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()
	ALEMBIC_REPO_PATH = os.path.join(os.path.dirname(__file__), "alembic")
	meta = MetaData()
	mapper_registry = registry()
	rave_wmo_station
	rave_observation
	rave_gra_coefficient
	rave_grapoint
	rave_melting_layer
dict	dburipool = {}
	a = create_db_from_conf("/etc/baltrad/bltnode.properties")

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()

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()

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("identifier", Text, nullable=False),
    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("identifier", "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),
    Column("identifier", Text, nullable=False),
    PrimaryKeyConstraint("identifier", "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'),
)