
    nj                         S SK r S SKrS SKJr  SS jr\R
                  4S jr\S:X  a#  \R                  " \" \R
                  5      5        gg)    N)ogrc                    SnU(       a  [        SU -   5        [        R                  " U 5      nUR                  S5      nS nUR	                  5       nU(       a  UR                  S5      nUR                  U5        S nU(       a]  U(       a  [        S5        [        R                  " U SS9nUR                  S5        UR                  UR                  S	S
5      5        S nSnU(       a  U(       d  [        S5        g g g )NFz
Analyzing zSELECT sql FROM sqlite_master WHERE name = 'gpkg_metadata_reference_column_name_update' AND sql LIKE '%NEW.column_nameIS NOT NULL%'r   zC  Fixing invalid gpkg_metadata_reference_column_name_update trigger   )updatez7DROP TRIGGER gpkg_metadata_reference_column_name_updatezNEW.column_nameIS NOT NULLzNEW.column_name IS NOT NULLTz  Nothing to change)printr   Open
ExecuteSQLGetNextFeatureGetFieldReleaseResultSetreplace)filenameverbosesomething_donedslyr	buggy_sqlfs          X/var/www/html/pdf-tiff/venv/lib/python3.13/site-packages/osgeo_utils/samples/fix_gpkg.pyfixr   &   s    NlX%&	(	B
--	4C
 IAJJqM		BWXXXhq)
OP
,.K	

 ~#$ &w    c                     [        U 5      S:w  a  [        S5        gU S   nSU;   a)  [        R                  " U5       H  n[        U5        M     g[        U5        g)N   z!Usage: fix_gpkg.py my.gpkg|*.gpkgr   *r   )lenr   globr   )argvr   s     r   mainr   I   sT    
4yA~12AwH
h		(+HM ,  	Hr   __main__)r   )	r   sysosgeor   r   r   r   __name__exit r   r   <module>r%      sH   @  
  %F hh  zHHT#((^ r   