def test_can_open_twbx_and_save_changes(self):
original_wb = Workbook(self.workbook_file.name)
original_wb.datasources[0].connections[0].server = 'newdb'
original_wb.save()
new_wb = Workbook(self.workbook_file.name)
self.assertEqual(new_wb.datasources[0].connections[0].server, 'newdb')
def test_can_update_datasource_connection_and_save(self):
original_wb = Workbook(self.workbook_file.name)
original_wb.datasources[0].connections[0].dbname = 'newdb'
original_wb.save()
new_wb = Workbook(self.workbook_file.name)
self.assertEqual(new_wb.datasources[0].connections[0].dbname, 'newdb')
def test_can_open_twbx_and_save_changes(self):
original_wb = Workbook(self.workbook_file.name)
original_wb.datasources[0].connections[0].server = 'newdb'
original_wb.save()
new_wb = Workbook(self.workbook_file.name)
self.assertEqual(new_wb.datasources[0].connections[
0].server, 'newdb')
def test_can_update_datasource_connection_and_save(self):
original_wb = Workbook(self.workbook_file.name)
original_wb.datasources[0].connections[0].dbname = 'newdb'
original_wb.save()
new_wb = Workbook(self.workbook_file.name)
self.assertEqual(new_wb.datasources[0].connections[
0].dbname, 'newdb')
def test_save_has_xml_declaration(self):
original_wb = Workbook(self.workbook_file.name)
original_wb.datasources[0].connections[0].dbname = 'newdb.test.tsi.lan'
original_wb.save()
with open(self.workbook_file.name) as f:
first_line = f.readline().strip() # first line should be xml tag
self.assertEqual(first_line,
"<?xml version='1.0' encoding='utf-8'?>")
def test_save_has_xml_declaration(self):
original_wb = Workbook(self.workbook_file.name)
original_wb.datasources[0].connections[0].dbname = 'newdb'
original_wb.save()
with open(self.workbook_file.name) as f:
first_line = f.readline().strip() # first line should be xml tag
self.assertEqual(
first_line, "<?xml version='1.0' encoding='utf-8'?>")
from tableaudocumentapi import Workbook
sourceWB = Workbook('workbook__31__5ebd2e77c610660027445090_output.twbx')
for i in range(0, (len(sourceWB.datasources))):
sourceWB.datasources[i].connections[
0].server = "sandbox3.opexanalytics.com"
sourceWB.datasources[i].connections[
0].dbname = "qa_tableau_test_app_5ed5fba9c966080027ea792a"
sourceWB.datasources[i].connections[
0].username = "******"
sourceWB.datasources[i].connections[0].password = "******"
print("Updated for : ", (sourceWB.datasources[i].caption))
sourceWB.save()
