PostGIS  2.4.9dev-r@@SVN_REVISION@@

◆ make_sql_register_overview()

def raster2pgsql.make_sql_register_overview (   options,
  ov_table,
  ov_factor 
)

Definition at line 455 of file raster2pgsql.py.

References make_sql_schema_table_names(), make_sql_table_name(), and quote_sql_value().

Referenced by wkblify_raster_level().

455 def make_sql_register_overview(options, ov_table, ov_factor):
456  assert len(ov_table) > 0
457  assert ov_factor > 0
458 
459  catalog = quote_sql_value('')
460  schema = make_sql_schema_table_names(options.table)[0]
461  r_table = make_sql_table_name(options.table)
462 
463  sql = "INSERT INTO public.raster_overviews( " \
464  "o_table_catalog, o_table_schema, o_table_name, o_column, " \
465  "r_table_catalog, r_table_schema, r_table_name, r_column, out_db, overview_factor) " \
466  "VALUES ('%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', FALSE, %d);\n" % \
467  (catalog, schema, ov_table, options.column, catalog, schema, r_table, options.column, ov_factor)
468 
469  return sql
470 
def make_sql_register_overview(options, ov_table, ov_factor)
def make_sql_table_name(schema_table)
def quote_sql_value(value)
SQL OPERATIONS.
def make_sql_schema_table_names(schema_table)
Here is the call graph for this function:
Here is the caller graph for this function: