ost.helpers.db.pgConnect

class ost.helpers.db.pgConnect(uname=None, pword=None, dbname='sat', host='localhost', port='5432')

Attributes

Methods

pgCreateS1
pgGetUUID
pgDrop
pgInsert	This function inserts a table into the connected database object.
pgSQL	This is a wrapper for a sql input that does get all responses.
pgSQLnoResp	This is a wrapper for a sql input that does not get any response.
shpGeom2pg	This function is a wrapper to import a shapefile geometry to a PostGreSQL database
pgDateline	This function splits the acquisition footprint into a geometry collection if it crosses the dateline

pgConnect.pgCreateS1(tablename)

pgConnect.pgGetUUID(sceneID, tablename)

pgConnect.pgDrop(tablename)

pgConnect.pgInsert(tablename, values)

This function inserts a table into the connected database object.

pgConnect.pgSQL(sql)

This is a wrapper for a sql input that does get all responses.

pgConnect.pgSQLnoResp(sql)

This is a wrapper for a sql input that does not get any response.

pgConnect.shpGeom2pg(aoi, tablename)

This function is a wrapper to import a shapefile geometry to a PostGreSQL database

pgConnect.pgDateline(tablename, uuid)

This function splits the acquisition footprint into a geometry collection if it crosses the dateline