diff options
| -rwxr-xr-x | DominoServer.py | 16 |
1 files changed, 16 insertions, 0 deletions
diff --git a/DominoServer.py b/DominoServer.py index f2a22e2..3cb3db6 100755 --- a/DominoServer.py +++ b/DominoServer.py @@ -198,6 +198,17 @@ class CommunicationHandler: logging.error('Could not add the new labels to %s for Domino Client %d', SERVER_DBFILE, sub_msg.domino_udid) logging.error('Unexpected error: %s', sys.exc_info()[0]) + newttypeset = self.dominoServer.subscribed_templateformats[sub_msg.domino_udid] + try: + c.execute("REPLACE INTO ttypes (udid, ttype_list) VALUES ({udid}, '{newvalue}')".\ + format(udid=sub_msg.domino_udid, newvalue=','.join(list(newttypeset)) )) + except sqlite3.OperationalError as ex1: + logging.error('Could not add the new labels to %s for Domino Client %d : %s', SERVER_DBFILE, sub_msg.domino_udid, ex1.message) + except: + logging.error('Could not add the new labels to %s for Domino Client %d', SERVER_DBFILE, sub_msg.domino_udid) + logging.error('Unexpected error: %s', sys.exc_info()[0]) + + dbconn.commit() dbconn.close() @@ -362,6 +373,11 @@ def main(argv): logging.debug('In database file %s, no table is created as %s', SERVER_DBFILE, ex.message) try: + c.execute('''CREATE TABLE ttypes (udid INTEGER PRIMARY KEY, ttype_list TEXT)''') + except sqlite3.OperationalError as ex: + logging.debug('In database file %s, no table is created as %s', SERVER_DBFILE, ex.message) + + try: c.execute('''CREATE TABLE clients (udid INTEGER PRIMARY KEY, ipaddr TEXT, tcpport INTEGER, templatetypes TEXT, seqno INTEGER)''') except sqlite3.OperationalError as ex: logging.debug('In database file %s, no table is created as %s', SERVER_DBFILE, ex.message) |