如何使用TypeOrm创建连接池?在探索 TypeOrm 时,我想创建连接池以使用 MySql
下面是代码片段:
import { createConnection } from 'typeorm';
export const databaseProviders = [
{
provide: 'DbConnectionToken',
useFactory: async () => await createConnection({
type: 'mysql',
host: 'localhost',
port: 8889,
username: 'root',
password: 'root',
database: 'typeorm_test',
entities: [
__dirname + '/../**/**.entity{.ts,.js}',
],
autoSchemaSync: true,
logging: 'all',
}),
},
];
TypeORM 默认使用连接池,默认有 10 个连接。如果您想要自定义池限制(建议),可以提及相同的内容connectionLimit
under extra
传递给底层 MySQL 驱动程序的选项。
[
{
"name": "default",
"type": "mysql",
"host": "mysql.db",
"port": 3306,
"username": "appUser",
"password": "appRandomPassword",
"database": "entity_schema",
"entities": [
"dist/models/entities/**/*.js"
],
"logging": [
"error"
],
"extra": {
"connectionLimit": 5
}
}
]
TypeORM 文档 https://typeorm.io/data-source-options#common-data-source-options
MySQL 连接池选项 https://github.com/mysqljs/mysql#pool-options可以通过下面extra
, 如果需要。
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)