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 from __future__ import print_function
26 import os, sys, MySQLdb
27 dirNm, execName = os.path.split(sys.argv[0])
28 sys.path.append(os.path.abspath(os.path.join(dirNm, "../libexec")))
29
30 from XALTdb import XALTdb
31 import warnings
32 warnings.filterwarnings("ignore", "Unknown table.*")
33
34
36 ConfigBaseNm = "xalt_db"
37 ConfigFn = ConfigBaseNm + ".conf"
38
39 if (not os.path.isfile(ConfigFn)):
40 dirNm,prg = os.path.split(sys.argv[0])
41 fn = os.path.join(dirNm, ConfigFn)
42 if (os.path.isfile(fn)):
43 ConfigFn = fn
44 else:
45 ConfigFn = os.path.abspath(os.path.join(dirNm,"../sbin",ConfigFn))
46
47
48 xalt = XALTdb(ConfigFn)
49 try:
50 conn = xalt.connect()
51 except MySQLdb.Error, e:
52 print("-1")
53 sys.exit(1)
54
55
56
57 try:
58 query = "USE "+xalt.db()
59 conn.query(query)
60 query = "SELECT job_id FROM xalt_job_id WHERE inc_id='1'"
61 conn.query(query)
62 result = conn.store_result()
63 if (result.num_rows() > 0):
64 row = result.fetch_row()
65 job_id = int(row[0][0]) + 1
66 query = "UPDATE xalt_job_id SET job_id='%d' WHERE inc_id='1'" % job_id
67 conn.query(query)
68
69 print(job_id)
70
71
72
73
74
75 except MySQLdb.Error, e:
76 print ("Error %d: %s" % (e.args[0], e.args[1]))
77 sys.exit (1)
78
79 if ( __name__ == '__main__'): main()
80