-
Notifications
You must be signed in to change notification settings - Fork 1
/
Copy pathExcelFileValidatorTest.py
65 lines (43 loc) · 1.85 KB
/
ExcelFileValidatorTest.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
#!/usr/bin/env python
# -*- coding: utf-8 -*-
from openpyxl import load_workbook
import threading
import os.path
import ExcelFileWatcher
import ExcelFileValidator
import ServerConfiguration
import ExcelFileLoader
def test_callback(evpath, evname):
print "test_callback: evpath=", evpath, "evname = ", evname
excelfileloader = ExcelFileLoader.ExcelFileLoader()
trainIDs = excelfileloader.loadfile(evpath+'/'+evname)
for l in trainIDs:
print l
########## main ##############
serverConfiguration = ServerConfiguration.ServerConfiguration('server.cfg')
foldername = serverConfiguration.getExcelFolderNameForSchedule()
filename = serverConfiguration.getExcelFileNameForSchedule()
print 'Folder= ',foldername, ' filename= ', filename
excelfileloader = ExcelFileLoader.ExcelFileLoader()
trainIDs = excelfileloader.loadfile(foldername+'/'+filename)
for l in trainIDs:
print l
print 'Starting the file validator ...'
#excelFileValidator = ExcelFileValidator.ExcelFileValidator( foldername, filename , test_callback) #("webservers/excelsrc", "excel1.xlsx", test_callback)
def ExcelFileValidatorThreadStarter():
excelFileValidator = ExcelFileValidator.ExcelFileValidator( foldername, filename , test_callback) #("webservers/excelsrc", "excel1.xlsx", test_callback)
excelFileValidator.startFileWatcher()
#excelFileValidatorThread = threading.Thread(target = ExcelFileValidatorThreadStarter())
#excelFileValidatorThread.daemon = True
#excelFileValidatorThread.start()
excelFileValidator = ExcelFileValidator.ExcelFileValidator( foldername, filename , test_callback) #("webservers/excelsrc", "excel$
excelFileValidator.startFileWatcher()
print "Right after thread start !!!"
#
#excelfileloader = ExcelFileLoader.ExcelFileLoader()
#trainIDs = excelfileloader.loadfile(folername+'/'+filename)
#
#for l in trainIDs:
# print l
#
#excelFileWatcher.start_watch_loop()