mirror of
https://github.com/hanzoai/pymssql.git
synced 2026-10-30 14:54:29 +00:00
Ramiro Morales
b818434465
This stops incorrect skipping of a few test_pymssql test cases. Fixes #253
133 lines
4.2 KiB
Python
133 lines
4.2 KiB
Python
import unittest
|
|
|
|
import pymssql as pym
|
|
|
|
from .helpers import pymssqlconn, PyTableBase, drop_table, CursorBase, eq_, config
|
|
|
|
class TestDBAPI2(object):
|
|
def test_version(self):
|
|
assert pym.__version__
|
|
|
|
class TestTransaction(unittest.TestCase, PyTableBase):
|
|
tname = 'users'
|
|
cols = (
|
|
'name varchar(50)',
|
|
)
|
|
|
|
def setUp(self):
|
|
PyTableBase.setUp(self)
|
|
# make sure we start with a fresh connection for transaction tests
|
|
# so that previous transaction activities don't taint a test
|
|
self.newconn()
|
|
|
|
def test_immediate_rollback(self):
|
|
# just making sure this doesn't throw an exception
|
|
self.conn.rollback()
|
|
|
|
def test_multiple_rollbacks(self):
|
|
# just making sure this doesn't throw an exception
|
|
self.conn.rollback()
|
|
self.conn.rollback()
|
|
self.conn.rollback()
|
|
|
|
def test_rollback(self):
|
|
cur = self.conn.cursor()
|
|
cur.execute('insert into users values (%s)', 'foobar')
|
|
eq_(self.row_count(), 1)
|
|
self.conn.rollback()
|
|
eq_(self.row_count(), 0)
|
|
|
|
def test_commit(self):
|
|
cur = self.conn.cursor()
|
|
cur.execute('insert into users values (%s)', 'foobar')
|
|
eq_(self.row_count(), 1)
|
|
self.conn.commit()
|
|
self.conn.rollback()
|
|
eq_(self.row_count(), 1)
|
|
|
|
def test_rollback_after_error(self):
|
|
cur = self.conn.cursor()
|
|
cur.execute('insert into users values (%s)', 'foobar')
|
|
eq_(self.row_count(), 1)
|
|
try:
|
|
cur.execute('insert into notable values (%s)', '123')
|
|
except pym.ProgrammingError as e:
|
|
if 'notable' not in str(e):
|
|
raise
|
|
# encountered an error, so we want to rollback
|
|
self.conn.rollback()
|
|
# rollback should have resulted in user's insert getting rolled back
|
|
# too
|
|
eq_(self.row_count(), 0)
|
|
|
|
def test_rollback_after_create_error(self):
|
|
"""
|
|
test_rollback_after_create_error
|
|
|
|
For some reason, SQL server will issue a batch-abort
|
|
if the statement is a CREATE statement and it fails. This means
|
|
the transaction is implicitly rolled back and a subsequent call to
|
|
rollback() without special handling would result in an error.
|
|
"""
|
|
cur = self.conn.cursor()
|
|
cur.execute('insert into users values (%s)', 'foobar')
|
|
eq_(self.row_count(), 1)
|
|
try:
|
|
cur.execute("CREATE TABLE badschema.t1 ( test1 CHAR(5) NOT NULL)")
|
|
except pym.OperationalError as e:
|
|
if 'badschema' not in str(e):
|
|
raise
|
|
# encountered an error, so we want to rollback
|
|
self.conn.rollback()
|
|
# rollback should have resulted in user's insert getting rolled back
|
|
# too
|
|
eq_(self.row_count(), 0)
|
|
|
|
class TestCursor(CursorBase):
|
|
dbmod = pym
|
|
|
|
@classmethod
|
|
def newconn(cls):
|
|
cls.conn = pymssqlconn()
|
|
|
|
class TestBasicConnection(unittest.TestCase):
|
|
|
|
def connect(self, conn_props=None):
|
|
return pym.connect(
|
|
server=config.server,
|
|
user=config.user,
|
|
password=config.password,
|
|
database=config.database,
|
|
port=config.port,
|
|
conn_properties=conn_props
|
|
)
|
|
|
|
def test_conn_props_override(self):
|
|
conn = self.connect(conn_props='SET TEXTSIZE 2147483647')
|
|
conn.close()
|
|
|
|
conn = self.connect(conn_props='SET TEXTSIZE 2147483647;')
|
|
conn.close()
|
|
|
|
conn = self.connect(conn_props='SET TEXTSIZE 2147483647;SET ANSI_NULLS ON;')
|
|
conn.close()
|
|
|
|
conn = self.connect(conn_props='SET TEXTSIZE 2147483647;SET ANSI_NULLS ON')
|
|
conn.close()
|
|
|
|
conn = self.connect(conn_props='SET TEXTSIZE 2147483647;'
|
|
'SET ANSI_NULLS ON;')
|
|
conn.close()
|
|
|
|
conn = self.connect(conn_props=['SET TEXTSIZE 2147483647;', 'SET ANSI_NULLS ON'])
|
|
conn.close()
|
|
self.assertRaises(Exception, self.connect, conn_props='BOGUS SQL')
|
|
|
|
conn = pym.connect(
|
|
conn_properties='SET TEXTSIZE 2147483647',
|
|
server=config.server,
|
|
user=config.user,
|
|
password=config.password
|
|
)
|
|
conn.close()
|