def generate_clients(connection, cursor): emails = get_list("data/emails.txt") countries = get_table_ids(cursor, "Countries") cities = get_list("data/cities.txt") phones = get_list("data/phone_numbers.txt") for i in range(0, 150): Email = get_random_value(emails) CountryID = get_random_value(countries) City = get_random_value(cities) Phone = get_random_value(phones) cursor.callproc("CreateClient", (Email, CountryID, City, Phone)) connection.commit()
def generate_individuals(connection, cursor): first_names = get_list("data/first_names.txt") last_names = get_list("data/last_names.txt") clients = get_table_ids(cursor, "Clients") letters = ["1", "2", "3", "4", "5", "6", "7", "8", "9"] for ClientID in clients: FirstName = get_random_value(first_names) LastName = get_random_value(last_names) StudentID = None if randint(1, 10) == 5: StudentID = "".join((random.choice(letters) for i in range(6))) try: cursor.callproc("CreateIndividualClient", (ClientID, FirstName, LastName, StudentID)) except pymssql.DatabaseError as e: pass connection.commit()
def generate_companies(connection, cursor): company_names = get_list("data/company_names.txt") clients = get_table_ids(cursor, "Clients") for ClientID, CompanyName in zip(clients, company_names): cursor.callproc("CreateCompany", (ClientID, CompanyName)) connection.commit()