Python DB.insert_id Examples

Example #1

def _key_by_table(db, table, cursor):
    db = db._config
    db_table = '%s@%s:%s.%s' % (db['user'], db['host'], db['port'], table)

    key = [db_table]

    if cursor.description:
        for i in cursor.description:
            key.append('%s:%s' % (i[0], i[1]))

    key = ' '.join(key)
    keyd = md5(key).digest()
    mckey = DB.fetch0('SELECT id FROM ZwebOrmTableMcKey where `md5`=%s', keyd)
    if not mckey:
        id = DB.insert_id('ZwebOrmTableMcKey',
                          md5=keyd,
                          database=db['db'],
                          time=int(time()))
        mckey = MC_KEYER.encode(id)
    return str(mckey)

Example #2

File: model.py Project: PegasusWang/collection_python

def _key_by_table(db, table, cursor):
    db = db._config
    db_table = '%s@%s:%s.%s'%(db['user'], db['host'], db['port'] , table)

    key = [ db_table ]

    if cursor.description:
        for i in cursor.description:
            key.append('%s:%s'%(i[0], i[1]))

    key = ' '.join(key)
    keyd = md5(key).digest()
    mckey = DB.fetch0('SELECT id FROM ZwebOrmTableMcKey where `md5`=%s', keyd)
    if not mckey:
        id = DB.insert_id(
            'ZwebOrmTableMcKey',
            md5=keyd,
            database=db['db'],
            time=int(time())
        )
        mckey = MC_KEYER.encode(id)
    return str(mckey)