mw_Pipe

tables.auto_generated.mw_Pipe

Classes

Name	Description
mw_PipeTable	Table for mw_Pipe (Pipes).
mw_PipeTableColumns	Column names for mw_Pipe (Pipes).

mw_PipeTable

tables.auto_generated.mw_Pipe.mw_PipeTable(net_table)

Table for mw_Pipe (Pipes).

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_Pipe.mw_PipeTable.delete()

Create a DELETE query for this table.

Returns

Name	Type	Description
	DeleteQuery	A new DeleteQuery object

get_muids

tables.auto_generated.mw_Pipe.mw_PipeTable.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_Pipe.mw_PipeTable.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_Pipe.mw_PipeTable.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_Pipe.mw_PipeTable.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_PipeTableColumns

tables.auto_generated.mw_Pipe.mw_PipeTableColumns(table)

Column names for mw_Pipe (Pipes).

Attributes

Name	Description
AssetName	Asset ID
Bulk_Coeff	Bulk coefficient [/d]
CDate	Construction year
CVCanReopen	Check valve can reopen
CVInterval	Check valve idle interval [sec]
CVPressure	Check valve cracking pressure [m]
CVReverseQ	Check valve reverse flow [m^3/s]
CVStatOpen	Check valve is regulating
CVTimeClose	Check valve time to close [sec]
CVTimeOpen	Check valve time to open [sec]
CVVelocity	Check valve minimum velocity [m/s]
Coeff1	Demand Coeff. 1
Coeff2	Demand Coeff. 2
Coeff3	Demand Coeff. 3
Coeff4	Demand Coeff. 4
DataSource	Data source
Description	Description
Diameter	Diameter [mm]
Element_S	Status
Enabled	Is active
FromNodeID	From node
GeometricLength	Geometric length [m]
GroupID	GroupID
Inner_Diameter	Inner diameter [mm]
L	Length [m]
LCoeff	Loss coefficient
MUID	ID
Material	Material
Note	Note
PMapZone	PMapZone
PN	Pressure nominal [m]
RCoeff	Roughness
StatusNo	Initial status
StreetName	Street name
Thickness	Wall thickness [mm]
ToNodeID	To node
UserLno	UserLno
Wall_Coeff	Wall coefficient [/d]
WaveSpeed	Wave speed [m/s]
ZoneID	Zone ID