#NEWLINE# def _add_geom( self , style , db_table ) : #NEWLINE# #INDENT# '\n        Adds this geometry column into the Oracle USER_SDO_GEOM_METADATA\n        table.\n        ' #NEWLINE# if ( self . _dim != 2 ) : #NEWLINE# #INDENT# raise Exception ( '3D geometries not yet supported on Oracle Spatial backend.' ) #NEWLINE# #UNINDENT# meta_sql = ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( style . SQL_KEYWORD ( 'INSERT INTO ' ) + style . SQL_TABLE ( 'USER_SDO_GEOM_METADATA' ) ) + ( ' (%s, %s, %s, %s)\n  ' % tuple ( map ( qn , [ 'TABLE_NAME' , 'COLUMN_NAME' , 'DIMINFO' , 'SRID' ] ) ) ) ) + style . SQL_KEYWORD ( ' VALUES ' ) ) + '(\n    ' ) + style . SQL_TABLE ( gqn ( db_table ) ) ) + ',\n    ' ) + style . SQL_FIELD ( gqn ( self . column ) ) ) + ',\n    ' ) + style . SQL_KEYWORD ( 'MDSYS.SDO_DIM_ARRAY' ) ) + '(\n      ' ) + style . SQL_KEYWORD ( 'MDSYS.SDO_DIM_ELEMENT' ) ) + ( "('LONG', %s, %s, %s),\n      " % ( self . _extent [ 0 ] , self . _extent [ 2 ] , self . _tolerance ) ) ) + style . SQL_KEYWORD ( 'MDSYS.SDO_DIM_ELEMENT' ) ) + ( "('LAT', %s, %s, %s)\n    ),\n" % ( self . _extent [ 1 ] , self . _extent [ 3 ] , self . _tolerance ) ) ) + ( '    %s\n  );' % self . _srid ) ) #NEWLINE# return meta_sql