def test_doubleNames2(self):
inFolder = "input/"
master_file = "act_test_dual_names.csv"
slave_file = "wp_test_dual_names.csv"
maPath = os.path.join(inFolder, master_file)
saPath = os.path.join(inFolder, slave_file)
saParser = CSVParse_User(
cols = ColData_User.getWPImportCols(),
defaults = ColData_User.getDefaults(),
)
saParser.analyseFile(saPath)
sUsr = saParser.emails['*****@*****.**'][0]
maParser = CSVParse_User(
cols = ColData_User.getACTImportCols(),
defaults = ColData_User.getDefaults(),
)
maParser.analyseFile(maPath)
mUsr = maParser.emails['*****@*****.**'][0]
syncUpdate = SyncUpdate(mUsr, sUsr)
syncUpdate.update(ColData_User.getSyncCols())
print "master old: ", syncUpdate.oldMObject['Name'], '|', syncUpdate.oldMObject['Contact']
print "master new: ", syncUpdate.newMObject['Name'], '|', syncUpdate.newMObject['Contact']
print "slave old: ", syncUpdate.oldSObject['Name'], '|', syncUpdate.oldSObject['Contact']
print "slave new: ", syncUpdate.newSObject['Name'], '|', syncUpdate.newSObject['Contact']
print syncUpdate.tabulate(tablefmt='simple')
print syncUpdate.getMasterUpdates()
def test_SQLWP_Analyse(self):
saParser = CSVParse_User(
cols = ColData_User.getImportCols(),
defaults = ColData_User.getDefaults()
)
with UsrSyncClient_SQL_WP(
self.SSHTunnelForwarderParams,
self.PyMySqlConnectParams
) as sqlClient:
sqlClient.analyseRemote(saParser, since='2016-01-01 00:00:00')
# CSVParse_User.printBasicColumns( list(chain( *saParser.emails.values() )) )
self.assertIn('*****@*****.**', saParser.emails)
