import MySQLdb
import csv

def pN(inp): 
 if len(str(inp).strip())==0: 
  return -99.99
 return inp 


conn = MySQLdb.connect(host = "localhost",user = "root",passwd = "",unix_socket="/home/belikov/mysql/mysql.sock",read_default_file="/home/belikov/mysql/my.cnf")
cursor = conn.cursor ()
cursor.execute ("USE PROB")
cursor.execute ("DROP TABLE USNOA2")
create_str ="CREATE TABLE USNOA2 (ID INT,RA2000 DOUBLE,DEC2000 DOUBLE,USNOID CHAR(13),ACTFLAG CHAR(1),MFLAG CHAR(1),BMAG DOUBLE,RMAG DOUBLE,EPOCH DOUBLE,PRIMARY KEY (ID))"

cursor.execute (create_str)


inp_file=csv.reader(open('usnoa2.data'),delimiter="|",quoting=csv.QUOTE_NONE)
i=0
for row in inp_file: 
  if len(row)==0: break 
  i=i+1
  ins_str="INSERT INTO USNOA2 VALUES(%i,%s,%s,\'%s\',\'%s\',\'%s\',%s,%s,%s)" % (i,row[4],row[5],row[3],row[6],row[7],pN(row[8]),pN(row[9]),pN(row[10]))
  print ins_str
  cursor.execute(ins_str)

cursor.close ()
conn.close ()