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