Skip to content

Instantly share code, notes, and snippets.

@wbob

wbob/expressions.json

Last active July 18, 2019 08:35
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 wbob/d081fa380fc5724d6353dcd8a825406e to your computer and use it in GitHub Desktop.
Save wbob/d081fa380fc5724d6353dcd8a825406e to your computer and use it in GitHub Desktop.
Download ZIP
gdpr-dump-json
Raw
expressions.json
{
"s_articles_vote": {
"email": "CONCAT(LEFT(MD5(CONCAT(@seed, `email`)), LENGTH(`email`)), '@localhost')",
"name": "LEFT(MD5(CONCAT(@seed, `name`)), LENGTH(`name`))"
},
"s_articles_notification": {
"mail": "CONCAT(LEFT(MD5(CONCAT(@seed, `mail`)), LENGTH(`mail`)), '@localhost')"
},
"s_campaigns_mailaddresses": {
"email": "CONCAT(LEFT(MD5(CONCAT(@seed, `email`)), LENGTH(`email`)), '@localhost')"
},
"s_campaigns_maildata": {
"email": "CONCAT(LEFT(MD5(CONCAT(@seed, `email`)), LENGTH(`email`)), '@localhost')",
"firstname": "LEFT(MD5(CONCAT(@seed, `firstname`)), LENGTH(`firstname`))",
"lastname": "LEFT(MD5(CONCAT(@seed, `lastname`)), LENGTH(`lastname`))",
"street": "LEFT(MD5(CONCAT(@seed, `street`)), LENGTH(`street`))"
},
"s_core_auth": {
"username": "LEFT(MD5(CONCAT(@seed, `username`)), LENGTH(`username`))",
"name": "LEFT(MD5(CONCAT(@seed, `name`)), LENGTH(`name`))",
"email": "CONCAT(LEFT(MD5(CONCAT(@seed, `email`)), LENGTH(`email`)), '@', SUBSTRING_INDEX(`email`, '@', -1))",
"password": "\"\"",
"apiKey": "NULL",
"sessionID": "NULL"
},
"s_core_payment_data": {
"account_holder": "LEFT(MD5(CONCAT(@seed, `account_holder`)), LENGTH(`account_holder`))",
"account_number": "NULL",
"bank_code": "NULL",
"bic": "NULL",
"iban": "NULL"
},
"s_core_payment_instance": {
"firstname": "LEFT(MD5(CONCAT(@seed, `firstname`)), LENGTH(`firstname`))",
"lastname": "LEFT(MD5(CONCAT(@seed, `lastname`)), LENGTH(`lastname`))",
"address": "LEFT(MD5(CONCAT(@seed, `address`)), LENGTH(`address`))",
"zipcode": "LPAD(FLOOR(1 + (RAND() * 99998)), 5, '1')",
"city": "LEFT(MD5(CONCAT(@seed, `city`)), LENGTH(`city`))",
"account_holder": "LEFT(MD5(CONCAT(@seed, `account_holder`)), LENGTH(`account_holder`))",
"account_number": "NULL",
"bank_code": "NULL",
"bic": "NULL",
"iban": "NULL"
},
"s_core_optin": {
"hash": "MD5(`hash`)",
"data": "\"\""
},
"s_crontab": {
"data": "NULL"
},
"s_emarketing_partner": {
"idcode": "MD5(`idcode`)",
"company": "LEFT(MD5(CONCAT(@seed, `company`)), LENGTH(`company`))",
"contact": "LEFT(MD5(CONCAT(@seed, `contact`)), LENGTH(`contact`))",
"street": "LEFT(MD5(CONCAT(@seed, `street`)), LENGTH(`street`))",
"zipcode": "LPAD(FLOOR(1 + (RAND() * 99998)), 5, '1')",
"city": "LEFT(MD5(CONCAT(@seed, `city`)), LENGTH(`city`))",
"phone": "CONCAT('+', ROUND(RAND()*100000000))",
"fax": "CONCAT('+', ROUND(RAND()*100000000))",
"email": "CONCAT(LEFT(MD5(CONCAT(@seed, `email`)), LENGTH(`email`)), '@localhost')",
"web": "NULL",
"profil": "NULL"
},
"s_emarketing_vouchers": {
"vouchercode": "MD5(`vouchercode`)"
},
"s_emarketing_voucher_codes": {
"code": "MD5(`code`)"
},
"s_emarketing_tellafriend": {
"recipient": "CONCAT(LEFT(MD5(CONCAT(@seed, `recipient`)), LENGTH(`recipient`)), '@localhost')"
},
"s_statistics_currentusers": {
"remoteaddr": "INET_NTOA(RAND()*1000000000)"
},
"s_statistics_pool": {
"remoteaddr": "INET_NTOA(RAND()*1000000000)"
},
"s_statistics_referer": {
"referer": "NULL"
},
"s_plugin_widgets_notes": {
"notes": "NULL"
},
"s_user": {
"confirmationkey": "NULL",
"email": "CONCAT(LEFT(MD5(CONCAT(@seed, `email`)), LENGTH(`email`)), '@localhost')",
"firstname": "LEFT(MD5(CONCAT(@seed, `firstname`)), LENGTH(`firstname`))",
"lastname": "LEFT(MD5(CONCAT(@seed, `lastname`)), LENGTH(`lastname`))",
"password": "\"\"",
"birthday": "DATE_FORMAT(DATE_SUB(NOW(), INTERVAL FLOOR(18*365 + RAND() * 81*365) DAY), GET_FORMAT(DATE,'ISO'))",
"sessionID": "NULL"
},
"s_user_addresses": {
"company": "LEFT(MD5(CONCAT(@seed, `company`)), LENGTH(`company`))",
"department": "NULL",
"firstname": "LEFT(MD5(CONCAT(@seed, `firstname`)), LENGTH(`firstname`))",
"lastname": "LEFT(MD5(CONCAT(@seed, `lastname`)), LENGTH(`lastname`))",
"street": "LEFT(MD5(CONCAT(@seed, `street`)), LENGTH(`street`))",
"zip": "LPAD(FLOOR(1 + (RAND() * 99998)), 5, '1')",
"city": "LEFT(MD5(CONCAT(@seed, `city`)), LENGTH(`city`))",
"phone": "CONCAT('+', ROUND(RAND()*100000000))",
"additional_address_line1": "NULL",
"additional_address_line2": "NULL",
"ustid": "CONCAT('DE', LPAD(FLOOR(1 + (RAND() * 999999998)), 9, '0'))"
},
"s_user_addresses_attributes": {
"text1": "NULL",
"text2": "NULL",
"text3": "NULL",
"text4": "NULL",
"text5": "NULL",
"text6": "NULL"
},
"s_user_billingaddress": {
"company": "LEFT(MD5(CONCAT(@seed, `company`)), LENGTH(`company`))",
"department": "NULL",
"firstname": "LEFT(MD5(CONCAT(@seed, `firstname`)), LENGTH(`firstname`))",
"lastname": "LEFT(MD5(CONCAT(@seed, `lastname`)), LENGTH(`lastname`))",
"street": "LEFT(MD5(CONCAT(@seed, `street`)), LENGTH(`street`))",
"zip": "LPAD(FLOOR(1 + (RAND() * 99998)), 5, '1')",
"city": "LEFT(MD5(CONCAT(@seed, `city`)), LENGTH(`city`))",
"phone": "CONCAT('+', ROUND(RAND()*100000000))",
"additional_address_line1": "NULL",
"additional_address_line2": "NULL",
"ustid": "CONCAT('DE', LPAD(FLOOR(1 + (RAND() * 999999998)), 9, '0'))"
},
"s_user_billingaddress_attributes": {
"text1": "NULL",
"text2": "NULL",
"text3": "NULL",
"text4": "NULL",
"text5": "NULL",
"text6": "NULL"
},
"s_user_shippingaddress": {
"company": "LEFT(MD5(CONCAT(@seed, `company`)), LENGTH(`company`))",
"department": "NULL",
"firstname": "LEFT(MD5(CONCAT(@seed, `firstname`)), LENGTH(`firstname`))",
"lastname": "LEFT(MD5(CONCAT(@seed, `lastname`)), LENGTH(`lastname`))",
"street": "LEFT(MD5(CONCAT(@seed, `street`)), LENGTH(`street`))",
"zip": "LPAD(FLOOR(1 + (RAND() * 99998)), 5, '1')",
"city": "LEFT(MD5(CONCAT(@seed, `city`)), LENGTH(`city`))",
"phone": "CONCAT('+', ROUND(RAND()*100000000))",
"additional_address_line1": "NULL",
"additional_address_line2": "NULL",
"ustid": "CONCAT('DE', LPAD(FLOOR(1 + (RAND() * 999999998)), 9, '0'))"
},
"s_user_shippingaddress_attributes": {
"text1": "NULL",
"text2": "NULL",
"text3": "NULL",
"text4": "NULL",
"text5": "NULL",
"text6": "NULL"
},
"s_order": {
"transactionID": "NULL",
"customercomment": "NULL",
"internalcomment": "NULL",
"trackingcode": "NULL",
"remote_addr": "INET_NTOA(RAND()*1000000000)"
},
"s_order_billingaddress": {
"company": "LEFT(MD5(CONCAT(@seed, `company`)), LENGTH(`company`))",
"department": "NULL",
"firstname": "LEFT(MD5(CONCAT(@seed, `firstname`)), LENGTH(`firstname`))",
"lastname": "LEFT(MD5(CONCAT(@seed, `lastname`)), LENGTH(`lastname`))",
"street": "LEFT(MD5(CONCAT(@seed, `street`)), LENGTH(`street`))",
"zip": "LPAD(FLOOR(1 + (RAND() * 99998)), 5, '1')",
"city": "LEFT(MD5(CONCAT(@seed, `city`)), LENGTH(`city`))",
"phone": "CONCAT('+', ROUND(RAND()*100000000))",
"additional_address_line1": "NULL",
"additional_address_line2": "NULL",
"ustid": "CONCAT('DE', LPAD(FLOOR(1 + (RAND() * 999999998)), 9, '0'))"
},
"s_order_billingaddress_attributes": {
"text1": "NULL",
"text2": "NULL",
"text3": "NULL",
"text4": "NULL",
"text5": "NULL",
"text6": "NULL"
},
"s_order_shippingaddress": {
"company": "LEFT(MD5(CONCAT(@seed, `company`)), LENGTH(`company`))",
"department": "NULL",
"firstname": "LEFT(MD5(CONCAT(@seed, `firstname`)), LENGTH(`firstname`))",
"lastname": "LEFT(MD5(CONCAT(@seed, `lastname`)), LENGTH(`lastname`))",
"street": "LEFT(MD5(CONCAT(@seed, `street`)), LENGTH(`street`))",
"zip": "LPAD(FLOOR(1 + (RAND() * 99998)), 5, '1')",
"city": "LEFT(MD5(CONCAT(@seed, `city`)), LENGTH(`city`))",
"phone": "CONCAT('+', ROUND(RAND()*100000000))",
"additional_address_line1": "NULL",
"additional_address_line2": "NULL",
"title": "NULL"
},
"s_order_shippingaddress_attributes": {
"text1": "NULL",
"text2": "NULL",
"text3": "NULL",
"text4": "NULL",
"text5": "NULL",
"text6": "NULL"
},
"s_order_basket_signatures": {
"signature": "MD5(`signature`)",
"basket": "\"\""
},
"s_shopgate_customer": {
"token": "\"\""
},
"s_shopgate_orders": {
"reported_cancellations": "NULL",
"received_data": "NULL"
}
}
Raw
flushtables.json
{
"database": [
"s_es_backlog",
"s_core_sessions",
"s_core_sessions_backend",
"s_articles_also_bought_ro",
"s_articles_similar_shown_ro",
"s_articles_top_seller_ro",
"s_emarketing_lastarticles",
"s_campaigns_logs",
"s_customer_search_index",
"s_statistics_article_impression",
"s_statistics_search",
"s_statistics_visitors"
]
}
Raw
replacements.json
{
"s_articles_vote": {
"email": {
"formatter": "freeEmail"
},
"name": {
"formatter": "{{firstName}} {{lastName}}"
}
},
"s_campaigns_mailaddresses": {
"email": {
"formatter": "email"
}
},
"s_campaigns_maildata": {
"email": {
"formatter": "email"
},
"firstname": {
"formatter": "firstName"
},
"lastname": {
"formatter": "lastName"
},
"street": {
"formatter": "streetAddress"
}
},
"s_core_auth": {
"username": {
"formatter": "userName"
},
"name": {
"formatter": "name"
},
"email": {
"formatter": "email"
},
"password": {
"formatter": "md5"
},
"apiKey": {
"formatter": "clear"
},
"sessionID": {
"formatter": "clear"
}
},
"s_core_payment_data": {
"account_holder": {
"formatter": "{{firstName}} {{lastName}}"
},
"account_number": {
"formatter": "bankAccountNumber"
},
"bank_code": {
"formatter": "bank"
},
"bic": {
"formatter": "swiftBicNumber"
},
"iban": {
"formatter": "iban($countryCode)"
}
},
"s_core_payment_instance": {
"firstname": {
"formatter": "firstName"
},
"lastname": {
"formatter": "lastName"
},
"account_holder": {
"formatter": "{{firstName}} {{lastName}}"
},
"account_number": {
"formatter": "clear"
},
"bank_code": {
"formatter": "clear"
},
"bic": {
"formatter": "swiftBicNumber"
},
"iban": {
"formatter": "iban($countryCode)"
}
},
"s_core_optin": {
"hash": {
"formatter": "md5"
},
"data": {
"formatter": "clear"
}
},
"s_crontab": {
"data": {
"formatter": "clear"
}
},
"s_emarketing_partner": {
"idcode": {
"formatter": "md5"
},
"company": {
"formatter": "company"
},
"contact": {
"formatter": "{{firstName}} {{lastName}}"
},
"street": {
"formatter": "streetAddress"
},
"zipcode": {
"formatter": "postcode"
},
"city": {
"formatter": "city"
},
"phone": {
"formatter": "e164PhoneNumber"
},
"fax": {
"formatter": "e164PhoneNumber"
},
"email": {
"formatter": "email"
},
"web": {
"formatter": "clear"
},
"profil": {
"formatter": "clear"
}
},
"s_emarketing_vouchers": {
"vouchercode": {
"formatter": "md5"
}
},
"s_emarketing_voucher_codes": {
"code": {
"formatter": "md5"
}
},
"s_emarketing_tellafriend": {
"recipient": {
"formatter": "email"
}
},
"s_statistics_currentusers": {
"remoteaddr": {
"formatter": "ipv4"
}
},
"s_statistics_pool": {
"remoteaddr": {
"formatter": "ipv4"
}
},
"s_statistics_referer": {
"referer": {
"formatter": "clear"
}
},
"s_plugin_widgets_notes": {
"notes": {
"formatter": "clear"
}
},
"s_user": {
"confirmationkey": {
"formatter": "clear"
},
"email": {
"formatter": "freeEmail"
},
"firstname": {
"formatter": "firstName"
},
"lastname": {
"formatter": "lastName"
},
"password": {
"formatter": "md5"
},
"sessionID": {
"formatter": "clear"
}
},
"s_user_addresses": {
"company": {
"formatter": "company"
},
"department": {
"formatter": "clear"
},
"firstname": {
"formatter": "firstName"
},
"lastname": {
"formatter": "lastName"
},
"street": {
"formatter": "streetAddress"
},
"zip": {
"formatter": "postcode"
},
"city": {
"formatter": "city"
},
"phone": {
"formatter": "e164PhoneNumber"
},
"additional_address_line1": {
"formatter": "clear"
},
"additional_address_line2": {
"formatter": "clear"
},
"ustid": {
"formatter": "vat"
}
},
"s_user_addresses_attributes": {
"text1": {
"formatter": "clear"
},
"text2": {
"formatter": "clear"
},
"text3": {
"formatter": "clear"
},
"text4": {
"formatter": "clear"
},
"text5": {
"formatter": "clear"
},
"text6": {
"formatter": "clear"
}
},
"s_user_billingaddress": {
"company": {
"formatter": "company"
},
"department": {
"formatter": "clear"
},
"firstname": {
"formatter": "firstName"
},
"lastname": {
"formatter": "lastName"
},
"street": {
"formatter": "streetAddress"
},
"zip": {
"formatter": "postcode"
},
"city": {
"formatter": "city"
},
"phone": {
"formatter": "e164PhoneNumber"
},
"additional_address_line1": {
"formatter": "clear"
},
"additional_address_line2": {
"formatter": "clear"
},
"ustid": {
"formatter": "vat"
}
},
"s_user_billingaddress_attributes": {
"text1": {
"formatter": "clear"
},
"text2": {
"formatter": "clear"
},
"text3": {
"formatter": "clear"
},
"text4": {
"formatter": "clear"
},
"text5": {
"formatter": "clear"
},
"text6": {
"formatter": "clear"
}
},
"s_user_shippingaddress": {
"company": {
"formatter": "company"
},
"department": {
"formatter": "clear"
},
"firstname": {
"formatter": "firstName"
},
"lastname": {
"formatter": "lastName"
},
"street": {
"formatter": "streetAddress"
},
"zip": {
"formatter": "postcode"
},
"city": {
"formatter": "city"
},
"phone": {
"formatter": "e164PhoneNumber"
},
"additional_address_line1": {
"formatter": "clear"
},
"additional_address_line2": {
"formatter": "clear"
},
"ustid": {
"formatter": "vat"
}
},
"s_user_shippingaddress_attributes": {
"text1": {
"formatter": "clear"
},
"text2": {
"formatter": "clear"
},
"text3": {
"formatter": "clear"
},
"text4": {
"formatter": "clear"
},
"text5": {
"formatter": "clear"
},
"text6": {
"formatter": "clear"
}
},
"s_order": {
"transactionID": {
"formatter": "clear"
},
"customercomment": {
"formatter": "shuffle"
},
"internalcomment": {
"formatter": "shuffle"
},
"trackingcode": {
"formatter": "clear"
},
"remote_addr": {
"formatter": "ipv4"
}
},
"s_order_billingaddress": {
"company": {
"formatter": "company"
},
"department": {
"formatter": "clear"
},
"firstname": {
"formatter": "firstName"
},
"lastname": {
"formatter": "lastName"
},
"street": {
"formatter": "streetAddress"
},
"zip": {
"formatter": "postcode"
},
"city": {
"formatter": "city"
},
"phone": {
"formatter": "e164PhoneNumber"
},
"additional_address_line1": {
"formatter": "clear"
},
"additional_address_line2": {
"formatter": "clear"
},
"ustid": {
"formatter": "vat"
}
},
"s_order_billingaddress_attributes": {
"text1": {
"formatter": "clear"
},
"text2": {
"formatter": "clear"
},
"text3": {
"formatter": "clear"
},
"text4": {
"formatter": "clear"
},
"text5": {
"formatter": "clear"
},
"text6": {
"formatter": "clear"
}
},
"s_order_shippingaddress": {
"company": {
"formatter": "company"
},
"department": {
"formatter": "clear"
},
"firstname": {
"formatter": "firstName"
},
"lastname": {
"formatter": "lastName"
},
"street": {
"formatter": "streetAddress"
},
"zip": {
"formatter": "postcode"
},
"city": {
"formatter": "city"
},
"phone": {
"formatter": "e164PhoneNumber"
},
"additional_address_line1": {
"formatter": "clear"
},
"additional_address_line2": {
"formatter": "clear"
},
"title": {
"formatter": "clear"
}
},
"s_order_shippingaddress_attributes": {
"text1": {
"formatter": "clear"
},
"text2": {
"formatter": "clear"
},
"text3": {
"formatter": "clear"
},
"text4": {
"formatter": "clear"
},
"text5": {
"formatter": "clear"
},
"text6": {
"formatter": "clear"
}
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment