- ID
- 19511c16-3d35-416b-84e3-83f20b038b9f
2023-09-20
DONE One on one with Bogle
CLOSED:
DONE Force push 74 policies and quotes for Toggle Renters
CLOSED:
#+begin_src tsv
TOR7RTXU1C QTQQH19IU 2020-06-29T14:22:56Z 2020-06-29T00:00:00Z
TOSDZZ0YCO QZSQN4N7V 2020-06-29T14:15:44Z 2020-06-30T00:00:00Z
TOGR7REIUP Q6CMGVQ1I 2020-06-29T16:54:05Z 2020-07-01T00:00:00Z
TORZHTZF3E QOW828HNM 2020-06-29T22:15:26Z 2020-07-02T00:00:00Z
TOXEB60BOZ Q61E2V4S8 2020-06-29T23:04:07Z 2020-07-02T00:00:00Z
TOLSZHKG28 QDV4Y19IX 2023-07-21T21:36:56Z 2023-07-24T00:00:00Z
TOMVEGHXXL QA3I45LLI 2023-07-21T22:33:14Z 2023-07-25T00:00:00Z
TO9RWUGCAH Q6KQBI4PJ 2023-06-30T16:06:20Z 2023-07-27T00:00:00Z
TOUSEALVDJ QCUV33WJ1 2023-07-21T22:04:05Z 2023-07-28T00:00:00Z
TOCL3S8T6A Q9SLZC5K9 2023-07-21T21:38:48Z 2023-07-29T00:00:00Z
TOTFTJVM5T QFJVLZ5NI 2023-07-31T20:56:31Z 2023-07-31T00:00:00Z
TO2YBPNBLY Q6Z4NDZ7Y 2023-07-31T20:57:57Z 2023-07-31T00:00:00Z
TONP99JUVB QCHF4UJG6 2023-07-21T21:42:48Z 2023-07-31T00:00:00Z
TORW443EZA Q6YGANU7A 2023-07-21T22:06:20Z 2023-08-01T00:00:00Z
TOCL9X7T3Y QLL6P5LRK 2023-07-31T20:55:58Z 2023-08-01T00:00:00Z
TOLJ72URVU QQUGXLDMH 2023-07-31T20:20:31Z 2023-08-01T00:00:00Z
TOH3R7K6K7 QHYB9082H 2023-08-04T17:23:50Z 2023-08-04T00:00:00Z
TOT4QTNC3W Q9G4H7DUO 2023-08-04T17:06:19Z 2023-08-04T00:00:00Z
TOEENVE33Q QP577PHZW 2023-08-04T14:49:04Z 2023-08-04T00:00:00Z
TO2AN3G3HH QM7PC3D8E 2023-08-04T17:47:45Z 2023-08-04T00:00:00Z
TOUQ3TQ6YT Q3R4S0H9U 2023-08-04T17:15:49Z 2023-08-04T00:00:00Z
TOHHBR4MZS QPMGGKQD5 2023-08-04T17:37:58Z 2023-08-04T00:00:00Z
TO3C5SNP3K QLJHX1S63 2023-08-04T17:23:10Z 2023-08-04T00:00:00Z
TOP5N4SB3J Q2FX1426R 2023-08-04T16:49:51Z 2023-08-04T00:00:00Z
TO8D696ZYK QT0XYQTIP 2023-08-04T17:35:55Z 2023-08-04T00:00:00Z
TORVXPGFN9 QC26GFW4K 2023-08-04T17:00:48Z 2023-08-04T00:00:00Z
TOSPWDN32B QCDUW4L7I 2023-08-04T13:31:40Z 2023-08-04T00:00:00Z
TO9BNTBP3H QDKOP7895 2023-08-04T17:40:30Z 2023-08-04T00:00:00Z
TOZNL3C24K QMNWLXQFR 2023-08-04T17:42:18Z 2023-08-04T00:00:00Z
TOVD7XY8V7 QIGDU53KZ 2023-08-04T17:39:59Z 2023-08-05T00:00:00Z
TOGZ8AE86Y QRIXOPCM5 2023-08-04T16:05:14Z 2023-08-05T00:00:00Z
TO2DAURXTB QLR6X0FDQ 2023-08-04T17:14:46Z 2023-08-05T00:00:00Z
TO26GWRY62 QP4FASLB9 2023-08-04T17:43:34Z 2023-08-05T00:00:00Z
TOH9BM9ALZ QABJERB1H 2023-08-04T17:40:17Z 2023-08-05T00:00:00Z
TO5L2ERB8A QYQS70UYX 2023-08-04T17:38:06Z 2023-08-05T00:00:00Z
TONZH5RCTC Q0MOTLGDG 2023-08-04T17:30:50Z 2023-08-07T00:00:00Z
TODS3FSB6K QIS2VCI9K 2023-08-04T17:07:23Z 2023-08-07T00:00:00Z
TOBNYUUZ7X Q7ZLG7JT8 2023-07-31T20:18:40Z 2023-08-11T00:00:00Z
TO8Z5TC4R6 QJEQ1OLA9 2023-07-14T14:40:28Z 2023-08-12T00:00:00Z
TO2G4XUBV8 Q4NVEEVA9 2023-07-14T14:33:20Z 2023-08-13T00:00:00Z
TOWN3WM2WV QH7TFKLJY 2023-08-14T04:03:17Z 2023-08-14T00:00:00Z
TOQ5VBAAHB QV5LXUA2S 2023-08-14T02:16:54Z 2023-08-14T00:00:00Z
TO8DV3XHHT QESNJZ8FQ 2023-08-14T03:37:56Z 2023-08-14T00:00:00Z
TOQEDNFXJY QALDFK3W8 2023-08-14T03:42:17Z 2023-08-14T00:00:00Z
TO76QENTLG QXWOF399W 2023-08-14T02:34:27Z 2023-08-14T00:00:00Z
TO3JDNZ6W9 Q9UF0667Q 2023-08-14T02:29:28Z 2023-08-14T00:00:00Z
TOSLNCQB8J Q0Y8Q7XF8 2023-08-14T02:11:20Z 2023-08-14T00:00:00Z
TORBUHL9LC QPOPLYOOF 2023-08-14T01:02:56Z 2023-08-14T00:00:00Z
TOUX9XJVVJ QSJVVGP34 2023-08-14T01:08:42Z 2023-08-14T00:00:00Z
TOVP2SZLEH Q9AL8F31N 2023-08-09T18:06:24Z 2023-08-15T00:00:00Z
TO7WQUGHQF QI1EMGQYV 2023-08-12T20:41:02Z 2023-08-15T00:00:00Z
TO7352MQSJ QN53XKBA6 2023-08-14T02:25:56Z 2023-08-16T00:00:00Z
TOKJXKVBM9 QEI5XDTE2 2023-08-14T01:56:41Z 2023-08-16T00:00:00Z
TOV6HWF5R2 Q535NZ13L 2023-08-18T16:07:41Z 2023-08-18T00:00:00Z
TOG4EYR62S Q4Y4CDII6 2023-08-16T14:59:45Z 2023-08-18T00:00:00Z
TOA4K9CJUX QBZQ8CTXP 2023-08-18T15:45:46Z 2023-08-18T00:00:00Z
TO23NAXZMX Q5F0UWTVK 2023-08-18T15:47:00Z 2023-08-18T00:00:00Z
TOGUBV3UM8 QOW5MJ0WO 2023-08-18T15:51:42Z 2023-08-18T00:00:00Z
TOVTKL4GR9 Q9ID3HJUK 2023-08-18T02:14:29Z 2023-08-18T00:00:00Z
TOTJ76X5SE QV8XEW42U 2023-08-17T23:58:51Z 2023-08-18T00:00:00Z
TOREX73Y4N QF43NKX0B 2023-08-18T16:03:01Z 2023-08-19T00:00:00Z
TODGCWT9SB QM10F45YL 2023-07-21T21:55:18Z 2023-08-19T00:00:00Z
TO8LA34FE7 Q7N08437T 2023-08-14T03:09:59Z 2023-08-19T00:00:00Z
TOJ5ZCBM42 QM40XUCMH 2023-08-18T15:57:38Z 2023-08-19T00:00:00Z
TOGKXTCYKX QDVB40PFU 2023-08-14T03:17:25Z 2023-08-19T00:00:00Z
TO94JPCAMU QHBSZPBCF 2023-08-18T15:49:11Z 2023-08-19T00:00:00Z
TOHMDSXEDM Q90AS9OMJ 2023-08-18T16:04:13Z 2023-08-19T00:00:00Z
TOS24RFJ9X QFUNXC90Z 2023-08-18T16:05:24Z 2023-08-19T00:00:00Z
TOK85TGXWP QKP77WH2R 2023-07-21T21:33:48Z 2023-08-20T00:00:00Z
TOW38VBJAQ QJ8UP2FCG 2023-08-23T17:28:45Z 2023-08-23T00:00:00Z
TO6VYSNW5S Q82B2Z8T5 2023-08-18T16:00:48Z 2023-08-28T00:00:00Z
TOUQKKRMB3 QKAD1NW9W 2023-08-18T16:02:36Z 2023-08-31T00:00:00Z
TOXVCBNSF9 QATLESGAB 2023-08-18T14:04:04Z 2023-08-31T00:00:00Z
TO3DRDG6CM QBDK5FO3V 2023-08-14T03:39:28Z 2023-09-08T00:00:00Z
#+end_src
#+begin_src python
policy_numbers = ["TOR7RTXU1C","TOSDZZ0YCO","TOGR7REIUP"]
policy_numbers = ["TOWNWYHFZA"]
policies_id_list = ["TORZHTZF3E","TOXEB60BOZ","TOLSZHKG28","TOMVEGHXXL","TO9RWUGCAH","TOUSEALVDJ","TOCL3S8T6A","TOTFTJVM5T","TO2YBPNBLY","TONP99JUVB","TORW443EZA","TOCL9X7T3Y","TOLJ72URVU","TOH3R7K6K7","TOT4QTNC3W","TOEENVE33Q","TO2AN3G3HH","TOUQ3TQ6YT","TOHHBR4MZS","TO3C5SNP3K","TOP5N4SB3J","TO8D696ZYK","TORVXPGFN9","TOSPWDN32B","TO9BNTBP3H","TOZNL3C24K","TOVD7XY8V7","TOGZ8AE86Y","TO2DAURXTB","TO26GWRY62","TOH9BM9ALZ","TO5L2ERB8A","TONZH5RCTC","TODS3FSB6K","TOBNYUUZ7X","TO8Z5TC4R6","TO2G4XUBV8","TOWN3WM2WV","TOQ5VBAAHB","TO8DV3XHHT","TOQEDNFXJY","TO76QENTLG","TO3JDNZ6W9","TOSLNCQB8J","TORBUHL9LC","TOUX9XJVVJ","TOVP2SZLEH","TO7WQUGHQF","TO7352MQSJ","TOKJXKVBM9","TOV6HWF5R2","TOG4EYR62S","TOA4K9CJUX","TO23NAXZMX","TOGUBV3UM8","TOVTKL4GR9","TOTJ76X5SE","TOREX73Y4N","TODGCWT9SB","TO8LA34FE7","TOJ5ZCBM42","TOGKXTCYKX","TO94JPCAMU","TOHMDSXEDM","TOS24RFJ9X","TOK85TGXWP","TOW38VBJAQ","TO6VYSNW5S","TOUQKKRMB3","TOXVCBNSF9","TO3DRDG6CM"]
from django.conf import settings
from surepreme.apps.jobs.extraction.toggle.renters.policy_data import *
from surepreme.thirdparty.snowflake.loader import SnowflakeLoader
policy_numbers = ('TOBE8BJ8NH','TOQXE7296L','TOMX9JAMJX','TO3NDY6PKH','TOSB4K3STD','TO5DSX4EDK','TOV8DCYW95','TOYXHJ8DYE','TONT6EMAEU')
policies = Policy.objects.filter(policy_number__in=policy_numbers)
snowflake_loader = SnowflakeLoader(
sf_account=settings.SECRET_SETTINGS.farmers.snowflake.account,
sf_user=settings.SECRET_SETTINGS.farmers.snowflake.user,
sf_password=settings.SECRET_SETTINGS.farmers.snowflake.password,
warehouse=settings.SECRET_SETTINGS.farmers.snowflake.warehouse,
database=settings.SECRET_SETTINGS.farmers.snowflake.database,
schema="DAILY_DUMPS",
)
policies_data = [policy_to_toggle_json(p) for p in policies]
snowflake_loader.upload_json("all_policies", "all_policies", policies_data)
#+end_src
#+begin_src python
from django.conf import settings
from surepreme.apps.jobs.extraction.toggle.renters.policy_data import *
from surepreme.thirdparty.snowflake.loader import SnowflakeLoader
quote_numbers = ["QTQQH19IU","QZSQN4N7V","Q6CMGVQ1I","QOW828HNM","Q61E2V4S8","QDV4Y19IX","QA3I45LLI","Q6KQBI4PJ","QCUV33WJ1","Q9SLZC5K9","QFJVLZ5NI","Q6Z4NDZ7Y","QCHF4UJG6","Q6YGANU7A","QLL6P5LRK","QQUGXLDMH","QHYB9082H","Q9G4H7DUO","QP577PHZW","QM7PC3D8E","Q3R4S0H9U","QPMGGKQD5","QLJHX1S63","Q2FX1426R","QT0XYQTIP","QC26GFW4K","QCDUW4L7I","QDKOP7895","QMNWLXQFR","QIGDU53KZ","QRIXOPCM5","QLR6X0FDQ","QP4FASLB9","QABJERB1H","QYQS70UYX","Q0MOTLGDG","QIS2VCI9K","Q7ZLG7JT8","QJEQ1OLA9","Q4NVEEVA9","QH7TFKLJY","QV5LXUA2S","QESNJZ8FQ","QALDFK3W8","QXWOF399W","Q9UF0667Q","Q0Y8Q7XF8","QPOPLYOOF","QSJVVGP34","Q9AL8F31N","QI1EMGQYV","QN53XKBA6","QEI5XDTE2","Q535NZ13L","Q4Y4CDII6","QBZQ8CTXP","Q5F0UWTVK","QOW5MJ0WO","Q9ID3HJUK","QV8XEW42U","QF43NKX0B","QM10F45YL","Q7N08437T","QM40XUCMH","QDVB40PFU","QHBSZPBCF","Q90AS9OMJ","QFUNXC90Z","QKP77WH2R","QJ8UP2FCG","Q82B2Z8T5","QKAD1NW9W","QATLESGAB","QBDK5FO3V"]
qs = Quote.objects.filter(quote_number__in=quote_numbers)
quotes_data = [i.to_mongo().to_dict() for i in qs]
snowflake_loader = SnowflakeLoader(
sf_account=settings.SECRET_SETTINGS.farmers.snowflake.account,
sf_user=settings.SECRET_SETTINGS.farmers.snowflake.user,
sf_password=settings.SECRET_SETTINGS.farmers.snowflake.password,
warehouse=settings.SECRET_SETTINGS.farmers.snowflake.warehouse,
database=settings.SECRET_SETTINGS.farmers.snowflake.database,
schema="DAILY_DUMPS",
)
snowflake_loader.upload_json("all_quotes", "all_quotes", quotes_data)
gc.collect() # Freeing memory
#+end_src