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(
    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.mss_Pattern.mss_PatternTable.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.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