Voir Notes Python DB - ORM - DAL

Core & ORM :

• https://www.youtube.com/watch?v=0PSdzUxRYpA

Voir ORM :

• https://www.youtube.com/watch?v=PTZiDnuC86g

Lib :

• https://github.com/dahlia/awesome-sqlalchemy

RestApi pour DB SqlAlchemy :

• https://github.com/jeffknupp/sandman2

Notes SQLAlchemy Core

#import urllib.parse
import sqlalchemy
from sqlalchemy import create_engine, text
 
engine = create_engine('sqlite:////home/jean/tmp/test-sqlite.db')
 
# Exemple de SQL
sql = text('SELECT * FROM contacts;')
 
with engine.connect() as con:
	result = con.execute(sql)
 
print(result.all())
result.close()
 
 
# Exemple de code SQL
conn = engine.connect()
result = conn.execute(text("SELECT * FROM contacts"))
for row in result:
	print(row)
 
# Exemple de Select
from sqlalchemy import select
stmt = select(User).where(User.name == "spongebob")
 
 
# Introspection import Table
metadata=MetaData()
with engine.connect() as conn:
    table_contacts_reflected==Table("contacts", metadata, autoload_with=conn)
 
print(table_contacts.c)
print(table_contacts.primary_key)
 
 
# Champs descriptions
conn = engine.connect()
result = conn.execute(text("SELECT * FROM contacts"))
cursor=result.cursor
print(';'.join([ x[0] for x in cursor.description]))

Voir :

• https://dataset.readthedocs.io/en/latest/
• Using pandas and Python to Explore Your Dataset

Dataset: databases for lazy people

import dataset
 
db = dataset.connect('sqlite:///:memory:')
 
table = db['sometable']
table.insert(dict(name='John Doe', age=37))
table.insert(dict(name='Jane Doe', age=34, gender='female'))
 
john = table.find_one(name='John Doe')