Insert Operations
The insert function Database.insert() inserts an object and its concept properties (if any) recursively into the database.
You can insert all related objects at once instead of performing individual inserts. The join keys are internally managed.
In the case of concept references, foreign keys in the referencing concept are updated with primary keys in the referenced concept.
In the case of contained concept properties, foreign keys in the contained concept are updated with primary keys in the container concept.
If columns in the database are modified by the database during inserts, these changes are also made in the concept instances. This is usually the case when primary keys are automatically generated or when columns have default values.
- Using Generated Unique Primary Keys for Inserts
Many database products provide a mechanism for generating unique primary keys.
Copyright © Cloud Software Group, Inc. All rights reserved.