An npm package that query [Cloudflare's D1](https://developers.cloudflare.com/d1/) through [Query D1 Database API](https://developers.cloudflare.com/api/operations/cloudflare-d1-query-database-query) and [Knex](https://knexjs.org/).
npm install cloudflare-d1-http-knex



An npm package that query Cloudflare's D1 through Query D1 Database API and Knex.
``bash
npm install cloudflare-d1-http-knex
Usage
`ts
import { createConnection } from 'cloudflare-d1-http-knex';// The connection function returns a Knex instance
const connection = createConnection({
account_id: 'account_id',
database_id: 'database_id',
key: 'key',
});
const query = await connection('table_name').select('*');
`Mocking
1. Install
better-sqlite3: npm install -D better-sqlite3.
2. Using in case:
`ts
import { createConnection } from 'cloudflare-d1-http-knex'
import { mockedFetch } from 'cloudflare-d1-http-knex/mock'const db = createConnection({
account_id: 'xxxx',
database_id: 'xxxx',
key: 'xxxx',
mockedFetch, // Using mocked fetch, it won't connect to real D1 database.
})
await db.raw('SELECT 1+1')
`$3
You should add below codes to your jest setup files.
`ts
import { mockedFetch } from 'cloudflare-d1-http-knex/mock'global.fetch = jest.fn(mockedFetch)
``See CHANGELOG.md.