class UserHelper:
def __init__(self):
self.db = OracleDb()
def getVariable(self, user_name=None):
if user_name:
user_name = "'{0}'".format(user_name)
else:
user_name = 'null'
query = "select * from table(ORM_USER_FUNCTION.GetVariable({0}))".format(user_name)
result = self.db.execute(query)
return result.fetchall()
def getVariables(self, function_name=None):
if function_name:
function_name = "'{0}'".format(function_name)
else:
function_name = 'null'
query = "select * from table(orm_user_Function_search.GetVariable({0}))".format(function_name)
result = self.db.execute(query)
return result.fetchall()
class Helper:
def init(self):
self.db = OracleDb()
def Get_phone(self, phone_id=None):
if phone_id:
phone_id = "'{0}'".format(phone_id)
else:
phone_id = 'null'
query = "select * from table(pkg_hr.get_phone({0}))".format(phone_id)
result = self.db.execute(query)
return result.fetchall()
def Update_phone(self, phone_id, phone_model, phone_vendor, phone_price,
phone_date):
cursor = self.db.cursor
status = cursor.var(cx_Oracle.STRING)
cursor.callproc("pkg_hr.update_phone", [
phone_id, phone_model, phone_vendor, phone_price, phone_date,
status
])
return status.getvalue()
class UserHelper:
def __init__(self):
self.db = OracleDb()
def getVariable(self, group_name=None):
if group_name:
group_name = "'{0}'".format(group_name)
else:
group_name = 'null'
query = "select * from table(ORM_COUNT.GetCountData({0}))".format(
group_name)
print(query)
result = self.db.execute(query)
return result.fetchall()
def test(self):
db = OracleDb()
query1 = (
db.sqlalchemy_session.query(
ormSchedule.group_name,
func.count(ormSchedule.group_name).label('skill_count')
). \
group_by(ormSchedule.group_name)
).all()
print(query1)
class UserHelper:
def __init__(self):
self.db = OracleDb()
def getSkillData(self, skill_name=None):
if skill_name:
skill_name = "'{0}'".format(skill_name)
else:
skill_name = 'null'
query = "select * from table(user_skillS.GetSkillData({0}))".format(
skill_name)
result = self.db.execute(query)
return result.fetchall()
def getUserId(self, user_email, user_password):
user_id = self.db.cursor.callfunc("USER_AUTH.GET_USER_ID",
cx_Oracle.NATIVE_INT,
[user_email, user_password])
return user_id
def newUser(self, USER_STUDYBOOK, USER_YEAR, USER_NAME, USER_EMAIL,
USER_BIRTHDAY, USER_PASSWORD):
cursor = self.db.cursor
user_id = cursor.var(cx_Oracle.NATIVE_INT)
status = cursor.var(cx_Oracle.STRING)
cursor.callproc("USER_AUTH.NEW_USER", [
user_id, status, USER_STUDYBOOK, USER_YEAR, USER_NAME, USER_EMAIL,
USER_BIRTHDAY.upper(), USER_PASSWORD
])
return user_id.getvalue(), status.getvalue()
def getUsers(self):
return self.db.execute('SELECT * FROM "user"').fetchall()
class ShipHelper:
def __init__(self):
self.db = OracleDb()
def getShip(self, ship_id):
query = "select * from ship where ship.ship_id = {}".format(ship_id)
result = self.db.execute(query)
return result.fetchall()
def updateShip(self, ship_id, ship_number, ship_date, ship_name,
ship_address):
query = "update ship set ship_number={ship_number}, ship_date={ship_date}, ship_name={ship_name}, ship_address={ship_address} where ship_id={ship_id}".format(
ship_number=ship_number,
ship_date=ship_date,
ship_name=ship_name,
ship_address=ship_address,
ship_id=ship_id)
self.db.execute(query)
class UserHelper:
def __init__(self):
self.db = OracleDb()
def getUserData(self, **kwargs):
first_name = kwargs.get('first_name', 'null')
last_name = kwargs.get('last_name', 'null')
query = "select * from table(orm_user_package.GetUserData())" #.format(first_name, last_name)
print(query)
result = self.db.execute(query)
print(result)
return result
def search(self):
db = OracleDb()
user = f"'{self.user_name.data}'" if self.user_name.data != 'None' else 'null'
file = f"'{self.file_name.data}'" if self.file_name.data != 'None' else 'null'
query = f"select * from table(editors_search.find({file}, {user}))"
result = db.execute(query)
result = result.fetchall()
if result:
return result
else:
return 'Empty search table'
def search(self):
db = OracleDb()
nick = f"'{self.news_name.data}'" if selfnews_name.data != 'None' else 'null'
name = f"'{self.nick.data}'" if self.nick.data != 'None' else 'null'
query = f"select * from table(search.find({nick}, {name}))"
result = db.execute(query)
result = result.fetchall()
if result:
return result
else:
return 'search table'
class UH:
def __init__(self):
self.db = OracleDb()
def getData(self, name=None):
if name:
name = "'{0}'".format(name)
else:
name = 'null'
query = "select * from table(m_name.getData({0}))".format(name)
result = self.db.execute(query)
return result.fetchall()
class UserHelper:
def __init__(self):
self.db = OracleDb()
def getDocumentData(self, patch_file=None):
if patch_file:
patch_file = "'{0}'".format(patch_file)
else:
patch_file = 'null'
query = "select * from table(orm_user_group.GetDocumentData({0}))".format(
patch_file)
result = self.db.execute(query)
return result.fetchall()
class UserHelper:
def __init__(self):
self.db = OracleDb()
def getSkillData(self, skill_name=None):
if skill_name:
skill_name = "'{0}'".format(skill_name)
else:
skill_name = 'null'
query = "select * from table(orm_user_skillS.GetSkillData({0}))".format(
skill_name)
result = self.db.execute(query)
return result.fetchall()
class UserHelper:
def __init__(self):
self.db = OracleDb()
def getUserData(self, user_locale=None):
if user_locale:
user_locale = "'{0}'".format(user_locale)
else:
user_locale = 'null'
query = "select * from table(orm_user_locale.GetUserData({0}))".format(
user_locale)
result = self.db.execute(query)
return result.fetchall()
class UserHelper:
def __init__(self):
self.db = OracleDb()
def getHobbyData(self, hobby_name=None):
if hobby_name:
hobby_name = "'{0}'".format(hobby_name)
else:
hobby_name = 'null'
query = "select * from table(orm_hobby.GetHobbyData({0}))".format(
hobby_name)
result = self.db.execute(query)
return result.fetchall()
class OwnerHelper:
def __init__(self):
self.db = OracleDb()
def getCarData(self, car_number=None):
if car_number:
car_number = "'{0}'".format(car_number)
else:
car_number = 'null'
query = "select * from table(orm_owner_car.GetCarData({0}))".format(
car_number)
result = self.db.execute(query)
return result.fetchall()
class UserHelper:
def __init__(self):
self.db = OracleDb()
def getTestCount(self, variable_name=None):
if variable_name:
variable_name = "'{0}'".format(variable_name)
else:
variable_name = 'null'
query = "select * from table(orm_test_count.GetTestCount({0}))".format(variable_name)
result = self.db.execute(query)
return result.fetchall()
class TokenFinder:
def __init__(self):
self.db = OracleDb()
def getTokenData(self, token_data=None, password=None):
if token_data and password:
token_data = "'{0}'".format(token_data)
password = "******".format(password)
else:
token_data = 'null'
password = '******'
query = "select * from table(orm_user_skillS.GetSkillData({0}))".format(
skill_name)
result = self.db.execute(query)
return result.fetchall()
class WorkerHelper:
def __init__(self):
self.db = OracleDb()
def GetJobData(self, worker_surname=None, assignment_name=None):
if worker_surname:
worker_surname = "'{0}'".format(worker_surname)
else:
worker_surname = 'null'
if assignment_name:
assignment_name = "'{0}'".format(assignment_name)
else:
assignment_name = 'null'
query = "select * from table(orm_worker_assignment.GetJob({0}, {1}))".format(
worker_surname, assignment_name)
result = self.db.execute(query)
return result.fetchall()
query = """
SELECT
col.column_name,
col.data_type,
col.nullable
FROM
sys.all_tab_columns col
INNER JOIN sys.all_tables t
ON col.owner = t.owner AND col.table_name = t.table_name
WHERE
col.owner = upper('{0}')
AND col.table_name = '{1}'
""".format(table_owner, table_name)
result = db.execute(query)
controls_mapping = \
{
"VARCHAR2":"StringField",
"DATE":"DateField",
"NUMBER":"IntegerField",
"CHAR": "StringField",
}
class_fields = ""
form_fields = ""
for column_name, data_type, nullable in result.fetchall():
if nullable == 'Y':
def delete(self):
db = OracleDb()
query = "DELETE FROM user WHERE {0} = {1}".format(
'user_id', self.user_id.data)
db.execute(query)