mss_SnowPack

tables.auto_generated.mss_SnowPack

Classes

Name Description
mss_SnowPackTable Table for mss_SnowPack (Snowpacks).
mss_SnowPackTableColumns Column names for mss_SnowPack (Snowpacks).

mss_SnowPackTable

tables.auto_generated.mss_SnowPack.mss_SnowPackTable(net_table)

Table for mss_SnowPack (Snowpacks).

Attributes

Name Description
columns Get the columns for the table.
description Get the table description.
display_name Get the display name for the table.
name Get the table name.

Methods

Name Description
delete Create a DELETE query for this table.
get_muids Get a list of MUIDs for the table.
insert Insert a row with the given values.
select Create a SELECT query for this table.
update Create an UPDATE query for this table.
delete
tables.auto_generated.mss_SnowPack.mss_SnowPackTable.delete()

Create a DELETE query for this table.

Returns
Name Type Description
DeleteQuery A new DeleteQuery object
get_muids
tables.auto_generated.mss_SnowPack.mss_SnowPackTable.get_muids(
    order_by=None,
    descending=False,
)

Get a list of MUIDs for the table.

Parameters
Name Type Description Default
order_by str or None Column to order the MUIDs by None
descending bool Whether to order in descending order False
Returns
Name Type Description
list of str A list of MUIDs
insert
tables.auto_generated.mss_SnowPack.mss_SnowPackTable.insert(
    values,
    execute=True,
)

Insert a row with the given values.

Parameters
Name Type Description Default
values dict of str to Any Column-value pairs to insert required
execute bool Whether to execute the query immediately (default: True) True
Returns
Name Type Description
str or InsertQuery If execute is True, returns the ID of the newly inserted row (MUID) If execute is False, returns an InsertQuery instance
select
tables.auto_generated.mss_SnowPack.mss_SnowPackTable.select(columns=[])

Create a SELECT query for this table.

Parameters
Name Type Description Default
columns list of str The columns to select []
Returns
Name Type Description
SelectQuery A new SelectQuery object
update
tables.auto_generated.mss_SnowPack.mss_SnowPackTable.update(values)

Create an UPDATE query for this table.

Parameters
Name Type Description Default
values dict of str to Any Column-value pairs to set in the UPDATE required
Returns
Name Type Description
UpdateQuery A new UpdateQuery object

mss_SnowPackTableColumns

tables.auto_generated.mss_SnowPack.mss_SnowPackTableColumns(table)

Column names for mss_SnowPack (Snowpacks).

Attributes

Name Description
Cmax1 Cmax [mm/deg C/h]
Cmax2 Cmax [mm/deg C/h]
Cmax3 Cmax [mm/deg C/h]
Cmin1 Cmin [mm/deg C/h]
Cmin2 Cmin [mm/deg C/h]
Cmin3 Cmin [mm/deg C/h]
Description Description
Fimelt Fimelt
Fimperv Fimperv
Fout Fout
Fperv Fperv
Fsubcatch Fsubcatch
Fw01 FWF [mm]
Fw02 FW0 [mm]
Fw03 FWF [mm]
Fwf1 FWF
Fwf2 FWF
Fwf3 FWF
MUID ID
SD1002 SD100 [mm]
SD1003 SD100 [mm]
Sd01 SD0 [mm]
Sd02 SD0 [mm]
Sd03 SD0 [mm]
Sdplow SDplow [mm]
Snn0 SNN
SubCatchID SubcatchID
Tbase1 Tbase [deg C]
Tbase2 Tbase [deg C]
Tbase3 Tbase [deg C]