import re
  import os
  import StringIO
  import psycopg2
  import simplejson as json
  
  DSN = "dbname=pnegron"
  
  file = '/Users/pnegron/Desktop/SCRIPT-TESTING/R1.cfg'
  
  test = open(file,'r')
  
  text = test.read()
  
  test.close()
  
  text3 = re.search(r'NAME:\s\D([a-zA-Z]*).*\n.*SN:\s([0-9]*)', text)
  
  #print text
  #print text3.groups
  print text3.group(1)
  print text3.group(2)
  
  
  
  #print "Opening connection using dsn:", DSN
  #conn = psycopg2.connect(DSN)
  #print "Encoding for this connection is", conn.encoding
  
  #curs = conn.cursor()
  #try:
  #    curs.execute("CREATE TABLE cisco_devices (device text, Serial_No text, Description text)")
  #except:
  #    conn.rollback()
  #    curs.execute("DROP TABLE cisco_devices")
  #    curs.execute("CREATE TABLE cisco_devices (device text, Serial_No text, Description text)")
  #conn.commit()
  
  ## demostrate copy_to functionality
  #data = [(newtext, newtext2, newtext3)]
  #query = "INSERT INTO cisco_devices VALUES (%s,%s,%s)"
  #curs.executemany(query, data)
  #conn.commit()