def insert_random_seller(self, repeat=qsellers):
''' Inserir registros com valores randomicos '''
seller_list = []
for _ in range(repeat):
d = gen_timestamp(2014, 2015) + '+00'
fname = names.get_first_name()
lname = names.get_last_name()
email = fname[0].lower() + '.' + lname.lower() + '@example.com'
birthday = gen_timestamp() + '+00'
active = rstr.rstr('01', 1)
internal = rstr.rstr('01', 1)
commissioned = rstr.rstr('01', 1)
commission = 0.01
seller_list.append(
(gen_cpf(), fname, lname, email, gen_phone(), birthday, active, internal, commissioned, commission, d, d))
try:
self.db.cursor.executemany("""
INSERT INTO vendas_seller (cpf, firstname, lastname, email, phone, birthday, active, internal, commissioned, commission, created, modified)
VALUES (?,?,?,?,?,?,?,?,?,?,?,?)
""", seller_list)
self.db.commit_db()
print("Inserindo %s registros na tabela vendas_seller." % repeat)
print("Registros criados com sucesso.")
except sqlite3.IntegrityError:
print("Aviso: O email deve ser único.")
return False
def insert_random_customer(self, repeat=qcustomers):
''' Inserir registros com valores randomicos '''
customer_list = []
for _ in range(repeat):
# d = datetime.datetime.now().isoformat(" ")
d = gen_timestamp(2014, 2015) + '+00'
fname = names.get_first_name()
lname = names.get_last_name()
email = fname[0].lower() + '.' + lname.lower() + '@example.com'
birthday = gen_timestamp() + '+00'
customer_list.append(
(gen_cpf(), fname, lname, email, gen_phone(), birthday, d, d))
try:
self.db.cursor.executemany("""
INSERT INTO vendas_customer (cpf, firstname, lastname, email, phone, birthday, created, modified)
VALUES (?,?,?,?,?,?,?,?)
""", customer_list)
self.db.commit_db()
print("Inserindo %s registros na tabela vendas_customer." % repeat)
print("Registros criados com sucesso.")
except sqlite3.IntegrityError:
print("Aviso: O email deve ser único.")
return False
['id_company', choice(company_list)],
['id_department', choice(department_list)],
['id_occupation', 'Arquiteto'],
]
for field in fields:
search = page.find_element_by_id(field[0])
search.send_keys(field[1])
# time.sleep(0.5)
button = page.find_element_by_link_text('Documentos')
button.click()
fields = [
['id_photo', photo],
['id_cpf', gen_cpf()],
['id_rg', gen_rg()],
]
for field in fields:
search = page.find_element_by_id(field[0])
search.send_keys(field[1])
# time.sleep(0.5)
button = page.find_element_by_link_text('Endereço')
button.click()
fields = [
['id_address', address_list[INDEX]['address']],
['id_complement', 'Apto 303'],
['id_district', address_list[INDEX]['district']],
search = page.find_element_by_id(gender)
search.click()
INDEX = randint(0, 146)
fields = [
['id_treatment', treatment],
['id_first_name', first_name],
['id_last_name', last_name],
['id_slug', slug],
['id_photo', photo],
['id_company', choice(company_list)],
['id_department', choice(department_list)],
['id_occupation', 'Estagiário'],
['id_email', email],
['id_cpf', gen_cpf()],
['id_rg', gen_rg()],
['id_address', address_list[INDEX]['address']],
['id_complement', str(randint(1, 30)) + 'º andar'],
['id_district', address_list[INDEX]['district']],
['id_city', address_list[INDEX]['city']],
['id_uf', address_list[INDEX]['city']], # deixa city mesmo
['id_cep', address_list[INDEX]['cep']],
]
for field in fields:
search = page.find_element_by_id(field[0])
search.send_keys(field[1])
# button = page.find_element_by_id('id_submit')
button = page.find_element_by_class_name('btn-primary')