# I'm facing an issue when trying to execute the following code snippet using psycopg2 in place of create_engine. # Code snippet using create_engine (works fine): from sqlalchemy import create_engine import pandas as pd db_url = "your_database_url_here" engine = create_engine(db_url)…
i have a problem connecting to my postgres. It is running in my Docker properly but i am not able to connect via python to that container. Additionally i get no error message. "e" is empty. Any idea why it…
Sample from class: try: conn = psycopg2.connect( database='ytbstatsdb', host='127.0.0.1', user='admin', password='admin123', port='5432' ) except psycopg2.Error as e: print(e) cursor = conn.cursor() engine = sqlalchemy.create_engine('postgresql://admin:admin123@localhost:5432/ytbstatsdb') df_videos_details.to_sql('testtable', engine, if_exists='replace', index=False) Docker file (docker-compose.yaml): services: db: image: postgres ports: - 5432:5432 restart: always…
I have a python script that I built over the last 2 weeks using python3.10. The script did run fine 100s of times until I reinstalled python/modules. I recently upgraded to Python 3.12. I had to pip install all of…
I am trying to connect to a db instance, but my password has the following special characters: backslash, plus, dot, asterisk/star and at symbol. For example, [email protected]*90 (regex nightmare lol) How do I safe pass it to the connection string?…
I'm making a copy of an nft website for practice and I'm getting an error when transferring data from one table to another in my postgresql database using python. sender table: collection_stats receiving table: tbl_general_assets ` import psycopg2 db_config =…
I'm trying to create dataBase in Postgre SQL Python, i got an error: CREATE DATABASE cannot run inside a transaction block. I have read that u need autocommit, but i already have it. What's the problem try: with psycopg2.connect( host=host,…
Trying to do a shopping cart in telegram bot using psycopg2 and aiogram, but the data does not appear in the "korzina" column code: connection.cursor(f'INSERT INTO bot_users(korzina) VALUES({id_tovara}) FROM bot_user WHERE user_id= {us_id}') connection.commit() types of column's: user_id | bigint…
I am facing this issue when trying to run psycopg2, any one with solution would be helpful, thanx! Collecting psycopg2==2.8.6 (from -r requirements.txt (line 45)) Using cached psycopg2-2.8.6.tar.gz (383 kB) Preparing metadata (setup.py) ... error error: subprocess-exited-with-error × python setup.py…
Passing "SELECT"-based SQL queries works. But passing "DELETE"- or "GRANT"-based SQL executed in python without error but makes no change to my database (python 3.8, sqlalchemy 2.0.10). These "DELETE" and "GRANT" queries worked in Python 3.6, sqlalchemy 1.3.23. I could…