def get(uid=None, limit=60, offset=0, maxlines=None, colored=None, scene=None, name=None):
q = db.session.query(AsciiModel)
if uid and isinstance(uid, int):
result = q.filter(AsciiModel.id == uid).first()
if result:
result.html = AsciiController.irc_to_html(result.path)
return [result]
if maxlines and isinstance(maxlines, int):
q = q.filter(AsciiModel.numlines <= maxlines)
if name and isinstance(name, str):
name = name.replace("%", "")
name = name.replace("_", "")
q = q.filter(func.lower(AsciiModel.name).like("%"+name+"%"))
if isinstance(colored, bool):
q = q.filter(AsciiModel.colored == colored)
if isinstance(scene, bool):
q = q.filter(AsciiModel.scene == scene)
if offset and isinstance(offset, int):
q = q.offset(offset)
if limit and isinstance(limit, int):
q = q.limit(limit)
results = q.all()
rtn = []
for result in results:
result.html = AsciiController.irc_to_html(result.path)
rtn.append(result)
return rtn
评论列表
文章目录