def put(self, id):
_request = request.json
try:
_errors = validate_rest(fields=self._fields,
request=_request,
method='put')
if not _errors:
_val = type_of_update_rest(self._fields, _request)
_qrp = "UPDATE %s SET %s WHERE id=%s;" % (
self._table,
_val,
id,
)
g.db_conn.execute(_qrp)
if g.db_conn.count() > 0:
_put = processing_rest_success(
status_code=201,
message="El registro fue actualizado correctamente")
else:
raise ExceptionRest(
status_code=404,
message=
"No se ha podido encontrar el registro, para actualizar."
)
else:
raise ExceptionRest(status_code=400, errors=_errors)
except (Exception, ExceptionRest), e:
_put = processing_rest_exception(e)
def put(self, id):
_request = request.json
try:
_errors = validate_rest(fields=self._fields,
request=_request,
method='put')
if not _errors:
_val = type_of_update_rest(self._fields, _request)
_qrp = "UPDATE %s SET %s WHERE id=%s;" % (
self._table,
_val,
id,
)
g.db_conn.execute(_qrp)
if g.db_conn.count() > 0:
_put = processing_rest_success(
status_code=201,
message=_("The record was successfully updated"))
else:
raise ExceptionRest(status_code=404,
message=_("Not found record"))
else:
raise ExceptionRest(status_code=400, errors=_errors)
except (Exception, ExceptionRest), e:
_put = processing_rest_exception(e)
def post(self):
_request = request.json
try:
if 'assigned_user_id' not in _request:
_request['assigned_user_id'] = g.user.id
print _request
_errors = validate_rest(fields=self._fields, request=_request)
if not _errors:
_col, _val = type_of_insert_rest(self._fields, _request)
_qrp = """
INSERT INTO %s (create_id , %s ) VALUES (%s, %s)
RETURNING (select row_to_json(collection) FROM (VALUES(id)) collection(id));
""" % (self._table, _col, g.user.id, _val)
g.db_conn.execute(_qrp)
if g.db_conn.count() > 0:
_data = {self._table: g.db_conn.one()}
_post = processing_rest_success(
data=_data,
message='Fue creado correctamente',
status_code=201)
else:
raise ExceptionRest(status_code=500,
message='No se ha podido registrar')
else:
raise ExceptionRest(status_code=400, errors=_errors)
except (Exception, ExceptionRest), e:
_post = processing_rest_exception(e)
def post(self):
_request = request.json
try:
_errors = validate_rest(fields=self._fields, request=_request)
if not _errors:
_col, _val = type_of_insert_rest(self._fields, _request)
_qrp = """
INSERT INTO %s (create_id, %s) VALUES (%s,%s)
RETURNING (select row_to_json(collection) FROM (VALUES(id)) collection(id));
""" % (self._table, _col, g.user.id, _val)
g.db_conn.execute(_qrp)
if g.db_conn.count() > 0:
_data = g.db_conn.one()
# add default 4 columns
for _column in ['Today', 'Tomorrow', 'Upcoming', 'Someday']:
qryIprojectTask = """
INSERT INTO project_tasks (create_id, name, project_id) VALUES ({}, '{}',{})
""".format(g.user.id, _column, _data[0]['id'])
g.db_conn.execute(qryIprojectTask)
_data = {self._table: _data}
_post = processing_rest_success(data=_data, message='El proyecto fue creado correctamente',
status_code=201)
else:
raise ExceptionRest(status_code=500, message='No se ha podido registrar el proyecto.')
else:
raise ExceptionRest(status_code=400, errors=_errors)
except (Exception, ExceptionRest), e:
_post = processing_rest_exception(e)
def put(self, reminder_id):
_request = request.json
try:
_params = _request.get('params', None)
val_params = ''
if _params:
del _request['params']
val_params = " params=cast('{}' as json), ".format(
json.dumps(_params))
_errors = validate_rest(fields=self._fields,
request=_request,
method="put")
if not _errors:
_val = type_of_update_rest(self._fields, _request)
_qrp = "UPDATE {} SET {} last_datetime_notify=NULL, {} WHERE id={};".format(
self._table, val_params, _val, reminder_id)
print _qrp
g.db_conn.execute(_qrp)
if g.db_conn.count() > 0:
_put = processing_rest_success(
status_code=200,
message=_("The record was successfully updated"))
else:
raise ExceptionRest(status_code=404,
message=_("Not found record"))
else:
raise ExceptionRest(status_code=400, errors=_errors)
except (Exception, ExceptionRest), e:
_put = processing_rest_exception(e)
def token():
_request = request.json
_field = {'email': {'required': True}}
try:
_errors = validate_rest(fields=_field, request=_request)
if not _errors:
_email = _request['email']
rpo = ResetPasswordMdl()
rpo.account_exists(email=_email)
_get = processing_rest_success(
data=None,
message=
'El token fue enviado correctamente para actualizar su contraseña!',
status_code=200)
else:
raise ExceptionRest(status_code=400, errors=_errors)
except (Exception, ExceptionRest), e:
_get = processing_rest_exception(e)
def post(self):
_request = request.json
try:
_errors = validate_rest(fields=self._fields, request=_request)
if not _errors:
_col, _val = type_of_insert_rest(self._fields, _request)
_qrp = """
INSERT INTO %s (create_id , %s ) VALUES (%s, %s)
RETURNING (select row_to_json(collection) FROM (VALUES(id)) collection(id));
""" % (self._table, _col, g.user.id, _val)
g.db_conn.execute(_qrp)
if g.db_conn.count() > 0:
_data = {self._table: g.db_conn.one()}
_post = processing_rest_success(
data=_data,
message=_('It was created correctly'),
status_code=201)
else:
raise ExceptionRest(status_code=500,
message=_('Unable to register'))
else:
raise ExceptionRest(status_code=400, errors=_errors)
except (Exception, ExceptionRest), e:
_post = processing_rest_exception(e)
def password_change():
_request = request.json
_fields = {'password': {'required': True}, 'token': {'required': True}}
try:
_errors = validate_rest(fields=_fields, request=_request)
if not _errors:
_new_password = _request['password']
_token = _request['token']
rpo = ResetPasswordMdl()
if rpo.password_change(_new_password, _token):
_change = processing_rest_success(
data=None,
message='La contraseña fue actualizado correctamente!',
status_code=200)
else:
raise ExceptionRest(
status_code=400,
message=
'Ocurrio un problema al intentar cambiar la contraseña, por favor intenta mas tarde :('
)
else:
raise ExceptionRest(status_code=400, errors=_errors)
except (Exception, ExceptionRest), e:
_change = processing_rest_exception(e)
