def insert(self) -> 'Manager': if isinstance(self._entity, ReadOnlyEntity): return self sql_elements = self._entity.to_dict() sql_elements.__delitem__(self._entity.get_id_name()) sql = "insert into {} ({}) values ({})".format( self._entity.get_table_name(), ', '.join(sql_elements.keys()), ', '.join("'" + str(v) + "'" for v in sql_elements.values())) db_connect = UseDatabase(dbconfig) with db_connect as cursor: cursor.execute(sql) db_connect.commit() return self
def update(self) -> 'Manager': if isinstance(self._entity, ReadOnlyEntity): return self sql_elements = self._entity.to_dict() element_id = sql_elements[self._entity.get_id_name()] sql_elements.__delitem__(self._entity.get_id_name()) update_elements = [] for key, value in sql_elements.items(): update_elements.append("{} = '{}'".format(key, value)) query = "update {} set {} where {} = {:d}".format( self._entity.get_table_name(), ', '.join(update_elements), self._entity.get_id_name(), element_id) db_connect = UseDatabase(dbconfig) with db_connect as cursor: cursor.execute(query) db_connect.commit() return self