API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Aug 28th, 2015
437
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Python 15.74 KB | None | 0 0
raw download clone embed print report
  1. #@batch, q:\create_cust_entities_115___3_7.txt
  2. # Use ==> Q:\test_quippet_batch.txt  when you need to debug
  3. # Version 2: 2015-07-18. Adds qp_user_password and qp_user_display_name
  4.  
  5. #INSERT INTO user_accessible_apps  (uaapp_user_entity_id, uaapp_app_id) VALUES ( 20, 1), ( 14, 2), ( 16,1), (15, 2), (15, 1);
  6.  
  7.  
  8. {'quippet_name' : 'create__entities', 'clientid' : '115', 'qp_addr_address_1' : '10 MyStreet', 'qp_addr_address_type' : 'Home', 'qp_addr_city' : 'Boston', 'qp_addr_postal_code' : '12004', 'qp_addr_region_id' : '4648', 'qp_cnum_contact_number_type' : 'Mobile, Work, Fax', 'qp_cnum_number' : '407-777-0010, 407-777-0011, 407-777-0012', 'qp_cust_info' : '10 is not to be believed.', 'qp_cust_loyalty_acct_code' : 'LoyAcct-10', 'qp_cust_warning' : 'Don\'t Trust Anyone!!! (3,7)', 'qp_eml_email' : 'Home10@foofoo.com, Work11@foofoo.com, Sales12@foofoo.com', 'qp_eml_email_type' : 'Home, Work, Sales', 'qp_epn_key_names' : 'KeyName-10', 'qp_epn_names_before_key_names' : 'B4KeyName-10', 'qp_erole_role_id' : '3,7', 'qp_user_password' : 'xx_1234m', 'qp_user_display_name' : 'udn_01'}
  9.  
  10. {'quippet_name' : 'create__entities', 'clientid' : '115', 'qp_addr_address_1' : '15 MyStreet', 'qp_addr_address_type' : 'Home', 'qp_addr_city' : 'Detroit', 'qp_addr_postal_code' : '12004', 'qp_addr_region_id' : '4649', 'qp_cnum_contact_number_type' : 'Mobile, Work, Fax', 'qp_cnum_number' : '407-777-0015, 407-777-0016, 407-777-0017', 'qp_cust_info' : '15 is not to be believed.', 'qp_cust_loyalty_acct_code' : 'LoyAcct-15', 'qp_cust_warning' : 'Don\'t Trust Anyone!!! (3,7)', 'qp_eml_email' : 'Home15@foofoo.com, Work16@foofoo.com, Sales17@foofoo.com', 'qp_eml_email_type' : 'Home, Work, Sales', 'qp_epn_key_names' : 'KeyName-15', 'qp_epn_names_before_key_names' : 'B4KeyName-15', 'qp_erole_role_id' : '3,7', 'qp_user_password' : 'xx_1234l', 'qp_user_display_name' : 'udn_02'}
  11.  
  12. {'quippet_name' : 'create__entities', 'clientid' : '115', 'qp_addr_address_1' : '20 MyStreet', 'qp_addr_address_type' : 'Home', 'qp_addr_city' : 'Helena', 'qp_addr_postal_code' : '12004', 'qp_addr_region_id' : '4653', 'qp_cnum_contact_number_type' : 'Mobile, Work, Fax', 'qp_cnum_number' : '407-777-0020, 407-777-0021, 407-777-0022', 'qp_cust_info' : '20 is not to be believed.', 'qp_cust_loyalty_acct_code' : 'LoyAcct-20', 'qp_cust_warning' : 'Don\'t Trust Anyone!!! (3,7)', 'qp_eml_email' : 'Home20@foofoo.com, Work21@foofoo.com, Sales22@foofoo.com', 'qp_eml_email_type' : 'Home, Work, Sales', 'qp_epn_key_names' : 'KeyName-20', 'qp_epn_names_before_key_names' : 'B4KeyName-20', 'qp_erole_role_id' : '3,7', 'qp_user_password' : 'xx_1234k', 'qp_user_display_name' : 'udn_03'}
  13.  
  14. {'quippet_name' : 'create__entities', 'clientid' : '115', 'qp_addr_address_1' : '25 MyStreet', 'qp_addr_address_type' : 'Home', 'qp_addr_city' : 'Trenton', 'qp_addr_postal_code' : '12004', 'qp_addr_region_id' : '4657', 'qp_cnum_contact_number_type' : 'Mobile, Work, Fax', 'qp_cnum_number' : '407-777-0025, 407-777-0026, 407-777-0027', 'qp_cust_info' : '25 is not to be believed.', 'qp_cust_loyalty_acct_code' : 'LoyAcct-25', 'qp_cust_warning' : 'Don\'t Trust Anyone!!! (3,7)', 'qp_eml_email' : 'Home25@foofoo.com, Work26@foofoo.com, Sales27@foofoo.com', 'qp_eml_email_type' : 'Home, Work, Sales', 'qp_epn_key_names' : 'KeyName-25', 'qp_epn_names_before_key_names' : 'B4KeyName-25', 'qp_erole_role_id' : '3,7', 'qp_user_password' : 'xx_1234j', 'qp_user_display_name' : 'udn_04'}
  15.  
  16. {'quippet_name' : 'create__entities', 'clientid' : '115', 'qp_addr_address_1' : '30 MyStreet', 'qp_addr_address_type' : 'Home', 'qp_addr_city' : 'Cleveland', 'qp_addr_postal_code' : '12004', 'qp_addr_region_id' : '4663', 'qp_cnum_contact_number_type' : 'Mobile, Work, Fax', 'qp_cnum_number' : '407-777-0030, 407-777-0031, 407-777-0032', 'qp_cust_info' : '30 is not to be believed.', 'qp_cust_loyalty_acct_code' : 'LoyAcct-30', 'qp_cust_warning' : 'Don\'t Trust Anyone!!! (3,7)', 'qp_eml_email' : 'Home30@foofoo.com, Work31@foofoo.com, Sales32@foofoo.com', 'qp_eml_email_type' : 'Home, Work, Sales', 'qp_epn_key_names' : 'KeyName-30', 'qp_epn_names_before_key_names' : 'B4KeyName-30', 'qp_erole_role_id' : '3,7', 'qp_user_password' : 'xx_1234i', 'qp_user_display_name' : 'udn_05'}
  17.  
  18. {'quippet_name' : 'create__entities', 'clientid' : '115', 'qp_addr_address_1' : '35 MyStreet', 'qp_addr_address_type' : 'Home', 'qp_addr_city' : 'Albany', 'qp_addr_postal_code' : '12004', 'qp_addr_region_id' : '4659', 'qp_cnum_contact_number_type' : 'Mobile, Work, Fax', 'qp_cnum_number' : '407-777-0035, 407-777-0036, 407-777-0037', 'qp_cust_info' : '35 is not to be believed.', 'qp_cust_loyalty_acct_code' : 'LoyAcct-35', 'qp_cust_warning' : 'Don\'t Trust Anyone!!! (3,7)', 'qp_eml_email' : 'Home35@foofoo.com, Work36@foofoo.com, Sales37@foofoo.com', 'qp_eml_email_type' : 'Home, Work, Sales', 'qp_epn_key_names' : 'KeyName-35', 'qp_epn_names_before_key_names' : 'B4KeyName-35', 'qp_erole_role_id' : '3,7', 'qp_user_password' : 'xx_1234h', 'qp_user_display_name' : 'udn_06'}
  19.  
  20. {'quippet_name' : 'create__entities', 'clientid' : '115', 'qp_addr_address_1' : '40 MyStreet', 'qp_addr_address_type' : 'Home', 'qp_addr_city' : 'Albany', 'qp_addr_postal_code' : '12004', 'qp_addr_region_id' : '4659', 'qp_cnum_contact_number_type' : 'Mobile, Work, Fax', 'qp_cnum_number' : '407-777-0040, 407-777-0041, 407-777-0042', 'qp_cust_info' : '40 is not to be believed.', 'qp_cust_loyalty_acct_code' : 'LoyAcct-40', 'qp_cust_warning' : 'Don\'t Trust Anyone!!! (3,7)', 'qp_eml_email' : 'Home40@foofoo.com, Work41@foofoo.com, Sales42@foofoo.com', 'qp_eml_email_type' : 'Home, Work, Sales', 'qp_epn_key_names' : 'KeyName-40', 'qp_epn_names_before_key_names' : 'B4KeyName-40', 'qp_erole_role_id' : '3,7', 'qp_user_password' : 'xx_1234g', 'qp_user_display_name' : 'udn_07'}
  21.  
  22. {'quippet_name' : 'create__entities', 'clientid' : '115', 'qp_addr_address_1' : '45 MyStreet', 'qp_addr_address_type' : 'Home', 'qp_addr_city' : 'Albany', 'qp_addr_postal_code' : '12004', 'qp_addr_region_id' : '4659', 'qp_cnum_contact_number_type' : 'Mobile, Work, Fax', 'qp_cnum_number' : '407-777-0045, 407-777-0046, 407-777-0047', 'qp_cust_info' : '45 is not to be believed.', 'qp_cust_loyalty_acct_code' : 'LoyAcct-45', 'qp_cust_warning' : 'Don\'t Trust Anyone!!! (3,7)', 'qp_eml_email' : 'Home45@foofoo.com, Work46@foofoo.com, Sales47@foofoo.com', 'qp_eml_email_type' : 'Home, Work, Sales', 'qp_epn_key_names' : 'KeyName-45', 'qp_epn_names_before_key_names' : 'B4KeyName-45', 'qp_erole_role_id' : '3,7', 'qp_user_password' : 'xx_1234f', 'qp_user_display_name' : 'udn_08'}
  23.  
  24. {'quippet_name' : 'create__entities', 'clientid' : '115', 'qp_addr_address_1' : '50 MyStreet', 'qp_addr_address_type' : 'Home', 'qp_addr_city' : 'Albany', 'qp_addr_postal_code' : '12004', 'qp_addr_region_id' : '4659', 'qp_cnum_contact_number_type' : 'Mobile, Work, Fax', 'qp_cnum_number' : '407-777-0050, 407-777-0051, 407-777-0052', 'qp_cust_info' : '50 is not to be believed.', 'qp_cust_loyalty_acct_code' : 'LoyAcct-50', 'qp_cust_warning' : 'Don\'t Trust Anyone!!! (3,7)', 'qp_eml_email' : 'Home50@foofoo.com, Work51@foofoo.com, Sales52@foofoo.com', 'qp_eml_email_type' : 'Home, Work, Sales', 'qp_epn_key_names' : 'KeyName-50', 'qp_epn_names_before_key_names' : 'B4KeyName-50', 'qp_erole_role_id' : '3,7', 'qp_user_password' : 'xx_1234e', 'qp_user_display_name' : 'udn_09'}
  25.  
  26. {'quippet_name' : 'create__entities', 'clientid' : '115', 'qp_addr_address_1' : '60 MyStreet', 'qp_addr_address_type' : 'Home', 'qp_addr_city' : 'Albany', 'qp_addr_postal_code' : '12004', 'qp_addr_region_id' : '4659', 'qp_cnum_contact_number_type' : 'Mobile, Work, Fax', 'qp_cnum_number' : '407-777-0060, 407-777-0061, 407-777-0062', 'qp_cust_info' : '60 is not to be believed.', 'qp_cust_loyalty_acct_code' : 'LoyAcct-60', 'qp_cust_warning' : 'Don\'t Trust Anyone!!! (3,5)', 'qp_eml_email' : 'Home60@foofoo.com, Work61@foofoo.com, Sales62@foofoo.com', 'qp_eml_email_type' : 'Home, Work, Sales', 'qp_ent_is_business' : 'TRUE', 'qp_ent_name' : 'Test Data Supply Co. (3,5) 60', 'qp_ent_notes' : 'Slow Deliveries, Poor Packing (60)', 'qp_epn_key_names' : 'KeyName-60 (3,5)', 'qp_epn_names_before_key_names' : 'B4KeyName-60', 'qp_erole_role_id' : '3,5', 'qp_user_password' : 'xx_1234d', 'qp_user_display_name' : 'udn_10'}
  27.  
  28. {'quippet_name' : 'create__entities', 'clientid' : '115', 'qp_addr_address_1' : '65 MyStreet', 'qp_addr_address_type' : 'Home', 'qp_addr_city' : 'Albany', 'qp_addr_postal_code' : '12004', 'qp_addr_region_id' : '4659', 'qp_cnum_contact_number_type' : 'Mobile, Office, Fax', 'qp_cnum_number' : '407-777-0065, 407-777-0066, 407-777-0067', 'qp_eml_email' : 'Home65@foofoo.com, Work66@foofoo.com, Sales67@foofoo.com', 'qp_eml_email_type' : 'Home, Work, Sales', 'qp_ent_is_business' : 'TRUE', 'qp_ent_is_tax_exempt' : 'TRUE', 'qp_ent_name' : 'Test Data Supply or Mfg Co. (4) 65', 'qp_ent_notes' : 'Slow Deliveries, Poor Packing (65)', 'qp_ent_web_url' : 'WooHoo(115-4).com', 'qp_erole_role_id' : '4', 'qp_user_password' : 'xx_1234c', 'qp_user_display_name' : 'udn_11'}
  29.  
  30. {'quippet_name' : 'create__entities', 'clientid' : '115', 'qp_addr_address_1' : '70 MyStreet', 'qp_addr_address_type' : 'Home', 'qp_addr_city' : 'Albany', 'qp_addr_postal_code' : '12004', 'qp_addr_region_id' : '4659', 'qp_cnum_contact_number_type' : 'Mobile, Work, Fax', 'qp_cnum_number' : '407-777-0070, 407-777-0071, 407-777-0072', 'qp_eml_email' : 'Home70@foofoo.com, Work71@foofoo.com, Sales72@foofoo.com', 'qp_eml_email_type' : 'Home, Work, Sales', 'qp_ent_is_business' : 'TRUE', 'qp_ent_is_tax_exempt' : 'TRUE', 'qp_ent_name' : 'Test Data Supply or Mfg Co. (4,5) 70', 'qp_ent_notes' : 'Slow Deliveries, Poor Packing (70)', 'qp_ent_web_url' : 'WooHoo(115-4,5).com', 'qp_erole_role_id' : '4,5', 'qp_user_password' : 'xx_1234b', 'qp_user_display_name' : 'udn_12'}
  31.  
  32. {'quippet_name' : 'create__entities', 'clientid' : '115', 'qp_addr_address_1' : '80 MyStreet', 'qp_addr_address_2' : 'DBA address 2 80', 'qp_addr_address_type' : 'Home', 'qp_addr_city' : 'Albany', 'qp_addr_postal_code' : '12004', 'qp_addr_region_id' : '4659', 'qp_cnum_contact_number_type' : 'Mobile, Work, Fax', 'qp_cnum_number' : '407-777-0080, 407-777-0081, 407-777-0082', 'qp_cust_info' : '80 is not to be believed.', 'qp_cust_loyalty_acct_code' : 'LoyAcct-80', 'qp_cust_warning' : 'Don\'t Trust Anyone!!! (3)', 'qp_eml_email' : 'Home80@foofoo.com, Work81@foofoo.com, Sales82@foofoo.com', 'qp_eml_email_type' : 'Home, Work, Sales', 'qp_ent_is_business' : 'FALSE', 'qp_ent_is_tax_exempt' : 'FALSE', 'qp_epn_key_names' : 'KeyName-80 (3)', 'qp_epn_names_before_key_names' : 'B4KeyName-80', 'qp_erole_role_id' : '3', 'qp_user_password' : 'xx_1234a', 'qp_user_display_name' : 'udn_13'}
  33.  
  34. {'quippet_name' : 'create__entities', 'clientid' : '115', 'qp_addr_address_1' : '85 MyStreet', 'qp_addr_address_2' : 'DBA address 2 85', 'qp_addr_address_type' : 'Home', 'qp_addr_city' : 'Albany', 'qp_addr_country_id' : 231, 'qp_addr_postal_code' : '12004', 'qp_addr_region_id' : '4659', 'qp_cnum_contact_number_type' : 'Mobile, Office, Fax', 'qp_cnum_number' : '407-777-0085, 407-777-0086, 407-777-0087', 'qp_eml_email' : 'Home85@foofoo.com, Work86@foofoo.com, Sales87@foofoo.com', 'qp_eml_email_type' : 'Home, Work, Sales', 'qp_ent_is_business' : 'TRUE', 'qp_ent_is_tax_exempt' : 'TRUE', 'qp_ent_name' : 'Test Data Supply or Mfg or Loc. (rl-2, id-85)', 'qp_ent_notes' : 'Slow Deliveries, Poor Packing (85)', 'qp_ent_web_url' : 'WooHoo(115-2).com', 'qp_erole_role_id' : '2', 'qp_loc_is_enabled' : 'True', 'qp_loc_receipt_name' : '85 MyStreet receipt', 'qp_loc_report_code' : '85 RepCod', 'qp_loc_default_tax_id' : '1'}
  35.  
  36. #Create some locations
  37. {'quippet_name' : 'create__entities', 'clientid' : '115', 'qp_addr_address_1' : '90 MyStreet', 'qp_addr_address_2' : 'DBA address 2 90', 'qp_addr_address_type' : 'Home', 'qp_addr_city' : 'Albany', 'qp_addr_country_id' : 231, 'qp_addr_postal_code' : '12004', 'qp_addr_region_id' : '4659', 'qp_cnum_contact_number_type' : 'Mobile, Office, Fax', 'qp_cnum_number' : '407-777-0090, 407-777-0091, 407-777-0092', 'qp_eml_email' : 'Home90@foofoo.com, Work91@foofoo.com, Sales92@foofoo.com', 'qp_eml_email_type' : 'Home, Work, Sales', 'qp_ent_is_business' : 'TRUE', 'qp_ent_is_tax_exempt' : 'TRUE', 'qp_ent_name' : 'Test Data Supply or Mfg or Loc. (rl-2, id-90)', 'qp_ent_notes' : 'Slow Deliveries, Poor Packing (90)', 'qp_ent_web_url' : 'WooHoo(115-2).com', 'qp_erole_role_id' : '2', 'qp_loc_is_enabled' : 'True', 'qp_loc_receipt_name' : '90 MyStreet receipt', 'qp_loc_report_code' : '90 RepCod', 'qp_loc_default_tax_id' : '1'}
  38.  
  39. {'quippet_name' : 'create__entities', 'clientid' : '115', 'qp_addr_address_1' : '95 MyStreet', 'qp_addr_address_2' : 'DBA address 2 95', 'qp_addr_address_type' : 'Home', 'qp_addr_city' : 'Albany', 'qp_addr_country_id' : 231, 'qp_addr_postal_code' : '12004', 'qp_addr_region_id' : '4659', 'qp_cnum_contact_number_type' : 'Mobile, Office, Fax', 'qp_cnum_number' : '407-777-0095, 407-777-0096, 407-777-0097', 'qp_eml_email' : 'Home95@foofoo.com, Work96@foofoo.com, Sales97@foofoo.com', 'qp_eml_email_type' : 'Home, Work, Sales', 'qp_ent_is_business' : 'TRUE', 'qp_ent_is_tax_exempt' : 'TRUE', 'qp_ent_name' : 'Test Data Supply or Mfg or Loc. (rl-2, id-95)', 'qp_ent_notes' : 'Slow Deliveries, Poor Packing (95)', 'qp_ent_web_url' : 'WooHoo(115-2).com', 'qp_erole_role_id' : '2', 'qp_loc_is_enabled' : 'True', 'qp_loc_receipt_name' : '95 MyStreet receipt', 'qp_loc_report_code' : '95 RepCod', 'qp_loc_default_tax_id' : '1'}
  40.  
  41. {'quippet_name' : 'create__entities', 'clientid' : '115', 'qp_addr_address_1' : '100 MyStreet', 'qp_addr_address_2' : 'DBA address 2 100', 'qp_addr_address_type' : 'Home', 'qp_addr_city' : 'Albany', 'qp_addr_country_id' : 231, 'qp_addr_postal_code' : '12004', 'qp_addr_region_id' : '4659', 'qp_cnum_contact_number_type' : 'Mobile, Office, Fax', 'qp_cnum_number' : '407-777-0100, 407-777-0101, 407-777-0102', 'qp_eml_email' : 'Home100@foofoo.com, Work101@foofoo.com, Sales102@foofoo.com', 'qp_eml_email_type' : 'Home, Work, Sales', 'qp_ent_is_business' : 'TRUE', 'qp_ent_is_tax_exempt' : 'TRUE', 'qp_ent_name' : 'Test Data Supply or Mfg or Loc. (rl-2, id-100)', 'qp_ent_notes' : 'Slow Deliveries, Poor Packing (100)', 'qp_ent_web_url' : 'WooHoo(115-2).com', 'qp_erole_role_id' : '2', 'qp_loc_is_enabled' : 'True', 'qp_loc_receipt_name' : '100 MyStreet receipt', 'qp_loc_report_code' : '100 RepCod', 'qp_loc_default_tax_id' : '1'}
  42.  
  43.  
  44. {'quippet_name' : 'create__entities', 'clientid' : '115', 'qp_addr_address_1' : '105 MyStreet', 'qp_addr_address_2' : 'DBA address 2 105', 'qp_addr_address_type' : 'Home', 'qp_addr_city' : 'Albany', 'qp_addr_country_id' : 231, 'qp_addr_postal_code' : '12004', 'qp_addr_region_id' : '4659', 'qp_cnum_contact_number_type' : 'Mobile, Work, Fax', 'qp_cnum_number' : '407-777-0105, 407-777-0106, 407-777-0107', 'qp_cust_info' : '105 is not to be believed.', 'qp_cust_loyalty_acct_code' : 'LoyAcct-105', 'qp_cust_warning' : 'Don\'t Trust Anyone!!! (3)', 'qp_eml_email' : 'Home105@foofoo.com, Work106@foofoo.com, Sales107@foofoo.com', 'qp_eml_email_type' : 'Home, Work, Sales', 'qp_ent_is_business' : 'FALSE', 'qp_ent_is_tax_exempt' : 'TRUE', 'qp_epn_key_names' : 'KeyName-105 (3)', 'qp_epn_names_before_key_names' : 'B4KeyName-105', 'qp_erole_role_id' : '3'}
  45.  
  46. {'quippet_name' : 'create__entities', 'clientid' : '115', 'qp_addr_address_1' : '110 MyStreet', 'qp_addr_address_2' : 'DBA address 2 110', 'qp_addr_address_type' : 'Home', 'qp_addr_city' : 'Albany', 'qp_addr_country_id' : 231, 'qp_addr_postal_code' : '12004', 'qp_addr_region_id' : '4659', 'qp_cnum_contact_number_type' : 'Mobile, Work, Fax', 'qp_cnum_number' : '407-777-0110, 407-777-0111, 407-777-0112', 'qp_cust_info' : '110 is not to be believed.', 'qp_cust_loyalty_acct_code' : 'LoyAcct-110', 'qp_cust_warning' : 'Don\'t Trust Anyone!!! (3)', 'qp_eml_email' : 'Home110@foofoo.com, Work111@foofoo.com, Sales112@foofoo.com', 'qp_eml_email_type' : 'Home, Work, Sales', 'qp_ent_is_business' : 'FALSE', 'qp_ent_is_tax_exempt' : 'TRUE', 'qp_epn_key_names' : 'KeyName-110 (3)', 'qp_epn_names_before_key_names' : 'B4KeyName-110', 'qp_erole_role_id' : '3'}
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!