Basic Tutorial for python-sql

Support Developer
1

I am startng python-sql today. Where are the basic guides which I ca use? Looking for fool-proof tutorial with example and output

2

There are many examples on the homepage: https://pypi.org/project/python-sql/

2 Likes
3

Thanks for the reply.

I M looking for these specific area.

  1. How to connect database?

  2. How to execute query to get result?

4

That is not part of python-sql. Check the documentation of the library you use to connect to your database. But python-sql is designed to work with PEP 249 complying library.

5

Thanks. Any pointer to python-sql + alchemy/psycopg2 documentation?

6

Well there is mainly no point to use python-sql with SQLAlchemy as they do mainly the same thing.
For psycopg2 the documentation is good enough: https://www.psycopg.org/docs/
You just pass the python-sql query to the cursor.execute method like this:

>>> cursor.execute(*table.select())