+ ԷcjD Rt^RIt^RIt^RIt^RIt^RIt^RIt^RIt^RIt^RI t ^RI t ^RI t ^RI HtH t Ht^RIHt^RIt^RIHtHtHtHtHt^RIHt^RIHtHt^RIHtH t H!t!H"t"H#t#H$t$H%t%H&t&H't'H(t(H)t)H*t*H+t+H,t,H-t-]P\!]/4t0]!R]/4t1R ]&R ](R ])R ]'R ]%R]PdPf/t40Rmt50Rmt6RR0t70Rmt8Rs9]Pt!4t;]]ltmR?tnR@toRAtpRBtqRCtrRDtsREttRFtuRGtvRHtwRItxRRJltyRKtzRRLlt{RMt|RNt}RROlt~RRPltRRQltRRtRStRRTltRRUltRVtRRWltR]B3RXltRRYltRZt^2tR[tR\tR]tR^tR_tR`tRatRbtRctRdtRetRftRgtRhtRitRjtRktRRlltRmtRRnltRRoltRptRqtRRrltRst]A3RtltRutRvtRwtRRxltRytRztR{tR|tR}tR~tRtRRltRtRRltRtRtRtRtRtRtRRltRtRtRt]1EPzR4t]1EPR4R4t]1EPRR.R7R4t]1EPRR.R7R4t]1EPRR.R7R4t]1EPRR.R7R4t]1EPRR.R7R4t]1EPRR.R7R4t]1EPRR.R7R4t]1EPRR.R7R4t]1EPRR.R7R4t]1EPRR.R7R4t]1EPRR.R7R4t]1EPRR.R7R4t]1EPRR.R7R4t]1EPRR.R7R4t]1EPRR.R7R4t]1EPRR.R7R4t]1EPRR.R7R4t]1EPRR.R7R4t]1EPR4R4t]1EPR4R4t]1EPRR.R7R4t]1EPRR.R7R4t]1EPRR.R7R4t]1EPRR.R7R4t]1EPRR.R7R4t]1EPRR.R7R4t]1EPRR.R7R4t]1EPRRR.R7R4t]1EPRR.R7R4t]1EPRR.R7R4t]1EPRR.R7R4t]1EPRR.R7R4t]1EPRR.R7R4t]1EPRR.R7R4t]1EPRR.R7R4t]1EPRR.R7R4t]1EPRR.R7R4t]1EPRR.R7R4t]1EPRR.R7R4t]1EPRR.R7R4t]1EPRR.R7R4t]1EPRR.R7R4t]1EPR4R4t]1EPR4R4t]1EPR4R4t]1EPR4R4t]1EPR4R4t]1EPRRR/R7]1EPR4R44tR#)zFGarden Tracker: plants, seeds, schedules, hydro tanks, planting guide.N)datedatetime timedelta)Decimal) BlueprintResponsejsonifyrequestsend_from_directory)secure_filename)ensure_alert_state_tablesend_sms_alert_detailed)GARDEN_CLIENT_DIST GARDEN_LAT GARDEN_LONGARDEN_LOCATION_LABELGARDEN_REMINDER_CHECK_MINUTES GARDEN_ZIPMYSQL_DATABASE MYSQL_HOSTMYSQL_PASSWORD MYSQL_PORT MYSQL_USERPARTSINV_IMAGE_SEARCH_API_KEYPARTSINV_IMAGE_SEARCH_CX WEATHER_LAT WEATHER_LON gardentrackerhostportuserpassworddatabase cursorclassseed store_boughtFgardentracker_seed_uploadsc6\P!R/\B#)N)pymysqlconnect DB_CONFIGr(@/workplace/Workspace/Software/Server/blueprints/gardentracker.pyget_dbr.Qs ?? 'Y ''r,c2\V\4'dVP4#\V\4'dVP4#\V\4'd \ V4#\V\ 4'dVPRRR7#V#)utf-8replaceerrors) isinstancer isoformatrrfloatbytesdecodevalues&r- _serializer;Usr%""  %  %!!U|%||GI|66 Lr,c~V'gV#VP4UUu/uFwrV\V4bK upp#uuppiN)itemsr;)rowkvs& r-_serialize_rowrBas3  ), 5Az!}  55 5s9cBVUu.uFp\V4NK up#uupir=)rB)rowsrs& r-_serialize_rowsrFgs'+ ,t!N1 t ,, ,scVeVR8XdR#\V\4'dV#\P!\ V4P RR44P4# \ dR#i;iNZz+00:00)r4rr fromisoformatstrr1 ValueErrorr9s&r- _parse_daterNksd } % %%c%j&8&8h&GHMMOO sA"J%!!J%2I J% I J%I($J%'I((J%+J J%J J%J" J%!J" "J%% J5 cVPR4VP4p\VR,;'g^4^,p\W3V,4Uu.uF pRVR 2NK up#uupi)z SELECT MAX(CAST(SUBSTRING(label_id, 3) AS UNSIGNED)) AS n FROM GardenPlant WHERE label_id LIKE 'P-%' nzP-05d)rTrWrVrange)r^countr?startis&& r-_allocate_plant_label_idsrlksdKK  ,,.C C A  "E"'u}"= >"=Qb3L"= >> >sA+c |VP4;_uu_4pVPR4VP4pV'g RRR4R#\V\ V44p\ W#4FwrEVPRWTR,34K! RRR4VP 4R# +'giL";i)zNSELECT id FROM GardenPlant WHERE label_id IS NULL OR label_id = '' ORDER BY idNz2UPDATE GardenPlant SET label_id = %s WHERE id = %sid)rSrTfetchallrllenzipr[)r]r^rDlabelsr?labels& r-r\r\xs # \ ||~  +3D :d+JC KKLuZ^V_N` a,  KKM s+B+AB++ B; a SELECT p.*, s.crop_name AS seed_crop_name, s.variety AS seed_variety, s.location AS seed_bin, s.source AS seed_source, EXISTS ( SELECT 1 FROM GardenPlantEvent dead_event WHERE dead_event.plant_id = p.id AND dead_event.event_type = 'died' ) AS has_died_event FROM GardenPlant p LEFT JOIN GardenSeedInventory s ON s.id = p.seed_id cNV'gR#VPR4;'gVPR4;'gRP4pVPR4;'gVPR4;'gRP4;'gRpT;'gRV3#)Nseed_crop_namerarI seed_varietyvarietyNNrXstrip)r?croprws& r-_plant_type_crop_varietyr|s  GG$ % > > > >B E E GDww~&BB#'')*<BBIIKSStG <<4  r,c\WV4pT;'g/PR4;'g.pV'd V^,#R#)imagesN)_get_seed_type_inforX)r] crop_namerw type_infor~s&&& r-_get_primary_type_imagers=#DW=Ioo2 " "8 , 2 2F6!9(D(r,cV'gV#\V4pVPR4R8Xd&VPR4'd\V4VR&V'd)Ve%\V4wrEV'd\ WV4VR&V#) source_typer$seed_id seed_label primary_image)rBrX_seed_display_labelr|r)r?r]include_primary_imageoutrrws&&& r-_serialize_plantrsp   C ww}'CGGI,>,>/4L!15c: #:4G#TC Jr,c.pVPR4'dVPRVR, 24VPR4;'gVPR4pV'dVPV4VPR4;'gVPR4pV'dVPV4V'dRPV4#R#)seed_binzbin #rurrvrwu · N)rXappendjoin)r?partsr{rws& r-rrs E wwz uS_-./ 77# $ < < (D EfM# 3f EE EscXVfR#\V4P4pT;'gR#r=)rLrz)r:locs& r-_normalize_locationrs( } e*   C ;;$r,cdVeVR8XdR#\V4# \\3dR#i;i)NrI)r6 TypeErrorrMr9s&r-_optional_floatrs6 } U| z "s //cRVR8wdR#VPR\V4V34R#) transplantedNz2UPDATE GardenPlant SET location = %s WHERE id = %s)rTr)r^r event_typelocations&&&&r-_sync_transplant_locationrs)^#KK< X &1r,cVP4;_uu_4pVPR4VP4uuRRR4# +'giR#;i)z)SELECT * FROM GardenSettings WHERE id = 1N)rSrTrWr]r^s& r- _get_settingsrs1 # ?@||~ s !A A c\P!4pVPR4VPR\P!4P 4 R24VPR4VP 4;_uu_4pVPR4VP4Uu.uF q3R,NK ppVEFspVPRV R24VP4pV'dVPR4MR pV'gKNVPR V R 24VPR V R 24VPV R24VPRV R24VP4pV'gK\V^,P44p RPV U u.uF p RV R2NK up 4p VF\pRPV U u.uF"qPVPV 44NK$ up 4p VPRV RV RV R24K^ VPR 4EKv R R R 4VPR4VP4#uupiuup iuup i +'giL@;i)z-- Garden Tracker backup z-- Generated at z zSET FOREIGN_KEY_CHECKS = 0; z SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = DATABASE() AND TABLE_TYPE = 'BASE TABLE' AND TABLE_NAME LIKE 'Garden%' ORDER BY TABLE_NAME TABLE_NAMEzSHOW CREATE TABLE ``z Create TableNz -- Table:  zDROP TABLE IF EXISTS `z`; z; zSELECT * FROM `z, z INSERT INTO `z` (z ) VALUES (z); zSET FOREIGN_KEY_CHECKS = 1; )ioStringIOwriternowr5rSrTrorWrXlistkeysrliteralgetvalue) r]rr^r? table_names table_name create_row create_sqlrDcolumnscr_valss & r-_sql_dump_garden_tablesr s  ++-CII*+II !9!9!; D47<<>*Gii7 ;7a1QCq7 ;1D"!::fa(+113 3I ::<r,c \V'd\V4V8dR#\VPR44pV'gR#\V4;'gTpWQ9dR#VP V4TP RTRVPR4RVPR4;'gR/4R#)Nrtitlesource wikipedia)rprrXraddr)r~seen_identitiesimglimitridents&&&& r-_append_unique_imagers #f+& swwu~ .C  %c * 1 1cE  MM s!#''(#22{r,c\PP\PP\PP\444p\PP V\ 4#r=)osrdirnameabspath__file__rSEED_IMAGE_UPLOAD_DIR)bases r-_seed_upload_rootrsD 77??277??277??8+DE FD 77<<3 44r,cl\P!RRT;'gR4R,pT;'gR#)z [^\w\-|]+runknown:NPN)resub) cache_keysafes& r-_seed_upload_subdirr!s/ 66,Y%;%;) 29 $S)   366N9+6 SWWW% cggh'66; 23BSBStT   !*+  5 s8+ +  J10 J=## I s GG*)G*cT;'gRP4P4pT;'gRP4P4pV RV 2#)rI|)rzr)rrwr{vars&& r-_seed_type_cache_keyrTFsL OO " " $ * * ,D ==b   ! ' ' )CV1SE?r,cLRVPR4RVPR4RVPR4RVPR4RVPR4RVPR4R VPR 4;'g.R VPR 4R VPR 4/ #) slug common_name commonNamescientific_namescientificNamecategoryseasondays_to_harvest daysToHarvestwindowsnotes zone_range zoneRangerX) crop_datas&r-_map_cropgraph_guidereLs f%y}}\29==)9:IMM*-)--)9==99==+11rw'immK0  r,cT;'gRP4pV'gR#VP4PRR4pRV 2p\W4pV'dV#\ RV 24pTPR 4;'gTp \T 4p \!YT ^4T # \ P P\ P P\P\3d\ R\ PPT4 24pTPR4;'g.pT'gR#T^,PR4;'gTp\ RT 24pEL \ P P\ P P\P\3dR#i;ii;i) rIN -z crop_detail:z#https://api.cropgraph.com/api/crop/'https://api.cropgraph.com/api/search?q=resultsrVr{)rzrr1rrrerrorURLError HTTPErrorrr-OSErrorrr$rXrer) r]rr{rVrcachedr8searchrjrdguides && r-_fetch_cropgraph_plantingrrZsz OO " " $D  ::<  S )Dtf%I  (F   !DTFKL ((DI  +Etr* L LL ! !6<<#9#94;O;OQX Y  $9&,,:L:LT:R9STFjj+11rG1:>>&)11TD"%H#OPD %%v||'='=t?S?SU\]   s? B##A G 1AE54 E5E5!E55A GG GG c^\PPT;'gRPRR4RR7pV'gR#\ \ RV 24# \P P\P P\P\3dR#i;i)rIrgrr#Nz/api/rest_v1/page/summary/) rrr$r1r WIKIPEDIA_APIrkrlrmrr-rn)r encodeds& r-_wiki_page_summaryrvwsll  %++2!6!6sC!@r JG -0J7)TUU LL ! !6<<#9#94;O;OQX YsAA B,+B,c T;'gRP4pV'g.#\\ R\PP V4 RV 24pVP R4;'g.Uu.uF,qDP R4'gKVP R4NK. up#uupi \PP\PP\P\3d.u#i;i)rIz/w/rest.php/v1/search/title?q=z&limit=pagesr ) rzrrtrrr$rXrkrlrmrr-rn)queryrqr8ps&& r-_wiki_search_titlesr|s "A  o;FLL"D"D"!I!I(!SC s #C  sW%+ r,cT;'gRP4pV'g.#\PPRRRVRRRRRR R R /4p\ \ R V 24p.pTPR4;'g/PR /4P4FpTPR4'dK\TPR4;'g/PR44pT'gKYTPRTRTPR4RR/4K TRT# \P P\P P\P\3d.u#i;i)rIactionrytitlesprop pageimagesformatr pithumbsizepipropzthumbnail|name /w/api.php?rxmissingr~r rr r N)rzrr urlencoderrtrkrlrmrr-rnrXvaluesrr)r rparamsr8r~pagers&& r-_wiki_page_imagesrsW [[b   !E  \\ # # g e L f 3 &   F- F8DEF'"((b--gr:AAC 88I   $dhh{&;&A&Ar%F%Fx%PQ 5 MMu'*+  D &5> LL ! !6<<#9#94;O;OQX Y sD((AE:9E:cT;'gRP4P4pV'd\V4^8:dR#V\9#)rIT)rzrrpGENERIC_VARIETY_TERMS)rwrAs& r-_is_generic_varietyrs; B%%'A A!  % %%r,cT;'gRP4P4p\4pV'dVPV4VP 4F&p\ V4^8gKVPV4K( \ PVR4F"pVPVP44K$ V#)rIr()rzrrLr rrpCROP_WIKI_ALIASESrX)rr{termswordaliass& r-_crop_match_termsrs OO " " $ * * ,D EE  $JJLD4yA~ $!'**44E IIekkm $5 Lr,cT;'gRP4pV'gR#\V4F pWC9gK R# T;'gRP4P4pV'd\V4'g W#9dR#R#)rIFT)rrrzr)r rrwtitle_lterms&&& r-_wiki_title_matches_croprsk{{!!#G !), ?-}}"##%++-G*7338J r,cT;'gRP4pV'g.#\4p.p\WR7FTpV'gK VP4V9gK$VP VP44VP V4KV \ V4^8de\WR7FTpV'gK VP4V9gK$VP VP44VP V4KV V#)rIr)rzrLr|rr rrp_wiki_fulltext_titles)rrrNrr s&& r-_wiki_crop_title_candidatesrsb'')I  5D C$Y< 5U[[]$. HHU[[] # JJu = 3x!|*9BEud2' 5!C Jr,cXT;'g.Uu.uFp\W1V4'gKVNK ppV'dV#\V4Uu0uFq3P4kK ppT;'g.Uu.uF%q3;'gRP4V9gK#VNK' up#uupiuupiuupirI)rrr)rrrwtfiltered allowlists&&& r-_filter_titles_for_croprs"LLbL]La-EaT[-\LH]$? $JK$Jq$JIK " H !''r):i)GAA HH ^L Hs"BBB"/ B'<B'B'c`T;'gRP4p\V4'dR#V#rrzrrws&r-_variety_for_wiki_searchrs)}}"##%G7## Nr,cT;'gRP4p\V4p.pV'd-VPV RV 24VPV RV 24V'dVPV4\4p.pVFGpVP 4pV'gKWc9gK%VP V4VPV4KI V#rIrg)rzrrrLrr )rrwqueriesrNrrzrs&& r-_wiki_search_queriesrsb'')I&w/GG'!I;/0)AgY/0y! 5D C ggi 33? HHSM JJqM  Jr,cTp\W4F(p\WBR7p\WPV4pV'gK%Wd3u# \WR7pV'dWp3#.R3#)rN)rr|rr)rrwrvariety_for_matchryrrelevant crop_titless&&& r-_wiki_resolve_titlesrs\%i9$U8*6>OP 8? " : .iEK%% t8Or,c >T;'gRP4pV'g.#\PPRRRRRVRVRR/4p\ \ R V 24pTPR4;'g/PR.4Uu.uF,qUPR 4'gKTPR 4NK. up# \P P\P P\P\3d.u#i;iuupi) rIrryrrpsrsearchsrlimitrrrr ) rzrrrrrtrkrlrmrr-rnrX)ryrrzrr8hits&& r-rrs "A  \\ # # g H  u f  F- F8DE*.'):)@)@b(E(EhPR(S h(SW^W^_fWg CGGG (S hh LL ! !6<<#9#94;O;OQX Y  hsCD-DADDcaT;'gRP4oSPR4'gR#\;QJdV3RlR4F 'gK RM RM!V3RlR44'gR#Rp\;QJd)V3RlV4F'gK R'*# R'*#!V3RlV44'*#)rIzfile:Fc3,<"TF qS9xK R#5ir=r().0extras& r- &_wiki_file_is_photo..7sI&Hsd{&HTc3,<"TF qS9xK R#5ir=r()rtokenras& r-rr=s:kUD=kr).jpg.jpeg.png.webp) z commons-logoz edit-clearsymbolzicon-flagmaplogo pictogramambox wikimedia question_bookcrystal)rrany) file_title skip_tokensras& @r-_wiki_file_is_photor3s   " # # %D ??7 # # 3I&HI333I&HI I IKs:k:ss ::s ::s:k:: ::r,cT;'gRP4pV'dV^8:d.#\T;'g.4p\PP RRRVRRR^RR/4p\ \ R V 24p.pTPR4;'g/PR /4P4FZpTPR4;'g.F8pTPR 4p\T4'gK'TP!T4K: K\ T'g.#.p ^p \#^\%\'T4^4T 4EFhp Y[Y,p \PP RRRR P)T 4RR RRRRRR/4p \ \ R T 24pTPR4;'g/PR /4P4FpTPR 4;'g/.^,p\+TPR4;'gTPR44pT'gKc\-T4;'gTpTT9dKTP/T4T P!RTR TPR 4RR/4\'T 4T8gKT uu# EKk T # \PP\PP\P\3d.u#i;i \PP\PP\P\3dEKi;i)rIrryrrr~imlimitrrrrxr rR imageinfoiipropr iiurlwidthrthumburlr r )rzrLrrrrrtrkrlrmrr-rnrXrrrrhrrprrrr )r skip_identitiesrrr8 file_titlesritemrr~ batch_sizerjbatch info_params info_datainforrs&&& r-_wiki_extra_page_imagesr@s [[b   !E EQJ ///R0O \\ # # g e H r f  F- F8DEK'"((b--gr:AACHHX&,,",D'*J":.."":.-D  FJq#c+.3Z@%"45ll,,'#((5/ %c&     '=/(RSI]]7+11r66wCJJLDHH[)11bT15D&txx ';'N'NtxxOC-c299cE'    & MMs'*+  6{e# M!A@ M[ LL ! !6<<#9#94;O;OQX Y 6 %%v||'='=t?S?SU\]   s&+J5L 5ALL A MMc .p\4p\WV4Fp\V4V8dM\V^R7pV'd\ WEV^,V4M!\ V4p\ WE\ V4V4\V4V8dMQV^8gK{\VVV\V4, R7F"p \ WEW4\V4V8gK!K K VRV#)r)rrN)rLrrprrrvrr) rrrwrr~r r  page_imgsprimaryextras &&&& r-_collect_wiki_imagesrs FeO(GD v;%  %e15  )A, N(/G :RSZ:[]b c v;%   190 /c&k) %VeKv;%'E( &5>r,cVP4;_uu_4pRpV'd VR, pVR, pVPV4VP4uuRRR4# +'giR#;i)zSELECT * FROM GardenSeedCompanyz WHERE enabled = 1z ORDER BY sort_order, nameN)rSrTro)r] enabled_onlyr^sqls&& r-_get_seed_companiesrsN #/  ' 'C ++ C||~ s =A!! A2 c\PPV4P;'gRP 4#r)rrrhostnamer)rbs&r- _company_hostrs. LL ! !( + 4 4 : : A A CCr,c\PPV4pVP;'gRP 4pV'dVP R9dR#\ VRR7FNp\VPR44pV'gK'W58Xg!VPRV,4'gKMR# R#)rIFTrrb.)httphttps) rrrrrschemerrrXendswith)r]rparsedrcompany company_hosts&& r-_is_allowed_product_urlrs \\ " "3 'F OO ! !r ( ( *D 6==(99&t$?$W[[%<= >@Ax( ( 0 0b 9 A A% L R R T  ]%8%8%:hnn>N%NNNm_Ai[#A#G#G#IJNN=1#a {+1134sy! 5D Ckkm 5S_ HHSM JJu   Jr,c<aS;'gRP4o\;QJdV3RlR 4F 'gK RM RM!V3RlR 44'dR#RS9d!\\P!RS44#RS9gRS9gRS9dR#R#) rIc3.<"TF pVS9xK R#5ir=r(rskiprs& r-r+_is_company_product_path..s   D   TFz /product/z/product/[^/]+(?:/\d+)?/?$z.htmlz/herbs/ /vegetables/)z/gift-certificatez '+produrl+'produrlz /viewcartz/create_review)rrrGrrp)rsfr-_is_company_product_pathr,s JJB   D s   sss    dBII;TBCC$)t+~/E r,cPaT;'gRP4oS'gR#\;QJd#V3Rl\4F 'gK RM RM!V3Rl\44'dR#RS9gRS9dR#RS9d \P!RS4'dR#R#)rIFc3,<"TF qS9xK R#5ir=r()rr'rs& r-r-_is_seed_company_image_url.."s @!?19!?rTz/images/popup/z/images/products/rz//images/[^/]*\d{3,}[^/]*\.(?:jpg|jpeg|png|webp))rrSEED_COMPANY_IMAGE_SKIP_TOKENSrrprs&@r-_is_seed_company_image_urlr1s| A  s @!? @sss @!? @@@1 3q 8q RYY: && r,cF\VPR44pVR8wd.#VPR4;'gRPR4p.pVFp\PP RRRRRV/4P 4p\PPV R 2VR R R R RRRV R2/RR7p\PPV^R7;_uu_4pVP4PRRR7p RRR4VP\X V44K \%\&P)V44# +'giLM;i \PP\PP \"3dEKMi;i)rbwww.totallytomato.comrIrrSearch search_typeprodcatkeywordz /index.phpr.addUs8OOODtD( T"$r,rIrb)rL_fetch_html_url_company_search_urlrrkrlrmrnrB_company_browse_linksrGrrX_google_site_search_links) rrrwrDr  search_queryrFdomainrErNs &&&& @@r-_collect_company_product_linksrSQs E 5D# '  )*=g*TUK *; @A 'g12"7;< 7;;z2 3F *L )&? @+ L %%v||'='=wG K sB%%AC('C(c\VPR44pVPR4;'gRPR4pT;'gRP4pV'dV'd V'g.#.pVR8Xd*\ V4pV'dVP RV R24M/VR8Xd)\ V4pV'dVP RV R24.pVF/p\ W7,4pTP\Y44K1 \\P!V44# \PP\PP\3dKi;i)rbrIrzwww.johnnyseeds.comr*r3z/vegetables/vegetable-seeds/z-seeds)rrXr?rzrrrMrrkrlrmrnrArBrr.rC) rrrrbpathspluralrEr browse_htmls && r-rOrOls, Z0 1D J'--255c:Hb'')I xy E $$"9-  LL<xq1 2 ( ("9-  LL7xvF G E )(/:K  3KIJ   e$ %% %%v||'='=wG   s"D//>E10E1c\V4pV.p\P!RV4'd(VP\P!RRV44VP RR4pV'dVPV4\P !RV4pV'd4VPVP^4 VP^4 24\\PV44#)rorganicrgrI^([a-z])\s+(\d+)\b) _normalize_match_textrrprrr1matchgrouprr.rC)rwnorm_varformscompact code_matchs& r-_variety_match_formsrbs$W-H JE yyH%% RVVIy(;<sB'G W/:J ((+,Z-=-=a-@,ABC  e$ %%r,cpT;'gRP4pV'd\V4'dR#V#rrrs&r-rrs,}}"##%G )'22 Nr,cT;'gRP4pVPRR4PRR4p\P!RRV4pRP VP 44#)rIrhrgrr )rr1rrrr)texts&r-r[r[sZ JJB   D <<S ! ) )#s 3D 66-d +D 88DJJL !!r,ca \V4pV'g^d#\RPV44pV'g^#VPRR4p\ V4F9pWB9d^d#VPRR4p\ V4^8gK0WS9gK8^b# \V4p.pVP 4F@p\ V4^8dVPV4K&VR 9gK/VPV4KB \P!RV4p V 'd4VPV P^4 V P^4 24V'gVPRR4V9d^d#^#Vo RV9d S R, o \V 3RlV44p V \ V4, p V R8d^_#V R8d^A#V 'd^##^#) drgrIogrZz organicc38<"TFqS9gK ^xK R#5irNr()rrexpandeds& r-r'_variety_match_score..sA/@!! g?g?)rhopf1f2) rr[rr1rbrprrrr\r]sum) rwtextscombined compact_textform compact_formr^ var_tokensrramatchedratiorks &* @r-_variety_match_scorerzs )G $SXXe_5H ##C,L$W-  ||C, |  !l&B . %W-HJ! u:?   e $ . .   e $ " /:JZ--a01*2B2B12E1FGH &&sB/<?sFQFH zJAAAG c*o %E | | r,caT;'gRP4pV'g^d#\V4p\RPV44oS'g^#VS9d^d#VP4Uu.uFp\ V4^8gKVNK ppV'gVSP RR49d^d#^#\ V3RlV44p\^dV,\ V4, 4#uupi)rIrgc38<"TFqS9gK ^xK R#5irjr()rrrss& r-r$_crop_match_score..sB0A!!rm)rzr[rrrpr1rqrV)rrr norm_cropr crop_tokensrxrss&* @r-_crop_match_scorersb'')I %i0I$SXXe_5H H'oo/?/3q6Q;11/K? 8#3#3C#<.&s   DLr)TFz://) z/searchz /customer-z/growers-libraryz/shop-by-colorz/cartz/accountz/loginz /shippingz/privacy)rXr?rrfindallr1rrrrrrrrr,rrnetlocrr.rC)rrrb base_hostrEhrefrrs&& @r-rBrBsX J'--255c:Hh'I E ,djjb9||GS) ??3  ?Dv&& &&t, Yoo-M  !!r((* 3  333      #D ) ) LL.>ASASTWAXX Y':(  e$ %%r,c \'d \'g.#\PP R\R\RRV RV 2R\ V^ 4/4p\ RV 2^ R7p.pTPR4;'g.FEpTPR 4pT'gKTPTPR 4^,4KG \!\"P%T44R T# \PP\PP\P\3d.u#i;i) rcxrzzsite:rgnumz+https://www.googleapis.com/customsearch/v1?rr>rK?N)rrrrrrrrkrlrmrr-rnrXrrrr.rC)rRryrrr8rErrKs&&& r-rPrP3s ( (0H0H \\ # # 0 * 5%) 3ub>  F9& B  E!''R'xx 4 LLC+ ,(  e$ %fu -- LL ! !6<<#9#94;O;OQX Y sC22AEEc Z aaaa\V4oT3RlpT3RlpT!R4;'g T!R4oS'g\ P!RS\ P4pT'dZ\P!TP^4P44o\ P!RRS4P4oS'g\ P!RS\ P\ P,4pT'd[\P!\ P!R RTP^444oR PSP!44oT!R 4;'g T!R 4pT'g\ P!R S\ P\ P,4pT'd[\P!\ P!R RTP^444pR PTP!44p.o\#4oTTT3Rlp\ P$!RS\ P4F pT!T4K \ P$!RS\ P4F pT!T4K \'T!R44p T 'd T!T 4\ P(!RS\ P4EF,p \*P,!T P^44p \1T \24'dT MT .p T Fp \1T \44'dT P7R4R8wdK1T'gT P7R 4pS'gT P7R4oT P7R4p\1T\24'dT'd T^,MRp\1T\44'dTP7R4p\'T4pT'gKT!T4K EK/ T'g S'dSpT'g S'gR#S'd6\P!S4oR PSP!44oT'd6\P!T4pR PTP!44pRSRTRSR,RT/# \PP\PP\ 3dR#i;i \*P.dEK>i;i)Nc<\SVR7#))rr)rrs&r- meta_property1_extract_product_page_info..meta_propertyS!)$77r,c<\SVR7#))rar)rars&r- meta_name-_extract_product_page_info..meta_nameVrr,zog:titler z([^<]+)z\s*\|.*$rIz]*>(.*?)z<[^>]+>rgzog:description descriptionzC]*>\s*((?:A [^<]{40,600}|(?:A blend of|This)[^<]{20,600}))

c<\V4pV'd\V4'gR#\V4;'gTpVS9dR#SPV4SP RVRSRR/4R#)Nrr r  seed_company)rr1rr r)rr)rr~rNr s& r- add_image-_extract_product_page_info..add_imageqse)#. !;J!G!G )*5CC D=   : U n  r,z>https://[^"\']+/images/products/[^"\']+\.(?:jpg|jpeg|png|webp)z;https://cdn\.commercev3\.net/[^"\']+\.(?:jpg|jpeg|png|webp)zog:imagez2z@typeProductraimagerrr~:NN source_url)rMrrkrlrmrnrrprrrr]rzrrrrrLrrfinditerrrr-r4rr.rX)page_urlrr title_matchh1_matchr lead_matchrrog_imager\rr>rrr~rrNr s& @@@@r-_extract_product_page_inforMs#H- 88 * % ; ;7);E ii 99bddK MM+"3"3A"6"<"<">?EFF;E288:E 993Yrtt L MM"&&R9J"KLEHHU[[]+E,-II=1IG YY R  DD244K mmBFF:r:;K;KA;N$OPGhhw}}/G F 5D  zzI  # zzF  # $M*$=>H(=   jjQ0G>447)DdD))TXXg->)-K((=1(HHW%E%&&$)at%&& %((/Eu% 4 u 6  e$'--(((7==?+7&*h  K LL ! !6<<#9#97 CP##   s# S 0%T >T  T T*)T*cZ\T;'g.4pVUu0uFp\V4kK ppVPR4T;'g.FRp\V4pV'dWe9dKVPV4VP V4\ V4V8gKRM VRV#uupir=)rr1discardr rrp)existing new_imagesrmergedrrNrs&&& r-_merge_seed_imagesrs (..b !F17 8#  %D 8LLR$S)   c v;%    &5> 9sB(c \VP4;_uu_4pVPRV34VP4'd RRR4R#TPRYT;'gR\P!.434RRR4VP 4R# +'giL";i)z=SELECT cache_key FROM GardenSeedTypeInfo WHERE cache_key = %sNz INSERT INTO GardenSeedTypeInfo (cache_key, crop_name, variety, images) VALUES (%s, %s, %s, %s) )rSrTrWrrr[)r]rrrwr^s&&&& r-_ensure_seed_type_info_rowrs| # SV_Uab <<>>    7??dDJJrN C   KKM s+BB$B B+ cVP4;_uu_4pVPR4\VP4;'g/P R4;'g^4^8uuRRR4# +'giR#;i)z SELECT COUNT(*) AS cnt FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'GardenSeedTypeInfo' AND COLUMN_NAME = 'images_user_managed' rRN)rSrTrVrWrXrs& r-rFrFs\ #   CLLN((b--e499:Q> sAA4 A44 B cVP4;_uu_4pVPRV34VP4pRRR4\X'dVP R44#R4# +'giL8;i)z:SELECT images FROM GardenSeedTypeInfo WHERE cache_key = %sNr~)rSrTrWr/rXrHs&& r-_load_type_info_imagesrsZ # PS\R^_lln  #SWWX. @@4 @@ s $A-- A= c`\WW#4VP4;_uu_4p\P!VR\4pV'd&\ V4'dVP RWq34MVP RWq34RRR4VP4R# +'giL";i)Nz UPDATE GardenSeedTypeInfo SET images = %s, images_user_managed = 1 WHERE cache_key = %s z>UPDATE GardenSeedTypeInfo SET images = %s WHERE cache_key = %s)rrSrrrMrFrTr[)r]rrrwr~ user_managedr^rs&&&&&& r-_save_type_info_imagesrst C #**V$9%9:; ;DAA KK $   KKP$    KKM! s AB B- ctV'dRV9gVPR4'dR#\4p\PP W4p\PP V4'd\P !V4R#R# \d\PRT4R#i;i)..rNzCould not delete seed upload %s) rrrrrisfileremovernloggerwarning)r& upload_rootfulls& r-_delete_seed_upload_filers  )Y-A-A#-F-F#%K 77<< /D ww~~d I IIdO I NN $((<"8!7;;v#6 t++DHHX4F4L4L"0MQR0R1 .2 4DHHY''C0B0H0Hb,IQ,N IL t xx)//R/ / &cggen 5 G G G/  !G488H%++,1 -.A'.QR 3;HE e,88L111$7K >1$72((7+ HHY/  ?88H-333C5cggenEWWQVEud!2$++C0txx177R83|;LLPQQ! 4txx)//R03|3DDI5-!F,DHHX,> TUVX  4"tdt  U LL))6<<+A+A7K  s %S&0S&;S++>T.-T.c DT;'gRP4pT;'gRP4pV'gV'g RRRRRRR./#\W4wr#V'gV'd\V4pTp.pRpRpRpV'd\V^,4pV'd]VP R4pVP R4pVP R4;'g/P R /4P R 4p\ W V\ R 7pRVRVRVRVR\ /#) rIrNwikipedia_title wikipedia_urlr~extractr  content_urlsdesktoprr)rzrrrvrXrWIKI_IMAGE_LIMIT) rrwr matched_queryr~ summary_text wiki_titlewiki_urlrs && r-_fetch_wikipedia_seed_inforsb'')I}}"##%G W t t T b   1DF i&y1! FLJH $VAY/ ";;y1L W-J N399r>>y"MQQRXYH%fHXY <:&**+  r,c.V'gR#\VPR44pVPR4p\V\\34'dVP RRR7p\V\ 4'd\P!V4pRVPR4RVPR4RVPR4R VPR 4R VPR 4R VPR 4RVRVR \VPR 44/ #) Nr~rr0r1r2rrrrrr fetched_at) rPrXr4r7r,r8rLrrr;)r?r~rs& r-_serialize_seed_type_infors  #CGGH$5 6Fwwz"H(UI.//??79?=(C  ::h'3779%377#451sww}-cggl+sww}-&Hj!67  r,c\W4pVP4;_uu_4pVPRV34VP4pRRR4\ X4# +'giL;i)5SELECT * FROM GardenSeedTypeInfo WHERE cache_key = %sN)rTrSrTrWr)r]rrwrr^r?s&&& r-rrsO$Y8I # Ki\Zlln  %S )) s $A A+ cV'gR#VPR4;'gRP4'dR#VPR4'dR#VPR4'dR#VPR4'dR#R#)FrrITr~rrry)rs&r-_seed_type_info_has_contentrsd  i &&B--//}}X}}Z  }}_%% r,c\W4p\WW4VP4;_uu_4pVPRV34VP 4;'g/pRRR4\ XP R44p\W4'dTpM$\YsP R4;'g.4pVP R4p VP R4;'gVP R4p \W 4p VP4;_uu_4pTPRTTT;'gRV VP R4VP R4R V V \P!V4VP R 43 4RRR4VP4\WV4# +'giELN;i +'giL@;i) rNr~rrr a INSERT INTO GardenSeedTypeInfo (cache_key, crop_name, variety, summary, wikipedia_title, wikipedia_url, info_source, source_url, source_name, images, planting) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s) ON DUPLICATE KEY UPDATE crop_name = VALUES(crop_name), variety = VALUES(variety), summary = VALUES(summary), info_source = VALUES(info_source), source_url = VALUES(source_url), source_name = VALUES(source_name), images = VALUES(images), fetched_at = CURRENT_TIMESTAMP rrrr)rTrrSrTrWrPrXrIrrrrr[r) r]rrw page_inforr^rexisting_imagesr~rrrs &&&& r-_apply_product_page_inforse$Y8It C # Ki\Z<<>''R -X\\(-CDO%d66 #O]]85L5R5RPRS|,JmmI&@@)--*@G&t8K #   4 ./ _- 6" Z( !  > KKM t 88]  s.F#A)F7# F4 7 G c.\W4pVe \V4pM \W4p\W4p\ WV4pVP R4p\VP R4;'g.4p VP R4p VP R4p VP R4p Rp RpV'*p\ V 4^8pV'g V'd\W4pV'dUVP R4'd>VP R4pVP R4p VP R4pV 'gRp V'd3\T VP R4;'g.R\\R 7p V 'gSVP R4'gVP R4'd%Rp VP R4p VP R4p\W4'd \W4p M\WY\R 7p VP4;_uu_4pTPR TTT;'gRTT TT T T \P!V 4V'd\P!V4MR3 4RRR4VP!4R# +'giL";i) Nrr~rrrrrr raQ INSERT INTO GardenSeedTypeInfo (cache_key, crop_name, variety, summary, wikipedia_title, wikipedia_url, info_source, source_url, source_name, images, planting) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s) ON DUPLICATE KEY UPDATE crop_name = VALUES(crop_name), variety = VALUES(variety), summary = VALUES(summary), wikipedia_title = VALUES(wikipedia_title), wikipedia_url = VALUES(wikipedia_url), info_source = VALUES(info_source), source_url = VALUES(source_url), source_name = VALUES(source_name), images = VALUES(images), planting = VALUES(planting), fetched_at = CURRENT_TIMESTAMP )rTrrrrrrXrprrrrMrIrSrTrrr[)r]rrwpreserved_imagesrrrrrr~rrrrr need_summary need_imageswikir^s&&&& r-_fetch_and_store_seed_type_infor s$Y8I#/00A(9H&t@Gkk)$G '++h'--2 .F++m,K\*J++m,KJH;Lf+/K{))= DHHY//hhy)G"34Jxx0H) '(#))r+<,<=*F  3 3txx7I7I%K"34Jxx0H%d66'8#OCWX #  &4 6"(0 8$d '  D KKME s.workeris  =&&7;;ItL '8D $T*/%.  '&)11)<'&!'&  N   A9 M N'&&&&)11)<'&&&stB=BB=B(B=5C$ B% B=(B::B==!C!C8 C!!C8$ C5 8D9D&  D9& D6 1D9Tz seed-type-:N Ntargetdaemonra)rTrrrr  threadingThreadrj)rrwrr rsff& @r-_queue_seed_type_fetchr_s$Y8I    '5E ' 2 1 1    "%%i0 =,)C.) * egC  sBB B* c\V4;'g/p\VPR4;'g^4p\V4pVPR4;'gTp\ VR,4\ V48*VR&V#)low_seed_thresholdlow_stock_thresholdqty low_stock)rrVrXrBr6)r]r?settings thresholdrrs&& r-_serialize_seed_with_stockrsrT"((bHHLL!56;;!.:Eqyy{{EFT02drc3@"TFqP4xK R#5ir=r$r&s& r-rr'r(r))rLrzrrpallrV)r:r rs& r- _format_mmddr-s   E A GGCLE 5zQ33:E:333:E:::eAh-$Ac%(mC%899 5zQ33:E:333:E:::eAh-$Ac%(mC%899 Hr,c\VR4pV'dV#\V4;'g/pVPR4;'g\p\ V4wrEp\ RV R24p\ RV RV 24pVPR4;'g/p VPR4;'g/p RTRV PR4;'gVPR4R VPR 4R \V PR 44R \V PR 44RVPR4RVPR4RRVRV//p \VRV ^4V # \ PP\ PP\P\3d/pELEi;i \ PP\ PP\P\3d/pELi;i)z zone_info:v2r zhttps://phzmapi.org/z.jsonz'https://api.cropgraph.com/api/zone?lat=&lng=zone frostDatesrqtemperature_rangelast_spring_frost lastSpringfirst_fall_frost firstFall season_days seasonDays climate_type climateType coordinatesrr)rrrXrr!rrrkrlrmrr-rnr-r) r]rorr rrrphzm cropgraphr0frostresults & r-_get_zone_infor@s n -F  T"((bH||J'55:Hd#KCa!5hZuEF#5cU%u E == & &BD MM, ' - -2E x 44DHHV$4TXX&9:\%))L*ABL;)?@y}}\2 m4sE3/ Ft^VR0 M+ LL ! !6<<#9#94;O;OQX Y LL ! !6<<#9#94;O;OQX Y s&E*F2AF/.F/2AHHc ,\p\pRV RV R2p\V4pVPR4;'g/pVPR4;'g/pRVPR4RVPR4R VPR 4;'gR .^,R VPR 4;'gR .^,/# \P P \P P\P\3dR #i;i)z0https://api.open-meteo.com/v1/forecast?latitude=z &longitude=z¤t=temperature_2m,relative_humidity_2m&daily=temperature_2m_max,temperature_2m_min&temperature_unit=fahrenheit&timezone=auto&forecast_days=2currentdailytemp_ftemperature_2mhumidityrelative_humidity_2m today_maxtemperature_2m_maxN today_mintemperature_2m_min) rrrrXrrkrlrmrr-rn)rrrr8rBrCs r- _get_weatherrLs C C 5 C5)) ) s#((9%++!''R gkk"23  $:; %))$89CCdVQG %))$89CCdVQG   LL ! !6<<#9#94;O;OQX Ys)"CC=C"C6 CA DDc\VPR4;'g^4p\P!4\ VR7,#) interval_daysr)rVrXrrr)scheduleintervals& r-_advance_schedule_next_duerRs48<<066B7H ?? yh7 77r,cVPR4;'gVPRR4pV'd V RV R2#V'd V RV R2#V#)r  task_typeTask ()rc)rP plant_name tank_namer s&&& r-_schedule_labelrZsT LL ! F FX\\+v%FE:,a((9+Q'' Lr,c d \4p\V4\V4;'g/pVPR^4'gVP 4R#\ VPR4;'g^4p\ P!4p\ P!\P!4\ PP44pVP4;_uu_4pVPRV34VP4pVFp\!VR,4pVPRV34VP#4p V 'd V R,MRp V 'd W8dK[VPRVR,V34VP#4'dK\%WwPR4VPR 44p R V R 2p \'V 4wrV 'gKVPR W34K VPR V34VP4FpRVR, 2pVPRV34VP#4p V 'd V R,MRp V 'd W8dKURVR, VPR4'dRVR,,R,MR RVR, RVR, R2p \'V 4wp pV 'gKVPRW34K VPR4VP4pVEFpVPRVR,34VP#4p\ VPR4;'g^4pRpV'gR pMVR!,\)VR"7,pVV8*pV'gK\!VR,4pVPR#V34VP#4p V 'd V R,MRp V 'd W8dKR$VR%, R&2p \'V 4wp pV 'gEKVPR'VV34EK RRR4VP+4VP 4R# +'giL2;i \,d\.P1R(4LGi;i TP 4i;i))notifications_enabledNra. SELECT s.*, p.name AS plant_name, t.name AS tank_name FROM GardenSchedule s LEFT JOIN GardenPlant p ON p.id = s.plant_id LEFT JOIN GardenTank t ON t.id = s.tank_id WHERE s.enabled = 1 AND s.next_due <= %s rnz SELECT last_notified_at FROM alert_state WHERE source_type = 'garden_schedule' AND source_id = %s AND metric = 'reminder' last_notified_atz SELECT id FROM GardenTaskCompletion WHERE schedule_id = %s AND completed_at >= %s LIMIT 1 rXrYzGarden Tracker: z is dueaF INSERT INTO alert_state (source_type, source_id, metric, last_state, last_notified_at) VALUES ('garden_schedule', %s, 'reminder', 'due', %s) ON DUPLICATE KEY UPDATE last_state = 'due', last_notified_at = VALUES(last_notified_at) z SELECT s.* FROM GardenSeedInventory s WHERE s.qty <= COALESCE(s.low_stock_threshold, %s) seed_z SELECT last_notified_at FROM alert_state WHERE source_type = 'garden_seed' AND source_id = %s AND metric = 'low_stock' u#Garden Tracker: Low seed stock — rrwrVrWrIz: rrgunitz remainingaC INSERT INTO alert_state (source_type, source_id, metric, last_state, last_notified_at) VALUES ('garden_seed', %s, 'low_stock', 'low', %s) ON DUPLICATE KEY UPDATE last_state = 'low', last_notified_at = VALUES(last_notified_at) zSELECT * FROM GardenTank SELECT recorded_at FROM GardenTankReading WHERE tank_id = %s ORDER BY recorded_at DESC LIMIT 1 test_interval_daysFT recorded_atrOz SELECT last_notified_at FROM alert_state WHERE source_type = 'garden_tank' AND source_id = %s AND metric = 'test_overdue' zGarden Tracker: Tank 'raz' needs testing (pH/EC)aF INSERT INTO alert_state (source_type, source_id, metric, last_state, last_notified_at) VALUES ('garden_tank', %s, 'test_overdue', 'due', %s) ON DUPLICATE KEY UPDATE last_state = 'due', last_notified_at = VALUES(last_notified_at) zGarden reminder check failed)r.rdrrXrrVrrcombinertodayrtimerSrTrorLrWrZr rr[r rr )r]r low_thresholdr today_startr^ due_schedulesschedsid alert_row last_notifiedrsmsgokerrr$rtankstank last_readingrQoverduedue_bytids r-_check_remindersrvs% 8DOT" &,,"||3Q77 V UHLL)=>CC!D oo&&tzz|X\\5F5F5HI [[]]c KK  LLNM&%+& F  LLN AJ *< =PT  ]%A  4[+. <<>>'99\2EIIk4J)w71#62KK  ;'L KK   d4j\* F  LLN AJ *< =PT  ]%A9${:K9L9=)9L9LtI.4RTUUWE{m1T&\N*> 04A2KK  )': KK2 3LLNE $ZM  #||~ txx(<=BBC#"G)-89(;SSF$mG$t*o F  LLN AJ *< =PT  ]%A.tF|n?MJJrN  =!r,c\;_uu_4\'d RRR4R#\P!\RRR7pVP 4RsRRR4R# +'giR#;i)NTzgarden-remindersr)_reminder_lock_reminder_thread_startedrrr{rj)rs r-start_reminder_threadr sI  # #     N4FX Y  #' sA /A  A1 c\4R#r=)rr(r,r-_ensure_reminder_threadr sr,z /api/healthc \4p\ T4\RRRR/4TP 4# \Pd%p\RRR\ T4/4R3uRp?#Rp?ii;i \Pd5p\RRR\ T4/4R3uRp?TP 4#Rp?ii;i TP 4i;i)rnFrkrNTservicer)r.r)ErrorrrLrdr)r]excs r-healthr s>xT"dI?@  ==>eWc#h78#==> ==>eWc#h78#== > sJ 7A3A0 A+%A0+A03B<B7!B<"B?7B<<B??Cz /api/settingsGET)methodsc \4p\V4\RRR\\ V44/4VP 4# TP 4i;i)rnTr)r.rdrrBrrr]s r- get_settingsr sD 8DT"dJ}T?R0STU  s +AAPUTc \P!RRR7;'g/p\4p\V4VP 4;_uu_4pVP RVP R4VP R4VP R4VP R4VP R434RRR4VP4VP 4;_uu_4pVP R 4RRR4VP4\R RR \\V44/4VP4# +'giL;i +'giLd;i TP4i;i) Tr3a UPDATE GardenSettings SET zip_code = COALESCE(%s, zip_code), lat = COALESCE(%s, lat), lng = COALESCE(%s, lng), notifications_enabled = COALESCE(%s, notifications_enabled), low_seed_threshold = COALESCE(%s, low_seed_threshold) WHERE id = 1 r rrr\rNzPDELETE FROM GardenExternalCache WHERE cache_key IN ('zone_info', 'zone_info:v2')rnr) r r6r.rdrSrTrXr[rrBrr)r8r]r^s r-update_settingsr s    $t 4 : :D 8DT" [[]]c KKHHZ(HHUOHHUOHH45HH12  & [[]]c KKb  dJ}T?R0STU 7](] s<#E%A#D?40E%$E68E%? E E% E" E%%E7z/api/settings/backup/fullc \4p\V4\V4pR\P!4P R4 R2p\ VRRRV R2/R7VP4# \d5p\RR R \T4/4R 3uR p?TP4#R p?ii;i TP4i;i) garden_tracker_backup_z %Y%m%d_%H%M%Sz.sqlzapplication/sqlzContent-Dispositionzattachment; filename="rmimetyperrnFrkrN) r.rdrrrstrftimerrr rrL)r]dump_sqlfilenamers r-settings_backup_fullr s 8D T"*40+HLLN,C,CO,T+UUYZ &*.DXJa,PQ   >eWc#h78#== > s0AA.. B-9B(B-B0(B--B00Cz/api/seed-companiesc\4p\V4\\V44p\ RRRV/4VP 4# TP 4i;i)rnTr)r.rdrFrrr)r]rs r-list_seed_companiesr sJ 8DT"#$7$=> dK;<  s -A Ar=c\P!RRR7;'g/pVPR4;'gRP4pVPR4;'gRP4P R4pV'd V'g\ RRRR /4R 3#VP R 4'g R V,p\4p\V4VP4;_uu_4pTPR TTVPR4VPRR4'd^M^\VPR4;'g^434VPpVPRV34VP4pRRR4VP4\ RRR\X4/4^3VP!4# +'giLJ;i TP!4i;i)Tr3rarIrbrrnFrkzname and base_url requiredrrz INSERT INTO GardenSeedCompany (name, base_url, search_url_template, enabled, sort_order) VALUES (%s, %s, %s, %s, %s) renabled sort_order-SELECT * FROM GardenSeedCompany WHERE id = %sNr)r r6rXrzr?rrr.rdrSrTrV lastrowidrWr[rBr)r8rarbr]r^ company_idrs r-create_seed_companyr s   $t 4 : :D HHV  " " ) ) +D$**113::3?H xeW.JKLcQQ   v & &( 8DT" [[]]c KK HH23)T22A.33!4  J KKG* WllnG#$ dI~g/FGH#M +]* s+#G3AG ;G1G G GG,z$/api/seed-companies/c \P!RRR7;'g/p\4p\V4VP 4;_uu_4pVP RV34VP 4'g,\RRRR/4R3uuRRR4VP4#VPR 4p\V\4'dHVP4PR 4pV'd!VPR 4'g R V,pVP R VPR4VVPR4VPR4VPR4V34VP RV34VP 4pRRR4VP4\RRR\!X4/4VP4# +'giLH;i TP4i;i)Tr3z.SELECT id FROM GardenSeedCompany WHERE id = %srnFrk Not foundNrbrrra~ UPDATE GardenSeedCompany SET name = COALESCE(%s, name), base_url = COALESCE(%s, base_url), search_url_template = COALESCE(%s, search_url_template), enabled = COALESCE(%s, enabled), sort_order = COALESCE(%s, sort_order) WHERE id = %s rarrrrr)r r6r.rdrSrTrWrrrXr4rLrzr?rr[rB)rr8r]r^rbrs& r-update_seed_companyr s   $t 4 : :D 8D#T" [[]]c KKH:- X<<>>eWkBCSH]B ;xx +H(C((#>>+2237H$7$7$?$?)H4H KKHHV$HH23HHY'HH\*  & KKG* WllnG;< dI~g/FGH C]B s=#G:G  G&A G 4G  BG  /G G GG0DELETEc\4p\V4VP4;_uu_4pVPRV34VP^8Xd,\ RRRR/4R3uuRRR4VP 4#RRR4VP4\ RR/4VP 4# +'giL=;i TP 4i;i)z+DELETE FROM GardenSeedCompany WHERE id = %srnFrkrrNTr.rdrSrTrowcountrrr[)rr]r^s& r-delete_seed_companyr@ s 8D T" [[]]c KKE } U||q eWkBCSH] ! d|$ ] (#C5B5$ C$C5 C CCz /api/plantsc\PPR4p\4p\ V4VP 4;_uu_4pV'd VP \R,V34MVP \R,4VP4pRRR4\RRR\X4/4VP4# +'giL8;i TP4i;i)statusz$ WHERE p.status = %s ORDER BY p.namez ORDER BY p.nameNrnTplants) r r7rXr.rdrSrT _PLANT_SELECTrorrr)rr]r^rDs r- list_plantsrR s \\  h 'F 8D T" [[]]c !$JJI  M,>>?<<>DdH.?.EFG ] s$#C%AC"C% C" C%%C7z/api/plants/by-label/c \4p\V4VP4;_uu_4pVP\R,VP 4P 434VP4pV'g,\RRRR/4R3uuRRR4VP4#VR,pVPRV34\W$W2P44pRRR4\RR R \XVR R 7R X/4VP4# +'giL=;i TP4i;i) z WHERE p.label_id = %srnFrkrrNrnTSELECT * FROM GardenPlantEvent WHERE plant_id = %s ORDER BY event_date DESC, id DESCTrrr) r.rdrSrTrrzupperrWrrrror)label_idr]r^rrrs& r-get_plant_by_labelrf s 8DT" [[]]c KK (@@8>>CSCYCYC[B] ^LLNEeWkBCSH ] T{H KKf  $C5,,.IFdG-=e$fj-kmuw}~ ] s/#D+A#D D+-6D#$D+ D( #D++D=z/api/plants/c \4p\V4VP4;_uu_4pVP\R,V34VP 4pV'g,\ RRRR/4R3uuRRR4VP4#VPRV34VP4pVPRV34VP4p\W W44pRRR4\ RR R \XVR R 7R XR \X4/4VP4# +'giLH;i TP4i;i) WHERE p.id = %srnFrkrrNrzBSELECT * FROM GardenSchedule WHERE plant_id = %s ORDER BY next_dueTrrr schedules) r.rdrSrTrrWrrrorrrF)rr]r^rrrs& r- get_plantr{ s 8DT" [[]]c KK (::XK HLLNEeWkBCSH ]2 ) KKf  \\^F KKT   I#C5AF d)%dRVW&_Y7    3]2 s0#D6AD#6 D6AD##/D6# D3 .D66Ec \P!RRR7;'g/pVPR4;'gRP4pV\9d\ RRRR/4R3#VPR 4;'gR pV\ 9d\ RRRR /4R3#\VPR 4;'g^4pT^8gTR8d\ RRRR/4R3#TPR4pTPR4;'gRP4pTPR4;'gRP4;'gRp\TPR44;'g\P!4p\4p\T4TP4;_uu_4p Rp TR8XdT'g,\ RRRR/4R3uuRRR4TP!4#T P#RT34T P%4p T 'g,\ RRRR/4R3uuRRR4TP!4#T'g T R,pTf!T PR4'd T R,pM3T'g,\ RRRR/4R3uuRRR4TP!4#TR8XdRMRp Rp TR8Xd \'T 4p M(TPR4'dTPR4p .p \)Y4pTFpT P#R TTTTPR!4TTTPR"4TPR4TR8XdTMRT3 4T P*pT P-T4T P#R#TYT ^R$34K TR8Xd,TPR%R4'dT P#R&Y434.pT FUpT P#\.R',T34T P%4pT'gK;TP-\1T44KW RRR4TP34\ RRR(\5X4R)T'd T^,MRR*T/4^3TP!4# \\3d\ RRRR /4R3u#i;i +'giL;i TP!4i;i)+Tr3rr%rnFrkzinvalid source_typerractiveinvalid statusquantityzinvalid quantityrz"quantity must be between 1 and 500rrarIrwNrr$z(seed_id required for seed-sourced plants/SELECT * FROM GardenSeedInventory WHERE id = %szSeed not foundrrz%name required for store-bought plantsrrr`a INSERT INTO GardenPlant (label_id, name, variety, location, status, planted_date, moisture_device_id, notes, seed_id, source_type) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s) rmoisture_device_idz INSERT INTO GardenPlantEvent ( plant_id, event_type, event_date, notes, days_since_start, days_since_anchor ) VALUES (%s, %s, %s, %s, %s, %s) rdecrement_seedzHUPDATE GardenSeedInventory SET qty = GREATEST(0, qty - %s) WHERE id = %srrirr)r r6rXrzPLANT_SOURCE_TYPESrPLANT_STATUSESrVrrMrNrrdr.rdrSrrTrWrrlrrrrr[rp)r8rrrrrarwrr]r^r$r event_notes created_ids label_idsrrrr?s r- create_plantr sd   $t 4 : :D88M*<?@#EEHtxx +00q1!|x#~eW.RSTVYYYhhy!G HHV  " " ) ) +Dxx "((b//199TGtxx78HHDJJLL 8DQT" [[]]cDf$"D%:d#efhkk ]^ U MPWzZ||~"D%:J#KLcQ]^ M ,D?txx ':':"9oGeW6]^_add]^ *5)>NJKf$1$7 '"""hhw/ K1#@I%  !,$!56)#.d#  &==""8,  zaT-&@f$2BD)I)I ^' F' M,>> Llln3MM"23"78 (AJ dVf$&     u z "HeW.@ABCGGH]^ s Q;=Q;#R65R#R# R62*R#R#- R6R##R#4R#R# R616R#(C R#4A R#R#$AR6;"R R # R3 .R66ScZ\P!RRR7;'g/p\4p\V4VP 4;_uu_4pVP RV34VP 4'g,\RRRR/4R3uuRRR4VP4#VPR 4pVe7V\9d,\RRRR /4R 3uuRRR4VP4#TP R VPR 4VPR4VPR4TRV9d\VPR44MRVPR4VPR4VPR4VPR4V3 4VP \R,V34VP 4pRRR4VP4\RRR\X4/4VP4# +'giLH;i TP4i;i)Tr3z(SELECT id FROM GardenPlant WHERE id = %srnFrkrrNrrraP UPDATE GardenPlant SET name = COALESCE(%s, name), variety = COALESCE(%s, variety), location = COALESCE(%s, location), status = COALESCE(%s, status), planted_date = COALESCE(%s, planted_date), moisture_device_id = COALESCE(%s, moisture_device_id), notes = COALESCE(%s, notes), seed_id = COALESCE(%s, seed_id), source_type = COALESCE(%s, source_type) WHERE id = %s rarwrrrr`rrrr)r r6r.rdrSrTrWrrrXrrNrr[r)rr8r]r^rrs& r- update_plantr s   $t 4 : :D 8D)T" [[]]c KKBXK P<<>>eWkBCSH]N GXXh'F!fN&BeW6FGH#M ]N A KK HHV$HHY'HHZ(=Kt=SK 89Y]HH12HHW%HHY'HH]+  6 KK (::XK HLLNEGH dG-=e-DEF O]N s<#H:H H&0H H1CH/H H HH*z$/api/plants//duplicatec\4p\V4VP4;_uu_4pVP\R,V34VP 4pV'g,\ RRRR/4R3uuRRR4VP4#\V^4^,pVPR4;'gRpVR 8XdR MR pRpVR 8XdUVPR 4'd>VPR VR ,34VP 4pV'd \V4pVPR4;'g\P!4p \V \4'dV P4p TPRTVR,VPR4VPR4VPR4;'gRT VPR4VPR4VR 8XdVPR 4MRV3 4VPp VPRWW^R34VP\R,V 34VP 4p RRR4VP!4\ RRR\#X 4/4^3VP4# +'giLJ;i TP4i;i)rrnFrkrrNrr%r$rrrrrz INSERT INTO GardenPlant (label_id, name, variety, location, status, planted_date, moisture_device_id, notes, seed_id, source_type) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s) rarwrrrrr`z INSERT INTO GardenPlantEvent ( plant_id, event_type, event_date, notes, days_since_start, days_since_anchor ) VALUES (%s, %s, %s, %s, %s, %s) rTr)r.rdrSrTrrWrrrlrXrrrdr4rrr[r) rr]r^rrrrrr$rnew_id new_plants & r-duplicate_plantr4 sG 8D8T" [[]]c KK (::XK HLLNEeWkBCSH ]l a1a8;H))M2DDnK)4)>NJKf$9)=)= MPUV_P`Obc||~"5d";K 99^4DD L,11+002 KK &MIIi(IIj)IIh'338 II23IIg&,76,AEIIi(t   &]]F KK \:N  KK (::VI F Ief dG-=i-HIJCO m]l sO#J0AJ6 J0*J<-J*1J"J?BJBJ1J0 J- (J00Kc\4p\V4VP4;_uu_4pVPRV34VP^8Xd,\ RRRR/4R3uuRRR4VP 4#RRR4VP4\ RR/4VP 4# +'giL=;i TP 4i;i)z%DELETE FROM GardenPlant WHERE id = %srnFrkrrNTr)rr]r^s& r- delete_plantrr s 8D T" [[]]c KK?( M||q eWkBCSH] ! d|$ ] rz!/api/plants//eventsc\4p\V4VP4;_uu_4pVP\R,V34VP 4pV'g,\ RRRR/4R3uuRRR4VP4#VPRV34VP4p\W W44pRRR4\ RRR X/4VP4# +'giL/;i TP4i;i) rrnFrkPlant not foundrNrTr) r.rdrSrTrrWrrror)rr]r^rrDs& r-list_plant_eventsr s 8DT" [[]]c KK (::XK HLLNEeW6GHI3N ]  KKf  <<>D!#=DdHd34 ] s/#C:AC'6 C:/C'C:' C7 2C::D c\P!RRR7;'g/pVPR4;'gRpV\9d\ RRRR/4R3#\ VPR 44;'g\ P!4p\4p\V4VP4;_uu_4pVP\R ,V34VP4pV'g,\ RRRR /4R 3uuR R R 4VP4#\VPR44p\!VPR44p\#WPWc4wrVPRVVVVPR4VPR4VPR4VVV V 3 4\%WPW'4VP&p VPRV 34VP4p \)WPWl4p R R R 4VP+4\ RRRX /4^3VP4# +'giLA;i TP4i;i)Tr3rnoternFrkinvalid event_typerrrrrNrheighta$ INSERT INTO GardenPlantEvent ( plant_id, event_type, event_date, notes, qty, unit, location, height, days_since_start, days_since_anchor ) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s) r`rr_,SELECT * FROM GardenPlantEvent WHERE id = %sr)r r6rX EVENT_TYPESrrNrrdr.rdrSrTrrWrrrrrrrr[) rr8rrr]r^rrr days_sincerevent_idrs & r-create_plant_eventr s   $t 4 : :D,'116J$eW.BCDcIITXXl34DD J 8D'T" [[]]c KK (::XK HLLNEeW6GHI3N ]J A+488J+?@H$TXXh%78F!:3%!\ J KKHHW%HHUOHHV$  * &cZ J}}H KKF TLLNE!#>ECD dGU34c9 K]J s2#H??AH, H?!CH,3(H?, H< 7H??Iz0/api/plants//events/c\P!RRR7;'g/p\4p\V4VP 4;_uu_4pVP \ R,V34VP4pV'g,\RRRR/4R3uuRRR4VP4#VP R W34VP4pV'g,\RRRR /4R3uuRRR4VP4#VPR VR ,4pV\9d,\RRRR /4R 3uuRRR4VP4#RV9dO\VPR44pV'g,\RRRR/4R 3uuRRR4VP4#M\VPR44pRV9d VR,MVPR4p RV9d VR,MVPR4p RV9d VR,MVPR4p RV9dVVPR4eC\^\VR,44p T;'g/PR4R8XdRMRp M\%W@WX4wr\'RV9d VR,MVPR44pRV9d\)VPR44pMVPR4pVP RVVV V V VVV V VV3 4\+W@W~4VP RV34VP4p\-W@WV4pRRR4VP/4\RRRX/4VP4# \ \"3d/\RRRR/4R 3uuuRRR4TP4#i;i +'giL;i TP4i;i)Tr3rrnFrkrrNz>SELECT * FROM GardenPlantEvent WHERE id = %s AND plant_id = %srrrrrzinvalid event_dater`rr_rzinvalid days_since_startrr$rrrra UPDATE GardenPlantEvent SET event_type = %s, event_date = %s, notes = %s, qty = %s, unit = %s, location = %s, height = %s, days_since_start = %s, days_since_anchor = %s WHERE id = %s AND plant_id = %s rr)r r6r.rdrSrTrrWrrrXrrNrrrVrrMrrrrrr[)rrr8r]r^rrrrr`rr_rrrrs&& r-update_plant_eventr s   $t 4 : :D 8DNT" [[]]c KK (::XK HLLNEeW6GHI3N ]X O KKP$ LLNEeWkBCSH]X ,l0CDJ,eW6JKLcQ]X yt#(,)?@ !"D%:N#OPRUU']X u"&eii &=> %,_DM%))G:LE!&$$u+EIIe4DC#)T>4se%`" *$.$$6Z EIIjEQR dGU34 _":.\"D%:T#UVX[[[=]X _\;]X s#OAO O3;O. O 4O= O9O O,BON!O*CO &O"N?"O# O>N??O O OO'c\4p\V4VP4;_uu_4pVPRW34VP^8Xd,\ RRRR/4R3uuRRR4VP 4#RRR4VP4\ RR/4VP 4# +'giL=;i TP 4i;i)zc4V'dRVPR49d\RRRR/4R3#\4p\PP W4p\PP V4'g\RRRR/4R3#\W4#) rrrnFrkz invalid pathrz not foundr)rrrrrrrr )relrrs& r-serve_seed_type_uploadr2 s~ $#))C.(eWn=>CC#%K 77<< )D 77>>$  eWk:;S@@ { 00r,z/api/seed-imagec \PPR4;'gRP4pV'g\ RRRR/4R3#\ V4p\ PPV4pVP;'gRP4p\4p\V4\V4pVP4\W54'g\ RRRR/4R3#VP R8wd\ RRRR /4R3#R pV\"9dR V R 2p\ PP%VR RRV/R7p\ PP'V^R7;_uu_4pVP)4p VP*PRR4p RRR4\-X X RR/R7# TP4i;i +'giL5;i \ P.P0\ P.P2\43d%p \ RRR\7T 4/4R3uRp ? #Rp ? ii;i)rrIrnFrkz url requiredrzhost not allowedrz invalid urlzhttps://en.wikipedia.org/rrrzMozilla/5.0 GardenTracker/1.0r<rrr9z image/jpegNz Cache-Controlzpublic, max-age=86400r)r r7rXrzrrrrrrrr.rdrrrrrrrrrrrkrlrmrnrL) raw_urlrrrr]rrefererrrr8 content_typers r-seed_image_proxyr= s||&,,"335G eWn=>CC w 'C \\ " "3 'F OO ! !r ( ( *D 8DT",T2  t 3 3eW.@ABCGG }}eWm<=sBB)G ((TF!$>nn$$ =7% ^^ # #C # 4 499;D<<++NLIL5 !$&=>  ' 5 4 LL ! !6<<#9#97 C>eWc#h78#==>sC*F;(AG#6-G#G#;G  G G##>I!I:IIz /api/seedscx\4p\V4VP4;_uu_4pVPR4VP 4pRRR4\ V4;'g/p\ VPR4;'g^4p.pXF[p\V4pVPR4;'gTp\VR,4\V48*VR&VPV4K] \RRRV/4VP4# +'giL;i TP4i;i) z=SELECT * FROM GardenSeedInventory ORDER BY crop_name, varietyNrrrrrnTseeds) r.rdrSrTrorrVrXrBr6rrr) r]r^rDrrrr?rrs r- list_seedsrf s 8DT" [[]]c KKW X<<>D!&,," %9:??a@ C!#&DGG12??iE %c%j 1U5\ AD  JJt   dGS12 ] s5#D'"DD'+D' 0D'D/0 y((9*=>dFN4,@ABCG 9]8 s&0#G2C0GA G2 G/ *G22Hz/api/seeds/c \4p\V4VP4;_uu_4pVPRV34VP 4pRRR4X'g"\ RRRR/4R3VP 4#\W4p\WR,VPR44p\VR,VPR44pRpV'g9\V4pV'g%\VR,VPR44R pMVPR 4'g{.'gs\W4'gbV\9dL\PV4\V4'g%\VR,VPR44R pM \V4p\ RR R VR VR V/4VP 4# +'giEL;i TP 4i;i)rNrnFrkrrrrwTr~r$rtype_info_loading)r.rdrSrTrWrrrrrXrTrrrI_seed_type_image_retry_doner )rr]r^r?r$rrrs& r-get_seedr s 8D"T" [[]]c KKIG: V,,.CD%+>?D8 7*$4'+.> @RS ([)93779;MN ! 7 BB.s;/?AST,0)(DY(O%dY#%6    A]]@ s<#G$G G#GB'G,G4BG G  GG/z$/api/seeds//product-urlc$\P!RR7;'g/pVPR4;'gRP4pV'g\ RRRR/4R3#VP R 4'g!VP R 4'g R V,pVP R 4^,PR 4p\4p\V4VP4;_uu_4pVPR V34VP4pRRR4X'g"\ RRRR/4R3VP4#\WC4'g"\ RRRR/4R3VP4#\V4pV'g \ RRRR/4VP4#VR,pVPR4p \!VVV VPR4VPR4R7p V \"8p RVPR4RVPR4RTR\%WC4R\'VPR4;'g.4/p \)WHV 4p \+V 4p\-VPR44p\-VPR44pV'glV 'g?\ RRRRV 2V 'dRV 2MR,R V R!V R"VR#R/4VP4#\ RRR$RR V R!V R"V/4VP4#V 'g*V'g"\ RRRR%/4R3VP4#\/WHW4p\ RRR&V/4VP4# +'giEL^;i TP4i;i)'T)r5rrIrnFrkzProduct URL is requiredrrrrrrNrrz>) $ $S^^J-G-G3 #q!((-I 8DHT" [[]]c KKIG: V,,.CD%+>?DD C't77eW@ w/y9 eEr i $ '')$+   --(MM),  !<< Y]]7+ y}}Y/ ) /@ 3y}}X6<<"=  't@28< TXXg&'TXXg&'%=$+'?FE'*;BP";w"L  8 #d4{7 " ue3 -TgQ dK;< M]]L sa #M=0$M)M=$M=!M=7!M=)DM=*-M=(M= M=M=M=>M=) M: 4 M==Nz*/api/seeds//refresh-type-infoc\4p\V4VP4;_uu_4pVPRV34VP 4pRRR4X'g"\ RRRR/4R3VP 4#\VR,VPR44p\W4pVP4;_uu_4pVPR V34RRR4VP4\PV4\VR,VPR4VR 7\ RR R R /4VP 4# +'giEL;i +'giL;i TP 4i;i) rNrnFrkrrrrwz3DELETE FROM GardenSeedTypeInfo WHERE cache_key = %srTr)r.rdrSrTrWrrrTrXrr[rrr)rr]r^r?rrs& r-refresh_seed_type_infor! s& 8DT" [[]]c KKIG: V,,.CD%+>?D )[)93779;MN 1$B [[]]c KKMPY| \ #++I6   GGI - d$7>? %]]] sH#E4$E E4#E4AE4 E!AE4 E  E4! E1 ,E44Fz$/api/seeds//type-imagesc \PPR4pV'g\RRRR/4R3#\ 4p\ V4VP 4;_uu_4pVPRV34VP4pRRR4X'g"\RRRR/4R 3VP4#\VR ,VPR 44p\W%4p\V4\8d*\RRRR \ R 2/4R3VP4#\VP;'gR4;'gRp\ P"P%V4^,P'4pVR9dRp\ P(!^4P+4 V 2p \-V4 RV 2p \ P"P/\14V 4p \ P2!\ P"P5V 4RR7VP7V 4VP9RRV 2RV RVRR/4\;W%VR ,VPR 4VRR7\=W$R ,VPR 44p \RRRV /4^3VP4# +'giEL5;i TP4i;i)rrnFrkzNo file uploadedrrNrrrrwzMaximum z imagesz image.jpgrrT)exist_okrr?r&r r uploadedrr)rrrrz.gif)r filesrXrr.rdrSrTrWrrTrrprMr rrrsplitextrurandomhexr!rrmakedirsrsaverrr) rrr]r^r?rr~ safe_namerrrrrs & r-upload_seed_type_imager ; sd MM  g &E eW.@ABCGG 8D#T" [[]]c KKIG: V,,.CD%+>?D: 7)[)93779;MN '8 v;. .D%H=Q @RS dK; K EK 7 K  K Kc \4p\4pVR8XdVf\RRRR/4R3#\4p\ V4VP 4;_uu_4pVP RV34VP4pRRR4X'g"\RRRR/4R 3VP4#\VR ,VPR 44p\W64pRp\V4p VeKV^8gV\V48d"\RRRR /4R 3VP4#V PV4pM5.p VF-p \W4'd VfT pKV P!V 4K/ V'g"\RRRR /4R 3VP4#VPR 4'd\#VR ,4\%W6VR ,VPR 4V RR7\'W5R ,VPR 44p \RRRV /4VP4# +'giEL;i TP4i;i)rINrnFrkurl or index requiredrrrrrrwImage not foundr&Trr)r9r=rr.rdrSrTrWrrTrXrrrprrCrrrr) rrr;r]r^r?rr~removedkeptrrs & r-delete_seed_type_imagerg s  C " $E byU]eW.EFGLL 8D"T" [[]]c KKIG: V,,.CD%+>?D8 5)[)93779;MN '8F|  qyES[0eW6GHI3N( 'hhuoGD)#33!G C  D%2CDEsJ  ;;{ # # $W[%9 : S-swwy/A4VZ (+.> @RS dK;< A]]@ sJ#H>$H*H>H>4A%H>*AH>9H>H>1A(H>* H; 5 H>>Iz,/api/seeds//type-images/primaryPATCHc  a \4o \4pS R8XdVf\RRRR/4R3#\4p\ V4VP 4;_uu_4pVP RV34VP4pRRR4X'g"\RRRR/4R 3VP4#\VR ,VPR 44p\W%4pVe<V^8gV\V48d"\RRRR /4R 3VP4#TpMD\V 3R l\V44R4pVf"\RRRR /4R 3VP4#V^8Xdh\W%VR ,VPR 4VRR7\!W$R ,VPR 44p\RRRV/4VP4#VP#V4p VP%^V 4\W%VR ,VPR 4VRR7\!W$R ,VPR 44p\RRRV/4VP4# +'giEL;i TP4i;i)rINrnFrkr rrrrrrwr c3T<"TFwr\VS4'gKVxK R#5ir=)rC)rrkrrs& r-r/make_seed_type_image_primary.. s"W!2vq6LSRU6V!2s( (Trr)r9r=rr.rdrSrTrWrrTrXrrpnextrYrrrinsert) rr;r]r^r?rr~r`rchosenrs & @r-make_seed_type_image_primaryr s:  C " $E byU]eW.EFGLL 8D$T" [[]]c KKIG: V,,.CD%+>?D< 9)[)93779;MN '8  qyES[0eW6GHI3N0 /CW6!2WC{eW6GHI3N  !8 "[!137793Ev\` ,Dk2BCGGIDVWID$ Y?@ C a  S-swwy/A6X\ (+.> @RS dK;< E]]D sD#I1 $II1I15AI16I1%AI1A9I1 I. ( I11Jc\P!RRR7;'g/p\4p\V4VP 4;_uu_4pVP RV34VP 4'g,\RRRR/4R3uuRRR4VP4#TP R VPR 4VPR 4VPR 4VPR 4VPR4RV9d\VPR44MRRV9d\VPR44MRVPR4VPR4VPR4V3 4VP RV34VP 4pRRR4VP4\RRR\X4/4VP4# +'giLH;i TP4i;i)Tr3z0SELECT id FROM GardenSeedInventory WHERE id = %srnFrkrrNa UPDATE GardenSeedInventory SET crop_name = COALESCE(%s, crop_name), variety = COALESCE(%s, variety), qty = COALESCE(%s, qty), unit = COALESCE(%s, unit), source = COALESCE(%s, source), purchase_date = COALESCE(%s, purchase_date), expiry_date = COALESCE(%s, expiry_date), location = COALESCE(%s, location), low_stock_threshold = COALESCE(%s, low_stock_threshold), notes = COALESCE(%s, notes) WHERE id = %s rrwrr_r rrrrr`rr$) r r6r.rdrSrTrWrrrXrNr[rB)rr8r]r^r$s& r- update_seedr s   $t 4 : :D 8D(T" [[]]c KKJWJ W<<>>eWkBCSH]L E KK HH[)HHY'HHUOHHV$HHX&>MQU>UK 9:[_DEF dFN4,@AB M]L s0#G3:G  G3&C:G  /G3 G0 +G33Hc\4p\V4VP4;_uu_4pVPRV34VP^8Xd,\ RRRR/4R3uuRRR4VP 4#RRR4VP4\ RR/4VP 4# +'giL=;i TP 4i;i)z-DELETE FROM GardenSeedInventory WHERE id = %srnFrkrrNTr)rr]r^s& r- delete_seedr s 8D T" [[]]c KKG' T||q eWkBCSH] ! d|$ ] rz#/api/seeds//adjust-qtyc 0\P!RRR7;'g/pVPR4pVf\RRRR/4R3#\ 4p\ V4VP 4;_uu_4pVPR V34VP4pV'g,\RRRR /4R 3uuRRR4VP4#\^\VR ,4\V4,4pVPR W`34VPR V34VP4pRRR4VP4\RRR\X4/4VP4# +'giLH;i TP4i;i)Tr3deltaNrnFrkzdelta requiredrrrrrz5UPDATE GardenSeedInventory SET qty = %s WHERE id = %sr$)r r6rXrr.rdrSrTrWrrr6r[rB)rr8rr]r^r$new_qtys& r-adjust_seed_qtyr  sG   $t 4 : :D HHW E }eW.>?@#EE 8DT" [[]]c KKIG: V<<>DeWkBCSH ] !U4;/%,>?G KKG"  KKIG: V<<>D dFN4,@AB ] s1#F7D)+/D(,0D) 4 ' 2dGS12 7]6 s0#E/B'EE&AE5E/ E, 'E//Fc\P!RRR7;'g/pVPR4;'gRP4pV'g\ RRRR/4R3#\ 4p\ V4VP4;_uu_4pVPR VVPR 4VPR 4VPR 4VPR 4VPR4VPR4VPR^4VPR43 4VPpVPRV34VP4pRRR4VP4\ RRR\X4/4^3VP4# +'giLJ;i TP4i;i)Tr3rarIrnFrkz name requiredra INSERT INTO GardenTank (name, volume_gal, solution_type, target_ph_min, target_ph_max, target_ec_min, target_ec_max, test_interval_days, notes) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s) volume_gal solution_type target_ph_min target_ph_max target_ec_min target_ec_maxrar`&SELECT * FROM GardenTank WHERE id = %sNrq)r r6rXrzrr.rdrSrTrrWr[rBr)r8rar]r^tank_idrqs r- create_tankr1@se   $t 4 : :D HHV  " " ) ) +D eWo>?DD 8DT" [[]]c KKHH\*HH_-HH_-HH_-HH_-HH_-HH115HHW%  &mmG KK@7* M<<>D-. dFN4,@ABCG 5]4 s%0#F,CF1F, F) $F,,F>z/api/tanks/c\P!RRR7;'g/p\4p\V4VP 4;_uu_4pVP RV34VP 4'g,\RRRR/4R3uuRRR4VP4#VP R VPR 4VPR 4VPR 4VPR 4VPR4VPR4VPR4VPR4VPR4V3 4VP RV34VP 4pRRR4VP4\RRR\X4/4VP4# +'giLH;i TP4i;i)Tr3'SELECT id FROM GardenTank WHERE id = %srnFrkrrNa UPDATE GardenTank SET name = COALESCE(%s, name), volume_gal = COALESCE(%s, volume_gal), solution_type = COALESCE(%s, solution_type), target_ph_min = COALESCE(%s, target_ph_min), target_ph_max = COALESCE(%s, target_ph_max), target_ec_min = COALESCE(%s, target_ec_min), target_ec_max = COALESCE(%s, target_ec_max), test_interval_days = COALESCE(%s, test_interval_days), notes = COALESCE(%s, notes) WHERE id = %s rar)r*r+r,r-r.rar`r/rq) r r6r.rdrSrTrWrrrXr[rB)r0r8r]r^rqs& r- update_tankr4fsr   $t 4 : :D 8D&T" [[]]c KKAG: N<<>>eWkBCSH]H A KK HHV$HH\*HH_-HH_-HH_-HH_-HH_-HH12HHW%  6 KK@7* M<<>DAB dFN4,@AB I]H s0#F?:F, F?&CF,,/F?, F< 7F??Gc\4p\V4VP4;_uu_4pVPRV34VP^8Xd,\ RRRR/4R3uuRRR4VP 4#RRR4VP4\ RR/4VP 4# +'giL=;i TP 4i;i)z$DELETE FROM GardenTank WHERE id = %srnFrkrrNTr)r0r]r^s& r- delete_tankr6s 8D T" [[]]c KK> K||q eWkBCSH] ! d|$ ] rz!/api/tanks//readingscV\4p\V4VP4;_uu_4pVPRV34VP 4pRRR4\ RRR\ X4/4VP4# +'giL8;i TP4i;i)z SELECT * FROM GardenTankReading WHERE tank_id = %s ORDER BY recorded_at DESC LIMIT 100 NrnTreadingsr.rdrSrTrorrFr)r0r]r^rDs& r-list_tank_readingsr:s 8D T" [[]]c KK  <<>DdJ0EFG ] s"#B$BB B BB(c \P!RRR7;'g/p\4p\V4VP 4;_uu_4pVP RV34VP 4'g,\RRRR/4R3uuRRR4VP4#\VPR 44;'g\P!4pVP R VVPR 4VPR 4VPR 4VPR4VPR4V34VPpVP RV34VP 4pRRR4VP4\RRR\X4/4^3VP4# +'giLJ;i TP4i;i)Tr3r3rnFrkzTank not foundrNrbz INSERT INTO GardenTankReading (tank_id, ph, ec, temp_f, volume_gal, notes, recorded_at) VALUES (%s, %s, %s, %s, %s, %s, %s) phecrDr)r`z-SELECT * FROM GardenTankReading WHERE id = %sreading)r r6r.rdrSrTrWrrrPrXrrrr[rB)r0r8r]r^rb reading_idr>s& r-create_tank_readingr@sm   $t 4 : :D 8DT" [[]]c KKAG: N<<>>eW6FGH#M]6 /*$((=*ABWWhooFWK KK HHTNHHTNHHX&HH\*HHW%   J KKG* WllnG/0 dI~g/FGH#M 7]6 s6#G:F2 G& F2B)F201G2 G =GGz/api/schedulescR\4p\V4VP4;_uu_4pVPR4VP 4pRRR4\ RRR\ X4/4VP4# +'giL8;i TP4i;i)a SELECT s.*, p.name AS plant_name, t.name AS tank_name FROM GardenSchedule s LEFT JOIN GardenPlant p ON p.id = s.plant_id LEFT JOIN GardenTank t ON t.id = s.tank_id ORDER BY s.next_due NrnTrr9)r]r^rDs r-list_schedulesrBs{ 8DT" [[]]c KK <<>DdK1FGH ] s"#B"BB B BB&cJ\P!RRR7;'g/pVPR4;'gRpV\9d\ RRRR/4R3#VPR 4;'g!VP R R 4P 4P4p\VPR 4;'g^4p\VPR 44;'g\P!4p\4p\V4VP4;_uu_4pTPRVPR4VPR4TTTTVPRR4'd^M^VPR434VP pVPRV34VP#4pRRR4VP%4\ RRR\'X4/4^3VP)4# +'giLJ;i TP)4i;i)Tr3rTcustomrnFrkinvalid task_typerr rrgrNnext_duez INSERT INTO GardenSchedule (plant_id, tank_id, task_type, title, interval_days, next_due, enabled, notes) VALUES (%s, %s, %s, %s, %s, %s, %s, %s) rr0rr`*SELECT * FROM GardenSchedule WHERE id = %sNrP)r r6rX TASK_TYPESrr1r rzrVrPrrr.rdrSrTrrWr[rBr) r8rTr rNrFr]r^ schedule_idrPs r-create_schedulerJs   $t 4 : :D%11I "eW.ABCSHH XXg  E E)"3"3C"="C"C"E L L NE177R8Mtxx 34II8IH 8DT" [[]]c KK HHZ(HHY'!)T22AHHW%   "--K KKD{n U||~H)* dJx0HIJCO 1]0 s%#H*BG=;1H= H HH"z /api/schedules/cH\P!RRR7;'g/p\4p\V4VP 4;_uu_4pVP RV34VP 4'g,\RRRR/4R3uuRRR4VP4#VPR 4pVe7V\9d,\RRRR /4R 3uuRRR4VP4#VPR 4pTP R VPR4VPR4TVPR4VPR4RV9d\VPR44MRVRJd^M VRJd^MRVPR4V3 4VP RV34VP 4pRRR4VP4\RRR\X4/4VP4# +'giLH;i TP4i;i)Tr3rGrnFrkrrNrTrErra  UPDATE GardenSchedule SET plant_id = COALESCE(%s, plant_id), tank_id = COALESCE(%s, tank_id), task_type = COALESCE(%s, task_type), title = COALESCE(%s, title), interval_days = COALESCE(%s, interval_days), next_due = COALESCE(%s, next_due), enabled = COALESCE(%s, enabled), notes = COALESCE(%s, notes) WHERE id = %s rr0r rNrFr`rP)r r6r.rdrSrTrWrrrXrHrPr[rB)rIr8r]r^rTrrPs& r-update_schedulerLs   $t 4 : :D 8D(T" [[]]c KKD{n U<<>>eWkBCSH]L E-I$*)DeW6IJKSP ]L ?hhy)G KK HHZ(HHY'HHW%HH_-=G4=OODHHZ$89UY DAGu4Dq$HHW%  2 KKD{n U||~HEF dJx0HIJ M]L s<#H:G< H&0G< H1C G</completec \P!RRR7;'g/p\4p\V4VP 4;_uu_4pVP RV34VP 4pV'g,\RRRR/4R3uuRRR4VP4#\P!4pVP R WVPR 434\V4pVP R W`34VPR 4'dnVPR 4R8XdXTP RVR ,\P!4VPR 4;'gVPR434VP RV34VP 4pRRR4VP4\RRR\!X4/4VP4# +'giLH;i TP4i;i)Tr3rGrnFrkrrNz INSERT INTO GardenTaskCompletion (schedule_id, completed_at, notes) VALUES (%s, %s, %s) r`z5UPDATE GardenSchedule SET next_due = %s WHERE id = %srrT fertilizez INSERT INTO GardenPlantEvent (plant_id, event_type, event_date, notes) VALUES (%s, 'fertilized', %s, %s) r rP)r r6r.rdrSrTrWrrrrrXrRrrdr[rB)rIr8r]r^rPrrFs& r-complete_schedulerQVs   $t 4 : :D 8D%T" [[]]c KKD{n U||~HeWkBCSH ]F =//#C KK488G#45  2(;H KKG' ||J''HLL,E,T  !, )BBX\\'-B  KKD{n U||~H?@ dJx0HIJ G]F s6#G8DDF z !$ED!ABWAXXZ[eZffhi H 7$J<0 D, $D)>z RF 0 ! B"=j\zl[D 4D!,dV%:E:N     %%v||'='=t?S?SU\] BD%#c(;(G)G>GGGz/api/crops/searchc \PPR4;'gRP4pV'g\ RRR./4#\ 4p\ V4RVP4 2p\W4pV'd \ RRRV/4VP4#\R\PPV4 24p\+T\,4'dTPR4;'gTM.p\/YT^4\ RRRT/4TP4# \PP\PP \"P$\&3d5p\ RRR\)T4/4R 3uR p?TP4#R p?ii;i TP4i;i) rzrIrnTrjz crop_search:riFrkrN)r r7rXrzrr.rdrrrrrrr$rkrlrmrr-rnrLr4rr)rzr]rror8rrjs r- search_cropsrbsp   #  $ $"++-A dIr233 8DT""1779+. D, D$ 6:;  B"9&,,:L:LQ:O9PQD 2c\pVPR4'd\RR/4R3#V'dN\PP \PP W44'd \W4#\PP VR4p\PP V4'd \VR4#\RRRRRV/4R 3#) zapi/rkrrz index.htmlz!Garden Tracker frontend not builtr^z>Build the React client and place output in GARDEN_CLIENT_DIST.disti)rrrrrexistsrr )rdist_dir index_paths& r-spark0s"H v-.33 rww||H;<<"822h 5J ww~~j!!"8\::  8 W H      r,>prunewaterrDrP test_tank harvest_check>diedrarchived harvested> rprrDprunedseededwateredrr fertilized germinatedr true_leavesr)r)NF))rfavicon mobilemenu mobilecart empty_cartz green-lushheaderfooter newsletterz search-iconz group.pngz ngb-footer fontawesome brands_sec solid_sec regular_sec))zJohnny's Selected Seedszhttps://www.johnnyseeds.com/r)zTotally Tomatoeszhttps://www.totallytomato.com/z{base_url}/search?q={query}>rorprngmomixr<blendmixedcommonhybridgenericrYregulartreatedrrwheirloomimprovedpelletedstandard untreated traditionalnon gmonon-gmoopen pollinatedopen-pollinated)erucarocketroquette)maizezzea mayszea) auberginezsolanum melongena) coriander coriandrum)z green onionzallium fistulosum) courgette cucurbita)rr=)))Nr)Frx)__doc__rrrloggingrrrre urllib.errorr urllib.parseurllib.requestrrrdecimalrr)flaskrrrr r werkzeug.utilsr blueprints.alertsr r configrrrrrrrrrrrrrrr getLogger__name__rbpcursors DictCursorr+rHrrrr~Lockr}rLrrrrrMrrr.r;rBrFrNrPrdrlr\rr|rrrrrrrrrrrrrrrrrt frozensetrrr0rZrrrrrrr!r'r*r/r1r9r=rCrIrPrTrerrrvr|rrrrrrrrrrrrrrrrrrrrrrrr#r,r1rGrSrOrbrr[rzrrrNrMrrrBrPrrrrFrrrrrrrrrrrrrr!r-r@rLrRrZrvr{rbefore_app_requestrrouterrrrrrrrrrrrrrrrrrrrrrrrrrr rrrrr r'r1r4r6r:r@rBrJrLrNrQrYr[r`rbrdrkr(r,r-rs L   ..LL*O$   8 $) J J J7??--   U <n-  !!E!(!e 4( 6 -g$T ?  "!)  1g>"F )X0 " + !#9;R"ST"$8#9:" "#. (2+4*  ""5  \ Z*1F  R 8&R :  @&  $I& i( ;=@59@P4D!   "J   &F6&2 &"% P1""T = 1:&6.4m`4H   ?A* Iqh"J,* 19hM`6 $N,  B.8 Qh"(-  /E7+,/E7+ , F %w78" %12 &2 3 F 05'B&C&R 08*E F "-%)*& +eW=>( &89@-&*d+dN &8,9,^ 06(C:D:z & ; <  -w?@( -x@.A.b %>P,()(,)$*$N $ug6$7$N 06(CRDRj 6IJ2 06(C(D(V 08*E(F(V 87FBST*U*Z $ug6+7+\ $xj9 :  /'CD:,()D,)"*"J $ug6)7)X $xj9 :  -w?@$ -x@ A L UG,-( VH-#.#L ,ug>+?+\ ,xjA B  5xH(I(\ ??J  ++\ 0   ! $# %. & r,