njϺ2SSKrSSKrSSKrSSKrSSKrSSKrSSKJrJr Sr Sr Sr Sr "SS \5r"S S \5rSS jrS r\R(4Sjr\S:Xa#\R."\"\R(55 gg!\ a Sr Nqf=f)N)gdalogrTFc&URSS5$)N'''replace)literals ]/var/www/html/pdf-tiff/venv/lib/python3.13/site-packages/osgeo_utils/samples/validate_gpkg.py _esc_literalr 1s ??3 %%c2SURSS5-S-$)N"z""r) identifiers r _esc_idr5s ##C. . 44r clUS;=(d) URS5=(d URS5$)N) BOOLEANTINYINTSMALLINT MEDIUMINTINTINTEGERFLOATDOUBLEREALTEXTBLOBDATEDATETIMETEXT(BLOB() startswith)typs r _is_valid_data_typer$9s:    # >>' "! #" >>' "%r c\rSrSrSrg)GPKGCheckExceptionPN)__name__ __module__ __qualname____firstlineno____static_attributes__r(r r r&r&Psr r&c\rSrSrSrSrSSjrSrSrSr Sr S r S r S r S rS rSrSrSrSrSrSrSrSrSrSrSrSrg) GPKGCheckerT)GEOMETRYPOINT LINESTRINGPOLYGON MULTIPOINTMULTILINESTRING MULTIPOLYGONGEOMETRYCOLLECTION)CIRCULARSTRING COMPOUNDCURVE CURVEPOLYGON MULTICURVE MULTISURFACECURVESURFACEcXlSUlSUlSUlX lX0lX@lXPlX`l/Ul /Ul gNF) filenameconnhas_tried_spatialiteextended_pragma_infoabort_at_first_error extra_checkslog_msg warning_msgwarning_as_errorerrorswarnings)selfrBrFrGrHrIrJs r __init__GPKGChecker.__init__jsK!  $)!$)!$8!( & 0  r c>UR(a [U5 gg)N)rHprintrMmsgs r _logGPKGChecker._logs << #J r cU(dVU=RX#4/- slUR(a.U(a[S[U5<SU<35e[U5eU$)NReq : )rKrFr&str)rMcondreqrSs r _assertGPKGChecker._assertsG KKSJ< 'K((,SXs-KLL,S11 r cUR(aURSSU5 gU=RU/- slUR(a [ U5 ggrA)rJr\rLrIrQrRs r _warnGPKGChecker._warns@  LLc * MMcU "Mc  r cUR[U5[U5:HUSU[U5[U54-5 UGHunnnnn n Sn UHup\pnnX:waMSU;a U (aSnU S:Xa U(aSnUR(dU S:aSn URX;USU <SU<S[U5<SU <35 URX:HUS U <SU<SU<SU<35 URX:HUS U <SU<SU <SU<35 URUU :HUS U <SU<SU <SU<35 S n O URXS U<SU<S35 GM g)Nz0Table %s has %d columns, whereas %d are expectedFrzWrong type for  of z . Expected z, got zWrong notnull for zWrong default for z Wrong pk for TColumn z not found!)r\lenrErY)rMcolumnsexpected_columnsr[ table_name_ expected_name expected_typeexpected_notnullexpected_default expected_pkfoundnamer#notnulldefaultpks r _check_structureGPKGChecker._check_structures{ LC 01 1  >3w<-=)>? @      E8?4#( -+'($)#G00[1_"#K (Z]);SB  /Z)97D  /Z)97D  +%Zb: I9@L LLsM:V Qr c URS5 URS5 URUR5SLSS5(dgURS5 UR 5nSnSnUHupV nUS:XaSnUS :XdMSnM URS 5 SnUR5b!URS 5 UR5nU(aSUupURUS :HS SU S35 URUS SU S35 U(aURU S:HS S5 O0URU(+S S5 URU(+S S5 U(aY/SQn U(aU S/- n UV V s/sHoV s/sHoPM sn PM nn n UHn U SS;dMU SS:XdMSU S'M O/SQn UR X*SS5 U(aURS5 OURS5 UR 5n UR[ U 5S:HS S!5 [ U 5S:wagURU S"SS#:HS S$U S"S-5 URU S"S%S&:HS S'U S"S%-5 URU S"SS(:HS S)U S"S-5 U(a(URU S"SS(:HS*S+S,U S"S--5 URU SSS#:HS S-U SS-5 URU SS%S":HS S.U SS%-5 URU SSS(:HS S/U SS-5 U(a(URU SSS(:HS*S+S0U SS--5 URU S%SR5S1:HS S2U S%S-5 URU S%S%S3:HS S4U S%S%-5 URU S%SS(:gS S5U S%S-5 U(a(URU S%SS(:gS*S+S6U S%S--5 U(aFURS75 UR 5nUHunURSS8S9U-S:-5 M ggs sn fs sn n f);NzChecking gpkg_spatial_ref_sysz?SELECT 1 FROM sqlite_master WHERE name = 'gpkg_spatial_ref_sys' z"gpkg_spatial_ref_sys table missingz'PRAGMA table_info(gpkg_spatial_ref_sys)Fdefinition_12_063Tepoch:SELECT 1 FROM sqlite_master WHERE name = 'gpkg_extensions'znSELECT scope, extension_name FROM gpkg_extensions WHERE extension_name IN ('gpkg_crs_wkt', 'gpkg_crs_wkt_1_1') read-writez scope of z extension should be read-writez@gpkg_spatial_ref_sys should have a definition_12_063 column, as z extension is declaredgpkg_crs_wkt_1_1zdgpkg_extensions should declare gpkg_crs_wkt_1_1 extension as gpkg_spatial_ref_sys has a epoch columnzlgpkg_extensions should declare gpkg_crs_wkt extension as gpkg_spatial_ref_sys has a definition_12_063 column)rsrs_namerrbNrrbsrs_idrrbNrb organizationrrbNrorganization_coordsys_idrrbNr definitionrrbNr descriptionrrNr)rxrrbNr)ryrrNrrb)rrxrr)r~rrrrrgpkg_spatial_ref_syszSELECT srs_id, organization, organization_coordsys_id, definition, definition_12_063 FROM gpkg_spatial_ref_sys WHERE srs_id IN (-1, 0, 4326) ORDER BY srs_idzSELECT srs_id, organization, organization_coordsys_id, definition FROM gpkg_spatial_ref_sys WHERE srs_id IN (-1, 0, 4326) ORDER BY srs_idr z:There should be at least 3 records in gpkg_spatial_ref_sysrNONEz0wrong value for organization for srs_id = -1: %srzwrong value for organization_coordsys_id for srs_id = 4326: %sz0wrong value for definition for srs_id = 4326: %szsrs_id = 4326: %szSELECT srs_id FROM gpkg_spatial_ref_sys WHERE srs_id NOT IN (0, -1) AND definition = 'undefined' AND definition_12_063 = 'undefined'uz$srs_id = %d has both definition and zdefinition_12_063 undefined)rTexecuter\fetchonefetchallrtrelower)rMcrfhas_definition_12_063 has_epochrirprowscopeextension_namergcolumnvretrowsrs r _check_gpkg_spatial_ref_sys'GPKGChecker._check_gpkg_spatial_ref_syss[ 12 VW|| JJL $b*N    ;<**, % %, !QaAq**(,%w &- NO ::< # III **,C $' !E LL%N++JK  LL%$%%;=   "&88A LL))I  LL =  !   %G$HH :AAv6*6a6*GA!1I!DDq T) $F1I "   g=ST II@  II@  jjl HM  K s8q=  F1I   >Q J F1IO   #Aq  * F1I $  Q J ! LLAq [(8%Aq 12  ! II2  :: Q< Q7 Q<7Q<c zURS5 URS5 URUR5SLSS5 URS5 UR 5n/SQnUR X#SS5 URS5 UR 5nUR[ U5S :HS S [U5-5 URS 5 UR 5nUHupgnURS U45 URUR5SLSSU-5 [RRUS5 UcMeURSU45 URUR5SLSSXh4-5 M g![a URSSSU<SU<S35 Nlf=f)NzChecking gpkg_contentsz8SELECT 1 FROM sqlite_master WHERE name = 'gpkg_contents' zgpkg_contents table missingz PRAGMA table_info(gpkg_contents)) rrhrrbNrb)rb data_typerrbNr)rrrrNr)rrrrrr)r last_changerrb$strftime('%Y-%m-%dT%H:%M:%fZ','now')r)rmin_xrrNr)rmin_yrrNr)rmax_xrrNr)max_yrrNr) rrrNr gpkg_contentszSELECT table_name, data_type FROM gpkg_contents WHERE data_type NOT IN ('features', 'tiles', 'attributes', '2d-gridded-coverage')rz*Unexpected data types in gpkg_contents: %sz9SELECT table_name, last_change, srs_id FROM gpkg_contentszVSELECT 1 FROM sqlite_master WHERE lower(name) = lower(?) AND type IN ('table', 'view')z5table_name=%s in gpkg_contents is not a table or view%Y-%m-%dT%H:%M:%S.%fZFzlast_change = z for table_name = z is invalid datetime3SELECT 1 FROM gpkg_spatial_ref_sys WHERE srs_id = ?zVtable_name=%s has srs_id=%d in gpkg_contents which isn't found in gpkg_spatial_ref_sys) rTrr\rrrtrerYdatetimestrptime ValueError) rMrrfrgrrrhrrs r _check_gpkg_contents GPKGChecker._check_gpkg_contentss *+ LM QZZ\-r3PQ 45**, & g_M  I jjl HM  83s8 C MNzz|15 -Zf IIG   LL D(M  !!**;8OP! Lvi JJL,F"* +726  "J0 s- F&F:9F:c UR(dURS5 gURS5 UVs/sHnSPM nnURSSRSU55<S[ U5<35 [ R [ R-nSn[R"U5n[R"US -5n [R"US -5n [R"US -5n UR5GHFn [[U55GH)n X](aMU S U -S -nU S U -S-R5nU S U -S-nUcMCX=SnX=SnUS:Xa*US:Xa$US;aSX]'URSUU4-5 MMUS:Xa0US:Xa*US:dUS:aSX]'URSUU4-5 MMUS:Xa0US:Xa*US:dUS:aSX]'URSUU4-5 MMUS:Xa2US:Xa,US:dUS:aSX]'URS UU4-5 GM"GM%US!;a US:XaGM4US";a US#:XaGMCURS$5(aiUS%:wa%SX]'URS&U<S'U<S(U<S)35 GM[!U[S$5S*5nUU:aSX]'URS+UUU4-5 GMGMURS,5(aiUS-:wa%SX]'URS&U<S'U<S(U<S)35 GM[!U[S,5S*5nUU:aSX]'URS.UUU4-5 GM>GMAUS-:Xa UU;aGMPUS/:Xa<US%:Xa6UR#U5c!SX]'URS&U<S0U<S135 GMGMUS2:XafUS%:Xa`U R#U5cKU R#U5c6U R#U5c!SX]'URS&U<S0U<S335 GMGMGMGMUU:wdGMSX]'URS&U<S'U<S(U<S)35 GM, GMI gs snf)4Nz'Skipping checks on actual table contentzChecking actual table contentFSELECT ,c 3# UH7n[US5<S[US5<S[US5<S3v M9 g7f)rbz,typeof(z ),length()N)r).0cols r 8GPKGChecker._check_user_table_content..s= $#3q6?GCFOWSV_N $s?A FROM z[0-9]{4}-[0-1][0-9]-[0-3][0-9]zT[0-2][0-9]:[0-5][0-9]Zz"T[0-2][0-9]:[0-5][0-9]:[0-5][0-9]Zz+T[0-2][0-9]:[0-5][0-9]:[0-5][0-9].[0-9]{3}Zrrrbrrr)rrbTz8In column %s, value %d found whereas 0 or 1 was expectedrizHIn column %s, value %d found whereas it was expected to be in [-128,127]riizLIn column %s, value %d found whereas it was expected to be in [-32768,32767]riizVIn column %s, value %d found whereas it was expected to be in [-2147483648,2147483647])rr)rrrrr rz In column z, content of type z found whereas was expectedrzCIn column %s, string of length %d found whereas %d max was expectedr!rzAIn column %s, blob of length %d found whereas %d max was expectedrz, text z found which is not a valid DATErz$ found which is not a valid DATETIME)rGrTrjoinrr/BASE_GEOM_TYPESEXT_GEOM_TYPESrecompilerrangereupperr_r"intmatch)rMrrhcolsr warned_col geom_typesdate_pattern_str date_patterndatetime_pattern_no_seconds#datetime_pattern_with_seconds_no_ms"datetime_pattern_with_millisecondsrival got_col_type length_valueexpected_col_typecol_nameexpected_max_lengths r _check_user_table_content%GPKGChecker._check_user_table_contents  II? @  12'+,tet ,  $  #  !00;3M3MM ;zz"23 &(jj 8 8' #/1jj C C/ +.0ZZ L L. *::5 [-[ U5S?5n[.R0"S@U-USU5nURUS[3SA5:HS=S>5 URUS[3SB5:HS=S>5 URUSS:HS=S>5 USn U S- S-S:Hn!U S-S:Hn"U S- SC-n#URU S"- S-S:HS=SD5 URU#S :*S=SE5 U"(aSFOSGn$[.R0"U$SH-S-US S<5Sn%UU%:wa2SIUU%U4-n&U&U;a$UR5U&5 URS SJU&5 URU!=(a U#S:g(+SKSL5 U#S:XaSn'OU#S:XaSn'OU#S:XdU#S:XaSn'OS n'S5 UU(n)U)S:Hn*U*(aSFOSGn+[.R0"U+SM-S-UU(S-U(S"-5Sn,URU,S:=(a U,SN-[ U5:S=SO5 [7U,SN- 5n-US:Xa"URU-S:H=(d U-S:HS=SP5 US:Xa"URU-S:H=(d U-S:HS=SQ5 U-S:XdU-S:XaURUS:S=SR5 U-S:XdU-S:XaURUS:S=SS5 UR5UU,SN-5 [8(dGM[:R<"UU(S5n.URU.SLS=STUSUU35 U.cGMPURU.R?5=(a U!=(d# U.R?5(+=(a U!(+SKSV5 GM USW;aFURU(+=(d U[+U/5:HSXSYU<SZ[AU5<S[U<S\35 GOUS]:XaSURU(+=(d! URC[+/S^Q55(+SXSYU<SZ[AU5<35 GO`US_;aSURU(+=(d! URC[+S`Sa/55(+SXSYU<SZ[AU5<35 GOUSb:XaRURU(+=(d! URC[+ScSb/55(+SXSYU<SZ[AU5<35 OUSd:XaRURU(+=(d! URC[+SeSd/55(+SXSYU<SZ[AU5<35 OWUSf:XaQURU(+=(d! URC[+/SgQ55(+SXSYU<SZ[AU5<35 UHZn/U/[ R$;dMURS3U/-X$45 URUR 5SLS4S5U/<S6U<35 M\ ShU<SiU<3n0URSjU045 UR 5SLn1U1(Ga URSkX$45 URUR 5SLSlSmU-5 URS[ U05-5 UR5n2SSnSoSp/SSS4SSq/SrQSSS4SSs/SrQSSS4SSt/SrQSSS4S Su/SrQSSS4/n3UREU2U3S?U05 URSvSw[GU05--5 URUR 5SLSxSyU0-5 URHSz:aS{n4OS|n4URS}S~[GU05--5 UR5n5[+5n6U5H^un[7U[ [GU055[ S5-S5n7U7U4;aURS SxUS35 U6R5U75 M` U4Hn8URU8U6;SxSU0U84-5 M URSvS[GU05--5 URUR 5SLSxSU0-5 gg![RGawn UR(GdZSUl S n URRS5 URRS5 Sn O![a Of=fU (dU eURS5 UR 5SS:Xa[R"S5n U RS5 U RS5 U R5nURS5 URS5 OM![Ra6 URS5 URS5 URS5 Of=fURS[ U5-5 Sn A G NSn A ff=f)NzChecking vector user table zdSELECT column_name, z, m, geometry_type_name, srs_id FROM gpkg_geometry_columns WHERE table_name = ?rbz:table_name = %s is not registered in gpkg_geometry_columnsrrrrz= maxzcgpkg_data_column_constraints contains constraint of type range whose min value is not less than maxz1SELECT 1 FROM gpkg_data_column_constraints WHERE zconstraint_type = 'range' AND z NOT IN (0,1)pzigpkg_data_column_constraints contains constraint of type range whose min_is_inclusive value is not 0 or 1zigpkg_data_column_constraints contains constraint of type range whose max_is_inclusive value is not 0 or 1rrzYSELECT 1 FROM gpkg_data_column_constraints WHERE constraint_type IN ('enum', 'glob') AND z IS NOT NULLqzLgpkg_data_column_constraints contains constraint of type enum or glob whose z column is not NULLz[SELECT 1 FROM gpkg_data_column_constraints WHERE constraint_type = 'enum' AND value IS NULLrzXgpkg_data_column_constraints contains constraint of type enum whose value column is NULL)rTrrr\r&rrtr) rMrmust_have_gpkg_schemarrrfrgrrhrWr6r8rs r _check_schemaGPKGChecker._check_schema s () % NO ::< # II1 **,C(,% \)G <<9,LL D0=LL ,= . jjl?LLC PQ ::< $ UC)KL  /*  89**,  g>QR IJzz|)- %Z IIH:- Xzz|# H:- JJL*Z7GHJK  LL))!E'*4)K78CD !*.6 U  ::<  LL%R S CD**, #',,&"8 >N #',,&"8 >N  7 6 , -  )Qa 8 -  )Qa 8 2    s,J   1 ::< # LL@    ::< # LLG   @  ::< # LLC   :  ::< # LL:   :  ::< # LL:   9  ::< # LLG  ?./?.@ N O  ::< # LL  ?./?.@ N O  ::< # LL  0%9IJH II=!!  zz|' 4,,K"  ;  ::< # LL<  $r c .URS5 SnURS5 UR5bURS5 UR5nSnU(a`SnUH&upVUS:XaSnUR US:HSSU-5 M( UR USS 5 UR [ U5S :SS 5 URS 5 UR5c-U(aUR SSS 5 gURS5 gURS5 UR5n/SQnUR XxSS5 URS5 UR5GHuppn URSU 45 UR5SLnUR USSU -5 U(a&UR URXU 5SSU -5 URSU 45 UR5SLnUR USSU -5 U(a&UR URXU 5SSU -5 URSU 45 UR5SLnUR USSU -5 URSU 45 UR5SLnUR USSU -S-5 UR URXS5SSU <SS<S35 UR URXS5SSU <SS<S35 GM g) NzChecking relationsFrzzoSELECT table_name, scope FROM gpkg_extensions WHERE extension_name IN ('related_tables', 'gpkg_related_tables')Tgpkgext_relationsr{z?Wrong scope for gpkgext_relations in gpkg_extensions for table zkgpkg_extensions should have an entry for extension_name = related_tables and table_name = gpkgext_relationsrbzvgpkg_extensions should have at least one entry for extension_name = related_tables and table_name != gpkgext_relationsz