# @qorebase/cli > qore cli Latest version **1.0.12** (published 2022-11-28) · MIT license · 0 weekly downloads ## Install ```sh npm install @qorebase/cli pnpm add @qorebase/cli yarn add @qorebase/cli bun add @qorebase/cli ``` Provides the command `qore`. ## Health **Score 25/100 (F)** — status: abandoned. Positive: has types; no vulnerabilities; high quality score. Warnings: low downloads; no esm support. Negative: abandoned; low maintenance score. ## Facts | | | |---|---| | Version | 1.0.12 | | Published | 2022-11-28 | | First published | 2022-03-16 | | Weekly downloads | 0 | | License | MIT | | TypeScript types | bundled | | Module format | CommonJS | | Node | >=8.0.0 | | Dependencies | 33 | | Unpacked size | 332 KB | | Known vulnerabilities | 0 (+29 in 2 direct dependencies) | | Install scripts | no | | Maintainers | ajudan | | Keywords | oclif | ## Links - npm: https://www.npmjs.com/package/@qorebase/cli - Repository: https://github.com/rrmdn/cli - Issues: https://github.com/rrmdn/cli/issues - npm.io page: https://npm.io/package/@qorebase/cli ## Dependencies (33) - [conf](https://npm.io/package/conf.md) ^7.1.2 - [nixt](https://npm.io/package/nixt.md) ^0.5.1 - [voca](https://npm.io/package/voca.md) ^1.4.0 - [axios](https://npm.io/package/axios.md) ^0.21.0 - [chalk](https://npm.io/package/chalk.md) ^4.1.2 - [debug](https://npm.io/package/debug.md) ^4.3.1 - [listr](https://npm.io/package/listr.md) ^0.14.3 - [tslib](https://npm.io/package/tslib.md) ^1 - [wonka](https://npm.io/package/wonka.md) ^4.0.15 - [cli-ux](https://npm.io/package/cli-ux.md) ^5.5.1 - [prompts](https://npm.io/package/prompts.md) ^2.4.0 - [fs-extra](https://npm.io/package/fs-extra.md) ^9.0.1 - [inquirer](https://npm.io/package/inquirer.md) ^8.2.0 - [node-dir](https://npm.io/package/node-dir.md) ^0.1.17 - [prettier](https://npm.io/package/prettier.md) ^2.2.1 - [sequency](https://npm.io/package/sequency.md) ^0.19.2 - [simple-git](https://npm.io/package/simple-git.md) ^2.31.0 - [@types/conf](https://npm.io/package/@types/conf.md) ^3.0.0 - [@types/voca](https://npm.io/package/@types/voca.md) ^1.4.0 - [chalk-table](https://npm.io/package/chalk-table.md) ^1.0.2 - [@sentry/node](https://npm.io/package/@sentry/node.md) ^5.29.2 - [@types/debug](https://npm.io/package/@types/debug.md) ^4.1.5 - [@types/listr](https://npm.io/package/@types/listr.md) ^0.14.4 - [@oclif/config](https://npm.io/package/@oclif/config.md) ^1 - [@qorebase/sdk](https://npm.io/package/@qorebase/sdk.md) ^1.0.8 - [@oclif/command](https://npm.io/package/@oclif/command.md) ^1 - [@types/prompts](https://npm.io/package/@types/prompts.md) ^2.0.9 - [@sentry/tracing](https://npm.io/package/@sentry/tracing.md) ^5.29.2 - [@types/fs-extra](https://npm.io/package/@types/fs-extra.md) ^9.0.5 - [@types/inquirer](https://npm.io/package/@types/inquirer.md) ^8.1.3 - [@types/node-dir](https://npm.io/package/@types/node-dir.md) ^0.0.33 - [@oclif/plugin-help](https://npm.io/package/@oclif/plugin-help.md) ^3 - [@sentry/integrations](https://npm.io/package/@sentry/integrations.md) ^6.2.5 ## Alternatives - [@salesforce/cli](https://npm.io/package/@salesforce/cli.md) — 389.7K weekly downloads - [@mintlify/cli](https://npm.io/package/@mintlify/cli.md) — 208.9K weekly downloads - [@grafana/e2e-selectors](https://npm.io/package/@grafana/e2e-selectors.md) — 128.7K weekly downloads - [mintlify](https://npm.io/package/mintlify.md) — 112.0K weekly downloads - [@intlayer/cli](https://npm.io/package/@intlayer/cli.md) — 22.8K weekly downloads ## Recent versions - 1.0.12 (latest) — 2022-11-28 - 1.0.11 — 2022-11-17 - 1.0.9 — 2022-07-18 - 1.0.8 — 2022-07-05 - 1.0.7 — 2022-06-16 - 1.0.6 — 2022-04-07 - 1.0.5 — 2022-04-07 - 1.0.4 — 2022-04-05 - 1.0.3 — 2022-03-29 - 1.0.1 — 2022-03-16 ## README @qore/cli ========= qore cli [![oclif](https://img.shields.io/badge/cli-oclif-brightgreen.svg)](https://oclif.io) [![Version](https://img.shields.io/npm/v/@qore/cli.svg)](https://npmjs.org/package/@qore/cli) [![Downloads/week](https://img.shields.io/npm/dw/@qore/cli.svg)](https://npmjs.org/package/@qore/cli) [![License](https://img.shields.io/npm/l/@qore/cli.svg)](https://github.com/rrmdn/cli/blob/master/package.json) * [Usage](#usage) * [Commands](#commands) # Usage ```sh-session $ npm install -g @qorebase/cli $ qore COMMAND running command... $ qore (-v|--version|version) @qorebase/cli/1.0.12 linux-x64 node-v18.12.1 $ qore --help [COMMAND] USAGE $ qore COMMAND ... ``` # Commands * [`qore alter-column [FORMERNAME] [NEWNAME]`](#qore-alter-column-formername-newname) * [`qore alter-permission`](#qore-alter-permission) * [`qore alter-role [FORMERNAME] [NEWNAME]`](#qore-alter-role-formername-newname) * [`qore alter-table [FORMERNAME] [NEWNAME]`](#qore-alter-table-formername-newname) * [`qore codegen`](#qore-codegen) * [`qore context`](#qore-context) * [`qore create-column`](#qore-create-column) * [`qore create-permission`](#qore-create-permission) * [`qore create-relation [RELATIONTYPE] [TABLEORIGIN] [TABLETARGET]`](#qore-create-relation-relationtype-tableorigin-tabletarget) * [`qore create-roles [ROLES]`](#qore-create-roles-roles) * [`qore create-tables [TABLESNAME]`](#qore-create-tables-tablesname) * [`qore drop-columns [COLUMNSNAME]`](#qore-drop-columns-columnsname) * [`qore drop-permission [ACTION]`](#qore-drop-permission-action) * [`qore drop-relation [RELATIONTYPE] [TABLEORIGIN/TABLEONE] [TABLETARGET/TABLEMANY]`](#qore-drop-relation-relationtype-tableorigintableone-tabletargettablemany) * [`qore drop-roles [ROLES]`](#qore-drop-roles-roles) * [`qore drop-tables [TABLESNAME]`](#qore-drop-tables-tablesname) * [`qore export-schema`](#qore-export-schema) * [`qore help [COMMAND]`](#qore-help-command) * [`qore import-schema`](#qore-import-schema) * [`qore login`](#qore-login) * [`qore logout`](#qore-logout) * [`qore open-dashboard`](#qore-open-dashboard) * [`qore open-doc`](#qore-open-doc) * [`qore ping`](#qore-ping) * [`qore read-migrations`](#qore-read-migrations) * [`qore rollback [STEPS]`](#qore-rollback-steps) * [`qore select [TABLENAME]`](#qore-select-tablename) ## `qore alter-column [FORMERNAME] [NEWNAME]` Rename column from specific table ``` USAGE $ qore alter-column [FORMERNAME] [NEWNAME] OPTIONS --table=table (required) tableName EXAMPLES $ qore alter-column formerName newName --table tableName ``` _See code: [src/commands/alter-column.ts](https://github.com/rrmdn/cli/blob/v1.0.12/src/commands/alter-column.ts)_ ## `qore alter-permission` Change condition in permissions table for specific role ``` USAGE $ qore alter-permission OPTIONS --action=action (required) action --condition=condition (required) condition --role=role (required) roleName --tables=tables (required) tables EXAMPLES $ qore alter-permission --role users --action select --condition '{"$and": [ { "title": { "$eq": "sleeping" } } ]}' --tables all $ qore alter-permission --role users --action delete --condition '{"$and": [ { "title": { "$eq": "add fitur login" } } ]}' --tables todos,projects ``` _See code: [src/commands/alter-permission.ts](https://github.com/rrmdn/cli/blob/v1.0.12/src/commands/alter-permission.ts)_ ## `qore alter-role [FORMERNAME] [NEWNAME]` Rename specific role ``` USAGE $ qore alter-role [FORMERNAME] [NEWNAME] EXAMPLE $ qore alter-role formerName newName ``` _See code: [src/commands/alter-role.ts](https://github.com/rrmdn/cli/blob/v1.0.12/src/commands/alter-role.ts)_ ## `qore alter-table [FORMERNAME] [NEWNAME]` Rename specific table ``` USAGE $ qore alter-table [FORMERNAME] [NEWNAME] EXAMPLE $ qore alter-table formerName newName ``` _See code: [src/commands/alter-table.ts](https://github.com/rrmdn/cli/blob/v1.0.12/src/commands/alter-table.ts)_ ## `qore codegen` Generate qore project files ``` USAGE $ qore codegen OPTIONS --adminSecret=adminSecret admin secret --path=path path --url=url project url EXAMPLE $ qore codegen --project projectId --org orgId ``` _See code: [src/commands/codegen.ts](https://github.com/rrmdn/cli/blob/v1.0.12/src/commands/codegen.ts)_ ## `qore context` Set base url for project access ``` USAGE $ qore context EXAMPLE $ qore set-url ``` _See code: [src/commands/context.ts](https://github.com/rrmdn/cli/blob/v1.0.12/src/commands/context.ts)_ ## `qore create-column` Create new columns in specific table ``` USAGE $ qore create-column EXAMPLE $ qore create-column ``` _See code: [src/commands/create-column.ts](https://github.com/rrmdn/cli/blob/v1.0.12/src/commands/create-column.ts)_ ## `qore create-permission` Create permission for specific role in specific tables ``` USAGE $ qore create-permission OPTIONS --actions=actions (required) actions --condition=condition condition --role=role (required) roleName --tables=tables (required) tables EXAMPLE $ qore create-permission --role users --tables todos,projects --actions select,delete --condition '{"$and": []}' ``` _See code: [src/commands/create-permission.ts](https://github.com/rrmdn/cli/blob/v1.0.12/src/commands/create-permission.ts)_ ## `qore create-relation [RELATIONTYPE] [TABLEORIGIN] [TABLETARGET]` Create relation 1:m for one-to-many or m:n for many-to-many relation ``` USAGE $ qore create-relation [RELATIONTYPE] [TABLEORIGIN] [TABLETARGET] OPTIONS --relation=relation relationName EXAMPLE $ qore create-relation relationType tableOrigin tableTarget --relation personTodo ``` _See code: [src/commands/create-relation.ts](https://github.com/rrmdn/cli/blob/v1.0.12/src/commands/create-relation.ts)_ ## `qore create-roles [ROLES]` Create new roles ``` USAGE $ qore create-roles [ROLES] EXAMPLE $ qore create-roles user,engineer ``` _See code: [src/commands/create-roles.ts](https://github.com/rrmdn/cli/blob/v1.0.12/src/commands/create-roles.ts)_ ## `qore create-tables [TABLESNAME]` Create tables ``` USAGE $ qore create-tables [TABLESNAME] ARGUMENTS TABLESNAME list of table name EXAMPLES $ qore create-tables todos $ qore create-tables todos,projects ``` _See code: [src/commands/create-tables.ts](https://github.com/rrmdn/cli/blob/v1.0.12/src/commands/create-tables.ts)_ ## `qore drop-columns [COLUMNSNAME]` Drop columns from specific table ``` USAGE $ qore drop-columns [COLUMNSNAME] ARGUMENTS COLUMNSNAME list of column name OPTIONS --table=table (required) tableName EXAMPLE $ qore drop-columns title,status --table todos ``` _See code: [src/commands/drop-columns.ts](https://github.com/rrmdn/cli/blob/v1.0.12/src/commands/drop-columns.ts)_ ## `qore drop-permission [ACTION]` Drop action permission for role in tables ``` USAGE $ qore drop-permission [ACTION] ARGUMENTS ACTION actionName OPTIONS --role=role (required) roleName --tables=tables (required) tables EXAMPLES $ qore drop-permission select --role user --tables all $ qore drop-permission delete --role user --tables todos,projects ``` _See code: [src/commands/drop-permission.ts](https://github.com/rrmdn/cli/blob/v1.0.12/src/commands/drop-permission.ts)_ ## `qore drop-relation [RELATIONTYPE] [TABLEORIGIN/TABLEONE] [TABLETARGET/TABLEMANY]` Drop relation column in 1:m or drop junction table if m:n relation ``` USAGE $ qore drop-relation [RELATIONTYPE] [TABLEORIGIN/TABLEONE] [TABLETARGET/TABLEMANY] OPTIONS --relation=relation (required) relationName EXAMPLES $ qore drop-relation 1:m tableOrigin/tableOne tableTarget/tableMany --relation personTodo $ qore drop-relation m:n tableOrigin/tableOne tableTarget/tableMany --relation personProject ``` _See code: [src/commands/drop-relation.ts](https://github.com/rrmdn/cli/blob/v1.0.12/src/commands/drop-relation.ts)_ ## `qore drop-roles [ROLES]` Drop some roles ``` USAGE $ qore drop-roles [ROLES] ARGUMENTS ROLES list role name EXAMPLES $ qore drop-roles users,engineer $ qore drop-roles developer ``` _See code: [src/commands/drop-roles.ts](https://github.com/rrmdn/cli/blob/v1.0.12/src/commands/drop-roles.ts)_ ## `qore drop-tables [TABLESNAME]` Drop specific table ``` USAGE $ qore drop-tables [TABLESNAME] ARGUMENTS TABLESNAME list of table name EXAMPLES $ qore drop-tables todos $ qore drop-tables todos,projects ``` _See code: [src/commands/drop-tables.ts](https://github.com/rrmdn/cli/blob/v1.0.12/src/commands/drop-tables.ts)_ ## `qore export-schema` Populate json file for all migrations process ``` USAGE $ qore export-schema OPTIONS --location=location [default: migrations] fileLocation EXAMPLE $ qore export-schema --location migrations ``` _See code: [src/commands/export-schema.ts](https://github.com/rrmdn/cli/blob/v1.0.12/src/commands/export-schema.ts)_ ## `qore help [COMMAND]` display help for qore ``` USAGE $ qore help [COMMAND] ARGUMENTS COMMAND command to show help for OPTIONS --all see all commands in CLI ``` _See code: [@oclif/plugin-help](https://github.com/oclif/plugin-help/blob/v3.3.1/src/commands/help.ts)_ ## `qore import-schema` Import-schema in specific folder for other database architecture ``` USAGE $ qore import-schema OPTIONS -l, --location=location [default: migrations] fileLocation EXAMPLE $ qore import-schema --location ``` _See code: [src/commands/import-schema.ts](https://github.com/rrmdn/cli/blob/v1.0.12/src/commands/import-schema.ts)_ ## `qore login` Login to qore cli ``` USAGE $ qore login OPTIONS --adminSecret=adminSecret admin secret --url=url url EXAMPLE $ qore login ``` _See code: [src/commands/login.ts](https://github.com/rrmdn/cli/blob/v1.0.12/src/commands/login.ts)_ ## `qore logout` Logout from qore cli ``` USAGE $ qore logout EXAMPLE $ qore logout ``` _See code: [src/commands/logout.ts](https://github.com/rrmdn/cli/blob/v1.0.12/src/commands/logout.ts)_ ## `qore open-dashboard` Open project dashboard on browser ``` USAGE $ qore open-dashboard EXAMPLE $ qore open-dashboard ``` _See code: [src/commands/open-dashboard.ts](https://github.com/rrmdn/cli/blob/v1.0.12/src/commands/open-dashboard.ts)_ ## `qore open-doc` Open project doc on browser ``` USAGE $ qore open-doc EXAMPLE $ qore open-doc ``` _See code: [src/commands/open-doc.ts](https://github.com/rrmdn/cli/blob/v1.0.12/src/commands/open-doc.ts)_ ## `qore ping` Ping ``` USAGE $ qore ping EXAMPLE $ qore ping ``` _See code: [src/commands/ping.ts](https://github.com/rrmdn/cli/blob/v1.0.12/src/commands/ping.ts)_ ## `qore read-migrations` Read/see migrations histories ``` USAGE $ qore read-migrations OPTIONS --limit=limit limit --offset=offset offset EXAMPLE $ qore read-migrations --limit 0 --offset 0 ``` _See code: [src/commands/read-migrations.ts](https://github.com/rrmdn/cli/blob/v1.0.12/src/commands/read-migrations.ts)_ ## `qore rollback [STEPS]` Rollback to previous migration ``` USAGE $ qore rollback [STEPS] ARGUMENTS STEPS Number of Rollbacks EXAMPLE $ qore rollback 10 ``` _See code: [src/commands/rollback.ts](https://github.com/rrmdn/cli/blob/v1.0.12/src/commands/rollback.ts)_ ## `qore select [TABLENAME]` Get all rows from specific table ``` USAGE $ qore select [TABLENAME] OPTIONS -x, --extended show extra columns --columns=columns only show provided columns (comma-separated) --csv output is csv format [alias: --output=csv] --filter=filter filter property by partial string matching, ex: name=foo --no-header hide table header from output --no-truncate do not truncate output to fit screen --output=csv|json|yaml output in a more machine friendly format --sort=sort property to sort by (prepend '-' for descending) EXAMPLE $ qore select tableName ``` _See code: [src/commands/select.ts](https://github.com/rrmdn/cli/blob/v1.0.12/src/commands/select.ts)_ --- _Source: https://npm.io/package/@qorebase/cli · Machine-readable twin of the npm.io package page. Health data is recomputed on every publish._