del rdict["primary_source_1"] del rdict["primary_source_2"] rdict["active"] = True rdict["submitted_by"] = migtools.mig_user try: entry = BilateralTradeDataEntry(**rdict) if entry.imports == "-9": if entry.exports == "-9": sys.stdout.write("[%i] %s - %s (dropped; missing data)\n" % (i, entry.location, entry.trade_partner)) continue else: entry.imports = None elif entry.exports == "-9": entry.exports == None else: # TEMPORARY: add only entries with missing data sys.stdout.write("[%i] %s - %s (ignored for now)\n" % (i, entry.location, entry.trade_partner)) continue entry.save() num_mig += 1 sys.stdout.write("[%i] %s - %s\n" % (i, entry.location, entry.trade_partner)) except (ValueError, DatabaseError, ValidationError) as e: sys.stderr.write('Failed to save data row (%i): %s\n' % (i, e)) num_err_rows += 1 print 'Migration complete. %i rows migrated, %i locations created, and %i row errors encountered and ignored' % (num_mig, num_locs, num_err_rows)