~cwt/pySyslog commit - sourcehut hg

1 files changed, 2 insertions(+), 1 deletions(-)

M syslogd.py

M syslogd.py +2 -1

@@ 16,7 16,7 @@ del(os)
 
 
 # Query
-SQL = ("INSERT INTO SystemEvents (Facility, Priority, FromHost, "
+SQL = ("INSERT INTO SystemEvents%s (Facility, Priority, FromHost, "
        "InfoUnitID, ReceivedAt, DeviceReportedTime, SysLogTag, "
        "ProcessID, Message) values "
        "('%s','%s','%s','%s','%s','%s','%s','%s','%s')")

          
@@ 100,6 100,7 @@ class SyslogUDPHandler(DatagramServer):
             FromHost = address[0]
             InfoUnitID = 1  # Hardcoded
             sql_command = SQL % (
+                ReceivedAt.strftime('%Y%m'),
                 Facility, Priority, FromHost, InfoUnitID,
                 ReceivedAt.strftime('%Y-%m-%d %H:%M:%S'),
                 DeviceReportedTime.strftime('%Y-%m-%d %H:%M:%S'),