def test_can_write_attributes_to_connection(self):
conn = Connection(self.connection)
conn.dbname = 'BubblesInMyDrink'
conn.server = 'mssql2014.test.tsi.lan'
conn.username = '******'
self.assertEqual(conn.dbname, 'BubblesInMyDrink')
self.assertEqual(conn.username, 'bob')
self.assertEqual(conn.server, 'mssql2014.test.tsi.lan')
def test_can_write_attributes_to_connection(self):
conn = Connection(self.connection)
conn.dbname = 'BubblesInMyDrink'
conn.server = 'mssql2014.test.tsi.lan'
conn.username = '******'
self.assertEqual(conn.dbname, 'BubblesInMyDrink')
self.assertEqual(conn.username, 'bob')
self.assertEqual(conn.server, 'mssql2014.test.tsi.lan')
def test_can_write_attributes_to_connection(self):
conn = Connection(self.connection)
conn.dbname = 'BubblesInMyDrink'
conn.server = 'mssql2014'
conn.username = '******'
conn.port = '1337'
self.assertEqual(conn.dbname, 'BubblesInMyDrink')
self.assertEqual(conn.username, 'bob')
self.assertEqual(conn.server, 'mssql2014')
self.assertEqual(conn.port, '1337')
def test_can_create_datasource_from_connections(self):
conn1 = Connection.from_attributes(
server='a', dbname='b', username='******', dbclass='mysql', authentication='d')
conn2 = Connection.from_attributes(
server='1', dbname='2', username='******', dbclass='mysql', port='1337', authentication='7')
ds = Datasource.from_connections('test', connections=[conn1, conn2])
self.assertEqual(ds.connections[0].server, 'a')
self.assertEqual(ds.connections[0].port, None)
self.assertEqual(ds.connections[1].server, '1')
self.assertEqual(ds.connections[1].port, '1337')
def test_can_create_datasource_from_connections(self):
conn1 = Connection.from_attributes(server='a',
dbname='b',
username='******',
dbclass='mysql',
authentication='d')
conn2 = Connection.from_attributes(server='1',
dbname='2',
username='******',
dbclass='mysql',
authentication='7')
ds = Datasource.from_connections('test', connections=[conn1, conn2])
self.assertEqual(ds.connections[0].server, 'a')
self.assertEqual(ds.connections[1].server, '1')
def test_can_read_attributes_from_connection(self):
conn = Connection(self.connection)
self.assertEqual(conn.dbname, 'TestV1')
self.assertEqual(conn.username, '')
self.assertEqual(conn.server, 'mssql2012.test.tsi.lan')
self.assertEqual(conn.dbclass, 'sqlserver')
self.assertEqual(conn.authentication, 'sspi')
def test_can_create_connection_from_scratch(self):
conn = Connection.from_attributes(
server='a', dbname='b', username='******', dbclass='mysql', authentication='d')
self.assertEqual(conn.server, 'a')
self.assertEqual(conn.dbname, 'b')
self.assertEqual(conn.username, 'c')
self.assertEqual(conn.dbclass, 'mysql')
self.assertEqual(conn.authentication, 'd')
def test_can_read_attributes_from_connection(self):
conn = Connection(self.connection)
self.assertEqual(conn.dbname, 'TestV1')
self.assertEqual(conn.username, '')
self.assertEqual(conn.server, 'mssql2012')
self.assertEqual(conn.dbclass, 'sqlserver')
self.assertEqual(conn.authentication, 'sspi')
self.assertEqual(conn.port, '1433')
self.assertEqual(conn.initial_sql, '')
self.assertEqual(conn.query_band, '')
def test_can_create_connection_from_scratch(self):
conn = Connection.from_attributes(server='a',
dbname='b',
username='******',
dbclass='mysql',
authentication='d')
self.assertEqual(conn.server, 'a')
self.assertEqual(conn.dbname, 'b')
self.assertEqual(conn.username, 'c')
self.assertEqual(conn.dbclass, 'mysql')
self.assertEqual(conn.authentication, 'd')
def test_can_write_attributes_to_connection(self):
conn = Connection(self.connection)
conn.dbname = 'BubblesInMyDrink'
conn.server = 'mssql2014'
conn.username = '******'
conn.port = '1337'
conn.initial_sql = "insert values (1, 'winning') into schema.table"
conn.query_band = 'TableauReport=<workbookname>'
self.assertEqual(conn.dbname, 'BubblesInMyDrink')
self.assertEqual(conn.username, 'bob')
self.assertEqual(conn.server, 'mssql2014')
self.assertEqual(conn.port, '1337')
self.assertEqual(conn.initial_sql,
"insert values (1, 'winning') into schema.table")
self.assertEqual(conn.query_band, 'TableauReport=<workbookname>')
def test_can_write_attributes_to_connection(self):
conn = Connection(self.connection)
conn.dbname = 'BubblesInMyDrink'
conn.server = 'mssql2014'
conn.username = '******'
conn.port = '1337'
self.assertEqual(conn.dbname, 'BubblesInMyDrink')
self.assertEqual(conn.username, 'bob')
self.assertEqual(conn.server, 'mssql2014')
self.assertEqual(conn.port, '1337')
def test_can_write_attributes_to_connection(self):
conn = Connection(self.connection)
conn.dbname = 'BubblesInMyDrink'
conn.server = 'mssql2014'
conn.username = '******'
conn.port = '1337'
conn.initial_sql = "insert values (1, 'winning') into schema.table"
conn.query_band = 'TableauReport=<workbookname>'
self.assertEqual(conn.dbname, 'BubblesInMyDrink')
self.assertEqual(conn.username, 'bob')
self.assertEqual(conn.server, 'mssql2014')
self.assertEqual(conn.port, '1337')
self.assertEqual(conn.initial_sql, "insert values (1, 'winning') into schema.table")
self.assertEqual(conn.query_band, 'TableauReport=<workbookname>')
def test_can_delete_initial_sql_from_connection(self):
conn = Connection(self.connection)
conn.initial_sql = None
self.assertEqual(conn.initial_sql, None)
self.assertIsNone(conn._connectionXML.get('initial_sql'))
def test_bad_dbclass_rasies_attribute_error(self):
conn = Connection(self.connection)
conn.dbclass = 'sqlserver'
self.assertEqual(conn.dbclass, 'sqlserver')
with self.assertRaises(AttributeError):
conn.dbclass = 'NotReal'
def test_can_delete_query_band_from_connection(self):
conn = Connection(self.connection)
conn.query_band = None
self.assertEqual(conn.query_band, None)
self.assertIsNone(conn._connectionXML.get('query_band'))
def test_can_delete_initial_sql_from_connection(self):
conn = Connection(self.connection)
conn.initial_sql = None
self.assertEqual(conn.initial_sql, None)
self.assertIsNone(conn._connectionXML.get('initial_sql'))
def test_can_delete_port_from_connection(self):
conn = Connection(self.connection)
conn.port = None
self.assertEqual(conn.port, None)
self.assertIsNone(conn._connectionXML.get('port'))
def test_can_delete_port_from_connection(self):
conn = Connection(self.connection)
conn.port = None
self.assertEqual(conn.port, None)
self.assertIsNone(conn._connectionXML.get('port'))
def test_can_delete_query_band_from_connection(self):
conn = Connection(self.connection)
conn.query_band = None
self.assertEqual(conn.query_band, None)
self.assertIsNone(conn._connectionXML.get('query_band'))
def test_bad_dbclass_rasies_attribute_error(self):
conn = Connection(self.connection)
conn.dbclass = 'sqlserver'
self.assertEqual(conn.dbclass, 'sqlserver')
with self.assertRaises(AttributeError):
conn.dbclass = 'NotReal'
