remote/sqlite-utils
1
0
Fork 0
mirror of https://github.com/simonw/sqlite-utils.git synced 2026-09-16 13:34:10 +02:00
Code Issues Projects Releases Packages Wiki Activity

Commit graph

  • fc81588cc3 Loop through correct list Simon Willison 2019-06-28 23:23:16 -07:00
  • 889e2afccf Unit test + bug fix for db.add_foreign_keys() Simon Willison 2019-06-28 23:21:23 -07:00
  • 3db2c26ce2 .rst fixes Simon Willison 2019-06-28 17:49:28 -07:00
  • 4230560e94 Docs for db.add_foreign_keys() Simon Willison 2019-06-28 17:47:57 -07:00
  • 9beecc6eb0 db.add_foreign_keys() method, refs #31 Simon Willison 2019-06-28 08:39:50 -07:00
  • 86bd2bba68 1.2.2 release notes Simon Willison 2019-06-25 21:23:45 -07:00
  • 641eccc2b7 Release 1.2.2 1.2.2 Simon Willison 2019-06-25 21:20:55 -07:00
  • f03d2eddd8 Handle datetime.time correctly Simon Willison 2019-06-25 21:18:35 -07:00
  • 46281c9db0 Release 1.2.1 1.2.1 Simon Willison 2019-06-20 17:01:21 -07:00
  • 976263effc Sanity check add_foreign_key() column exists, closes #29 Simon Willison 2019-06-20 16:58:09 -07:00
  • 364b0fb678 Remove .DS_Store Simon Willison 2019-06-20 16:55:39 -07:00
  • 1c8a0e874f Release 1.2 1.2 Simon Willison 2019-06-12 23:39:59 -07:00
  • 208f56fbaf --not-null and --default options to insert/update, closes #24 Simon Willison 2019-06-12 23:30:16 -07:00
  • 362359da7e not_null= and defaults= arguments to various Python methods, refs #24 Simon Willison 2019-06-12 23:10:07 -07:00
  • 07a10bdb2c foreign_keys=[...] can now detect tables and keys - closes #25 Simon Willison 2019-06-12 22:32:26 -07:00
  • d645032cfa add_foreign_key can now detect table and pk, refs #25 Simon Willison 2019-06-12 21:51:09 -07:00
  • c2622ceabd cd docs && make livehtml Simon Willison 2019-06-12 21:50:18 -07:00
  • 2fed87da6e --not-null-default and not_null_default=, refs #24 Simon Willison 2019-06-12 18:35:02 -07:00
  • 7a3041b1ad Releasing 1.1 1.1 Simon Willison 2019-05-28 22:12:03 -07:00
  • 26b2cf3418 Changelog for 1.1 + docs for --ignore/ignore=True Simon Willison 2019-05-28 22:06:22 -07:00
  • 50e2f94b58 Ability to add a column that is a foreign key reference Simon Willison 2019-05-28 21:54:43 -07:00
  • 00c5a49a87 Option to ignore inserts if primary key exists already Simon Willison 2019-05-28 21:15:57 -07:00
  • 1e28eeee8c
         Fixed RST syntax bug Simon Willison 2019-05-27 22:25:03 -07:00
  • 63953f56e7 Release 1.0.1 1.0.1 Simon Willison 2019-05-27 17:50:28 -07:00
  • cec8c3c482 sqlite-utils rows now obeys --json-cols Simon Willison 2019-05-27 17:47:59 -07:00
  • 092e1368ed Fixed typo Simon Willison 2019-05-25 07:24:17 -07:00
  • ee017cdbdd Release notes for 1.0, closes #22 1.0 Simon Willison 2019-05-24 18:06:38 -07:00
  • 251e473041 --json-cols option for outputting nested JSON, closes #20 Simon Willison 2019-05-24 17:56:44 -07:00
  • 747ea5d6bc Fixed help text for sqlite-utils enable-fts Simon Willison 2019-05-24 17:43:41 -07:00
  • eff52023c6 alter=True/--alter option to automatically add missing columns Simon Willison 2019-05-24 17:41:04 -07:00
  • 8ab7dcb4f9 Update description, don't package tests/ Simon Willison 2019-05-24 17:37:29 -07:00
  • 0b1af42ead
         Link to my blog entry Simon Willison 2019-02-24 19:45:38 -08:00
  • 05317f5341 Release 0.14 0.14 Simon Willison 2019-02-24 15:11:51 -08:00
  • 3cab079d3e add-column col_type now optional, defaults to str Simon Willison 2019-02-24 14:24:00 -08:00
  • 557dc3f9a7 Improved foreign_keys= argument, closes #17 Simon Willison 2019-02-24 14:12:45 -08:00
  • f8d3b7cfe5 sqlite-utils add-foreign-key books.db books author_id authors id Simon Willison 2019-02-24 13:33:45 -08:00
  • e1ca938aa1 table.add_foreign_key(column, other_table, other_column) Simon Willison 2019-02-24 13:10:51 -08:00
  • 9756310408 Black Simon Willison 2019-02-24 12:59:46 -08:00
  • 33df260b38 Fix for CLI test Simon Willison 2019-02-24 12:12:59 -08:00
  • 0bc49e938e 'sqlite-utils add-column name type' command, closes #15 Simon Willison 2019-02-24 12:04:33 -08:00
  • 05a85b358f Don't assume -1 for error code Simon Willison 2019-02-24 11:50:56 -08:00
  • 6d25f648ed add_column now accepts explicit SQLite types, refs #15 Simon Willison 2019-02-24 11:49:24 -08:00
  • c5286d2c66 Black formatting Simon Willison 2019-02-24 11:40:58 -08:00
  • dc2560879e table.add_column(name, type) method, refs #15 Simon Willison 2019-02-24 11:40:26 -08:00
  • 8a5d0d80c3 sqlite-utils create-index command, closes #14 Simon Willison 2019-02-24 11:11:21 -08:00
  • 7784b924a1 Added create_index(..., if_not_exists=True), refs #14 Simon Willison 2019-02-24 10:46:44 -08:00
  • 0c6745b70f Whitespace fix Simon Willison 2019-02-24 10:42:27 -08:00
  • e7ffbcdb36 Ability to create unique indexes, refs #14 Simon Willison 2019-02-24 10:41:51 -08:00
  • 1b6025e8ab Release 0.13 0.13 Simon Willison 2019-02-23 22:54:43 -08:00
  • 10e3aab4c6 Fixed typo with last_pk Simon Willison 2019-02-23 22:49:54 -08:00
  • 6c3f5e6479 Added --table and --fmt options for table output using tabulate Simon Willison 2019-02-23 22:45:17 -08:00
  • dbf239e3fc hash_id= mechanism for setting ID using content hash, closes #13 Simon Willison 2019-02-23 20:36:40 -08:00
  • e615d22c55
         Support for numpy types, closes #11 (#12) Simon Willison 2019-02-23 20:02:19 -08:00
  • c5068a0972 📝 Updates my_database.py to my_database.db (#9) Jeff Triplett 2019-02-23 21:55:04 -06:00
  • 7c20e60685 Travis should not fail if this line fails numpy-pandas Simon Willison 2019-02-23 19:54:02 -08:00
  • bfec253e10 Support for numpy types, closes #11 Simon Willison 2019-02-23 19:20:28 -08:00
  • ca225b02c0 Prettier indentation for CREATE TABLE Simon Willison 2019-02-23 12:51:35 -08:00
  • 919415e4e9
         Added LICENSE file Simon Willison 2019-02-23 09:16:57 -08:00
  • 463fd3c3f6
         Bump copyright year Simon Willison 2019-02-22 22:08:14 -08:00
  • 1ffa40301d Releasing 0.12 0.12 Simon Willison 2019-02-22 18:22:28 -08:00
  • e3c0ed1b1a sqlite-utils tables now takes --counts, --columns, --csv, --nl Simon Willison 2019-02-22 18:12:53 -08:00
  • 11a9511d23 Updated README to reflect new query default subcommand Simon Willison 2019-02-22 17:53:48 -08:00
  • c7dbb03a10 Added 'sqlite-utils rows db.db tablename' command Simon Willison 2019-02-22 17:52:17 -08:00
  • f2ca48c0da Default command now executes queries, --csv or --json Simon Willison 2019-02-22 17:40:21 -08:00
  • 3095f2e671 Added db[table].rows iterator Simon Willison 2019-02-21 21:29:50 -08:00
  • 62e1edeaf6 [] escaping for FTS columns Simon Willison 2019-02-21 20:17:58 -08:00
  • fd1b6eb82d Help text for enable-fts and populate-fts Simon Willison 2019-02-07 21:25:26 -08:00
  • c89b2df918 Fixed documentation typo 0.11 Simon Willison 2019-02-07 21:23:50 -08:00
  • 6acfd456b0 Releasing 0.11 Simon Willison 2019-02-07 21:22:13 -08:00
  • 3f8ef35b2a enable-fts and populate-fts CLI commands Simon Willison 2019-02-07 21:18:24 -08:00
  • ac9311aaf5 Refactored insert and upsert to share the same options Simon Willison 2019-02-06 21:50:25 -08:00
  • 7c09a2e994 Release 0.10 0.10 Simon Willison 2019-02-06 21:16:35 -08:00
  • 7aab60d876 Handle datetime.date and datetime.time Simon Willison 2019-02-06 21:15:08 -08:00
  • 1ad604fbbd
         📝 Updates my_database.py to my_database.db Jeff Triplett 2019-02-01 11:34:54 -06:00
  • 441c131db5 Better --help text for insert command Simon Willison 2019-01-29 07:40:34 -08:00
  • 1843d55615 @cli.command(name="csv") instead of import csv as csv_std Simon Willison 2019-01-29 07:37:01 -08:00
  • 82f0f6076a sqlite-utils insert db.db foo - --csv Simon Willison 2019-01-29 07:28:12 -08:00
  • 79a0f9cc96 Releasing 0.9 0.9 Simon Willison 2019-01-27 22:34:33 -08:00
  • 50589f8523 CLI insert tool now uses generators, closes #7 Simon Willison 2019-01-27 22:26:45 -08:00
  • f0afa5646b insert_all() now accepts generator, closes #7 Simon Willison 2019-01-27 22:12:18 -08:00
  • 225cf7299f Docs example chaining --nl together Simon Willison 2019-01-27 18:28:02 -08:00
  • a226076994 Fixed RST bug Simon Willison 2019-01-27 18:18:55 -08:00
  • 5309c5c775 sqlite-utils insert ... --nl option, closes #6 Simon Willison 2019-01-27 18:17:38 -08:00
  • 57fc8ce55e Database() constructor works with pathlib.Path Simon Willison 2019-01-27 15:53:41 -08:00
  • 3f2e711a4b Refactored to use itertools Simon Willison 2019-01-26 10:58:45 -08:00
  • ea17c63cc5 Tests for json returning single row Simon Willison 2019-01-26 10:58:00 -08:00
  • 3a944d0c07
         Run Travis tests against Python 3.8-dev (#5) Simon Willison 2019-01-25 18:37:54 -08:00
  • b2f81e8607
         Run Travis tests against Python 3.8-dev python-38-travis Simon Willison 2019-01-25 18:30:31 -08:00
  • 9a4d1ff0a2 Releasing 0.8.1 (just a better README) 0.8.1 Simon Willison 2019-01-25 18:22:18 -08:00
  • 20a744fb5a More detailed README Simon Willison 2019-01-25 18:21:55 -08:00
  • 4e9045e5b0 Documentation typo Simon Willison 2019-01-25 18:19:15 -08:00
  • 3db4f08f19 Release 0.8 0.8 Simon Willison 2019-01-25 18:13:29 -08:00
  • 5466c9745d sqlite-utils json dogs.db "select * from dogs" Simon Willison 2019-01-25 18:06:29 -08:00
  • 7689ca7229
         Fixed RST formatting Simon Willison 2019-01-25 10:16:26 -08:00
  • c83dd8a5eb sqlite-utils csv data.db "select ..." command Simon Willison 2019-01-25 07:50:20 -08:00
  • 6f54342570 Release 0.7 0.7 Simon Willison 2019-01-24 23:20:49 -08:00
  • 9501ba4bf1 sqlite-utils table_names blah.db is now tables blah.db Simon Willison 2019-01-24 23:04:52 -08:00
  • 8af5dd5ffb Debug fix-travis Simon Willison 2019-01-24 22:58:04 -08:00
  • 42b2b4b785
         Upgrade sqlite3 in Travis so we can test against FTS5 Simon Willison 2019-01-24 22:54:32 -08:00
  • 7f205d2308 -y fts5 Simon Willison 2019-01-24 22:50:24 -08:00