Module
expensetracker.dbmodel
Module expensetracker.dbmodel
API
Definitions
samjs/expensetracker.dbmodel
Deprecated1.0.0
This package does not have any public APIs.
Functions
main
function main()
Clients
expensetracker.dbmodel: Client
Isolated
queryNativeSQL
Isolated FunctionRemote Function
function queryNativeSQL(ParameterizedQuery sqlQuery, typedesc<record {}> rowType) returns stream<rowType, Error?>
executeNativeSQL
Isolated FunctionRemote Function
function executeNativeSQL(ParameterizedQuery sqlQuery) returns ExecutionResult|Error
Parameters
- sqlQuery ParameterizedQuery -
get expenseitems
Isolated FunctionResource Function
function get expenseitems(ExpenseItemTargetType targetType, ParameterizedQuery whereClause, ParameterizedQuery orderByClause, ParameterizedQuery limitClause, ParameterizedQuery groupByClause) returns stream<targetType, Error?>
Parameters
- targetType ExpenseItemTargetType (default <>) -
- whereClause ParameterizedQuery (default ``) -
- orderByClause ParameterizedQuery (default ``) -
- limitClause ParameterizedQuery (default ``) -
- groupByClause ParameterizedQuery (default ``) -
get expenseitems/[string id]
Isolated FunctionResource Function
function get expenseitems/[string id](ExpenseItemTargetType targetType) returns targetType|Error
Parameters
- targetType ExpenseItemTargetType (default <>) -
post expenseitems
Isolated FunctionResource Function
function post expenseitems(ExpenseItemInsert[] data) returns string[]|Error
Parameters
- data ExpenseItemInsert[] -
put expenseitems/[string id]
Isolated FunctionResource Function
function put expenseitems/[string id](ExpenseItemUpdate value) returns ExpenseItem|Error
Parameters
- value ExpenseItemUpdate -
delete expenseitems/[string id]
Isolated FunctionResource Function
function delete expenseitems/[string id]() returns ExpenseItem|Error
get expensecategories
Isolated FunctionResource Function
function get expensecategories(ExpenseCategoryTargetType targetType, ParameterizedQuery whereClause, ParameterizedQuery orderByClause, ParameterizedQuery limitClause, ParameterizedQuery groupByClause) returns stream<targetType, Error?>
Parameters
- targetType ExpenseCategoryTargetType (default <>) -
- whereClause ParameterizedQuery (default ``) -
- orderByClause ParameterizedQuery (default ``) -
- limitClause ParameterizedQuery (default ``) -
- groupByClause ParameterizedQuery (default ``) -
get expensecategories/[string id]
Isolated FunctionResource Function
function get expensecategories/[string id](ExpenseCategoryTargetType targetType) returns targetType|Error
Parameters
- targetType ExpenseCategoryTargetType (default <>) -
post expensecategories
Isolated FunctionResource Function
function post expensecategories(ExpenseCategoryInsert[] data) returns string[]|Error
Parameters
- data ExpenseCategoryInsert[] -
put expensecategories/[string id]
Isolated FunctionResource Function
function put expensecategories/[string id](ExpenseCategoryUpdate value) returns ExpenseCategory|Error
Parameters
- value ExpenseCategoryUpdate -
delete expensecategories/[string id]
Isolated FunctionResource Function
function delete expensecategories/[string id]() returns ExpenseCategory|Error
get categorybudgets
Isolated FunctionResource Function
function get categorybudgets(CategoryBudgetTargetType targetType, ParameterizedQuery whereClause, ParameterizedQuery orderByClause, ParameterizedQuery limitClause, ParameterizedQuery groupByClause) returns stream<targetType, Error?>
Parameters
- targetType CategoryBudgetTargetType (default <>) -
- whereClause ParameterizedQuery (default ``) -
- orderByClause ParameterizedQuery (default ``) -
- limitClause ParameterizedQuery (default ``) -
- groupByClause ParameterizedQuery (default ``) -
get categorybudgets/[string id]
Isolated FunctionResource Function
function get categorybudgets/[string id](CategoryBudgetTargetType targetType) returns targetType|Error
Parameters
- targetType CategoryBudgetTargetType (default <>) -
post categorybudgets
Isolated FunctionResource Function
function post categorybudgets(CategoryBudgetInsert[] data) returns string[]|Error
Parameters
- data CategoryBudgetInsert[] -
put categorybudgets/[string id]
Isolated FunctionResource Function
function put categorybudgets/[string id](CategoryBudgetUpdate value) returns CategoryBudget|Error
Parameters
- value CategoryBudgetUpdate -
delete categorybudgets/[string id]
Isolated FunctionResource Function
function delete categorybudgets/[string id]() returns CategoryBudget|Error
close
Isolated Function
function close() returns Error?
Records
expensetracker.dbmodel: CategoryBudget
Closed record
Fields
- idreadonly string -
- categorybudgetId string -
- amount decimal -
- year string -
- month string -
expensetracker.dbmodel: CategoryBudgetOptionalized
Closed record
Fields
- id string? -
- categorybudgetId string? -
- amount decimal? -
- year string? -
- month string? -
expensetracker.dbmodel: CategoryBudgetUpdate
Closed record
Fields
- categorybudgetId string? -
- amount decimal? -
- year string? -
- month string? -
expensetracker.dbmodel: CategoryBudgetWithRelations
Closed record
Fields
- Fields Included from * CategoryBudgetOptionalized
- category ExpenseCategoryOptionalized? -
expensetracker.dbmodel: ExpenseCategory
Closed record
Fields
- idreadonly string -
- name string -
- description string -
expensetracker.dbmodel: ExpenseCategoryOptionalized
Closed record
Fields
- id string? -
- name string? -
- description string? -
expensetracker.dbmodel: ExpenseCategoryUpdate
Closed record
Fields
- name string? -
- description string? -
expensetracker.dbmodel: ExpenseCategoryWithRelations
Closed record
Fields
- Fields Included from * ExpenseCategoryOptionalized
- categoryBudget CategoryBudgetOptionalized? -
- expenseItems ExpenseItemOptionalized[]? -
expensetracker.dbmodel: ExpenseItem
Closed record
Fields
- idreadonly string -
- description string -
- amount decimal -
- dateTime Civil -
- comment string -
- createdAt Utc -
- updatedAt Utc -
- categoryId string -
expensetracker.dbmodel: ExpenseItemOptionalized
Closed record
Fields
- id string? -
- description string? -
- amount decimal? -
- dateTime Civil? -
- comment string? -
- createdAt Utc? -
- updatedAt Utc? -
- categoryId string? -
expensetracker.dbmodel: ExpenseItemUpdate
Closed record
Fields
- description string? -
- amount decimal? -
- dateTime Civil? -
- comment string? -
- createdAt Utc? -
- updatedAt Utc? -
- categoryId string? -
expensetracker.dbmodel: ExpenseItemWithRelations
Closed record
Fields
- Fields Included from * ExpenseItemOptionalized
- category ExpenseCategoryOptionalized? -
Type descriptor types
expensetracker.dbmodel: ExpenseItemTargetType
ExpenseItemTargetType
expensetracker.dbmodel: ExpenseCategoryTargetType
ExpenseCategoryTargetType
expensetracker.dbmodel: CategoryBudgetTargetType
CategoryBudgetTargetType
Simple name reference types
expensetracker.dbmodel: ExpenseItemInsert
ExpenseItemInsert
expensetracker.dbmodel: ExpenseCategoryInsert
ExpenseCategoryInsert
expensetracker.dbmodel: CategoryBudgetInsert
CategoryBudgetInsert
Import
import samjs/expensetracker.dbmodel;
Metadata
Released date: about 1 month ago
Version: 1.0.0
Compatibility
Platform: java17
Ballerina version: 2201.8.5
GraalVM compatible: Yes
Pull count
Total: 18
Current verison: 2
Weekly downloads
Other versions
1.0.0