def get_sql_from_index_diff(self, **kwargs):
"""
This function get the sql from index diff.
:param kwargs:
:return:
"""
sid = kwargs.get('sid')
did = kwargs.get('did')
scid = kwargs.get('scid')
tid = kwargs.get('tid')
idx = kwargs.get('idx')
data = kwargs.get('data', None)
target_schema = kwargs.get('target_schema', None)
drop_req = kwargs.get('drop_req', False)
sql = ''
if data:
data['schema'] = self.schema
data['nspname'] = self.schema
data['table'] = self.table
sql, name = index_utils.get_sql(
self.conn,
data=data,
did=did,
tid=tid,
idx=idx,
datlastsysoid=self._DATABASE_LAST_SYSTEM_OID,
mode='create')
sql = sql.strip('\n').strip(' ')
elif target_schema:
sql = index_utils.get_reverse_engineered_sql(
self.conn,
schema=target_schema,
table=self.table,
did=did,
tid=tid,
idx=idx,
datlastsysoid=self._DATABASE_LAST_SYSTEM_OID,
template_path=None,
with_header=False,
add_not_exists_clause=True)
drop_sql = ''
if drop_req:
drop_sql = '\n' + self.delete(gid=1,
sid=sid,
did=did,
scid=scid,
tid=tid,
idx=idx,
only_sql=True)
if drop_sql != '':
sql = drop_sql + '\n\n' + sql
return sql
def get_sql_from_index_diff(self,
sid,
did,
scid,
tid,
idx,
data=None,
diff_schema=None,
drop_req=False):
tmp_idx = idx
schema = ''
if data:
schema = self.schema
data['schema'] = self.schema
data['nspname'] = self.schema
data['table'] = self.table
sql, name = index_utils.get_sql(self.conn,
data,
did,
tid,
idx,
self.datlastsysoid,
mode='create')
sql = sql.strip('\n').strip(' ')
elif diff_schema:
schema = diff_schema
sql = index_utils.get_reverse_engineered_sql(self.conn,
schema,
self.table,
did,
tid,
idx,
self.datlastsysoid,
template_path=None,
with_header=False)
drop_sql = ''
if drop_req:
drop_sql = '\n' + self.delete(gid=1,
sid=sid,
did=did,
scid=scid,
tid=tid,
idx=idx,
only_sql=True)
if drop_sql != '':
sql = drop_sql + '\n\n' + sql
return sql
def sql(self, gid, sid, did, scid, tid, idx):
"""
This function will generates reverse engineered sql for schema object
Args:
gid: Server Group ID
sid: Server ID
did: Database ID
scid: Schema ID
tid: Table ID
idx: Index ID
"""
SQL = index_utils.get_reverse_engineered_sql(self.conn, self.schema,
self.table, did, tid, idx,
self.datlastsysoid)
return ajax_response(response=SQL)
def sql(self, gid, sid, did, scid, tid, idx):
"""
This function will generates reverse engineered sql for schema object
Args:
gid: Server Group ID
sid: Server ID
did: Database ID
scid: Schema ID
tid: Table ID
idx: Index ID
"""
SQL = index_utils.get_reverse_engineered_sql(
self.conn,
schema=self.schema,
table=self.table,
did=did,
tid=tid,
idx=idx,
datlastsysoid=self._DATABASE_LAST_SYSTEM_OID,
add_not_exists_clause=True)
return ajax_response(response=SQL)
def get_sql_from_index_diff(self, sid, did, scid, tid, idx, data=None,
diff_schema=None, drop_req=False):
tmp_idx = idx
schema = ''
if data:
schema = self.schema
elif diff_schema:
schema = diff_schema
sql = index_utils.get_reverse_engineered_sql(
self.conn, schema,
self.table, did, tid, idx,
self.datlastsysoid,
template_path=None, with_header=False)
drop_sql = ''
if drop_req:
drop_sql = '\n' + render_template(
"/".join([self.template_path, 'delete.sql']),
data=data, conn=self.conn
)
return drop_sql + '\n\n' + sql
