SQLAlchemy

pip3 install SQLAlchemy

> python3

> import sqlalchemy

> sqlalchemy.__version__

Oracle DB:

python -m pip install cx_Oracle --upgrade

import sqlalchemy

from sqlalchemy import create_engine

from sqlalchemy import MetaData

from sqlalchemy import Table, Column, Integer, Numeric, String

from datetime import datetime

from sqlalchemy import DateTime

from sqlalchemy import insert

from sqlalchemy import select

from sqlalchemy import asc

from sqlalchemy import desc

# echo, encoding, isolation_level, pool_timeout

theEng = create_engine('sqlite:///:memory:')

theConn = theEng.connect()

theMeta = MetaData()

carsTable = Table('cars', theMeta,

Column('car_id', Integer(), primary_key=True),

Column('car_name', String(60), index=True, nullable=False),

Column('car_sku', String(30), unique=True),

Column('unit_cost', Numeric(12, 2)),

Column('create_date', DateTime(), default=datetime.now),

Column('update_date', DateTime(), default=datetime.now, onupdate=datetime.now)

)

theMeta.create_all(theEng)

.c.

selectStmt = select([carsTable.c.car_name, carsTable.c.unit_cost])

selectStmt.order_by(asc(...c...))

resultProxy = theConn.execute(selectStmt)

print(resultProxy.keys())

result = resultProxy.first()