# @torch-orm/mysql

> MySQL adapter for torch-orm

Latest version **1.2.0** (published 2026-09-24) · MIT license · 0 weekly downloads

## Install

```sh
npm install @torch-orm/mysql
pnpm add @torch-orm/mysql
yarn add @torch-orm/mysql
bun add @torch-orm/mysql
```

## Health

**Score 65/100 (B)** — status: active.

Positive: has types; esm support; no vulnerabilities; recently updated; high maintenance score.

Warnings: low downloads.

## Facts

| | |
|---|---|
| Version | 1.2.0 |
| Published | 2026-09-24 |
| First published | 2025-02-19 |
| Weekly downloads | 0 |
| License | MIT |
| TypeScript types | bundled |
| Module format | ESM + CommonJS |
| Dependencies | 1 |
| Unpacked size | 4.3 KB |
| Known vulnerabilities | 0 |
| Install scripts | no |
| GitHub stars | 0 |
| Author | jawide |
| Maintainers | jawide |
| Keywords | orm, database, typescript, mysql, adapter |

## Links

- npm: https://www.npmjs.com/package/@torch-orm/mysql
- Repository: https://github.com/jawide/torch-orm
- Homepage: https://github.com/jawide/torch-orm#readme
- Issues: https://github.com/jawide/torch-orm/issues
- npm.io page: https://npm.io/package/@torch-orm/mysql

## Dependencies (1)

- [mysql2](https://npm.io/package/mysql2.md) ^3.12.0

## Alternatives

- [mobx-react](https://npm.io/package/mobx-react.md) — 2.8M weekly downloads
- [rc-tree](https://npm.io/package/rc-tree.md) — 2.6M weekly downloads
- [@react-oauth/google](https://npm.io/package/@react-oauth/google.md) — 1.3M weekly downloads
- [@wagmi/connectors](https://npm.io/package/@wagmi/connectors.md) — 877.0K weekly downloads
- [vee-validate](https://npm.io/package/vee-validate.md) — 836.4K weekly downloads

## Recent versions

- 1.2.0 (latest) — 2026-09-24
- 1.1.15 — 2025-03-05
- 1.1.14 — 2025-03-05
- 1.1.13 — 2025-03-03
- 1.1.12 — 2025-03-03
- 1.1.11 — 2025-03-03
- 1.1.10 — 2025-02-27
- 1.1.9 — 2025-02-27
- 1.1.8 — 2025-02-26
- 1.1.7 — 2025-02-26
- 1.1.6 — 2025-02-22
- 1.1.5 — 2025-02-21
- 1.1.4 — 2025-02-21
- 1.1.3 — 2025-02-21
- 1.1.2 — 2025-02-21
- … 3 more at https://npm.io/package/@torch-orm/mysql/versions

## README

# Torch ORM

一个轻量级的 ORM 库，支持浏览器和 Node.js 环境。基于适配器模式设计，可以轻松扩展支持不同的存储后端。

## 特性

- 支持浏览器和 Node.js
- 基于适配器模式，易于扩展
- TypeScript 支持
- 简单的 API 设计

## 安装

```bash
# 安装核心包
pnpm add @torch-orm/core

# 安装适配器（根据需要选择）
pnpm add @torch-orm/localstorage  # 浏览器 LocalStorage 适配器
pnpm add @torch-orm/sqlite        # SQLite 适配器
pnpm add @torch-orm/mysql         # MySQL 适配器
```

## 使用示例

```typescript
import { DataStore, MapDataAdapter } from "@torch-orm/core";

interface User {
  id: number;
  name: string;
  age: number;
}

// 创建适配器和数据存储实例
const adapter = new MapDataAdapter();
const userStore = new DataStore<User>("users", {
  adapter,
  idAttribute: "id" // 可选，默认为 "id"
});

// 创建用户
await userStore.create({
  id: 1,
  name: "John Doe",
  age: 30
});

// 查询用户
const users = await userStore.find({
  where: { id: 1 }
});

// 更新用户
await userStore.update(1, { age: 31 });

// 删除用户
await userStore.delete(1);
```

## API

### DataStore

- `constructor(collection: string, options: DataStoreOptions)`
  - `collection`: 集合名称
  - `options.adapter`: 数据适配器实例
  - `options.idAttribute`: 自定义 ID 字段名称（可选，默认为 "id"）

- `find(query?: Query): Promise<T[]>`
- `create(data: T): Promise<T>`
- `update(id: string | number, data: Partial<T>): Promise<T>`
- `delete(id: string | number): Promise<void>`
- `clear(): Promise<void>`

### Query 接口

```typescript
interface Query {
  where?: Record<string, any>;
  limit?: number;
  offset?: number;
  sort?: Array<[string, "asc" | "desc"]>;
}
```

## 适配器

### MapDataAdapter

使用 JavaScript Map 作为存储后端的内存适配器。

```typescript
import { MapDataAdapter } from "@torch-orm/core";

interface MapDataAdapterOptions {
  initialData?: Map<string, Map<string | number, Record<string, any>>>;
}

const adapter = new MapDataAdapter({
  initialData: new Map() // 可选，初始数据
});
```

### LocalStorageDataAdapter

使用浏览器 LocalStorage 作为存储后端的适配器。

```typescript
import { LocalStorageDataAdapter } from "@torch-orm/localstorage";

interface LocalStorageDataAdapterOptions {
  prefix?: string;    // 可选，键前缀，默认为 "torch-orm:"
  storage?: Storage;  // 可选，存储实现，默认为 localStorage
}

const adapter = new LocalStorageDataAdapter({
  prefix: "app:",
  storage: sessionStorage // 可选，使用其他存储实现
});
```

### SQLiteDataAdapter

使用 SQL.js 作为存储后端的 SQLite 适配器。

```typescript
import { SQLiteDataAdapter } from "@torch-orm/sqlite";

interface SQLiteDataAdapterOptions {
  filename?: string;  // 可选，数据库文件名
  memory?: boolean;   // 可选，是否使用内存数据库
}

const adapter = new SQLiteDataAdapter({
  memory: true // 使用内存数据库
});
```

### MySQLDataAdapter

使用 MySQL 作为存储后端的适配器。

```typescript
import { MySQLDataAdapter } from "@torch-orm/mysql";

interface MySQLDataAdapterOptions {
  host: string;
  user: string;
  password: string;
  database: string;
  // 其他 mysql2 连接池选项
  waitForConnections?: boolean;
  connectionLimit?: number;
  maxIdle?: number;
  idleTimeout?: number;
  queueLimit?: number;
  enableKeepAlive?: boolean;
  keepAliveInitialDelay?: number;
}

const adapter = new MySQLDataAdapter({
  host: "localhost",
  user: "root",
  password: "password",
  database: "myapp",
  connectionLimit: 10
});

// 使用完毕后关闭连接池
await adapter.close();
```

## 开发

```bash
# 安装依赖
pnpm install

# 运行测试
pnpm test

# 构建
pnpm build

# 清理
pnpm clean
```

## 项目结构

```
packages/
  ├── core/           # 核心包
  ├── localstorage/   # LocalStorage 适配器
  ├── sqlite/         # SQLite 适配器
  ├── mysql/          # MySQL 适配器
  └── test/           # 测试工具包
```

## 许可证

MIT 

### 测试适配器

如果你要开发自己的适配器，可以使用 `@torch-orm/test` 包来测试你的适配器是否符合规范。该测试工具支持多种测试框架，例如 Jest 和 Vitest：

```typescript
// 使用 Jest
import { runAdapterTests } from "@torch-orm/test";
import { describe, test, beforeEach, afterAll, expect } from "@jest/globals";
import { YourDataAdapter } from "./YourDataAdapter";

describe("YourDataAdapter Tests", () => {
  runAdapterTests(
    "YourDataAdapter",
    () => new YourDataAdapter(),
    { describe, test, beforeEach, afterAll, expect },
    // 可选的 beforeEach 回调
    async () => {
      // 在每个测试前执行的操作
    },
    // 可选的 afterAll 回调
    async () => {
      // 在所有测试完成后执行的操作
    }
  );
});

// 使用 Vitest
import { runAdapterTests } from "@torch-orm/test";
import { describe, test, beforeEach, afterAll, expect } from "vitest";
import { YourDataAdapter } from "./YourDataAdapter";

describe("YourDataAdapter Tests", () => {
  runAdapterTests(
    "YourDataAdapter",
    () => new YourDataAdapter(),
    { describe, test, beforeEach, afterAll, expect }
  );
});
```

确保在你的项目中安装了必要的依赖：

```bash
# 使用 Jest
pnpm add -D jest @jest/globals @torch-orm/test

# 使用 Vitest
pnpm add -D vitest @torch-orm/test
```

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