Workers Qb Versions Save

What's Changed

• Fix bug on select when calling with empty where

Full Changelog: https://github.com/G4brym/workers-qb/compare/v1.2.1...v1.2.2

What's Changed

• fields now defaults to * when left undefined
• Added a simplified where interface when calling without arguments, the interface is still the same when calling with parameters

const fetched = await qb
  .fetchAll({
    tableName: 'employees',
    where: ['active = true', 'department = "HR"'],
  })
  .execute()

// The example above is the same as this

const fetched = await qb
  .fetchAll({
    tableName: 'employees',
    fields: '*',
    where: {
      conditions: ['active = true', 'department = "HR"'],
    },
  })
  .execute()

Full Changelog: https://github.com/G4brym/workers-qb/compare/v1.2.0...v1.2.1

What's Changed

• Add sql results type hints

type Employee = {
  name: string
  role: string
  level: number
}

// Send your table type in every query like this:
const employeeList = await qb
  .fetchAll<Employee>({
    tableName: 'employees',
    fields: '*',
    where: {
      conditions: 'active = ?1',
      params: [true],
    },
  })
  .execute()

// You will then get type hints inside results in the shape of your table:
employeeList.results[0].name

Full Changelog: https://github.com/G4brym/workers-qb/compare/v1.1.1...v1.2.0

What's Changed

• Turn underlying db client a public property by @G4brym in https://github.com/G4brym/workers-qb/pull/37
• Add raw query support by @G4brym in https://github.com/G4brym/workers-qb/pull/38

Full Changelog: https://github.com/G4brym/workers-qb/compare/v1.1.0...v1.1.1

What's Changed

• Add upsert support by @G4brym in https://github.com/G4brym/workers-qb/pull/36

Full Changelog: https://github.com/G4brym/workers-qb/compare/v1.0.2...v1.1.0

What's Changed

• Update top-level types path by @programbo in https://github.com/G4brym/workers-qb/pull/31

Full Changelog: https://github.com/G4brym/workers-qb/compare/v1.0.1...v1.0.2

What's Changed

• Fix type definition by @G4brym in https://github.com/G4brym/workers-qb/pull/29
• Fix FetchOne() to start returning undefined when no results by @G4brym in https://github.com/G4brym/workers-qb/pull/30

Full Changelog: https://github.com/G4brym/workers-qb/compare/v1.0.0...v1.0.1

Breaking Changes

• For upgrading you must append .execute() at the end of every query, read more here

What's Changed

• D1 batch queries by @ejyager00 in https://github.com/G4brym/workers-qb/pull/25
• Fix bug when passing execute function in creation of new Query by @ejyager00 in https://github.com/G4brym/workers-qb/pull/26
• Update docs to match new interface and refactor tests by @G4brym in https://github.com/G4brym/workers-qb/pull/27

Full Changelog: https://github.com/G4brym/workers-qb/compare/v0.1.12...v1.0.0

What's Changed

• Add debugger option to see generated query + parameters by @G4brym in https://github.com/G4brym/workers-qb/pull/23
• Allow use of subqueries in join clauses by @ejyager00 in https://github.com/G4brym/workers-qb/pull/24

Full Changelog: https://github.com/G4brym/workers-qb/compare/v0.1.11...v0.1.12

Fixes

• Fix D1 insert() to respect response schema

Full Changelog: https://github.com/G4brym/workers-qb/compare/v0.1.10...v0.1.11