Releases: onebeyond/handy-postgres
Releases · onebeyond/handy-postgres
Release list
v1.3.2
v1.3.1
Main Changes
insert and update functions modified to optionally retrieve the newly inserted or updated rows, so the user doesn't need to perform a select query after that.
Insert function
insert(table, data, options)
object options is optional. It accepts the boolean property returning to retrieve inserted data.
Update function
update(table, update, where, options)
objects where and options are optional. where accepts where conditions, options is analogous to insert usage.
Other Changes
- Explain new feature in README
- Add test for the new feature
Changelog
- 6373d55 feat: add insert and update queries with returning by @neodmy
- 257f149 feat: add optional returing option for insert and update by @neodmy
- 7d50342 test: add tests for returning option in insert and update by @neodmy
- 8c5ee58 docs: document new option parameter for insert and update by @neodmy
- fd846b6 fix: polish changes by @neodmy
- 84352cf refactor: rename returning option and add as an extra param to update by @neodmy
- 9609ae0 test: amend tests after refactor by @neodmy
- 09a01f2 docs: amend README after refactor by @neodmy
- 2960815 Merge branch 'returning_option_for_insert_update' of github.com:neodmy/handy-postgres into returning_option_for_insert_update by @neodmy
- e2c36b3 chore: update package version to 1.3.0 by @neodmy
v1.2.6
v1.2.4
Main changes
Changelog
- 11600d4 Added autopublishing by @UlisesGascon
- b3bdd86 Bump pkg version by @UlisesGascon
NPM Release
npm notice
npm notice 📦 handy-postgres@1.2.4
npm notice === Tarball Contents ===
npm notice 84B .eslintrc
npm notice 121B test/.eslintrc
npm notice 2B .nvmrc
npm notice 303B Dockerfile
npm notice 1.8kB test/e2e/config.test.js
npm notice 1.9kB test/e2e/copy.test.js
npm notice 1.4kB index.js
npm notice 975B lib/migrate.js
npm notice 3.2kB test/e2e/migrations.test.js
npm notice 1.5kB lib/pool.js
npm notice 4.5kB test/e2e/query.test.js
npm notice 7.2kB lib/runner.js
npm notice 5.8kB test/e2e/schema.test.js
npm notice 6.4kB test/e2e/streamQuery.test.js
npm notice 1.1kB lib/transaction.js
npm notice 3.4kB test/e2e/tx.test.js
npm notice 1.3kB package.json
npm notice 5.6kB README.md
npm notice 1.1kB docker/setup-databases.sh
npm notice 31B sql/_insert.sql
npm notice 19B sql/_update.sql
npm notice 106B test/fixtures/migrations-additional/001-create-another-table.sql
npm notice 75B test/fixtures/migrations/001-create-table.sql
npm notice 105B test/fixtures/migrations/002-populate-data.sql
npm notice 213B test/fixtures/sql/create-films.sql
npm notice 225B test/fixtures/sql/schemas/create-films.sql
npm notice 250B test/fixtures/sql/create-migrations-user.sql
npm notice 40B test/fixtures/sql/schemas/create-schema.sql
npm notice 28B test/fixtures/sql/drop-films.sql
npm notice 40B test/fixtures/sql/schemas/drop-films.sql
npm notice 90B test/fixtures/sql/drop-migrations-test.sql
npm notice 71B test/fixtures/sql/drop-migrations.sql
npm notice 19B test/fixtures/sql/select-1.sql
npm notice 28B test/fixtures/sql/schemas/select-all.sql
npm notice 16B test/fixtures/sql/select-all.sql
npm notice 44B test/fixtures/sql/select-formatted-multi.sql
npm notice 21B test/fixtures/sql/schemas/select-formatted.sql
npm notice 21B test/fixtures/sql/select-formatted.sql
npm notice 25B test/fixtures/sql/select-parameterised.sql
npm notice 33B test/fixtures/sql/schemas/truncate-films.sql
npm notice 21B test/fixtures/sql/truncate-films.sql
npm notice 85B test/fixtures/data/films_out.tsv
npm notice 85B test/fixtures/data/films.tsv
npm notice 26B docker/user-databases.txt
npm notice 529B .travis.yml
npm notice 138B docker-compose.yml
npm notice === Tarball Details ===
npm notice name: handy-postgres
npm notice version: 1.2.4
npm notice package size: 12.4 kB
npm notice unpacked size: 50.0 kB
npm notice shasum: 85136e40cc81d4842fd6b72ef6a28d9b060c509e
npm notice integrity: sha512-PHqTAfX6aF9DS[...]aiL0HN4SPUloQ==
npm notice total files: 46
npm notice
+ handy-postgres@1.2.4
v1.2.3
Notable changes
Bump acorn from 7.1.0 to 7.1.1 (#14)
NPM Details release
npm notice
npm notice 📦 handy-postgres@1.2.3
npm notice === Tarball Contents ===
npm notice 84B .eslintrc
npm notice 121B test/.eslintrc
npm notice 2B .nvmrc
npm notice 303B Dockerfile
npm notice 1.8kB test/e2e/config.test.js
npm notice 1.9kB test/e2e/copy.test.js
npm notice 1.4kB index.js
npm notice 975B lib/migrate.js
npm notice 3.2kB test/e2e/migrations.test.js
npm notice 1.5kB lib/pool.js
npm notice 4.5kB test/e2e/query.test.js
npm notice 7.2kB lib/runner.js
npm notice 5.8kB test/e2e/schema.test.js
npm notice 6.4kB test/e2e/streamQuery.test.js
npm notice 1.1kB lib/transaction.js
npm notice 3.4kB test/e2e/tx.test.js
npm notice 1.3kB package.json
npm notice 5.6kB README.md
npm notice 1.1kB docker/setup-databases.sh
npm notice 31B sql/_insert.sql
npm notice 19B sql/_update.sql
npm notice 106B test/fixtures/migrations-additional/001-create-another-table.sql
npm notice 75B test/fixtures/migrations/001-create-table.sql
npm notice 105B test/fixtures/migrations/002-populate-data.sql
npm notice 213B test/fixtures/sql/create-films.sql
npm notice 225B test/fixtures/sql/schemas/create-films.sql
npm notice 250B test/fixtures/sql/create-migrations-user.sql
npm notice 40B test/fixtures/sql/schemas/create-schema.sql
npm notice 28B test/fixtures/sql/drop-films.sql
npm notice 40B test/fixtures/sql/schemas/drop-films.sql
npm notice 90B test/fixtures/sql/drop-migrations-test.sql
npm notice 71B test/fixtures/sql/drop-migrations.sql
npm notice 19B test/fixtures/sql/select-1.sql
npm notice 28B test/fixtures/sql/schemas/select-all.sql
npm notice 16B test/fixtures/sql/select-all.sql
npm notice 44B test/fixtures/sql/select-formatted-multi.sql
npm notice 21B test/fixtures/sql/schemas/select-formatted.sql
npm notice 21B test/fixtures/sql/select-formatted.sql
npm notice 25B test/fixtures/sql/select-parameterised.sql
npm notice 33B test/fixtures/sql/schemas/truncate-films.sql
npm notice 21B test/fixtures/sql/truncate-films.sql
npm notice 85B test/fixtures/data/films_out.tsv
npm notice 85B test/fixtures/data/films.tsv
npm notice 26B docker/user-databases.txt
npm notice 327B .travis.yml
npm notice 138B docker-compose.yml
npm notice === Tarball Details ===
npm notice name: handy-postgres
npm notice version: 1.2.3
npm notice package size: 12.3 kB
npm notice unpacked size: 49.8 kB
npm notice shasum: 2fa8994d812b4d8a617780ba423e11818e0fb5d1
npm notice integrity: sha512-C10PRLk5J+Fvu[...]J/eJEby47RLlQ==
npm notice total files: 46
npm notice
+ handy-postgres@1.2.3
v1.2.2
Notable Changes
- Added Missing metadata in
package.json - Added Travis as CI
- Current situation: 0 package vulnerable or outdated 🎉
- NSP dependency has been removed (deprecated notice)
npm run vulnnow executesnpm audit(6a772b7)- Husky hooks where relocated inside the
package.json(d5137f8) - Dependencies upgraded as follow (d5137f8):
bluebird ^3.5.0 → ^3.7.2
debug ^2.6.8 → ^4.1.1
marv ^2.0.0 → ^3.1.0
marv-pg-driver ^2.0.0 → ^3.0.0
pg ^7.12.1 → ^7.17.0
pg-copy-streams ^1.2.0 → ^2.2.2
pg-query-stream ^1.1.1 → ^2.1.2
ramda ^0.24.1 → ^0.26.1
eslint ^4.18.2 → ^6.8.0
eslint-config-airbnb ^6.2.0 → ^18.0.1
eslint-plugin-mocha ^4.8.0 → ^6.2.2
eslint-plugin-react ^4.3.0 → ^7.17.0
husky ^0.13.2 → ^4.0.3
mocha ^3.2.0 → ^7.0.0
nsp ^2.8.1 → ^3.2.1
Contexts
PRs
- #5 Bump lodash from 4.17.11 to 4.17.15
- #6 Bump eslint from 2.13.1 to 4.18.2
- #7 Added missing metadata
- #10 Travis pipeline added
- #11 Revert "Travis pipeline added"
- #12 CI
- #13 Upgrade dependencies
Issues
Commits
- ccd3572 Bump lodash from 4.17.11 to 4.17.15 by @dependabot
- 19aadad Bump eslint from 2.13.1 to 4.18.2 by @dependabot
- 3756eec Added missing metadata by @UlisesGascon
- 186d2f3 Travis pipeline added by @UlisesGascon
- 9403a6f Typo by @UlisesGascon
- 19a5299 Merge branch 'master' into add-ci by @UlisesGascon
- 9e29429 Improved before_script by @UlisesGascon
- 8d361c9 Improved script by @UlisesGascon
- 7bb038a gruped to script context by @UlisesGascon
- 04dcea7 cicd: testing travis pipeline by @danielherrerohernando
- d5137f8 Upgraded dependencies by @UlisesGascon
- 6a772b7 Removed NSP by @UlisesGascon
NPM Release Details
npm notice
npm notice 📦 handy-postgres@1.2.2
npm notice === Tarball Contents ===
npm notice 84B .eslintrc
npm notice 121B test/.eslintrc
npm notice 2B .nvmrc
npm notice 303B Dockerfile
npm notice 1.8kB test/e2e/config.test.js
npm notice 1.9kB test/e2e/copy.test.js
npm notice 1.4kB index.js
npm notice 975B lib/migrate.js
npm notice 3.2kB test/e2e/migrations.test.js
npm notice 1.5kB lib/pool.js
npm notice 4.5kB test/e2e/query.test.js
npm notice 7.2kB lib/runner.js
npm notice 5.8kB test/e2e/schema.test.js
npm notice 6.4kB test/e2e/streamQuery.test.js
npm notice 1.1kB lib/transaction.js
npm notice 3.4kB test/e2e/tx.test.js
npm notice 1.3kB package.json
npm notice 5.6kB README.md
npm notice 1.1kB docker/setup-databases.sh
npm notice 31B sql/_insert.sql
npm notice 19B sql/_update.sql
npm notice 106B test/fixtures/migrations-additional/001-create-another-table.sql
npm notice 75B test/fixtures/migrations/001-create-table.sql
npm notice 105B test/fixtures/migrations/002-populate-data.sql
npm notice 213B test/fixtures/sql/create-films.sql
npm notice 225B test/fixtures/sql/schemas/create-films.sql
npm notice 250B test/fixtures/sql/create-migrations-user.sql
npm notice 40B test/fixtures/sql/schemas/create-schema.sql
npm notice 28B test/fixtures/sql/drop-films.sql
npm notice 40B test/fixtures/sql/schemas/drop-films.sql
npm notice 90B test/fixtures/sql/drop-migrations-test.sql
npm notice 71B test/fixtures/sql/drop-migrations.sql
npm notice 19B test/fixtures/sql/select-1.sql
npm notice 28B test/fixtures/sql/schemas/select-all.sql
npm notice 16B test/fixtures/sql/select-all.sql
npm notice 44B test/fixtures/sql/select-formatted-multi.sql
npm notice 21B test/fixtures/sql/schemas/select-formatted.sql
npm notice 21B test/fixtures/sql/select-formatted.sql
npm notice 25B test/fixtures/sql/select-parameterised.sql
npm notice 33B test/fixtures/sql/schemas/truncate-films.sql
npm notice 21B test/fixtures/sql/truncate-films.sql
npm notice 85B test/fixtures/data/films_out.tsv
npm notice 85B test/fixtures/data/films.tsv
npm notice 26B docker/user-databases.txt
npm notice 327B .travis.yml
npm notice 138B docker-compose.yml
npm notice === Tarball Details ===
npm notice name: handy-postgres
npm notice version: 1.2.2
npm notice package size: 12.3 kB
npm notice unpacked size: 49.8 kB
npm notice shasum: 2e3a020297cb32223ac1d0f35033115d0460dbd3
npm notice integrity: sha512-BLSto+MoxSLRS[...]WchlkI6FekXsA==
npm notice total files: 46