def createProjects(mnd_dataset, allergies_dataset, labels_added_mnd, labels_added_allergies, user1, user2): mnd_desc = 'annotating gp referral letters to identify patients that might need to be fast tracked to the MND clinic ' project = Project(name='mnd', dataset=mnd_dataset, description=mnd_desc, labels=labels_added_mnd, users=[user1, user2]) db.session.add(project) allergies_desc = 'allergies project doing some annotation' project2 = Project(name='allergies project', dataset=allergies_dataset, description=allergies_desc, labels=labels_added_allergies, users=[user2]) db.session.add(project2) db.session.commit() # Associate Labels with Project db.session.execute(projectlabel_association.insert().values([ (project.id, labels_added_mnd[0].id), (project.id, labels_added_mnd[1].id) ]))
def save_project_info(session, proj_dict): ''' Save a dictionary of project info to the datastore session. Return an app.Project instance. ''' # Select the current project, filtering on name AND organization. filter = Project.name == proj_dict[ 'name'], Project.organization_name == proj_dict['organization_name'] existing_project = session.query(Project).filter(*filter).first() # If this is a new project, save and return it. if not existing_project: new_project = Project(**proj_dict) session.add(new_project) return new_project # Preserve the existing project # :::here (project/true) existing_project.keep = True # Update existing project details for (field, value) in proj_dict.items(): setattr(existing_project, field, value) return existing_project
def save_project_info(session, proj_dict): ''' Save a dictionary of project info to the datastore session. Return an app.Project instance. ''' # Select the current project, filtering on name AND organization. filter = Project.name == proj_dict[ 'name'], Project.organization_name == proj_dict['organization_name'] existing_project = session.query(Project).filter(*filter).first() # If this is a new project, save and return it. if not existing_project: new_project = Project(**proj_dict) session.add(new_project) return new_project # Mark the existing project for safekeeping. existing_project.keep = True # Update existing project details for (field, value) in proj_dict.items(): setattr(existing_project, field, value) # Flush existing object, to prevent a sqlalchemy.orm.exc.StaleDataError. session.flush() return existing_project
def newProject(self): self.mainDialog.PreparedArea.clear() self.mainDialog.ThroughArea.clear() self.mainDialog.BacklightArea.clear() self.mainnodes = [Node("Samples"), Node("Other")] self.project_tree.setMainNodes(self.mainnodes) self.project = Project('TEMP') self.refresh()
def test_one(client): q = db_session.query(Project).all() assert len(q) == 0 project = Project(name='hey', evernote='google', description='potato') db_session.add(project) db_session.commit() q = db_session.query(Project).all() assert len(q) == 1
def post_project(): req_data = request.get_json() print(req_data) project = Project(req_data['title'], req_data['userId'], req_data['description'], req_data['totalCost'], req_data['totalTime'], req_data['auth0subject']) db.session.add(project) db.session.commit() result = project_schema.dump(project) print(result) return jsonify(result.data)
def create_prject(): args = request.get_json() if request.is_json else request.args is_present = Project.query.filter_by(title=args['title']).first() if is_present is None: owner = User.query.filter_by(id=args['participants'][0]).first() project = Project( title=args['title'], description=args['description'] ) owner.projects.append(project) db.session.add_all([project, owner]) db.session.commit() res = { 'new entry?': is_present == None, 'operation': 'create_prject', 'args': args, 'Host': request.headers['Host'], } return jsonify(res)
def project_init(self): self.project = Project('New')
return data if __name__ == '__main__': for org in get_orgs(): print >> stderr, 'Found', org['name'], 'with projects at', org[ 'projects_url'] got = get(org['projects_url']) data = list(DictReader(StringIO(got.text), dialect='excel-tab')) shuffle(data) for row in data: row = update_project_info(row) print row kwargs = dict(name=row.get('name', None), code_url=row.get('code_url', None), link_url=row.get('link_url', None), description=row.get('description', None), type=row.get('type', None), category=row.get('category', None)) project = Project(**kwargs) db.session.add(project) db.session.commit()
from app import db, User, Project, Vote # Create all the tables db.create_all() # create Projects education = Project(name='Gift an education...Make a life !') health = Project(name='Less Privileged Elders Need Care & Meal Support') # add projects to session db.session.add(education) db.session.add(health) # commit the projects to database db.session.commit()
from flask import Flask, request, send_file from flask_cors import CORS from app import Project from json import dumps, loads from bson.json_util import dumps as bsonDumps # to convert cursor object to json from defaults import * api = Flask(__name__) CORS(api) project = Project(uri="mongodb://*****:*****@api.route('/head') def hello_world(): return str(project.head()) @api.route('/plot') def get_plot(): bytes_obj = project.plot() return send_file(bytes_obj, attachment_filename='plot.png', mimetype='image/png') # requests.get(url, params={'filter': json.dumps(filter), 'limit': json.dumps(limit)}) @api.route('/crud/find', methods=['GET']) def find_from_db(): args = request.args # j = loads(dumps(args)) argsJSON = parseRequestArgs(findArgsJSON, args) print (argsJSON) cursor = project.find(**argsJSON) response_list = bsonDumps(cursor) # cursor = project.find(filter=argsJSON['filter'], limit=argsJSON['limit'])
projects = get_projects(organization['name'], organization['projects_list_url']) for project in projects: # Mark this project for safe-keeping project['keep'] = True # Select the current project, filtering on name AND brigade # filter = Project.name == project['name'], Project.brigade == project['brigade'] existing_project = db.session.query(Project).filter( Project.name == project['name'], Project.brigade == project['brigade']).first() # If this is a new project if not existing_project: project = Project(**project) db.session.add(project) continue # Update exisiting project details for (field, value) in project.items(): setattr(existing_project, field, value) # Save each project to db db.session.commit() # Remove everything marked for deletion. db.session.execute(db.delete(Project).where(Project.keep == False)) db.session.commit()
print 'Gathering all of ' + organization['name']+ "'s projects." projects = get_projects(organization['name'], organization['projects_list_url']) for project in projects: # Mark this project for safe-keeping project['keep'] = True # Select the current project, filtering on name AND brigade # filter = Project.name == project['name'], Project.brigade == project['brigade'] existing_project = db.session.query(Project).filter(Project.name == project['name'], Project.brigade == project['brigade']).first() # If this is a new project if not existing_project: project = Project(**project) db.session.add(project) continue # Update exisiting project details for (field, value) in project.items(): setattr(existing_project, field, value) # Save each project to db db.session.commit() # Remove everything marked for deletion. db.session.execute(db.delete(Project).where(Project.keep == False)) db.session.commit()