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(=None,
order_by=False,
descending )
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
=True) tables.auto_generated.mw_Pump.mw_PumpTable.insert(values, execute
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] |