{"_id":"escape-sql-string","_rev":"2-785ddfd22110935649739710ae1d0b62","name":"escape-sql-string","dist-tags":{"latest":"1.2.2"},"versions":{"1.2.0":{"name":"escape-sql-string","version":"1.2.0","description":"Simple SQL string escape.","main":"dist/index.js","types":"dist/index.d.ts","devDependencies":{"@babel/core":"^7.21.0","@babel/preset-env":"^7.20.2","@babel/preset-typescript":"^7.21.0","@types/jest":"^29.4.0","babel-jest":"^29.5.0","jest":"^29.5.0","prettier":"^2.8.4","typescript":"^4.9.5"},"repository":{"type":"git","url":"git://github.com/jackall3n/escape-sql-string.git"},"homepage":"https://github.com/jackall3n/escape-sql-string","keywords":["sql","escape","injection","security"],"author":{"name":"Jack Allen","email":"me@jackallen.me","url":"https://jck.dev"},"license":"MIT","scripts":{"test":"jest","build":"tsc"},"bugs":{"url":"https://github.com/jackall3n/escape-sql-string/issues"},"_id":"escape-sql-string@1.2.0","_integrity":"sha512-zNf6Nh4vK+RKDp4/vdad5FdqsdTv1V1cRGCK+1Rrqv/9H69ZowZMAESAGTwgNjFoe9agZaVUkmbVfnKpMYvtmg==","_resolved":"/private/var/folders/kw/mdfd9y1j2w93q88r2qs2s_mw0000gn/T/a7ca7cf72c73481e9fefb008ebda0798/escape-sql-string-1.2.0.tgz","_from":"file:escape-sql-string-1.2.0.tgz","_nodeVersion":"18.13.0","_npmVersion":"8.19.3","dist":{"integrity":"sha512-zNf6Nh4vK+RKDp4/vdad5FdqsdTv1V1cRGCK+1Rrqv/9H69ZowZMAESAGTwgNjFoe9agZaVUkmbVfnKpMYvtmg==","shasum":"dc8614497fb97b781775f2e6ea6a93b32ed9635a","tarball":"https://registry.npmjs.org/escape-sql-string/-/escape-sql-string-1.2.0.tgz","fileCount":4,"unpackedSize":5132,"signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEQCIH9I+hHalvYTVyTH5J4WAIKvczSRZqZyJzFOZIsFc0lKAiBgYVFfwbzUkoVNtp/qvEScBahIrlsMaGfyKZIXJddxAQ=="}],"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v4.10.10\r\nComment: https://openpgpjs.org\r\n\r\nwsFzBAEBCAAGBQJkDiEhACEJED1NWxICdlZqFiEECWMYAoorWMhJKdjhPU1b\r\nEgJ2VmoTlQ/9FlMJKXoEJjg4ZJ5+ex3cU+IcNXesx79UGrFQQpqsuP0H9l7Q\r\nvPkFQvNUuLw7VYNi2mpsRj3lP6ZgWDpo5y/IM0VpvNYgkU9xW1hzymsR2Ukr\r\n2rJmHOC07AqFsbItUTCekWbNheOtIApet53y0IamFrf0+mK0RsIb5ukBhXIq\r\nzur1mNuqiZwZBR+GZLWPI/L90rVZdNrCY+q7L7l0VtTOOASnVRQ/aQfe+5hJ\r\nQv1XixcVim3guY3udNhFQCnb34z9hNCQytoA+YLnA0ajkwYJRxUAxjWoWofH\r\nJq91fbNuZEBI2nJ8JtF1MKZXee5Tye4jAvt88Bvk5NPJvEmh5XnZrk+AqUb/\r\nAB8h5PswDp4lwA/HMskBUadto+fkzW+Ct76CMSUCHzr4tPPBgLqMn/eg/H8X\r\nFKOWugSoc7auuPTr4j19XhrsIqyRjFDS0mp53NXTHylDunVol0z/E/Dvvkp0\r\nd9IXkg7Kjw3UmbC2YoNMsxapyVC3fjaA0pzyGKZoJfyFnqa8MJlKITSvAFV1\r\nah0vID3jeGOk9sJTQgRys3HtRyhCPdoBjwQN9KjjriIuYOPriD6cje8PNREY\r\nj07qH6lYQrHAQezFZ3ifTUTK/rLK9aoGKyxWSZj5uXcB3pu1Y8dUgGcbtd/7\r\nbOQYb+NRweH08+YTWaqL9AgL6LQGFJd+jKM=\r\n=o4mw\r\n-----END PGP SIGNATURE-----\r\n"},"_npmUser":{"name":"jackall3n","email":"jackallensemail+npm@gmail.com"},"directories":{},"maintainers":[{"name":"jackall3n","email":"jackallensemail+npm@gmail.com"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/escape-sql-string_1.2.0_1678647585671_0.9753821795237256"},"_hasShrinkwrap":false},"1.2.1":{"name":"escape-sql-string","version":"1.2.1","description":"Simple SQL string escape.","main":"dist/index.js","types":"dist/index.d.ts","devDependencies":{"@babel/core":"^7.21.0","@babel/preset-env":"^7.20.2","@babel/preset-typescript":"^7.21.0","@types/jest":"^29.4.0","babel-jest":"^29.5.0","jest":"^29.5.0","prettier":"^2.8.4","typescript":"^4.9.5"},"repository":{"type":"git","url":"git://github.com/jackall3n/escape-sql-string.git"},"homepage":"https://github.com/jackall3n/escape-sql-string","keywords":["sql","escape","injection","security"],"author":{"name":"Jack Allen","email":"me@jackallen.me","url":"https://jck.dev"},"license":"MIT","scripts":{"test":"jest","build":"tsc"},"bugs":{"url":"https://github.com/jackall3n/escape-sql-string/issues"},"_id":"escape-sql-string@1.2.1","_integrity":"sha512-NXfYDAdFeOcpBnkyY2lu+yTZoUj/aOTufmMIq0Rlzun1tXcpYny07n+iUQu2uDanjbrzLl+0XlefF+NO8ucUsw==","_resolved":"/private/var/folders/kw/mdfd9y1j2w93q88r2qs2s_mw0000gn/T/e7899c2e3fb45ea3f5d96db68f994d25/escape-sql-string-1.2.1.tgz","_from":"file:escape-sql-string-1.2.1.tgz","_nodeVersion":"18.13.0","_npmVersion":"8.19.3","dist":{"integrity":"sha512-NXfYDAdFeOcpBnkyY2lu+yTZoUj/aOTufmMIq0Rlzun1tXcpYny07n+iUQu2uDanjbrzLl+0XlefF+NO8ucUsw==","shasum":"eaeb0d352c29b3923d93ec3663e0f7c2024ccba4","tarball":"https://registry.npmjs.org/escape-sql-string/-/escape-sql-string-1.2.1.tgz","fileCount":5,"unpackedSize":7697,"signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCICYZpvUup+CzluZwuYVyqetuU66NPWCHPGtW+tSAVC2LAiEAkcJP3ym9vNZz7uUjL74cPP7hsXZRdJNV81XC+afTLYk="}],"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v4.10.10\r\nComment: https://openpgpjs.org\r\n\r\nwsFzBAEBCAAGBQJkDiJwACEJED1NWxICdlZqFiEECWMYAoorWMhJKdjhPU1b\r\nEgJ2VmrSKxAAhTxVA7Dvvd7oC89BmK3qiHPuMcDNMK2NoPZExK6FBXLKdE8t\r\nMCIKzKWcLIMmO6IR/9AFg5gRX0J4TQWSTVYe/HGLDEpjShZPvkFI5fn6+NWB\r\nqwRJF7D7cU4IRLfG0xM9Cx+7kzVnEN9IMI4nJXLC5t6+anKqvARKr5KwhiHq\r\nzfmzMP2f7JvKJZBB+9S52NMh0h1VVXrrMQulQsM0jwQ3NPdHl8S4Bs8zsM8S\r\nl35e9yFgmXfzmiwNEsAlfcOtGjdcJWu9WTSr8eHXe4b/qzGmmVLwTknhWP/f\r\n4ruVkpE403/k3Rh+VQ6i2X3BsAdVLdRmtDwEkXT4zMYGLe35bA9JHg1kTbIL\r\nD4PCBXeMWyGuUiFlAVphzac2ULcp7M8qiTAzjYSQjTecLMUW5MqiWp8CF+2h\r\nU/pCVLACtrzlqLwyP7TkHbUHqmpzZZnsrUyUvnWp6NRLEF9mt1jqYPpE/Vvy\r\nT3SSqUYX/ZAJOiyJ/VHu4qfoDuRLH7H2rX8XN86BCOckJnwjWEnVtaLcsr38\r\nHrnlsjbhc96rri+9a1GhcQAGnE/BHTHDOtrgz2A7jUHpYvC2GC4M0/bMufY2\r\nyHrzsz2WpVysFEhq9F3Vaax9zLMt6YY1pevrN36gNP3JZIQXseCiuziE/yBB\r\nu9DYHeLGYAGf4ZSK1+Jzs57nS7yYqOO8uBg=\r\n=Ve8s\r\n-----END PGP SIGNATURE-----\r\n"},"_npmUser":{"name":"jackall3n","email":"jackallensemail+npm@gmail.com"},"directories":{},"maintainers":[{"name":"jackall3n","email":"jackallensemail+npm@gmail.com"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/escape-sql-string_1.2.1_1678647920163_0.8253093383304935"},"_hasShrinkwrap":false},"1.2.2":{"name":"escape-sql-string","version":"1.2.2","description":"Simple SQL string escape.","main":"dist/index.js","types":"dist/index.d.ts","devDependencies":{"@babel/core":"^7.21.0","@babel/preset-env":"^7.20.2","@babel/preset-typescript":"^7.21.0","@types/jest":"^29.4.0","babel-jest":"^29.5.0","jest":"^29.5.0","prettier":"^2.8.4","typescript":"^4.9.5"},"repository":{"type":"git","url":"git://github.com/jackall3n/escape-sql-string.git"},"homepage":"https://github.com/jackall3n/escape-sql-string","keywords":["sql","escape","injection","security"],"author":{"name":"Jack Allen","email":"me@jackallen.me","url":"https://jck.dev"},"license":"MIT","scripts":{"test":"jest","build":"tsc"},"bugs":{"url":"https://github.com/jackall3n/escape-sql-string/issues"},"_id":"escape-sql-string@1.2.2","_integrity":"sha512-d94H1vwMmAmchX+8+Zaj8GhaPW7vrayHxwLEu/1S34wVSj4D5Q+m+9mRCUgFa+IHSMdUg2QkE23CwSzVECgUmQ==","_resolved":"/private/var/folders/kw/mdfd9y1j2w93q88r2qs2s_mw0000gn/T/8222f2871e0e3925be1453f42a21a3bd/escape-sql-string-1.2.2.tgz","_from":"file:escape-sql-string-1.2.2.tgz","_nodeVersion":"18.13.0","_npmVersion":"8.19.3","dist":{"integrity":"sha512-d94H1vwMmAmchX+8+Zaj8GhaPW7vrayHxwLEu/1S34wVSj4D5Q+m+9mRCUgFa+IHSMdUg2QkE23CwSzVECgUmQ==","shasum":"4921cb64f7235e9d8e598bd4975bb7d405f73ecc","tarball":"https://registry.npmjs.org/escape-sql-string/-/escape-sql-string-1.2.2.tgz","fileCount":7,"unpackedSize":9155,"signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEQCIClp8DVT8f1dw/l3UlevESmbCScZAVI2uaY+VSmYWUf/AiA03yep9AAkwhbvEuVEU43AlK8mW9nJedbyUXPeAT7aqw=="}],"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v4.10.10\r\nComment: https://openpgpjs.org\r\n\r\nwsFzBAEBCAAGBQJkDiMCACEJED1NWxICdlZqFiEECWMYAoorWMhJKdjhPU1b\r\nEgJ2Vmo+lA//RdEbXuVFeUc3JJQH/Wb8pQERvMSPxGsg/oDEKhG0Y7r2DryI\r\nvgdywJyydW+XU1JzNhQwyOj6C/+8dGago8aCAJdstSx6cRAurwJvEiOuztU3\r\nK991wtcV7a0la4ndiArgNsjRlFiy2aW9uazcv4ZunotM+SWTMB9bOArhcE2f\r\nCb2Ybm1DcY5meA92dDJTP/JMdVw6nR0KNbBwEFBLmKnMuOKKfbMa+VV0yqy7\r\niJYw5CLB6d0MjPtKm7D2btap1I4Tn7rtheaiatiaf34CBWrjvRDLmQ6+efi0\r\nzSaSgF40TDKFn5JqcxzT3BJ38xxrH5wcWuwuTx9BAFQlOaTUigR1Bqkj7Hf1\r\ns6/r4t0eFZJLg7VMx2sE37ssm4EsjLGi4q6gPCit71UURntMDKA4xaVtQyMv\r\n5BIAjYV20QIX623caFWPYdJj31fpDpNcEfj0zSThEkAgn4MHdY8H9ecewL4D\r\n7K0jWAhghzhhT7x0D2feX0xbg1J+HBMpmmSzTutQea58vrG9hlOCvwvLjJEN\r\nKnDn5/I5Gbwa7GkH8qQJiz4La0tn/1+w3wzih/3xGUFDvVf2GRKAeZmXkciS\r\nbQA6AjMQaOwRgFP9tGEHS7JXtyp72karCd+sQXPN9N5JmMNUBS0U2myxUI4l\r\nFljyYxngz0Dy7TKwwl+e/1g0RdRuU0uThkM=\r\n=7Axe\r\n-----END PGP SIGNATURE-----\r\n"},"_npmUser":{"name":"jackall3n","email":"jackallensemail+npm@gmail.com"},"directories":{},"maintainers":[{"name":"jackall3n","email":"jackallensemail+npm@gmail.com"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/escape-sql-string_1.2.2_1678648066480_0.7971224504520509"},"_hasShrinkwrap":false}},"time":{"created":"2023-03-12T18:59:45.671Z","1.2.0":"2023-03-12T18:59:45.801Z","modified":"2023-03-12T19:07:46.740Z","1.2.1":"2023-03-12T19:05:20.312Z","1.2.2":"2023-03-12T19:07:46.656Z"},"maintainers":[{"name":"jackall3n","email":"jackallensemail+npm@gmail.com"}],"description":"Simple SQL string escape.","homepage":"https://github.com/jackall3n/escape-sql-string","keywords":["sql","escape","injection","security"],"repository":{"type":"git","url":"git://github.com/jackall3n/escape-sql-string.git"},"author":{"name":"Jack Allen","email":"me@jackallen.me","url":"https://jck.dev"},"bugs":{"url":"https://github.com/jackall3n/escape-sql-string/issues"},"license":"MIT","readme":"# escape-sql-string ![Github Workflow Status](https://github.com/jackall3n/escape-sql-string/actions/workflows/ci.yaml/badge.svg)\n\nSimple SQL string escape.\n\n```typescript\nimport escapeString from 'escape-sql-string';\n\nconst sqlString = \"Sup'er\"\nconsole.log(escapeString(sqlString)) // => Sup''er\n```\n\n## Installation\n\n npm install escape-sql-string\n\n## Note\n\nOriginal implementation from [sql-escape-string](https://thlorenz.github.io/sql-escape-string) with the added typescript support\n\n## [API](https://github.com/jackall3n/escape-sql-string)\n\n\n\n### escapeString\n\nEscapes the given string to protect against SQL injection attacks.\n\nBy default, it assumes that backslashes are not supported as they are not part of the standard SQL spec.\nQuoting from the [SQLite website](https://sqlite.org/lang_expr.html):\n\n> C-style escapes using the backslash character are not supported because they are not standard SQL.\n\nThis means three things:\n\n- backslashes and double quotes `\"` are not escaped by default\n- single quotes are escaped via `''` instead of `\\'`\n- your sql engine should throw an error when encountering a backslash escape\n as part of a string, unless it is a literal backslash, i.e. `'backslash: \\\\'`.\n\nIt is recommended to set the `backslashSupported` option `true` if your SQL\nengine supports it. In that case backslash sequences are escaped and single\nand double quotes are escaped via a backslash, i.e. `'\\''`.\n\n**Parameters**\n\n- `value` **[String](https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Global_Objects/String)** the original string to be used in a SQL query\n- `options` **[Object](https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Global_Objects/Object)** opts\n - `options.backslashSupported` **[Boolean](https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Global_Objects/Boolean)?** if `true` backslashes are supported (optional, default `false`)\n- `opts` \n\nReturns **[String](https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Global_Objects/String)** the original string escaped wrapped in single quotes, i.e. `'mystring'`\n\n## License\n\nMIT\n","readmeFilename":"README.md"}