def insert_group(grp_name, grp_type): sql = """ INSERT INTO myemsl.groups(name, type) VALUES (%(name)s, %(type)s); """ do_sql_insert(sql, True, myemsl_schema_versions=['1.0'], params={'name':str(grp_name), 'type':str(grp_type)})
def insert_subgroup(child_id, parent_id): sql = """ INSERT INTO myemsl.subgroups(child_id, parent_id) VALUES (%(child_id)s, %(parent_id)s); """ do_sql_insert(sql, True, myemsl_schema_versions=['1.0'], params={'child_id':str(child_id), 'parent_id':str(parent_id)})
def insert_item(item_type, cursor=None): sql = """ INSERT INTO myemsl.items(type) VALUES (%(type)s); """ if cursor: cursor.execute(sql, params={'type':item_type}) else: do_sql_insert(sql, False, myemsl_schema_versions=['1.3'], params={'type':item_type})