Python get_cursor Examples

Example #1

File: directory_log.py Project: frs24/shell

def log_to_db():
    'Creates a db in memory with a table to save flights information'
    file = get_db_path()
    check_db_exists(file)
    cursor = get_cursor(file)

    current = "'" + environ['PWD'] + "'"
    query = '''INSERT OR IGNORE INTO dircounts(path,count, time) VALUES (%s,1, DATETIME('NOW'));
               UPDATE dircounts SET count = count + 1, time = DATETIME('NOW') WHERE path like %s;''' % (current, current)

    cursor.executescript(query)

Example #2

File: directory_frequency.py Project: frs24/shell

def directory():
    file = get_db_path()
    check_db_exists(file)
    cursor = get_cursor(file)
    print_paths(cursor, '''SELECT path FROM dircounts ORDER BY count DESC LIMIT 7''')

Example #3

File: directory_damp.py Project: frs24/shell

def damp_db():
    file = get_db_path()
    check_db_exists(file)
    cursor = get_cursor(file)
    cursor.execute('UPDATE dircounts SET count = count / 2')