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