mss_Pattern
tables.auto_generated.mss_Pattern
Classes
Name | Description |
---|---|
mss_PatternTable | Table for mss_Pattern (Time patterns). |
mss_PatternTableColumns | Column names for mss_Pattern (Time patterns). |
mss_PatternTable
tables.auto_generated.mss_Pattern.mss_PatternTable(net_table)
Table for mss_Pattern (Time patterns).
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.mss_Pattern.mss_PatternTable.delete()
Create a DELETE query for this table.
Returns
Name | Type | Description |
---|---|---|
DeleteQuery | A new DeleteQuery object |
get_muids
tables.auto_generated.mss_Pattern.mss_PatternTable.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.mss_Pattern.mss_PatternTable.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.mss_Pattern.mss_PatternTable.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.mss_Pattern.mss_PatternTable.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 |
mss_PatternTableColumns
tables.auto_generated.mss_Pattern.mss_PatternTableColumns(table)
Column names for mss_Pattern (Time patterns).
Attributes
Name | Description |
---|---|
AM1 | Week AM 01 |
AM10 | Week AM 10 |
AM11 | Week AM 11 |
AM12 | Week AM 12 |
AM2 | Week AM 02 |
AM3 | Week AM 03 |
AM4 | Week AM 04 |
AM5 | Week AM 05 |
AM6 | Week AM 06 |
AM7 | Week AM 07 |
AM8 | Week AM 08 |
AM9 | Week AM 09 |
AMW1 | Weekend AM 01 |
AMW10 | Weekend AM 10 |
AMW11 | Weekend AM 11 |
AMW12 | Weekend AM 12 |
AMW2 | Weekend AM 02 |
AMW3 | Weekend AM 03 |
AMW4 | Weekend AM 04 |
AMW5 | Weekend AM 05 |
AMW6 | Weekend AM 06 |
AMW7 | Weekend AM 07 |
AMW8 | Weekend AM 08 |
AMW9 | Weekend AM 09 |
Day1 | Monday |
Day2 | Tuesday |
Day3 | Wednesday |
Day4 | Thursday |
Day5 | Friday |
Day6 | Saturday |
Day7 | Sunday |
Description | Description |
MUID | ID |
Mdr1 | January |
Mdr10 | October |
Mdr11 | November |
Mdr12 | December |
Mdr2 | February |
Mdr3 | March |
Mdr4 | April |
Mdr5 | May |
Mdr6 | June |
Mdr7 | July |
Mdr8 | August |
Mdr9 | September |
PM1 | Week PM 01 |
PM10 | Week PM 10 |
PM11 | Week PM 11 |
PM12 | Week PM 12 |
PM2 | Week PM 02 |
PM3 | Week PM 03 |
PM4 | Week PM 04 |
PM5 | Week PM 05 |
PM6 | Week PM 06 |
PM7 | Week PM 07 |
PM8 | Week PM 08 |
PM9 | Week PM 09 |
PMW1 | Weekend PM 01 |
PMW10 | Weekend PM 10 |
PMW11 | Weekend PM 11 |
PMW12 | Weekend PM 12 |
PMW2 | Weekend PM 02 |
PMW3 | Weekend PM 03 |
PMW4 | Weekend PM 04 |
PMW5 | Weekend PM 05 |
PMW6 | Weekend PM 06 |
PMW7 | Weekend PM 07 |
PMW8 | Weekend PM 08 |
PMW9 | Weekend PM 09 |
TypeNo | Type |