{"_id":"@dfeidao/fd-aw000001","_rev":"5-b5e043bcc8f036e43d021351615f2e86","name":"@dfeidao/fd-aw000001","dist-tags":{"latest":"4.6.201910301104"},"versions":{"4.6.0":{"name":"@dfeidao/fd-aw000001","version":"4.6.0","description":"操作websql","scripts":{"test":"../../node_modules/.bin/tsc -w & ../../node_modules/.bin/ava --watch ./test.js","lint":"../../node_modules/.bin/tslint -p tsconfig.json","compile-ts-amd":"../../node_modules/.bin/tsc -m amd -d false --outFile main.js","compile-ts-cjs":"../../node_modules/.bin/tsc","compile":"npm run compile-ts-amd && npm run compile-ts-cjs","build":"npm run lint && npm run compile"},"repository":{"type":"git","url":"https://gitee.com/dfeidao/widgets"},"keywords":["feidao","01feidao","dfeidao","atom","飞道","控件","ai"],"author":{"name":"葛晓丹","email":"gexiaodan@ifeidao.com","url":"http://www.01feidao.com/"},"maintainers":[{"name":"taoqf","email":"tao_qiufeng@126.com"}],"license":"MIT","dependencies":{"@types/websql":"0.0.27"},"_id":"@dfeidao/fd-aw000001@4.6.0","_nodeVersion":"12.8.0","_npmVersion":"6.10.2","dist":{"integrity":"sha512-CDribI6FVkLKUzLqkSpB8kGrbqQVnN9GMiEQXDzMr9S9u4qlSsVF4qUhMTR1FvuCE7e6Mjt/bzGU+IoYhqxtyw==","shasum":"65d6014ffb8195d68f8f965acd30ed0e9e991a58","tarball":"https://registry.npmjs.org/@dfeidao/fd-aw000001/-/fd-aw000001-4.6.0.tgz","fileCount":6,"unpackedSize":5062,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v3.0.4\r\nComment: https://openpgpjs.org\r\n\r\nwsFcBAEBCAAQBQJdTOujCRA9TVsSAnZWagAA+YwQAIVFMNOv/Y/BQzWycf/0\nKVlNbkBIor8j+QEfHUbhVzPkGC2/hoJgSX98Zl5c2Hv70xnomI1So3l/eSDL\nLlYqak2AGmcPRdh+FtkMJ3e8fXx2xKjsrzmx0kjQAKGK2a+6Pwj9jXcGZ5AE\nreA2agbjhuBZNPYpQo473Q49AUr2wEDdfqnHBD+MR620vab+uG/5lnlreMy9\nb1Biub0g8MGihA5jerFk2MriZP9M0q6ANw34TYm7MX7kdXpqQk352gAqsboc\nLnS86w1X76RZeZrZzrlr34foqM8BsTLs81K3b/Cd0KXzfEML4MtrUhYz7t5N\ntNW9f3tTVB0tMZf0nlqWMZuT4a8xsi+bf9/YCItOQ7lhArt4KqNDxzmwg4zi\nVpSQFXXPPI4yOtUCTJvjv8Dcs6ShZ7Ve+NxGpdD1/kWBa45zFanK6h8/5gqq\n34Dv8yn5D26gg3/N2/HhSUR1P8GVh3TDMCcJ4l/yBe2Bt9K3B9aHACMPevbs\nCRV2/VNuTWa/YBwikIkV3er7asgVqRrz+Mo14kGOE3lGWNDvmZMRCAnYkjzi\nOQadBb/03D7A7TipOurElq0zo+VuEvRUyzvWif0fpVeL7WdhgOMtsR22ruk8\nq4AEY7r+i0K3M7SSnjd51UjPV4E0l2V9Dyofz0YMzG2y6oBjDaqdlS8vUESY\ntGVj\r\n=S21O\r\n-----END PGP SIGNATURE-----\r\n","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIQDx7cpe8KgGNorQ9rfzZ95ozZnFS7mMZQWWDrwvRDVxtAIgOk16MKvZ+vPn/NWgq1Tu0QSkiJQ6aOih8r01NFdIcwI="}]},"_npmUser":{"name":"taoqf","email":"tao_qiufeng@126.com"},"directories":{},"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/fd-aw000001_4.6.0_1565322146441_0.2223316908888402"},"_hasShrinkwrap":false},"4.6.201908091143":{"name":"@dfeidao/fd-aw000001","version":"4.6.201908091143","description":"操作websql","scripts":{"test":"../../node_modules/.bin/tsc -w & ../../node_modules/.bin/ava --watch ./test.js","lint":"../../node_modules/.bin/tslint -p tsconfig.json","compile-ts-amd":"../../node_modules/.bin/tsc -m amd -d false --outFile main.js","compile-ts-cjs":"../../node_modules/.bin/tsc","compile":"npm run compile-ts-amd && npm run compile-ts-cjs","build":"npm run lint && npm run compile"},"repository":{"type":"git","url":"https://gitee.com/dfeidao/widgets"},"keywords":["feidao","01feidao","dfeidao","atom","飞道","控件","ai"],"author":{"name":"葛晓丹","email":"gexiaodan@ifeidao.com","url":"http://www.01feidao.com/"},"maintainers":[{"name":"taoqf","email":"tao_qiufeng@126.com"}],"license":"MIT","dependencies":{"@types/websql":"0.0.27"},"_id":"@dfeidao/fd-aw000001@4.6.201908091143","_nodeVersion":"12.8.0","_npmVersion":"6.10.2","dist":{"integrity":"sha512-ktn8uQVrloGITc3/WfuDOoxV5Ulqxsdk+9VMudHWaG3QKNCu1HMq/ugPT95WBCQSUh4xE63/dgBatasLqQ3RYA==","shasum":"ddb9c2baa3c2cbf517bcc3af4372f8c97cb431f3","tarball":"https://registry.npmjs.org/@dfeidao/fd-aw000001/-/fd-aw000001-4.6.201908091143.tgz","fileCount":6,"unpackedSize":5074,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v3.0.4\r\nComment: https://openpgpjs.org\r\n\r\nwsFcBAEBCAAQBQJdTOveCRA9TVsSAnZWagAA2XcP/R1E6tJV2BIQTL/jytW5\noDX7z3k9SmLCZ2y9taZSPij31Zepx4LOBAllZ2bwmOvfNidIvhYqrTSFyySQ\nrZQzw5NMEWMpxdvHioeWmbSY3lpIeGqbpFrqx8y7yvLEme8pywFfKhGQ9uDQ\nRS0DBqdEwkJIm9y2L4sHNsyLjfdHoOMyj7QmjZnOG6FQ98DXpd2Wpw5IRQKK\niGIozw10nsNN82Q6zI+GIdtl7xLnMN8vfmIwpgH+JcidLYmQDv43M/K3UIUw\nvAMEd0d+Ue9J0UPFo/Xe9nwGQikzonSfT5vmnbhDOD4CmH3wofS2vYAPtNF/\nzjJXrvgx6XMDFvhBViEb+NVrOADhzrH2067PHNMHauW/k3uy+9Tu9YLId/fd\n55gChV+c94UZl8/xQzZTSD0if2B/iEDYBXZzAwErSTIiU7f7u2rsh6miJBn3\nO7X+QdQwCBpyLX8StrttlgRX+yEoh7sej72HJ5krsx1KJWpSeSirdpjPGkFJ\nWI95ABRqhq3CzWA52uvJkmeO+ndHeVxv5LKZHPY9Bs6uuuOz/swdZRdqXbSq\nXcG9AnWzWusAWwycufBkms5J0FgOYuydvEYLBHcV9B0LQN/byk6UaEka2+1x\nKqxDCyWdFb1HB1iV+h8R10Qeq+n9W1LaeackfD/Lf6BQQlhgsxKDkCADQFNQ\nBw84\r\n=xpLj\r\n-----END PGP SIGNATURE-----\r\n","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIQDiosk4KWSvbl6DKd/wuJZxgEOmz7I/mqHeICsfAC0vEwIgUGS8C/KqXq6XX9DCbDNROvmRyb5nkqEUw2dlPHkF4pk="}]},"_npmUser":{"name":"taoqf","email":"tao_qiufeng@126.com"},"directories":{},"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/fd-aw000001_4.6.201908091143_1565322205946_0.9352501644967186"},"_hasShrinkwrap":false},"4.6.201910151526":{"name":"@dfeidao/fd-aw000001","version":"4.6.201910151526","description":"操作websql","scripts":{"test":"../../node_modules/.bin/tsc -w & ../../node_modules/.bin/karma start","lint":"../../node_modules/.bin/tslint -p tsconfig.json","compile-ts-amd":"../../node_modules/.bin/tsc -m amd -d false --outFile main.js","compile-ts-cjs":"../../node_modules/.bin/tsc","compile":"npm run compile-ts-amd && npm run compile-ts-cjs","build":"npm run lint && npm run compile"},"repository":{"type":"git","url":"https://gitee.com/dfeidao/widgets"},"keywords":["feidao","01feidao","dfeidao","atom","飞道","控件","ai"],"author":{"name":"葛晓丹","email":"gexiaodan@ifeidao.com","url":"http://www.01feidao.com/"},"maintainers":[{"name":"taoqf","email":"tao_qiufeng@126.com"}],"license":"MIT","dependencies":{"@types/websql":"0.0.27"},"_id":"@dfeidao/fd-aw000001@4.6.201910151526","_nodeVersion":"12.12.0","_npmVersion":"6.11.3","dist":{"integrity":"sha512-O3OeU3ZfN2IBBcaVUfSEPD/9aovji5+lxfV3JSZvQZuJCcwdHRDWNGmr4h0UxcPVQwbmbMtyH5GV8o7WvGDWCw==","shasum":"a2566c543d9f4ff33e2327dccfaff15f28eb0038","tarball":"https://registry.npmjs.org/@dfeidao/fd-aw000001/-/fd-aw000001-4.6.201910151526.tgz","fileCount":9,"unpackedSize":5922,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v3.0.4\r\nComment: https://openpgpjs.org\r\n\r\nwsFcBAEBCAAQBQJdpXS0CRA9TVsSAnZWagAAaAMQAJsV5L8XNKT8c/T2PAzA\n6xhvxBCeIjxd3G8fSi8xHtUSjzcCXGeRn9iPtCXIEGGn3wxltbE1OZerVzg7\nN5PRJxZv2HTRTMppp5EoRrvY7dkk8hu7GS9D+JgBBDe7K4uRtRyOsGoRcDCE\nNO5BA6AFzSQ6Y5JC46OvBUzaa5avKP5sKSQQFzn97sL4cyANI+RFcuSV0161\nFhBrq9q8Gj8kJvaL52BBaVMbrxb/J/TMOBKj6jMvYKAyiFVjXL1EE7zyZgem\nHGP/yfxDv4vBUxqY+6WOkfS6bvlBRQmLOKgRLk25Pxz8cVdlFHh3r1T96Mkg\nvy7XLvOedWxCCF4YAvDrs4kCSayxlQJ//hg+2or4Vv3IJ6i9/VUllV6Ohtar\ngSUOl8RZwSs5zNRyKoamfQeg4uZLOl362d+ZYj4X0kqw2hmCn7FzFCVm7sf7\nNmJwKG/NN0765M0W3IzaXb3ljPjGFjTd13u2nBSjgrUd8fBI/IqY9nXsG4zE\n2TBxJownAmNhL5d54AvLkA07CnzXXDL0bKjga3hdVhFZtumvyKWgHojY+d5f\nOJcbuEQ5Lp4++94XPB2Jns2bxAhMYTyTJ508Ods2OUCOqRrlK5/qI3RHK8vk\nCRbtjY6qm/wA/q77tAoeqmkOinmlm+xgrxBE3ZIKqK62dEcXi9JOmmMHj8Nn\nQhel\r\n=wEhm\r\n-----END PGP SIGNATURE-----\r\n","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEQCIDw5hBPYyQv5T95RglH6Bwe2MGH4q/2MHB4tpJFdQpr6AiAkzineV7JcM5zrQHzvgST9NTHY0+xbVM/qbKoiO+1LBQ=="}]},"_npmUser":{"name":"taoqf","email":"tao_qiufeng@126.com"},"directories":{},"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/fd-aw000001_4.6.201910151526_1571124403577_0.8092293128480041"},"_hasShrinkwrap":false},"4.6.201910151528":{"name":"@dfeidao/fd-aw000001","version":"4.6.201910151528","description":"操作websql","scripts":{"test":"../../node_modules/.bin/tsc -w & ../../node_modules/.bin/karma start","lint":"../../node_modules/.bin/tslint -p tsconfig.json","compile-ts-amd":"../../node_modules/.bin/tsc -m amd -d false --outFile main.js","compile-ts-cjs":"../../node_modules/.bin/tsc","compile":"npm run compile-ts-amd && npm run compile-ts-cjs","build":"npm run lint && npm run compile"},"repository":{"type":"git","url":"https://gitee.com/dfeidao/widgets"},"keywords":["feidao","01feidao","dfeidao","atom","飞道","控件","ai"],"author":{"name":"葛晓丹","email":"gexiaodan@ifeidao.com","url":"http://www.01feidao.com/"},"maintainers":[{"name":"taoqf","email":"tao_qiufeng@126.com"}],"license":"MIT","dependencies":{"@types/websql":"0.0.27"},"_id":"@dfeidao/fd-aw000001@4.6.201910151528","_nodeVersion":"12.12.0","_npmVersion":"6.11.3","dist":{"integrity":"sha512-+XF4QBqKZAZqATKil71a7PkjwNGtKIN3wU8nyKTIPM1Y7gssvMPxfIsNdrCCcjukvza/QUSmEsPGbhHn3ksRAg==","shasum":"333a804e93854df2f51d21adca7691892c9d1f98","tarball":"https://registry.npmjs.org/@dfeidao/fd-aw000001/-/fd-aw000001-4.6.201910151528.tgz","fileCount":9,"unpackedSize":5923,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v3.0.4\r\nComment: https://openpgpjs.org\r\n\r\nwsFcBAEBCAAQBQJdpXUpCRA9TVsSAnZWagAAEDAP/10SfFhNahynDt/K+TSw\nP8Am4mtuRUYLROr9znWukpb5dHPPwpQJKAP+HlYLtjzQ3RAj2mzX416NHRxJ\nR0KNyJgpgHkq4mcsF0IOcoD4XippWupUSaTqapieV3vjP0Fhj2Qu5tswaQCx\nS8fgI35lP4o4L7bcOxKMVTBlByvo1c2g+66T/roP+EvjsfTUVSFkWxqWvPRG\nsBmVuJBb0s2tsfgtYXkGEdoIgL6ShuE9hYa6JPTXhDp9XxDskhf/VoXY2tOU\nLgGxVqaI6Xw9lKu8LpVRBr5JddQnSnxCoy2Jqre7JozO7DUi4OPLKvQvIC5k\nhA2TUJqElWxCqUSznjcW9YEA8g6kgop6FULO8mhrd1P8Pd9AeOa1VMf8AUVJ\n+2Et1/BBzECmliHHwygjtxk4sCMXTqjaQ0cr9ce8SsC1SJBwxWdl5jv3BPgw\nHqUiEnUSD9+CxzPPDxkreXAQKF/1pY7J+n0DtKrTba52ght0mlECqWc+S7KB\np9BPi3yhFNtKa4aj0yAJuGBLki1kZSHTOL3dEx1ghl2429QRSjMIHx7WdeoJ\nBMmBhcpgHvZBSmvgpfkIxkwgfroovyr8N390qGXKzxEJJRgvPe1unBPbQ9U/\nVK9275lmFMJhz+5JTYmb68tvXXRijEKa1PWUz7LGJfSbI+QQs8jHczomkp1s\nnx4h\r\n=VdJy\r\n-----END PGP SIGNATURE-----\r\n","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEYCIQCVucyN0SWULSb870J5mlSsKjK5THfPlrAKFoELLq2G0QIhAPGZ4a2xxKBsH+cL9hO9y6cXmNHFR9TiB/aLqhHm19MR"}]},"_npmUser":{"name":"taoqf","email":"tao_qiufeng@126.com"},"directories":{},"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/fd-aw000001_4.6.201910151528_1571124521334_0.47094930003938895"},"_hasShrinkwrap":false},"4.6.201910301104":{"name":"@dfeidao/fd-aw000001","version":"4.6.201910301104","description":"操作websql","scripts":{"test":"../../node_modules/.bin/tsc -w & ../../node_modules/.bin/karma start","lint":"../../node_modules/.bin/tslint -p tsconfig.json","compile-ts-amd":"../../node_modules/.bin/tsc -m amd -d false --outFile main.js","compile-ts-cjs":"../../node_modules/.bin/tsc","compile":"npm run compile-ts-amd && npm run compile-ts-cjs","build":"npm run lint && npm run compile"},"repository":{"type":"git","url":"https://gitee.com/dfeidao/widgets"},"keywords":["feidao","01feidao","dfeidao","atom","飞道","控件","ai"],"author":{"name":"葛晓丹","email":"gexiaodan@ifeidao.com","url":"http://www.01feidao.com/"},"maintainers":[{"name":"taoqf","email":"tao_qiufeng@126.com"}],"license":"MIT","dependencies":{"@types/websql":"0.0.27"},"_id":"@dfeidao/fd-aw000001@4.6.201910301104","_nodeVersion":"13.0.1","_npmVersion":"6.12.0","dist":{"integrity":"sha512-X01XZ6ow5O1nJNS1deECggPfSeN3g7LGu6ARMGG6dk4CL5M6lEj8+m0pdIO6BnNXZ3qt7QhcOIGe1+losXhxTw==","shasum":"5bdd566199fa39f3be99a8a9d4b0f6be98ea8f0f","tarball":"https://registry.npmjs.org/@dfeidao/fd-aw000001/-/fd-aw000001-4.6.201910301104.tgz","fileCount":9,"unpackedSize":5859,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v3.0.4\r\nComment: https://openpgpjs.org\r\n\r\nwsFcBAEBCAAQBQJduP2uCRA9TVsSAnZWagAAfe0P/jyISFGwJov9DpuNh+8i\nJic+2jWDiD0kIGJVq/iBkJgdcp9nevd4ZMYujWONmPzgDZ4x3zhvJzP2KLoU\nQxt+xaVROjOgQ+KlbGsfXBA1uD/h6XzmZu4diTp+Qh6lIoWe0lyqvLs+T0Ia\ntBFMmXvNAcBmC+8s/EJk7UPlo7+VfmR6gjcKbgkO0W3cSEm2MgKcCVXKEM9S\n8DIoNzLvHi+qZe0IQSOcMj2AZ2xKM+ooZh85trIo6FhSmf+nJE30u2pobaoS\nNsu+PlDmr2yD/KROI+ZyGDPLLOU0wrKBlVHLMTQ0/Rx9hCMIHd6A88SgpH9K\nilS63NGFLzd9MREVH4N5rT49FbU8rGOWNJ3XclGIVEUm0SYi55YhDfoK5hlX\nhrmfFNmyN2fSiGWrrOx0ofiPmkBu8/q9xhyQQqoxhpdR7vhVz6RkvGkp3jL9\negXzwUM8k2khwgDHmBH3rZoDBVZleCfCmlppkX4Ip7GCvSE73/+kRHpTsVmI\nSaK6eYYPjZkEeyRgtxqu6GGviDtKUeWr5pTWC2BOntsSMXyMDX6pfaf+VD3E\n6+NoPnkQ000tABVuQlA9Yb6/bhJ9i+qyd6tBSLtL1ZdG/DYvTco1/u0TXEim\nDPGOG0/167MkaCukTmJAZzgCN5vz06yvo+x7DxUQsnxJAE1Ngmxrfhb6zeCw\nqlgJ\r\n=YSwb\r\n-----END PGP SIGNATURE-----\r\n","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEYCIQCOTurrpVCeB7chvNOEVK5dUqm/5X+PQzeXR9pJFlO05gIhANs0OPaeXKnJxUClByMmTbFEUlBkYrXPrfLKbOICdLqh"}]},"_npmUser":{"name":"taoqf","email":"tao_qiufeng@126.com"},"directories":{},"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/fd-aw000001_4.6.201910301104_1572404654251_0.756754194140844"},"_hasShrinkwrap":false}},"time":{"created":"2019-08-09T03:42:26.253Z","4.6.0":"2019-08-09T03:42:26.574Z","modified":"2022-04-05T04:16:00.769Z","4.6.201908091143":"2019-08-09T03:43:26.065Z","4.6.201910151526":"2019-10-15T07:26:43.903Z","4.6.201910151528":"2019-10-15T07:28:41.483Z","4.6.201910301104":"2019-10-30T03:04:14.338Z"},"maintainers":[{"name":"taoqf","email":"tao_qiufeng@126.com"}],"description":"操作websql","keywords":["feidao","01feidao","dfeidao","atom","飞道","控件","ai"],"repository":{"type":"git","url":"https://gitee.com/dfeidao/widgets"},"author":{"name":"葛晓丹","email":"gexiaodan@ifeidao.com","url":"http://www.01feidao.com/"},"license":"MIT","readme":"# 操作websql\n\n## param\n\n属性 | 描述 | 类型\n---- | ---- | ----\nsql | sql语句 | string[]\ndbname | 数据库名称，可选参数，默认为`feidao` | string\n\n## result\n\n返回值类型：`SQLResultSet[]`\n\n```js\n {rows: SQLResultSetRowList, insertId: 0, rowsAffected: 0}\n // 或者\n {insertId: '错误信息'，rows: SQLResultSetRowList，rowsAffected: 3}\n```\n\n## result-error\n\n`SQLError`\n\n## Example\n\n```js\nimport aw001 from '@dfeidao/fd-aw000001';\n// 单条sql语句\ntry{\n\t// 创建表，在表不存在时创建已存在忽略此sql\n\tconst res1 = await aw001(['create table if not exists test (id varchar(255))']);\n\t// 新增数据\n\tconst res2 = await aw001(['insert into test values (\\'999999999999\\')']);\n\t// 查询\n\tconst res3 = await aw001(['select id from test']);\n\t// 删除表中数据\n\tconst res4 = await aw001(['delete from test']);\n\t// 修改表中数据\n\tconst res5 = await aw001(['update test set id = \\'888\\'']);\n\t// 删除表\n\tconst res6 = await aw001(['drop table test']);\n\t// TODO 不能删除数据库\n\tconst res7 = await aw001(['drop database feidao']); // 删除数据库报错\n}catch(e){\n\tconsole.log(e);\n}\n\n// 多条sql执行，有事务处理\n\ntry{\n\tconst res8 = await aw001(['create table if not exists test (id varchar(255))', 'insert into test values (\\'999999999999\\')', 'select id from test2']);\n}catch(error){\n\t// 会抛出错我，不存在表名test2，并且之前sql执行的结果会回滚即不会创建表和新增数据\n\tconsole.log(error);\n}\n\n// 正常执行\ntry{\n\tconst res10 = await aw001(['create table if not exists test (id varchar(255))', 'insert into test values (\\'999999999999\\')', 'select id from test']);\n\t// 返回的数据res10值为 SQLResultSet[]，数组中的结果分别对应参数数组中sql执行结果\n}catch(error){\n\tconsole.log(error);\n}\n\n```\n","readmeFilename":"readme.md"}