Yancy::Backend::SQLite - A backend for Postgres using Mojo::SQLite
version 0.006
# yancy.conf { backend => 'sqlite:filename.db', collections => { table_name => { ... }, }, } # Plugin use Mojolicious::Lite; plugin Yancy => { backend => 'sqlite:filename.db', collections => { table_name => { ... }, }, };
This Yancy backend allows you to connect to a SQLite database to manage the data inside. This backend uses Mojo::SQLite to connect to SQLite.
See Yancy::Backend for the methods this backend has and their return values.
The URL for this backend takes the form sqlite:<filename.db>.
sqlite:<filename.db>
Some examples:
# A database file in the current directory sqlite:filename.db # In a specific location sqlite:/tmp/filename.db
The collections for this backend are the names of the tables in the database.
So, if you have the following schema:
CREATE TABLE people ( id SERIAL, name VARCHAR NOT NULL, email VARCHAR NOT NULL ); CREATE TABLE business ( id SERIAL, name VARCHAR NOT NULL, email VARCHAR NULL );
You could map that schema to the following collections:
{ backend => 'sqlite:filename.db', collections => { People => { required => [ 'name', 'email' ], properties => { id => { type => 'integer', readOnly => 1, }, name => { type => 'string' }, email => { type => 'string' }, }, }, Business => { required => [ 'name' ], properties => { id => { type => 'integer', readOnly => 1, }, name => { type => 'string' }, email => { type => 'string' }, }, }, }, }
Mojo::SQLite, Yancy
Doug Bell <preaction@cpan.org>
This software is copyright (c) 2017 by Doug Bell.
This is free software; you can redistribute it and/or modify it under the same terms as the Perl 5 programming language system itself.
To install Yancy, copy and paste the appropriate command in to your terminal.
cpanm
cpanm Yancy
CPAN shell
perl -MCPAN -e shell install Yancy
For more information on module installation, please visit the detailed CPAN module installation guide.