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