Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #!/usr/bin/env python
- import sqlalchemy
- from sqlalchemy import create_engine,\
- Table, Column, Integer, String, MetaData, ForeignKey
- from sqlalchemy.orm import sessionmaker
- from sqlalchemy.ext.declarative import declarative_base
- engine = create_engine('sqlite:///places.sqlite')
- Session = sessionmaker(bind=engine)
- metadata = MetaData(engine)
- Base = declarative_base()
- moz_bookmarks = Table('moz_bookmarks', metadata,
- # Column('id', Integer(), primary_key=True, nullable=False),
- autoload=True)
- class MozBookmarks(Base):
- __table__ = moz_bookmarks
- for bookmark in Session().query(MozBookmarks)\
- .filter(MozBookmarks.id == 903):
- print bookmark, bookmark.title, bookmark.__dict__
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement