Error message- postgres db connection- says argument 1 should be psycopg2 object?

Question

Don't really know how this can be wrong because I'm literally copying along with a coding video but here we are. Says the first arg must be a psycopg2.extension.connection instead of a string?? its not on the documentation nor the guide.

  try:   
        conn = psycopg2.connect(dbname= 'fastapi', host= 'localhost' , port= 5432 , user = 'postgres', password= 'ninjagaiden',connection_factory= RealDictCursor )
        cur = conn.cursor()
        print('database connection succesful')
    except Exception as error :
        print("connection failed")
        print("error explanation:", error)

Why not to use SQLAlchemy tho, FastAPI shows it as an example db library in their documentation. — sudden_appearance
– sudden_appearance, Commented Feb 3, 2022 at 20:25
@sudden_appearance im following a tutorial on building my first rest API — C A OB1
– C A OB1, Commented Feb 4, 2022 at 10:31

sudden_appearance · Accepted Answer · 2022-02-03 20:23:29Z

1

...connection_factory=RealDictCursor) is the part causing problem Your code should look something like this

try:   
    conn = psycopg2.connect(dbname= 'fastapi', host='localhost', port=5432, user='postgres', password='ninjagaiden')
    cur = conn.cursor(cursor_factory=RealDictCursor)
    print('database connection succesful')
except Exception as error:
    print("connection failed")
    print("error explanation:", error)

P.S. Please try watching after where you put spaces.

answered Feb 3, 2022 at 20:23

sudden_appearance

2,2131 gold badge6 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

C A OB1 Over a year ago

still fails, it seems the connection factory setting is the reason.

Collectives™ on Stack Overflow

Error message- postgres db connection- says argument 1 should be psycopg2 object?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related