def add_clients():
clients = [
Clients(name='Ally'),
Clients(name='Blayze'),
Clients(name='Courtney'),
Clients(name='Delmer'),
]
db_session.bulk_save_objects(clients, return_defaults=True)
return clients
def add_new_client():
body = json.loads(request.data)
name = body.get('name', None)
username = body.get('username', None)
password = body.get('password', None)
courriel = body.get('courriel', None)
if name is None:
return jsonify({'error': 'name cannot be null'})
if username is None:
return jsonify({'error': 'username cannot be null'})
if password is None:
return jsonify({'error': 'password cannot be null'})
if courriel is None:
return jsonify({'error': 'courriel cannot be null'})
new_clients = Clients(name=name,
username=username,
password=password,
courriel=courriel)
db.add(new_client)
return jsonify({'result': new_client._dump()})
def gen_default_client():
"""
Generates the default client.
:return: The default client.
"""
default_client = Clients()
default_client.id = 0
default_client.name = "default"
return default_client
def create_rab():
if db.session.query(Roles).filter_by(
id_role=current_user.id_role).first().name != "Менеджер":
return 'What are you doing here?'
if request.method == 'GET':
return render_template('create_rab.html',
role=db.session.query(Roles).filter_by(
id_role=current_user.id_role).first().name)
if request.method == 'POST':
cipher = Salsa20.new(key=secret)
fio = request.form['fio']
created = time.strftime('%d/%m/%Y',
time.localtime()) # использовать дату
dob = request.form['dob']
if request.form['role'] == 'Стажер':
role = 1
id_position = 0
elif request.form['role'] == 'Продавец-консультант':
role = 1
id_position = 1
elif request.form['role'] == 'Менеджер':
role = 2
id_position = 2
email = request.form['email']
phone = request.form['phone']
company = request.form['company']
hash_password = generate_password_hash(request.form['password'])
hash_address = request.form['address']
hash_card = str(cipher.nonce +
cipher.encrypt(bytes(request.form['card'], 'utf-8')))
amount = request.form['amount']
new_Client = Clients(email=email,
fio=fio,
created=created,
dob=dob,
id_role=role)
db.session.add(new_Client)
db.session.commit()
new_Contactdetailsclients = Contactdetailsclients(
id_clients=new_Client.id_clients, phone=phone, company=company)
new_Secretdate = Secretdate(id_clients=new_Client.id_clients,
hash_password=hash_password,
hash_address=hash_address)
new_Card = Card(id_clients=new_Client.id_clients,
hash_card=hash_card,
amount=amount)
new_Staff = Staff(id_staff=new_Client.id_clients,
id_position=id_position)
db.session.add(new_Contactdetailsclients)
db.session.add(new_Secretdate)
db.session.add(new_Card)
db.session.add(new_Staff)
db.session.commit()
return redirect('/login')
def create_client(session, orga, name="test"):
client = Clients()
client.orga = orga
client.email = name + "@test.com"
client.name = name
client.identifier = name + "id"
session.add(client)
session.commit()
time.sleep(config.SPI_GENERATION_INTERVAL * 3)
return client
def register(self, user, password):
validator = get_validator(user)
if not validator.is_valid(password):
raise StrongPasswordException("Your password is not strong enough")
hashed_password, salt = hash_password(password)
current_user = self.session.query(Clients.username).\
filter(Clients.username == user).first()
if current_user is not None:
raise ClientAlreadyRegistered('Client already registered')
client = Clients(username=user, password=hashed_password, salt=salt)
self.__commit_object(client)
def add(request):
if request.method == 'POST':
#form = ClientsForm(request.POST)
user_id = request.POST.get('registerID')
user_name = request.POST.get('registername')
user_no = request.POST.get('registernum')
user_network = request.POST.get('registernetwork')
user_dob = request.POST.get('registerdob')
q1 = Clients(name=user_name,
mob_no=user_no,
network=user_network,
dob=user_dob)
q1.save()
#registered = True
else:
pass
return render(request, 'QA/add.html')
def clients() -> Tuple[str, int]:
"""Запрос на вывод и создание клиента."""
if request.method == 'GET':
client_id = request.args.get('clientId')
client = session.query(Clients).filter(Clients.id == client_id).first()
json_return = {'id': client.id, 'name': client.name,
'is_vip': client.is_vip}
return jsonify(json_return)
elif request.method == 'POST':
response_post = request.json
name = response_post['name']
is_vip = response_post['is_vip']
create_client = Clients(name, is_vip)
session.add(create_client)
print(create_client.__repr__())
session.commit()
session.close()
return 'created!', 200
assert False
def client_create(request, decoded):
"""
REST endpoint to create a client.
:param request: The flask request.
:param decoded: The decoded json value from the with_json decorator.
:return: json of the newly created client.
"""
orga = int(
request.args.get('ebuio_orgapk') or request.form.get('ebuio_orgapk'))
client = Clients()
client.orga = orga
client.email = decoded['email']
client.name = decoded['name']
client.identifier = decoded['identifier']
db.session.add(client)
db.session.commit()
return {'client': client.json}
def registration():
if request.method == 'GET':
return render_template('registration.html')
if request.method == 'POST':
cipher = Salsa20.new(key=secret)
fio = request.form['fio']
created = time.strftime('%d/%m/%Y',
time.localtime()) # использовать дату
dob = request.form['dob'] # определить формат
role = 0
email = request.form['email']
phone = request.form['phone']
company = request.form['company']
hash_password = generate_password_hash(request.form['password'])
print(hash_password)
hash_address = request.form['address']
hash_card = str(cipher.nonce +
cipher.encrypt(bytes(request.form['card'], 'utf-8')))
amount = request.form['amount']
new_Client = Clients(email=email,
fio=fio,
created=created,
dob=dob,
id_role=role)
db.session.add(new_Client)
db.session.commit()
new_Contactdetailsclients = Contactdetailsclients(
id_clients=new_Client.id_clients, phone=phone, company=company)
new_Secretdate = Secretdate(id_clients=new_Client.id_clients,
hash_password=hash_password,
hash_address=hash_address)
new_Card = Card(id_clients=new_Client.id_clients,
hash_card=hash_card,
amount=amount)
db.session.add(new_Contactdetailsclients)
db.session.add(new_Secretdate)
db.session.add(new_Card)
db.session.commit()
return redirect('/login')
def get_profile():
cli = Clients.query.filter_by(id=current_user.id).first()
username = ClientLog.query.filter_by(id=current_user.id).first()
if cli is None:
cli = Clients(id=current_user.id,
first_name=request.form.get('firstname'),
last_name=request.form.get('lastname'),
sex=request.form.get('sex'),
date_of_birth=request.form.get('date'),
location=request.form.get('location'))
db.session.add(cli)
for i in range(1, 11):
# if request.form.get('v{}'.format(i)) is not None:
# v = Vaccines(name=request.form.get('v{}'.format(i)))
# db.session.add(v)
vacc = VaccControl(
client_id=current_user.id,
vacc_id=Vaccines.query.filter_by(id=i).first().id,
date=(datetime.date.today() - datetime.timedelta(
days=(730 - randint(1, 730)))).isoformat(),
is_done=True
if request.form.get('v{}'.format(i)) is not None else False)
db.session.add(vacc)
else:
cli.first_name = request.form.get('firstname')
cli.last_name = request.form.get('lastname')
cli.sex = request.form.get('sex')
cli.date_of_birth = request.form.get('date')
cli.location = request.form.get('location')
username.name = request.form.get('username')
for i in range(1, 11):
if request.form.get('v{}'.format(i)) is None:
temp = db.session.query(VaccControl).filter_by(
client_id=current_user.id).filter_by(
is_done=True).join(Vaccines).filter_by(id=i).first()
if temp is not None:
temp.is_done = False
else:
temp = db.session.query(VaccControl).filter_by(
client_id=current_user.id).join(Vaccines).filter_by(
id=i).first()
if temp is not None:
temp.is_done = True
else:
db.session.add(
VaccControl(client_id=current_user.id,
vacc_id=Vaccines.query.filter_by(
name=request.form.get('v{}'.format(
i))).first().id,
date=datetime.date.today().isoformat(),
is_done=True))
db.session.commit()
if request.form.get('firstname') == '' or request.form.get(
'lastname') == '' or request.form.get(
'date') == '' or request.form.get(
'location') == '' or request.form.get('username') == '':
flash("*")
return redirect(url_for('main.profile'))
return redirect(url_for('main.home'))
def clients(rut):
if request.method == 'GET':
list = []
if rut == "17.402.744-7" or rut == "20.968.696-1":
resp = db.session.query(Clients).all(
) #DEPURAR ESTO, TOMAR RESP Y QUE EL MODEL ARROJE UN OBJ DE TODOS LOS CAMPOS
for item in resp:
list.append({
"clients_id": item.clients_id,
"clients_name": item.clients_name,
"clients_rut": item.clients_rut,
"clients_nationality": item.clients_nationality,
"clients_civilStatus": item.clients_civilStatus,
"clients_job": item.clients_job,
"clients_address": item.clients_address,
"clients_contact": item.clients_contact
})
return jsonify({"resp": list}), 200
else:
resp = db.session.query(Clients).filter_by(clients_rut=rut).all()
for item in resp:
list.append({
"clients_id": item.clients_id,
"clients_name": item.clients_name,
"clients_rut": item.clients_rut,
"clients_nationality": item.clients_nationality,
"clients_civilStatus": item.clients_civilStatus,
"clients_job": item.clients_job,
"clients_address": item.clients_address,
"clients_contact": item.clients_contact
})
return jsonify({"resp": list}), 200
if request.method == 'POST':
incomingData = request.get_json()
existingClient = db.session.query(Clients).filter_by(
clients_rut=incomingData['rut']).all(
) #CHECKING IF THE CLIENT ALREADY EXIST
list = []
for item in existingClient:
list.append(item.clients_id)
if len(list) == 0:
insertedData = Clients(
clients_name=incomingData['name'],
clients_rut=incomingData['rut'],
clients_nationality=incomingData['nationality'],
clients_civilStatus=incomingData['civilStatus'],
clients_job=incomingData['job'],
clients_address=incomingData['address'],
clients_contact=incomingData['contact'])
db.session.add(insertedData)
db.session.commit()
lastId = insertedData.clients_id
return jsonify({
"resp": "inserted data",
"lastId": str(lastId)
}), 200
if len(list) > 0:
return jsonify({"resp": "client already exist", "lastId": list[0]})
if request.method == 'PUT':
incomingData = request.get_json()
updateData = Clients.query.filter_by(clients_rut=rut)
listOfNotEmptyStrings = []
for item in incomingData:
if incomingData[item] != "":
listOfNotEmptyStrings.append(item)
for item2 in listOfNotEmptyStrings:
print(incomingData[item2], item2)
updateData.update({item2: incomingData[item2]})
db.session.commit()
return "updated"
if request.method == 'DELETE':
deletedRow = Clients.query.filter_by(clients_rut=rut).first()
db.session.delete(deletedRow)
db.session.commit()
return "data deleted", 200
def save_or_update_station(sp, request, errors, station_instance=None, client=None, parent_station=None):
"""
Saves or updates a station based on the request form values.
:param sp: The service provider.
:param request: The fask request.
:param errors: The error list instance.
:param station_instance: The station instance if any. If this is a new station leave this paramter to None.
:param client: The client instance if this is an override for a client. If this is a new station leave this
parameter to None.
:param parent_station: The parent station of this station if this is a
:return: the save/updated/same station instance and the errors list.
"""
if not client:
client = Clients()
client.id = 0
client.name = "default"
is_override = "True" == request.form.get("is_client_override_" + str(client.id))
if not is_override and client.id != 0:
return station_instance, errors
if not station_instance:
station_instance = Station(int(request.form.get('ebuio_orgapk')))
station_instance.service_provider_id = sp.id
for field in station_fields:
field_value = request.form.get(field + '_' + str(client.id))
if parent_station and field_value == parent_station[field]:
field_value = None
setattr(station_instance, field, field_value)
if not is_override and station_instance.name == "":
errors.append("Please set a name")
return station_instance, errors
# handle special fields
station_instance.radiovis_enabled = 'radiovis_enabled_' + str(client.id) in request.form
station_instance.radioepg_enabled = station_instance.radiospi_enabled = 'radioepg_enabled_' + str(
client.id) in request.form
station_instance.radiotag_enabled = 'radiotag_enabled_' + str(client.id) in request.form
station_instance.radioepgpi_enabled = 'radioepgpi_enabled_' + str(client.id) in request.form
# handle genres
clientid = str(client.id) if is_override else '0'
genre_href = map(lambda key: request.form[key],
filter(lambda key: key.startswith('genrehref[]_' + clientid + "_") and request.form[key] != '',
request.form.keys()))
genre_href = sorted(genre_href)
genres = []
for h in genre_href:
genre_id = h.split(':')[-1]
if genre_id != '':
genres.append({'href': h, 'name': genres_map[genre_id]})
station_instance.genres = json.dumps(genres)
if is_override:
station_instance.parent = parent_station.id
station_instance.fk_client = client.id
# save
if (is_override or client.id == 0) and not station_instance.id:
station_instance.gen_random_password()
db.session.add(station_instance)
return station_instance, errors