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()
