{"_id":"@blued-core-oversea/mysql-client-no-qconf","name":"@blued-core-oversea/mysql-client-no-qconf","dist-tags":{"latest":"0.1.0"},"versions":{"0.1.0":{"name":"@blued-core-oversea/mysql-client-no-qconf","version":"0.1.0","description":"<!--  * @Date: 2024-11-20 19:38:11  * @LastEditors: kiddy fanzhenzhen@blued.com  * @LastEditTime: 2024-12-03 14:08:59  * @FilePath: /node-util-mysql/README.md  * @Description:  --> 基于 sequelize 的一层封装。","main":"dist/index.js","scripts":{"build":"rm -rf dist && tsc","watch":"tsc -w","test":"ts-node nodemon test/init.ts"},"keywords":[],"author":"","license":"ISC","dependencies":{"@blued-core/qconf":"^2.0.2","mysql2":"^2.3.3","reflect-metadata":"^0.2.2","sequelize":"^6.37.5","sequelize-typescript":"^2.1.6"},"devDependencies":{"@commitlint/cli":"^7.5.2","@commitlint/config-conventional":"^7.5.0","@types/chai":"^4.1.7","@types/mocha":"^5.2.7","@types/node":"^11.13.4","@types/sequelize":"^4.28.20","@typescript-eslint/eslint-plugin":"^2.34.0","chai":"^4.2.0","commitizen":"^3.0.7","eslint":"^6.8.0","eslint-plugin-import":"^2.16.0","mocha":"^6.1.4","ts-node":"^8.0.3","typescript":"^5.6.3"},"peerDependencies":{"sequelize":"^6.6.5","sequelize-typescript":"^2.1.0"},"publishConfig":{"access":"public"},"gitHead":"8e77788397fd1306630ee0b0deabad735b5ad518","_id":"@blued-core-oversea/mysql-client-no-qconf@0.1.0","_nodeVersion":"12.22.3","_npmVersion":"6.14.13","dist":{"integrity":"sha512-/Ud1rrn/oVcgBL0yjbJ+KyV77F87CcEJ78bG0FDvdPmL5qKsKUfAifcFGpM7k6VzYLwluqqPp4zlPfnkP1hSUA==","shasum":"3963485a183aac0e8be77ceb08ea0378ac859e2f","tarball":"https://registry.npmjs.org/@blued-core-oversea/mysql-client-no-qconf/-/mysql-client-no-qconf-0.1.0.tgz","fileCount":8,"unpackedSize":26708,"signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEQCIAJ23jE6ttP4u0wHPi0e9cnnxo4XrDewFUhltOj9AA/mAiAqQSvWmfNlOGRonu7aHBqHyTiOr9Ow+7qCV1ma4xiZfg=="}]},"_npmUser":{"name":"bluediapp","email":"iappdeveloper@blued.com"},"directories":{},"maintainers":[{"name":"bluediapp","email":"iappdeveloper@blued.com"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/mysql-client-no-qconf_0.1.0_1733206276818_0.3469614475818128"},"_hasShrinkwrap":false}},"time":{"created":"2024-12-03T06:11:16.678Z","0.1.0":"2024-12-03T06:11:16.998Z","modified":"2024-12-03T06:11:17.329Z"},"maintainers":[{"name":"bluediapp","email":"iappdeveloper@blued.com"}],"description":"<!--  * @Date: 2024-11-20 19:38:11  * @LastEditors: kiddy fanzhenzhen@blued.com  * @LastEditTime: 2024-12-03 14:08:59  * @FilePath: /node-util-mysql/README.md  * @Description:  --> 基于 sequelize 的一层封装。","keywords":[],"license":"ISC","readme":"<!--\n * @Date: 2024-11-20 19:38:11\n * @LastEditors: kiddy fanzhenzhen@blued.com\n * @LastEditTime: 2024-12-03 14:08:59\n * @FilePath: /node-util-mysql/README.md\n * @Description: \n-->\n基于 sequelize 的一层封装。\n\n```bash\nnpm i @blued-core-oversea/mysql-client-no-qconf\n```\n\n```typescript\nimport BattleRecord from './models/battle-record'\n\nexport const mysql = {\n  liveArchive: {\n    qconf: '/blued/backend/udb/live_archive',\n    database: 'record_oversea',\n    modelPath: path.resolve(__dirname, './models'),\n  },\n}\n\n// 线上logging 参数建议设置为false\nconst client = new MysqlClient(mysql, {\n  logging: true,\n})\n\nexport const misOverseaMysqlClient = () => client.getClient('liveArchive')\n\nconst main = async () => {\n  for (let i = 0; i <= 10; i++) {\n    const pk = await BattleRecord.findOne({\n      where: {\n        pkId: '23423434342342342424',\n      },\n      raw: true,\n    })\n\n    console.log(pk)\n\n    const result = await misOverseaMysqlClient().query(`SELECT pk_id AS pkId FROM battle_record WHERE pk_id = '23423434342342342424'`, {\n      raw: true,\n    })\n    console.log((result))\n  }\n}\n\nmain().then(() => {\n  console.log('success')\n}).catch(error => {\n  console.log(error)\n})\n```","readmeFilename":"README.md"}