{"_id":"@aicblock/emysql","_rev":"4-a507a49d98f0b8a8cda55b9086076db9","name":"@aicblock/emysql","dist-tags":{"latest":"1.3.2"},"versions":{"1.3.0":{"name":"@aicblock/emysql","version":"1.3.0","keywords":["MYSQL","AICBLOCKCN","ORM","nodejs","mysql-orm"],"author":{"name":"jieyang;damon;"},"license":"MIT","_id":"@aicblock/emysql@1.3.0","maintainers":[{"name":"aicdyangj","email":"yangj@aicblock.cn"}],"homepage":"http://emysql.aicblock.cn/","dist":{"shasum":"3e55c2f17772dae28274491ad7395912e859d696","tarball":"https://registry.npmjs.org/@aicblock/emysql/-/emysql-1.3.0.tgz","fileCount":7,"integrity":"sha512-8aatxGcZjgDV+0j5YWJwDa7BneCGeEbYMXeEPOaQmP7O/mfEpqKT14g9ark05cofeeNVqqCp+a1uycCAbj2eTQ==","signatures":[{"sig":"MEQCIFEGDicaeD7Joss/xB+ywtsBFIR5qR+A6P/5JPCsFJRtAiAJ7tH6RrxFPzQZiB5YUX65S9GKwoMEi2vazQKLs9sx5Q==","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":33343},"main":"lib/index.js","husky":{"hooks":{"commit-msg":"commitlint -E HUSKY_GIT_PARAMS,"}},"types":"./lib/index.d.ts","gitHead":"5be090c705e27a0bc64a0aafb44e3aedeea667fa","scripts":{"doc":"npm run -C ./doc dev","test":"jest --coverage","package":"ts-node ./scripts/build.ts","prepare":"husky","changelog":"conventional-changelog -p angular -i CHANGELOG.md -s -r 1","doc:build":"npm run -C ./doc build"},"_npmUser":{"name":"aicdyangj","email":"yangj@aicblock.cn"},"repository":{"url":"https://gitee.com/aiclouddigit/e-mysql","type":"git"},"_npmVersion":"10.9.2","description":"🛠️ Based on the basic secondary package of `mysql`, the pursuit of creating a simple and easy to use `mysql-ORM` library.","directories":{},"_nodeVersion":"22.16.0","dependencies":{"mysql2":"^3.14.1"},"_hasShrinkwrap":false,"devDependencies":{"jest":"^27.5.1","husky":"^9.1.7","esbuild":"^0.21.3","ts-jest":"^27.1.3","ts-node":"^10.9.2","@types/jest":"^27.5.2","@types/node":"^16.4.10","@commitlint/cli":"^19.6.0","@dpapejs/node-utils":"^0.1.0","conventional-changelog-cli":"^5.0.0","@commitlint/config-conventional":"^19.6.0"},"_npmOperationalInternal":{"tmp":"tmp/emysql_1.3.0_1768786907356_0.18421692631593278","host":"s3://npm-registry-packages-npm-production"},"deprecated":"Package no longer supported. Contact Support at https://www.npmjs.com/support for more info."},"1.3.1":{"name":"@aicblock/emysql","version":"1.3.1","keywords":["MYSQL","AICBLOCKCN","ORM","nodejs","mysql-orm"],"author":{"name":"jieyang;damon;"},"license":"MIT","_id":"@aicblock/emysql@1.3.1","maintainers":[{"name":"aicdyangj","email":"yangj@aicblock.cn"}],"homepage":"http://emysql.aicblock.cn/","dist":{"shasum":"2ae78039cde7ddc964d59a5412a39e42f75ae9b5","tarball":"https://registry.npmjs.org/@aicblock/emysql/-/emysql-1.3.1.tgz","fileCount":7,"integrity":"sha512-vDCFA8QYNLOu1OBc+XqUA/Gx2hItLxm+s66sop+5bAQOihTL83IAdDGKtLj8gaGHhX09PMDnSruJUHiScd3zgQ==","signatures":[{"sig":"MEUCIQDGBiw1Qpt9VMT8svqGtIafbGLwprOcRwU2dqZ8RP/T8QIgGqiRLxJhpSvlAPYIzbVdVRuPNMFVDs3wICZbb6xRnkM=","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":33451},"main":"lib/index.js","husky":{"hooks":{"commit-msg":"commitlint -E HUSKY_GIT_PARAMS,"}},"types":"./lib/index.d.ts","gitHead":"35100d4f7bf95b5a7de1f6ab61adabbff8983346","scripts":{"doc":"npm run -C ./doc dev","test":"jest --coverage","package":"ts-node ./scripts/build.ts","prepare":"husky","changelog":"conventional-changelog -p angular -i CHANGELOG.md -s -r 1","doc:build":"npm run -C ./doc build"},"_npmUser":{"name":"aicdyangj","email":"yangj@aicblock.cn"},"repository":{"url":"https://gitee.com/aiclouddigit/e-mysql","type":"git"},"_npmVersion":"10.9.2","description":"🛠️ Based on the basic secondary package of `mysql`, the pursuit of creating a simple and easy to use `mysql-ORM` library.","directories":{},"_nodeVersion":"22.16.0","dependencies":{"mysql2":"^3.14.1"},"_hasShrinkwrap":false,"devDependencies":{"jest":"^27.5.1","husky":"^9.1.7","esbuild":"^0.21.3","ts-jest":"^27.1.3","ts-node":"^10.9.2","@types/jest":"^27.5.2","@types/node":"^16.4.10","@commitlint/cli":"^19.6.0","@dpapejs/node-utils":"^0.1.0","conventional-changelog-cli":"^5.0.0","@commitlint/config-conventional":"^19.6.0"},"_npmOperationalInternal":{"tmp":"tmp/emysql_1.3.1_1771690568160_0.31676184995960566","host":"s3://npm-registry-packages-npm-production"},"deprecated":"Package no longer supported. Contact Support at https://www.npmjs.com/support for more info."},"1.3.2":{"name":"@aicblock/emysql","version":"1.3.2","keywords":["MYSQL","AICBLOCKCN","ORM","nodejs","mysql-orm"],"author":{"name":"jieyang;damon;"},"license":"MIT","_id":"@aicblock/emysql@1.3.2","maintainers":[{"name":"aicdyangj","email":"yangj@aicblock.cn"}],"homepage":"http://emysql.aicblock.cn/","dist":{"shasum":"08845229d693c9cbb2cb2ae2bd012269d60a2023","tarball":"https://registry.npmjs.org/@aicblock/emysql/-/emysql-1.3.2.tgz","fileCount":7,"integrity":"sha512-GE1LfRdAq0UI4eQcCm1Rxo0c5soomSVPiKuFDiuwEsyJdfCESK6knycNGvcKwyPFvtqIwNQ5v8nMyIwnD8wAqA==","signatures":[{"sig":"MEYCIQDVqikdcDOYPwkh8g1J+4TWC29/7tuXYuxDPU5dAF1Y1wIhAO+2Y0hKBgFS4xztQIM3QH9Tu/2HT+4Mzv3AoTqMsV+m","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":33583},"main":"lib/index.js","husky":{"hooks":{"commit-msg":"commitlint -E HUSKY_GIT_PARAMS,"}},"types":"./lib/index.d.ts","gitHead":"fc4f12eac5daaaaf2839cce51784f587003d52b5","scripts":{"doc":"npm run -C ./doc dev","test":"jest --coverage","package":"ts-node ./scripts/build.ts","prepare":"husky","changelog":"conventional-changelog -p angular -i CHANGELOG.md -s -r 1","doc:build":"npm run -C ./doc build"},"_npmUser":{"name":"aicdyangj","email":"yangj@aicblock.cn"},"repository":{"url":"https://gitee.com/aiclouddigit/e-mysql","type":"git"},"_npmVersion":"10.9.2","description":"🛠️ Based on the basic secondary package of `mysql`, the pursuit of creating a simple and easy to use `mysql-ORM` library.","directories":{},"_nodeVersion":"22.16.0","dependencies":{"mysql2":"^3.14.1"},"_hasShrinkwrap":false,"devDependencies":{"jest":"^27.5.1","husky":"^9.1.7","esbuild":"^0.21.3","ts-jest":"^27.1.3","ts-node":"^10.9.2","@types/jest":"^27.5.2","@types/node":"^16.4.10","@commitlint/cli":"^19.6.0","@dpapejs/node-utils":"^0.1.0","conventional-changelog-cli":"^5.0.0","@commitlint/config-conventional":"^19.6.0"},"_npmOperationalInternal":{"tmp":"tmp/emysql_1.3.2_1772271535326_0.9658377093544572","host":"s3://npm-registry-packages-npm-production"},"deprecated":"Package no longer supported. Contact Support at https://www.npmjs.com/support for more info."}},"time":{"created":"2026-01-19T01:41:47.195Z","modified":"2026-04-15T17:29:52.165Z","1.3.0":"2026-01-19T01:41:47.503Z","1.3.1":"2026-02-21T16:16:08.304Z","1.3.2":"2026-02-28T09:38:55.478Z"},"author":{"name":"jieyang;damon;"},"license":"MIT","homepage":"http://emysql.aicblock.cn/","keywords":["MYSQL","AICBLOCKCN","ORM","nodejs","mysql-orm"],"repository":{"url":"https://gitee.com/aiclouddigit/e-mysql","type":"git"},"description":"🛠️ Based on the basic secondary package of `mysql`, the pursuit of creating a simple and easy to use `mysql-ORM` library.","maintainers":[{"name":"aicdyangj","email":"yangj@aicblock.cn"}],"readme":"# @aicblock/emysql\n\n![npm](https://img.shields.io/npm/v/@aicblock/emysql)\n![npm](https://img.shields.io/npm/dm/@aicblock/emysql)\n![NPM](https://img.shields.io/npm/l/@aicblock/emysql)\n\n#### 介绍\n\n🛠️ 基于 `mysql` 基础二次封装，追求打造简单、好用的 `mysql-ORM` 库.\n\n#### 安装教程\n\n```sh\nnpm i @aicblock/emysql@latest -S\n```\n\n#### 使用说明\n\n```ts\nimport emysql, { DefineTable } from '@aicblock/emysql' // 引用库\n// 函数实例化\nconst mysql = new emysql({\n  password: '[database login password]',\n  user: '[database login username]',\n  database: 'database name'\n})\n\n// 创建表结构\nconst createTable = DefineTable({\n  tableName: 'create_table',\n  columns: [\n    {\n      name: 'id',\n      dataType: 'INT',\n      primaryKey: true,\n      autoIncrement: true,\n      comments: '主键id'\n    },\n    {\n      name: 'name',\n      dataType: 'VARCHAR',\n      length: 45,\n      notNull: true,\n      comments: '名称'\n    },\n    {\n      name: 'create_at',\n      dataType: 'DATETIME',\n      notNull: true,\n      comments: '创建时间'\n    }\n  ]\n})\n// 初始化数据库\nawait mysql.init()\n// 创建表\nawait mysql.table.create([createTable])\n// 插入数据\nconst now = new Date()\nawait mysql.change.insert({\n  t: createTable,\n  params: { name: 'test', create_at: now }\n})\n// 查询数据\nconst list = await mysql.query({\n  t: createTable,\n  fields: ['name', 'id'],\n  condition: { id: 1 }\n})\nconsole.log(list) // [{id:1,name:\"test\"}]\n```\n","readmeFilename":"README.md"}