def createNewJob(self, contentName, contentID, keyword, content):
con = None
try:
con = psycopg2.connect(database='d1s3idai1l2u3d', user='******', password='******', host='ec2-54-197-241-24.compute-1.amazonaws.com', port='5432', sslmode='require')
cur = con.cursor()
except psycopg2.DatabaseError as e:
print ('Error %s' % e)
sys.exit(1)
finally:
if con:
cur.execute("SELECT * FROM resume");
rows = cur.fetchall()
numRows = (len(rows))
newJob = JobDescNode(contentID, keyword, content)
if (numRows == 0):
ResumeProcessor.construct(newJob)
toPrint = encodeClassToJson(newJob)
cur.execute("INSERT INTO job VALUES (%s,%s,%s,%s)",(toPrint,'f', contentID ,contentName))
con.commit()
else:
ResumeProcessor.construct(newJob)
toPrint = encodeClassToJson(newJob)
cur.execute("INSERT INTO job VALUES (%s,%s,%s,%s)",(toPrint,'f', contentID ,contentName))
con.commit()
f = Facade()
matcher = Matcher(f)
scorer = Scorer(f)
matcher.matchAll(2)
scorer.calculateScore()
con.close()
def createNewResume(self, name, hpNumber, email, contentName, content):
con = None
try:
con = psycopg2.connect(
database='d1s3idai1l2u3d',
user='******',
password='******',
host='ec2-54-197-241-24.compute-1.amazonaws.com',
port='5432',
sslmode='require')
cur = con.cursor()
except psycopg2.DatabaseError as e:
print('Error %s' % e)
sys.exit(1)
finally:
if con:
cur.execute("SELECT * FROM job")
rows = cur.fetchall()
numRows = (len(rows))
newResume = ResumeNode(name, hpNumber, email, contentName,
content)
if (numRows == 0):
ResumeProcessor.construct(newResume)
toPrint = encodeClassToJson(newResume)
cur.execute(
"INSERT INTO resume VALUES (%s,%s,%s,%s,%s,%s)",
(toPrint, 'f', contentName, name, hpNumber, email))
con.commit()
else:
ResumeProcessor.construct(newResume)
toPrint = encodeClassToJson(newResume)
cur.execute(
"INSERT INTO resume VALUES (%s,%s,%s,%s,%s,%s)",
(toPrint, 'f', contentName, name, hpNumber, email))
con.commit()
f = Facade()
matcher = Matcher(f)
scorer = Scorer(f)
matcher.matchAll(1)
scorer.calculateScore()
con.close()
def storeMatchBoxes(self,mboxes):
con = None
try:
con = psycopg2.connect(database='d1s3idai1l2u3d', user='******', password='******', host='ec2-54-197-241-24.compute-1.amazonaws.com', port='5432', sslmode='require')
cur = con.cursor()
except psycopg2.DatabaseError as e:
print ('Error %s' % e)
sys.exit(1)
finally:
for xx in mboxes:
toPrintTwo = encodeClassToJson(xx)
cur.execute("INSERT INTO matchbox VALUES (%s)",(toPrintTwo,))
con.commit()
con.close()
def storeMatchBoxes(self, mboxes):
con = None
try:
con = psycopg2.connect(
database='d1s3idai1l2u3d',
user='******',
password='******',
host='ec2-54-197-241-24.compute-1.amazonaws.com',
port='5432',
sslmode='require')
cur = con.cursor()
except psycopg2.DatabaseError as e:
print('Error %s' % e)
sys.exit(1)
finally:
for xx in mboxes:
toPrintTwo = encodeClassToJson(xx)
cur.execute("INSERT INTO matchbox VALUES (%s)", (toPrintTwo, ))
con.commit()
con.close()
def addMatchBoxes(self, mboxes):
con = None
try:
con = psycopg2.connect(
database="d1s3idai1l2u3d",
user="******",
password="******",
host="ec2-54-197-241-24.compute-1.amazonaws.com",
port="5432",
sslmode="require",
)
cur = con.cursor()
except psycopg2.DatabaseError as e:
print("Error %s" % e)
sys.exit(1)
finally:
for xx in mboxes:
toPrintTwo = encodeClassToJson(xx)
cur.execute("INSERT INTO matchbox VALUES (%s)", (toPrintTwo,))
con.commit()
con.close()
con = None
try:
con = psycopg2.connect(database='d1s3idai1l2u3d', user='******', password='******', host='ec2-54-197-241-24.compute-1.amazonaws.com', port='5432', sslmode='require')
cur = con.cursor()
except psycopg2.DatabaseError as e:
print ('Error %s' % e)
sys.exit(1)
finally:
if con:
cur.execute("SELECT * FROM resume");
rows = cur.fetchall()
numRows = (len(rows))
newJob = JobDescNode(contentID, contentFile, keyword)
if (numRows == 0):
ResumeProcessor.construct(newJob)
toPrint = encodeClassToJson(newJob)
cur.execute("INSERT INTO job VALUES (%s,%s,%s,%s)",(toPrint,'f', contentID ,contentName))
con.commit()
print('just store job')
else:
ResumeProcessor.construct(newJob)
toPrint = encodeClassToJson(newJob)
cur.execute("INSERT INTO job VALUES (%s,%s,%s,%s)",(toPrint,'f', contentID ,contentName))
con.commit()
f = Facade()
matcher = Matcher(f)
scorer = Scorer(f)
cur.execute("SELECT isonce_resume FROM once")
rows = cur.fetchall()
for row in rows:
if(row[0] is True):
con = None
try:
con = psycopg2.connect(database='d1s3idai1l2u3d', user='******', password='******', host='ec2-54-197-241-24.compute-1.amazonaws.com', port='5432', sslmode='require')
cur = con.cursor()
except psycopg2.DatabaseError as e:
print ('Error %s' % e)
sys.exit(1)
finally:
if con:
cur.execute("SELECT * FROM job");
rows = cur.fetchall()
numRows = (len(rows))
if (numRows == 0):
ResumeProcessor.construct(newResume)
toPrint = encodeClassToJson(newResume)
#print(type(newResume.getContent()))
print(toPrint)
cur.execute("INSERT INTO resume VALUES (%s,%s,%s,%s,%s,%s)",(toPrint,'f',contentName,name,hpNumber,email))
con.commit()
else:
ResumeProcessor.construct(newResume)
toPrint = encodeClassToJson(newResume)
#print(type(newResume.getContent()))
print(toPrint)
cur.execute("INSERT INTO resume VALUES (%s,%s,%s,%s,%s,%s)",(toPrint,'f',contentName,name,hpNumber,email))
con.commit()
f = Facade()
matcher = Matcher(f)
scorer = Scorer(f)
cur.execute("SELECT isonce_resume FROM once")
host='ec2-54-197-241-24.compute-1.amazonaws.com',
port='5432',
sslmode='require')
cur = con.cursor()
except psycopg2.DatabaseError as e:
print('Error %s' % e)
sys.exit(1)
finally:
if con:
cur.execute("SELECT * FROM job")
rows = cur.fetchall()
numRows = (len(rows))
if (numRows == 0):
ResumeProcessor.construct(newResume)
toPrint = encodeClassToJson(newResume)
#print(type(newResume.getContent()))
print(toPrint)
cur.execute("INSERT INTO resume VALUES (%s,%s,%s,%s,%s,%s)",
(toPrint, 'f', contentName, name, hpNumber, email))
con.commit()
else:
ResumeProcessor.construct(newResume)
toPrint = encodeClassToJson(newResume)
#print(type(newResume.getContent()))
print(toPrint)
cur.execute("INSERT INTO resume VALUES (%s,%s,%s,%s,%s,%s)",
(toPrint, 'f', contentName, name, hpNumber, email))
con.commit()
f = Facade()
matcher = Matcher(f)
