
    nj(                         S SK r S SKJr  S r\ R                  4S jr\S:X  a#  \ R                  " \" \ R                  5      5        gg)    N)ogrc                  0    [        S5        [        S5        g)Nz>Usage: load2odbc.py [-where attr_filter] infile odbc_dsn layer    )print     Y/var/www/html/pdf-tiff/venv/lib/python3.13/site-packages/osgeo_utils/samples/load2odbc.pyUsager   (   s    	
JK	"Ir	   c                 h	   SnS nS nS nS nSnU[        U 5      :  aJ  X   S:X  a
  US-   nX   nO"Uc  X   nOUc  X   nOUc  X   nO
[        5       $ US-   nU[        U 5      :  a  MJ  Uc
  [        5       $ [        R                  " USS9nUR	                  U5      nUc  [        SU5        gUb  UR                  U5        US:X  a  S n	OE[        U5      S:  d	  US S S	:w  a  S	U-   n[        R                  " U5      n	U	c  [        S
U-   5        g SU-   n
U	c  [        U
5        OU	R                  U
5         UR                  5       nSU-   S-   n
U(       a  U
S-   n
[        UR                  5       5       H  nUR                  U5      nU
S-   UR                  5       -   n
UR                  5       [        R                  :X  a  U
S-   n
MS  UR                  5       [        R                   :X  a  U
S-   n
M|  UR                  5       [        R"                  :X  a  U
S-   n
M  U
S-   n
M     U
S-   n
U	c  [        U
5        O1[        SU
5        U	R                  U
5      nUb  U	R%                  U5        UR'                  5         UR)                  5       nUGb  SU-   S-   nSUR+                  5       -  nUR-                  5       nUb  US-   nUS-   UR/                  5       -   S-   nU(       a   Ub  UR1                  5       nUS-   nUSU-  -   n[        UR                  5       5       GH  nUR                  U5      nUR3                  U5      S:w  a  US-   UR                  5       -   nUR                  5       [        R                  :X  a  US-   UR5                  U5      -   nM{  UR                  5       [        R                   :X  a  US-   UR5                  U5      -   S-   nM  UR                  5       [        R"                  :X  a  US-   UR5                  U5      -   nM  US-   UR5                  U5      -   S-   nGM     UU-   S-   n
U	c  [        U
5        O[        SU
5        U	R                  U
5        UR7                  5         UR)                  5       nUb  GM  UR7                  5         U	b  U	R7                  5         g! [         a     GN~f = f)N   z-wherer   )updatezDid not find layer: stdout      zODBC:zUnable to connect to zdrop table zCREATE TABLE z$( OGC_FID INTEGER, WKT_GEOMETRY MEMOz4, XMIN NUMBER, YMIN NUMBER, XMAX NUMBER, YMAX NUMBERz, z INTEGERz TEXTz NUMBER)zExecuteSQL: zINSERT INTO z ( OGC_FID z) VALUES (%dz, WKT_GEOMETRYz, ''z, XMIN, XMAX, YMIN, YMAXz, %.7f, %.7f, %.7f, %.7f)lenr   r   OpenGetLayerByNamer   SetAttributeFilter
ExecuteSQL	ExceptionGetLayerDefnrangeGetFieldCountGetFieldDefnGetNameGetType
OFTInteger	OFTStringOFTRealReleaseResultSetResetReadingGetNextFeatureGetFIDGetGeometryRefExportToWktGetEnvelope
IsFieldSetGetFieldAsStringDestroy)argvextents_flaginfileodbc_dsn	layernameattr_filteriin_dsin_layerout_dscmddefniFieldfielddefresultfeat	cmd_startcmd_endgeomextents                       r
   mainrA   .   s   LFHIK	A
c$i-7hAA'K^WFwHI7NE c$i- w
 HHVA&E##I.H$i0##K0
 8x=1! 7)H(#>)H45
i'>#Jc"   "D
I
%(N
NCJJ**,-$$V,Dj8++--/
"C3==0-C3;;.	/C-C . )C~c
nc"""3'##F+ ""$D

"Y.>	 4;;=0""$!$44Io(8(8(::S@GD,%%'F!$>>I!;f!DEGD..01F((0Hv&!+%,x/?/?/AA	!S^^3!D.4+@+@+HH!!#s}}4!E/D,A,A&,IICO!!#s{{2!D.4+@+@+HH!E/D,A,A&,IICO 2 '!C'>#J.#&c"&&(K 
T 
MMOi  s   R#  R# #
R10R1__main__)sysosgeor   r   r-   rA   __name__exitr   r	   r
   <module>rG      sF   B  
 hh Tn zHHT#((^ r	   