from pymongo import MongoClient
import csv
import sys

def pfl(val):
  try:
    return float(val)
  except:
    return None

with open(sys.argv[1]) as csvfile:
  collec = MongoClient()["galaxy"]["comets"]
  for row in csv.reader(csvfile, delimiter="\t"):
    try:
      collec.insert({"name":row[0],"observer":row[1],"type":row[2],"period":pfl(row[3]), "ecc":pfl(row[4]),"semaj_axs":pfl(row[5]), "perih_dist":pfl(row[6]), "incl":pfl(row[7]), "abs_mag":pfl(row[8])})
    except:
      print "Error: could not import: ", row