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)