+ "outputs": [
+ {
+ "name": "stdout",
+ "output_type": "stream",
+ "text": [
+ "write 1448246712.259522\n",
+ "write 75eef2128eb84e9ca8e4837f3d4e31bd@hotmail.com\n",
+ "write 9138782308848375092\n",
+ "write 840fc02d5cb847ec9f007fb236c0c190@hotmail.com\n",
+ "write 15111277194568576101\n",
+ "write 1448419746.206772\n",
+ "write 1448592471.754446\n",
+ "write c8e4fe772ae3434594e8396a8abf77b1@hotmail.com\n",
+ "write 2273327349069127175\n",
+ "write 1448851661.602960\n",
+ "write 1448938177.97045\n",
+ "write 18203685646345145151\n",
+ "write 12700770160536483846\n",
+ "write 1449024342.601561\n",
+ "write 1fadaaf3d9d544568a41042a1f42df05@hotmail.com\n",
+ "write 3544432548848738700\n",
+ "write 1449110875.443288\n",
+ "write 1449197294.177690\n",
+ "write 10356602625290246518\n",
+ "write 1449283514.868026\n",
+ "write 4654132158287507198\n",
+ "write 5164714352250096219\n",
+ "write 1449542804.259788\n",
+ "write 20246ec4a70041caa276560032fdc595@hotmail.com\n",
+ "write 14089985608998676943\n",
+ "write 1449629119.120001\n",
+ "write c8f339f8f3364d78820dd03a84d11daa@hotmail.com\n",
+ "write 1233953228184721030\n",
+ "write 17984785070730076605\n",
+ "write 1449888489.668429\n",
+ "write 121bb39637c14847a40669dd3e7cdf49@hotmail.com\n",
+ "write 14661842628106423589\n",
+ "write 1449974899.615312\n",
+ "write 7834597727856283739\n",
+ "write f94f00dee713479fb8bfdbcad539da88@hotmail.com\n",
+ "write 17659080448126516391\n",
+ "write 1450234735.690828\n",
+ "write 17880573400612806781\n",
+ "write 1451184218.12383\n",
+ "write 6505353761044749597\n",
+ "write 02aca4c6bb144bb6b54773374c14a43a@hotmail.com\n",
+ "write 1451443783.692950\n",
+ "write 12137203242660163862\n",
+ "write d1019291012e4f4589f59f1dacef31a3@hotmail.com\n",
+ "write 1451616408.476341\n",
+ "write 11743474449139138027\n",
+ "write e245ef81f05b4697bea34bed977d8286@hotmail.com\n",
+ "write 1452134765.308922\n",
+ "write 271c80b9234a4c99bb9608abc5470c99@hotmail.com\n",
+ "write 15974729567081493290\n",
+ "write ba1e9c35eec5428b8c3d6a32d25daa46@hotmail.com\n",
+ "write 1452393953.83099\n",
+ "write d71792d8afc246e9a4756bd13e600b59@hotmail.com\n",
+ "write 1452480188.666644\n",
+ "write 1452566814.805501\n",
+ "write fc0750780e0d4b1395c4c9f41cb9791f@hotmail.com\n",
+ "write 1452653275.294149\n",
+ "write 1452741832.342075\n",
+ "write 2884439811958006165\n",
+ "write 3508955360705645678\n",
+ "write 1452826445.971145\n",
+ "write 1452912512.114840\n",
+ "write eda16c25bbdb48b2bae0d18eab13f736@hotmail.com\n",
+ "write 724976339745122723\n",
+ "write 1453084984.369330\n",
+ "write 1453171440.157305\n",
+ "write 1862812391966551302\n",
+ "write 1453258067.440890\n",
+ "write 1453344550.144698\n",
+ "write 2002148329698541727\n",
+ "write 6110291457768008366\n",
+ "write de651cefbc0749a3aa3d91cdc5084f5a@hotmail.com\n",
+ "write 1453517236.399019\n",
+ "write 14593873841710243963\n",
+ "write ba64911adb0743d0b926588647ec5dcf@hotmail.com\n",
+ "write 1453689981.768611\n",
+ "write 13959504937502303973\n",
+ "write 3eba8b9e31724809aaf8d517e5656c4b@hotmail.com\n",
+ "write 1453776417.898739\n",
+ "write 9594298247075547297\n",
+ "write d77c5b90344149f5bb7b50ff69400aeb@hotmail.com\n",
+ "write 1453862958.482897\n",
+ "write 3267388508667988463\n",
+ "write 580ca0a74948493ba8b7c6e62b8c81d9@hotmail.com\n",
+ "write 6876229717666715946\n",
+ "write 6474240574237085621\n",
+ "write 1454381343.228960\n",
+ "write 77b6c2aa32bf440aa240195db229cd4a@hotmail.com\n",
+ "write 1922265692629464594\n",
+ "write 1454467952.258012\n",
+ "write 1454640482.903992\n",
+ "write 16409503372348966326\n",
+ "write 456ffff78456494fbaed47b465259d46@hotmail.com\n",
+ "write 543258397004515473\n",
+ "write 4158049796460953654\n",
+ "write a6b6aec1af1647eb8c6fd83baaed6bbe@hotmail.com\n",
+ "write 1454986282.636073\n",
+ "write 8986675713054039362\n",
+ "write 30d5ef78d6d746a4a777c56e7ca6f1c6@hotmail.com\n",
+ "write 1455072659.49250\n",
+ "write 10744929815548178249\n",
+ "write 1178c4fe34364ff39cb6e24a51219093@hotmail.com\n",
+ "write 730219275619457\n",
+ "write 164180405175632647\n",
+ "write 16520810497197721925\n",
+ "write 13f28e952d67451281b90d55eee9c7c3@hotmail.com\n",
+ "write 1455418081.446180\n",
+ "write 641b4cc500334a7eb3f649b21af003ca@hotmail.com\n",
+ "write 14416654486328871570\n",
+ "write dbe2f49dbea947428b179e0ecec5f813@hotmail.com\n",
+ "write 1455679107.469767\n",
+ "write 7815164892280952980\n",
+ "write 511d6fbb8484454b916ad8d799938390@hotmail.com\n",
+ "write 1455763965.140751\n",
+ "write 10491829640821461358\n",
+ "write 13702792868066092542\n",
+ "write 1456109267.60200\n",
+ "write 2cfe3d0ec75b43f89a6a7ae57777e25c@hotmail.com\n",
+ "write 9037150256193522538\n",
+ "write e327753089e04950906848d104a93695@hotmail.com\n",
+ "write 1456282325.455667\n",
+ "write 3584764172722215181\n",
+ "write 1456455410.661669\n",
+ "write 16824795799639390032\n",
+ "write 14217880258295310962\n",
+ "write 1456541727.873510\n",
+ "write 1102163566627474204\n",
+ "write 1456713880.905762\n",
+ "write 1456800606.884839\n",
+ "write 1bcc49be66744cc7a70ae1cc53515bbf@hotmail.com\n",
+ "write 11019573554877343650\n",
+ "write 1456886761.643377\n",
+ "write 36dd4e2b3f424bb6919d2d5d4c77c8dd@hotmail.com\n",
+ "write b6d15133598b4e00b21c8e2b7cbec05e@hotmail.com\n",
+ "write 1457059537.625770\n",
+ "write 85136d21c514431e9f5cf9d36faa4a22@hotmail.com\n",
+ "write 1457146943.63077\n",
+ "write 1457232742.472142\n",
+ "write ea3a96df66a845c5a666068ef8ca1368@hotmail.com\n",
+ "write 17044038014166863505\n",
+ "write 1457318880.887129\n",
+ "write 3689737760348689620\n",
+ "write 726a3261dfab4b4590b5fc898c561b08@hotmail.com\n",
+ "write 129a9dc3ff2e40ae8a3890ecc1c291d9@hotmail.com\n",
+ "write 1457491692.793016\n",
+ "write 1207168150882246442\n",
+ "write 10706879170593875813\n",
+ "write 4226319448276355598\n",
+ "write 1457750956.253773\n",
+ "write 12434676377746978866\n",
+ "write 43e7b5e2e0fb400aa914058360c8aaab@hotmail.com\n",
+ "write 1457919850.989656\n",
+ "write 594749737641304465\n",
+ "write 18c9a966da81401e80ca2a22310ffee6@hotmail.com\n",
+ "write 1458006833.731671\n",
+ "write 6996084840178215735\n",
+ "write 1458093082.193350\n",
+ "write 3188090359734380692\n",
+ "write 7006513620611789399\n",
+ "write 1458353823.362308\n",
+ "write 17071564483265101388\n",
+ "write 1458524834.32161\n",
+ "write 1458611429.595569\n",
+ "write 14662396456930987863\n",
+ "write 1458784545.303847\n",
+ "write 13032699446207263761\n",
+ "write 8426152571808739514\n",
+ "write 1458957186.548175\n",
+ "write 2150510829392606201\n",
+ "write 68aad5080a774e2c997d159b546569b9@hotmail.com\n",
+ "write 1459129809.695034\n",
+ "write 16143280651570354241\n",
+ "write 8c177254c3cb41869dc3afab59f74c76@hotmail.com\n",
+ "write 15410706527896810898\n",
+ "write 1459216304.582931\n",
+ "write 15497495941279624940\n",
+ "write 1459302353.261157\n",
+ "write 7773a696f4a54f1e8c01f4644fbb94ee@hotmail.com\n",
+ "write 15185964531645951164\n",
+ "write 1459391203.751219\n",
+ "write 9452413620101638402\n",
+ "write 1459475662.735732\n"
+ ]
+ }
+ ],
+ "source": [
+ "for report in dmarc_reports:\n",
+ " cur.execute('select id, report_metadata_report_id from reports where report_metadata_report_id = %s;', \n",
+ " [report.find('./report_metadata/report_id').text])\n",
+ " results = cur.fetchall()\n",
+ " if not results:\n",
+ " print('write', report.find('./report_metadata/report_id').text)\n",
+ " write_report(conn, cur, report)"
+ ]
+ },
+ {
+ "cell_type": "code",
+ "execution_count": 48,
+ "metadata": {
+ "collapsed": true
+ },