1 Python 2.7.3 (default, Apr 10 2012, 23:31:26) [MSC v.1500 32 bit (Intel)] on win32 2 Type "copyright", "credits" or "license()" for more information. 3 >>> from sqlalchemy import create_engine 4 >>> engine = create_engine('postgresql+psycopg2://openpg:openpgpwd@localhost:5432/testdb',echo=True) 5 >>> from sqlalchemy import Table,MetaData,Column,ForeignKey,Integer,String 6 >>> from sqlalchemy.orm import mapper 7 >>> metadata = MetaData() 8 >>> user = Table('user',metadata, 9 Column('id',Integer,primary_key=True), 10 Column('name',String(50)), 11 Column('fullname',String(50)), 12 Column('password',String(12))) 13 >>> metadata.create_all(engine) 14 2013-04-01 16:26:44,773 INFO sqlalchemy.engine.base.Engine select version() 15 2013-04-01 16:26:44,792 INFO sqlalchemy.engine.base.Engine {} 16 2013-04-01 16:26:44,796 INFO sqlalchemy.engine.base.Engine select current_schema() 17 2013-04-01 16:26:44,799 INFO sqlalchemy.engine.base.Engine {} 18 2013-04-01 16:26:44,802 INFO sqlalchemy.engine.base.Engine select relname from pg_class c join pg_namespace n on n.oid=c.relnamespace where n.nspname=current_schema() and relname=%(name)s 19 2013-04-01 16:26:44,805 INFO sqlalchemy.engine.base.Engine {'name': u'user'} 20 2013-04-01 16:26:44,808 INFO sqlalchemy.engine.base.Engine 21 CREATE TABLE "user" ( 22 id SERIAL NOT NULL, 23 name VARCHAR(50), 24 fullname VARCHAR(50), 25 password VARCHAR(12), 26 PRIMARY KEY (id) 27 ) 28 29 30 2013-04-01 16:26:44,812 INFO sqlalchemy.engine.base.Engine {} 31 2013-04-01 16:26:45,111 INFO sqlalchemy.engine.base.Engine COMMIT 32 >>> class User(object): 33 def __init__(self,name,fullname,password): 34 self.name = name 35 self.fullname = fullname 36 self.password = password 37 38 39 >>> mapper(User,user) 40 <Mapper at 0x2970f90; User> 41 >>> from sqlalchemy.orm import sessionmaker 42 >>> Session = sessionmaker(bind = engine) 43 >>> session = Session() 44 >>> ed_user = User('ed','Ed Jones','edpassword') 45 >>> session.add(ed_user) 46 >>> session.commit() 47 2013-04-01 16:27:44,516 INFO sqlalchemy.engine.base.Engine BEGIN (implicit) 48 2013-04-01 16:27:44,532 INFO sqlalchemy.engine.base.Engine INSERT INTO "user" (name, fullname, password) VALUES (%(name)s, %(fullname)s, %(password)s) RETURNING "user".id 49 2013-04-01 16:27:44,549 INFO sqlalchemy.engine.base.Engine {'fullname': 'Ed Jones', 'password': 'edpassword', 'name': 'ed'} 50 2013-04-01 16:27:44,568 INFO sqlalchemy.engine.base.Engine COMMIT