import re
import os
import StringIO
import psycopg2

#DSN = "dbname=pnegron"

file = '/Users/pnegron/Desktop/SCRIPT-TESTING/R1.cfg'

test = open(file,'r')

text = test.read()

test.close()

text1 = re.search(r'NAME:\s\D(.+)\D.*DESCR:\s(.*)', text)
print text1.group(1).strip(' \",')
#text2 = re.search(r'(SN:\s)([0-9].*)', text)
#text3 = re.findall(r'(NAME:\s.*)(DESCR:\s.*)', text)
#text4 = re.findall(r'(SN:)\s([0-9].)', text)
#text5 = re.search(r'Chassis', text)
#print text1.group(1)
#print text1.group(1).strip(" ,")
#print newtext
#newtext3 = text1.group(2)
#newtext2 = text2.group(2)
#print text3
#print text5.group()
#print text1.group(1)
#print text1.group(2)
#print text2.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()