mrm_BridgeOpening
tables.auto_generated.mrm_BridgeOpening
Classes
| Name | Description |
|---|---|
| mrm_BridgeOpeningTable | Table for mrm_BridgeOpening (mrm_BridgeOpening). |
| mrm_BridgeOpeningTableColumns | Column names for mrm_BridgeOpening (mrm_BridgeOpening). |
mrm_BridgeOpeningTable
tables.auto_generated.mrm_BridgeOpening.mrm_BridgeOpeningTable(net_table)Table for mrm_BridgeOpening (mrm_BridgeOpening).
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.mrm_BridgeOpening.mrm_BridgeOpeningTable.delete()Create a DELETE query for this table.
Returns
| Name | Type | Description |
|---|---|---|
| DeleteQuery | A new DeleteQuery object |
get_muids
tables.auto_generated.mrm_BridgeOpening.mrm_BridgeOpeningTable.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.mrm_BridgeOpening.mrm_BridgeOpeningTable.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.mrm_BridgeOpening.mrm_BridgeOpeningTable.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.mrm_BridgeOpening.mrm_BridgeOpeningTable.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 |
mrm_BridgeOpeningTableColumns
tables.auto_generated.mrm_BridgeOpening.mrm_BridgeOpeningTableColumns(table)Column names for mrm_BridgeOpening (mrm_BridgeOpening).
Attributes
| Name | Description |
|---|---|
| ArchesNum | Number of arches |
| AsymmetryChk | Include asymmetric opening |
| ContractionLoss | Contraction loss coef. [()] |
| CustomTableBase | Custom table |
| CustomTableBaseR | Custom table |
| CustomTableEntran | Custom table |
| CustomTableEntranR | Custom table |
| CustromTableAbut | Custom table |
| CustromTableAbutR | Custom table |
| CustromTableDepth | Custom table |
| CustromTableDepthR | Custom table |
| CustromTableFroude | Custom table |
| CustromTableFroudeR | Custom table |
| CustromTableVel | Custom table |
| CustromTableWW | Custom table |
| CustromTableWWR | Custom table |
| DatumDownCrs | Datum [m] |
| DatumUpCrs | Datum [m] |
| DownCrsSlope | Slope [()] |
| DownCrsTypeNo | Cross section |
| EctrCustomTable | Custom table |
| EctrUseCustomNo | Use custom table |
| EmbankSlope | Slope |
| EmbankSlopeR | Slope |
| EntranAngle | Angle [deg] |
| EntranAngleR | Angle [deg] |
| EntranRadius | Radius [m] |
| EntranRadiusR | Radius [m] |
| EntranTypeNo | Type |
| EntranTypeRNo | Type |
| EntranWidth | Width [m] |
| EntranWidthR | Width [m] |
| ExpansionLoss | Expansion loss coef. [()] |
| FromSDown | From S value [m] |
| FromSUp | From S value [m] |
| IncludeEctrNo | Include eccentricity |
| IncludePirNo | Include piers / piles |
| IncludeSknNo | Include skewness |
| IncludeSpdNo | Include spur dykes |
| LevelBottom | Level of bottom of arch curvature [m] |
| LevelOfLength | Level of waterway length [m] |
| LevelOfLengthR | Level of waterway length [m] |
| LevelTop | Level of top of arch curvature [m] |
| MUID | ID |
| Method | Method |
| OffsetDSSection | Horizontal offset for downstream bridge section [m] |
| OffsetOver | Horizontal offset for overflow level [m] |
| OffsetSub | Horizontal offset for submergence level [m] |
| OffsetUSSection | Horizontal offset for upstream bridge section [m] |
| OflDeckLevel | Bridge deck level [m] |
| OflDischargeCoef1 | Discharge coef #1 |
| OflDischargeCoef2 | Discharge coef #2 |
| OflLength | Length [m] |
| OflMethodNo | Method |
| OflSurfaceNo | Surface |
| OflUseCustomTableNo | Use custom table |
| OflWeirID | Weir |
| OpeningTypeNo | Opening type |
| OpeningTypeRNo | Opening type, right |
| OpeningWidth | Opening width [m] |
| PileCustomTable1L | Custom table |
| PileCustomTable2L | Custom table |
| PirCustomTable | Custom table |
| PirTypeNo | Type |
| PirUseCustomNo | Use custom table |
| PirWWBlock | Waterway blocked [()] |
| RadioType | Ratio |
| Radius | Radius of arch curvature [m] |
| RiverBridgeID | River bridge ID |
| RoughTypeNo | Roughness type |
| RoughValue | Roughness value |
| SknAngle | Angle [deg] |
| SknCustomTable | Custom table |
| SknUseCustomNo | Use custom table |
| SpdAngle | Angle [deg] |
| SpdAngleR | Angle [deg] |
| SpdCustomTable1 | Table 1 |
| SpdCustomTable2 | Table 1 |
| SpdCustomTableR1 | Table 2 |
| SpdCustomTableR2 | Table 2 |
| SpdLength | Length [m] |
| SpdLengthR | Length [m] |
| SpdOffset | Offset [m] |
| SpdOffsetR | Offset [m] |
| SpdTypeNo | Type |
| SpdTypeRNo | Type |
| SpdUseCustom | Use custom table |
| SpdUseCustomR | Use custom tables, right |
| Sqn | Sqn |
| SubMgcContraction | Contraction loss [()] |
| SubMgcCulvertID | Culvert |
| SubMgcCustomTable | Custom table |
| SubMgcDischargeCoef | Discharge coef. [()] |
| SubMgcExpansion | Expansion loss [()] |
| SubMgcFactor | Submergence factor |
| SubMgcMethodNo | Method |
| SubMgcSoffitLevel | Bridge soffit level [m] |
| SubMgcUseCustomTableNo | Use custom table |
| SubmergenceTypeNo | Include |
| TableCrsDownID | Custom table |
| TableCrsUpID | Custom table |
| ToSDown | To S value [m] |
| ToSUp | To S value [m] |
| TypeBaseNo | Type |
| UseCustomBaseNo | Use custom table |
| UseCustomBaseRNo | Use custom table |
| UseCustomEntranNo | Use custom table |
| UseCustomEntranRNo | Use custom table |
| UseCustromAbutNo | Use custom table |
| UseCustromAbutRNo | Use custom table |
| UseCustromCrsDownNo | Use custom sub-cross section |
| UseCustromCrsUpNo | Use custom sub-cross section |
| UseCustromDepthNo | Use custom table |
| UseCustromDepthRNo | Use custom table |
| UseCustromFroudeNo | Use custom table |
| UseCustromFroudeRNo | Use custom table |
| UseCustromVelNo | Use custom table |
| UseCustromWWNo | Use custom table |
| UseCustromWWRNo | Use custom table |
| WWAngle | Angle [deg] |
| WWAngleR | Angle [deg] |
| WaterwayLength | Waterway length [m] |
| WaterwayLengthR | Waterway length [m] |