Пример #1
0
def create_person():
    from mimesis import Person as MimesisPerson, locales, Address

    person = MimesisPerson(locales.RU)
    address = Address(locales.RU)

    with transaction.atomic():
        first_name = person.name()
        last_name = person.surname()

        gender = person.gender()
        if gender == 'Муж.':
            patronymic = choice([
                'Сергеевич', 'Николаевич', 'Артурович', 'Константинович',
                'Игоревич'
            ])
        else:
            patronymic = choice([
                'Александровна', 'Борисовна', 'Петровна', 'Юрьевна',
                'Анатольевна'
            ])

        birth_date = generate_birthdate()
        address = '{}, {}'.format(address.federal_subject(), address.address())

        passport_series = randint(1000, 7000)
        passport_number = randint(100000, 999999)

        pair = generate_RSA_pair()

        signature_public_key = pair[1]
        load_key_to_file(
            '../../../person_signature_private_keys/{}_{}_{}_{}.pem'.format(
                passport_series, passport_number, last_name, first_name),
            pair[0])

        person_info = '{} {} {} {} {} {} {} {}'.format(
            first_name, last_name, patronymic, birth_date, address,
            passport_series, passport_number, signature_public_key)

        signature_i = sign_person_info(person_info)

        Person(first_name=first_name,
               last_name=last_name,
               patronymic=patronymic,
               birth_date=birth_date,
               address=address,
               passport_series=passport_series,
               passport_number=passport_number,
               signature_public_key=signature_public_key,
               signature_i=signature_i).save()
Пример #2
0
def generate_random_data():
    p = Person()
    a = Address()

    return {
        "name": p.full_name(),
        "email": p.email(),
        "nationality": p.nationality(),
        "occupation": p.occupation(),
        "password": p.password(),
        "phone": p.telephone(),
        "address": a.address(),
        "city": a.city(),
        "street_no": a.street_number(),
        "created": Datetime().date().isoformat(),
    }
def generate_fake_persons(size):
    """ This function generates a list of dummy persons
        (email, username, fullname, DOB, address and ssn)
    """
    person = Personal('en')
    datetime = Datetime()
    address = Address('en')
    usa_provider = USASpecProvider()

    fake_persons = []
    for _ in range(0, size):
        fake_person = (person.email(), person.username(), \
                       person.full_name(), datetime.date(1970, 2000), \
                       address.address() + " - " + address.state(), usa_provider.ssn())
        fake_persons.append(fake_person)

    return fake_persons
Пример #4
0
def get_data(address: Address, lang: str):
    return {
        'address': address.address(),
        'calling_code': address.calling_code(),
        'city': address.city(),
        'continent': address.continent(),
        'coordinates': address.coordinates(),
        'country': address.country(),
        'country_code': get_country_code(lang),
        'latitude': address.latitude(),
        'longitude': address.longitude(),
        'postal_code': address.postal_code(),
        'state': address.state(),
        'street_name': address.street_name(),
        'street_number': address.street_number(),
        'street_suffix': address.street_suffix(),
        'zip_code': address.zip_code()
    }
Пример #5
0
def generatingData(num, locale, country):
    person = Person(locale)
    address = Address(locale)
    buffer = io.StringIO()
    writer = csv.writer(buffer,
                        delimiter=';',
                        lineterminator="\n",
                        quoting=csv.QUOTE_NONE,
                        escapechar='\\')
    for i in range(int(num)):
        writer.writerow([
            person.full_name(),
            country if randint(0, 1) == 1 else address.country(),
            ', '.join([address.province(),
                       address.city(),
                       address.address()]),
            person.telephone()
        ])
    return buffer.getvalue()
Пример #6
0
def generate():
    inserts = []
    counter = 350

    business = Business('en')
    address = Address('en')
    internet = Internet('en')

    for index in range(counter, 15000, 1):
        inserts.append(
            template.substitute(id=index,
                                name=business.company().replace("'", "''"),
                                address=address.address().replace("'", "''"),
                                credit=random.randint(300, 1000000),
                                website=internet.home_page().replace(
                                    "'", "''")))

    inserts_file = open('result_scripts/customers.sql', 'w', encoding='utf-8')
    inserts_file.writelines('\n'.join(inserts))
    inserts_file.close()
Пример #7
0
def generatePeople(row_num: int, region: str):
    if region == 'en_US':
        locale = 'en'
    elif region == 'ru_RU':
        locale = 'ru'
    else:
        locale = 'uk'
    writer = csv.writer(stdout,
                        quoting=csv.QUOTE_NONE,
                        delimiter=';',
                        escapechar='"')
    person = Person(locale)
    address = Address(locale)
    for i in range(row_num):
        writer.writerow([
            person.full_name(),
            address.country(),
            address.region(),
            address.city(),
            address.address(),
            address.zip_code(),
            person.telephone()
        ])
Пример #8
0
from mimesis import random
from mimesis.enums import Gender
import random

person = Person('ru')
address = Address('ru')
datetime = Datetime()
file = open("clients.txt", 'w')

list_rating = []
list_cities = ['Истра', 'Правдинск', 'Соликамск', 'Железнодорожный', 'Углич', 'Белёв', 'Тайга', 'Красноармейск', 'Володарск', 'Гаджиево', 'Яровое', 'Багратионовск', 'Среднеуральск', 'Невельск', 'Питкяранта', 'Темников', 'Калач-на-Дону', 'Сергиев Посад', 'Бугуруслан', 'Калининград', 'Лесной', 'Ишимбай', 'Жирновск', 'Нефтекамск', 'Серпухов', 'Балахна', 'Железногорск', 'Тюкалинск', 'Воронеж', 'Черемхово', 'Каменск-Уральский', 'Эртиль', 'Алагир', 'Новокубанск', 'Избербаш', 'Гуково', 'Сокол', 'Ельня', 'Баймак', 'Ступино', 'Высоцк', 'Коломна', 'Сосновоборск', 'Суздаль', 'Сковородино', 'Оханск', 'Малгобек', 'Спасск-Дальний', 'Каменск-Шахтинский', 'Юхнов']
list_date = []
list_phones = []
list_email = []
list_seniority = []
list_shops = []

for i in range(10000):
    list_date.append(datetime.date(start = 1960, end = 2005))
    list_phones.append(person.telephone())
    list_email.append(person.email())
    list_shops.append(random.randint(1, 1000))

for i in range(10000):
    list_seniority.append(random.randint(0, 10))

for i in range(1, 10001):
    file.write("%d|%s|%s|г.%s, %s|%s|%s\n" %(i, person.full_name(), list_date[i-1], random.choice(list_cities), address.address(),
                                                   list_phones[i-1], list_email[i-1]))

Пример #9
0
    def ii_push_record(self, in_record: object) -> bool:
        """
        Responsible for pushing records out.
        Called when an input record is being sent to the plugin.
        :param in_record: The data for the incoming record.
        :return: False if there's a downstream error, or if there's an error with the field name, otherwise True.
        """

        if not self.parent.is_initialized:
            return False

        #create the new fields
        record_value = None
        for field in enumerate(self.record_info_out):
            if field[1].name == 'address_full_address':
                mimesis_object = Address(self.parent.Locale)
                record_value = mimesis_object.address()
            if field[1].name == 'address_coordinates':
                mimesis_object = Address(self.parent.Locale)
                record_value = str(mimesis_object.coordinates())
            if field[1].name == 'address_country':
                mimesis_object = Address(self.parent.Locale)
                record_value = mimesis_object.country()
            if field[1].name == 'address_postal_code':
                mimesis_object = Address(self.parent.Locale)
                record_value = mimesis_object.postal_code()
            if field[1].name == 'code_imei':
                mimesis_object = Code(self.parent.Locale)
                record_value = mimesis_object.imei()
            if field[1].name == 'code_isbn':
                mimesis_object = Code(self.parent.Locale)
                record_value = mimesis_object.isbn()
            if field[1].name == 'code_pin':
                mimesis_object = Code(self.parent.Locale)
                record_value = mimesis_object.pin()
            if field[1].name == 'food_dish':
                mimesis_object = Food(self.parent.Locale)
                record_value = mimesis_object.dish()
            if field[1].name == 'food_fruit':
                mimesis_object = Food(self.parent.Locale)
                record_value = mimesis_object.fruit()
            if field[1].name == 'food_vegetables':
                mimesis_object = Food(self.parent.Locale)
                record_value = mimesis_object.vegetable()
            '''if field[1].name == 'game_gaming_platform':
                mimesis_object = Games(self.parent.Locale)
                record_value = mimesis_object.gaming_platform()
            if field[1].name == 'game_titles':
                mimesis_object = Games(self.parent.Locale)
                record_value = mimesis_object.game()'''
            if field[1].name == 'person_blood_type':
                mimesis_object = Person(self.parent.Locale)
                record_value = mimesis_object.blood_type()
            if field[1].name == 'person_email':
                mimesis_object = Person(self.parent.Locale)
                record_value = mimesis_object.email()
            if field[1].name == 'person_full_name':
                mimesis_object = Person(self.parent.Locale)
                record_value = mimesis_object.full_name()
            if field[1].name == 'person_nationality':
                mimesis_object = Person(self.parent.Locale)
                record_value = mimesis_object.nationality()
            if field[1].name == 'person_occupation':
                mimesis_object = Person(self.parent.Locale)
                record_value = mimesis_object.occupation()
            if field[1].name == 'person_telephone':
                mimesis_object = Person(self.parent.Locale)
                record_value = mimesis_object.telephone()
            if field[1].name == 'science_atomic_number':
                mimesis_object = Science(self.parent.Locale)
                record_value = str(mimesis_object.atomic_number())
            if field[1].name == 'science_chemical_element':
                mimesis_object = Science(self.parent.Locale)
                record_value = mimesis_object.chemical_element()
            if field[1].name == 'transport_airplane':
                mimesis_object = Transport(self.parent.Locale)
                record_value = mimesis_object.airplane()
            if field[1].name == 'transport_car':
                mimesis_object = Transport(self.parent.Locale)
                record_value = mimesis_object.car()
            if field[1].name == 'transport_truck':
                mimesis_object = Transport(self.parent.Locale)
                record_value = mimesis_object.truck()
            if field[1].name == 'transport_vehicle_reg_code':
                mimesis_object = Transport(self.parent.Locale)
                record_value = mimesis_object.vehicle_registration_code()
                #pdb.set_trace()
            self.record_info_out[field[0]].set_from_string(self.record_creator, record_value)
        out_record = self.record_creator.finalize_record()
        #self.parent.output_anchor.push_record(out_record, False)
        self.record_creator.reset()


        # Copy the data from the incoming record into the outgoing record.
        self.record_creator.reset()
        self.record_copier.done_adding()
        self.record_copier.copy(self.record_creator, in_record)

        # Push the record downstream and quit if there's a downstream error.
        if not self.parent.output_anchor.push_record(out_record):
            return False

        return True
Пример #10
0
    def pi_push_all_records(self, n_record_limit: int) -> bool:
        """
        Called when a tool has no incoming data connection.
        :param n_record_limit: Set it to <0 for no limit, 0 for no records, and >0 to specify the number of records.
        :return: True for success, False for failure.
        """

        if not self.is_initialized:
            return False

        # Save a reference to the RecordInfo passed into this function in the global namespace, so we can access it later.
        record_info_out = Sdk.RecordInfo(self.alteryx_engine)

        # Adds the new field to the record.
        for field in self.column_name:
            self.output_field = record_info_out.add_field(field, self.output_type, size=self.field_size)

        # Lets the downstream tools know what the outgoing record metadata will look like, based on record_info_out.
        self.output_anchor.init(record_info_out)
        # Creating a new, empty record creator based on record_info_out's record layout.
        record_creator = record_info_out.construct_record_creator()

        #import pdb; pdb.set_trace()

        #sophs code:
        for record in range(self.record_limit):
            for field in enumerate(record_info_out):
                if field[1].name == 'address_full_address':
                    mimesis_object = Address(self.Locale)
                    record_value = mimesis_object.address()
                if field[1].name == 'address_coordinates':
                    mimesis_object = Address(self.Locale)
                    record_value = str(mimesis_object.coordinates())
                if field[1].name == 'address_country':
                    mimesis_object = Address(self.Locale)
                    record_value = mimesis_object.country()
                if field[1].name == 'address_postal_code':
                    mimesis_object = Address(self.Locale)
                    record_value = mimesis_object.postal_code()
                if field[1].name == 'code_imei':
                    mimesis_object = Code(self.Locale)
                    record_value = mimesis_object.imei()
                if field[1].name == 'code_isbn':
                    mimesis_object = Code(self.Locale)
                    record_value = mimesis_object.isbn()
                if field[1].name == 'code_pin':
                    mimesis_object = Code(self.Locale)
                    record_value = mimesis_object.pin()
                if field[1].name == 'food_dish':
                    mimesis_object = Food(self.Locale)
                    record_value = mimesis_object.dish()
                if field[1].name == 'food_fruit':
                    mimesis_object = Food(self.Locale)
                    record_value = mimesis_object.fruit()
                if field[1].name == 'food_vegetables':
                    mimesis_object = Food(self.Locale)
                    record_value = mimesis_object.vegetable()
                '''if field[1].name == 'game_gaming_platform':
                    mimesis_object = Games(self.Locale)
                    record_value = mimesis_object.gaming_platform()
                if field[1].name == 'game_titles':
                    mimesis_object = Games(self.Locale)
                    record_value = mimesis_object.game()'''
                if field[1].name == 'person_blood_type':
                    mimesis_object = Person(self.Locale)
                    record_value = mimesis_object.blood_type()
                if field[1].name == 'person_email':
                    mimesis_object = Person(self.Locale)
                    record_value = mimesis_object.email()
                if field[1].name == 'person_full_name':
                    mimesis_object = Person(self.Locale)
                    record_value = mimesis_object.full_name()
                if field[1].name == 'person_nationality':
                    mimesis_object = Person(self.Locale)
                    record_value = mimesis_object.nationality()
                if field[1].name == 'person_occupation':
                    mimesis_object = Person(self.Locale)
                    record_value = mimesis_object.occupation()
                if field[1].name == 'person_telephone':
                    mimesis_object = Person(self.Locale)
                    record_value = mimesis_object.telephone()
                if field[1].name == 'science_atomic_number':
                    mimesis_object = Science(self.Locale)
                    record_value = str(mimesis_object.atomic_number())
                if field[1].name == 'science_chemical_element':
                    mimesis_object = Science(self.Locale)
                    record_value = mimesis_object.chemical_element()
                if field[1].name == 'transport_airplane':
                    mimesis_object = Transport(self.Locale)
                    record_value = mimesis_object.airplane()
                if field[1].name == 'transport_car':
                    mimesis_object = Transport(self.Locale)
                    record_value = mimesis_object.car()
                if field[1].name == 'transport_truck':
                    mimesis_object = Transport(self.Locale)
                    record_value = mimesis_object.truck()
                if field[1].name == 'transport_vehicle_reg_code':
                    mimesis_object = Transport(self.Locale)
                    record_value = mimesis_object.vehicle_registration_code()
                record_info_out[field[0]].set_from_string(record_creator, record_value)
            out_record = record_creator.finalize_record()
            self.output_anchor.push_record(out_record, False)
            record_creator.reset()


        # Make sure that the output anchor is closed.
        self.output_anchor.close()
        return True
Пример #11
0
    'Тайга', 'Красноармейск', 'Володарск', 'Гаджиево', 'Яровое',
    'Багратионовск', 'Среднеуральск', 'Невельск', 'Питкяранта', 'Темников',
    'Калач-на-Дону', 'Сергиев Посад', 'Бугуруслан', 'Калининград', 'Лесной',
    'Ишимбай', 'Жирновск', 'Нефтекамск', 'Серпухов', 'Балахна', 'Железногорск',
    'Тюкалинск', 'Воронеж', 'Черемхово', 'Каменск-Уральский', 'Эртиль',
    'Алагир', 'Новокубанск', 'Избербаш', 'Гуково', 'Сокол', 'Ельня', 'Баймак',
    'Ступино', 'Высоцк', 'Коломна', 'Сосновоборск', 'Суздаль', 'Сковородино',
    'Оханск', 'Малгобек', 'Спасск-Дальний', 'Каменск-Шахтинский', 'Юхнов'
]
list_date = []
list_phones = []
list_email = []
list_seniority = []
list_shops = []

for i in range(10000):
    list_date.append(datetime.date(start=1985, end=1998))
    list_phones.append(person.telephone())
    list_email.append(person.email())
    list_shops.append(random.randint(1, 1000))

for i in range(10000):
    list_seniority.append(random.randint(0, 10))

for i in range(1, 10001):
    file.write(
        "%d|%s|%s|г.%s, %s|%s|%s|%d|%d\n" %
        (i, person.full_name(), list_date[i - 1], random.choice(list_cities),
         address.address(), list_phones[i - 1], list_email[i - 1],
         list_seniority[i - 1], list_shops[i - 1]))
def main():

    try:
        num_gen = int(sys.argv[1])
    except:
        num_gen = -1

    if len(sys.argv) < 2 or num_gen == -1:
        print(
            "Usage: python faker_customers_to_csv.py <INT: Number of Customers to generate>"
        )
        print("Exymple: python faker_customers_to_csv.py 10000")
        return

    # Generate Customers that are between 18 and 100 years old
    ls_dates = [
        fake_de.date_time_between(start_date="-100y",
                                  end_date="-18y",
                                  tzinfo=None) for i in range(0, num_gen)
    ]
    ls_dates.sort()

    ls_customer = []
    for i in range(0, len(ls_dates)):
        s_country = random_country()
        address = None
        person = None
        s_nationality = None
        if s_country == 'DE':
            address = Address('de')
            person = Person('de')
            s_nationality = 'Germany'
        elif s_country == 'AT':
            address = Address('de-at')
            person = Person('de-at')
            s_nationality = 'Austria'
        else:
            address = Address('de-ch')
            person = Person('de-ch')
            s_nationality = 'Switzerland'

        s_sex = random_mf_flag()
        gender = mimesis.enums.Gender.FEMALE if s_sex == 'F' else mimesis.enums.Gender.MALE
        s_first_name = person.name(gender)
        s_last_name = person.last_name(gender)
        s_marital_status = random_marital_status_flag()
        s_job = person.occupation()
        s_email = person.email()
        s_phone = person.telephone()
        i_number_children = random.randint(0, 4)
        s_address_street = address.address()
        s_address_zip = address.postal_code()
        s_address_city = address.city()

        t_customer = (customer_number(i), s_sex, s_first_name, s_last_name,
                      s_job, s_email, s_phone, i_number_children,
                      s_marital_status, ls_dates[i].replace(hour=0,
                                                            minute=0,
                                                            second=0,
                                                            microsecond=0),
                      s_address_street, s_address_zip, s_address_city,
                      s_country, s_nationality)
        ls_customer.append(t_customer)

    ls_columns = [
        'customer_id', 'gender', 'first_name', 'last_name', 'job', 'email',
        'phone', 'number_children', 'marital_status', 'date_of_birth',
        'street', 'zip', 'city', 'country_code', 'nationality'
    ]

    df_customer = pd.DataFrame(ls_customer, columns=ls_columns)

    df_customer.to_csv('output/customers__de_at_ch.csv',
                       sep=',',
                       index=False,
                       header=ls_columns)
Пример #13
0
    def gen_data_add_nested_struct(self, data_path, partition_date, num_rows,
                                   file_format):
        """
        Input
        - data_path: path where the partition will be created (string)
        - partition_date: partition date to be created (date)
        - num_rows: number of rows to be generated (integer)
        - file_format: format of file to be generated (parquet or avro)

        This function creates a data sample adding a nested struct to the schema
        """

        person = Person('en')
        address = Address('en')

        # Create schema
        schema_address = StructType([
            StructField('address', StringType(), True),
            StructField('city', StringType(), True),
            StructField('country', StringType(), True),
            StructField('state', StringType(), True),
            StructField('postal_code', StringType(), True)
        ])

        schema_df = StructType([
            StructField('identifier', StringType(), True),
            StructField('first_name', StringType(), True),
            StructField('last_name', StringType(), True),
            StructField('occupation', StringType(), True),
            StructField('age', IntegerType(), True),
            StructField('address', schema_address, True),
            StructField('date', DateType(), True)
        ])

        # Generate data
        for _ in range(num_rows):
            df_temp = self.spark.createDataFrame([[
                person.identifier(),
                person.first_name(),
                person.last_name(),
                person.occupation(),
                person.age(),
                [
                    address.address(),
                    address.city(),
                    address.country(),
                    address.state(),
                    address.postal_code()
                ], partition_date
            ]], schema_df)

            try:
                df = df.union(df_temp)
            except:
                df = df_temp

        df.coalesce(1).write.partitionBy('date').mode('overwrite').format(
            file_format).save(data_path)

        print('Partition created: {data_path}/date={date}'.format(
            data_path=data_path, date=partition_date))
        print('# Rows:', df.count())
        print('Schema:')
        df.printSchema()
        print('\n')

        return
Пример #14
0
from mimesis import Generic

generic = Generic('ko')

print(generic.datetime.month())
print(generic.code.imei())
print(generic.food.fruit())

from mimesis import Address

address_ko = Address('ko')

print(address_ko.region())
print(address_ko.federal_subject())
print(address_ko.address())
print(address_ko.address())

from mimesis import Person

person = Person('ko', seed=0xffff)
print(person.full_name())

from mimesis.schema import Field, Schema
from mimesis.enums import Gender

field = Field('ko')
schema_dict = (lambda: {
    'version': field('version', pre_release=True),
    'timestamp': field('timestamp', posix=False),
    'token': field('token_hex'),
Пример #15
0
#Генерація назв фруктів по назві
f = Generic('uk')
f.food.fruit()
print(f.food.fruit())

#Генерація області по мові
adr = Address('uk')
adr.region()
print(adr.region())

# Генерація країни по мові
adr = Address('uk')
adr.country()
print(adr.country())

# Генерація адреси
adr = Address('uk')
adr.address()
print(adr.address())

# Генерація поного імені людини з іншого регіону
person = Person(locales.EN)
person.full_name()
print(person.full_name())
with person.override_locale(locales.RU):
    person.full_name()
print(person.full_name())

person = Person('rtv', seed=0xFF)
person.full_name()
print(person.full_name())
Пример #16
0
    return 0.01*pow(np.abs(df[age] - 30), 2.5) + df[age] + 50*df[marketing_level]*gated_age + 2*df[account_balance] + noise


##################################################

##################################################
### Generate a DataFrame of user information
##################################################
# Generate 10,000 rows of the following:
# user_id, first_name, last_name, email, password, address,
# birth_date, credit_card_num, credit_card_exp, security_answer,
# account_balance

user_df = pd.DataFrame([[x, person.name(), person.surname(), person.gender(),
                        person.email(), hashed_passwd(person.password()),
                        address.address(), person.age(),
                        payment.credit_card_number(),
                        payment.credit_card_expiration_date(), text.word(),
                        account_balance(), np.random.randint(1, 11)]
                        for x in range(10000)])

user_df.columns = ["user_id", "first_name", "last_name",
                   "gender", "email", "password_hashed", "address",
                   "age", "credit_card_num", "credit_card_exp",
                   "security_answer", "account_balance",
                   "marketing_level"]

# Generate sales, based on a noisy linear model
user_df['sales'] = generate_sales(user_df)
user_df['sales'] = user_df['sales'] - user_df['sales'].min()
user_df['sales'] /= 40
Пример #17
0
from django.test import TestCase

# Create your tests here.
from organization.models import CityDict, CourseOrganization, OrgType
from mimesis.enums import Gender
from mimesis import Address, Development
import random

if __name__ == "__main__":
    zh = Address('zh')
    c = Development()
    citys = ["上海", "北京", "杭州", "深圳", "广东"]

    for i in citys:
        city = CityDict(name=i, desc="test")
        city.save()
        for i in range(100):
            org = CourseOrganization(name=c.backend(),
                                     desc=c.programming_language(),
                                     click_num=i * random.randint(1, 1000),
                                     fav_nums=i * random.randint(1, 1000),
                                     address=zh.address())
            org.city = city
            org.save()
'''
delete from city_dict;
delete from course_organization;
select * from city_dict;
select * from course_organization;
'''
Пример #18
0
##################################################
### Generate a DataFrame of user information
##################################################
# Generate 10,000 rows of the following:
# user_id, first_name, last_name, email, password, address,
# birth_date, credit_card_num, credit_card_exp, security_answer,
# account_balance

user_df = pd.DataFrame([[
    x,
    person.name(),
    person.surname(),
    person.gender(),
    person.email(),
    hashed_passwd(person.password()),
    address.address(),
    person.age(),
    payment.credit_card_number(),
    payment.credit_card_expiration_date(),
    text.word(),
    account_balance(),
    np.random.randint(1, 11)
] for x in range(10000)])

user_df.columns = [
    "user_id", "first_name", "last_name", "gender", "email", "password_hashed",
    "address", "age", "credit_card_num", "credit_card_exp", "security_answer",
    "account_balance", "marketing_level"
]

# Generate sales, based on a noisy linear model
Пример #19
0
    gender = random.choice(gen)
    if gender == 'Женский':
        first_name = p.first_name(gender=Gender.FEMALE)
        last_name = p.last_name(gender=Gender.FEMALE)
        #self.patron = rus.patronymic(gender = Gender.FEMALE)
    elif gender == 'Мужской':
        first_name = p.first_name(gender=Gender.MALE)
        last_name = p.last_name(gender=Gender.MALE)
        #self.patron = rus.patronymic(gender = Gender.MALE)
    age = p.age(minimum=18, maximum=70)
    month_ob = dt.month()
    day_ob = dt.day_of_month()
    year_ob = 2020 - age
    city_ob = adr.city()
    city = adr.city()
    address = adr.address()
    phone = p.telephone(mask='+7(###)-###-####')
    email = p.email(domains=['mimesis.name'])

    user = (int(idd), str(gender), str(first_name), str(last_name), str(age),
            str(month_ob), str(day_ob), str(year_ob), str(city_ob), str(city),
            str(address), str(phone), str(email))

    cur.execute(
        "INSERT INTO people VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);",
        user)
    conn.commit()
    n += 1

cur.execute("SELECT * FROM people;")
three_results = cur.fetchmany(-1)
Пример #20
0
def getting_started_example():
    generic = Generic()
    #generic = Generic(locales.EN)

    print('Month =', generic.datetime.month())
    print('Datetime =',
          generic.datetime.datetime(start=1900, end=2035,
                                    timezone=None))  # Type: datetime.datetime.
    print('IMEI =', generic.code.imei())
    print('Fruit =', generic.food.fruit())
    print('RNA =', generic.science.rna_sequence())

    print('Word =', generic.text.word())

    with generic.text.override_locale(locales.FR):
        print('Word =', generic.text.word())

    print('Word =', generic.text.word())

    generic = Generic('en')
    generic.add_provider(USASpecProvider)

    print('SSN =', generic.usa_provider.ssn())
    #print('CPF =', generic.usa_provider.cpf())  # AttributeError: 'USASpecProvider' object has no attribute 'cpf'.

    generic = Generic('pt-br')
    #generic = Generic(locales.PT_BR)
    generic.add_provider(BrazilSpecProvider)

    #print('SSN =', generic.brazil_provider.ssn())  # AttributeError: 'BrazilSpecProvider' object has no attribute 'ssn'.
    print('CPF =', generic.brazil_provider.cpf())

    #--------------------
    numbers = Numbers()

    print('Numbers =', numbers.between())  # Type: int.
    print('Numbers =', numbers.between(10, 10000000000000000))  # Type: int.

    #--------------------
    person = Person(locales.KO)

    print('Full name =', person.full_name(gender=Gender.FEMALE))
    print('Full name =', person.full_name(gender=Gender.MALE, reverse=True))

    with person.override_locale(locales.RU):
        print('Full name =', person.full_name())

    print('Full name =', person.full_name())
    print('Telephone =', person.telephone())
    print('Telephone =', person.telephone(mask='(###)-###-####'))
    print('Identifier =', person.identifier())
    print('Identifier =', person.identifier(mask='######-#######'))

    #--------------------
    de = Address('de')
    ru = Address('ru')

    print('Region =', de.region())
    print('Federal subject =', ru.federal_subject())
    print('Address =', de.address())
    print('Address =', ru.address())

    ko = Address('ko')

    print('Address =', ko.province(), ko.city(), ko.address())
    print('Zip code =', ko.zip_code())

    #--------------------
    business = Business('ko')

    #print('Price =', business.price(minimum=1.0, maximum=1000000000.0))  # Type: str.
    #print('Price =', business.price(minimum=1.0, maximum=1000000000.0)[:-2])  # Type: str.
    print('Price =',
          business.price(minimum=1.0, maximum=1000000000.0)[:-5])  # Type: str.

    #--------------------
    payment = Payment()

    print('Credit card =',
          payment.credit_card_number(card_type=None))  # Type: str.
Пример #21
0
file = open("shops.txt", 'w')

list_rating = []
list_cities = []

for i in range(50):
    list_cities.append(address.city())

print(list_cities)

for i in range(1000):
    list_rating.append(round(random.uniform(0, 5), 2))



'''
    for i in range(1000):
    if (list_age[i] < 30):
    list_seniority.append(random.randint(0, 5))
    elif (list_age[i] > 30 and list_age[i] < 35):
    list_seniority.append(random.randint(0, 10))
    elif (list_age[i] > 35 and list_age[i] < 45):
    list_seniority.append(random.randint(0, 15))
    else:
    list_seniority.append(random.randint(0, 20))
    '''

for i in range(1, 1001):
    file.write("%d|%.1f|г.%s, %s\n" %(i, list_rating[i-1], random.choice(list_cities), address.address()))

Пример #22
0
for i in range(count_bran):
    brabn = Branch(id=i,
                   organization_id=random.randrange(count_org),
                   name='Фелиал' + str(i))
    session.add(brabn)
    session.commit()

for i in range(count_dep):
    dep = Department(id=i,
                     branch_id=random.randrange(count_bran),
                     name='Отдел' + str(i))
    session.add(dep)
    session.commit()

for i in range(count_peop):
    gender0 = gender[random.randrange(len(gender))]

    peop = People(id=i,
                  first_name=person.first_name(gender=gender0),
                  last_name=person.last_name(gender=gender0),
                  department_id=random.randrange(count_dep),
                  position=positions[random.randrange(len(positions))],
                  number=gen_number(),
                  bday=dateTime.date(start=1970, end=2002),
                  address=address.address(),
                  gender=gender0.name)
    session.add(peop)
    session.commit()

session.close()
Пример #23
0
    error_list.append(random.randint(0, int(sys.argv[1]) - 1))

error_list.sort()
# print(error_list)

if sys.argv[2] == 'ru':
    address = Address('ru')
    person = Person('ru')
    kol = int(sys.argv[1])
    for i in range(0, kol):
        listok = list()
        listok.append(person.last_name() + " ")
        listok.append(person.name() + " ")
        listok.append(person.name() + "ович ")
        listok.append(person.telephone('+7 ### ### ## ##') + " ")
        listok.append(address.address())
        line = "".join(listok)
        line = func(line)
        print(line)
elif sys.argv[2] == 'en':
    address = Address('en')
    person = Person('en')
    for i in range(0, int(sys.argv[1])):
        listok = list()
        listok.append(person.last_name() + " ")
        listok.append(person.name() + " ")
        listok.append(person.name() + " ")
        listok.append(person.telephone('+1 ### ### ## ##') + " ")
        listok.append(address.address())
        line = "".join(listok)
        line = func(line)