API tools faq
paste
Advertisement
cristobalsv

Insert Risk PostgreSQL

cristobalsv
May 28th, 2024 (edited)
164
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PostgreSQL 11.06 KB | None | 0 0
raw download clone embed print report
  1. INSERT INTO "RiskScore" ("id", "shopName", "orderId", "score", "recommendedAction", "categoryOfRisk", "riskLabel", "estimatedSaving", "datetime")
  2. VALUES
  3. INSERT INTO "RiskScore" ("id", "shopName", "orderId", "score", "recommendedAction", "categoryOfRisk", "riskLabel", "orderInfo", "estimatedSaving", "datetime")
  4. VALUES
  5. ('58', 'deliverlitics-store.myshopify.com', 'gid://shopify/Order/5594729709763', '0.125', 'N/A', 'No Risk', 'Low', '0.0', to_timestamp(1715036669780 / 1000)),
  6. ('57', 'deliverlitics-store.myshopify.com', 'gid://shopify/Order/5594727121091', '0.728', 'Signature Verification', 'Historical Risk', 'High', '700.0', to_timestamp(1715036464387 / 1000)),
  7. ('59', 'deliverlitics-store.myshopify.com', 'gid://shopify/Order/5594729971907', '0.079', 'N/A', 'No Risk', 'Low', '0.0', to_timestamp(1715036691711 / 1000)),
  8. ('60', 'deliverlitics-store.myshopify.com', 'gid://shopify/Order/5594730430659', '0.129', 'N/A', 'No Risk', 'Low', '0.0', to_timestamp(1715036730158 / 1000)),
  9. ('61', 'deliverlitics-store.myshopify.com', 'gid://shopify/Order/5594730692803', '0.297', 'N/A', 'No Risk', 'Low', '0.0', to_timestamp(1715036751890 / 1000)),
  10. ('62', 'deliverlitics-store.myshopify.com', 'gid://shopify/Order/5594731020483', '0.533', 'N/A', 'Historical Risk', 'Medium', '0.0', to_timestamp(1715036778917 / 1000)),
  11. ('63', 'deliverlitics-store.myshopify.com', 'gid://shopify/Order/5594731774147', '0.633', 'Signature Verification', 'Historical Risk', 'High', '600.0', to_timestamp(1715036814113 / 1000)),
  12. ('64', 'deliverlitics-store.myshopify.com', 'gid://shopify/Order/5594732331203', '0.973', 'Signature Verification', 'Historical Risk', 'High', '500.0', to_timestamp(1715036846694 / 1000)),
  13. ('65', 'deliverlitics-store.myshopify.com', 'gid://shopify/Order/5594732658883', '0.258', 'N/A', 'No Risk', 'Low', '0.0', to_timestamp(1715036875838 / 1000)),
  14. ('66', 'deliverlitics-store.myshopify.com', 'gid://shopify/Order/5594733412547', '0.512', 'N/A', 'Historical Risk', 'Medium', '0.0', to_timestamp(1715036938706 / 1000)),
  15. ('67', 'deliverlitics-store.myshopify.com', 'gid://shopify/Order/5594733772995', '0.341', 'N/A', 'Historical Risk', 'Medium', '0.0', to_timestamp(1715036965537 / 1000)),
  16. (10340, 'deliverlitics-store.myshopify.com', 'gid://shopify/Order/5611488116931', 0.152, 'N/A', 'No Risk', 'Low', '{"id":"gid://shopify/Order/5611488116931","shippingAddress":{"address1":"754 Tyre Lane","city":"Grand Ridge","zip":"32442","province":"Florida","country":"United States","address2":null,"latitude":30.6176683,"longitude":-85.0211625,"country_code":"US","province_code":"FL"},"originalTotalPriceSet":{"shopMoney":{"amount":"100.00","currency_code":"USD"}}}', 0, to_timestamp(1715036965537 / 1000)),
  17. (10282, 'deliverlitics-store.myshopify.com', 'gid://shopify/Order/5825682833729', 0.017, 'N/A', 'No Risk', 'Low', '{"id":"gid://shopify/Order/5825682833729","shippingAddress":{"address1":"San Carlos Hotel","address2":null,"city":"New York","country":"United States","zip":"10022","latitude":40.7560154,"longitude":-73.971445,"countryCodeV2":"US","province":"New York","provinceCode":"NY"},"originalTotalPriceSet":{"shopMoney":{"amount":"200.0"}}}', 0, to_timestamp(1715036965537 / 1000)),
  18. (10275, 'deliverlitics-store.myshopify.com', 'gid://shopify/Order/5825679163713', 0.212, 'N/A', 'No Risk', 'Low', '{"id":"gid://shopify/Order/5825679163713","shippingAddress":{"address1":"2429 Solomon Lane","address2":null,"city":"Nashville","country":"United States","zip":"37207","latitude":null,"longitude":null,"countryCodeV2":"US","province":"Tennessee","provinceCode":"TN"},"originalTotalPriceSet":{"shopMoney":{"amount":"124.95"}}}', 0, to_timestamp(1715036965537 / 1000)),
  19. (10302, 'deliverlitics-store.myshopify.com', 'gid://shopify/Order/5825810432321', 0.326, 'N/A', 'Historical Risk', 'Medium', '{"id":"gid://shopify/Order/5825810432321","shippingAddress":{"address1":"4560 South Hydraulic Avenue","address2":null,"city":"Wichita","country":"United States","zip":"67216","latitude":37.613439,"longitude":-97.315321,"countryCodeV2":"US","province":"Kansas","provinceCode":"KS"},"originalTotalPriceSet":{"shopMoney":{"amount":"450.0"}}}', 0, to_timestamp(1715036965537 / 1000)),
  20. (10342, 'deliverlitics-store.myshopify.com', 'gid://shopify/Order/5611526717635', 0.066, 'N/A', 'No Risk', 'Low', '{"id":"gid://shopify/Order/5611526717635","shippingAddress":{"address1":"754 Tyre Lane","city":"Grand Ridge","zip":"32442","province":"Florida","country":"United States","address2":null,"latitude":30.6176683,"longitude":-85.0211625,"country_code":"US","province_code":"FL"},"originalTotalPriceSet":{"shopMoney":{"amount":"100.00","currency_code":"USD"}}}', 0, to_timestamp(1715036965537 / 1000)),
  21. (10301, 'deliverlitics-store.myshopify.com', 'gid://shopify/Order/5825809416513', 0.145, 'N/A', 'No Risk', 'Low', '{"id":"gid://shopify/Order/5825809416513","shippingAddress":{"address1":"105 Victoria St","address2":null,"city":"Toronto","country":"Canada","zip":"M5C 1N7","latitude":43.6521328,"longitude":-79.3777157,"countryCodeV2":"CA","province":"Ontario","provinceCode":"ON"},"originalTotalPriceSet":{"shopMoney":{"amount":"350.0"}}}', 0, to_timestamp(1715036965537 / 1000)),
  22. (10297, 'deliverlitics-store.myshopify.com', 'gid://shopify/Order/5825808892225', 0.115, 'N/A', 'No Risk', 'Low', '{"id":"gid://shopify/Order/5825808892225","shippingAddress":{"address1":"10068 Carinata Drive","address2":null,"city":"Elk Grove","country":"United States","zip":"95757","latitude":38.3920426,"longitude":-121.4040748,"countryCodeV2":"US","province":"California","provinceCode":"CA"},"originalTotalPriceSet":{"shopMoney":{"amount":"350.0"}}}', 0, to_timestamp(1715036965537 / 1000)),
  23. (10281, 'deliverlitics-store.myshopify.com', 'gid://shopify/Order/5825682309441', 0.598, 'N/A', 'Historical Risk', 'Medium', '{"id":"gid://shopify/Order/5825682309441","shippingAddress":{"address1":"151 O Connor St","address2":null,"city":"Ottawa","country":"Canada","zip":"K2P 2L8","latitude":45.4191176,"longitude":-75.6966166,"countryCodeV2":"CA","province":"Ontario","provinceCode":"ON"},"originalTotalPriceSet":{"shopMoney":{"amount":"400.0"}}}', 0, to_timestamp(1715036965537 / 1000)),
  24. (10279, 'deliverlitics-store.myshopify.com', 'gid://shopify/Order/5825680802113', 0.058, 'N/A', 'No Risk', 'Low', '{"id":"gid://shopify/Order/5825680802113","shippingAddress":{"address1":"123 West Main Street","address2":null,"city":"Independence","country":"United States","zip":"67301","latitude":37.2229568,"longitude":-95.7078961,"countryCodeV2":"US","province":"Kansas","provinceCode":"KS"},"originalTotalPriceSet":{"shopMoney":{"amount":"84.85"}}}', 0, to_timestamp(1715036965537 / 1000)),
  25. (10272, 'deliverlitics-store.myshopify.com', 'gid://shopify/Order/5825678311745', 0.212, 'N/A', 'No Risk', 'Low', '{"id":"gid://shopify/Order/5825678311745","shippingAddress":{"address1":"420 San Pedro Street","address2":null,"city":"Los Angeles","country":"United States","zip":"90013","latitude":34.04501279999999,"longitude":-118.243162,"countryCodeV2":"US","province":"California","provinceCode":"CA"},"originalTotalPriceSet":{"shopMoney":{"amount":"59.9"}}}', 0, to_timestamp(1715036965537 / 1000)),
  26. (10299, 'deliverlitics-store.myshopify.com', 'gid://shopify/Order/5825809252673', 0.243, 'N/A', 'No Risk', 'Low', '{"id":"gid://shopify/Order/5825809252673","shippingAddress":{"address1":"420 San Pedro Street","address2":null,"city":"Los Angeles","country":"United States","zip":"90013","latitude":34.04501279999999,"longitude":-118.243162,"countryCodeV2":"US","province":"California","provinceCode":"CA"},"originalTotalPriceSet":{"shopMoney":{"amount":"224.95"}}}', 0, to_timestamp(1715036965537 / 1000)),
  27. (10277, 'deliverlitics-store.myshopify.com', 'gid://shopify/Order/5825680179521', 0.949, 'Signature Verification', 'Historical Risk', 'High', '{"id":"gid://shopify/Order/5825680179521","shippingAddress":{"address1":"23 R Street Northwest","address2":null,"city":"Washington","country":"United States","zip":"20001","latitude":38.912843,"longitude":-77.0099687,"countryCodeV2":"US","province":"District of Columbia","provinceCode":"DC"},"originalTotalPriceSet":{"shopMoney":{"amount":"1109.85"}}}', 1109.85, to_timestamp(1715036965537 / 1000)),
  28. (10274, 'deliverlitics-store.myshopify.com', 'gid://shopify/Order/5825678541121', 0.838, 'Signature Verification', 'Historical Risk', 'High', '{"id":"gid://shopify/Order/5825678541121","shippingAddress":{"address1":"105 Victoria St","address2":null,"city":"Toronto","country":"Canada","zip":"M5C 1N7","latitude":43.6521328,"longitude":-79.3777157,"countryCodeV2":"CA","province":"Ontario","provinceCode":"ON"},"originalTotalPriceSet":{"shopMoney":{"amount":"2629.95"}}}', 2629.95, to_timestamp(1715036965537 / 1000)),
  29. (10280, 'deliverlitics-store.myshopify.com', 'gid://shopify/Order/5825681326401', 0.278, 'N/A', 'No Risk', 'Low', '{"id":"gid://shopify/Order/5825681326401","shippingAddress":{"address1":"42 Main St","address2":null,"city":"Copan","country":"United States","zip":"74022","latitude":36.9157208,"longitude":-95.8024753,"countryCodeV2":"US","province":"Oklahoma","provinceCode":"OK"},"originalTotalPriceSet":{"shopMoney":{"amount":"244.85"}}}', 0, to_timestamp(1715036965537 / 1000)),
  30. (10303, 'deliverlitics-store.myshopify.com', 'gid://shopify/Order/5825811317057', 0.313, 'N/A', 'Historical Risk', 'Medium', '{"id":"gid://shopify/Order/5825811317057","shippingAddress":{"address1":"5789 Graham Road","address2":null,"city":"Whiteland","country":"United States","zip":"46184","latitude":39.5626586,"longitude":-86.0563909,"countryCodeV2":"US","province":"Indiana","provinceCode":"IN"},"originalTotalPriceSet":{"shopMoney":{"amount":"400.0"}}}', 0, to_timestamp(1715036965537 / 1000)),
  31. (10344, 'deliverlitics-store.myshopify.com', 'gid://shopify/Order/5614501200067', 0.056, 'N/A', 'No Risk', 'Low', '{"id":"gid://shopify/Order/5614501200067","shippingAddress":{"address1":"754 Tyre Lane","city":"Grand Ridge","zip":"32442","province":"Florida","country":"United States","address2":null,"latitude":30.6176683,"longitude":-85.0211625,"country_code":"US","province_code":"FL"},"originalTotalPriceSet":{"shopMoney":{"amount":"10.00","currency_code":"USD"}}}', 0, to_timestamp(1715036965537 / 1000)),
  32. (10345, 'deliverlitics-store.myshopify.com', 'gid://shopify/Order/5615495872707', 0.265, 'N/A', 'No Risk', 'Low', '{"id":"gid://shopify/Order/5615495872707","shippingAddress":{"address1":"2454 County Road 4500","city":"Coffeyville","zip":"67337","province":"Kansas","country":"United States","address2":null,"latitude":37.08763,"longitude":-95.65500999999999,"country_code":"US","province_code":"KS"},"originalTotalPriceSet":{"shopMoney":{"amount":"200.00","currency_code":"USD"}}}', 0, to_timestamp(1715036965537 / 1000)),
  33. (10346, 'deliverlitics-store.myshopify.com', 'gid://shopify/Order/5615497412803', 0.952, 'Signature Verification', 'Historical Risk', 'High', '{"id":"gid://shopify/Order/5615497412803","shippingAddress":{"address1":"21407 Virginia Drive","city":"Hollister","zip":"95023","province":"California","country":"United States","address2":null,"latitude":null,"longitude":null,"country_code":"US","province_code":"CA"},"originalTotalPriceSet":{"shopMoney":{"amount":"1359.90","currency_code":"USD"}}}', 1359.9, to_timestamp(1715036965537 / 1000));
  34.  
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!