def insert(cls, instance): with CursorPool() as cursor: logger.debug(cursor.mogrify(cls.__INSERT)) logger.debug(f'instance to insert: {instance}') values = (instance.getQID(), instance.getItemLabel()) cursor.execute(cls.__INSERT, values) return cursor.rowcount
def insert(cls, subClass): with CursorPool() as cursor: logger.debug(cursor.mogrify(cls.__INSERT)) logger.debug(f'subClass to insert: {subClass}') values = (subClass.getQID(), subClass.getItemLabel()) cursor.execute(cls.__INSERT, values) return cursor.rowcount
def createJson(cls): with CursorPool() as cursor: logger.debug(cursor.mogrify(cls.__GENERATE_JSON)) cursor.execute(cls.__GENERATE_JSON) result = cursor.fetchone() result = str(result).replace("(", "") result = str(result).replace(")", "") return result
def updateCopy(cls, instance): with CursorPool() as cursor: logger.debug(cursor.mogrify(cls.__UPDATE_COPY)) logger.debug(f'instance to update: {instance.getQID()}') values = (instance.getDescription(), instance.getAlias(), instance.getStatements(), instance.getQID()) cursor.execute(cls.__UPDATE_COPY, values) return cursor.rowcount
def select(cls): with CursorPool() as cursor: logger.debug(cursor.mogrify(cls.__SELECT)) cursor.execute(cls.__SELECT) results = cursor.fetchall() subClasses = [] for result in results: subClass = Subclass(result[0], result[1]) subClasses.append(subClass) return subClasses
def select(cls): with CursorPool() as cursor: logger.debug(cursor.mogrify(cls.__SELECT)) cursor.execute(cls.__SELECT) results = cursor.fetchall() instances = [] for result in results: instance = Instance(result[0], result[1]) instances.append(instance) return instances
def createInstanceCopy(cls): with CursorPool() as cursor: logger.debug(cursor.mogrify(cls.__CREATE_COPY_INSTANCEOF)) cursor.execute(cls.__CREATE_COPY_INSTANCEOF) return cursor.rowcount
def dropFunctions(cls): with CursorPool() as cursor: logger.debug(cursor.mogrify(cls.__DROP_FUNCTIONS)) cursor.execute(cls.__DROP_FUNCTIONS) return cursor.rowcount
def dropTables(cls): with CursorPool() as cursor: logger.debug(cursor.mogrify(cls.__DROP_TABLES)) cursor.execute(cls.__DROP_TABLES) return cursor.rowcount
def createTableInstance(cls): with CursorPool() as cursor: logger.debug(cursor.mogrify(cls.__CREATE_INSTANCE)) cursor.execute(cls.__CREATE_INSTANCE) return cursor.rowcount
def createTableSubclass(cls): with CursorPool() as cursor: logger.debug(cursor.mogrify(cls.__CREATE_SUBCLASS)) cursor.execute(cls.__CREATE_SUBCLASS) return cursor.rowcount