X-Git-Url: https://git.njae.me.uk/?a=blobdiff_plain;f=dmarc_to_database;fp=dmarc_to_database;h=ac7baa39c034ac7e00dc3616de4ac0c5be382c0f;hb=1804dc85cd913ace36a9627f5ee3b956fb0ffe45;hp=530d548b984fa8267eb57c46cfbacdf983441c1b;hpb=9705b435f1eb6db4a872858989d8af455c1dc890;p=dmarc.git

diff --git a/dmarc_to_database b/dmarc_to_database
index 530d548..ac7baa3 100755
--- a/dmarc_to_database
+++ b/dmarc_to_database
@@ -117,7 +117,7 @@ def build_insert_command(table_name, report, preamble_values=None, i=None):
         field_names += [field_maps[f]['pg_field_name']]
         if field_maps[f]['pg_type'] == 'int':
             values[field_maps[f]['pg_field_name']] = int(report.find(fp).text)
-        elif field_maps[f]['pg_type'] == 'timestamp':
+        elif field_maps[f]['pg_type'] == 'timestamptz':
             # values[field_maps[f]['pg_field_name']] = datetime.datetime.utcfromtimestamp(int(report.find(fp).text))
             values[field_maps[f]['pg_field_name']] = \
                 datetime.datetime.fromtimestamp(int(report.find(fp).text),