Product
Introducing License Enforcement in Socket
Ensure open-source compliance with Socket’s License Enforcement Beta. Set up your License Policy and secure your software!
@sap/cds-ql
Advanced tools
This package deals with creating a pool of connection clients, connecting to a driver (read: db) and using these connection clients from the pool to insert, delete, select and update values or rows from a specific table. Performing these insert, delete,
This package deals with creating a pool of connection clients, connecting to a driver (read: db) and using these connection clients from the pool to insert, delete, select and update values or rows from a specific table. Performing these insert, delete, select and update operations also includes executing embedded queries and plain statements.
TBD
npm install
Following is an example of how to set up a connection pool by specifying the maximum and minimum number of connections and a connection by specifying host, port, user and password. These connect options can be client specific. For example SAP Hana might include certificate and schema, while others like SQLite have neither.
cds.connect({
kind: 'hana',
pool: {
min: 1,
max: 100
},
credentials: {
host: 'hana.tld',
port: 39015,
user: 'TECHNICAL_USER',
password: 'VerySecure'
}
})
Following is an example of a basic SELECT statement:
SELECT.from('Authors')
Following is an example of a basic INSERT statement:
INSERT.into('Authors')
.rows([ 1, 'Wuthering Heights' ])
Following is an example of a basic UPDATE statement:
UPDATE('Authors')
.set({NAME: 'Jon Doe', STOCK: 123})
Following is an example of a basic DELETE statement:
DELETE.from('Authors')
FAQs
The `@sap/cds-runtime` module is the successor of `@sap/cds-ql`. Please note that future development and bug fixes will be provided in the `@sap/cds-runtime` module only.
The npm package @sap/cds-ql receives a total of 9 weekly downloads. As such, @sap/cds-ql popularity was classified as not popular.
We found that @sap/cds-ql demonstrated a not healthy version release cadence and project activity because the last version was released a year ago. It has 1 open source maintainer collaborating on the project.
Did you know?
Socket for GitHub automatically highlights issues in each pull request and monitors the health of all your open source dependencies. Discover the contents of your packages and block harmful activity before you install or update your dependencies.
Product
Ensure open-source compliance with Socket’s License Enforcement Beta. Set up your License Policy and secure your software!
Product
We're launching a new set of license analysis and compliance features for analyzing, managing, and complying with licenses across a range of supported languages and ecosystems.
Product
We're excited to introduce Socket Optimize, a powerful CLI command to secure open source dependencies with tested, optimized package overrides.