shiyan/file-to-sqlite

Copies data from a file to an SQLite database using regular expressions.

0.4.0 2018-04-14 19:31 UTC

Requires

• php: ^7.1
• ext-pdo_sqlite: *
• consolidation/annotated-command: ^2.8.3
• shiyan/iterate: ^2.0
• shiyan/lite-sql-insert: ^3.0@beta
• symfony/console: ^4.0
• symfony/filesystem: ^4.0

Suggests

• consolidation/cgr: Isolates the composer library from other globally-installed tools

MIT

• Mike Shiyan

• php
• file
• sqlite
• console
• OOP
• regex

README

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.

Requirements

• PHP ≥ 7.1
• Composer

Installation

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

Usage

file-to-sqlite [options] [--] <source> <destination> <pattern>

Arguments:

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.

Options:

-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.