@@ -42,7 +42,7 @@ def test_can_extract_federated_connections(self):
42
42
connections = parser .get_connections ()
43
43
self .assertIsInstance (connections , list )
44
44
self .assertIsInstance (connections [0 ], Connection )
45
- self .assertEqual (connections [0 ].dbname , 'testv1 ' )
45
+ self .assertEqual (connections [0 ].dbname , 'TestV1 ' )
46
46
47
47
48
48
class ConnectionModelTests (unittest .TestCase ):
@@ -54,18 +54,18 @@ def test_can_read_attributes_from_connection(self):
54
54
conn = Connection (self .connection )
55
55
self .assertEqual (conn .dbname , 'TestV1' )
56
56
self .assertEqual (conn .username , '' )
57
- self .assertEqual (conn .server , 'mssql2012.test.tsi.lan ' )
57
+ self .assertEqual (conn .server , 'mssql2012' )
58
58
self .assertEqual (conn .dbclass , 'sqlserver' )
59
59
self .assertEqual (conn .authentication , 'sspi' )
60
60
61
61
def test_can_write_attributes_to_connection (self ):
62
62
conn = Connection (self .connection )
63
63
conn .dbname = 'BubblesInMyDrink'
64
- conn .server = 'mssql2014.test.tsi.lan '
64
+ conn .server = 'mssql2014'
65
65
conn .username = 'bob'
66
66
self .assertEqual (conn .dbname , 'BubblesInMyDrink' )
67
67
self .assertEqual (conn .username , 'bob' )
68
- self .assertEqual (conn .server , 'mssql2014.test.tsi.lan ' )
68
+ self .assertEqual (conn .server , 'mssql2014' )
69
69
70
70
def test_bad_dbclass_rasies_attribute_error (self ):
71
71
conn = Connection (self .connection )
@@ -117,15 +117,15 @@ def test_can_extract_connection(self):
117
117
118
118
def test_can_save_tds (self ):
119
119
original_tds = Datasource .from_file (self .tds_file .name )
120
- original_tds .connections [0 ].dbname = 'newdb.test.tsi.lan '
120
+ original_tds .connections [0 ].dbname = 'newdb'
121
121
original_tds .save ()
122
122
123
123
new_tds = Datasource .from_file (self .tds_file .name )
124
- self .assertEqual (new_tds .connections [0 ].dbname , 'newdb.test.tsi.lan ' )
124
+ self .assertEqual (new_tds .connections [0 ].dbname , 'newdb' )
125
125
126
126
def test_save_has_xml_declaration (self ):
127
127
original_tds = Datasource .from_file (self .tds_file .name )
128
- original_tds .connections [0 ].dbname = 'newdb.test.tsi.lan '
128
+ original_tds .connections [0 ].dbname = 'newdb'
129
129
130
130
original_tds .save ()
131
131
@@ -158,11 +158,11 @@ def test_can_extract_connection(self):
158
158
159
159
def test_can_save_tds (self ):
160
160
original_tds = Datasource .from_file (self .tds_file .name )
161
- original_tds .connections [0 ].dbname = 'newdb.test.tsi.lan '
161
+ original_tds .connections [0 ].dbname = 'newdb'
162
162
original_tds .save ()
163
163
164
164
new_tds = Datasource .from_file (self .tds_file .name )
165
- self .assertEqual (new_tds .connections [0 ].dbname , 'newdb.test.tsi.lan ' )
165
+ self .assertEqual (new_tds .connections [0 ].dbname , 'newdb' )
166
166
167
167
168
168
class DatasourceModelV10TDSXTests (unittest .TestCase ):
@@ -183,22 +183,22 @@ def test_can_open_tdsx(self):
183
183
184
184
def test_can_open_tdsx_and_save_changes (self ):
185
185
original_tdsx = Datasource .from_file (self .tdsx_file .name )
186
- original_tdsx .connections [0 ].server = 'newdb.test.tsi.lan '
186
+ original_tdsx .connections [0 ].server = 'newdb'
187
187
original_tdsx .save ()
188
188
189
189
new_tdsx = Datasource .from_file (self .tdsx_file .name )
190
190
self .assertEqual (new_tdsx .connections [
191
- 0 ].server , 'newdb.test.tsi.lan ' )
191
+ 0 ].server , 'newdb' )
192
192
193
193
def test_can_open_tdsx_and_save_as_changes (self ):
194
194
new_tdsx_filename = 'newtdsx.tdsx'
195
195
original_wb = Datasource .from_file (self .tdsx_file .name )
196
- original_wb .connections [0 ].server = 'newdb.test.tsi.lan '
196
+ original_wb .connections [0 ].server = 'newdb'
197
197
original_wb .save_as (new_tdsx_filename )
198
198
199
199
new_wb = Datasource .from_file (new_tdsx_filename )
200
200
self .assertEqual (new_wb .connections [
201
- 0 ].server , 'newdb.test.tsi.lan ' )
201
+ 0 ].server , 'newdb' )
202
202
os .unlink (new_tdsx_filename )
203
203
204
204
@@ -230,12 +230,12 @@ def test_has_filename(self):
230
230
231
231
def test_can_update_datasource_connection_and_save (self ):
232
232
original_wb = Workbook (self .workbook_file .name )
233
- original_wb .datasources [0 ].connections [0 ].dbname = 'newdb.test.tsi.lan '
233
+ original_wb .datasources [0 ].connections [0 ].dbname = 'newdb'
234
234
original_wb .save ()
235
235
236
236
new_wb = Workbook (self .workbook_file .name )
237
237
self .assertEqual (new_wb .datasources [0 ].connections [
238
- 0 ].dbname , 'newdb.test.tsi.lan ' )
238
+ 0 ].dbname , 'newdb' )
239
239
240
240
241
241
class WorkbookModelV10Tests (unittest .TestCase ):
@@ -260,17 +260,17 @@ def test_can_extract_datasourceV10(self):
260
260
261
261
def test_can_update_datasource_connection_and_saveV10 (self ):
262
262
original_wb = Workbook (self .workbook_file .name )
263
- original_wb .datasources [0 ].connections [0 ].dbname = 'newdb.test.tsi.lan '
263
+ original_wb .datasources [0 ].connections [0 ].dbname = 'newdb'
264
264
265
265
original_wb .save ()
266
266
267
267
new_wb = Workbook (self .workbook_file .name )
268
268
self .assertEqual (new_wb .datasources [0 ].connections [
269
- 0 ].dbname , 'newdb.test.tsi.lan ' )
269
+ 0 ].dbname , 'newdb' )
270
270
271
271
def test_save_has_xml_declaration (self ):
272
272
original_wb = Workbook (self .workbook_file .name )
273
- original_wb .datasources [0 ].connections [0 ].dbname = 'newdb.test.tsi.lan '
273
+ original_wb .datasources [0 ].connections [0 ].dbname = 'newdb'
274
274
275
275
original_wb .save ()
276
276
@@ -298,22 +298,22 @@ def test_can_open_twbx(self):
298
298
299
299
def test_can_open_twbx_and_save_changes (self ):
300
300
original_wb = Workbook (self .workbook_file .name )
301
- original_wb .datasources [0 ].connections [0 ].server = 'newdb.test.tsi.lan '
301
+ original_wb .datasources [0 ].connections [0 ].server = 'newdb'
302
302
original_wb .save ()
303
303
304
304
new_wb = Workbook (self .workbook_file .name )
305
305
self .assertEqual (new_wb .datasources [0 ].connections [
306
- 0 ].server , 'newdb.test.tsi.lan ' )
306
+ 0 ].server , 'newdb' )
307
307
308
308
def test_can_open_twbx_and_save_as_changes (self ):
309
309
new_twbx_filename = 'newtwbx.twbx'
310
310
original_wb = Workbook (self .workbook_file .name )
311
- original_wb .datasources [0 ].connections [0 ].server = 'newdb.test.tsi.lan '
311
+ original_wb .datasources [0 ].connections [0 ].server = 'newdb'
312
312
original_wb .save_as (new_twbx_filename )
313
313
314
314
new_wb = Workbook (new_twbx_filename )
315
315
self .assertEqual (new_wb .datasources [0 ].connections [
316
- 0 ].server , 'newdb.test.tsi.lan ' )
316
+ 0 ].server , 'newdb' )
317
317
318
318
os .unlink (new_twbx_filename )
319
319
0 commit comments