def update_gesture(sequence,name,comment,command): conn=db_connect() cur=conn.cursor() cur.execute("update gestures set comment='%s', command='%s',sequence='%s' where name='%s'"%(comment,command,sequence,name)) conn.commit()
def delete_gesture(field,value): conn=db_connect() cur=conn.cursor() cur.execute("delete from gestures where %s='%s'"%(field,value)) conn.commit()
def get_all_gestures(): conn=db_connect() cur=conn.cursor() cur.execute("select * from gestures") return cur.fetchall()
def add_gesture(sequence,name,comment,command): conn=db_connect() cur=conn.cursor() cur.execute("insert into gestures values('%s','%s','%s','%s')"%(name,comment,command,sequence)) conn.commit()
def search_gesture_by_field(field,value): conn=db_connect() cur=conn.cursor() cur.execute("select * from gestures where %s='%s'"%(field,value)) return cur.fetchall()