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()
