Unable to perform inspectdb on tables containing dot (".") in the name about django-snowflake

[timgraham]

The issue is that table names from SHOW TABLES (e.g. DBO.TABLENAME) are lowercased by DatabaseIntrospection.identifier_converter() (dbo.tablename) and then later uppercased by DatabaseOperations.quote_name() which also performs quoting of periods ("DBO"."TABLENAME").

This patch seemed to work for me to introspect a table with a dot in the name:

diff --git a/django_snowflake/introspection.py b/django_snowflake/introspection.py
index 36dff42..c8064f3 100644
--- a/django_snowflake/introspection.py
+++ b/django_snowflake/introspection.py
@@ -194,7 +194,7 @@ class DatabaseIntrospection(BaseDatabaseIntrospection):
         cursor.execute('SHOW TABLES')
         tables = [
             TableInfo(
-                self.identifier_converter(row[1]),  # table name
+                '"' + row[1] + '"',  # table name
                 't',  # 't' for table
                 row[5],  # comment
             ) for row in cursor.fetchall()

output:

class DboTablename(models.Model):
    col1 = models.BigIntegerField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = '"DBO.TABLENAME"'

but only use it temporarily while running inspectdb! A proper solution needs more thought, likely as part of #43.

[ClausSander]

Thanks for looking into this. However, this patch appears to be working only when running inspectdb on the whole database.
python manage.py inspectdb --database snowflake
But not when inspecting one specific table
python manage.py inspectdb --database snowflake DBO.TABLE
python manage.py inspectdb --database snowflake 'DBO.TABLE'
python manage.py inspectdb --database snowflake '"DBO.TABLE"'