samjs/expensetracker.dbmodel

function queryNativeSQL(ParameterizedQuery sqlQuery, typedesc<record {}> rowType) returns stream<rowType, Error?>

function executeNativeSQL(ParameterizedQuery sqlQuery) returns ExecutionResult|Error

function get expenseitems(ExpenseItemTargetType targetType, ParameterizedQuery whereClause, ParameterizedQuery orderByClause, ParameterizedQuery limitClause, ParameterizedQuery groupByClause) returns stream<targetType, Error?>

function get expenseitems/[string id](ExpenseItemTargetType targetType) returns targetType|Error

function post expenseitems(ExpenseItemInsert[] data) returns string[]|Error

function put expenseitems/[string id](ExpenseItemUpdate value) returns ExpenseItem|Error

function delete expenseitems/[string id]() returns ExpenseItem|Error

function get expensecategories(ExpenseCategoryTargetType targetType, ParameterizedQuery whereClause, ParameterizedQuery orderByClause, ParameterizedQuery limitClause, ParameterizedQuery groupByClause) returns stream<targetType, Error?>

function get expensecategories/[string id](ExpenseCategoryTargetType targetType) returns targetType|Error

function post expensecategories(ExpenseCategoryInsert[] data) returns string[]|Error

function put expensecategories/[string id](ExpenseCategoryUpdate value) returns ExpenseCategory|Error

function delete expensecategories/[string id]() returns ExpenseCategory|Error

function get categorybudgets(CategoryBudgetTargetType targetType, ParameterizedQuery whereClause, ParameterizedQuery orderByClause, ParameterizedQuery limitClause, ParameterizedQuery groupByClause) returns stream<targetType, Error?>

function get categorybudgets/[string id](CategoryBudgetTargetType targetType) returns targetType|Error

function post categorybudgets(CategoryBudgetInsert[] data) returns string[]|Error

function put categorybudgets/[string id](CategoryBudgetUpdate value) returns CategoryBudget|Error

function delete categorybudgets/[string id]() returns CategoryBudget|Error

function close() returns Error?