def index(self, search = None):
if search:
q = quotes.select().order_by('id').where('body LIKE "%{0}%"'.format(search))
else:
q = quotes.select().order_by('id')
rs = q.execute()
rows = rs.fetchall()
to_ret = []
for r in rows:
to_ret.append((r[0], linkify(r[1])))
template = env.get_template("search.jinja2")
return template.render(results=to_ret)
def index(self, search=None):
if search:
q = quotes.select().order_by('id').where(
'body LIKE "%{0}%"'.format(search))
else:
q = quotes.select().order_by('id')
rs = q.execute()
rows = rs.fetchall()
to_ret = []
for r in rows:
to_ret.append((r[0], linkify(r[1])))
template = env.get_template("search.jinja2")
return template.render(results=to_ret)
def get_by_id(self, quoteId):
q = quotes.select().where('id=' + str(quoteId))
rs = q.execute()
row = rs.fetchone()
return row
def search(self, message):
q = quotes.select().order_by('id').where('body LIKE "%{0}%"'.format(message))
rs = q.execute()
rows = rs.fetchall()
return rows
def get_random(self):
q = quotes.select(limit=1).order_by('RANDOM()')
rs = q.execute()
row = rs.fetchone()
return row
def get_by_id(self, quoteId):
q = quotes.select().where("id=" + str(quoteId))
rs = q.execute()
row = rs.fetchone()
return row
def search(self, message):
q = quotes.select().order_by("id").where('body LIKE "%{0}%"'.format(message))
rs = q.execute()
rows = rs.fetchall()
return rows
def get_random(self):
q = quotes.select(limit=1).order_by("RANDOM()")
rs = q.execute()
row = rs.fetchone()
return row
def search(self, message):
print "Search string: "+ message
q = quotes.select().order_by('id').where('body LIKE "%'+message+'%"')
rs = q.execute()
rows = rs.fetchall()
return rows
