mw_Pump

tables.auto_generated.mw_Pump

Classes

Name Description
mw_PumpTable Table for mw_Pump (Pumps).
mw_PumpTableColumns Column names for mw_Pump (Pumps).

mw_PumpTable

tables.auto_generated.mw_Pump.mw_PumpTable(net_table)

Table for mw_Pump (Pumps).

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.mw_Pump.mw_PumpTable.delete()

Create a DELETE query for this table.

Returns
Name Type Description
DeleteQuery A new DeleteQuery object
get_muids
tables.auto_generated.mw_Pump.mw_PumpTable.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.mw_Pump.mw_PumpTable.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.mw_Pump.mw_PumpTable.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.mw_Pump.mw_PumpTable.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

mw_PumpTableColumns

tables.auto_generated.mw_Pump.mw_PumpTableColumns(table)

Column names for mw_Pump (Pumps).

Attributes

Name Description
AssetName Asset ID
CDate Date
C_MTorqueID Motor torque
CurveTypeNo Curve type
DataSource Data source
Description Description
EPatternID Energy price pattern
EPrice Energy price
EfCurveID Effective curve
Element_S Status
Elev Elevation [m]
Enabled Is active
FromNodeID From node
MUID ID
Note Note
P_IW Moment of inertia [kg*m^2]
P_PTorqueID Pump torque
P_ScheduleID Operation schedule
P_ScheduleNo Operation type
P_Speed Rotational pump speed [rpm]
P_TTripoff Pump tripoff time [sec]
Par1 Shutoff head [m]
Par2 Design head [m]
Par3 Design flow [m^3/s]
Par4 High end head [m]
Par5 High end flow [m^3/s]
Par6 Constant power [W]
PatternID Pattern
QHCurveID QH curve
Setting Relative speed
StatusNo Closed
StreetName Street name
ToNodeID To node
TypeNo Type
VSD_CtrlFlow Control flow [m^3/s]
VSD_CtrlLevelTypeNo Control item
VSD_Curve VSD curve
VSD_HGL Control HGL [m]
VSD_Link Control link
VSD_MaxSpeed Maximum speed
VSD_MinSpeed Minimum speed
VSD_Node Control node
VSD_Pressure Control pressure [m]
VSD_TypeNo Control type
ZoneID Zone ID
p_TStartup Pump startup time [sec]