使用python向数据库插入数据时候,写原生sql是很痛苦的。。。
使用sqlalchemy, 一能兼容多种数据库,二来insert很简单。
create_table.py
from sqlalchemy import create_engine
from sqlalchemy import Table, Column, Integer, String, MetaData, ForeignKey
# dialect+driver://username:password@host:port/database
# sqlite: 'sqlite:///foo.db'
# sqlite_mem: 'sqlite://'
# mysql: 'mysql+pymysql://scott:tiger@localhost/foo'
engine = create_engine('postgresql+psycopg2://postgres:hua123@localhost:5432/test')
metadata = MetaData()
user = Table(