A command-line utility for copying data from a file to an SQLite database file using regular expressions.
Perfect for converting automatic log files, reports, etc.
- PHP ≥ 7.1
- Composer
composer global require --optimize-autoloader shiyan/file-to-sqlite
Make sure that the COMPOSER_HOME/vendor/bin
dir is in your PATH
env var.
More info in the composer help: composer global -h
If you have the CGR installed, then run the following command instead of the one above:
cgr -o shiyan/file-to-sqlite
file-to-sqlite [options] [--] <source> <destination> <pattern>
source Path to the source file.
destination Path to the SQLite database file. If not exists, it will
be created.
pattern Regular expression pattern with named subpatterns.
-t, --table=TABLE Table name. By default, the source file name is used.
-i, --integer=INTEGER List of integer fields. (multiple values allowed)
--blob=BLOB List of blob fields. (multiple values allowed)
--real=REAL List of real fields. (multiple values allowed)
--numeric=NUMERIC List of numeric fields. (multiple values allowed)
-p, --primary=PRIMARY Primary key(s). (multiple values allowed)
-a, --append If the table exists, this option allows to insert into it
anyway.