Hello, problem really solving.

Copy dump into root site. Further, from not root privileges:

dbicdump -Ilib -o dump_directory=./lib -o 
components='["InflateColumn::DateTime"]' -o preserve_case=1 Schema 
dbi:SQLite:database=blog.db '{ quote_char => "`" }'

In my App:

use Schema;

has schema => sub {
    return Schema->connect('dbi:SQLite:' . '/puth/to/home/dump/blog.db', 
'', '', { sqlite_unicode => 1});
};

In startup:

$self->helper(db => sub { $self->app->schema });


In controller:

sub index {
   my $self = shift;
   my $cursor = $self->db->resultset('Post');
   $self->stash(cursor => $cursor);
}

In template index:

% while( my $post = $cursor->next ) {
<%= $post->header %>
<%= b($post->post) %>
<%= $post->tags %>
% }

And also, i wrote in DB, all very nice work. 

I sow that, when i generating schema under root privileges, in root folder 
created blog.db, and run hypnotoad under root privileges, i got error. 
Thanks.

 

-- 
You received this message because you are subscribed to the Google Groups 
"Mojolicious" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/mojolicious.
For more options, visit https://groups.google.com/d/optout.

Reply via email to