コード例 #1
0
def update(entry, ktable):
    
    params = ''
    for col in ktable.columns:
        value = escapeSql(getattr(entry, col.name))
        params += col.name + '=\'' + value + '\', '
    params = params[:-2]
    
    sql = "UPDATE %s SET %s WHERE id = ?" % (ktable.name,
                                             params)
    cursor = conn.cursor()
    cursor.execute(sql, (entry.id, ))
    
    """
    Update values in the kindex table too    
    First, remove index entries associated with this entry 
    """
    cursor.execute('DELETE FROM kindex WHERE ktable_id = ? AND row_id = ?', (ktable.id, entry.id))
    """
    Then insert new values in the kindex table     
    """
    for col in ktable.columns:
        value = escapeSql(getattr(entry, col.name))
        sql = 'INSERT INTO kindex(ktable_id, row_id, contents) VALUES(?, ?, ?)' 
        cursor.execute(sql, (ktable.id, entry.id, value))
    
    conn.commit()
コード例 #2
0
def add(entry, ktable):
    
    entryColumns = ''
    entryValues = ''
    for col in ktable.columns:
        entryColumns += col.name + ', '
        value = escapeSql(getattr(entry, col.name))
        entryValues += '\'' + value + '\', '
    #remove last ', ' from both strings
    entryColumns = entryColumns[:-2]
    entryValues = entryValues[:-2]
    
    sql = 'INSERT INTO %s(%s) VALUES(%s)' % (ktable.name,
                                             entryColumns,
                                             entryValues)
    cursor = conn.cursor()
    cursor.execute(sql)
    entry.id=cursor.lastrowid
    
    """
    Insert values in the kindex table too    
    """
    for col in ktable.columns:
        value = escapeSql(getattr(entry, col.name))
        sql = 'INSERT INTO kindex(ktable_id, row_id, contents) VALUES(?, ?, ?)' 
        cursor.execute(sql, (ktable.id, entry.id, value))
    
    conn.commit()
コード例 #3
0
def indexTable(ktable, readCursor, writeCursor):
    
    
    rs = readCursor.execute('SELECT * FROM %s' % (ktable.name, ))
    while True:
        row = rs.fetchone()
        if row is None:
            break
        rowId = row[0]
        for i in range(1, len(row)):
            if row[i]:
                sql = 'INSERT INTO kindex(ktable_id, row_id, contents) VALUES(%d, %d, \'%s\')' % (ktable.id, rowId, escapeSql(row[i]))
                writeCursor.execute(sql)