Skip to content

Instantly share code, notes, and snippets.

@anxiousmodernman
Created May 5, 2014 16:15
Show Gist options
  • Save anxiousmodernman/11541093 to your computer and use it in GitHub Desktop.
Save anxiousmodernman/11541093 to your computer and use it in GitHub Desktop.
make Query classes?
def fetch_main_briefs():
"""Fetch list of dict result set from alchemy database"""
q = session.query(BriefTable.briefid,
BriefTable.brief_name,
BriefTable.activestatus)
q = q.filter(BriefTable.parentid == None) # todo abstract this out into a clauses list to prevent duplication
q = q.filter(or_(BriefTable.briefName_alias == '', BriefTable.briefName_alias == None))
result_set = [result.__dict__ for result in q.all()]
return result_set
def fetch_brief_tags():
q = session.query(BriefTable.briefid,
BriefTagsTable.tag_name)
q = q.filter(BriefTable.parentid == None)
q = q.filter(or_(BriefTable.briefName_alias == '', BriefTable.briefName_alias == None))
q = q.filter(BriefTable.briefid == LinkBriefTagTable.briefid) \
.filter(LinkBriefTagTable.tagid == BriefTagsTable.tagid)
result_set = [result.__dict__ for result in q.all()]
return result_set
@anxiousmodernman
Copy link
Author

Could I write a class such that I could do

q = MainBriefQuery()
result_set = q.execute()

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment