This example depends on the ProductAutoInc class that maps to a database table. This class contains several properties that map to the database, as well as some methods that alter those properties. The ID property attribute is the primary key and it is set to AutoIncrement.
classdef ProductAutoInc < database.orm.mixin.Mappable
properties(PrimaryKey, ColumnName = "ProductNumber", AutoIncrement)
ID int32
end
properties
Name string
Description string
Quantity int32
end
properties(ColumnName = "UnitCost")
CostPerItem int32
end
properties(ColumnName = "Manufacturer")
Supplier string
end
properties(ColumnType = "date")
InventoryDate datetime
end
methods
function obj = ProductAutoInc(name,description,supplier,cost,quantity,inventoryDate)
if nargin ~= 0
inputElements = numel(name);
if numel(description) ~= inputElements || ...
numel(supplier) ~= inputElements || ...
numel(cost) ~= inputElements || ...
numel(quantity) ~= inputElements || ...
numel(inventoryDate) ~= inputElements
error('All inputs must have the same number of elements')
end
% Preallocate by creating the last object first
obj(inputElements).Name = name(inputElements);
obj(inputElements).Description = description(inputElements);
obj(inputElements).Supplier = supplier(inputElements);
obj(inputElements).CostPerItem = cost(inputElements);
obj(inputElements).Quantity = quantity(inputElements);
obj(inputElements).InventoryDate = inventoryDate(inputElements);
for n = 1:inputElements-1
% Fill in the rest of the objects
obj(n).Name = name(n);
obj(n).Description = description(n);
obj(n).Supplier = supplier(n);
obj(n).CostPerItem = cost(n);
obj(n).Quantity = quantity(n);
obj(n).InventoryDate = inventoryDate(n);
end
end
end
function obj = adjustPrice(obj,amount)
arguments
obj (1,1) Product
amount (1,1) {mustBeNumeric}
end
obj.CostPerItem = obj.CostPerItem + amount;
end
function obj = shipProduct(obj,amount)
arguments
obj (1,1) Product
amount (1,1) {mustBePositive,mustBeInteger}
end
obj.Quantity = obj.Quantity - amount;
end
function obj = receiveProduct(obj,amount)
arguments
obj (1,1) Product
amount (1,1) {mustBePositive,mustBeInteger}
end
obj.Quantity = obj.Quantity + amount;
obj.InventoryDate = datetime('today');
end
end
end
First, create an sqlite database file that does not require a connection to a live database.
Create a ProductAutoInc object and store it on the database using the ormwrite function. You can return the object to the workspace by using the optional output argument.
obj =
ProductAutoInc with properties:
ID: []
Name: "Toy1"
Description: "Descr1"
Quantity: 100
CostPerItem: 19
Supplier: "CompanyA"
InventoryDate: 05-Jul-2023
obj =
ProductAutoInc with properties:
ID: 1
Name: "Toy1"
Description: "Descr1"
Quantity: 100
CostPerItem: 19
Supplier: "CompanyA"
InventoryDate: 05-Jul-2023
In this example, the ID property of the output object has a value of 1. Use the sqlread function to read the table and verify that the database automatically filled in the primary key value.
ans=1×7 table
ProductNumber Name Description Quantity UnitCost Manufacturer InventoryDate
_____________ ______ ___________ ________ ________ ____________ ____________________________
1 "Toy1" "Descr1" 100 19 "CompanyA" "2023-07-05 00:00:00.000000"
Instantiate a ProductAutoInc class with an array of objects with the ID property attribute chosen as the primary key and set it to AutoIncrement. The ID property is initially empty for all products.
products=1×3 ProductAutoInc array with properties:
ID
Name
Description
Quantity
CostPerItem
Supplier
InventoryDate
IDS =
0x0 empty int32 matrix
Store the array of objects on the database using the ormwrite function and verify that the database automatically fills in the IDs.
products=1×3 ProductAutoInc array with properties:
ID
Name
Description
Quantity
CostPerItem
Supplier
InventoryDate
IDS = 1x3 int32 row vector
2 3 4
