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)
)
return JsonResponse({}, status=status.HTTP_200_OK)
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)
def post(self, request, schema, table):
if request.POST and request.FILES:
csvfile = TextIOWrapper(request.FILES['csv_file'].file,
encoding=request.encoding)
reader = csv.DictReader(csvfile, delimiter=',')
actions.data_insert({
'schema': actions.get_meta_schema_name(schema),
'table': actions.get_comment_table_name(table),
'method': 'values',
'values': reader
}, {'user': request.user})
return redirect('/dataedit/view/{schema}/{table}/comments'.format(schema=schema,
table=table))
def post(self, request, schema, table):
if request.POST and request.FILES:
csvfile = TextIOWrapper(request.FILES['csv_file'].file,
encoding=request.encoding)
reader = csv.DictReader(csvfile, delimiter=',')
actions.data_insert(
{
'schema': actions.get_meta_schema_name(schema),
'table': actions.get_comment_table_name(table),
'method': 'values',
'values': reader
}, {'user': request.user})
return redirect('/dataedit/view/{schema}/{table}/comments'.format(
schema=schema, table=table))
