NAME

Mojolicious::Plugin::ContentManagement::Source::DBI - content from database

SYNOPSIS

    my $dbh = DBI->connect(...);

    # Mojolicious
    $self->plugin( content_management => {
        source      => 'dbi',
        source_conf => { dbh => $dbh, prefix => 'foo' },
        ...
    });

    # Mojolicious::Lite
    plugin content_management => {
        source      => 'dbi',
        source_conf => { dbh => $dbh, prefix => 'foo' },
        ...
    };

DESCRIPTION

This is the database source, using DBI. You just need a table like this:

    CREATE TABLE foo_pages (
        path    VARCHAR(100),
        parent  VARCHAR(100),
        sort    VARCHAR(10),
        title   VARCHAR(100),
        raw     VARCHAR(10000),
        PRIMARY KEY (path)
    );

Create a few rows and the pages are available in your webapp immediately. Two example pages:

    INSERT INTO foo_pages (path, parent, sort, title, raw)
        VALUES ('/foo.html', NULL, '03', 'This is /foo.html', 'Yay');
    INSERT INTO foo_pages (path, parent, sort, title, raw)
        VALUES ('/foo/bar.html', '/foo.html', '02', 'This is /foo/bar.html', 'Yay');

As you can see, the parent field is used to reference the parent of a page, the sort field is used to defined the order of all pages on the same level.

CONFIGURATION

With the source_conf hash ref you can pass the dbh, which must be a DBI database handle. Also you can pass a prefix for the pages table. Without the prefix, the table pages is used, if you pass foo as a prefix, the table foo_pages is used.

METHODS

This class implements all abstract methods of its base class Mojolicious::Plugin::ContentManagement::Source

SEE ALSO

Mojolicious::Plugin::ContentManagement, Mojolicious::Plugin::ContentManagement::Source