# Mojolicious
$self->plugin( Yancy => backend => 'postgresql://postgres@/mydb' );

# Mojolicious::Lite
plugin Yancy => backend => 'postgresql://postgres@/mydb'; # mysql, sqlite, dbic...

# Secure access to the admin UI with Basic authentication
my $under = $app->routes->under( '/yancy', sub( $c ) {
    return 1 if $c->req->url->to_abs->userinfo eq 'Bender:rocks';
    $c->res->headers->www_authenticate('Basic');
    $c->render(text => 'Authentication required!', status => 401);
    return undef;
});
$self->plugin( Yancy => backend => 'postgresql://postgres@/mydb', route => $under );

# ... then load the editor at http://127.0.0.1:3000/yancy

# PostgreSQL: A Mojo::Pg connection string
plugin Yancy => backend => 'postgresql://postgres@/test';

# PostgreSQL: A Mojo::Pg object
plugin Yancy => backend => Mojo::Pg->new( 'postgresql://postgres@/test' );

# MySQL: A Mojo::mysql connection string
plugin Yancy => backend => 'mysql://user@/test';

# MySQL: A Mojo::mysql object
plugin Yancy => backend => Mojo::mysql->strict_mode( 'mysql://user@/test' );

# SQLite: A Mojo::SQLite connection string
plugin Yancy => backend => 'sqlite:test.db';

# SQLite: A Mojo::SQLite object
plugin Yancy => backend => Mojo::SQLite->new( 'sqlite::temp:' );

# DBIx::Class: A connection string
plugin Yancy => backend => 'dbic://My::Schema/dbi:SQLite:test.db';

# DBIx::Class: A DBIx::Class::Schema object
plugin Yancy => backend => My::Schema->connect( 'dbi:SQLite:test.db' );

plugin Yancy => backend => 'postgres://postgres@/test',
    schema => {
        employees => {
            title => 'Employees',
            description => 'Our crack team of loyal dregs.',
            properties => {
                address => {
                    description => 'Where to notify next-of-kin.',
                    # Regexp to validate this field
                    pattern => '^\d+ \S+',
                },
                email => {
                    # Use the browser's native e-mail input
                    format => 'email',
                },
            },
        },
    };

# View a list of blog entries
get '/' => sub( $c ) {
    my @blog_entries = $c->yancy->list(
        blog_entries =>
        { published => 1 },
        { order_by => { -desc => 'published_date' } },
    );
    $c->render(
        'blog_list',
        items => \@blog_entries,
    );
};

# View a single blog entry
get '/blog/:blog_entry_id' => sub( $c ) {
    my $blog_entry = $c->yancy->get(
        blog_entries => $c->param( 'blog_entry_id' ),
    );
    $c->render(
        'blog_entry',
        item => $blog_entry,
    );
};

# Load the form plugin
app->yancy->plugin( 'Form::Bootstrap4' );

# Edit a blog entry
any [ 'GET', 'POST' ], '/edit/:blog_entry_id' => sub( $c ) {
    if ( $c->req->method eq 'GET' ) {
        my $blog_entry = $c->yancy->get(
            blog_entries => $c->param( 'blog_entry_id' ),
        );
        return $c->render(
            'blog_entry',
            item => $blog_entry,
        );
    }
    my $id = $c->param( 'blog_entry_id' );
    my $item = $c->req->params->to_hash;
    delete $item->{csrf_token}; # See https://docs.mojolicious.org/Mojolicious/Guides/Rendering#Cross-site-request-forgery
    $c->yancy->set( blog_entries => $id, $c->req->params->to_hash );
    $c->redirect_to( '/blog/' . $id );
};

__DATA__
@@ blog_form.html.ep
%= $c->yancy->form->form_for( 'blog_entries', item => stash 'item' )

# A rewrite of the routes above to use Yancy::Controller::Yancy

# View a list of blog entries
get '/' => {
    controller => 'yancy',
    action => 'list',
    schema => 'blog_entries',
    filter => { published => 1 },
    order_by => { -desc => 'published_date' },
} => 'blog.list';

# View a single blog entry
get '/blog/:blog_entry_id' => {
    controller => 'yancy',
    action => 'get',
    schema => 'blog_entries',
} => 'blog.get';

# Load the form plugin
app->yancy->plugin( 'Form::Bootstrap4' );

# Edit a blog entry
any [ 'GET', 'POST' ], '/edit/:blog_entry_id' => {
    controller => 'yancy',
    action => 'set',
    schema => 'blog_entries',
    template => 'blog_form',
    redirect_to => 'blog.get',
} => 'blog.edit';

__DATA__
@@ blog_form.html.ep
%= $c->yancy->form->form_for( 'blog_entries' )