def setUp(self): super(TriggersUpdateTestCase, self).setUp() self.db_name = parent_node_dict["database"][-1]["db_name"] schema_info = parent_node_dict["schema"][-1] self.server_id = schema_info["server_id"] self.db_id = schema_info["db_id"] db_con = database_utils.connect_database(self, utils.SERVER_GROUP, self.server_id, self.db_id) if not db_con['data']["connected"]: raise Exception( "Could not connect to database to update a trigger.") self.schema_id = schema_info["schema_id"] self.schema_name = schema_info["schema_name"] schema_response = schema_utils.verify_schemas(self.server, self.db_name, self.schema_name) if not schema_response: raise Exception("Could not find the schema to update a trigger.") self.table_name = "table_trigger_%s" % (str(uuid.uuid4())[1:8]) self.table_id = tables_utils.create_table(self.server, self.db_name, self.schema_name, self.table_name) self.func_name = "trigger_func_add_%s" % str(uuid.uuid4())[1:8] self.function_info = \ trigger_funcs_utils.create_trigger_function_with_trigger( self.server, self.db_name, self.schema_name, self.func_name) self.trigger_name = "test_trigger_update_%s" % (str(uuid.uuid4())[1:8]) self.trigger_id = triggers_utils.create_trigger( self.server, self.db_name, self.schema_name, self.table_name, self.trigger_name, self.func_name)
def setUp(self): super(TriggersAddTestCase, self).setUp() self.db_name = parent_node_dict["database"][-1]["db_name"] schema_info = parent_node_dict["schema"][-1] self.server_id = schema_info["server_id"] self.db_id = schema_info["db_id"] db_con = database_utils.connect_database(self, utils.SERVER_GROUP, self.server_id, self.db_id) if not db_con['data']["connected"]: raise Exception("Could not connect to database to add a trigger.") self.schema_id = schema_info["schema_id"] self.schema_name = schema_info["schema_name"] schema_response = schema_utils.verify_schemas(self.server, self.db_name, self.schema_name) if not schema_response: raise Exception("Could not find the schema to add a trigger.") self.table_name = "table_trigger_%s" % (str(uuid.uuid4())[1:8]) self.table_id = tables_utils.create_table(self.server, self.db_name, self.schema_name, self.table_name) self.func_name = "trigger_func_add_%s" % str(uuid.uuid4())[1:8] self.function_info = \ trigger_funcs_utils.create_trigger_function_with_trigger( self.server, self.db_name, self.schema_name, self.func_name)
def setUp(self): super(InitDebugger, self).setUp() self.schema_data = parent_node_dict['schema'][-1] self.server_id = self.schema_data['server_id'] self.db_id = self.schema_data['db_id'] self.db_name = parent_node_dict["database"][-1]["db_name"] self.schema_id = self.schema_data['schema_id'] self.schema_name = self.schema_data["schema_name"] db_con = database_utils.connect_database(self, utils.SERVER_GROUP, self.server_id, self.db_id) if not db_con['data']["connected"]: raise Exception("Could not connect to database to delete trigger.") self.table_name = "table_trigger_%s" % (str(uuid.uuid4())[1:8]) self.table_id = tables_utils.create_table(self.server, self.db_name, self.schema_name, self.table_name) self.trigger_func_name = "trigger_func_delete_%s" % \ str(uuid.uuid4())[1:8] self.trigger_function_id = \ trigger_funcs_utils.create_trigger_function_with_trigger( self.server, self.db_name, self.schema_name, self.trigger_func_name)[0] self.trigger_name = "trigger_%s" % str(uuid.uuid4())[1:8] self.test_data['name'] = self.trigger_name self.test_data['tfunction'] = "{0}.{1}".format(self.schema_name, self.trigger_func_name) self.trigger_id = debugger_utils.create_trigger(self, utils) if self.add_extension: debugger_utils.add_extension(self, utils)
def setUp(self): super(InitTargetDebugger, self).setUp() self.debugger_error = 'The debugger plugin is not enabled. ' \ 'Please add the plugin to the shared_preload_' \ 'libraries setting in the postgresql.conf file' \ ' and restart the database server for indirect' \ ' debugging.' self.schema_data = parent_node_dict['schema'][-1] self.server_id = self.schema_data['server_id'] self.db_id = self.schema_data['db_id'] self.schema_id = self.schema_data['schema_id'] local_self = funcs_utils.set_up(self) func_name = "test_function_%s" % str(uuid.uuid4())[1:8] function_info = funcs_utils.create_function(local_self.server, local_self.db_name, local_self.schema_name, func_name) self.func_id = function_info[0] if self.add_extension: debugger_utils.add_extension(self, utils) init_debugger = debugger_utils.init_debugger_function(self) self.trans_id = json.loads(init_debugger.data)['data']['trans_id'] if hasattr(self, 'create_trigger_func') and self.create_trigger_func: db_con = db_utils.connect_database(self, utils.SERVER_GROUP, self.server_id, self.db_id) if not db_con['data']["connected"]: raise Exception( "Could not connect to database to delete trigger.") self.table_name = "table_trigger_%s" % (str(uuid.uuid4())[1:8]) self.table_id = tables_utils.create_table(self.server, self.db_name, self.schema_name, self.table_name) self.trigger_func_name = 'test_trigger_function_%s' % str( uuid.uuid4())[1:8] self.trigger_function_id = \ trigger_funcs_utils.create_trigger_function_with_trigger( self.server, self.db_name, self.schema_name, self.trigger_func_name)[0] self.trigger_name = "trigger_%s" % str(uuid.uuid4())[1:8] self.test_data['name'] = self.trigger_name self.test_data['tfunction'] = "{0}.{1}".format( self.schema_name, self.trigger_func_name) self.trigger_id = debugger_utils.create_trigger(self, utils)