If you comment there, with sufficient details I can try to reproduce it. On Thu, 14 Jan 2021 at 14:59, Skyler Cain <skylerc...@gmail.com> wrote:
> Should I add a comment to the closed Django issue? > > On Tuesday, January 12, 2021 at 11:54:53 PM UTC-7 carlton...@gmail.com > wrote: > >> OK, this was reported as https://code.djangoproject.com/ticket/31765, >> something* to do with macOS's bundled SQLite. >> * technical term. >> >> There's a workaround in master — >> https://github.com/django/django/commit/80a8be03d9321669a239dbced8ac48a4ebbbb7e1 >> >> I assume you're running against that, so can you perhaps comment on the >> issue with your `platform.mac_ver()` and we can have a look. >> >> Thanks! >> >> On Tuesday, 12 January 2021 at 20:13:28 UTC+1 skyle...@gmail.com wrote: >> >>> I got 'testing' returned. With that command I'm getting: >>> >>> (django-2) skylercain:~/code/django [master]$ python -c "import sqlite3; >>> print(sqlite3.sqlite_version)" >>> 3.32.3 >>> >>> Should I try an earlier version? >>> >>> On Tue, Jan 12, 2021 at 10:43 AM Carlton Gibson <carlton...@gmail.com> >>> wrote: >>> >>>> > I ran your code to set and test the DYLD_LIBRARY_PATH and the first >>>> example worked for me. >>>> >>>> Did it give None or ‘testing’ — only if the latter is the environment >>>> variable reaching the Python process. (So only they can you override the >>>> default version) >>>> >>>> ~ $ python -c "import sqlite3; print(sqlite3.sqlite_version)" >>>> 3.32.3 >>>> >>>> Minimum version is currently 3.8.3 >>>> https://docs.djangoproject.com/en/3.1/ref/databases/#sqlite-notes >>>> >>>> >>>> On Tue, 12 Jan 2021 at 18:27, Skyler Cain <skyle...@gmail.com> wrote: >>>> >>>>> I ran the code to ensure that JSON1 extension is working within >>>>> sqlite3. Can I check which version I need -- is that somewhere? Also if >>>>> the >>>>> JSON1 extension is working what other functionality do I need to check >>>>> for? >>>>> >>>>> I was not using a customly installed version of python -- which I've >>>>> now switched to. However I'm still getting the same error message. I ran >>>>> your code to set and test the DYLD_LIBRARY_PATH and the first example >>>>> worked for me. >>>>> >>>>> Thanks for your help I'd like to get everything working if possible >>>>> then move on to PostgreSQL. >>>>> >>>>> On Tue, Jan 12, 2021 at 9:13 AM Carlton Gibson <carlton...@gmail.com> >>>>> wrote: >>>>> >>>>>> Hi Skyler. >>>>>> >>>>>> Welcome. >>>>>> >>>>>> That’ll be your SQLite version. >>>>>> >>>>>> MacOS tends to bundle an old one — and updating can be a little >>>>>> tricky because of the “System integrity protection”, not letting you >>>>>> specify a DYLD_LIBRARY_PATH. >>>>>> >>>>>> See the instructions here for getting a newer SQLite version: >>>>>> >>>>>> https://code.djangoproject.com/wiki/JSON1Extension >>>>>> >>>>>> It might not work because of SIP. >>>>>> >>>>>> Try this: >>>>>> >>>>>> ~ $ DYLD_LIBRARY_PATH="testing" python -c "import os; >>>>>> print(os.getenv('DYLD_LIBRARY_PATH'))" >>>>>> None >>>>>> >>>>>> If you get that your Python is running via SIP. You’ll need to >>>>>> install Python in your home folder somewhere. >>>>>> >>>>>> I use pyenv but the shims that use still go view /bin/env, so SIP is >>>>>> in play. >>>>>> >>>>>> You have to do this kind of thing: >>>>>> >>>>>> ~ $ DYLD_LIBRARY_PATH="testing" $(pyenv which python) -c "import os; >>>>>> print(os.getenv('DYLD_LIBRARY_PATH'))" >>>>>> testing >>>>>> >>>>>> Hopefully that makes sense and helps. If not reply and I’ll see if I >>>>>> can help some more. >>>>>> >>>>>> You can always ignore the failure, or use Postgres: >>>>>> https://postgresapp.com is a very easy to get going with. >>>>>> >>>>>> Kind regards, Carlton >>>>>> >>>>>> On Tue, 12 Jan 2021 at 16:50, Skyler Cain <skyle...@gmail.com> wrote: >>>>>> >>>>>>> Hello all! >>>>>>> >>>>>>> I've read this: >>>>>>> https://docs.djangoproject.com/en/3.1/intro/contributing/ >>>>>>> >>>>>>> But after running my tests I get the following failure (when running >>>>>>> all or individual). Any thoughts / suggestions would be much >>>>>>> appreciated. >>>>>>> >>>>>>> (django) skylercain:~/code/django/tests [master]$ ./runtests.py >>>>>>> schema.tests.SchemaTests.test_db_table >>>>>>> Testing against Django installed in >>>>>>> '/Users/skylercain/code/django/django' >>>>>>> Creating test database for alias 'default'... >>>>>>> System check identified no issues (0 silenced). >>>>>>> F >>>>>>> >>>>>>> ====================================================================== >>>>>>> FAIL: test_db_table (schema.tests.SchemaTests) >>>>>>> Tests renaming of the table >>>>>>> >>>>>>> ---------------------------------------------------------------------- >>>>>>> Traceback (most recent call last): >>>>>>> File "/Users/skylercain/code/django/django/test/utils.py", line >>>>>>> 382, in inner >>>>>>> return func(*args, **kwargs) >>>>>>> File "/Users/skylercain/code/django/tests/schema/tests.py", line >>>>>>> 2339, in test_db_table >>>>>>> self.assertForeignKeyExists(Book, "author_id", >>>>>>> "schema_otherauthor") >>>>>>> File "/Users/skylercain/code/django/tests/schema/tests.py", line >>>>>>> 213, in assertForeignKeyExists >>>>>>> self.assertEqual(constraint_fk, (expected_fk_table, field)) >>>>>>> AssertionError: Tuples differ: ('schema_author', 'id') != >>>>>>> ('schema_otherauthor', 'id') >>>>>>> >>>>>>> First differing element 0: >>>>>>> 'schema_author' >>>>>>> 'schema_otherauthor' >>>>>>> >>>>>>> - ('schema_author', 'id') >>>>>>> + ('schema_otherauthor', 'id') >>>>>>> ? +++++ >>>>>>> >>>>>>> >>>>>>> >>>>>>> ---------------------------------------------------------------------- >>>>>>> Ran 1 test in 0.015s >>>>>>> >>>>>>> FAILED (failures=1) >>>>>>> Destroying test database for alias 'default'... >>>>>>> >>>>>>> -- >>>>>>> You received this message because you are subscribed to the Google >>>>>>> Groups "Django developers (Contributions to Django itself)" group. >>>>>>> To unsubscribe from this group and stop receiving emails from it, >>>>>>> send an email to django-develop...@googlegroups.com. >>>>>>> To view this discussion on the web visit >>>>>>> https://groups.google.com/d/msgid/django-developers/75e140c4-facf-456f-8605-80a72662cf03n%40googlegroups.com >>>>>>> <https://groups.google.com/d/msgid/django-developers/75e140c4-facf-456f-8605-80a72662cf03n%40googlegroups.com?utm_medium=email&utm_source=footer> >>>>>>> . >>>>>>> >>>>>> -- >>>>>> >>>>> You received this message because you are subscribed to a topic in the >>>>>> Google Groups "Django developers (Contributions to Django itself)" group. >>>>>> To unsubscribe from this topic, visit >>>>>> https://groups.google.com/d/topic/django-developers/TvGYJyj-ouo/unsubscribe >>>>>> . >>>>>> To unsubscribe from this group and all its topics, send an email to >>>>>> django-develop...@googlegroups.com. >>>>>> To view this discussion on the web visit >>>>>> https://groups.google.com/d/msgid/django-developers/CAJwKpyQh32UYkxAHma-wRY3WhY36oiuWjhmLCGLm4%2BxGHAgvRQ%40mail.gmail.com >>>>>> <https://groups.google.com/d/msgid/django-developers/CAJwKpyQh32UYkxAHma-wRY3WhY36oiuWjhmLCGLm4%2BxGHAgvRQ%40mail.gmail.com?utm_medium=email&utm_source=footer> >>>>>> . >>>>>> >>>>> -- >>>>> You received this message because you are subscribed to the Google >>>>> Groups "Django developers (Contributions to Django itself)" group. >>>>> To unsubscribe from this group and stop receiving emails from it, send >>>>> an email to django-develop...@googlegroups.com. >>>>> To view this discussion on the web visit >>>>> https://groups.google.com/d/msgid/django-developers/CAAWGEHxvzJgepJjMuhUi7KeD4j-1vWqnuZvqSwpCwjoV83zG4Q%40mail.gmail.com >>>>> <https://groups.google.com/d/msgid/django-developers/CAAWGEHxvzJgepJjMuhUi7KeD4j-1vWqnuZvqSwpCwjoV83zG4Q%40mail.gmail.com?utm_medium=email&utm_source=footer> >>>>> . >>>>> >>>> -- >>>> You received this message because you are subscribed to a topic in the >>>> Google Groups "Django developers (Contributions to Django itself)" group. >>>> To unsubscribe from this topic, visit >>>> https://groups.google.com/d/topic/django-developers/TvGYJyj-ouo/unsubscribe >>>> . >>>> To unsubscribe from this group and all its topics, send an email to >>>> django-develop...@googlegroups.com. >>>> >>> To view this discussion on the web visit >>>> https://groups.google.com/d/msgid/django-developers/CAJwKpySoXa8aXD-s6hNZ7u7wmgXAAuSF3agF97jv9dX-TsmFmw%40mail.gmail.com >>>> <https://groups.google.com/d/msgid/django-developers/CAJwKpySoXa8aXD-s6hNZ7u7wmgXAAuSF3agF97jv9dX-TsmFmw%40mail.gmail.com?utm_medium=email&utm_source=footer> >>>> . >>>> >>> -- > You received this message because you are subscribed to the Google Groups > "Django developers (Contributions to Django itself)" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to django-developers+unsubscr...@googlegroups.com. > To view this discussion on the web visit > https://groups.google.com/d/msgid/django-developers/0b45a0b6-444a-476e-804a-88110eac0f83n%40googlegroups.com > <https://groups.google.com/d/msgid/django-developers/0b45a0b6-444a-476e-804a-88110eac0f83n%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- You received this message because you are subscribed to the Google Groups "Django developers (Contributions to Django itself)" group. To unsubscribe from this group and stop receiving emails from it, send an email to django-developers+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/django-developers/CAJwKpySujWd6hC%2B9w-cM2C3cO092Gv0T1SNjNqjJn0VE%2Bw273g%40mail.gmail.com.
