dokucama

This is an old revision of the document!

---

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()