{"_id":"qmy","_rev":"50-234c3f5d54bb4ad5bc9e37be30f629be","name":"qmy","dist-tags":{"latest":"1.2.2-Stable"},"versions":{"0.1.0-beta":{"name":"qmy","version":"0.1.0-beta","keywords":["mysql","quickmysql","db","database","sql","quick"],"author":{"name":"Arth"},"license":"Apache-2.0","_id":"qmy@0.1.0-beta","maintainers":[{"name":"iarth","email":"onlyarth@gmail.com"}],"homepage":"https://github.com/4i8/qmy#readme","bugs":{"url":"https://github.com/4i8/qmy/issues"},"dist":{"shasum":"3209bf017929872c8b46ad9e775849f01ff4a16c","tarball":"https://registry.npmjs.org/qmy/-/qmy-0.1.0-beta.tgz","fileCount":23,"integrity":"sha512-shul/m9/xWs3dpNev4M6OxNX0anL/oA6m889zKv5VCJ7BQPLYgJBBchgIFjgRm8mxoZUYhMKtBpxrFKV2JsKRQ==","signatures":[{"sig":"MEQCIHeQTd2tTqkUZextZ+wnJ/h9nZCrgpgnAZGX96U6Z75eAiBl7X5+mKoxqdJHFXHINjV/rGPB8Uxqb6TMNw5kLIX8mA==","keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA"}],"unpackedSize":48491},"main":"index.js","scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"_npmUser":{"name":"iarth","email":"onlyarth@gmail.com"},"deprecated":"Package no longer supported. Contact Support at https://www.npmjs.com/support for more info.","repository":{"url":"git+https://github.com/4i8/qmy.git","type":"git"},"_npmVersion":"6.14.4","description":"Quick mysql is a powerful module that makes the mysql system easier, simpler and faster","directories":{},"_nodeVersion":"13.14.0","dependencies":{"got":"^11.8.2","chalk":"^4.1.2","mysql":"^2.18.1"},"_hasShrinkwrap":false,"_npmOperationalInternal":{"tmp":"tmp/qmy_0.1.0-beta_1635513023588_0.5254094306323551","host":"s3://npm-registry-packages"}},"0.1.1-beta":{"name":"qmy","version":"0.1.1-beta","keywords":["mysql","quickmysql","db","database","sql","quick"],"author":{"name":"Arth"},"license":"Apache-2.0","_id":"qmy@0.1.1-beta","maintainers":[{"name":"iarth","email":"onlyarth@gmail.com"}],"homepage":"https://github.com/4i8/qmy#readme","bugs":{"url":"https://github.com/4i8/qmy/issues"},"dist":{"shasum":"76fb7b7f50198114d068aba805e2d9492c6c1daa","tarball":"https://registry.npmjs.org/qmy/-/qmy-0.1.1-beta.tgz","fileCount":23,"integrity":"sha512-roL+2BhNhUVaL5FCM36XG2TFpm6y2T1KLyjzmzL1DhMT2rBmh+KxHQWa9Bzjg4n7Q1BOCdie2Wr5C5xauFYR+Q==","signatures":[{"sig":"MEUCIBhgSJN4SBren5PLtYM+ndGgvdLMXmWWtiIj9qscKPAnAiEAlXLpA2agbcEtFuxujmdtoL3XduJdCwN+jIvSuEq2HLE=","keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA"}],"unpackedSize":48563},"main":"index.js","scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"_npmUser":{"name":"iarth","email":"onlyarth@gmail.com"},"deprecated":"Package no longer supported. Contact Support at https://www.npmjs.com/support for more info.","repository":{"url":"git+https://github.com/4i8/qmy.git","type":"git"},"_npmVersion":"6.14.4","description":"Quick mysql is a powerful module that makes the mysql system easier, simpler and faster","directories":{},"_nodeVersion":"13.14.0","dependencies":{"got":"^11.8.2","chalk":"^4.1.2","mysql":"^2.18.1"},"_hasShrinkwrap":false,"_npmOperationalInternal":{"tmp":"tmp/qmy_0.1.1-beta_1636072384716_0.334882285135635","host":"s3://npm-registry-packages"}},"0.2.2-beta":{"name":"qmy","version":"0.2.2-beta","keywords":["mysql","quickmysql","db","database","sql","quick"],"author":{"name":"Arth"},"license":"Apache-2.0","_id":"qmy@0.2.2-beta","maintainers":[{"name":"iarth","email":"onlyarth@gmail.com"}],"homepage":"https://github.com/4i8/qmy#readme","bugs":{"url":"https://github.com/4i8/qmy/issues"},"dist":{"shasum":"1108ce00eae27f50998863ee828d679baa71375d","tarball":"https://registry.npmjs.org/qmy/-/qmy-0.2.2-beta.tgz","fileCount":23,"integrity":"sha512-+E+BYSE+QwyTYIAbR1W2P0R8dT6rxuFkuUtBHLKeh0/OAiMEQA53PXtkgmWj1D9wxHVKAlcSsl2cg0x5TYxGpw==","signatures":[{"sig":"MEQCIFXnRTHwGwchZVQlPn4vjOpT4EgngVthLgLbxdWLFfuIAiAebIJBzSSZqhjnw51LRQE8CyaugKF2Ydn1KnnLCGnpIA==","keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA"}],"unpackedSize":47380},"main":"index.js","gitHead":"8fd4696ccbb869df6c9c64ac006365eb2f979ede","scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"_npmUser":{"name":"iarth","email":"onlyarth@gmail.com"},"deprecated":"Package no longer supported. Contact Support at https://www.npmjs.com/support for more info.","repository":{"url":"git+https://github.com/4i8/qmy.git","type":"git"},"_npmVersion":"6.14.4","description":"Quick mysql is a powerful module that makes the mysql system easier, simpler and faster","directories":{},"_nodeVersion":"13.14.0","dependencies":{"got":"^11.8.2","chalk":"^4.1.2","mysql":"^2.18.1"},"_hasShrinkwrap":false,"_npmOperationalInternal":{"tmp":"tmp/qmy_0.2.2-beta_1636306907419_0.43834533812891174","host":"s3://npm-registry-packages"}},"1.0.0-Stable":{"name":"qmy","version":"1.0.0-Stable","keywords":["mysql","quickmysql","db","database","sql","quick"],"author":{"name":"Arth"},"license":"Apache-2.0","_id":"qmy@1.0.0-Stable","maintainers":[{"name":"iarth","email":"onlyarth@gmail.com"}],"homepage":"https://github.com/4i8/qmy#readme","bugs":{"url":"https://github.com/4i8/qmy/issues"},"dist":{"shasum":"ea52255fff501922d9b34546b0299a860d6cd726","tarball":"https://registry.npmjs.org/qmy/-/qmy-1.0.0-Stable.tgz","fileCount":17,"integrity":"sha512-w5QUNIvHw3z7f+6MB0JjnL7w1DRL23JxQAtOa/rHo4KtC0DFk4sF7ZR+rqGQeBXjB47IFTIi4rWr1NyCHcIMnQ==","signatures":[{"sig":"MEQCIFfXdxYQvsN3ulpy7BY4cadKBsguc+o50bxjGOKZVzCVAiAUxDgXFyy7skMSl0DwGBX+xT4cnGANpP+i1z/aFi+DUQ==","keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA"}],"unpackedSize":34009,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v3.0.13\r\nComment: https://openpgpjs.org\r\n\r\nwsFcBAEBCAAQBQJhr2f2CRA9TVsSAnZWagAAn9QQAIgXRetA1Kfdg62gsGt6\nkD/DbDTt6CnRZqVHBiYPKBLx2arEPYUzJhFHbgFNPGqCJHoZqeKgi4u9Nlb3\n7LM0JvodpFiToA6LKklaedYeF/+9IuBP7Tw5yh+jdZ3tFK0jotAwvVpD8/Ps\nX069q1YIj+Gz6aQjaHi/CRAlZiTNT2BCXmK9C9vMukuEFVL+jMCoehiMBAln\nNQdsoGBjEhmiQL+O6wIrI5ywiBfnxLtQGAeP7q3pRIPu6L5OOU6+QyG24rQQ\nVc/HHhPRLxpoVUxP7Yv2IDiVwvUHbyeZfLNk5Ttpg4zPIRMATwZu6CyaAQLX\nYkuP3MNedU620GYZoK39Nr26AnxIvld43jFN6jL9OsiibTaG8Ect6VaOhhtm\njtuxIVKfqLE9/3RR2q3kcGWDJQ+lCKIiqvipCirXXz390brXM7qyl8JEHdAj\nbF707VHNoqE/yqQvbKK16w+6a/8ypjhiWfG2zbxP+oI7WEjTdqAeKGtuU2gV\n9EZf7w4T0bu5heGi2iffziJGYIPss0Qm/87W9Y/ick1I8PT1MaFb6+odbfQ2\nCd9vPwN/MoBrF9kuhlK15QmflSAJzJLGQ2tv2XdjYSaUPIBlUNYZZ8s8OjYY\nYs1ho2NjC+1E35Ae/Rgmk7lT06fOAHJHfTqmivrkYasKjFf2jcZgZ+4NfdTR\ntx3l\r\n=Nn6y\r\n-----END PGP SIGNATURE-----\r\n"},"main":"index.js","gitHead":"2dfd53ec85f4c229361bff68c0d5a84d875b4c87","scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"_npmUser":{"name":"iarth","email":"onlyarth@gmail.com"},"deprecated":"Package no longer supported. Contact Support at https://www.npmjs.com/support for more info.","repository":{"url":"git+https://github.com/4i8/qmy.git","type":"git"},"_npmVersion":"6.14.4","description":"Quick mysql is a powerful module that makes the mysql system easier, simpler and faster","directories":{},"_nodeVersion":"13.14.0","dependencies":{"got":"^11.8.2","chalk":"^4.1.2","mysql":"^2.18.1"},"_hasShrinkwrap":false,"_npmOperationalInternal":{"tmp":"tmp/qmy_1.0.0-Stable_1638885366217_0.37466697476456057","host":"s3://npm-registry-packages"}},"1.2.2-Stable":{"name":"qmy","version":"1.2.2-Stable","keywords":["mysql","quickmysql","db","database","sql","quick"],"author":{"name":"Arth"},"license":"Apache-2.0","_id":"qmy@1.2.2-Stable","maintainers":[{"name":"iarth","email":"onlyarth@gmail.com"}],"homepage":"https://github.com/4i8/qmy#readme","bugs":{"url":"https://github.com/4i8/qmy/issues"},"dist":{"shasum":"e25da5f6a3cd779674a0fb2f39160770648edc6c","tarball":"https://registry.npmjs.org/qmy/-/qmy-1.2.2-Stable.tgz","fileCount":15,"integrity":"sha512-pgAa61o7rU0UtLjgXQ3sUQH3G0HhOAXcTq9k5qoL8Tarf1HNGnK9hd9hdIvoWO1iLaEfXaZ7x7oVkvTXibDqWg==","signatures":[{"sig":"MEQCIFTglssDhRNz2yH/fKjKIy6Qpt/i5tL9SgT5hDnc7EJCAiBGoDYmgUJsUIEeg01/usJrJswtIBaHBTm2l2Z6pyuGhg==","keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA"}],"unpackedSize":66057,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v4.10.10\r\nComment: https://openpgpjs.org\r\n\r\nwsFzBAEBCAAGBQJiExD7ACEJED1NWxICdlZqFiEECWMYAoorWMhJKdjhPU1b\r\nEgJ2VmrijQ/+NZH3U8IylU/vKF+h5mgwfldaT2VSDGVA+z8+D7zLXadNR9qk\r\npJTQ4dMqVeL5pSj21lYVSwTUzeREckd7sv4awJNz4ao8kvnd1YkWtPIUHosm\r\nwC0TvRb3beSIVKKPg8hfeg00jA9HQHy/yq3P5aMauEqfIop8HBjQweebPFKo\r\n0ujcRrlrKjnM/olRdZn637mHk0kxa9Z1m6yp6GplvAN6hsPiCzJi/q8LntZN\r\nT917dhbOH/bByD9hGOmtqqPrwq4/pFHfwpzNzQ1SUQMu0Qf7ozK6Rq2RJAyK\r\n3xtx8K+93/Il6RJrlHhZ8Sn12Oe2Tl7XYAHKXIiXW8d4UHL8hGPk6+qIMtl2\r\na9GFkKl7ujEoqlRpC6ZCfgDg37ZG9OFOHSX/ZZwXFIqoD3AdAGDxsbjYA3hg\r\nBEet4xLko78BiyMr/3ZoVRxlqGyOrWhP8PqOfAr6EpKxKWGptaQuJS5czTzL\r\nexqNGVDMbZsiiEZcuR4vBdEiM49qSR24UpPB3ZR5c8L7Whdic5fj81hA4wgl\r\nF/leOKOhMepSB8dXxDZzh1BHoo8MUgNpPpliLYOAH/SwmkSINOQjH9MbZgEa\r\nAXsUpHL9hXCTYQcCjeXvJ9buYBvt3nxz2ld4kE4zDl3HnX0l4US8r2WYbVv8\r\nQbSreA4Wjy7f0umjsiTFlws17OG5X7bSr7A=\r\n=Lt+K\r\n-----END PGP SIGNATURE-----\r\n"},"main":"index.js","gitHead":"33be3aa5117184743ab378c1aa160b061eddbcfa","scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"_npmUser":{"name":"iarth","email":"onlyarth@gmail.com"},"deprecated":"Package no longer supported. Contact Support at https://www.npmjs.com/support for more info.","repository":{"url":"git+https://github.com/4i8/qmy.git","type":"git"},"_npmVersion":"6.14.11","description":"Quick mysql is a powerful module that makes the mysql system easier, simpler and faster","directories":{},"_nodeVersion":"14.16.0","dependencies":{"got":"^11.8.2","chalk":"^4.1.2","mysql":"^2.18.1"},"_hasShrinkwrap":false,"_npmOperationalInternal":{"tmp":"tmp/qmy_1.2.2-Stable_1645416698895_0.33543395550528565","host":"s3://npm-registry-packages"}}},"time":{"created":"2021-10-29T11:07:26.393Z","modified":"2025-01-31T20:26:28.970Z","1.0.0":"2021-10-29T11:05:21.400Z","0.0.1-security":"2021-10-29T11:07:26.517Z","0.1.0-beta":"2021-10-29T13:10:23.725Z","0.1.1-beta":"2021-11-05T00:33:04.878Z","0.2.2-beta":"2021-11-07T17:41:47.603Z","1.0.0-stable":"2021-12-06T02:04:09.390Z","1.0.0-Stable":"2021-12-07T13:56:06.411Z","1.1.5":"2022-02-21T02:09:23.926Z","1.1.0-Stable":"2022-02-21T03:44:09.467Z","1.1.1-Stable":"2022-02-21T04:02:42.351Z","1.2.1-Stable":"2022-02-21T04:05:51.093Z","1.2.2-Stable":"2022-02-21T04:11:39.058Z"},"bugs":{"url":"https://github.com/4i8/qmy/issues"},"author":{"name":"Arth"},"license":"Apache-2.0","homepage":"https://github.com/4i8/qmy#readme","keywords":["mysql","quickmysql","db","database","sql","quick"],"repository":{"url":"git+https://github.com/4i8/qmy.git","type":"git"},"description":"Quick mysql is a powerful module that makes the mysql system easier, simpler and faster","maintainers":[{"email":"onlyarth@gmail.com","name":"iarth"},{"email":"naimabd1321@gmail.com","name":"naimabd"}],"readme":"
\r\n

\r\n \"qmy\"\r\n

\r\n

\r\n \r\n \"NPM\r\n \"NPM\r\n \"Discord\r\n\r\n

\r\n
\r\n\r\n## About\r\n\r\nQuick [mysql](https://www.mysql.com/) is a powerful module that makes the mysql system easier, simpler and faster\r\n\r\n- Speed\r\n- Unlimited connection without losing connection\r\n- Easy to use\r\n- High security\r\n\r\n## Installation\r\n\r\n```sh-session\r\nnpm install qmy\r\nyarn add qmy\r\n```\r\n\r\n## Announcement \r\n\r\n> **(+)connect() will resolve the process by calling the then() function and it will give you a notification that the connection was successful if there is an error, it will reject the process and you can call the catch() function and it will give you the error
(-)Remove Reminders New Versions**\r\n\r\n## Example usage\r\n\r\n> **Connection Config**\r\n\r\n```js\r\n host: \"localhost\",\r\n port: 3306,\r\n localAddress: undefined,\r\n socketPath: undefined,\r\n user: undefined,\r\n password: undefined,\r\n database: undefined,\r\n connectTimeout: 10000,\r\n insecureAuth: false,\r\n supportBigNumbers: false,\r\n bigNumberStrings: false,\r\n dateStrings: false,\r\n debug: undefined,\r\n trace: true,\r\n stringifyObjects: false,\r\n timezone: \"local\",\r\n flags: \"\",\r\n queryFormat: undefined,\r\n pool: undefined,\r\n ssl: false,\r\n localInfile: true,\r\n multipleStatements: false,\r\n typeCast: true,\r\n maxPacketSize: 0,\r\n charsetNumber: 33,\r\n clientFlags: 455631,\r\n protocol41: true,\r\n```\r\n\r\n### #Note\r\n\r\n##### Direct connection problem solving: [Here](#connect)\r\n\r\n> **create connection**\r\n\r\n**Start by creating a connection to the database.\r\nUse the username and password from your MySQL database or use uri**\r\n\r\n```js\r\nconst qmy = require(\"qmy\");\r\n\r\nconst connection = new qmy({\r\n database: \"\",\r\n host: \"\",\r\n password: \"\",\r\n port: 3306,\r\n user: \"\",\r\n});\r\n```\r\n\r\n## Documentation\r\n\r\n\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n
MethodDescriptionexplain
connectconnect() will resolve the process by calling the then() function and it will give you a notification that the connection was successful if there is an error, it will reject the process and you can call the catch() function and it will give you the error\r\nGo to example
queryUse SQL statements to read from (or write to) a MySQL database. This is also called \"to query\" the database.\r\nThe connection object created in the example above, has a method for querying the databaseGo to example
getused to select data from a databaseGo to example
removeused to delete existing records in a tableGo to example
setused to insert new records in a tableGo to example
updateused to modify the existing records in a tableGo to example
\r\n\r\n## connect\r\n\r\n```js\r\nconst qmy = require(\"qmy\");\r\n\r\nconst connection = new qmy({\r\n database: \"\",\r\n host: \"\",\r\n password: \"\",\r\n port: 3306,\r\n user: \"\",\r\n});\r\nconnection\r\n .connect()\r\n .then(() => {\r\n //do something\r\n //...\r\n })\r\n .catch((error) => {\r\n //do something\r\n //...\r\n console.log(error);\r\n });\r\n```\r\n\r\n## query\r\n\r\n```js\r\nconst qmy = require(\"qmy\");\r\n\r\nconst connection = new qmy({\r\n database: \"\",\r\n host: \"\",\r\n password: \"\",\r\n port: 3306,\r\n user: \"\",\r\n});\r\nconnection\r\n .connect()\r\n .then(() => {\r\n connection\r\n .query(\"\")\r\n .then((result) => {\r\n console.log(result);\r\n })\r\n .catch((err) => {\r\n console.log(err);\r\n });\r\n })\r\n .catch((error) => {\r\n //do something\r\n //...\r\n console.log(error);\r\n });\r\n```\r\n\r\n## get\r\n\r\n```js\r\nconst qmy = require(\"qmy\");\r\n\r\nconst connection = new qmy({\r\n database: \"\",\r\n host: \"\",\r\n password: \"\",\r\n port: 3306,\r\n user: \"\",\r\n});\r\nconnection\r\n .connect()\r\n .then(() => {\r\n connection\r\n .get(\"\", \":\")\r\n .then((result) => {\r\n console.log(result);\r\n })\r\n .catch((err) => {\r\n console.log(err);\r\n });\r\n })\r\n .catch((error) => {\r\n //do something\r\n //...\r\n console.log(error);\r\n });\r\n```\r\n\r\n## remove\r\n\r\n```js\r\nconst qmy = require(\"qmy\");\r\n\r\nconst connection = new qmy({\r\n database: \"\",\r\n host: \"\",\r\n password: \"\",\r\n port: 3306,\r\n user: \"\",\r\n});\r\nconnection\r\n .connect()\r\n .then(() => {\r\n connection\r\n .remove(\"
\", \":\")\r\n .then((result) => {\r\n console.log(result);\r\n })\r\n .catch((err) => {\r\n console.log(err);\r\n });\r\n })\r\n .catch((error) => {\r\n //do something\r\n //...\r\n console.log(error);\r\n });\r\n```\r\n\r\n## set\r\n\r\n```js\r\nconst qmy = require(\"qmy\");\r\n\r\nconst connection = new qmy({\r\n database: \"\",\r\n host: \"\",\r\n password: \"\",\r\n port: 3306,\r\n user: \"\",\r\n});\r\nconnection\r\n .connect()\r\n .then(() => {\r\n connection\r\n .set(\r\n {\r\n table: \"users\",\r\n column: \"id - name - color\",\r\n values: \"2324249073 - arth - red\",\r\n },\r\n { sign: \"-\" }\r\n )\r\n .then((result) => {\r\n console.log(result);\r\n })\r\n .catch((err) => {\r\n console.log(err);\r\n });\r\n })\r\n .catch((error) => {\r\n //do something\r\n //...\r\n console.log(error);\r\n });\r\n```\r\n\r\n## update\r\n\r\n```js\r\nconst qmy = require(\"qmy\");\r\n\r\nconst connection = new qmy({\r\n database: \"\",\r\n host: \"\",\r\n password: \"\",\r\n port: 3306,\r\n user: \"\",\r\n});\r\nconnection\r\n .connect()\r\n .then(() => {\r\n connection\r\n .update({\r\n table: \"users\",\r\n column: \"name\",\r\n PrimaryKey: \"id:2324249073\",//:\r\n value: \"arth\",\r\n })\r\n .then((result) => {\r\n console.log(result);\r\n })\r\n .catch((err) => {\r\n console.log(err);\r\n });\r\n })\r\n .catch((error) => {\r\n //do something\r\n //...\r\n console.log(error);\r\n });\r\n```\r\n\r\n## Links\r\n\r\n- [Twiter](https://twitter.com/onlyarth)\r\n- [Github](https://github.com/4i8)\r\n- [Documentation](#documentation)\r\n\r\n## License\r\n\r\n- [Apache-2.0](https://www.apache.org/licenses/LICENSE-2.0)\r\n","readmeFilename":"README.md"}