Db.insertRow
Db.insertRow($table, $rowMap) -> null
Description
Insert a row into a table, where each Map key corresponds to a table column.
$row = {
name: 'Ann'
role: 'Analyst'
createDate: Date.now()
}
Db.insertRow('users', $row)
// Runs query:
// INSERT INTO users (name, role, createDate)
// VALUES ("Ann", "Analyst", "2021-03-23 16:38:11")
Object Values
If an inserted value is an object, it will try to convert it to a string based on its type.
| Type | Conversion |
|---|---|
| Date | $date.format('sql') |
| Password | $password.hash() |
| Other | $object.onToSqlString() (default: toString()) |