ms_DPSchedule

tables.auto_generated.ms_DPSchedule

Classes

Name Description
ms_DPScheduleTable Table for ms_DPSchedule (Profile calendars).
ms_DPScheduleTableColumns Column names for ms_DPSchedule (Profile calendars).

ms_DPScheduleTable

tables.auto_generated.ms_DPSchedule.ms_DPScheduleTable(net_table)

Table for ms_DPSchedule (Profile calendars).

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.ms_DPSchedule.ms_DPScheduleTable.delete()

Create a DELETE query for this table.

Returns
Name Type Description
DeleteQuery A new DeleteQuery object
get_muids
tables.auto_generated.ms_DPSchedule.ms_DPScheduleTable.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.ms_DPSchedule.ms_DPScheduleTable.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.ms_DPSchedule.ms_DPScheduleTable.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.ms_DPSchedule.ms_DPScheduleTable.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

ms_DPScheduleTableColumns

tables.auto_generated.ms_DPSchedule.ms_DPScheduleTableColumns(table)

Column names for ms_DPSchedule (Profile calendars).

Attributes

Name Description
DatesNo Dates
DaysNo Week days
MUID ID
Month1 January
Month10 October
Month11 November
Month12 December
Month2 February
Month3 March
Month4 April
Month5 May
Month6 June
Month7 July
Month8 August
Month9 September
MonthDay1 Day 1
MonthDay10 Day 10
MonthDay11 Day 11
MonthDay12 Day 12
MonthDay13 Day 13
MonthDay14 Day 14
MonthDay15 Day 15
MonthDay16 Day 16
MonthDay17 Day 17
MonthDay18 Day 18
MonthDay19 Day 19
MonthDay2 Day 2
MonthDay20 Day 20
MonthDay21 Day 21
MonthDay22 Day 22
MonthDay23 Day 23
MonthDay24 Day 24
MonthDay25 Day 25
MonthDay26 Day 26
MonthDay27 Day 27
MonthDay28 Day 28
MonthDay29 Day 29
MonthDay3 Day 3
MonthDay30 Day 30
MonthDay31 Day 31
MonthDay4 Day 4
MonthDay5 Day 5
MonthDay6 Day 6
MonthDay7 Day 7
MonthDay8 Day 8
MonthDay9 Day 9
MonthsNo Months
WeekDay1 Monday
WeekDay2 Tuesday
WeekDay3 Wednesday
WeekDay4 Thursday
WeekDay5 Friday
WeekDay6 Saturday
WeekDay7 Sunday