msm_LIDusage

tables.auto_generated.msm_LIDusage

Classes

Name	Description
msm_LIDusageTable	Table for msm_LIDusage (LID deployment).
msm_LIDusageTableColumns	Column names for msm_LIDusage (LID deployment).

tables.auto_generated.msm_LIDusage.msm_LIDusageTable(net_table)

Table for msm_LIDusage (LID deployment).

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.msm_LIDusage.msm_LIDusageTable.delete()

Create a DELETE query for this table.

Name	Type	Description
	DeleteQuery	A new DeleteQuery object

tables.auto_generated.msm_LIDusage.msm_LIDusageTable.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.msm_LIDusage.msm_LIDusageTable.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.msm_LIDusage.msm_LIDusageTable.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.msm_LIDusage.msm_LIDusageTable.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.msm_LIDusage.msm_LIDusageTableColumns(table)

Column names for msm_LIDusage (LID deployment).