Org Web Adapter

Editing journals/2023_09_20.org

:PROPERTIES:
:ID:       19511c16-3d35-416b-84e3-83f20b038b9f
:END:
#+title: 2023-09-20

* DONE One on one with Bogle
CLOSED: [2023-09-20 Wed 21:36]
<2023-09-20 Wed>
* DONE Force push 74 policies and quotes for Toggle Renters :sure:task:
CLOSED: [2023-09-20 Wed 21:36]
<2023-09-20 Wed>
#+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.upload_json("all_quotes", "all_quotes", quotes_data)

gc.collect()  # Freeing memory

#+end_src