Lib.rave_dom_db Namespace Reference

Classes
class	rave_db
	Class for connecting with the database. More...

Functions
	psql_set_extra_float_digits (dbapi_con, con_record)
	create_db (url, create_schema=True)
	Creates a rave db instance.
	create_db_from_conf (configfile=BDB_CONFIG_FILE, create_schema=True)
	Creates a rave_db instance.

Variables
	logger = rave_pgf_logger.create_logger()
	MIGRATION_REPO_PATH = os.path.join(os.path.dirname(__file__), "ravemigrate")
	meta = MetaData()
	rave_wmo_station
	rave_observation
	rave_gra_coefficient
	rave_grapoint
	rave_melting_layer
dict	dburipool = {}

Detailed Description

Copyright (C) 2010- Swedish Meteorological and Hydrological Institute (SMHI)

This file is part of RAVE.

RAVE is free software: you can redistribute it and/or modify
it under the terms of the GNU Lesser General Public License as published by
the Free Software Foundation, either version 3 of the License, or
(at your option) any later version.

RAVE is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
See the GNU Lesser General Public License for more details.

You should have received a copy of the GNU Lesser General Public License
along with RAVE.  If not, see <http://www.gnu.org/licenses/>.

Function Documentation

create_db()

Lib.rave_dom_db.create_db	(		url,
			create_schema = True )

Creates a rave db instance.

This instance will be remembered for the same url which means that the same db-instance will be used for the same url. If create_schema = True (default) then the tables will be created

create_db_from_conf()

Lib.rave_dom_db.create_db_from_conf	(		configfile = BDB_CONFIG_FILE,
			create_schema = True )

Creates a rave_db instance.

Variable Documentation

rave_gra_coefficient

Lib.rave_dom_db.rave_gra_coefficient

Initial value:

= Table("rave_gra_coefficient", meta,
                           Column("area", Text, nullable=False),
                           Column("date", Date, nullable=False),
                           Column("time", Time, nullable=False),
                           Column("significant", Text, nullable=False),
                           Column("points", Integer, nullable=False),
                           Column("loss", Integer, nullable=False),
                           Column("r", Float, nullable=False),
                           Column("r_significant", Text, nullable=False),
                           Column("corr_coeff", Float, nullable=False),
                           Column("a", Float, nullable=False),
                           Column("b", Float, nullable=False),
                           Column("c", Float, nullable=False),
                           Column("mean", Float, nullable=False),
                           Column("stddev", Float, nullable=False),
                           PrimaryKeyConstraint("area","date","time"))

rave_grapoint

Lib.rave_dom_db.rave_grapoint

Initial value:

= Table("rave_grapoint", meta,
                    Column("date", Date, nullable=False),
                    Column("time", Time, nullable=False),
                    Column("radarvaluetype", Integer, nullable=False),
                    Column("radarvalue", Float, nullable=False),
                    Column("radardistance", Float, nullable=False),
                    Column("longitude", Float, nullable=False),
                    Column("latitude", Float, nullable=False),
                    Column("observation", Float, nullable=False),
                    Column("accumulation_period", Integer, nullable=False),
                    Column("gr", Float, nullable=False),
                    PrimaryKeyConstraint("date","time","longitude","latitude"))

rave_melting_layer

Lib.rave_dom_db.rave_melting_layer

Initial value:

= Table("rave_melting_layer", meta,
                         Column("nod", Text, nullable=False),
                         Column("datetime", DateTime, nullable=False),
                         Column("top", Float, nullable=True),
                         Column("bottom", Float, nullable=True),
                         PrimaryKeyConstraint("datetime", "nod"))

rave_observation

Lib.rave_dom_db.rave_observation

Initial value:

= Table("rave_observation", meta,
                       Column("station", Text, nullable=True),
                       Column("country", Text, nullable=True),
                       Column("type", Integer, nullable=True),
                       Column("date", Date, nullable=False),
                       Column("time", Time, nullable=False),
                       Column("longitude", Float, nullable=False),
                       Column("latitude", Float, nullable=False),
                       Column("visibility", Float, nullable=True),
                       Column("windtype", Integer, nullable=True),
                       Column("cloudcover", Integer, nullable=True),
                       Column("winddirection", Float, nullable=True),
                       Column("windspeed", Float, nullable=True),
                       Column("temperature", Float, nullable=True),
                       Column("dewpoint", Float, nullable=True),
                       Column("relativehumidity", Float, nullable=True),
                       Column("pressure", Float, nullable=True),
                       Column("sea_lvl_pressure", Float, nullable=True),
                       Column("pressure_change", Float, nullable=True),
                       Column("liquid_precipitation", Float, nullable=True),
                       Column("accumulation_period", Integer, nullable=True),
                       Column("valid_fields_bitmask", Integer, nullable=True),
                       PrimaryKeyConstraint("station", "date", "time", "accumulation_period"))

rave_wmo_station

Lib.rave_dom_db.rave_wmo_station

Initial value:

= Table("rave_wmo_station", meta,
                       Column("stationnumber", Text, nullable=False),
                       Column("stationsubnumber", Text, nullable=False),
                       Column("stationname", Text, nullable=True),
                       Column("country", Text, nullable=True),
                       Column("countrycode", Text, nullable=True),
                       Column("longitude", Float, nullable=True),
                       Column("latitude", Float, nullable=True),
                       PrimaryKeyConstraint('stationnumber','stationsubnumber',name='pk_wmo_station'),
)