# qbql

> QuickBase Query Language

Latest version **1.0.5** (published 2019-01-08) · MIT license · 0 weekly downloads

## Install

```sh
npm install qbql
pnpm add qbql
yarn add qbql
bun add qbql
```

## Health

**Score 15/100 (F)** — status: abandoned.

Positive: no vulnerabilities.

Warnings: low downloads; no types; no esm support.

Negative: abandoned; low maintenance score.

## Facts

| | |
|---|---|
| Version | 1.0.5 |
| Published | 2019-01-08 |
| First published | 2019-01-04 |
| Weekly downloads | 0 |
| License | MIT |
| TypeScript types | none |
| Module format | CommonJS |
| Dependencies | 6 |
| Unpacked size | 593.7 KB |
| Known vulnerabilities | 0 (+26 in 2 direct dependencies) |
| Install scripts | no |
| Author | David J Barnes |
| Maintainers | davidjbarnes |
| Keywords | quickbase, query, language, qbql |

## Links

- npm: https://www.npmjs.com/package/qbql
- npm.io page: https://npm.io/package/qbql

## Dependencies (6)

- [axios](https://npm.io/package/axios.md) ^0.18.0
- [xml-js](https://npm.io/package/xml-js.md) ^1.6.8
- [webpack](https://npm.io/package/webpack.md) ^4.28.3
- [jsontoxml](https://npm.io/package/jsontoxml.md) ^1.0.1
- [node-sqlparser](https://npm.io/package/node-sqlparser.md) ^1.0.4
- [fast-xml-parser](https://npm.io/package/fast-xml-parser.md) ^3.12.11

## Alternatives

- [gamedig](https://npm.io/package/gamedig.md) — 29.3K weekly downloads
- [join-monster](https://npm.io/package/join-monster.md) — 12.8K weekly downloads
- [masked](https://npm.io/package/masked.md) — 5.5K weekly downloads
- [@comunica/actor-query-process-explain-logical](https://npm.io/package/@comunica/actor-query-process-explain-logical.md) — 4.7K weekly downloads
- [@veracity/vui](https://npm.io/package/@veracity/vui.md) — 4.6K weekly downloads

## Recent versions

- 1.0.5 (latest) — 2019-01-08
- 1.0.4 — 2019-01-08
- 1.0.3 — 2019-01-05
- 1.0.2 — 2019-01-04
- 1.0.1 — 2019-01-04
- 1.0.0 — 2019-01-04

## README

# QuickBase Query Language (qbql)
QuickBase API using standard SQL syntax

## Getting Started
Install from npm:
```
$ npm i qbql
```
Or get the source code here:
```
$ git remote add origin https://davidjbarnes@bitbucket.org/davidjbarnes/qbql.git
```

## Usage
```
import QBQL from 'qbql';

qbql = new QBQL({
    domain: <DOMAIN>,
    database: <DATABASE>,
    username: <USERNAME>,
    password: <PASSWORD>,
    onReady: (response) => {
        console.log(response);
    },
    onError: (error) => {
        console.log(error);
    }
});
```

## Methods
### Select
```
qbql.query("select name from user").then((response) => {
    console.log(response);
});
```

### Where
```
qbql.query("select name from user where name = 'David'").then((response) => {
    console.log(response);
});
```

#### Operators
Valid where operators:
* '='  Is equal to a specific value
* '!=' Is not equal to a specific value
* '<'  Is less than a specific value
* '<=' Is less than or equal to a specific value
* '>'  Is greater than a specific value
* '>=' Is greater than or equal to a specific value

## Work in Progress
* Insert (standard)
* Bulk insert
* Stored Procs
* Update
* Delete
* Join
* Aggregate functions

## Contributing
Email me: NullableInt@gmail.com 

## Authors

* **David J Barnes** - *NullableInt@gmail.com*

## License
This project is licensed under the MIT License - see the [LICENSE.md](LICENSE.md) file for details

---
_Source: https://npm.io/package/qbql · Machine-readable twin of the npm.io package page. Health data is recomputed on every publish._