def createTable(self, tableName):
assert Strings.notEmpty(tableName), "table Name Cannot be Empty"
connection = self.m_databaseConnection.getConnection()
for env in EnvironmentTypeEnum:
try:
query = self.getCreateTableQuery(table=Strings.concatinateWithUnderScore(str1=tableName, str2=env.name))
print(query)
connection.cursor().execute(query)
connection.commit()
query = self.insertQuery(table=Strings.concatinateWithUnderScore(str1=tableName, str2=env.name))
print(query)
connection.cursor().execute(query)
connection.commit()
except (Exception, psycopg2.Error) as error:
print(error)
self.m_databaseConnection.closeConnection(connection=connection);
def get(self):
try:
query = self.m_helper.getEntityQuery(
data=Strings.concatinateWithUnderScore(
self.m_table.tableName(),
self.m_serverEnvironment.getServerEnvironment().name))
print(query)
conn = self.m_dbConnection.getConnection()
cursor = conn.cursor()
cursor.execute(query)
row = cursor.fetchall()[0]
self.id = row[1]
conn.close()
return self.m_encoder.convert(id=int(row[1]))
except (Exception, psycopg2.Error) as error:
print("Error in update operation", error)
def update(self):
try:
query = self.m_helper.updateEntityQuery(
data=Strings.concatinateWithUnderScore(
self.m_table.tableName(),
self.m_serverEnvironment.getServerEnvironment().name),
value=self.getIdNumber(self.id))
print(query)
conn = self.m_dbConnection.getConnection()
cursor = conn.cursor()
cursor.execute(query)
conn.commit()
count = cursor.rowcount
conn.close()
except (Exception, psycopg2.Error) as error:
print("Error in update operation", error)
def update(self, id, json, table):
try:
query = self.getUpdateQuery(id=id, json=json, table=Strings.concatinateWithUnderScore(str1=table,
str2=self.m_serverListner.getServerEnvironment().name))
print(query)
conn = self.m_dbConnection.getConnection()
cursor = conn.cursor()
cursor.execute(str(query))
if (cursor.rowcount > 0):
conn.commit()
conn.close()
cursor.close()
return json
else:
conn.commit()
conn.close()
cursor.close()
return None
except (Exception, psycopg2.Error) as error:
print("Error in update operation", error)
def checkTable(self, tableName):
assert Strings.notEmpty(tableName), "table Name Cannot be Empty"
connection = self.m_databaseConnection.getConnection()
cursor = connection.cursor()
check = False
for env in EnvironmentTypeEnum:
try:
query = self.ckeckTableQuery(
tableName=Strings.concatinateWithUnderScore(str1=tableName,
str2=env.name))
print(query)
cursor.execute(query)
val = cursor.fetchall()[0]
check = val[0]
connection.commit()
except:
pass
self.m_databaseConnection.closeConnection(connection=connection)
if (check):
return check
def get(self, id, table):
try:
query = self.getQuery(table=Strings.concatinateWithUnderScore(str1=table,
str2=self.m_serverListner.getServerEnvironment().name),
id=id)
print(query)
conn = self.m_dbConnection.getConnection()
cursor = conn.cursor()
cursor.execute(query)
if (cursor.rowcount == 1):
row = cursor.fetchall()
data = row[0]
conn.commit()
conn.close()
cursor.close()
return data[0]
else:
conn.commit()
conn.close()
cursor.close()
return None
except (Exception, psycopg2.Error) as error:
print("Error in update operation", error)