def save(model): for item in model: DB.insert( 'galleries', name=item['name'], num_collections=item['num_collections'], num_images=item['num_images'], cover_thumb=item['cover_thumb'], last_update=item['last_update'] )
def setUp(self): DB.delete('user_articles', where='1=1') DB.delete('user_sources', where='1=1') DB.delete('sources', where='1=1') DB.delete('users', where='1=1') DB.insert('users', id=user_id, name='Guest') self.s = source.Source(type='feed', url=test_url1) self.us = source.UserSource(user_id=user_id, source_id=self.s.id)
def setUp(self): DB.delete('user_opml', where='1=1') DB.delete('user_articles', where='1=1') DB.delete('user_sources', where='1=1') DB.delete('users', where='1=1') self.a = article.Article() self.a.url = test_url1 self.a.title = 'Test title' self.a.description = 'Test description' self.a.save() DB.insert('users', id=user_id, name='Guest')
def refine_battle_log(): refined_logs = set() count = 0 logs = DB.find('battle_log', {}, {'_id': 0}) for l in logs: refined_logs.add(json.dumps(l)) count += 1 print(count, end=", ") print("Dumping to db") for battle in refined_logs: DB.insert('refined_battle_log', json.loads(battle)) count -= 1 print(count, end=', ')
def add_id(session_id): '''Adds new id to the session database''' round_select = DB.select(ROUND_ROBIN_DB_NAME)[0] curr_round = round_select['current_round'] total_rounds = round_select['total_rounds'] DB.insert(SESSION_DB_NAME, session_id=session_id, round_rbn=curr_round, num_eval=0) next_round = (curr_round + 1) % total_rounds return DB.update(ROUND_ROBIN_DB_NAME, where='current_round=%d' % curr_round, current_round=next_round)
def POST(self): from appForm import formClient f = formClient() if f.validates(): try: telefonos = {'fijo':f.d.fijo, 'celular':f.d.celular, 'pbx':f.d.pbx, 'fax':f.d.fax} try: nombres = f.d.nombres.split(' ') apellidos = f.d.apellidos.split(' ') nombres.append('') apellidos.append('') except: print "Error Inesperado1 /addclient:", sys.exc_info() return renderbase_admin.addclient(web.ctx.session, f, msgerr='Los Nombre o Apellidos no son validos.') sequence_id = DB.insert('clientes', documento=f.d.documento, tipo_docu=f.d.tipo_docu, fecha_naci=f.d.fecha_naci, direccion=f.d.direccion.lower(), ciudad=f.d.ciudad, sexo_id=f.d.sexo_id, email=f.d.email.lower(), nombre1=nombres[0].lower(), nombre2=nombres[1].lower() or None, apellido1=apellidos[0].lower(), apellido2=apellidos[1].lower() or None) from db import insertPhone insertPhone(telefonos, client_id=sequence_id) except: print "Error Inesperado2 /addclient:", sys.exc_info() return renderbase_admin.addclient(web.ctx.session, f, msgerr='El Cliente: %s %s, ya existe' % (f.d.nombres, f.d.apellidos)) return renderbase_admin.addclient(web.ctx.session, f, u'El Cliente: %s %s, se ha creado con éxito!' % (f.d.nombres, f.d.apellidos)) else: return renderbase_admin.addclient(web.ctx.session, f, msgerr=u'Los datos no son válidos.')
def save_user_info(session_id, age, gender, country, view, share, share_all): '''Saves user demographic data to the database''' return DB.insert(USER_DB_NAME, session_id=session_id, age=age, gender=gender, country=country, watch_videos=view, share_videos=share, share_content=share_all, dateof=datetime.utcnow())
def setUp(self): print 'TestUserArticle.setUp' DB.delete('user_sources', where='1=1') DB.delete('user_articles', where='1=1') DB.delete('users', where='1=1') self.a = article.Article() self.a.url = test_url1 self.a.title = 'Test title' self.a.description = 'Test description' self.a.save() DB.insert('users', id=user_id, name='Guest') self.ua = article.UserArticle(user_id=user_id, article_id=self.a.id) self.s = source.Source(type='feed', url=test_rss) self.us = source.UserSource(user_id=user_id, source_id=self.s.id) self.ua.add_location('source', self.s.id)
def save_choice(session_id, pair_id, id1, id2, like, share, pop, know, additional): '''Saves an evaluation''' return DB.insert(EVAL_DB_NAME, session_id=session_id, pair_num=pair_id, video_id1=id1, video_id2=id2, like_choice=like, share_choice=share, pop_choice=pop, additional=additional, know=know, dateof=datetime.utcnow())
def POST(self): from appForm import formGps f = formGps() if f.validates(): try: sequence_id = DB.insert('gps', **f.d) except: return renderbase_admin.addgps(web.ctx.session, f, msgerr='El dispositivo %s ya existe' % f.d.name) return renderbase_admin.addgps(web.ctx.session, f, u'El dispositivo %s, se ha guardado con éxito!' % f.d.name) else: return renderbase_admin.addgps(web.ctx.session, f, msgerr=u'Los datos no son válidos.')
def POST(self): from appForm import formAssignclient f = formAssignclient() if f.validates(): try: sequence_id = DB.insert('clientes_vehiculos', **f.d) except: return renderbase_admin.assignclient(web.ctx.session, f, msgerr=u'No se pudo crear la relación vehículo(%s) a cliente(%s). Porque ya existe!' % (f.d.vehiculo_id, f.d.cliente_id)) return renderbase_admin.assignclient(web.ctx.session, f, u'La relación vehículo(%s) a cliente(%s), se ha guardado con éxito!' % (f.d.vehiculo_id, f.d.cliente_id)) else: return renderbase_admin.assignclient(web.ctx.session, f, msgerr=u'Los datos no son válidos.')
def POST(self): from appForm import formUser f = formUser() if f.validates(): try: sequence_id = DB.insert('usuarios', usuario=f.d.usuario, passwd=f.d.passwd, privilege_id=f.d.privilege_id, activo=f.d.activo, cliente_id=f.d.cliente_id) except: return renderbase_admin.adduser(web.ctx.session, f, msgerr='El usuario %s ya existe' % f.d.usuario) return renderbase_admin.adduser(web.ctx.session, f, u'El usuario %s, se ha creado con éxito!' % f.d.usuario) else: return renderbase_admin.adduser(web.ctx.session, f, msgerr=u'Los datos no son válidos.')
def POST(self): from appForm import formVeh f = formVeh() if f.validates(): try: sequence_id = DB.insert('vehiculos', placa=f.d.placa.lower(), modelo=f.d.modelo, marca_id=f.d.marca_id, gps_id=f.d.gps_id, cilindraje=f.d.cilindraje or None, carroceria_id=f.d.carroceria_id or None, ejes=f.d.ejes or None, clase_id=f.d.clase_id or None, servicio_id=f.d.servicio_id or None, combustible_id=f.d.combustible_id or None, linea_id=f.d.linea_id or None, color_id=f.d.color_id or None) except: return renderbase_admin.addvehicle(web.ctx.session, f, msgerr=u'El Vehículo %s ya existe' % f.d.placa) return renderbase_admin.addvehicle(web.ctx.session, f, u'El vehículo %s, se ha creado con éxito!' % f.d.placa) else: return renderbase_admin.addvehicle(web.ctx.session, f, msgerr=u'Los datos no son válidos.')
def save_start_eval(session_id, pair_id): '''Saves when an evaluation has started''' return DB.insert(START_DB_NAME, session_id=session_id, pair_num=pair_id, dateof=datetime.utcnow())