{"_id":"@ariel-biton-sharecare/connect-session-knex","_rev":"2-61331f00421946593fce07b13445cbb3","name":"@ariel-biton-sharecare/connect-session-knex","dist-tags":{"latest":"3.0.3"},"versions":{"3.0.1":{"name":"@ariel-biton-sharecare/connect-session-knex","description":"A knex.js session store for Express and Connect (temp fork to support knex 2.1.0)","version":"3.0.1","main":"lib/index.js","typings":"typings/index.d.ts","engines":{"node":">=8"},"repository":{"type":"git","url":"git+ssh://git@github.com/ariel-biton-sharecare/connect-session-knex.git"},"bugs":{"url":"https://github.com/gx0r/connect-session-knex/issues"},"homepage":"https://github.com/gx0r/connect-session-knex","scripts":{"test":"node tests/index.js","lint":"eslint lib/ tests/","lint-fix":"eslint --fix lib/ tests"},"license":"ISC","dependencies":{"bluebird":"^3.7.2","knex":"^2.1.0"},"devDependencies":{"eslint":"^8.2.0","eslint-config-airbnb-base":"^14.2.1","eslint-plugin-import":"^2.25.2","express":"^4.17.1","express-session":"^1.17.2","mysql":"^2.18.1","pg":"^8.7.1","sqlite3":"^4.2.0","tape":"^5.3.1"},"directories":{"example":"examples","lib":"lib","test":"tests"},"gitHead":"a563c2fac559e02e800511ef3c06aeabf77ef9a6","_id":"@ariel-biton-sharecare/connect-session-knex@3.0.1","_nodeVersion":"16.15.0","_npmVersion":"8.5.5","dist":{"integrity":"sha512-+s8ErpL9Vpr/oUa0Bei7Yp/C2WLui+ezPniTxrmkX2QMTBqdGBRe7SNP4bzzzo9KIIbcNfacTxdgT5QpeLNMaA==","shasum":"02fdb9da0717160f62c8b3d1f26a7fbfecc5d4ee","tarball":"https://registry.npmjs.org/@ariel-biton-sharecare/connect-session-knex/-/connect-session-knex-3.0.1.tgz","fileCount":6,"unpackedSize":21529,"signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIQCXLvMceFfloRc6CX4Ad+dASRIljkdNjFhGxuCnhP6C7wIgNO9xdCjBv9PIDPqq7/qRdM8/1lFAodGfgFzAumk8chU="}],"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v4.10.10\r\nComment: https://openpgpjs.org\r\n\r\nwsFzBAEBCAAGBQJilkQOACEJED1NWxICdlZqFiEECWMYAoorWMhJKdjhPU1b\r\nEgJ2VmpR2Q/8CfowjNApfGghVfgjjMFvhxicgQ7DI7dkfXc/zexneqLMMLPy\r\n9iC5GBEiYheWV5OgUKKfOTeB+/hCIcDDo2dY3ASgt9+x1YO3WS8PjyAieMlp\r\n+piLImcWjQxOZUD/GjuNYHoNglgxnhx+3YuLFE5M8SewoF2wjzFi/PgmhuNn\r\nyajEgTFR29gX7J9HyVsdUdJ1TcLgRW9o37QvbNrWRwb1gG+w/Txt1ZCfBsB0\r\nm9IL+8qa0Ba9UCz6PM1UvNuMqW+07VGobHYItMYOJwUOKi8mT+2OKPW2WwX3\r\nBpUN36T+4o7i7/VWpEZKmVwA1czTVnDJvxLPX8i4EepxhsdS7V6g9MPZe4ur\r\n/fLd+4VGITBCroTEzF3XroPvyap73DFz7lNU5tjNCAlA6vwr1LH7+dMbKLLc\r\ndLHvv1s9R/q16R8FMD+WuTnUBqmAQ5WfFNHjtdCUmqngiJgy8EhlPArsFlRt\r\nCOKCHnOfUmdOwO+5FDht67o7iQA/n/MyfOS2ntpzQscUfhzNKCt6XGaMX07i\r\ncPQ9jlUHMQeFEmgd8SXw2jZnEgF8eDDBONEfvimEu1U5TZV+qclTtETaFvLC\r\nybhwweOjaU65LS273ubkDiE5zOjrits4GnFk2UqLPVCaWL1mafzVNS4gjKGb\r\nGKnHam1BiISXb6jfazXi6nbj2VohNmkVKNI=\r\n=p7TH\r\n-----END PGP SIGNATURE-----\r\n"},"_npmUser":{"name":"ariel-biton-sharecare","email":"ariel.biton@sharecare.com"},"maintainers":[{"name":"ariel-biton-sharecare","email":"ariel.biton@sharecare.com"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/connect-session-knex_3.0.1_1654014990740_0.8666033063473295"},"_hasShrinkwrap":false},"3.0.2":{"name":"@ariel-biton-sharecare/connect-session-knex","description":"A knex.js session store for Express and Connect (temp fork to support knex 2.1.0)","version":"3.0.2","main":"lib/index.js","typings":"typings/index.d.ts","engines":{"node":">=8"},"repository":{"type":"git","url":"git+ssh://git@github.com/ariel-biton-sharecare/connect-session-knex.git"},"bugs":{"url":"https://github.com/gx0r/connect-session-knex/issues"},"homepage":"https://github.com/gx0r/connect-session-knex","scripts":{"test":"node tests/index.js","lint":"eslint lib/ tests/","lint-fix":"eslint --fix lib/ tests"},"license":"ISC","dependencies":{"bluebird":"^3.7.2","knex":"^2.1.0"},"devDependencies":{"eslint":"^8.2.0","eslint-config-airbnb-base":"^14.2.1","eslint-plugin-import":"^2.25.2","express":"^4.17.1","express-session":"^1.17.2","mysql":"^2.18.1","pg":"^8.7.1","sqlite3":"^4.2.0","tape":"^5.3.1"},"gitHead":"079a1b0d229dcc741b72acd5bee57f054a1f79b5","_id":"@ariel-biton-sharecare/connect-session-knex@3.0.2","_nodeVersion":"16.15.0","_npmVersion":"8.5.5","dist":{"integrity":"sha512-NdkHLFK/YRcS+763n5R/ufHV6PH4kGk5oXSPfi9PQtRIlyqVpGuMV8XHcKDtUIkD9CYIosvgpDWToOHX9E1Swg==","shasum":"8b079125327428623c50e6ceff982b686c797c8e","tarball":"https://registry.npmjs.org/@ariel-biton-sharecare/connect-session-knex/-/connect-session-knex-3.0.2.tgz","fileCount":6,"unpackedSize":21430,"signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEQCIHKzcmHFBYIqnjXY4fYInp8KYC/8ue+IM8VhPhu/jJicAiBzceGqB/a0EvPGg6RG/AiH23ftV39q2Gn8GnIwzTn5nA=="}],"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v4.10.10\r\nComment: https://openpgpjs.org\r\n\r\nwsFzBAEBCAAGBQJilkbxACEJED1NWxICdlZqFiEECWMYAoorWMhJKdjhPU1b\r\nEgJ2VmrWzg//QJ9nOKtJIj4StaRmBsFgLc5pKQZ945wammc0TChkwy8E+eJO\r\n1DpbhSxRrZQmpWMgBLEUvVhtaPfmdO7vPuOI6/meKcJek2lMrmGKbhNhV7bE\r\nMwPlKr3fjKaw+g93+BakZcpVSxDuP50lvVEnqbqBlOT2CAHQOZtklx9+piFF\r\nKWt2iHU4V6EPeH4StlL8lXHLjCiF+pybIgm/Nbj9Gf2sLeS7/y07HwYOUrsa\r\nhI0c0tFO6HA7ip27CDsyarvBS6tyYHtZsD9svxC7WTStmBO7gmhaVdulpGY3\r\nFckjv2c3Gc/j5SnPPb6n1XdW7vMwIrNgk8r9IwRcd+Di1Hacl2bOvp9CxelI\r\nw37s5xypiKTjEJ/R8fbRHNU+A/rNoaCBNkcUNv50/yTHh9E53PAQu4j80QcA\r\n3kz6RaOyKY7fN7RMtsJ7IAfD0GRdcDJn1UcfReJPj+1ZPZmt+S5NMM2pbz58\r\nrQ/6kDTrKvPkRtNLOtrMYzUDT6v9CAUtDrX4moY3jvg/iIBJXAW3uGb1xzVL\r\nR7cUp+jOUtDUntBJ3mFTnBTkekmccz/94nVzLgXlGakYjVeVwRAPO0VkeVbD\r\nhbZyb6UZIhPdyPxeaEVIGlT0BnkDtaN4DKX4+xdwNduYFLNDQ0TUPJnRdmC0\r\n4lpHBfzP97orIqBZZfMqmh1UGCcXHHsRehA=\r\n=BuTV\r\n-----END PGP SIGNATURE-----\r\n"},"_npmUser":{"name":"ariel-biton-sharecare","email":"ariel.biton@sharecare.com"},"directories":{},"maintainers":[{"name":"ariel-biton-sharecare","email":"ariel.biton@sharecare.com"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/connect-session-knex_3.0.2_1654015728968_0.4822138524183637"},"_hasShrinkwrap":false},"3.0.3":{"name":"@ariel-biton-sharecare/connect-session-knex","description":"A knex.js session store for Express and Connect (temp fork to support knex 2.1.0)","version":"3.0.3","main":"lib/index.js","typings":"typings/index.d.ts","engines":{"node":">=8"},"repository":{"type":"git","url":"git+ssh://git@github.com/ariel-biton-sharecare/connect-session-knex.git"},"bugs":{"url":"https://github.com/gx0r/connect-session-knex/issues"},"homepage":"https://github.com/gx0r/connect-session-knex","scripts":{"test":"node tests/index.js","lint":"eslint lib/ tests/","lint-fix":"eslint --fix lib/ tests"},"license":"ISC","dependencies":{"bluebird":"^3.7.2","knex":"^2.1.0"},"devDependencies":{"eslint":"^8.2.0","eslint-config-airbnb-base":"^14.2.1","eslint-plugin-import":"^2.25.2","express":"^4.17.1","express-session":"^1.17.2","mysql":"^2.18.1","pg":"^8.7.1","sqlite3":"^4.2.0","tape":"^5.3.1"},"gitHead":"3f290ca7857d3821359b851034324bcb82abc388","_id":"@ariel-biton-sharecare/connect-session-knex@3.0.3","_nodeVersion":"16.15.0","_npmVersion":"8.5.5","dist":{"integrity":"sha512-icy6aWgF/tlyMuMxE+Va6SaHqm24eDYL52XrkTP1ZIYixHMveZVBn4nBIu8UpBJdt0eRYUWgju3MFi2JqDWxyQ==","shasum":"1e462eb0ee499e07ee50ddcf87565e846d599305","tarball":"https://registry.npmjs.org/@ariel-biton-sharecare/connect-session-knex/-/connect-session-knex-3.0.3.tgz","fileCount":6,"unpackedSize":21453,"signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEQCIC7sU7vQCNkgzjh0kXUx0pgx1cMtAAHbuksMA9hkGLLFAiAPLKCDv6/mjhfjmyP68ogf/To1mqwES49L6fq0gQromw=="}],"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v4.10.10\r\nComment: https://openpgpjs.org\r\n\r\nwsFzBAEBCAAGBQJilkhHACEJED1NWxICdlZqFiEECWMYAoorWMhJKdjhPU1b\r\nEgJ2VmqdRg/9HoS4S3YOkUHwRmukEkHnZk6OLKJJaMio/IG9Iv3C2Eh2i3Bp\r\nhNUtY/FQw6DBVRHDP1cBX2tIeDKGbY27gh7bpNe7Ylb5pTbSUCmpApNVAHml\r\n80immwdkMEybdZiEw7mDZsA+rbfeFdS8usq3CM/G+PJLWnjttKmbuI4qwKlV\r\n/5SHFq2KXdyE551lTvMD8i7saRFO0G1odAbUUGzc3lFcmP3bkr3FahwVLVJx\r\nuBHLnnoCiv7jPa6slTk5pPPnqaABNSigMeTJA78EIakqdIVC8r1uddOJ7yzk\r\n3txGGGnUPwiusBz+ov2eAPQ1PXaksCvmBJKPH5Wu6VxeC1dsnB0cVTp02skU\r\nQmXNzPcxbPYE/TcsbGW7eyvhBCzHiqWtuMrvwe+p0CR/QBTKtpu15bXnMmeV\r\n1tyid5sIGleIRK1WL5Tf0sj85ytCHUNS3yJc2JpFo7x+Jz9gckcbJ3pVyk/d\r\nPUMR9nRv075A2b5NkTiRuJl40b8GploisFjIVNIdH6U4ZMBtbDuiz59AWTUK\r\nYZ6wloZjDrnOSMENQ6BgyNMOLPJmPxRWpO5D6SobmygvnMyQ8+0s5xgnSOkS\r\nKR4G2Tb2mOOGHcFCx7WRXWhSeo8eQMoN9biAnFaJlQ5GQsFyMvD2T3X9yDzv\r\nN/MQAEIFJ7u0lzH52dE81yJ+opqNHdWA/ak=\r\n=fQPy\r\n-----END PGP SIGNATURE-----\r\n"},"_npmUser":{"name":"ariel-biton-sharecare","email":"ariel.biton@sharecare.com"},"directories":{},"maintainers":[{"name":"ariel-biton-sharecare","email":"ariel.biton@sharecare.com"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/connect-session-knex_3.0.3_1654016071620_0.7120423454861415"},"_hasShrinkwrap":false}},"time":{"created":"2022-05-31T16:36:30.667Z","3.0.1":"2022-05-31T16:36:30.941Z","modified":"2022-05-31T16:54:31.866Z","3.0.2":"2022-05-31T16:48:49.283Z","3.0.3":"2022-05-31T16:54:31.798Z"},"maintainers":[{"name":"ariel-biton-sharecare","email":"ariel.biton@sharecare.com"}],"description":"A knex.js session store for Express and Connect (temp fork to support knex 2.1.0)","homepage":"https://github.com/gx0r/connect-session-knex","repository":{"type":"git","url":"git+ssh://git@github.com/ariel-biton-sharecare/connect-session-knex.git"},"bugs":{"url":"https://github.com/gx0r/connect-session-knex/issues"},"license":"ISC","readme":"Temporary fork to work with Knex 2.1.0\n\n# Connect Session Knex\n\n\n[![NPM Version][npm-version-image]][npm-url]\n[![NPM Downloads][npm-downloads-image]][npm-url]\n[![Node.js Version][node-image]][node-url]\n[![NPM][npm-image]][npm-url]\n\nconnect-session-knex is an [express-session](https://github.com/expressjs/session) store backed by PostgreSQL, MySQL, MariaDB, MSSQL, Oracle or SQLite3, via the [knex.js](http://knexjs.org/) library.\n\n## Installation\n\n```sh\n$ npm install connect-session-knex\n```\n\n## History\n\nSee [Changelog.md](Changelog.md)\n\n## Usage\n\n[Example application using the defaults](https://github.com/gx0r/connect-session-knex/blob/master/examples/example.js)\n\n[Example application with PostgreSQL](https://github.com/gx0r/connect-session-knex/blob/master/examples/example-postgres.js)\n\n[With Express 3 or Connect](https://github.com/gx0r/connect-session-knex/blob/master/Oldversions.md)\n\n## Options\n\n - `tablename='sessions'` Tablename to use. Defaults to 'sessions'.\n - `sidfieldname='sid'` Field name in table to use for storing session ids. Defaults to 'sid'.\n - `knex` knex instance to use. Defaults to a new knex instance, using sqlite3 with a file named 'connect-session-knex.sqlite'\n - `createtable` if the table for sessions should be created automatically or not.\n - `clearInterval` milliseconds between clearing expired sessions. Defaults to 60000.\n - `disableDbCleanup` disables the automatic clearing of expired sessions. Defaults to false. \n\nIf the table does not exist in the schema, this module will attempt to create it unless the 'createtable' option is false.\n\nIf a knex instance is not provided, this module will attempt to create a sqlite3 database, with a file named 'connect-session-knex.sqlite', in the working directory of the process.\n\n## Schema\n\n### PostgreSQL or SQLite\n\n#### Table Name \"sessions\"  \n| Column  |           Type           | Modifiers | Storage  | \n|---------|:------------------------:|:---------:|:--------:|\n| sid     | character varying(255)   | not null  | extended |\n| sess    | json                     | not null  | extended |\n| expired | timestamp with time zone | not null  | plain    |  \n\n### Indexes:\n```  \n    \"sessions_pkey\" PRIMARY KEY, btree (sid)  \n    \"sessions_expired_index\" btree (expired)\n```\n\n## Benchmarks\n\n[https://github.com/gx0r/express-session-benchmarks](https://github.com/gx0r/express-session-benchmarks)\n\n[npm-version-image]: https://img.shields.io/npm/v/connect-session-knex.svg\n[npm-downloads-image]: https://img.shields.io/npm/dm/connect-session-knex.svg\n[npm-image]: https://nodei.co/npm/connect-session-knex.png?downloads=true&downloadRank=true&stars=true\n[npm-url]: https://npmjs.org/package/connect-session-knex\n[travis-image]: https://img.shields.io/travis/gx0r/connect-session-knex/master.svg\n[travis-url]: https://travis-ci.org/gx0r/connect-session-knex\n[node-image]: https://img.shields.io/node/v/connect-session-knex.svg\n[node-url]: http://nodejs.org/download/\n\n## Testing\n\nInstall Postgresql\n\nInstructions for Ubuntu after intalling the db:\n\n```bash\nsudo -u postgres psql\n```\n\n```sql\nCREATE DATABASE travis_ci_test OWNER postgres;\n```\n\n```sql\nGRANT all privileges ON DATABASE travis_ci_test TO postgres;\n```\n\n```sql\nALTER USER postgres WITH PASSWORD 'postgres';\n```\n\n```sql\n\\q\n```\n\nInstall Mysql\n\nInstructions for Ubuntu after installing the db:\n\n```bash\nsudo mysql -u root\n```\n\n```sql\ncreate user 'travis' identified by 'travis';\n```\n\n```sql\nALTER USER 'travis'@'localhost' IDENTIFIED BY 'travis';\n```\n\n```sql\ncreate database travis_ci_test;\n```\n\n```sql\ngrant all on travis_ci_test.* to 'travis';\n```\n\n```sql\n\\q\n```\n\n```bash\nsudo service mysql restart\n```\n\nMake sure both the MySQL and Postgres services are running\n\n```bash\nnpm run test\n```\n","readmeFilename":"Readme.md"}