Python 資料庫入門
Jason Myers
Co-Author of Essential SQLAlchemy and Software Engineer
MetaData
from sqlalchemy import create_engine, MetaData engine = create_engine('sqlite:///census_nyc.sqlite') metadata = MetaData()
from sqlalchemy import (Table, Column, String, Integer, Decimal, Boolean) employees = Table('employees', metadata, Column('id', Integer()), Column('name', String(255)), Column('salary', Decimal()), Column('active', Boolean())) metadata.create_all(engine)
from sqlalchemy import (Table, Column, String, Integer, Decimal, Boolean)
employees = Table('employees', metadata, Column('id', Integer()), Column('name', String(255)), Column('salary', Decimal()), Column('active', Boolean()))
metadata.create_all(engine)
Preparing Video For Download...
