def get_app_data():
application = DBConnection('application')
links = DBConnection('links')
return {
'title': application.find()[ 0 ],
'header': links.find()
}
def insert_companies(companies):
techDb = DBConnection('companies')
new_list = [Company.load_from_json(company) for company in companies]
for company in new_list:
company.is_valid() and techDb.update(company.to_json(), 'companyId')
return {'companies': techDb.find()}
def get_app_data():
application = DBConnection('application')
links = DBConnection('links')
try:
app_config = application.find()
result = dict()
for config in app_config:
result[ config.get('configName') ] = config.get('value')
except:
result = None
return {
'applicationConfig': result,
'header': {
'list': links.find(),
}
}
def insert_projects(project):
project_db = DBConnection('projects')
project_db.update(project, 'projectId')
return {
'projects':
project_db.find({'projectId': project.get('projectId', None)})
}
def get_user_by_username(username, n=None):
db = DBConnection('users')
user = db.find({'username': username})
if not len(user):
raise UserNotFound()
if n is None:
return user
else:
return user[int(n)]
def get_all_app_config():
application = DBConnection('application')
try:
app_config = application.find()
result = dict()
for config in app_config:
result[ config.get('configName') ] = config.get('value')
except:
result = None
return {
'applicationConfig': result
}
def get_companies():
techDb = DBConnection('companies')
return {'companies': techDb.find()}
def remove_companies(companies):
techDb = DBConnection('companies')
techDb.delete_all(companies, 'companyId')
return {'companies': techDb.find()}
def remove_projects(projects):
project_db = DBConnection('projects')
project_db.delete_all(projects, 'projectId')
return {'projects': project_db.find()}
def get_projects():
project_db = DBConnection('projects')
return {'projects': project_db.find()}
def get_experiences():
experiences = DBConnection('experiences')
return {
'experiences': experiences.find()
}
def insert_technology(skill):
techDb = DBConnection('technologies')
techDb.update(skill, 'techId')
return {'technologies': techDb.find({'techId': skill.get('techId', None)})}
def get_technologies():
techDb = DBConnection('technologies')
return {'technologies': techDb.find()}
