def find_cmsuser(id=None, username=None):
if id is not None:
return Session.query(CMSUser).get(id)
elif username is not None:
return Session.query(CMSUser).filter(CMSUser.username == username)\
.one()
else:
raise Exception("No id or username supplied. Go away.")
def list_news(**kargs):
q = Session.query(News)
if not session.get('cmsuser'):
q = q.filter(News.active == True) # noqa
q = q.order_by(News.created.desc())
num = q.count()
if 'limit' not in kargs:
q = q.limit(int(config['items_per_page']))
else:
if kargs.get('limit'):
q = q.limit(kargs.get('limit'))
if kargs.get('page'):
q = q.offset(_getOffset(kargs.get('page')))
return num, q
def find_news(id):
return Session.query(News).get(id)
def find_document(id):
return Session.query(Document).get(id)
def find_image(id):
return Session.query(Image).get(id)
def listImages():
q = Session.query(Image).order_by(Image.filename)
return q.count(), q
def listDocuments():
q = Session.query(Document).order_by(Document.filename)
return q.count(), q
def listCMSUsers():
q = Session.query(CMSUser).order_by(CMSUser.fullname)
return q.count(), q