def delete(self, request, schema, table): schema, table = actions.get_table_name(schema, table) meta_schema = actions.get_meta_schema_name(schema) edit_table = actions.get_edit_table_name(schema, table) actions._get_engine().execute( "DROP TABLE {schema}.{table} CASCADE;".format( schema=meta_schema, table=edit_table ) ) edit_table = actions.get_insert_table_name(schema, table) actions._get_engine().execute( "DROP TABLE {schema}.{table} CASCADE;".format( schema=meta_schema, table=edit_table ) ) edit_table = actions.get_delete_table_name(schema, table) actions._get_engine().execute( "DROP TABLE {schema}.{table} CASCADE;".format( schema=meta_schema, table=edit_table ) ) actions._get_engine().execute( "DROP TABLE {schema}.{table} CASCADE;".format(schema=schema, table=table) ) return JsonResponse({}, status=status.HTTP_200_OK)
def tearDown(self): meta_schema = actions.get_meta_schema_name(self.test_schema) if actions.has_table( dict(table=self.test_table, schema=self.test_schema)): actions.perform_sql( "DROP TABLE IF EXISTS {schema}.{table} CASCADE".format( schema=meta_schema, table=actions.get_insert_table_name( self.test_schema, self.test_table), )) actions.perform_sql( "DROP TABLE IF EXISTS {schema}.{table} CASCADE".format( schema=meta_schema, table=actions.get_edit_table_name(self.test_schema, self.test_table), )) actions.perform_sql( "DROP TABLE IF EXISTS {schema}.{table} CASCADE".format( schema=meta_schema, table=actions.get_delete_table_name( self.test_schema, self.test_table), )) actions.perform_sql( "DROP TABLE IF EXISTS {schema}.{table} CASCADE".format( schema=self.test_schema, table=self.test_table))
def delete(self, request, schema, table): schema, table = actions.get_table_name(schema, table) meta_schema = actions.get_meta_schema_name(schema) edit_table = actions.get_edit_table_name(schema, table) actions._get_engine().execute( "DROP TABLE \"{schema}\".\"{table}\" CASCADE;".format( schema=meta_schema, table=edit_table)) edit_table = actions.get_insert_table_name(schema, table) actions._get_engine().execute( "DROP TABLE \"{schema}\".\"{table}\" CASCADE;".format( schema=meta_schema, table=edit_table)) edit_table = actions.get_delete_table_name(schema, table) actions._get_engine().execute( "DROP TABLE \"{schema}\".\"{table}\" CASCADE;".format( schema=meta_schema, table=edit_table)) actions._get_engine().execute( "DROP TABLE \"{schema}\".\"{table}\" CASCADE;".format( schema=schema, table=table)) table_object, _ = DBTable.objects.get_or_create(name=table, schema__name=schema) table_object.delete() return JsonResponse({}, status=status.HTTP_200_OK)