I am working on a project with Django, Postgres. I typed that: When I type that: I got that: Then if I type that: I got that: Whereas the field name exists. Models.py: Answer M2M relationship means – you have many objects. user.food.name get attrbute name from M2M manager. Probably you mean user.food.al…
Tag: postgresql
Pydantic created at and updated at fields
I’m new to using Pydantic and I’m using it to set up the models for FastAPI to integrate with my postgres database. I want to make a model that has an updated_at and created_at field which store the last datetime the model was updated and the datetime the model was created. I figured created_at co…
Django query for column value search?
What is the Django query for this? DB data – I only need record that contain “1.2.3” values not like – (“Cat 1.2.3” or “1.2.3-XY2” or any such value). And pattern “1.2.3” can be anywhere in column where column value can have comma separated values to…
Python re.findall regex and text processing
I’m looking to find and modify some sql syntax around the convert function. I want basically any convert(A,B) or CONVERT(A,B) in all my files to be selected and converted to B::A. So far I tried selecting them with re.findall(r”bconvertb(.*?,.*)”, l, re.IGNORECASE) But it’s only return…
SQLAlchemy bulk insert statement in Postgres database throws AttributeError
I am trying to insert rows in Python SQLAlchemy by bulk into a Postgres database by using an insert statement. I need to use the insert statement instead of bulk_insert_mappings, as I want to silently ignore failed insertion of duplicate entries. This was not apparent before, but I have added it now. The tabl…
Django csv upload to db works but throws error
I have created an app named customer within a project named Website using django. I have created a csv upload in the admin area which is connected to the Postgres db. However the CSV file is still added to the db but the error screen is displayed. Even more strangely if I a notepad doc as csv containing the d…
Can’t connect to my Docker Postgres from python suddenly
I’ve been trying to configure my m1 to work with an older ruby on rails api and I think in the process I’ve broken my ability to connect any of my python apis to their database images in docker running locally. When I run: Instead of the lovely psql blinking cursor allowing me to run any sql state…
Postgredb in conda environment or keep standalone
I am looking for some guidance. I have Anaconda installed to manage my python packages and environments. I see that you can install postgres in the package manager. Am I best to install postgres in the conda environment or install standalone. I am on Windows. I see that if I install postgres separately I get …
How to use data from postgresql in django?
I have switched from sqlite to postgresql following Django: What are the best practices to migrate a project from sqlite to PostgreSQL the fourth answer. Here are my updated settings: However, I cannot seem to find/grab any of the data from my database. Here’s some example data from the database: The mi…
Python and PostGres | Showing data in a QLabel (psycopg2)
im using Postgres together with python(psycopg2). Im trying to insert data in a QLabel. It shows the data, but the data comes with clinges. How do I get rid of the clinges? My code: This is what I get out of it: I want it to just show 12 Answer Per here Cursor: Note cursor objects are iterable, so, instead