JsonDocumentRecords¶

model.AddUpdateJsonRecord(json, section, pk1, pk2, pk3, pk4)¶

Parameters:

• json (str) – JSON string to store

• section (str) – Section identifier for the record

• pk1 (object) – Primary key value 1 (required)

• pk2 (object) – Primary key value 2 (optional)

• pk3 (object) – Primary key value 3 (optional)

• pk4 (object) – Primary key value 4 (optional)

Adds or updates a JSON document record using the provided JSON string.

model.AddUpdateJsonRecord(data, section, pk1, pk2, pk3, pk4)¶

Parameters:

• data (DynamicData) – Dynamic data object to store as JSON

• section (str) – Section identifier for the record

• pk1 (object) – Primary key value 1 (required)

• pk2 (object) – Primary key value 2 (optional)

• pk3 (object) – Primary key value 3 (optional)

• pk4 (object) – Primary key value 4 (optional)

Adds or updates a JSON document record using the provided DynamicData object.

model.DeleteJsonRecord(section, pk1, pk2, pk3, pk4)¶

Parameters:

• section (str) – Section identifier for the record

• pk1 (object) – Primary key value 1 (required)

• pk2 (object) – Primary key value 2 (optional)

• pk3 (object) – Primary key value 3 (optional)

• pk4 (object) – Primary key value 4 (optional)

Deletes a JSON document record with the specified section and key values.

model.DeleteJsonRecordSection(section)¶

Parameters:

section (str) – Section identifier for the records to delete

Deletes all JSON document records belonging to the specified section.

model.SqlListDynamicData(sql, metadata)¶

Parameters:

• sql (str) – SQL query to execute

• metadata (DynamicData) – Optional metadata for type conversion

Returns:

List of DynamicData objects from query results

Return type:

List[DynamicData]

Executes an SQL query and returns the results as a list of DynamicData objects.

model.SqlTop1DynamicData(sql, metadata)¶

Parameters:

• sql (str) – SQL query to execute

• metadata (DynamicData) – Optional metadata for type conversion

Returns:

First row from query results as a DynamicData object, or null if no rows returned

Return type:

DynamicData

Executes an SQL query and returns the first row as a DynamicData object.

model.SqlList(sql)¶

Parameters:

sql (str) – SQL query to execute

Returns:

List of dynamic objects from query results

Return type:

List[dynamic]

Executes an SQL query and returns the results as a list of dynamic objects.