blob: cca79ce5c11f7e3277d8a68b7cf7e5c613060d6f [file] [log] [blame]
#!/usr/bin/env python3
# -*- coding: utf-8 -*-
# Licensed to the Apache Software Foundation (ASF) under one or more
# contributor license agreements. See the NOTICE file distributed with
# this work for additional information regarding copyright ownership.
# The ASF licenses this file to You under the Apache License, Version 2.0
# (the "License"); you may not use this file except in compliance with
# the License. You may obtain a copy of the License at
#
# http://www.apache.org/licenses/LICENSE-2.0
#
# Unless required by applicable law or agreed to in writing, software
# distributed under the License is distributed on an "AS IS" BASIS,
# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
# See the License for the specific language governing permissions and
# limitations under the License.
import argparse
import email.errors
import email.header
import email.utils
import glob
import gzip
import hashlib
import logging
import mailbox
import multiprocessing
import os
import random
import re
import sys
import tempfile
import time
import urllib.parse
from os import listdir
from os.path import isdir, isfile, join
from threading import Lock, Thread
from urllib.request import urlopen
if not __package__:
import archiver
from plugins import textlib
from plugins.elastic import Elastic
else:
from . import archiver
from .plugins.elastic import Elastic
from .plugins import textlib
TIMEOUT_DEFAULT = 600
goodies = 0
baddies = 0
dupes = 0 # number of duplicates dropped
replacements = 0 # number of entries replaced
duplicates: dict = {} # detect if mid is re-used this run
block = Lock()
lists: list = [] # N.B. the entries in this list depend on the import type:
# globDir: [filename, list-id]
# modMbox: [list-id, mbox]
# piperMail: [filename, list-id]
# imap(s): [uids, listname, imap4]
# other: [filename, list-override]
start = time.time()
quickmode = False
private = False
appender = "apache.org"
source = "./"
maildir = False
imap = False
list_override = None
project = ""
filebased = False
fileToLID = {}
interactive = False
extension = ".mbox"
piperWeirdness = False
resendTo = None
timeout = TIMEOUT_DEFAULT
fromFilter = None
dedup = False
dedupped = 0
noMboxo = False # Don't skip MBoxo patch
rootURL = ""
dumpfile = None # for args.dump
def bulk_insert(name, json, xes, dbindex, wc="quorum"):
sys.stderr.flush()
optype = "index" if args.overwrite else "create"
js_arr = []
for js in json:
document_id = js["mid"]
if dbindex == xes.db_source:
del js["mid"]
js_arr.append(
{
"_op_type": optype,
"_consistency": wc,
"_index": dbindex,
"_id": document_id,
"doc": js,
"_source": js,
}
)
successes = [] # indices of successful operations
findex = 0
repl = 0
# process the bulk responses individually so can determine
# which source entries need to be skipped
try:
for status, result in xes.streaming_bulk(js_arr, ignore_status=409):
d = result[optype]
if status:
successes.append(findex) # record successful entries
if d['result'] == 'updated':
repl += 1
else:
msgid = js_arr[findex]['doc'].get('message-id', 'Unknown')
print(f"{name}: Warning: Failed to create {d['_index']} with mid: {d['_id']} from msgid: {msgid}")
findex += 1
except Exception as err: # should not happen
print("%s: Warning: Could not bulk insert: %s into %s" % (name, err, dbindex))
return successes, repl
def bulk_insert_both(name, mbox, source, xes):
"""Create mbox entries; if any fail, don't create the corresponding source entries"""
global replacements, dupes, goodies
successes, repl = bulk_insert(name, mbox, xes, xes.db_mbox)
failures = len(mbox) - len(successes)
# if there are failures, keep only successes
if failures:
source = [source[i] for i in successes]
# anything left?
if source:
# not interested in replacements here
bulk_insert(name, source, xes, xes.db_source)
replacements += repl
goodies -= failures
dupes += failures
class DownloadThread(Thread): # handles Pipermail
def assign(self, url):
self.url = url
def run(self):
global lists
mldata = urlopen(self.url).read()
tmpfile = tempfile.NamedTemporaryFile(mode="w+b", delete=False)
try:
if ml.find(".gz") != -1:
mldata = gzip.decompress(mldata)
except Exception as err:
print("This wasn't a gzip file: %s" % err)
print(len(mldata))
tmpfile.write(mldata)
tmpfile.flush()
tmpfile.close()
lists.append([tmpfile.name, list_override])
print("Adding %s to slurp list as %s" % (self.url, tmpfile.name))
class SlurpThread(Thread):
def printid(self, message):
print("%s: %s" % (self.name, message))
def run(self):
global goodies, baddies, dedupped
ja = []
jas = []
self.printid("Thread started")
mla = None
ml = ""
mboxfile = ""
filename = ""
archie = archiver.Archiver(
generator=args.generator, parse_html=args.html2text, ignore_body=args.ibody, verbose=args.verbose
)
while len(lists) > 0:
self.printid("%u elements left to slurp" % len(lists))
block.acquire()
try:
mla = lists.pop(0)
if not mla:
self.printid("Nothing more to do here")
return
except Exception as err:
self.printid("Could not pop list: %s" % err)
return
finally:
block.release()
stime = time.time()
tmpname = ""
delete_file = False
useMboxo = False
if imap:
imap4 = mla[2]
tmpname = "IMAP"
def mailgen(_list):
for uid in _list:
msgbytes = imap4.uid("fetch", uid, "(RFC822)")[1][0][1]
yield email.message_from_bytes(msgbytes)
messages = mailgen(mla[0])
elif filebased:
tmpname = mla[0]
filename = mla[0]
if filename.find(".gz") != -1:
self.printid("Decompressing %s..." % filename)
try:
with open(filename, "rb") as bf:
bmd = bf.read()
bf.close() # explicit early close
bmd = gzip.decompress(bmd)
tmpfile = tempfile.NamedTemporaryFile(
mode="w+b", delete=False
)
tmpfile.write(bmd)
tmpfile.flush()
tmpfile.close()
tmpname = tmpfile.name
delete_file = True # Slated for deletion upon having been read
self.printid("%s -> %u bytes" % (tmpname, len(bmd)))
except Exception as err:
self.printid("This wasn't a gzip file: %s" % err)
self.printid("Slurping %s" % filename)
if maildir:
messages = mailbox.Maildir(tmpname, create=False)
else:
useMboxo = (not noMboxo)
messages = mailbox.mbox(
tmpname, None if noMboxo else MboxoFactory, create=False
)
else:
ml = mla[0]
mboxfile = mla[1]
self.printid("Slurping %s/%s" % (ml, mboxfile))
ctx = urlopen("%s%s/%s" % (source, ml, mboxfile))
inp = ctx.read().decode(
ctx.headers.get_content_charset() or "utf-8", errors="ignore"
)
tmpname = hashlib.sha224(
(
"%f-%f-%s-%s.mbox"
% (random.random(), time.time(), ml, mboxfile)
).encode("utf-8")
).hexdigest()
with open(tmpname, "w") as f:
f.write(inp)
if maildir:
messages = mailbox.Maildir(tmpname, create=False)
else:
messages = mailbox.mbox(
tmpname, None if noMboxo else MboxoFactory, create=False
)
count = 0
bad = 0
for key in messages.iterkeys():
file = messages.get_file(key, True)
# If the parsed data is filtered, also need to filter the raw input
# so the source agrees with the summary info
if useMboxo:
file = MboxoReader(file)
message_raw = file.read()
file.close()
message = email.message_from_bytes(message_raw, policy=archiver.policy)
if not message:
self.printid("Message %u could not be extracted from %s, ignoring it" % (key, tmpname))
continue
# If --filter is set, discard any messages not matching by continuing to next email
if (
fromFilter
and "from" in message
and message["from"].find(fromFilter) == -1
):
continue
if resendTo:
self.printid(
"Delivering message %s via MTA" % message["message-id"]
if "message-id" in message
else "??"
)
s = SMTP("localhost")
try:
if list_override:
message.replace_header("List-ID", list_override)
message.replace_header("To", resendTo)
except:
if list_override:
message["List-ID"] = list_override
message["cc"] = None
s.send_message(message, from_addr=None, to_addrs=(resendTo))
continue
if (
time.time() - stime > timeout
): # break out after N seconds, it shouldn't take this long..!
self.printid(
"Whoa, this is taking way too long, ignoring %s for now"
% tmpname
)
break
# Don't pass message to archiver unless we have a list id
if not (list_override or message["list-id"]):
self.printid("No list id found for %s " % message["message-id"])
bad += 1
continue
# If fetched from Pipermail, we have to revert/reconstruct From: headers sometimes,
# before we can pass it off to final archiving.
if args.pipermail and " at " in str(message.get("from")):
m = re.match(r"^(\S+) at (\S+) \((.+)\)$", str(message["from"]))
if m:
message.replace_header("from", "%s <%s@%s>" % (m.group(3), m.group(1), m.group(2)))
json, contents, _msgdata, _irt, skipit = archie.compute_updates(
list_override, private, message, message_raw
)
if skipit:
continue
# Not sure this can ever happen
if json and not (json["list"] and json["list_raw"]):
self.printid("No list id found for %s " % json["message-id"])
bad += 1
continue
# If --dedup is active, try to filter out any messages that already exist on the list
if json and dedup and message.get("message-id", None):
res = es.search(
index=es.db_mbox,
doc_type="_doc",
size=1,
_source=["mid"], # so can report the match source
body={
"query": {
"bool": {
"must": [
{
"term": {
"message-id": message.get(
"message-id", None
)
}
},
{"term": {"list_raw": json["list"]}},
]
}
}
},
)
if res and res["hits"]["total"]["value"] > 0:
self.printid(
"Dedupping %s - matched in %s"
% (
json["message-id"],
res["hits"]["hits"][0]["_source"]["mid"],
)
)
dedupped += 1
continue
if json:
if args.dups:
try:
duplicates[json["mid"]].append(
json["message-id"] + " in " + filename
)
except:
duplicates[json["mid"]] = [
json["message-id"] + " in " + filename
]
# Mark that we imported this email
json["_notes"] = [x for x in json["_notes"] if "ARCHIVE:" not in x] # Pop archiver.py note
json["_notes"].append(["IMPORT: Email imported as %s at %u" % (json["mid"], time.time())])
try: # temporary hack to try and find an encoding issue
# needs to be replaced by proper exception handling
json_source = {
"mid": json["dbid"], # this is only needed for bulk_insert to set up the _id
"message-id": json["message-id"],
"source": archiver.mbox_source(message_raw),
}
except Exception as e:
self.printid(
"Error '%s' processing id %s msg %s "
% (e, json["mid"], json["message-id"])
)
bad += 1
continue
count += 1
if args.verbose and verbose_logger:
# TODO optionally show other fields (e.g. From_ line)
verbose_logger.info("MID:%(mid)s MSGID:%(message-id)s", json)
# Nothing more to do if dry run
if args.dry:
if dumpfile:
import json as JSON
# drop fields with timestamps
del(json['_notes'])
del(json['_archived_at'])
JSON.dump(json, dumpfile, indent=2, sort_keys=True, ensure_ascii=False)
dumpfile.write(",\n")
continue
ja.append(json)
jas.append(json_source)
if contents:
for key in contents:
es.index(
index=es.db_attachment,
doc_type="_doc",
id=key,
body={"source": contents[key]},
)
if len(ja) >= 40:
bulk_insert_both(self.name, ja, jas, es)
ja = []
jas = []
else:
self.printid(
"Failed to parse: Return=%s Message-Id=%s"
% (message.get("Return-Path"), message.get("Message-Id"))
)
bad += 1
if filebased:
self.printid(
"Parsed %u records (failed: %u) from %s" % (count, bad, filename)
)
if delete_file:
os.unlink(tmpname)
elif imap:
self.printid("Parsed %u records (failed: %u) from imap" % (count, bad))
else:
self.printid(
"Parsed %s/%s: %u records (failed: %u) from %s"
% (ml, mboxfile, count, bad, tmpname)
)
os.unlink(tmpname)
goodies += count
baddies += bad
if len(ja) > 0 and not args.dry:
bulk_insert_both(self.name, ja, jas, es)
ja = []
jas = []
self.printid("Done, %u elements left to slurp" % len(lists))
parser = argparse.ArgumentParser(description="Command line options.")
parser.add_argument(
"--source",
dest="source",
type=str,
nargs=1,
help="Source to scan (http(s)://, imap(s):// or file path)",
)
parser.add_argument(
"--dir", dest="dir", action="store_true", help="Input is in Maildir format"
)
parser.add_argument(
"--interactive",
dest="interactive",
action="store_true",
help="Ask for help when possible",
)
parser.add_argument(
"--quick",
dest="quick",
action="store_true",
help="Only grab the first file you can find",
)
parser.add_argument(
"--mod-mbox",
dest="modmbox",
action="store_true",
help="This is mod_mbox, derive list-id and files from it",
)
parser.add_argument(
"--pipermail",
dest="pipermail",
action="store_true",
help="This is pipermail, derive files from it (list ID has to be set!)",
)
parser.add_argument(
"--lid",
dest="listid",
type=str,
nargs=1,
help="Optional List-ID to override source with. Format: <list-name>@<domain>",
)
parser.add_argument(
"--project",
dest="project",
type=str,
nargs=1,
help="Optional project to look for ($project-* will be imported as well)",
)
parser.add_argument(
"--ext",
dest="ext",
type=str,
nargs=1,
help='Optional file extension e.g. ".gz" (or call it with an empty string to not care)',
)
parser.add_argument(
"--domain",
dest="domain",
type=str,
nargs=1,
help="Optional domain extension for MIDs and List ID reconstruction)",
)
parser.add_argument(
"--private",
dest="private",
action="store_true",
help="This is a privately archived list. Filter through auth proxy.",
)
parser.add_argument(
"--dry",
dest="dry",
action="store_true",
help="Do not save emails to elasticsearch, only test importing",
)
parser.add_argument(
"--dump",
dest="dump",
type=str,
nargs=1,
help="Dump mbox json (only if dry-run)",
)
parser.add_argument(
"--verbose",
dest="verbose",
action="store_true",
help="Show details of generated id (for use with --dry)",
)
parser.add_argument(
"--logger_level",
dest="logger_level",
type=str,
nargs=1,
help="Set 'elasticsearch' logging level (e.g. 'INFO')",
)
parser.add_argument(
"--trace_level",
dest="trace_level",
type=str,
nargs=1,
help="Set 'elasticsearch.trace' logging level (e.g. 'INFO')",
)
parser.add_argument(
"--duplicates",
dest="dups",
action="store_true",
help="Detect duplicate mids in this run",
)
parser.add_argument(
"--html2text",
dest="html2text",
action="store_true",
help="If no text/plain is found, try to parse HTML using html2text",
)
parser.add_argument(
"--requirelid",
dest="requirelid",
action="store_true",
help="Require a List ID to be present, ignore otherwise",
)
parser.add_argument(
"--dedup",
dest="dedup",
action="store_true",
help="Don't import a message if its Message-Id already exists on the list",
)
parser.add_argument(
"--overwrite",
dest="overwrite",
action="store_true",
help="Allow incoming messages to overwrite existing entries (can result in data loss)",
)
parser.add_argument(
"--ignorebody",
dest="ibody",
type=str,
nargs=1,
help="Optional email bodies to treat as empty (in conjunction with --html2text)",
)
parser.add_argument(
"--resend",
dest="resend",
type=str,
nargs=1,
help="DANGER ZONE: Resend every read email to this recipient as a new email",
)
parser.add_argument(
"--timeout",
dest="timeout",
type=int,
nargs=1,
help="Optional timeout in secs for importing an mbox/maildir file (default is %d seconds)" % TIMEOUT_DEFAULT,
)
parser.add_argument(
"--filter",
dest="fromfilter",
type=str,
nargs=1,
help="Optional sender filter: Only import emails from this address",
)
parser.add_argument(
"--nomboxo", dest="nomboxo", action="store_true", help="Skip Mboxo processing"
)
parser.add_argument("--generator", dest="generator", help="Override the generator.")
args = parser.parse_args()
if len(sys.argv) <= 2:
parser.print_help()
sys.exit(-1)
if args.source:
source = args.source[0]
if args.dir:
maildir = args.dir
if args.listid:
list_override = textlib.normalize_lid(args.listid[0], strict=True)
if list_override is None:
raise ValueError("Invalid list-ID provided")
if args.project:
project = args.project[0]
if args.domain:
appender = args.domain[0]
if args.interactive:
interactive = args.interactive
if args.quick:
quickmode = args.quick
if args.private:
private = args.private
if args.dedup:
dedup = args.dedup
if args.ext:
extension = args.ext[0]
if args.fromfilter:
fromFilter = args.fromfilter[0]
if args.nomboxo:
noMboxo = args.nomboxo
else:
# Temporary patch to fix Python email package limitation
# It must be removed when the Python package is fixed
if not __package__:
from plugins.mboxo_patch import MboxoFactory, MboxoReader
else:
from .plugins.mboxo_patch import MboxoFactory, MboxoReader
if args.resend:
resendTo = args.resend[0]
from smtplib import SMTP
if args.timeout:
timeout = args.timeout[0]
baddies = 0
verbose_logger = None
if args.verbose:
verbose_logger = logging.getLogger("verbose")
verbose_logger.setLevel(logging.INFO)
# The default handler is set to WARN level
verbose_logger.addHandler(logging.StreamHandler(sys.stdout))
archiver.logger = verbose_logger
if args.dry:
print("Dry-run; continuing to check input data")
if args.dump:
print("Writing mbox output to %s" % args.dump[0])
dumpfile = open(args.dump[0], 'w')
dumpfile.write("[\n")
else:
# Fetch config and set up ES
es = Elastic(
logger_level=args.logger_level[0] if args.logger_level else None,
trace_level=args.trace_level[0] if args.trace_level else None
)
# No point continuing if the index does not exist
print("Checking that the database index %s exists ... " % es.db_mbox)
# Need to check the index before starting bulk operations
try:
if not es.indices.exists(index=es.db_mbox):
print("Error: the index '%s' does not exist!" % (es.db_mbox))
sys.exit(1)
print("Database exists OK")
except Exception as err:
print("Error: unable to check if the index %s exists!: %s" % (es.db_mbox, err))
sys.exit(1)
def glob_dir(d):
dirs = [f for f in listdir(d) if isdir(join(d, f))]
mboxes = [f for f in glob.glob(join(d, "*" + extension)) if isfile(f)]
if not d in fileToLID and len(mboxes) > 0 and interactive:
print("Would you like to set a list-ID override for %s?:" % d)
lo = sys.stdin.readline()
if lo and len(lo) > 3:
fileToLID[d] = textlib.normalize_lid(lo.strip("\r\n"))
print("Righto, setting it to %s." % fileToLID[d])
else:
print("alright, I'll try to figure it out myself!")
for fi in sorted(mboxes):
lists.append([fi, fileToLID.get(d) if fileToLID.get(d) else list_override])
for nd in sorted(dirs):
glob_dir(join(d, nd))
# HTTP(S) based import?
if re.match(r"https?://", source):
data = urlopen(source).read().decode("utf-8")
print("Fetched %u bytes of main data, parsing month lists" % len(data))
if project:
# ensure there is a '-' between project and list name otherwise we match too much
# Note: It looks like mod_mbox always uses single quoted hrefs
ns = r"<a href='(%s-[-a-z0-9]+)/'" % project
if project.find("-") != -1:
ns = r"<a href='(%s)/'" % project
else: # match all possible project names
ns = r"<a href='([-a-z0-9]+)/'"
if args.modmbox:
for mlist in re.finditer(ns, data):
ml = mlist.group(1)
mldata = urlopen("%s%s/" % (source, ml)).read().decode("utf-8")
present = re.search(
r"<th colspan=\"3\">Year 20[\d]{2}</th>", mldata
) # Check that year 2014-2017 exists, otherwise why keep it?
if present:
qn = 0
for mbox in re.finditer(r"(\d+\.mbox)/thread", mldata):
qn += 1
mboxfile = mbox.group(1)
lists.append([ml, mboxfile])
print("Adding %s/%s to slurp list" % (ml, mboxfile))
if quickmode and qn >= 2:
break
if args.pipermail:
filebased = True
piperWeirdness = True
if not list_override:
print(
"You need to specify a list ID with --lid when importing from Pipermail!"
)
sys.exit(-1)
ns = r"href=\"(\d+(?:-[a-zA-Z]+)?\.txt(\.gz)?)\""
qn = 0
dl_threads = []
for mlist in re.finditer(ns, data):
ml = mlist.group(1)
dl_thread = DownloadThread()
dl_thread.assign("%s%s" % (source, ml))
dl_thread.start()
dl_threads.append(dl_thread)
qn += 1
if quickmode and qn >= 2:
break
for done_dl_t in dl_threads:
done_dl_t.join()
# IMAP(S) based import?
elif re.match(r"imaps?://", source):
imap = True
import getpass
import imaplib
import urllib
url = urllib.parse.urlparse(source)
port = url.port or (143 if url.scheme == "imap" else 993)
user = url.username or getpass.getuser()
password = url.password or getpass.getpass("IMAP Password: ")
folder = url.path.strip("/") or "INBOX"
listname = list_override or "<%s/%s.%s>" % (user, folder, url.hostname)
# fetch message-id => _id pairs from elasticsearch
result = es.search(
scroll="5m",
body={
"size": 1024,
"fields": ["message-id"],
"query": {"match": {"list": listname}},
},
)
db = {}
while len(result["hits"]["hits"]) > 0:
for hit in result["hits"]["hits"]:
db[hit["fields"]["message-id"][0]] = hit["_id"]
result = es.scroll(scroll="5m", scroll_id=result["_scroll_id"])
# fetch message-id => uid pairs from imap
if url.hostname is not None:
if url.scheme == "imap":
imap4 = imaplib.IMAP4(url.hostname, port)
elif url.scheme == "imaps":
imap4 = imaplib.IMAP4_SSL(url.hostname, port)
else:
raise Exception("Hostname not found in IMAP source URL")
imap4.login(user, password)
imap4.select(folder, readonly=True)
results = imap4.uid("search", "ALL")
uids = b",".join(results[1][0].split()).decode("ascii")
results = imap4.uid("fetch", uids, "(BODY[HEADER.FIELDS (MESSAGE-ID)])")
mail = {}
uid_re = re.compile(b"^\\d+ \\(UID (\\d+) BODY\\[")
mid_re = re.compile(b"^Message-ID:\\s*(.*?)\\s*$", re.I)
uid = None
for result in results[1]:
for line in result:
if isinstance(line, bytes):
match = uid_re.match(line)
if match:
uid = match.group(1)
else:
match = mid_re.match(line)
if match:
try:
mail[match.group(1).decode("utf-8")] = uid
uid = None
except ValueError:
pass
# delete items from elasticsearch that are not present in imap
queue1 = []
queue2 = []
for mid, _id in db.items():
if mid not in mail:
queue1.append(
{
"_op_type": "delete",
"_index": es.db_mbox,
"_type": "_doc",
"_id": _id,
}
)
queue2.append(
{
"_op_type": "delete",
"_index": es.db_source,
"_type": "_doc",
"_id": _id,
}
)
print("deleting: " + mid)
while len(queue1) > 0:
es.bulk(queue1[0:1024])
del queue1[0:1024]
while len(queue2) > 0:
es.bulk(queue2[0:1024])
del queue2[0:1024]
# add new items to elasticsearch from imap
new_uids = []
for mid, uid in mail.items():
if mid not in db:
new_uids.append(uid)
lists.append([new_uids, listname, imap4])
else:
# File based import??
print("Doing file based import")
filebased = True
if maildir:
lists.append(
[source, fileToLID.get(source) if fileToLID.get(source) else list_override]
)
else:
if os.path.isfile(source):
lists.append(
[
source,
fileToLID.get(source) if fileToLID.get(source) else list_override,
]
)
else:
glob_dir(source)
threads = []
# Don't start more threads than there are lists
cc = min(len(lists), int(multiprocessing.cpu_count() / 2) + 1)
print("Starting up to %u threads to fetch the %u %s lists" % (cc, len(lists), project))
for i in range(1, cc + 1):
t = SlurpThread()
threads.append(t)
t.start()
print("Started no. %u" % i)
for t in threads:
t.join()
if args.dups:
print("Showing duplicate ids:")
for mid in duplicates:
if len(duplicates[mid]) > 1:
print("The mid %s was used by:" % mid)
for msg in duplicates[mid]:
print(msg)
if dumpfile:
dumpfile.write("]\n")
dumpfile.close()
if args.overwrite:
print(
"All done! %u records processed (including %u replacements) after %u seconds. %u records were bad and ignored."
% (goodies, replacements, int(time.time() - start), baddies)
)
else:
print(
"All done! %u records inserted after %u seconds. %u records were bad and ignored. %u duplicates were ignored."
% (goodies, int(time.time() - start), baddies, dupes)
)
if dedupped > 0:
print("%u records were not inserted due to deduplication" % dedupped)