def custom_db_creator(self, number_of_rows, db, custom):
try:
customdb = db.custom
data_list = list()
custom_d = faker_options_container()
for c in custom:
if custom_d.get(c):
logger.warning(
"fake2db found valid custom key provided: %s" % c,
extra=d)
else:
logger.error(
"fake2db does not support the custom key you provided.",
extra=d)
sys.exit(1)
for i in range(0, number_of_rows):
dict_c = {"id": rnd_id_generator(self)}
for c in custom:
dict_c[c] = getattr(self.faker, c)()
data_list.append(dict_c)
customdb.insert_many(data_list)
logger.warning('custom Commits are successful after write job!',
extra=d)
except Exception as e:
logger.error(e, extra=d)
def data_filler_customer(self, number_of_rows, db):
'''creates and fills the table with customer data
'''
try:
customer = db.customer
for i in range(0, number_of_rows):
post_cus_reg = {"id": rnd_id_generator(self),
"name": self.faker.name(),
"lastname": self.faker.last_name(),
"address": self.faker.address(),
"country": self.faker.country(),
"city": self.faker.city(),
"registry_date": self.faker.date(pattern="%d-%m-%Y"),
"birthdate": self.faker.date(pattern="%d-%m-%Y"),
"email": self.faker.safe_email(),
"phone_number": self.faker.phone_number(),
"locale": self.faker.locale()
}
customer.insert(post_cus_reg)
logger.warning('customer Commits are successful after write job!', extra=d)
except Exception as e:
logger.error(e, extra=d)
def data_filler_customer(self, number_of_rows, pipe):
'''creates keys with customer data
'''
try:
for i in range(number_of_rows):
pipe.hmset(
'customer:%s' % i, {
'id': rnd_id_generator(self),
'name': self.faker.name(),
'lastname': self.faker.last_name(),
'address': self.faker.address(),
'country': self.faker.country(),
'city': self.faker.city(),
'registry_date': self.faker.date(pattern="%d-%m-%Y"),
'birthdate': self.faker.date(pattern="%d-%m-%Y"),
'email': self.faker.safe_email(),
'phone_number': self.faker.phone_number(),
'locale': self.faker.locale()
})
pipe.execute()
logger.warning('customer Commits are successful after write job!',
extra=d)
except Exception as e:
logger.error(e, extra=d)
def data_filler_detailed_registration(self, number_of_rows, cursor, conn):
'''creates and fills the table with detailed regis. information
'''
detailed_registration_data = []
try:
for i in range(0, number_of_rows):
detailed_registration_data.append(
(rnd_id_generator(self), self.faker.safe_email(),
self.faker.md5(raw_output=False), self.faker.last_name(),
self.faker.first_name(), self.faker.address(),
self.faker.phone_number()))
detailed_registration_payload = (
"INSERT INTO detailed_registration "
"(id, email, password, lastname, name,"
"address, phone) "
"VALUES (%s, %s, %s, %s, %s, %s, %s)")
cursor.executemany(detailed_registration_payload,
detailed_registration_data)
conn.commit()
logger.warning(
'detailed_registration Commits are successful after write job!',
extra=extra_information)
except Exception as e:
logger.error(e, extra=extra_information)
def data_filler_user_agent(self, number_of_rows, conn):
'''creates and fills the table with user agent data
'''
cursor = conn.cursor()
cursor.execute('''
CREATE TABLE user_agent(id TEXT PRIMARY KEY,
ip TEXT, countrycode TEXT, useragent TEXT)
''')
conn.commit()
multi_lines = []
try:
for i in range(0, number_of_rows):
multi_lines.append(
(rnd_id_generator(self), self.faker.ipv4(),
self.faker.country_code(), self.faker.user_agent()))
cursor.executemany('insert into user_agent values(?,?,?,?)',
multi_lines)
conn.commit()
logger.warning(
'user_agent Commits are successful after write job!', extra=d)
except Exception as e:
logger.error(e, extra=d)
def data_filler_detailed_registration(self, number_of_rows, conn):
'''creates and fills the table with detailed regis. information
'''
cursor = conn.cursor()
cursor.execute('''
CREATE TABLE detailed_registration(id TEXT PRIMARY KEY,
email TEXT, password TEXT, lastname TEXT,
name TEXT, adress TEXT, phone TEXT)
''')
conn.commit()
multi_lines = []
try:
for i in range(0, number_of_rows):
multi_lines.append((rnd_id_generator(self), self.faker.safe_email(),
self.faker.md5(raw_output=False), self.faker.last_name(),
self.faker.first_name(), self.faker.address(), self.faker.phone_number()))
cursor.executemany('insert into detailed_registration values(?,?,?,?,?,?,?)', multi_lines)
conn.commit()
logger.warning('detailed_registration Commits are successful after write job!', extra=d)
except Exception as e:
logger.error(e, extra=d)
def data_filler_detailed_registration(self, number_of_rows, db):
'''creates and fills the table with detailed regis. information
'''
try:
detailed_registration = db.detailed_registration
for i in range(0, number_of_rows):
post_det_reg = {
"id": rnd_id_generator(self),
"email": self.faker.safe_email(),
"password": self.faker.md5(raw_output=False),
"lastname": self.faker.last_name(),
"name": self.faker.name(),
"adress": self.faker.address(),
"phone": self.faker.phone_number()
}
detailed_registration.insert(post_det_reg)
logger.warning(
'detailed_registration Commits are successful after write job!',
extra=d)
except Exception as e:
logger.error(e, extra=d)
def data_filler_customer(self, number_of_rows, cursor, conn):
'''creates and fills the table with customer
'''
customer_data = []
try:
for i in range(0, number_of_rows):
customer_data.append(
(rnd_id_generator(self), self.faker.first_name(),
self.faker.last_name(), self.faker.address(),
self.faker.country(), self.faker.city(),
self.faker.date(pattern="%d-%m-%Y"),
self.faker.date(pattern="%d-%m-%Y"),
self.faker.safe_email(), self.faker.phone_number(),
self.faker.locale()))
customer_payload = (
"INSERT INTO customer "
"(id, name, lastname, address, country, city, registry_date, birthdate, email, "
"phone_number, locale)"
"VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)")
cursor.executemany(customer_payload, customer_data)
conn.commit()
logger.warning(
'detailed_registration Commits are successful after write job!',
extra=extra_information)
except Exception as e:
logger.error(e, extra=extra_information)
def data_filler_detailed_registration(self, number_of_rows, db):
'''creates and fills the table with detailed regis. information
'''
try:
detailed_registration = db
data_list = list()
for i in range(0, number_of_rows):
post_det_reg = {
"id": rnd_id_generator(self),
"email": self.faker.safe_email(),
"password": self.faker.md5(raw_output=False),
"lastname": self.faker.last_name(),
"name": self.faker.first_name(),
"adress": self.faker.address(),
"phone": self.faker.phone_number()
}
detailed_registration.save(post_det_reg)
logger.warning(
'detailed_registration Commits are successful after write job!',
extra=d)
except Exception as e:
logger.error(e, extra=d)
def data_filler_customer(self, number_of_rows, db):
'''creates and fills the table with customer data
'''
try:
customer = db.customer
for i in range(0, number_of_rows):
post_cus_reg = {
"id": rnd_id_generator(self),
"name": self.faker.name(),
"lastname": self.faker.last_name(),
"address": self.faker.address(),
"country": self.faker.country(),
"city": self.faker.city(),
"registry_date": self.faker.date(pattern="%d-%m-%Y"),
"birthdate": self.faker.date(pattern="%d-%m-%Y"),
"email": self.faker.safe_email(),
"phone_number": self.faker.phone_number(),
"locale": self.faker.locale()
}
customer.insert(post_cus_reg)
logger.warning('customer Commits are successful after write job!',
extra=d)
except Exception as e:
logger.error(e, extra=d)
def data_filler_customer(self, number_of_rows, cursor, conn):
"""creates and fills the table with customer
"""
customer_data = []
try:
for i in range(0, number_of_rows):
customer_data.append(
(
rnd_id_generator(self),
self.faker.first_name(),
self.faker.last_name(),
self.faker.address(),
self.faker.country(),
self.faker.city(),
self.faker.date(pattern="%d-%m-%Y"),
self.faker.date(pattern="%d-%m-%Y"),
self.faker.safe_email(),
self.faker.phone_number(),
self.faker.locale(),
)
)
customer_payload = (
"INSERT INTO customer "
"(id, name, lastname, address, country, city, registry_date, birthdate, email, "
"phone_number, locale)"
"VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)"
)
cursor.executemany(customer_payload, customer_data)
conn.commit()
logger.warning("detailed_registration Commits are successful after write job!", extra=extra_information)
except Exception as e:
logger.error(e, extra=extra_information)
def data_filler_company(self, number_of_rows, conn):
'''creates and fills the table with company data
'''
cursor = conn.cursor()
cursor.execute('''
CREATE TABLE company(id TEXT PRIMARY KEY,
name TEXT, sdate TEXT, email TEXT, domain TEXT, city TEXT)
''')
conn.commit()
multi_lines = []
try:
for i in range(0, number_of_rows):
multi_lines.append((rnd_id_generator(self), self.faker.company(),
self.faker.date(pattern="%d-%m-%Y"),
self.faker.company_email(), self.faker.safe_email(),
self.faker.city()))
cursor.executemany('insert into company values (?,?,?,?,?,?)', multi_lines)
conn.commit()
logger.warning('companies Commits are successful after write job!', extra=d)
except Exception as e:
logger.error(e, extra=d)
def data_filler_detailed_registration(self, number_of_rows, cursor, conn):
"""creates and fills the table with detailed regis. information
"""
detailed_registration_data = []
try:
for i in range(0, number_of_rows):
detailed_registration_data.append(
(
rnd_id_generator(self),
self.faker.safe_email(),
self.faker.md5(raw_output=False),
self.faker.last_name(),
self.faker.first_name(),
self.faker.address(),
self.faker.phone_number(),
)
)
detailed_registration_payload = (
"INSERT INTO detailed_registration "
"(id, email, password, lastname, name,"
"address, phone) "
"VALUES (%s, %s, %s, %s, %s, %s, %s)"
)
cursor.executemany(detailed_registration_payload, detailed_registration_data)
conn.commit()
logger.warning("detailed_registration Commits are successful after write job!", extra=extra_information)
except Exception as e:
logger.error(e, extra=extra_information)
def data_filler_company(self, number_of_rows, cursor, conn):
"""creates and fills the table with company data
"""
companies_data = []
try:
for i in range(0, number_of_rows):
companies_data.append(
(
rnd_id_generator(self),
self.faker.company(),
self.faker.date(pattern="%Y-%m-%d"),
self.faker.company_email(),
self.faker.safe_email(),
self.faker.city(),
)
)
companies_payload = (
"INSERT INTO company " "(id, name, sdate, email, domain, city) " "VALUES (%s, %s, %s, %s, %s, %s)"
)
cursor.executemany(companies_payload, companies_data)
conn.commit()
logger.warning("companies Commits are successful after write job!", extra=extra_information)
except Exception as e:
logger.error(e, extra=extra_information)
def data_filler_customer(self, number_of_rows, conn):
'''creates and fills the table with customer data
'''
cursor = conn.cursor()
cursor.execute('''
CREATE TABLE customer(id TEXT PRIMARY KEY,
name TEXT, lastname TEXT, address TEXT, country TEXT, city TEXT, registry_date TEXT, birthdate TEXT, email TEXT,
phone_number TEXT, locale TEXT)
''')
conn.commit()
multi_lines = []
try:
for i in range(0, number_of_rows):
multi_lines.append((rnd_id_generator(self), self.faker.name(), self.faker.last_name(), self.faker.address(),
self.faker.country(), self.faker.city(), self.faker.date(pattern="%d-%m-%Y"),
self.faker.date(pattern="%d-%m-%Y"), self.faker.safe_email(), self.faker.phone_number(),
self.faker.locale()))
cursor.executemany('insert into customer values (?,?,?,?,?,?,?,?,?,?,?)', multi_lines)
conn.commit()
logger.warning('customer Commits are successful after write job!', extra=d)
except Exception as e:
logger.error(e, extra=d)
def data_filler_detailed_registration(self, number_of_rows, conn):
'''creates and fills the table with detailed regis. information
'''
cursor = conn.cursor()
cursor.execute('''
CREATE TABLE detailed_registration(id TEXT PRIMARY KEY,
email TEXT, password TEXT, lastname TEXT,
name TEXT, adress TEXT, phone TEXT)
''')
conn.commit()
multi_lines = []
try:
for i in range(0, number_of_rows):
multi_lines.append((rnd_id_generator(self), self.faker.safe_email(),
self.faker.md5(raw_output=False), self.faker.last_name(),
self.faker.name(), self.faker.address(), self.faker.phone_number()))
cursor.executemany('insert into detailed_registration values(?,?,?,?,?,?,?)', multi_lines)
conn.commit()
logger.warning('detailed_registration Commits are successful after write job!', extra=d)
except Exception as e:
logger.error(e, extra=d)
def data_filler_customer(self, number_of_rows, conn):
'''creates and fills the table with customer data
'''
cursor = conn.cursor()
cursor.execute('''
CREATE TABLE customer(id TEXT PRIMARY KEY,
name TEXT, lastname TEXT, address TEXT, country TEXT, city TEXT, registry_date TEXT, birthdate TEXT, email TEXT,
phone_number TEXT, locale TEXT)
''')
conn.commit()
multi_lines = []
try:
for i in range(0, number_of_rows):
multi_lines.append((rnd_id_generator(self), self.faker.first_name(), self.faker.last_name(), self.faker.address(),
self.faker.country(), self.faker.city(), self.faker.date(pattern="%d-%m-%Y"),
self.faker.date(pattern="%d-%m-%Y"), self.faker.safe_email(), self.faker.phone_number(),
self.faker.locale()))
cursor.executemany('insert into customer values (?,?,?,?,?,?,?,?,?,?,?)', multi_lines)
conn.commit()
logger.warning('customer Commits are successful after write job!', extra=d)
except Exception as e:
logger.error(e, extra=d)
def data_filler_company(self, number_of_rows, conn):
'''creates and fills the table with company data
'''
cursor = conn.cursor()
cursor.execute('''
CREATE TABLE company(id TEXT PRIMARY KEY,
name TEXT, sdate TEXT, email TEXT, domain TEXT, city TEXT)
''')
conn.commit()
multi_lines = []
try:
for i in range(0, number_of_rows):
multi_lines.append((rnd_id_generator(self), self.faker.company(),
self.faker.date(pattern="%d-%m-%Y"),
self.faker.company_email(), self.faker.safe_email(),
self.faker.city()))
cursor.executemany('insert into company values (?,?,?,?,?,?)', multi_lines)
conn.commit()
logger.warning('companies Commits are successful after write job!', extra=d)
except Exception as e:
logger.error(e, extra=d)
def custom_db_creator(self, number_of_rows, cursor, conn, custom):
'''creates and fills the table with simple regis. information
'''
custom_d = faker_options_container()
sqlst = "CREATE TABLE `custom` (`id` varchar(300) NOT NULL,"
custom_payload = "INSERT INTO custom (id,"
# form the sql query that will set the db up
for c in custom:
if custom_d.get(c):
sqlst += " `" + c + "` " + custom_d[c] + ","
custom_payload += " " + c + ","
logger.warning("fake2db found valid custom key provided: %s" %
c,
extra=extra_information)
else:
logger.error(
"fake2db does not support the custom key you provided.",
extra=extra_information)
sys.exit(1)
# the indice thing is for trimming the last extra comma
sqlst += " PRIMARY KEY (`id`)) ENGINE=InnoDB"
custom_payload = custom_payload[:-1]
custom_payload += ") VALUES (%s, "
for i in range(0, len(custom)):
custom_payload += "%s, "
custom_payload = custom_payload[:-2] + ")"
try:
cursor.execute(sqlst)
conn.commit()
except mysql.connector.Error as err:
logger.error(err.msg, extra=extra_information)
multi_lines = []
try:
for i in range(0, number_of_rows):
multi_lines.append([rnd_id_generator(self)])
for c in custom:
multi_lines[i].append(getattr(self.faker, c)())
cursor.executemany(custom_payload, multi_lines)
conn.commit()
logger.warning('custom Commits are successful after write job!',
extra=extra_information)
except Exception as e:
logger.error(e, extra=extra_information)
def data_filler_company(self, number_of_rows, cursor, conn):
'''creates and fills the table with company data
'''
try:
for i in range(0, number_of_rows):
companies_payload = ("INSERT INTO companies "
"(id, name, sdate, email, domain, city) "
"VALUES (%s, %s, %s, %s, %s, %s)")
companies_data = (rnd_id_generator(self), self.faker.name(), self.faker.date(pattern="%d-%m-%Y"),
self.faker.company_email(), self.faker.safe_email(), self.faker.city())
cursor.execute(companies_payload, companies_data)
conn.commit()
logger.warning('companies Commits are successful after write job!', extra=d)
except Exception as e:
logger.error(e, extra=d)
def data_filler_user_agent(self, number_of_rows, cursor, conn):
'''creates and fills the table with user agent data
'''
try:
for i in range(0, number_of_rows):
user_agent_payload = ("INSERT INTO user_agent "
"(id, ip, countrycode, useragent) "
"VALUES (%s, %s, %s, %s)")
user_agent_data = (rnd_id_generator(self), self.faker.ipv4(), self.faker.country_code(),
self.faker.user_agent())
cursor.execute(user_agent_payload, user_agent_data)
conn.commit()
logger.warning('user_agent Commits are successful after write job!', extra=extra_information)
except Exception as e:
logger.error(e, extra=extra_information)
def data_filler_simple_registration(self, number_of_rows, pipe):
'''creates keys with simple regis. information
'''
try:
for i in range(number_of_rows):
pipe.hmset('simple_registration:%s' % i, {
'id': rnd_id_generator(self),
'email': self.faker.safe_email(),
'password': self.faker.md5(raw_output=False)
})
pipe.execute()
logger.warning('simple_registration Commits are successful after write job!', extra=d)
except Exception as e:
logger.error(e, extra=d)
def data_filler_user_agent(self, number_of_rows, pipe):
'''creates keys with user agent data
'''
try:
for i in range(number_of_rows):
pipe.hmset('user_agent:%s' % i, {
'id': rnd_id_generator(self),
'ip': self.faker.ipv4(),
'countrycode': self.faker.country_code(),
'useragent': self.faker.user_agent()
})
pipe.execute()
logger.warning('user_agent Commits are successful after write job!', extra=d)
except Exception as e:
logger.error(e, extra=d)
def custom_db_creator(self, number_of_rows, cursor, conn, custom):
"""creates and fills the table with simple regis. information
"""
custom_d = faker_options_container()
sqlst = "CREATE TABLE `custom` (`id` varchar(300) NOT NULL,"
custom_payload = "INSERT INTO custom (id,"
# form the sql query that will set the db up
for c in custom:
if custom_d.get(c):
sqlst += " `" + c + "` " + custom_d[c] + ","
custom_payload += " " + c + ","
logger.warning("fake2db found valid custom key provided: %s" % c, extra=extra_information)
else:
logger.error("fake2db does not support the custom key you provided.", extra=extra_information)
sys.exit(1)
# the indice thing is for trimming the last extra comma
sqlst += " PRIMARY KEY (`id`)) ENGINE=InnoDB"
custom_payload = custom_payload[:-1]
custom_payload += ") VALUES (%s, "
for i in range(0, len(custom)):
custom_payload += "%s, "
custom_payload = custom_payload[:-2] + ")"
try:
cursor.execute(sqlst)
conn.commit()
except mysql.connector.Error as err:
logger.error(err.msg, extra=extra_information)
multi_lines = []
try:
for i in range(0, number_of_rows):
multi_lines.append([rnd_id_generator(self)])
for c in custom:
multi_lines[i].append(getattr(self.faker, c)())
cursor.executemany(custom_payload, multi_lines)
conn.commit()
logger.warning("custom Commits are successful after write job!", extra=extra_information)
except Exception as e:
logger.error(e, extra=extra_information)
def data_filler_user_agent(self, number_of_rows, db):
'''creates and fills the table with user agent data
'''
try:
user_agent = db.user_agent
for i in range(0, number_of_rows):
post_uo_reg={"id": rnd_id_generator(self),
"ip": self.faker.ipv4(),
"countrycode": self.faker.country_code(),
"useragent": self.faker.user_agent()
}
user_agent.insert(post_uo_reg)
logger.warning('user_agent Commits are successful after write job!', extra=d)
except Exception as e:
logger.error(e, extra=d)
def data_filler_user_agent(self, number_of_rows, db):
'''creates and fills the table with user agent data
'''
try:
user_agent = db.user_agent
for i in range(0, number_of_rows):
post_uo_reg={"id": rnd_id_generator(self),
"ip": self.faker.ipv4(),
"countrycode": self.faker.country_code(),
"useragent": self.faker.user_agent()
}
user_agent.insert(post_uo_reg)
logger.warning('user_agent Commits are successful after write job!', extra=d)
except Exception as e:
logger.error(e, extra=d)
def data_filler_company(self, number_of_rows, cursor, conn):
'''creates and fills the table with company data
'''
try:
for i in range(0, number_of_rows):
companies_payload = ("INSERT INTO company "
"(id, name, sdate, email, domain, city) "
"VALUES (%s, %s, %s, %s, %s, %s)")
companies_data = (rnd_id_generator(self), self.faker.company(),
self.faker.date(pattern="%d-%m-%Y"),
self.faker.company_email(),
self.faker.safe_email(), self.faker.city())
cursor.execute(companies_payload, companies_data)
conn.commit()
logger.warning('companies Commits are successful after write job!',
extra=extra_information)
except Exception as e:
logger.error(e, extra=extra_information)
def data_filler_simple_registration(self, number_of_rows, cursor, conn):
'''creates and fills the table with simple regis. information
'''
try:
for i in range(0, number_of_rows):
simple_registration_payload = ("INSERT INTO simple_registration "
"(id, email, password) "
"VALUES (%s, %s, %s)")
simple_registration_data = (
rnd_id_generator(self), self.faker.safe_email(), self.faker.md5(raw_output=False))
cursor.execute(simple_registration_payload, simple_registration_data)
conn.commit()
logger.warning('simple_registration Commits are successful after write job!', extra=extra_information)
except Exception as e:
logger.error(e, extra=extra_information)
def data_filler_simple_registration(self, number_of_rows, conn):
'''creates and fills the table with simple regis. information
'''
cursor = conn.cursor()
cursor.execute('''
CREATE TABLE simple_registration(id TEXT PRIMARY KEY,
email TEXT , password TEXT)
''')
conn.commit()
try:
for i in range(0, number_of_rows):
cursor.execute('insert into simple_registration values(?,?,?)',
(rnd_id_generator(self), self.faker.safe_email(), self.faker.md5(raw_output=False)))
conn.commit()
logger.warning('simple_registration Commits are successful after write job!', extra=d)
except Exception as e:
logger.error(e, extra=d)
def data_filler_simple_registration(self, number_of_rows, db):
'''creates and fills the table with simple regis. information
'''
try:
simple_registration = db.simple_registration
for i in range(0, number_of_rows):
post_simple_reg = {"id": rnd_id_generator(self),
"email": self.faker.safe_email(),
"password": self.faker.md5(raw_output=False)
}
simple_registration.insert(post_simple_reg)
logger.warning('simple_registration Commits are successful after write job!', extra=d)
except Exception as e:
logger.error(e, extra=d)
def data_filler_user_agent(self, number_of_rows, cursor, conn):
'''creates and fills the table with user agent data
'''
user_agent_data = []
try:
for i in range(0, number_of_rows):
user_agent_data.append((rnd_id_generator(self), self.faker.ipv4(),
self.faker.country_code(), self.faker.user_agent()))
user_agent_payload = ("INSERT INTO user_agent "
"(id, ip, countrycode, useragent) "
"VALUES (%s, %s, %s, %s)")
cursor.executemany(user_agent_payload, user_agent_data)
conn.commit()
logger.warning('user_agent Commits are successful after write job!', extra=extra_information)
except Exception as e:
logger.error(e, extra=extra_information)
def data_filler_company(self, number_of_rows, db):
'''creates and fills the table with company data
'''
try:
company = db.company
for i in range(0, number_of_rows):
post_comp_reg = {"id": rnd_id_generator(self),
"name": self.faker.company(),
"date": self.faker.date(pattern="%d-%m-%Y"),
"email": self.faker.company_email(),
"domain": self.faker.safe_email(),
"city": self.faker.city()
}
company.insert(post_comp_reg)
logger.warning('companies Commits are successful after write job!', extra=d)
except Exception as e:
logger.error(e, extra=d)
def data_filler_simple_registration(self, number_of_rows, db):
'''creates and fills the table with simple regis. information
'''
try:
simple_registration = db.simple_registration
for i in range(0, number_of_rows):
post_simple_reg = {"id": rnd_id_generator(self),
"email": self.faker.safe_email(),
"password": self.faker.md5(raw_output=False)
}
simple_registration.insert(post_simple_reg)
logger.warning('simple_registration Commits are successful after write job!', extra=d)
except Exception as e:
logger.error(e, extra=d)
def data_filler_company(self, number_of_rows, pipe):
'''creates keys with company data
'''
try:
for i in range(number_of_rows):
pipe.hmset('company:%s' % i, {
'id': rnd_id_generator(self),
'name': self.faker.company(),
'date': self.faker.date(pattern="%d-%m-%Y"),
'email': self.faker.company_email(),
'domain': self.faker.safe_email(),
'city': self.faker.city()
})
pipe.execute()
logger.warning('companies Commits are successful after write job!', extra=d)
except Exception as e:
logger.error(e, extra=d)
def data_filler_company(self, number_of_rows, db):
'''creates and fills the table with company data
'''
try:
company = db.company
for i in range(0, number_of_rows):
post_comp_reg = {"id": rnd_id_generator(self),
"name": self.faker.name(),
"date": self.faker.date(pattern="%d-%m-%Y"),
"email": self.faker.company_email(),
"domain": self.faker.safe_email(),
"city": self.faker.city()
}
company.insert(post_comp_reg)
logger.warning('companies Commits are successful after write job!', extra=d)
except Exception as e:
logger.error(e, extra=d)
def custom_db_creator(self, number_of_rows, conn, custom):
'''creates and fills the table with simple regis. information
'''
cursor = conn.cursor()
custom_d = faker_options_container()
sqlst = '''
CREATE TABLE custom(id TEXT PRIMARY KEY,'''
# first one is always ID primary key
exec_many = 'insert into custom values(?,'
for c in custom:
if custom_d.get(c):
sqlst += " " + c + " TEXT, "
exec_many += '?,'
logger.warning("fake2db found valid custom key provided: %s" %
c,
extra=d)
else:
logger.error(
"fake2db does not support the custom key you provided.",
extra=d)
sys.exit(1)
sqlst = sqlst[:-2] + ")"
cursor.execute(sqlst)
conn.commit()
multi_lines = []
exec_many = exec_many[:-1] + ')'
try:
for i in range(0, number_of_rows):
multi_lines.append([rnd_id_generator(self)])
for c in custom:
multi_lines[i].append(getattr(self.faker, c)())
cursor.executemany(exec_many, multi_lines)
conn.commit()
logger.warning('custom Commits are successful after write job!',
extra=d)
except Exception as e:
logger.error(e, extra=d)
def data_filler_user_agent(self, number_of_rows, conn):
'''creates and fills the table with user agent data
'''
cursor = conn.cursor()
cursor.execute('''
CREATE TABLE user_agent(id TEXT PRIMARY KEY,
ip TEXT, countrycode TEXT, useragent TEXT)
''')
conn.commit()
try:
for i in range(0, number_of_rows):
cursor.execute('insert into user_agent values(?,?,?,?)',
(rnd_id_generator(self), self.faker.ipv4(), self.faker.country_code(),
self.faker.user_agent()))
conn.commit()
logger.warning('user_agent Commits are successful after write job!', extra=d)
except Exception as e:
logger.error(e, extra=d)
def data_filler_simple_registration(self, number_of_rows, cursor, conn):
'''creates and fills the table with simple regis. information
'''
simple_registration_data = []
try:
for i in range(0, number_of_rows):
simple_registration_data.append((
rnd_id_generator(self), self.faker.safe_email(), self.faker.md5(raw_output=False)))
simple_registration_payload = ("INSERT INTO simple_registration "
"(id, email, password) "
"VALUES (%s, %s, %s)")
cursor.executemany(simple_registration_payload, simple_registration_data)
conn.commit()
logger.warning('simple_registration Commits are successful after write job!', extra=extra_information)
except Exception as e:
logger.error(e, extra=extra_information)
def data_filler_detailed_registration(self, number_of_rows, pipe):
'''creates keys with detailed regis. information
'''
try:
for i in range(number_of_rows):
pipe.hmset('detailed_registration:%s' % i, {
'id': rnd_id_generator(self),
'email': self.faker.safe_email(),
'password': self.faker.md5(raw_output=False),
'lastname': self.faker.last_name(),
'name': self.faker.first_name(),
'address': self.faker.address(),
'phone': self.faker.phone_number()
})
pipe.execute()
logger.warning('detailed_registration Commits are successful after write job!', extra=d)
except Exception as e:
logger.error(e, extra=d)
def data_filler_simple_registration(self, number_of_rows, conn):
'''creates and fills the table with simple regis. information
'''
cursor = conn.cursor()
cursor.execute('''
CREATE TABLE simple_registration(id TEXT PRIMARY KEY,
email TEXT , password TEXT)
''')
conn.commit()
try:
for i in range(0, number_of_rows):
cursor.execute(
'insert into simple_registration values(?,?,?)',
(rnd_id_generator(self), self.faker.safe_email(),
self.faker.md5(raw_output=False)))
conn.commit()
logger.warning(
'simple_registration Commits are successful after write job!',
extra=d)
except Exception as e:
logger.error(e, extra=d)
def custom_db_creator(self, number_of_rows, conn, custom):
'''creates and fills the table with simple regis. information
'''
cursor = conn.cursor()
custom_d = faker_options_container()
sqlst = '''
CREATE TABLE custom(id TEXT PRIMARY KEY,'''
# first one is always ID primary key
exec_many = 'insert into custom values(?,'
for c in custom:
if custom_d.get(c):
sqlst += " " + c + " TEXT, "
exec_many += '?,'
logger.warning("fake2db found valid custom key provided: %s" % c, extra=d)
else:
logger.error("fake2db does not support the custom key you provided.", extra=d )
sys.exit(1)
sqlst = sqlst[:-2] + ")"
cursor.execute(sqlst)
conn.commit()
multi_lines = []
exec_many = exec_many[:-1] +')'
try:
for i in range(0, number_of_rows):
multi_lines.append([rnd_id_generator(self)])
for c in custom:
multi_lines[i].append(getattr(self.faker, c)())
cursor.executemany(exec_many, multi_lines)
conn.commit()
logger.warning('custom Commits are successful after write job!', extra=d)
except Exception as e:
logger.error(e, extra=d)
def custom_db_creator(self, number_of_rows, db, custom):
try:
data_list = list()
custom_d = faker_options_container()
for c in custom:
if custom_d.get(c):
logger.warning("fake2db found valid custom key provided: %s" % c, extra=d)
else:
logger.error("fake2db does not support the custom key you provided.", extra=d )
sys.exit(1)
for i in range(0, number_of_rows):
dict_c = {"id": rnd_id_generator(self)}
for c in custom:
dict_c[c] = getattr(self.faker, c)()
db.save(dict_c)
logger.warning('custom Commits are successful after write job!', extra=d)
except Exception as e:
logger.error(e, extra=d)
def data_filler_customer(self, number_of_rows, pipe):
'''creates keys with customer data
'''
try:
for i in range(number_of_rows):
pipe.hmset('customer:%s' % i, {
'id': rnd_id_generator(self),
'name': self.faker.first_name(),
'lastname': self.faker.last_name(),
'address': self.faker.address(),
'country': self.faker.country(),
'city': self.faker.city(),
'registry_date': self.faker.date(pattern="%d-%m-%Y"),
'birthdate': self.faker.date(pattern="%d-%m-%Y"),
'email': self.faker.safe_email(),
'phone_number': self.faker.phone_number(),
'locale': self.faker.locale()
})
pipe.execute()
logger.warning('customer Commits are successful after write job!', extra=d)
except Exception as e:
logger.error(e, extra=d)
