// Copyright: (C) 2010 Nicolas Palix, Suman Saha, Gael Thomas, Christophe Calves, Julia Lawall, Gilles Muller, LIP6, INRIA, DIKU.  GPLv2.

@initialize:python@

import psycopg2
conn = psycopg2.connect("dbname={database name} user={username}")
curs = conn.cursor()

def add_note(ty,pos,src):
 for q in pos:
  file = "%s" % q.file
  line = "%s" % q.line
  colb = "%s" % q.column
  cole = "%s" % q.column_end
  front = file.partition("-")
  front = front[2].partition("/")
  version = front[0]
  file = front[2]
  str = "insert into notes (file_id,data_source,note_error_name,line_no,column_start,column_end,text_link) values (get_file('linux-%s','%s'),'%s','%s',%s,%s,%s,'%s')" % (version,file,src,ty,line,colb,cole,ty)

  try:
    curs.execute(str)
  except (psycopg2.InternalError,psycopg2.IntegrityError) as e:
    print e
    print str
  except:
    print "UNKNOWN ERROR"
    print str
  conn.commit()

@finalize:python@
curs.close()
conn.close()