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
