1 from sqlalchemy
import create_engine
2 from sqlalchemy
.orm
import sessionmaker
3 from table_def
import Map
11 self
.engine
= create_engine('sqlite:///rainbow.db', echo
=False)
13 def store(self
, tweet_id
):
14 Session
= sessionmaker(bind
=self
.engine
)
20 def rainbow_query(self
, rid
):
21 Session
= sessionmaker(bind
=self
.engine
)
23 res
= session
.query(Map
).filter("rainbow_id =:rid").params(rid
=rid
).all()
26 def tweet_query(self
, tid
):
27 Session
= sessionmaker(bind
=self
.engine
)
29 res
= session
.query(Map
).filter("tweet_id =:tid").params(tid
=tid
).all()