{"_id":"@adrian294-ags/ags-sql-gen","_rev":"2-397f1c1d52d530be8b34da35f970fd79","name":"@adrian294-ags/ags-sql-gen","dist-tags":{"latest":"1.0.1"},"versions":{"1.0.0":{"name":"@adrian294-ags/ags-sql-gen","version":"1.0.0","keywords":["SQL"],"author":{"name":"Santiago, Adrian"},"license":"ISC","_id":"@adrian294-ags/ags-sql-gen@1.0.0","maintainers":[{"name":"adrian294-ags","email":"stgoadrian294@gmail.com"}],"homepage":"https://github.com/Adrian294-AGS/AGS-SQL-Template#readme","bugs":{"url":"https://github.com/Adrian294-AGS/AGS-SQL-Template/issues"},"dist":{"shasum":"b44aea1b891bf3e7d01bd2b1ec277a046c369de9","tarball":"https://registry.npmjs.org/@adrian294-ags/ags-sql-gen/-/ags-sql-gen-1.0.0.tgz","fileCount":4,"integrity":"sha512-xnGPuNBnnQwwXauX6lN4ETbsgZBnH9rAk2FFMyxxvjn0yJUaCVhWPXNoLLcoEo0hkI87FIMOYZMdDu2s8H5DMA==","signatures":[{"sig":"MEUCICcQPT2ZAsCSU+aiu3W3hDiXnBc85Z7SHHkfYXY+XryuAiEAy/7EAhlmSOTD6KkxHVRTgS4BaLGRaLGucFXlBH4Xk+g=","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":5934},"main":"index.js","type":"module","gitHead":"daaae12b0d88ae6ba27cf429c2315b3d4a60f79f","scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"_npmUser":{"name":"adrian294-ags","email":"stgoadrian294@gmail.com"},"repository":{"url":"git+https://github.com/Adrian294-AGS/AGS-SQL-Template.git","type":"git"},"_npmVersion":"10.9.2","description":"preset query","directories":{},"_nodeVersion":"22.14.0","dependencies":{"child_process":"^1.0.2"},"_hasShrinkwrap":false,"devDependencies":{"mysql2":"^3.15.2"},"_npmOperationalInternal":{"tmp":"tmp/ags-sql-gen_1.0.0_1760680709677_0.42450402632040785","host":"s3://npm-registry-packages-npm-production"}},"1.0.1":{"name":"@adrian294-ags/ags-sql-gen","version":"1.0.1","description":"preset query","main":"index.js","scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"type":"module","repository":{"type":"git","url":"git+https://github.com/Adrian294-AGS/AGS-SQL-Template.git"},"keywords":["SQL"],"author":{"name":"Santiago, Adrian"},"license":"ISC","bugs":{"url":"https://github.com/Adrian294-AGS/AGS-SQL-Template/issues"},"homepage":"https://github.com/Adrian294-AGS/AGS-SQL-Template#readme","dependencies":{"child_process":"^1.0.2"},"devDependencies":{"mysql2":"^3.15.2"},"_id":"@adrian294-ags/ags-sql-gen@1.0.1","gitHead":"a85cb99ba5a41a5798b1bd3ec1f7b555f7ddb889","_nodeVersion":"22.14.0","_npmVersion":"10.9.2","dist":{"integrity":"sha512-o5cgdOLhCenjUZMwCfDXFc1L3YlwSst37NG0slxXHHphNhpL1iEh7boG1FRlvI5yFTaLXHfSrVOH8cXHmaef2Q==","shasum":"8a7d012a075aac87722ab36298882e0495742dc4","tarball":"https://registry.npmjs.org/@adrian294-ags/ags-sql-gen/-/ags-sql-gen-1.0.1.tgz","fileCount":4,"unpackedSize":8087,"signatures":[{"keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U","sig":"MEQCIBGYwG6OT4zOLrrcPDIR2WrvbQKInBWmb0LLARgazj8FAiByLle3vwQAU3hTbhXSDXWwJCP4GahaxK6hxuCzpRudGQ=="}]},"_npmUser":{"name":"adrian294-ags","email":"stgoadrian294@gmail.com"},"directories":{},"maintainers":[{"name":"adrian294-ags","email":"stgoadrian294@gmail.com"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages-npm-production","tmp":"tmp/ags-sql-gen_1.0.1_1760682503203_0.6767105920404739"},"_hasShrinkwrap":false}},"time":{"created":"2025-10-17T05:58:29.598Z","modified":"2025-10-17T06:28:23.548Z","1.0.0":"2025-10-17T05:58:29.900Z","1.0.1":"2025-10-17T06:28:23.386Z"},"bugs":{"url":"https://github.com/Adrian294-AGS/AGS-SQL-Template/issues"},"author":{"name":"Santiago, Adrian"},"license":"ISC","homepage":"https://github.com/Adrian294-AGS/AGS-SQL-Template#readme","keywords":["SQL"],"repository":{"type":"git","url":"git+https://github.com/Adrian294-AGS/AGS-SQL-Template.git"},"description":"preset query","maintainers":[{"name":"adrian294-ags","email":"stgoadrian294@gmail.com"}],"readme":"# AGS SQL Library\r\n\r\nAGS is a lightweight Node.js MySQL helper library that simplifies database operations such as **SELECT**, **INSERT**, **UPDATE**, **DELETE**, and **JOIN** queries.  \r\nIt also includes a fun bonus function: `getDadJokes()` — because debugging is better with a laugh. 😄\r\n\r\n---\r\n\r\n## 🚀 Features\r\n\r\n- Simple MySQL query wrapper using async/await  \r\n- Automatic handling for:\r\n  - Single or multiple table queries\r\n  - Batch insert, update, and delete\r\n- Built-in JOIN methods (INNER, LEFT, RIGHT)\r\n- Minimal setup required — just plug in your MySQL connection\r\n- Fun extra: fetches a random dad joke via `curl`\r\n\r\n---\r\n\r\n## 📦 Installation\r\n\r\n```bash\r\nnpm install ags-sql-lib\r\n\r\n## Importing\r\nimport AGS from \"ags-sql-lib\";\r\n\r\nconst sql = new AGS(\"root\", \"password\", \"localhost\", \"my_database\");\r\n\r\n// Select all columns\r\nconst result = await sql.select(\"*\", \"users\");\r\n\r\n// Select from multiple tables\r\nconst result = await sql.select(\"*\", [\"users\", \"products\"]);\r\n\r\n// Single\r\nconst user = await sql.selectWithId(\"id\", \"*\", \"users\", 1);\r\n\r\n// Multiple\r\nconst users = await sql.selectWithId(\"id\", \"*\", \"users\", [1, 2, 3]);\r\n\r\n## InsertInto\r\n// Single insert\r\nawait sql.insertInto(\"users\", { name: \"John\", age: 25 });\r\n\r\n// Multiple inserts\r\nawait sql.insertInto(\"users\", [\r\n  { name: \"Alice\", age: 22 },\r\n  { name: \"Bob\", age: 30 }\r\n]);\r\n\r\n// Single update\r\nawait sql.update(\"id\", \"users\", { age: 26 }, 1);\r\n\r\n// Multiple updates\r\nawait sql.update(\"id\", \"users\", [{ age: 22 }, { age: 28 }], [1, 2]);\r\n\r\n## DELETE\r\n\r\n// Single delete\r\nawait sql.delete(\"users\", \"id\", 1);\r\n\r\n// Multiple delete\r\nawait sql.delete(\"users\", \"id\", [2, 3]);\r\n\r\n## Joining Table\r\n\r\n// LEFT JOIN example\r\nconst result = await sql.selectLeftAndRightJoin(\r\n  \"users\",\r\n  \"orders\",\r\n  \"users.name, orders.total\",\r\n  \"users.id = orders.user_id\",\r\n  \"users.id\",\r\n  \"LEFT JOIN\",\r\n  1\r\n);\r\n\r\n// INNER JOIN\r\nconst result = await sql.selectInnerJoin(\r\n  \"users\",\r\n  \"orders\",\r\n  \"users.name, orders.total\",\r\n  \"users.id = orders.user_id\"\r\n);\r\n\r\n## BONUS\r\n\r\nimport { getDadJokes } from \"ags-sql-lib\";\r\n\r\nconst joke = await getDadJokes();\r\nconsole.log(joke);\r\n","readmeFilename":"README.md"}