def do_put(email,project, **kwargs):
"""
Save email from subscriber
"""
_db = get_db()
dbc = _db.cursor()
query = "SELECT id FROM subscribers WHERE email='{}'".format(email)
try:
dbc.execute(query)
except IntegrityError as e:
return base_common.msg.error(msgs.EXECUTE_QUERY_ERROR)
if dbc.rowcount != 0:
return base_common.msg.error(amsgs.ALREADY_EXIST)
id = sequencer().new('b')
query = "INSERT INTO subscribers (id,id_project, email, project) VALUES('{}','{}','{}','{}')".format(id, 1, email, project)
print(query)
try:
dbc.execute(query)
except IntegrityError as e:
return base_common.msg.error(msgs.EXECUTE_QUERY_ERROR)
_db.commit()
return base_common.msg.put_ok()
def do_put(request, *args, **kwargs):
"""
Save hash for give parameters
:param hash_data: data for storing, string, True
:return: 202, Data hash
:return: 404, Missing argument
"""
log = request.log
_db = get_db()
dbc = _db.cursor()
import tornado.web
try:
hdata = request.get_argument('data')
except tornado.web.MissingArgumentError:
log.critical('Missing data argument for hash2param')
return base_common.msg.error(msgs.MISSING_REQUEST_ARGUMENT)
h_id = sequencer().new('h')
h2p = prepare_hash2params_query(h_id, hdata)
try:
dbc.execute(h2p)
except IntegrityError as e:
log.critical('Insert hash for data: {}'.format(e))
return base_common.msg.error('Save data hash')
_db.commit()
return base_common.msg.post_ok({'h': h_id})
def do_post(username, password, users_data, **kwargs):
"""
Register user account
"""
_db = get_db()
dbc = _db.cursor()
username = username.lower()
if check_user_registered(dbc, username):
return base_common.msg.error(msgs.USERNAME_ALREADY_TAKEN)
if base_config.settings.STRONG_PASSWORD:
result, server_message = apphooks.check_password_is_valid(username, password, users_data, **kwargs)
if not result:
return base_common.msg.error(server_message)
u_id = sequencer().new('u')
if not u_id:
return base_common.msg.error(msgs.ERROR_SERIALIZE_USER)
quser = apphooks.prepare_user_query(u_id, username, password, users_data, **kwargs)
if not quser:
log.critical('Error checking users data and create query')
return base_common.msg.error(msgs.ERROR_REGISTER_USER)
try:
dbc.execute(quser)
except IntegrityError as e:
log.critical('User registration: {}'.format(e))
return base_common.msg.error(msgs.ERROR_REGISTER_USER)
tk = get_token(u_id, dbc)
if not tk:
return base_common.msg.error('Cannot login user')
_db.commit()
response = {'token': tk}
if users_data and hasattr(apphooks, 'post_register_digest'):
post_d = apphooks.post_register_digest(u_id, username, password, users_data, **kwargs)
if post_d == False:
log.critical('Error user post registration digest')
return base_common.msg.error(msgs.ERROR_POST_REGISTRATION)
if isinstance(post_d, dict):
response.update(post_d)
return base_common.msg.put_ok(response)
def do_post(username, password, users_data, **kwargs):
"""
Register user account
"""
_db = get_db()
dbc = _db.cursor()
username = username.lower()
if check_user_registered(dbc, username):
return base_common.msg.error(msgs.USERNAME_ALREADY_TAKEN)
if base_config.settings.STRONG_PASSWORD:
result, server_message = apphooks.check_password_is_valid(username, password, users_data, **kwargs)
if not result:
return base_common.msg.error(server_message)
u_id = sequencer().new("u")
if not u_id:
return base_common.msg.error(msgs.ERROR_SERIALIZE_USER)
quser = apphooks.prepare_user_query(u_id, username, password, users_data, **kwargs)
if not quser:
log.critical("Error checking users data and create query")
return base_common.msg.error(msgs.ERROR_REGISTER_USER)
try:
dbc.execute(quser)
except IntegrityError as e:
log.critical("User registration: {}".format(e))
return base_common.msg.error(msgs.ERROR_REGISTER_USER)
tk = get_token(u_id, dbc)
if not tk:
return base_common.msg.error("Cannot login user")
_db.commit()
response = {"token": tk}
if users_data and hasattr(apphooks, "post_register_digest"):
post_d = apphooks.post_register_digest(u_id, username, password, users_data, **kwargs)
if post_d == False:
log.critical("Error user post registration digest")
return base_common.msg.error(msgs.ERROR_POST_REGISTRATION)
if isinstance(post_d, dict):
response.update(post_d)
return base_common.msg.put_ok(response)
def get_token(uid, dbc):
# RETRIEVE ASSIGNED TOKEN
__tk = __get_assigned_token(dbc, uid)
if __tk:
return __tk
__tk = sequencer().new("s")
try:
__set_session_token(dbc, uid, __tk)
except ErrorSetSessionToken:
return None
return __tk
def get_token(uid, dbc):
# RETRIEVE ASSIGNED TOKEN
__tk = __get_assigned_token(dbc, uid)
if __tk:
return __tk
__tk = sequencer().new('s')
try:
__set_session_token(dbc, uid, __tk)
except ErrorSetSessionToken:
return None
return __tk
def do_post(username, password, users_data, **kwargs):
"""
Register user account
"""
_db = get_db()
dbc = _db.cursor()
if _check_user_registered(dbc, username):
return base_common.msg.error(msgs.USERNAME_ALREADY_TAKEN)
if hasattr(apphooks, 'check_password_is_valid') and not apphooks.check_password_is_valid(password):
return base_common.msg.error(msgs.INVALID_PASSWORD)
u_id = sequencer().new('u')
if not u_id:
return base_common.msg.error(msgs.ERROR_SERIALIZE_USER)
quser = apphooks.prepare_user_query(u_id, username, password, users_data, **kwargs)
if not quser:
log.critical('Error checking users data and create query')
return base_common.msg.error(msgs.ERROR_REGISTER_USER)
try:
dbc.execute(quser)
except IntegrityError as e:
log.critical('User registration: {}'.format(e))
return base_common.msg.error(msgs.ERROR_REGISTER_USER)
tk = get_token(u_id, dbc)
if not tk:
return base_common.msg.error('Cannot login user')
_db.commit()
response = {'token': tk}
if users_data and hasattr(apphooks, 'post_register_digest'):
post_d = apphooks.post_register_digest(u_id, username, password, users_data, **kwargs)
if post_d == False:
log.critical('Error user post registration digest')
return base_common.msg.error(msgs.ERROR_POST_REGISTRATION)
if isinstance(post_d, dict):
response.update(post_d)
return base_common.msg.put_ok(response)
def do_post(request, *args, **kwargs):
"""
Register user account
:param username: users username, string, True
:param password: users password, string, True
:return: 201, Created
:return: 404
"""
log = request.log
try:
username = request.get_argument('username')
password = request.get_argument('password')
except tornado.web.MissingArgumentError:
return base_common.msg.error(msgs.MISSING_REQUEST_ARGUMENT)
if len(password) < 3:
return base_common.msg.error(msgs.PASSWORD_TO_SHORT)
password = format_password(username, password)
_db = get_md2db()
dbc = _db.cursor()
if _check_user_registered(dbc, username):
return base_common.msg.error(msgs.USERNAME_ALREADY_TAKEN)
u_id = sequencer().new('u')
if not u_id:
return base_common.msg.error(msgs.ERROR_SERIALIZE_USER)
quser = _prepare_user_query(u_id, username, password)
try:
dbc.execute(quser)
except IntegrityError as e:
log.critical('User registration: {}'.format(e))
return base_common.msg.error(msgs.ERROR_REGISTER_USER)
tk = get_token(u_id, dbc, log)
if not tk:
return base_common.msg.error('Cannot login user')
_db.commit()
return base_common.msg.put_ok({'token': tk}, http_status=200)
def do_post(request, *args, **kwargs):
"""
Register user account
:param username: users username, string, True
:param password: users password, string, True
:return: 201, Created
:return: 404
"""
log = request.log
try:
username = request.get_argument('username')
password = request.get_argument('password')
except tornado.web.MissingArgumentError:
return base_common.msg.error(msgs.MISSING_REQUEST_ARGUMENT)
if len(password) < 3:
return base_common.msg.error(msgs.PASSWORD_TO_SHORT)
password = format_password(username, password)
_db = get_db()
dbc = _db.cursor()
if _check_user_registered(dbc, username):
return base_common.msg.error(msgs.USERNAME_ALREADY_TAKEN)
u_id = sequencer().new('u')
if not u_id:
return base_common.msg.error(msgs.ERROR_SERIALIZE_USER)
quser = _prepare_user_query(u_id, username, password)
try:
dbc.execute(quser)
except IntegrityError as e:
log.critical('User registration: {}'.format(e))
return base_common.msg.error(msgs.ERROR_REGISTER_USER)
tk = get_token(u_id, dbc, log)
if not tk:
return base_common.msg.error('Cannot login user')
_db.commit()
return base_common.msg.put_ok({'token': tk}, http_status=200)
def save_hash(hdata, commit=True):
_db = get_db()
dbc = _db.cursor()
h_id = sequencer().new('h', commit)
h2p = prepare_hash2params_query(h_id, hdata)
try:
dbc.execute(h2p)
except IntegrityError as e:
return False
if commit:
_db.commit()
return h_id
def save_hash(hdata, commit=True):
_db = get_db()
dbc = _db.cursor()
h_id = sequencer().new('h', commit)
h2p = prepare_hash2params_query(h_id, hdata)
try:
dbc.execute(h2p)
except IntegrityError as e:
return False
if commit:
_db.commit()
return h_id
def do_put(hdata, **kwargs):
"""
Save hash for give parameters
"""
_db = get_db()
dbc = _db.cursor()
h_id = sequencer().new('h')
h2p = prepare_hash2params_query(h_id, hdata)
try:
dbc.execute(h2p)
except IntegrityError as e:
log.critical('Insert hash for data: {}'.format(e))
return base_common.msg.error(msgs.ERROR_SAVE_HASH)
_db.commit()
return base_common.msg.post_ok({'h': h_id})
def do_put(hdata, **kwargs):
"""
Save hash for give parameters
"""
_db = get_db()
dbc = _db.cursor()
h_id = sequencer().new('h')
h2p = prepare_hash2params_query(h_id, hdata)
try:
dbc.execute(h2p)
except IntegrityError as e:
log.critical('Insert hash for data: {}'.format(e))
return base_common.msg.error(msgs.ERROR_SAVE_HASH)
_db.commit()
return base_common.msg.post_ok({'h': h_id})
