I have created a model with the ArrayField in Django Model. I am using PostgreSQL for the database. I want to create new rows in the database or update the existing rows. But I can not insert or append data to the ArrayField. Model View The time field does not being created or updated with the new value. How …
Tag: postgresql
How to fix IntegrityError: (psycopg2.errors.ForeignKeyViolation) update or delete on table “users” violates foreign key constraint
I have two tables created with Flask-SQLAlchemy below – they have a one to one relationship. I would like to update the user table in a case when the user would like to have a new username: The db.session.commit throws the following error: The error says the logo table still has the old username but I h…
How to add PostGIS SQL SELECT query as layer to QGIS 3 project using Python console?
I want to add a PostGIS SELECT query as a new layer to a QGIS 3 project using the Python console. It is a simple process to do this using the SQL Window in the DB Manager of QGIS. Here you can create a layer from any SQL query of a PostGIS enabled PostgreSQL database. The following works for adding
Trying to supply PGPASS to Docker Image
New to Docker here. I’m trying to create a basic Dockerfile where I run a python script that runs some queries in postgres through psycopg2. I currently have a pgpass file setup in my environment variables so that I can run these tools without supplying a password in the code. I’m trying to replic…
PostgreSQL NOT operator in SQLAlchemy
I’d like to achieve toggling a boolean flag with just one query. My query looks as follows: Does SQLAlchemy supports PostgreSQL NOT (https://www.postgresql.org/docs/current/functions-logical.html) operator. How this can be achieved different way? Answer As Adrian Klaver points out in their comment, SQLA…
AWS Aurora: bulk upsert of records using pre-formed SQL Statements
Is there a way of doing a batch insert/update of records into AWS Aurora using “pre-formed” Postgresql statements, using Python? My scenario: I have an AWS lambda that receives data changes (insert/modify/remove) from DynamoDB via Kinesis, which then needs to apply them to an instance of Postgres …
Error installing cloud-sql-python-connector[pg8000] in Python 3.7
I am trying to connect to a Cloud SQL postgresql instance through python 3.7 from my local machine. I am following the guide from the README cloud-sql-python-connector. There it says to pip install the necessary module with the following command, for a postgresql instance: But when I run this in my terminal, …
How to execute multiple sql files in airflow using PostgresOperator?
I have multiple sql files in my sql folder. I am not sure how to execute all the sql files within a DAG? For a single file, below code works Answer With a list Or you can make it dynamic
DateTime format in python from Postgres queries
I have a below result from postgres query performing in python. How can parse or format so I get date along with time only ? Answer Problem is solved by using result[0][0] in pyhton code
What should I use to enter data to my database on Django? Django admin or SQL code?
I am a newbie in programming, but now I connected my project with PostgreSQL. I learned the way to enter by SQL code and also found out that we can actually enter /adming (by creating the superuser and add data there). So which one is widely used in webdev? Answer It will depend completely on your application…