def fetch_fractions(self, **named): query=named.get("q") if query: rows = DBSession.query(Fraction).filter(Fraction.code.contains(query)).limit(5).all() else: rows = DBSession.query(Fraction).limit(5).all() return dict(data=rows)
def add_fraction( self, code, **named ): """Create a new movie record""" new = Fraction( code = code, add_date = datetime.now(), ) if 'title' in named: new.title=named['title'] if 'comment' in named: new.comment=named['comment'] if 'mass' in named: new.mass=named['mass'] if 'mass_left' in named: new.mass_left=named['mass_left'] # Checking if the experiment exists if 'description' in named: query = DBSession.query(Experiment).filter_by(code=named['experiments']) if query.count() != 0: experiment_id = query.one() new.experiments.append (experiment_id) # Checking if the owner exists if 'owner' in named: query = User.by_user_name(named['owner'])#DBSession.query(User).filter_by(user_name=named['owner']) if query != None: new.owner.append(query) DBSession.add( new ) flash( '''Added fraction: %s'''%( code, )) redirect( './index' )
def add( self, code, **named ): """Create a new record""" new = Experiment( code = code, add_date = datetime.now(), ) if 'title' in named: new.title=named['title'] if 'comment' in named: new.comment=named['comment'] # Checking if the experiment exists if 'description' in named: for fraction in named['fractions']: query = DBSession.query(Fraction).filter_by(code=fraction) if query.count() != 0: fraction_id = query.one() new.fractions.append (fraction_id) # Checking if the owner exists if 'owner' in named: query = User.by_user_name(named['owner'])#DBSession.query(User).filter_by(user_name=named['owner']) if query != None: new.owner.append(query) DBSession.add( new ) flash( '''Added experiment: %s'''%( code, )) redirect( '/experiments/new' )
def post(self,**kw): experiment = DBSession.query(Experiment).get(kw.get('id')) if not experiment : experiment=Experiment() experiment.fractions=[] for f_id in kw.get('fractions'): experiment.fractions.append(DBSession.query(Fraction).get(f_id)) experiment.title = kw.get('title') experiment.code = kw.get('code') experiment.description = kw.get('description') experiment.comment = kw.get('comment') DBSession.flush() flash( '''Modified experiment: %s'''%( kw.get('code') )) redirect( '/experiments' )
def edit(self,experiment_id,*args, **kw): print(request) query = DBSession.query(Experiment).filter_by(id=experiment_id).one() w = AddEditExperiment()# values=dict(title="Heyho")) values = query return dict(widget=w,page="edit",values=values)
def fetch_users(self): rows = DBSession.query(User.user_name).all() return dict(data=rows)
def fetch_experiments(self): rows = DBSession.query(Experiment.code).all() return dict(data=rows)
def by_user_name(cls, username): """Return the user object whose user name is ``username``.""" return DBSession.query(cls).filter_by(user_name=username).first()
def by_email_address(cls, email): """Return the user object whose email address is ``email``.""" return DBSession.query(cls).filter_by(email_address=email).first()