Set record (ZeyOS)

Anatomy

<db:set var="var" var_data="var" entity="string" id="(new)">
    ixml
</db:set>

Parents: db:connection

Description: DB:SET sets a database record, specified by an entity and an ID.

Attributes

Name	Type	Description	Defined By
var	var	Result variable name for insert ID	db:set
var_data	var	Variable name for associated field name and value pairs	db:set
entity	string	Entity	db:set
id	int	ID	db:set

Results:

Binding	Type	Predicate
var	int	N/A

Examples

Insert record

<db:set entity="contacts">
  <db:data field="lastname">Gates</db:data>
  <db:data field="firstname">Bill</db:data>
</db:set>

Update record

<db:set entity="contacts" id="123">
  <db:data field="lastname">Jobs</db:data>
  <db:data field="firstname">Steve</db:data>
</db:set>

Get and set record

<db:get var="obj" entity="contacts" id="123">
  <db:field>lastname</db:field>
</db:get>

<if value1="$obj.lastname" func="=" value2="Gates">
  <set var="obj.lastname">Jobs</set>
  <set var="obj.firstname">Steve</set>
</if>

<db:set entity="contacts" id="123" var_data="obj"/>