Registry / database / tsbean-driver-mysql

tsbean-driver-mysql

JSON →
library3.0.1jsnpmunverified

MySQL driver for TSBean-ORM, a TypeScript ORM. Version 3.0.1 requires tsbean-orm 3.0.0 and Node >= 16. It uses mysql2 under the hood, provides automatic camelCase to snake_case mapping for database identifiers (configurable), and offers full TypeScript support with type enforcement.

npm install tsbean-driver-mysql
INSTALL
IMPORT
SIG · TSBEAN-DRIVER-MYSQ
T
tsbean-driver-mysql
databasejavascriptv3.0.1
harness data pending
Install & Compatibility
Where this runs

No compatibility data collected yet for this library.

Code
Verified usage

Verified import paths — ran on the pinned version, not inferred.

MySQLDriver
✓ import { MySQLDriver } from 'tsbean-driver-mysql'
✗ const MySQLDriver = require('tsbean-driver-mysql')
ESM or TypeScript: named import. CommonJS require works but is not recommended.
type MySQLDriverConfig
✓ import type { MySQLDriverConfig } from 'tsbean-driver-mysql'
✗ import { MySQLDriverConfig } from 'tsbean-driver-mysql'
For type-only imports, use `import type` to avoid bundling issues in TypeScript.
DataModel
✓ import { DataModel, DataFinder, GenericRow, enforceType, DataSource } from 'tsbean-orm'
✗ import { DataModel } from 'tsbean-driver-mysql'
DataModel and related utilities are from tsbean-orm, not this driver.

Creates a MySQL data source using environment variables for connection parameters, registers it as the default data source with TSBean-ORM.

import { DataSourceDriver, DataSource } from 'tsbean-orm'; import { MySQLDriver } from 'tsbean-driver-mysql'; const mySource = MySQLDriver.createDataSource({ host: process.env.MYSQL_HOST ?? 'localhost', port: parseInt(process.env.MYSQL_PORT ?? '3306'), user: process.env.MYSQL_USER ?? 'root', password: process.env.MYSQL_PASSWORD ?? '', database: process.env.MYSQL_DATABASE ?? 'my_database', }); DataSource.set(DataSource.DEFAULT, mySource); export { DataSource };
Debug
Known issues
gotchaIdentifier conversion (camelCase ↔ snake_case) is enabled by default. Table/column names in queries and models must follow this mapping.
fix
Set `disableIdentifierConversion: true` in the config to bypass conversion.
affects: >=1.0.0
breakingPeer dependency tsbean-orm must be version 3.0.0 exactly. Incompatible with older or newer major versions.
fix
Install tsbean-orm@3.0.0 alongside this driver.
affects: 3.0.x
deprecatedUsing `require` style imports may cause issues in TypeScript ESM projects. Prefer ESM imports.
fix
Use `import { MySQLDriver } from 'tsbean-driver-mysql'` instead of `require`.
affects: >=1.0.0
Errors
Common errors & fixes
Cannot find module 'tsbean-driver-mysql'
Package not installed or missing peer dependency tsbean-orm.
fix
Run `npm install tsbean-driver-mysql tsbean-orm@3.0.0`
TypeError: MySQLDriver.createDataSource is not a function
Incorrect import (e.g., default instead of named import).
fix
Use `import { MySQLDriver } from 'tsbean-driver-mysql'`
Error: ER_BAD_DB_ERROR: Unknown database '...'
Database name does not exist or connection config missing.
fix
Ensure the database exists and `database` property is correctly set in the connection options.
Upgrade
Version history
3.0.1latest on npm
Audit
Dependencies
tsbean-ormrequiredPeer dependency: core ORM library required to use this driver.
Agent activity
14 hits · last 30 days
node
12
Amazon
1
OpenAI (training)
1
Resources
tsbean-driver-mysql — npm install tsbean-driver-mysql · libregistry