Project

Namespaces

Public Vars

remys.api.resources.queries

count-records
(count-records table)
Return the number of records in `table`.

count-records-with-fields-and-like
(count-records-with-fields-and-like table fields like)
Return the number of records in `table` filter by `fields` with `like`.

describe-table
(describe-table schema table)
Describe the `table` in `schema`.

execute-query
(execute-query query)(execute-query query params)
Execute `query` with `params`, if they are present.

max-size
The larger size to be used as limit size in a MySQL select query.
See: https://dev.mysql.com/doc/refman/5.7/en/select.html
primary-key
(primary-key schema table)
Find the primary key of `table`.

query-all
(query-all table)
Select all columns of all the records in `table`.

query-by-composite-key
(query-by-composite-key schema table ids)
Query the `table` in `schema` using its composite primary key `ids`.
`ids` is a string where the values are separated by three underscores.
query-by-composite-key-and-fields
(query-by-composite-key-and-fields schema table ids fields)
Select `fields` from `table` in `schema` using its composite key `ids`.
`ids` is a string where the values are separated by three underscores.
query-by-fields
(query-by-fields table fields)
Query `table` selecting only the given `fields`.
`fields` is a string with comma-separated values.
query-by-fields-and-like
(query-by-fields-and-like table fields like)
Query `table` selecting only `fields` with a `like` in the where clause.
`fields` is a string with comma-separated values.
query-by-fields-and-offset
(query-by-fields-and-offset table fields offset)
Query `table` selecting only the given `fields` and `offset`.
`fields` is a string with comma-separated values.
query-by-fields-and-size
(query-by-fields-and-size table fields size)
Query `table` selecting only the given `fields` and `size`.
`fields` is a string with comma-separated values.
query-by-fields-like-and-offset
(query-by-fields-like-and-offset table fields like offset)
Query `table` selecting only the given `fields` and `offset` with `like`.
`fields` is a string with comma-separated values.
query-by-fields-like-and-size
(query-by-fields-like-and-size table fields like size)
Query `table` selecting only the given `fields` and `size` with `like`.
`fields` is a string with comma-separated values.
query-by-fields-like-size-and-offset
(query-by-fields-like-size-and-offset table fields like size offset)
Query `table` selecting the given `fields`, `size` and `offset` with `like`.
`fields` is a string with comma-separated values.
query-by-fields-size-and-offset
(query-by-fields-size-and-offset table fields size offset)
Query `table` selecting only the given `fields`, `size` and `offset`.
`fields` is a string with comma-separated values.
query-by-key
(query-by-key schema table id)
Query `table` in `schema` by its primary key `id`.

query-by-key-and-fields
(query-by-key-and-fields schema table id fields)
Select `fields` from `table` in `schema` by its primary key `id`.

query-by-offset
(query-by-offset table offset)
Query `table` from the given `offset`.

query-by-size
(query-by-size table size)
Query `table` selecting `size` records.

show-tables
(show-tables schema)
Show all the tables in `schema`.

update-table
(update-table schema table id params)
Update `table` in `schema`, setting the values in `params` on the record
identified by the primary key `id`.