I have a Postgres database running in a Docker container and a Python application running in another Docker container. When I try to connect to the Postgres database from the Python app using SQLAlchemy, I get the following error: sqlalchemy.exc.OperationalError:…
I am trying to add a new row to my table enjordplatform_keywords but everytime I do that it instead tries to add the row in the middle of the table. Usually that id that it is trying to insert it…
I have a users table, with the primary key being an id field, which is an autoincrementing integer. I don't have a username field right now, but I would like to add one. Now, the username should be UNIQUE and…
Confused. Trying to build a scraper of UK news in python. import feedparser import pandas as pd def poll_rss(rss_url): feed = feedparser.parse(rss_url) for entry in feed.entries: print("Title:", entry.title) print("Description:", entry.description) print("n") def poll_rss(rss_url): feed = feedparser.parse(rss_url) for entry in feed.entries:…
i'm quite new to postgressql, so i have a table called public.dim_products with a column called weight_kg what i would like to do is given some weight in the weight ranges below to set up a new column called weight_class…
I'm using SQLAlchemy 1.4 to build my database models (posgresql). I've stablished relationships between my models, which I follow using the different SQLAlchemy capabilities. When doing so, the fields of the related models get aliases which don't work for me.…
I have the following line of code that keeps giving me an error that Engine object has no object execute. I think I have everything right but no idea what keeps happening. It seemed others had this issue and restarting…
I applied over a postgres USER table and unique contraint over email. The problem that I am facing now is that the constraint seems to register each value I insert (or try to insert) no matter if a record with…
self.engine=create_engine("postgresql://postgres:12345@localhost/postgres") self.con = self.engine.connect() self.conn.autocommit = True self.cursor = self.conn.cursor() df.to_sql(symbol, schema='xxx', con=self.con, if_exists='append', index=False) df.to_sql(symbol, con=self.con, if_exists='append', index=False) I am getting this error in both cases while adding the dataframe to the postgre sql database meta = MetaData(self.connectable, schema=schema)…
I have a table needs to be partitioned, but since the postgresql_partition_by wasn't added while the creation of the table so am trying to: create a new partitioned table that is similar the origin one. moving the data from the…