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