msm_RTCSensor

tables.auto_generated.msm_RTCSensor

Classes

Name	Description
msm_RTCSensorTable	Table for msm_RTCSensor (Sensors).
msm_RTCSensorTableColumns	Column names for msm_RTCSensor (Sensors).

msm_RTCSensorTable

tables.auto_generated.msm_RTCSensor.msm_RTCSensorTable(net_table)

Table for msm_RTCSensor (Sensors).

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.msm_RTCSensor.msm_RTCSensorTable.delete()

Create a DELETE query for this table.

Returns

Name	Type	Description
	DeleteQuery	A new DeleteQuery object

get_muids

tables.auto_generated.msm_RTCSensor.msm_RTCSensorTable.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.msm_RTCSensor.msm_RTCSensorTable.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.msm_RTCSensor.msm_RTCSensorTable.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.msm_RTCSensor.msm_RTCSensorTable.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

msm_RTCSensorTableColumns

tables.auto_generated.msm_RTCSensor.msm_RTCSensorTableColumns(table)

Column names for msm_RTCSensor (Sensors).

Attributes

Name	Description
ActionID	Action ID
BridgeRiverLocationID	River bridge ID
Chainage	Chainage [m]
ComponentID	WQ component
CulvertRiverLocationID	Culvert ID
DambreakRiverLocationID	Dambreak ID
Description	Description
DirectDischargeRiverLocationID	Direct discharge ID
DownStreamChainage	Downstr. chainage [m]
Expression	Expression
GateLocationID	Gate ID
LinkLocationID	Link ID
LocationNo	Location type
MUID	ID
NodeLocationID	Node ID
OrificeLocationID	Orifice Gate ID
PumpLocationID	Pump ID (CS)
PumpRiverLocationID	Pump ID (Rivers)
RiverLocationID	River ID
RiverStructureID	Structure ID
RiverStructureTypeNo	Structure type
Sqn	Sqn
StorageLocationID	Storage ID
TSFileName	Time series file
TSItemName	Time series item
TabulatedRiverLocationID	Tabulated ID
TypeNo	Type
UpStreamChainage	Upstr. chainage [m]
ValveLocationID	Valve ID
WeirLocationID	Weir ID (CS)
WeirRiverLocationID	Weir ID (Rivers)