Python get_connection Examples

Example #1

File: test_schema.py Project: enstrategic/django-sql-explorer-old

 def test_app_inclusion_list_excluded(self):
     # Inclusion list "wins"
     schema._get_includes = lambda: ('explorer_', )
     schema._get_excludes = lambda: ('explorer_', )
     res = schema.schema_info(get_connection())
     tables = [x[0] for x in res]
     self.assertIn('explorer_query', tables)

Example #2

File: test_schema.py Project: dsanders11/django-sql-explorer

 def test_app_inclusion_list_excluded(self):
     # Inclusion list "wins"
     schema._get_includes = lambda: ('explorer_',)
     schema._get_excludes = lambda: ('explorer_',)
     res = schema.schema_info(get_connection())
     tables = [x[0] for x in res]
     self.assertIn('explorer_query', tables)

Example #3

File: test_schema.py Project: enstrategic/django-sql-explorer-old

 def test_app_inclusion_list(self, ):
     schema._get_includes = lambda: ('auth_', )
     schema._get_excludes = lambda: []
     res = schema.schema_info(get_connection())
     tables = [x[0] for x in res]
     self.assertNotIn('explorer_query', tables)
     self.assertIn('auth_user', tables)

Example #4

File: test_schema.py Project: dsanders11/django-sql-explorer

 def test_app_inclusion_list(self, ):
     schema._get_includes = lambda: ('auth_',)
     schema._get_excludes = lambda: []
     res = schema.schema_info(get_connection())
     tables = [x[0] for x in res]
     self.assertNotIn('explorer_query', tables)
     self.assertIn('auth_user', tables)

Example #5

 def _get_numerics(self):
     conn = get_connection()
     if hasattr(conn.Database, "NUMBER"):
         return [ix for ix, c in enumerate(self._description) if hasattr(c, 'type_code') and c.type_code in conn.Database.NUMBER.values]
     elif self.data:
         d = self.data[0]
         return [ix for ix, _ in enumerate(self._description) if not isinstance(d[ix], six.string_types) and six.text_type(d[ix]).isnumeric()]
     return []

Example #6

File: models.py Project: ITCollectiv/django-sql-explorer

 def _get_numerics(self):
     conn = get_connection()
     if hasattr(conn.Database, "NUMBER"):
         return [ix for ix, c in enumerate(self._description) if hasattr(c, 'type_code') and c.type_code in conn.Database.NUMBER.values]
     elif self.data:
         d = self.data[0]
         return [ix for ix, _ in enumerate(self._description) if not isinstance(d[ix], six.string_types) and six.text_type(d[ix]).isnumeric()]
     return []

Example #7

    def execute_query(self):
        conn = get_connection()
        cursor = conn.cursor()
        start_time = time()

        try:
            cursor.execute(self.sql)
        except DatabaseError as e:
            cursor.close()
            raise e

        return cursor, ((time() - start_time) * 1000)

Example #8

File: models.py Project: ITCollectiv/django-sql-explorer

    def execute_query(self):
        conn = get_connection()
        cursor = conn.cursor()
        start_time = time()

        try:
            cursor.execute(self.sql)
        except DatabaseError as e:
            cursor.close()
            raise e

        return cursor, ((time() - start_time) * 1000)

Example #9

File: test_schema.py Project: enstrategic/django-sql-explorer-old

 def test_table_exclusion_list(self):
     schema._get_includes = lambda: None
     schema._get_excludes = lambda: ('explorer_', )
     res = schema.schema_info(get_connection())
     tables = [x[0] for x in res]
     self.assertNotIn('explorer_query', tables)

Example #10

File: test_schema.py Project: enstrategic/django-sql-explorer-old

 def test_schema_info_returns_valid_data(self):
     schema._get_includes = lambda: None
     schema._get_excludes = lambda: []
     res = schema.schema_info(get_connection())
     tables = [x[0] for x in res]
     self.assertIn('explorer_query', tables)

Example #11

File: views.py Project: dsanders11/django-sql-explorer

 def get(self, request, *args, **kwargs):
     return render_to_response('explorer/schema.html',
                               {'schema': schema_info(get_connection())})

Example #12

File: views.py Project: grouwner/sc

 def get(self, request, *args, **kwargs):
     return render_to_response('explorer/schema.html',
                               {'schema': schema_info(get_connection())})

Example #13

File: test_schema.py Project: dsanders11/django-sql-explorer

 def test_table_exclusion_list(self):
     schema._get_includes = lambda: None
     schema._get_excludes = lambda: ('explorer_',)
     res = schema.schema_info(get_connection())
     tables = [x[0] for x in res]
     self.assertNotIn('explorer_query', tables)

Example #14

File: test_schema.py Project: dsanders11/django-sql-explorer

 def test_schema_info_returns_valid_data(self):
     schema._get_includes = lambda: None
     schema._get_excludes = lambda: []
     res = schema.schema_info(get_connection())
     tables = [x[0] for x in res]
     self.assertIn('explorer_query', tables)