Python get_insert_table_name Examples

Example #1

File: views.py Project: sashatankov/oeplatform

    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)

Example #2

File: test_column.py Project: sashatankov/oeplatform

 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))

Example #3

    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)