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