class DjangoDatabaseWrapper(tests.MySQLConnectorTests): """Test the Django base.DatabaseWrapper class""" def setUp(self): dbconfig = tests.get_mysql_config() self.conn = mysql.connector.connect(**dbconfig) self.cnx = DatabaseWrapper(settings.DATABASES['default']) def test__init__(self): exp = self.conn.get_server_version() self.assertEqual(exp, self.cnx.mysql_version) value = datetime.time(2, 5, 7) exp = self.conn.converter._time_to_mysql(value) self.assertEqual(exp, self.cnx.ops.value_to_db_time(value)) self.cnx.connection = None value = datetime.time(2, 5, 7) exp = self.conn.converter._time_to_mysql(value) self.assertEqual(exp, self.cnx.ops.value_to_db_time(value)) def test_signal(self): from django.db import connection def conn_setup(*args, **kwargs): conn = kwargs['connection'] settings.DEBUG = True cur = conn.cursor() settings.DEBUG = False cur.execute("SET @xyz=10") cur.close() connection_created.connect(conn_setup) cursor = connection.cursor() cursor.execute("SELECT @xyz") self.assertEqual((10,), cursor.fetchone()) cursor.close() self.cnx.close() def count_conn(self, *args, **kwargs): try: self.connections += 1 except AttributeError: self.connection = 1 def test_connections(self): connection_created.connect(self.count_conn) self.connections = 0 # Checking if DatabaseWrapper object creates a connection by default conn = DatabaseWrapper(settings.DATABASES['default']) dbo = DatabaseOperations(conn) dbo.value_to_db_time(datetime.time(3, 3, 3)) self.assertEqual(self.connections, 0)
def setUp(self): dbconfig = tests.get_mysql_config() self.conn = mysql.connector.connect(**dbconfig) self.cnx = DatabaseWrapper(settings.DATABASES['default']) self.cur = self.cnx.cursor() self.tbl = "BugOra20106629" self.cur.execute("DROP TABLE IF EXISTS {0}".format(self.tbl), ()) self.cur.execute( "CREATE TABLE {0}(col1 TEXT, col2 BLOB)".format(self.tbl), ())
class DjangoDatabaseWrapper(tests.MySQLConnectorTests): """Test the Django base.DatabaseWrapper class""" def setUp(self): dbconfig = tests.get_mysql_config() self.conn = mysql.connector.connect(**dbconfig) self.cnx = DatabaseWrapper(settings.DATABASES['default']) def test__init__(self): exp = self.conn.get_server_version() self.assertEqual(exp, self.cnx.mysql_version) value = datetime.time(2, 5, 7) exp = self.conn.converter._time_to_mysql(value) self.assertEqual(exp, self.cnx.ops.value_to_db_time(value)) self.cnx.connection = None value = datetime.time(2, 5, 7) exp = self.conn.converter._time_to_mysql(value) self.assertEqual(exp, self.cnx.ops.value_to_db_time(value)) def test_signal(self): from django.db import connection def conn_setup(*args, **kwargs): conn = kwargs['connection'] settings.DEBUG = True cur = conn.cursor() settings.DEBUG = False cur.execute("SET @xyz=10") cur.close() connection_created.connect(conn_setup) cursor = connection.cursor() cursor.execute("SELECT @xyz") self.assertEqual((10, ), cursor.fetchone()) cursor.close() self.cnx.close() def count_conn(self, *args, **kwargs): try: self.connections += 1 except AttributeError: self.connection = 1 def test_connections(self): connection_created.connect(self.count_conn) self.connections = 0 # Checking if DatabaseWrapper object creates a connection by default conn = DatabaseWrapper(settings.DATABASES['default']) dbo = DatabaseOperations(conn) dbo.value_to_db_time(datetime.time(3, 3, 3)) self.assertEqual(self.connections, 0)
def setUp(self): dbconfig = tests.get_mysql_config() self.conn = mysql.connector.connect(**dbconfig) self.cnx = DatabaseWrapper(settings.DATABASES['default']) self.cur = self.cnx.cursor() self.tbl = "BugOra20106629" self.cur.execute("DROP TABLE IF EXISTS {0}".format(self.tbl), ()) self.cur.execute("CREATE TABLE {0}(col1 TEXT, col2 BLOB)".format(self.tbl), ())
def test_connections(self): connection_created.connect(self.count_conn) self.connections = 0 # Checking if DatabaseWrapper object creates a connection by default conn = DatabaseWrapper(settings.DATABASES['default']) dbo = DatabaseOperations(conn) dbo.adapt_timefield_value(datetime.time(3, 3, 3)) self.assertEqual(self.connections, 0)
def setUpClass(cls): cls.cnx = DatabaseWrapper(settings.DATABASES['default']) cls.introspect = DatabaseIntrospection(cls.cnx) cur = cls.cnx.cursor() for table_name, sql in TABLES.items(): cur.execute("SET foreign_key_checks = 0") cur.execute("DROP TABLE IF EXISTS {table_name}".format( table_name=table_name)) cur.execute(sql.format(table_name=table_name)) cur.execute("SET foreign_key_checks = 1")
class DjangoDatabaseWrapper(tests.MySQLConnectorTests): """Test the Django base.DatabaseWrapper class""" def setUp(self): dbconfig = tests.get_mysql_config() self.conn = mysql.connector.connect(**dbconfig) self.cnx = DatabaseWrapper(settings.DATABASES['default']) def test__init__(self): exp = self.conn.get_server_version() self.assertEqual(exp, self.cnx.server_version) value = datetime.time(2, 5, 7) exp = self.conn.converter._time_to_mysql(value) self.assertEqual(exp, self.cnx.ops.value_to_db_time(value)) self.cnx.connection = None value = datetime.time(2, 5, 7) exp = self.conn.converter._time_to_mysql(value) self.assertEqual(exp, self.cnx.ops.value_to_db_time(value)) def test_signal(self): from django.db import connection def conn_setup(*args, **kwargs): conn = kwargs['connection'] cur = conn.cursor() cur.execute("SET @xyz=10") cur.close() connection_created.connect(conn_setup) cursor = connection.cursor() cursor.execute("SELECT @xyz") self.assertEqual((10,), cursor.fetchone()) cursor.close() self.cnx.close()
class DjangoDatabaseWrapper(tests.MySQLConnectorTests): """Test the Django base.DatabaseWrapper class""" def setUp(self): dbconfig = tests.get_mysql_config() self.conn = mysql.connector.connect(**dbconfig) self.cnx = DatabaseWrapper(settings.DATABASES['default']) def test__init__(self): exp = self.conn.get_server_version() self.assertEqual(exp, self.cnx.server_version) value = datetime.time(2, 5, 7) exp = self.conn.converter._time_to_mysql(value) self.assertEqual(exp, self.cnx.ops.value_to_db_time(value)) self.cnx.connection = None value = datetime.time(2, 5, 7) exp = self.conn.converter._time_to_mysql(value) self.assertEqual(exp, self.cnx.ops.value_to_db_time(value)) def test_signal(self): from django.db import connection def conn_setup(*args, **kwargs): conn = kwargs['connection'] cur = conn.cursor() cur.execute("SET @xyz=10") cur.close() connection_created.connect(conn_setup) cursor = connection.cursor() cursor.execute("SELECT @xyz") self.assertEqual((10, ), cursor.fetchone()) cursor.close() self.cnx.close()
class BugOra20106629(tests.MySQLConnectorTests): """CONNECTOR/PYTHON DJANGO BACKEND DOESN'T SUPPORT SAFETEXT""" def setUp(self): dbconfig = tests.get_mysql_config() self.conn = mysql.connector.connect(**dbconfig) self.cnx = DatabaseWrapper(settings.DATABASES['default']) self.cur = self.cnx.cursor() self.tbl = "BugOra20106629" self.cur.execute("DROP TABLE IF EXISTS {0}".format(self.tbl), ()) self.cur.execute("CREATE TABLE {0}(col1 TEXT, col2 BLOB)".format(self.tbl), ()) def teardown(self): self.cur.execute("DROP TABLE IF EXISTS {0}".format(self.tbl), ()) def test_safe_string(self): safe_text = SafeText("dummy & safe data <html> ") safe_bytes = SafeBytes(b"\x00\x00\x4c\x6e\x67\x39") self.cur.execute("INSERT INTO {0} VALUES(%s, %s)".format(self.tbl), (safe_text, safe_bytes)) self.cur.execute("SELECT * FROM {0}".format(self.tbl), ()) self.assertEqual(self.cur.fetchall(), [(safe_text, safe_bytes)])
class BugOra20106629(tests.MySQLConnectorTests): """CONNECTOR/PYTHON DJANGO BACKEND DOESN'T SUPPORT SAFETEXT""" def setUp(self): dbconfig = tests.get_mysql_config() self.conn = mysql.connector.connect(**dbconfig) self.cnx = DatabaseWrapper(settings.DATABASES['default']) self.cur = self.cnx.cursor() self.tbl = "BugOra20106629" self.cur.execute("DROP TABLE IF EXISTS {0}".format(self.tbl), ()) self.cur.execute( "CREATE TABLE {0}(col1 TEXT, col2 BLOB)".format(self.tbl), ()) def teardown(self): self.cur.execute("DROP TABLE IF EXISTS {0}".format(self.tbl), ()) def test_safe_string(self): safe_text = SafeText("dummy & safe data <html> ") safe_bytes = SafeBytes(b"\x00\x00\x4c\x6e\x67\x39") self.cur.execute("INSERT INTO {0} VALUES(%s, %s)".format(self.tbl), (safe_text, safe_bytes)) self.cur.execute("SELECT * FROM {0}".format(self.tbl), ()) self.assertEqual(self.cur.fetchall(), [(safe_text, safe_bytes)])
def setUp(self): dbconfig = tests.get_mysql_config() self.conn = mysql.connector.connect(**dbconfig) self.cnx = DatabaseWrapper(settings.DATABASES['default']) self.dbo = DatabaseOperations(self.cnx)
def setUp(self): dbconfig = tests.get_mysql_config() self.conn = mysql.connector.connect(**dbconfig) self.cnx = DatabaseWrapper(settings.DATABASES['default'])