UTC issue in database

[todriguez]

I have tried making sure the postgresql database settings are UTC and the settings.py but I am not sure what else to do.

recipme/recipe_api/myenv/lib/python3.11/site-packages/django/db/backends/postgresql/utils.py", line 6, in utc_tzinfo_factory
raise AssertionError("database connection isn't set to UTC")
AssertionError: database connection isn't set to UTC

[flackdl]

Well you're the first person to show interest in this! Let's roll up our sleeves and figure it out.

I believe this is an issue with the Postgres/python library called psycopg2-binary. Let me investigate and I'll get back with you.

[flackdl]

@todriguez I updated the python depdendencies to support python 3.11 as I can tell that's what you're using. I just had to upgrade Django & psycopg2 (the postgres client).

I tested it locally and it's working for me.

Let me know how it goes.

[flackdl]

Make sure you pull the updates and go through the steps again.

[todriguez]

I sorted it not long after I raised the issue. It did my head in for a while. I think I had to get the psycog binary instead. Now i've got it having scraped 4200 recipes, but when i spin up the webserver, though it looks nice, when i attempt to create a query it just flashes a response for a second then blank.

Failed to load resource: the server responded with a status of 500 (Internal Server Error)

[flackdl]

You're right. The query isn't working - I rushed the python 3.11 update and didn't test it end-to-end. Let me get it updated properly and i'll keep you posted.

In the meantime, see this demo and make sure it's what you're looking for in the 1st place.

https://recipes.eerieemu.com/
https://recipes.eerieemu.com/api/

[flackdl]

Ok I fixed it up so it works with python 3.11. I went down a bit of a rabbit hole.

This will get you a working, but empty, recipe application:

git clone git@github.com:flackdl/recipe_api.git
cd recipe_api/
docker-compose down -v
docker-compose up -d postgres
python3.11 -mvenv .env
. .env/bin/activate
pip install -r requirements.txt
python manage.py migrate   
python manage.py createcachetable 
DEBUG=1 python manage.py runserver

Or, you can load up a full set of recipes using this recipes.sql.gz dump. However, there won't be any images since those are static and collected by the "normal" way when scraping.

NOTE: db password is "postgres"

git clone git@github.com:flackdl/recipe_api.git
cd recipe_api/
docker-compose down -v
docker-compose up -d postgres
gunzip -c ~/Downloads/recipes.sql.gz | psql -hlocalhost -Upostgres
python3.11 -mvenv .env
. .env/bin/activate
pip install -r requirements.txt
DEBUG=1 python manage.py runserver

Otherwise, you can scrape everything manually to get all the images and understand a bit how it works. One thing to note, is that you need to finish the scrape command before any recipes will show up. The "save" part happens at the end where the records get into the database.

[flackdl]

@todriguez any luck?