{"_id":"@amnet/db-manager","_rev":"11-043cd86e4ae0c11702e4850759d0f1ad","time":{"created":"2023-12-21T08:24:00.149Z","1.0.0":"2023-12-21T08:20:25.006Z","modified":"2024-01-03T12:03:25.714Z","1.0.1":"2023-12-21T08:24:00.473Z","1.0.2":"2023-12-21T09:00:11.237Z","1.0.3":"2023-12-22T07:33:59.173Z","1.1.0":"2023-12-22T07:48:21.293Z","1.2.0":"2023-12-22T08:01:04.297Z","1.3.0":"2023-12-27T07:55:28.828Z","1.4.0":"2023-12-27T09:54:15.096Z","1.5.0":"2023-12-29T08:16:40.439Z","1.6.0":"2024-01-03T12:03:25.544Z"},"name":"@amnet/db-manager","dist-tags":{"latest":"1.6.0"},"versions":{"1.0.1":{"name":"@amnet/db-manager","version":"1.0.1","description":"Provides database management utilities to Pubsweet apps.","private":false,"main":"src/index.js","keywords":["pubsweet","database"],"author":{"name":"Amnet"},"license":"MIT","dependencies":{"@hapi/joi":"^14.3.0","@pubsweet/logger":"^0.2.61","fs-extra":"^8.1.0","knex":"^3.1.0","knex-aurora-data-api-client":"^1.10.0","lodash":"^4.17.11","objection":"^2.1.3","pg":"^8.11.3","tmp-promise":"^2.0.0","umzug":"^2.1.0"},"peerDependencies":{"@pubsweet/models":">=0.3.0","config":">=3.0.1"},"_id":"@amnet/db-manager@1.0.1","_nodeVersion":"12.22.12","_npmVersion":"6.14.16","dist":{"integrity":"sha512-Fo1bhIKqmqlfLKeb7a+QH7tJNX3KZY2xDdkX0/HjdkHgwptHTDiI1PCoSIcX6/L1BAxm/XMrzhKTfhq5ujwDJw==","shasum":"05e6cb94bb1a5b3ec15a5d5c43fac7a2efc87c2d","tarball":"https://registry.npmjs.org/@amnet/db-manager/-/db-manager-1.0.1.tgz","fileCount":16,"unpackedSize":34821,"signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEQCIEw9t8tU03UHo1T/bEPwknuBzLkQZpaNDkvYQDGqqX6EAiAd9ehJKx/WfpE/wESvkKQxrzUzmpryGPnRZ++MpvJn1w=="}]},"_npmUser":{"name":"amnet","email":"devaraj.b@amnet-systems.com"},"directories":{},"maintainers":[{"name":"amnet","email":"devaraj.b@amnet-systems.com"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/db-manager_1.0.1_1703147040232_0.1563108963824824"},"_hasShrinkwrap":false},"1.0.2":{"name":"@amnet/db-manager","version":"1.0.2","description":"Provides database management utilities to Pubsweet apps.","private":false,"main":"src/index.js","keywords":["pubsweet","database"],"author":{"name":"Amnet"},"license":"MIT","dependencies":{"@hapi/joi":"^14.3.0","@pubsweet/logger":"^0.2.61","fs-extra":"^8.1.0","knex":"^3.1.0","knex-aurora-data-api-client":"^1.10.0","lodash":"^4.17.11","objection":"^2.1.3","pg":"^8.11.3","tmp-promise":"^2.0.0","umzug":"^2.1.0"},"peerDependencies":{"@pubsweet/models":">=0.3.0","config":">=3.0.1"},"_id":"@amnet/db-manager@1.0.2","_nodeVersion":"12.22.12","_npmVersion":"6.14.16","dist":{"integrity":"sha512-+DHZ8XPRB8B4DAcvI7mOBYuAAqBs+Eok3w1xGiBkqBUwrC5jjmGuBMUBrh4T6mwOMRsx5oN1c+V9y0k/zWkXnw==","shasum":"73e41b23e5ffc533a356c76e686e51cb52778e22","tarball":"https://registry.npmjs.org/@amnet/db-manager/-/db-manager-1.0.2.tgz","fileCount":16,"unpackedSize":34821,"signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEYCIQCD8j75xnOVX30WKTTIiaOHyr7ZCBwgbbjJP6x6TxvVmQIhAKgo4UB/mM20AUiGDC2ZB0TL2t3h8Rfm0+EwZ34xW2Mi"}]},"_npmUser":{"name":"amnet","email":"devaraj.b@amnet-systems.com"},"directories":{},"maintainers":[{"name":"amnet","email":"devaraj.b@amnet-systems.com"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/db-manager_1.0.2_1703149211011_0.7209449101371701"},"_hasShrinkwrap":false},"1.0.3":{"name":"@amnet/db-manager","version":"1.0.3","description":"Provides database management utilities to Pubsweet apps.","private":false,"main":"src/index.js","keywords":["pubsweet","database"],"author":{"name":"Amnet"},"license":"MIT","dependencies":{"@hapi/joi":"^14.3.0","@pubsweet/logger":"^0.2.61","fs-extra":"^8.1.0","knex":"^3.1.0","knex-aurora-data-api-client":"^1.10.0","lodash":"^4.17.11","objection":"^2.1.3","pg":"^8.11.3","tmp-promise":"^2.0.0","umzug":"^2.1.0"},"peerDependencies":{"@pubsweet/models":">=0.3.0","config":">=3.0.1"},"_id":"@amnet/db-manager@1.0.3","_nodeVersion":"12.22.12","_npmVersion":"6.14.16","dist":{"integrity":"sha512-QWX0JI+ZxlZhOxu6jMUyPcCVNFW1JZwr0s/VHbw32qgch3goOeQhrTC++BFo916bfFY+eG4QLpf1JTVQySdZYQ==","shasum":"34e882eebd94d2a13032d7a3e1e98049c6671edb","tarball":"https://registry.npmjs.org/@amnet/db-manager/-/db-manager-1.0.3.tgz","fileCount":16,"unpackedSize":34852,"signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIAgnViWBeZFuX5W/6/MbKzHgIPVGslhjWfmlJYWu6P+HAiEAlffFNfk8WE+j/0PEggOlb/DeDNo+KwjeWQarMHFjwP8="}]},"_npmUser":{"name":"amnet","email":"devaraj.b@amnet-systems.com"},"directories":{},"maintainers":[{"name":"amnet","email":"devaraj.b@amnet-systems.com"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/db-manager_1.0.3_1703230438984_0.19030853092590316"},"_hasShrinkwrap":false},"1.1.0":{"name":"@amnet/db-manager","version":"1.1.0","description":"Provides database management utilities to Pubsweet apps.","private":false,"main":"src/index.js","keywords":["pubsweet","database"],"author":{"name":"Amnet"},"license":"MIT","dependencies":{"@hapi/joi":"^14.3.0","@pubsweet/logger":"^0.2.61","fs-extra":"^8.1.0","knex-aurora-data-api-client":"^1.10.0","lodash":"^4.17.11","objection":"^2.1.3","pg":"^8.11.3","tmp-promise":"^2.0.0","umzug":"^2.1.0"},"peerDependencies":{"@pubsweet/models":">=0.3.0","config":">=3.0.1","knex":">=0.95.0 <2.1.0"},"_id":"@amnet/db-manager@1.1.0","_nodeVersion":"12.22.12","_npmVersion":"6.14.16","dist":{"integrity":"sha512-YA8AhH3KLsroGhrfo/yiMg3GtQgPDCm1ePesQo53mjNU5yQnl4WaTy8aJsnENUz8cfj92z3CEKJLcCGIF0gG7g==","shasum":"f0b780381acb44bd83d8b9df93759e23a8438d91","tarball":"https://registry.npmjs.org/@amnet/db-manager/-/db-manager-1.1.0.tgz","fileCount":17,"unpackedSize":35120,"signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEYCIQDtMP681Iio+HPirSCxi7sKmqx3Y/LHOoHepa/t9tBIRQIhAOfG8HKk6kRr4ILhXDfjfaHC0zZqs3KSiQkpSE+uxQdK"}]},"_npmUser":{"name":"amnet","email":"devaraj.b@amnet-systems.com"},"directories":{},"maintainers":[{"name":"amnet","email":"devaraj.b@amnet-systems.com"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/db-manager_1.1.0_1703231301071_0.1070010528542582"},"_hasShrinkwrap":false},"1.2.0":{"name":"@amnet/db-manager","version":"1.2.0","description":"Provides database management utilities to Pubsweet apps.","private":false,"main":"src/index.js","keywords":["pubsweet","database"],"author":{"name":"Amnet"},"license":"MIT","dependencies":{"@hapi/joi":"^14.3.0","@pubsweet/logger":"^0.2.61","fs-extra":"^8.1.0","knex-aurora-data-api-client":"^1.10.0","lodash":"^4.17.11","objection":"^2.1.3","pg":"^8.11.3","tmp-promise":"^2.0.0","umzug":"^2.1.0"},"peerDependencies":{"@pubsweet/models":">=0.3.0","config":">=3.0.1","knex":"^2.1.0"},"_id":"@amnet/db-manager@1.2.0","_nodeVersion":"12.22.12","_npmVersion":"6.14.16","dist":{"integrity":"sha512-AtNVtBF1C0FT9FG9SJ5574Ra5yLomWJB3Why8hs03SvJy9ZzQZ223j2UvWkSHyJLXt2p7wqRO4e9ktqXP+LM3A==","shasum":"ccce4d8977a921617c192001a4a851206fe7cada","tarball":"https://registry.npmjs.org/@amnet/db-manager/-/db-manager-1.2.0.tgz","fileCount":17,"unpackedSize":35111,"signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEYCIQDKTTDYWAwuEuolHAHqH7RTBSFLBtM2jq+YbXAXTREgvwIhAPuErOVw59E5UVs3eWpYtTdWqWbxa+bdIbSrYFB7E7eu"}]},"_npmUser":{"name":"amnet","email":"devaraj.b@amnet-systems.com"},"directories":{},"maintainers":[{"name":"amnet","email":"devaraj.b@amnet-systems.com"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/db-manager_1.2.0_1703232063978_0.2377749846292403"},"_hasShrinkwrap":false},"1.3.0":{"name":"@amnet/db-manager","version":"1.3.0","description":"Provides database management utilities to Pubsweet apps.","private":false,"main":"src/index.js","keywords":["pubsweet","database"],"author":{"name":"Amnet"},"license":"MIT","dependencies":{"@hapi/joi":"^14.3.0","@pubsweet/logger":"^0.2.61","fs-extra":"^8.1.0","knex":"^0.21.1","knex-aurora-data-api-client":"^1.10.0","lodash":"^4.17.11","objection":"^2.1.3","pg":"^8.11.3","tmp-promise":"^2.0.0","umzug":"^2.1.0"},"peerDependencies":{"@pubsweet/models":">=0.3.0","config":">=3.0.1"},"_id":"@amnet/db-manager@1.3.0","_nodeVersion":"12.22.12","_npmVersion":"6.14.16","dist":{"integrity":"sha512-atf/OyF1BjoUeTXWvlHHMQrU8YOYQAfu50erYLneDrxwFOI9LEzeEDD3vVKo2Y0LCOKJirkk6jWvEmBHJdHcKQ==","shasum":"52cbdba666fddea2b1dedd77ef58579be2226d50","tarball":"https://registry.npmjs.org/@amnet/db-manager/-/db-manager-1.3.0.tgz","fileCount":16,"unpackedSize":34875,"signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEQCIEFXJCC0IZw44d8YqIbj7weLN1FB3lOdXaQuyRh7u0fUAiAViblke2tCnFx/9YM5WpBrnJVythHu7Z6K0QO6p4pTpQ=="}]},"_npmUser":{"name":"amnet","email":"devaraj.b@amnet-systems.com"},"directories":{},"maintainers":[{"name":"amnet","email":"devaraj.b@amnet-systems.com"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/db-manager_1.3.0_1703663728660_0.7649597149630907"},"_hasShrinkwrap":false},"1.4.0":{"name":"@amnet/db-manager","version":"1.4.0","description":"Provides database management utilities to Pubsweet apps.","private":false,"main":"src/index.js","keywords":["pubsweet","database"],"author":{"name":"Amnet"},"license":"MIT","dependencies":{"@hapi/joi":"^14.3.0","@pubsweet/logger":"^0.2.61","fs-extra":"^8.1.0","knex":"^3.1.0","knex-aurora-data-api-client":"^1.10.0","lodash":"^4.17.11","objection":"^2.1.3","pg":"^8.11.3","tmp-promise":"^2.0.0","umzug":"^2.1.0"},"peerDependencies":{"@pubsweet/models":">=0.3.0","config":">=3.0.1"},"_id":"@amnet/db-manager@1.4.0","_nodeVersion":"12.22.12","_npmVersion":"6.14.16","dist":{"integrity":"sha512-XWDyD6Z9I0ulny3TbDwY7jEsHzEYNNiJwiBSfRQXwZdYjXVLP2R+XeqVOruY9xz10hIV+oV/GtEn5SyEse3MHg==","shasum":"5fcfd2cc1e5946b537dcec5f292eb6c131b7d40a","tarball":"https://registry.npmjs.org/@amnet/db-manager/-/db-manager-1.4.0.tgz","fileCount":16,"unpackedSize":34874,"signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCICfMJpzKkm/F5q6hUyV3b2byGh+VYBP96FC4Z66QHJCrAiEAiZOIOW8RY+pmr3vHjHJY4wdQQMOCB6ygJp6VOEne8e8="}]},"_npmUser":{"name":"amnet","email":"devaraj.b@amnet-systems.com"},"directories":{},"maintainers":[{"name":"amnet","email":"devaraj.b@amnet-systems.com"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/db-manager_1.4.0_1703670854915_0.34794192946786495"},"_hasShrinkwrap":false},"1.5.0":{"name":"@amnet/db-manager","version":"1.5.0","description":"Provides database management utilities to Pubsweet apps.","private":false,"main":"src/index.js","keywords":["pubsweet","database"],"author":{"name":"Amnet"},"license":"MIT","dependencies":{"@hapi/joi":"^14.3.0","@pubsweet/logger":"^0.2.61","fs-extra":"^8.1.0","knex":"^3.1.0","knex-aurora-data-api-client":"^1.10.0","lodash":"^4.17.11","objection":"^2.1.3","pg":"^8.11.3","tmp-promise":"^2.0.0","umzug":"^2.1.0"},"peerDependencies":{"@pubsweet/models":">=0.3.0","config":">=3.0.1"},"_id":"@amnet/db-manager@1.5.0","_nodeVersion":"12.22.12","_npmVersion":"6.14.16","dist":{"integrity":"sha512-5CAPoCFS37fxW4zhd44Z7Z3HmdOCJW215YP4juROVsxy9RqfkE1ElZFsprYQPEAJG1krVGOSdzssLr72gKnaiQ==","shasum":"23ac2e2c6a530ca23aa121017591ee162992a57c","tarball":"https://registry.npmjs.org/@amnet/db-manager/-/db-manager-1.5.0.tgz","fileCount":16,"unpackedSize":35175,"signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIQCC9fa4YuAKWZpM9uGbWDzpZgF6EM2VBJwC8UEulnOZGQIgDvulr04W4ZRXkrkszrIlP9/yEcm9E7O6DVPbUWtzV5c="}]},"_npmUser":{"name":"amnet","email":"devaraj.b@amnet-systems.com"},"directories":{},"maintainers":[{"name":"amnet","email":"devaraj.b@amnet-systems.com"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/db-manager_1.5.0_1703837800265_0.26375161560046734"},"_hasShrinkwrap":false},"1.6.0":{"name":"@amnet/db-manager","version":"1.6.0","description":"Provides database management utilities to Pubsweet apps.","private":false,"main":"src/index.js","keywords":["pubsweet","database"],"author":{"name":"Amnet"},"license":"MIT","dependencies":{"@hapi/joi":"^14.3.0","@pubsweet/logger":"^0.2.61","fs-extra":"^8.1.0","knex":"^3.1.0","knex-aurora-data-api-client":"^1.10.0","lodash":"^4.17.11","objection":"^2.1.3","pg":"^8.11.3","tmp-promise":"^2.0.0","umzug":"^2.1.0"},"peerDependencies":{"@pubsweet/models":">=0.3.0","config":">=3.0.1"},"_id":"@amnet/db-manager@1.6.0","_nodeVersion":"20.10.0","_npmVersion":"10.2.3","dist":{"integrity":"sha512-KZJ4Xj7ydXRP5j26Ntrtt4n074G0oOzpqbNJW/8eL2KEWIkRbdDxllh17jJVyDNfITsonWHW4NbjlzscZpY7PQ==","shasum":"0f72d800344bfcaf20501e83af88f7be7daf9cde","tarball":"https://registry.npmjs.org/@amnet/db-manager/-/db-manager-1.6.0.tgz","fileCount":16,"unpackedSize":33833,"signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEYCIQCcLhH70fZ4YLYiGXf8euemPwlAlSY1ryHYtkfTckCktgIhAMndD8qZWr7eSnYFDJltY2d4NWryUmrVc0m22DNcw2sp"}]},"_npmUser":{"name":"amnet","email":"devaraj.b@amnet-systems.com"},"directories":{},"maintainers":[{"name":"amnet","email":"devaraj.b@amnet-systems.com"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/db-manager_1.6.0_1704283405368_0.9646087591229984"},"_hasShrinkwrap":false}},"maintainers":[{"name":"amnet","email":"devaraj.b@amnet-systems.com"}],"description":"Provides database management utilities to Pubsweet apps.","keywords":["pubsweet","database"],"author":{"name":"Amnet"},"license":"MIT","readme":"Provides database management utilities to Pubsweet apps.\n\n### Usage\n\nThis package exports the following functions:\n\n- `setupDb`\n- `addUser`\n- `dbExists`\n- `migrate`\n\n#### `setupDb`\n\nThis function\n\n- creates the database\n- adds an admin user\n- generates a secret in `config/local-<NODE_ENV>.json` under `pubsweet-server.secret`.\n\nIt can be called without arguments, in which case it will take its configuration from the following config keys:\n\n```js static\n{\n  'pubsweet-server': {\n    db: {\n      //  takes the same configuration options as https://node-postgres.com/features/connecting#programmatic\n    }\n  },\n  dbManager: {\n    username: 'xxxxxx',\n    password: 'pppppp',\n    email: 'email@example.com',\n    clobber: false // overwrite existing db (optional)\n  }\n}\n```\n\nAlternatively it can be passed the `dbManager` object as an argument, which will override the values on config.\n\nThe name of the database will be the full `dbPath`.\n\n#### `addUser`\n\nThis function adds a user to an already existing database. It requires a user object as argument:\n\n```js static\naddUser({\n  username: 'xxxxxx',\n  password: 'pppppp',\n  email: 'email@example.com',\n  admin: true, // (optional)\n})\n```\n\n#### `dbExists`\n\nThis function checks if any database exists at the configured path. Returns `true` or `false`\n\n#### `migrate`\n\nThis function performs pending migrations.\n","readmeFilename":"README.md"}