Catmandu::DBI3pm
Catmandu tools to communicate with dbi based interfaces
Usage
# From the command line# Export data from a relational database$ catmandu convert DBI --dsn dbi:mysql:foobar --user foo --password bar --query "select * from table"# Import data into a relational database$ catmandu import JSON to DBI --data_source dbi:SQLite:mydb.sqlite < data.json# Export data from a relational database$ catmandu export DBI --data_source dbi:SQLite:mydb.sqlite to JSON# Or via a configuration file$ cat catmandu.yml---store:mydb:package: DBIoptions:data_source: "dbi:mysql:database=mydb"username: xyzpassword: xyz...$ catmandu import JSON to mydb < data.json$ catmandu export mydb to YAML > data.yml# Export one record$ catmandu export mydb --id 012E929E-FF44-11E6-B956-AE2804ED5190 to JSON > record.json# Count the number of records$ catmandu count mydb# Delete data$ catmandy delete mydb
Modules
Catmandu::Importer::DBI
Catmandu::Store::DBI
Releases
2 releases since Debian 12 (Bookworm); the text changed 1 time.