mss_Outlet

tables.auto_generated.mss_Outlet

Classes

Name	Description
mss_OutletTable	Table for mss_Outlet (Outlets).
mss_OutletTableColumns	Column names for mss_Outlet (Outlets).

tables.auto_generated.mss_Outlet.mss_OutletTable(net_table)

Table for mss_Outlet (Outlets).

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.

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.

tables.auto_generated.mss_Outlet.mss_OutletTable.delete()

Create a DELETE query for this table.

Name	Type	Description
	DeleteQuery	A new DeleteQuery object

tables.auto_generated.mss_Outlet.mss_OutletTable.get_muids(
    order_by=None,
    descending=False,
)

Get a list of MUIDs for the table.

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`

Name	Type	Description
	list of str	A list of MUIDs

tables.auto_generated.mss_Outlet.mss_OutletTable.insert(values, execute=True)

Insert a row with the given values.

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`

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

tables.auto_generated.mss_Outlet.mss_OutletTable.select(columns=[])

Create a SELECT query for this table.

Name	Type	Description	Default
columns	list of str	The columns to select	`[]`

Name	Type	Description
	SelectQuery	A new SelectQuery object

tables.auto_generated.mss_Outlet.mss_OutletTable.update(values)

Create an UPDATE query for this table.

Name	Type	Description	Default
values	dict of str to Any	Column-value pairs to set in the UPDATE	required

Name	Type	Description
	UpdateQuery	A new UpdateQuery object

tables.auto_generated.mss_Outlet.mss_OutletTableColumns(table)

Column names for mss_Outlet (Outlets).