Page Contents
Home > @loopback/sequelize > SequelizeDataSource > execute
SequelizeDataSource.execute() method
Execute a SQL command.
**WARNING:** In general, it is always better to perform database actions through repository methods. Directly executing SQL may lead to unexpected results, corrupted data, security vulnerabilities and other issues.
Signature:
execute(command: Command, parameters?: NamedParameters | PositionalParameters, options?: Options): Promise<AnyObject>;
Parameters
| Parameter | Type | Description |
|---|---|---|
| command | Command | A parameterized SQL command or query. |
| parameters | NamedParameters | PositionalParameters | (Optional) List of parameter values to use. |
| options | Options | (Optional) Additional options, for example transaction. |
Returns:
Promise<AnyObject>
A promise which resolves to the command output. The output type (data structure) is database specific and often depends on the command executed.
Example
// MySQL
const result = await db.execute(
'SELECT * FROM Products WHERE size > ?',
[42]
);
// PostgreSQL
const result = await db.execute(
'SELECT * FROM Products WHERE size > $1',
[42]
);