Skip to content

Instantly share code, notes, and snippets.

@bgrins
Last active November 18, 2022 16:11
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save bgrins/8ccaadbaa434013223295ceeeef13ac9 to your computer and use it in GitHub Desktop.
Save bgrins/8ccaadbaa434013223295ceeeef13ac9 to your computer and use it in GitHub Desktop.

Default settings

fake2db  --name 200rows --rows 200 --db sqlite

All custom columns supported by SQLite

The list was fetched from https://github.com/emirozer/fake2db/blob/master/fake2db/custom.py

fake2db --rows 200 --name all_columns --db sqlite --custom name_male address am_pm boolean opera paragraph bs building_number password century phone_number chrome postalcode city postalcode_plus4 city_prefix postcode city_suffix prefix color_name prefix_female company prefix_male company_email company_suffix country country_code credit_card_expire credit_card_full credit_card_number credit_card_provider credit_card_security_code currency_code date random_digit random_digit_not_null random_digit_not_null_or_empty random_digit_or_empty random_element day_of_month random_int day_of_week random_letter domain_name random_number domain_word ean rgb_color ean13 ean8 email safari file_extension safe_color_name file_name safe_email firefox safe_hex_color first_name secondary_address first_name_female first_name_male sentence free_email free_email_domain sha1 sha256 slug hex_color ssn image_url state internet_explorer state_abbr ipv4 street_address ipv6 street_name iso8601 street_suffix job suffix language_code suffix_female last_name suffix_male last_name_female text last_name_male time timezone linux_platform_token tld linux_processor unix_time locale uri uri_extension mac_address uri_page mac_platform_token uri_path mac_processor url md5 user_agent military_apo user_name military_dpo uuid4 military_ship windows_platform_token military_state word mime_type month year month_name zipcode name zipcode_plus4 name_female

By trial and error, the following were not supported:

 profile provider prgb_css_color date_time_ad  date_time_between date_time_between_dates date_time_this_month date_time_this_decade date_time_this_year rgb_color_list geo_coordinate longitude latitude time_delta words
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment