Find SQLite

Find any valid SQLite database files.

Examples

Just paths

$ find-sqlite ~/.cargo/git
"/home/xand/.cargo/git/checkouts/sqlx-59ff20ee512773be/92a2268/sqlx-bench/test.db"
"/home/xand/.cargo/git/checkouts/sqlx-59ff20ee512773be/92a2268/tests/sqlite/sqlite.db"

Paths with schemas

$ find-sqlite ~/.cargo/git -s
"/home/xand/.cargo/git/checkouts/sqlx-59ff20ee512773be/92a2268/sqlx-bench/test.db"
CREATE TABLE test (id INTEGER PRIMARY KEY NOT NULL)

"/home/xand/.cargo/git/checkouts/sqlx-59ff20ee512773be/92a2268/tests/sqlite/sqlite.db"
CREATE TABLE _sqlx_test ( id INT PRIMARY KEY, text TEXT NOT NULL )
CREATE TABLE accounts ( id integer not null primary key, name text not null, is_active boolean )
CREATE TABLE sqlite_sequence(name,seq)
CREATE TABLE tweet ( id BIGINT NOT NULL PRIMARY KEY, text TEXT NOT NULL, is_sent BOOLEAN NOT NULL DEFAULT TRUE, owner_id BIGINT )
CREATE VIEW accounts_view as select * from accounts

Paths with schemas, pretty-formatted

$ find-sqlite ~/.cargo/git -s -p
"/home/xand/.cargo/git/checkouts/sqlx-59ff20ee512773be/92a2268/sqlx-bench/test.db"
CREATE TABLE test (id INTEGER PRIMARY KEY NOT NULL)

"/home/xand/.cargo/git/checkouts/sqlx-59ff20ee512773be/92a2268/tests/sqlite/sqlite.db"
CREATE TABLE _sqlx_test (id INT PRIMARY KEY, text TEXT NOT NULL)
CREATE TABLE accounts (
    id integer NOT NULL PRIMARY KEY,
    name text NOT NULL,
    is_active boolean
)
CREATE TABLE sqlite_sequence(name, seq)
CREATE TABLE tweet (
    id BIGINT NOT NULL PRIMARY KEY,
    text TEXT NOT NULL,
    is_sent BOOLEAN NOT NULL DEFAULT TRUE,
    owner_id BIGINT
)
CREATE VIEW accounts_view AS
SELECT
    *
FROM
    accounts