Example #1
0
def get_record_with_id(table, record_id):
    where_clause = '''WHERE %s=%s''' % (record.KEY_RECORD_ID, record_id)
    limit_clause = '''LIMIT 1'''
    data = record.query(table, where_clause, limit_clause = limit_clause)
    if data == None or len(data) == 0:
        return None
    return record.generate(data)
Example #2
0
def get_record_with_status(table, status):
    where_clause = '''WHERE %s=%s''' % (record.KEY_STATUS, status)
    order_clause = '''ORDER BY RAND()'''
    limit_clause = '''LIMIT 1'''
    data = record.query(table, where_clause, order_clause, limit_clause)
    print data
    if data == None or len(data) == 0:
        return None
    return record.generate(data[0])