Skip to content
This repository has been archived by the owner on Aug 23, 2021. It is now read-only.

Releases: simonw/sqlite-transform

1.2.1

02 Aug 22:07
049b2fc
Compare
Choose a tag to compare
  • This tool is no longer maintained. The latest release of sqlite-utils introduces a new sqlite-utils convert command which provides a super-set of the functionality provided by sqlite-transform. #11

1.2

25 Jul 01:02
Compare
Choose a tag to compare
1.2
  • sqlite-transform lambda --multi option allowing the function to return a Python dictionary defining multiple columns that will be created and populated. #4
  • --drop option can be used with --output or --multi to drop the original column. #15
  • All commands now require at least one column to be specified. #17

1.1

21 Jul 19:05
Compare
Choose a tag to compare
1.1

New -s or --silent option for hiding the progress bar. #14

1.0

21 Jul 01:05
Compare
Choose a tag to compare
1.0

New --output colname and --output-type integer options for all of the commands, see saving the result to a separate column. #13

0.5

24 Mar 22:59
Compare
Choose a tag to compare
0.5
  • --dayfirst and --yearfirst options for parsedate and parsedatetime commands. #12

0.4

22 Feb 17:04
Compare
Choose a tag to compare
0.4
  • New sqlite-transform jsonsplit for converting foo,bar into ["foo", "bar"]. #10
  • Added --dry-run option to sqlite-tranfsorm lambda for previewing the conversion that is about to be applied. #8

0.3.1

18 Jan 21:01
10454a5
Compare
Choose a tag to compare
  • Better --help for sqlite-transform lambda. #7

0.3

04 Nov 04:39
Compare
Choose a tag to compare
0.3
  • return is now optional for one-line lambdas, e.g.
    sqlite-transform lambda my.db mytable mycolumn --code='str(value).upper()'
    

0.2

04 Nov 02:26
Compare
Choose a tag to compare
0.2
  • Added lambda command, which lets you specify a Python expression (or multiple lines of code) to be executed against every value in the column. Documentation here. (#2)
  • Added a parsedate command, which works like parsedatetime except it outputs just the date component. (#1)

0.1

04 Nov 02:19
Compare
Choose a tag to compare
0.1
  • First release, supporting only the parsedatetime command.