def res_import_types (self, sequence):
"""
imports resource type rows from @sequence into DB table;
"""
# truncate table
self.sql_query("DELETE FROM 'resource_types'")
# ensure plain list
if tools.is_plist(sequence):
# import many rows
self.cursor.executemany(
"INSERT OR IGNORE INTO 'resource_types' "
"VALUES (:type_key, :type_fk_parent, :type_name)",
sequence
)
# commit new transaction
self.commit()
def stb_import_shots (self, sequence):
"""
imports shot rows from @sequence into DB table;
"""
# truncate table
self.stb_clear_shots()
# ensure plain list
if tools.is_plist(sequence):
# import many rows
self.cursor.executemany(
"INSERT OR IGNORE INTO 'storyboard_shots' "
"VALUES (NULL, :shot_scene, :shot_shot, "
":shot_title, :shot_text)",
sequence
)
# commit new transaction
self.commit()
def res_import_items (self, sequence):
"""
imports resource item rows from @sequence into DB table;
"""
# truncate table
self.sql_query("DELETE FROM 'resource_items'")
# ensure plain list
if tools.is_plist(sequence):
# import many rows
self.cursor.executemany(
"INSERT OR IGNORE INTO 'resource_items' "
"VALUES (NULL, :item_fk_type, :item_name, :item_role, "
":item_contact, :item_phone, :item_email, :item_notes)",
sequence
)
# commit new transaction
self.commit()
def res_import_datebars (self, sequence):
"""
imports resource datebars rows from @sequence into DB
table;
"""
# truncate table
self.sql_query("DELETE FROM 'resource_datebars'")
# ensure plain list
if tools.is_plist(sequence):
# import many rows
self.cursor.executemany(
"INSERT OR IGNORE INTO 'resource_datebars' "
"VALUES (NULL, :datebar_fk_type, :datebar_tag, "
":datebar_status, :datebar_date_begin, "
":datebar_date_end)",
sequence
)
# commit new transaction
self.commit()
