def test_run_sql_command_catalog_update(self):
sql_cmd = 'show gp_session_role;'
out_file = os.path.join(os.path.dirname(inspect.getfile(self.__class__)),'test_catalog_update.out')
self.assertFalse(os.path.exists(out_file))
try:
PSQL.run_sql_command_catalog_update(sql_cmd = sql_cmd, out_file = out_file)
self.assertTrue(os.path.exists(out_file))
with open(out_file, 'r') as f:
output = f.read()
self.assertIsNotNone(re.search('utility', output))
finally:
os.remove(out_file)
self.assertFalse(os.path.exists(out_file))
sql_cmd = 'show allow_system_table_mods;'
out_file = os.path.join(os.path.dirname(inspect.getfile(self.__class__)),'test_catalog_update.out')
self.assertFalse(os.path.exists(out_file))
try:
PSQL.run_sql_command_catalog_update(sql_cmd = sql_cmd, out_file = out_file)
self.assertTrue(os.path.exists(out_file))
with open(out_file, 'r') as f:
output = f.read()
self.assertIsNotNone(re.search('DML', output))
finally:
os.remove(out_file)
self.assertFalse(os.path.exists(out_file))
def test_run_sql_command_catalog_update(self):
sql_cmd = 'show gp_session_role;'
out_file = os.path.join(
os.path.dirname(inspect.getfile(self.__class__)),
'test_catalog_update.out')
self.assertFalse(os.path.exists(out_file))
try:
PSQL.run_sql_command_catalog_update(sql_cmd=sql_cmd,
out_file=out_file)
self.assertTrue(os.path.exists(out_file))
with open(out_file, 'r') as f:
output = f.read()
self.assertIsNotNone(re.search('utility', output))
finally:
os.remove(out_file)
self.assertFalse(os.path.exists(out_file))
sql_cmd = 'show allow_system_table_mods;'
out_file = os.path.join(
os.path.dirname(inspect.getfile(self.__class__)),
'test_catalog_update.out')
self.assertFalse(os.path.exists(out_file))
try:
PSQL.run_sql_command_catalog_update(sql_cmd=sql_cmd,
out_file=out_file)
self.assertTrue(os.path.exists(out_file))
with open(out_file, 'r') as f:
output = f.read()
self.assertIsNotNone(re.search('DML', output))
finally:
os.remove(out_file)
self.assertFalse(os.path.exists(out_file))
def test_run_sql_command_catalog_update_with_additional_pgoptions(self):
sql_cmd = "show gp_session_role;"
output = PSQL.run_sql_command_catalog_update(sql_cmd=sql_cmd)
self.assertIsNotNone(re.search("utility", output))
sql_cmd = "show allow_system_table_mods;"
output = PSQL.run_sql_command_catalog_update(sql_cmd=sql_cmd)
self.assertIsNotNone(re.search("DML", output))
sql_cmd = "show client_min_messages;"
output = PSQL.run_sql_command_catalog_update(sql_cmd=sql_cmd, PGOPTIONS="-c client_min_messages=log")
self.assertIsNotNone(re.search("log", output))
def test_run_sql_command_catalog_update_with_additional_pgoptions(self):
sql_cmd = 'show gp_session_role;'
output = PSQL.run_sql_command_catalog_update(sql_cmd=sql_cmd)
self.assertIsNotNone(re.search('utility', output))
sql_cmd = 'show allow_system_table_mods;'
output = PSQL.run_sql_command_catalog_update(sql_cmd=sql_cmd)
self.assertIsNotNone(re.search('DML', output))
sql_cmd = 'show client_min_messages;'
output = PSQL.run_sql_command_catalog_update(
sql_cmd=sql_cmd, PGOPTIONS="-c client_min_messages=log")
self.assertIsNotNone(re.search('log', output))
