def get(self, tech_id):
conn = sqlite3.connect('lbg.db')
cursor = conn.cursor()
appl = cursor.execute(
'''select * from applications where userSolverId="%s"''' %
(tech_id))
for u in appl:
result = Application(u)
print(result.getFullInfo())
return jsonify(result.getFullInfo())
def new_application():
# company attributes
company_name = request.form.get('company_name')
website = request.form.get('website')
# job attributes
title = request.form.get('title')
link = request.form.get('link')
source = request.form.get('source')
# application status attributes
status = request.form.get('status')
application = Application()
db.session.add(application)
company = db.session.query(Company) \
.filter((Company.company_name==company_name) & (Company.website==website)) \
.first()
if not company:
company = Company(company_name=company_name,
website=website)
db.session.add(company)
db.session.commit()
job = db.session \
.query(Job) \
.filter(Job.title==title, Job.link==link, Job.source==source, Job.company==company) \
.first()
if not job:
job = Job(title=title, link=link, source=source)
db.session.add(job)
company.jobs.append(job)
db.session.commit()
application_status = ApplicationStatus(status=status)
db.session.add(application_status)
current_user.applications.append(application)
job.applications.append(application)
application.application_statuses.append(application_status)
db.session.commit()
# TODO: point entry for new application
return jsonify({
'application_id': application.application_id,
'title': job.title,
'company_name': company.company_name,
'status': application_status.status,
})
def seed1():
datetime_applied, datetime_created = datetime.now(), datetime.now()
user = User(email='*****@*****.**',
password='******',
first_name='First',
last_name='Last',
datetime_created=datetime_created)
db.session.add(user)
company = Company(company_name='My Company',
website='www.mycompany.com',
datetime_created=datetime_created)
db.session.add(company)
db.session.commit()
job = Job(company_id=company.company_id,
title='Software Engineer',
link='www.linkedin.com/mycompany/software-engineer',
source='LinkedIn',
datetime_created=datetime_created
)
db.session.add(job)
db.session.commit()
application = Application(user_id=user.user_id,
job_id=job.job_id,
datetime_applied=datetime_applied,
referred_by="Anjelica",
datetime_created=datetime_created)
db.session.add(application)
db.session.commit()
application_status = ApplicationStatus(application_id=application.application_id,
status='Applied',
experience_rating='positive',
datetime_created=datetime_created)
db.session.add(application_status)
journal_entry = JournalEntry(application_id=application.application_id,
entry='This is a journal entry.',
datetime_created=datetime_created)
db.session.add(journal_entry)
db.session.commit()
def seed2():
datetime_applied, datetime_created = datetime.now(), datetime.now()
user = User.query.first()
company = db.session.query(Company).filter(Company.company_name.like('%Another Company%')).first()
if not company:
company = Company(company_name='Another Company',
website='www.anothercompany.com',
datetime_created=datetime_created)
db.session.add(company)
db.session.commit()
job = db.session.query(Job).filter(Job.company_id==company.company_id, Job.title.like('%Software Engineer%')).first()
if not job:
job = Job(company_id=company.company_id,
title='Software Engineer',
link='www.linkedin.com/anothercompany/software-engineer',
source='Glassdoor',
datetime_created=datetime_created)
db.session.add(job)
db.session.commit()
application = Application(user_id=user.user_id,
job_id=job.job_id,
datetime_applied=datetime_applied,
referred_by="Anjelica",
datetime_created=datetime_created)
db.session.add(application)
db.session.commit()
application_status = ApplicationStatus(application_id=application.application_id,
status='Applied',
experience_rating='positive',
datetime_created=datetime_created)
db.session.add(application_status)
journal_entry = JournalEntry(application_id=application.application_id,
entry='Another journal entry.',
datetime_created=datetime_created)
db.session.add(journal_entry)
db.session.commit()
class testModel(unittest.TestCase):
calculator = Application()
def test_add(self):
self.calculator.compute_box = 14
self.calculator.add_button_fired()
self.calculator.compute_box = 20
self.calculator.eval_expr()
self.assertEqual(self.calculator.compute_box, 34)
self.calculator.compute_box = 14.0
self.calculator.add_button_fired()
self.calculator.compute_box = 20
self.calculator.eval_expr()
self.assertEqual(self.calculator.compute_box, 34.0)
self.calculator.compute_box = 14.65
self.calculator.add_button_fired()
self.calculator.compute_box = 20.09
self.calculator.eval_expr()
self.assertEqual(self.calculator.compute_box, 34.74)
def test_sub(self):
self.calculator.compute_box = 14
self.calculator.subtract_button_fired()
self.calculator.compute_box = 20
self.calculator.eval_expr()
self.assertEqual(self.calculator.compute_box, -6)
self.calculator.compute_box = 14.0
self.calculator.subtract_button_fired()
self.calculator.compute_box = 10
self.calculator.eval_expr()
self.assertEqual(self.calculator.compute_box, 4.0)
self.calculator.compute_box = 14.65
self.calculator.subtract_button_fired()
self.calculator.compute_box = 20.09
self.calculator.eval_expr()
self.assertEqual(self.calculator.compute_box, -5.44)
def test_div(self):
self.calculator.compute_box = 14
self.calculator.div_button_fired()
self.calculator.compute_box = 20
self.calculator.eval_expr()
# fails because we do floor division for integers!
self.assertEqual(self.calculator.compute_box, 0.7)
self.calculator.compute_box = 14.0
self.calculator.div_button_fired()
self.calculator.compute_box = 10
self.calculator.eval_expr()
self.assertEqual(self.calculator.compute_box, 1.40)
self.calculator.compute_box = 1
self.calculator.div_button_fired()
self.calculator.compute_box = 20
self.calculator.eval_expr()
self.assertEqual(self.calculator.compute_box, 0.05)
def test_mul(self):
self.calculator.compute_box = 14
self.calculator.mul_button_fired()
self.calculator.compute_box = 20
self.calculator.eval_expr()
# fails because we do floor division for integers!
self.assertEqual(self.calculator.compute_box, 280)
self.calculator.compute_box = 14.0
self.calculator.mul_button_fired()
self.calculator.compute_box = 10
self.calculator.eval_expr()
self.assertEqual(self.calculator.compute_box, 140.0)
self.calculator.compute_box = 1.1
self.calculator.mul_button_fired()
self.calculator.compute_box = 20.4
self.calculator.eval_expr()
self.assertEqual(self.calculator.compute_box, 22.44)