#!/usr/bin/env python ''' copy.py - copy utts column to utts_orig column. ''' import sys from datastore.sqlite import sqlite TARGET_DIR = sys.argv[1] db = sqlite(TARGET_DIR + '/data.db') update_st = 'UPDATE utterances SET {0}_utts = {0}_utts_orig' # update_st = 'UPDATE utterances SET {0}_utts_orig = {0}_utts' for speaker in ['p', 'c']: db.execute(update_st.format(speaker)) db.commit()
from datastore.sqlite import sqlite db = sqlite("temp.db") column = "c_utts" pattern = r".*\d" select_st = 'select id, {0} from utterances where {0} regexp "{1}";' db.execute(select_st.format(column, pattern)) for id, utt in db: print utt