Dancer-Plugin-Database
Dancer-Plugin-Database copied to clipboard
bigpresh
Dancer::Plugin::Database - easy database support for Dancer applications
t/01-basic.t seems to fail sometimes like this: ``` # Failed test 'database_connection_failed hook fires' # at t/01-basic.t line 247. # got: '' # expected: '1' # Looks like you failed...
According to: https://metacpan.org/pod/DBD::mysql#mysql_enable_utf8mb4 DBD::mysql requires setting `mysql_enable_utf8mb4` to support 4-byte UTF-8. MySQL is a bit quirky in that `utf8` is not **real** UTF-8. To get real UTF-8, you need `utf8mb4`:...
I have the following parameters in `development.yml`: ``` plugins: Database: connections: rw: driver: SQLite database: 'db.sqlite' dbi_params: RaiseError: 1 AutoCommit: 1 ReadOnly: 0 TaintIn: 1 TaintOut: 1 RaiseError: 1 PrintError:...
- add ShowErrorStatement to append relevant statement text to error messages - add mysql_enable_utf8 and mysql_enable_utf8mb4 flags to add UTF-8 encoding support for up to 3 (older) or 4 bit...
Happy Holidays! This pull is intended to resolve rt.cpan.org ticket: 127745. I didn't look through all the readme files originally or I would have just done a git pull request...
The simplest of joins is to take two tables, and join on a single field from each table. If we're agreed that's simple, then it is worth supporting. So, rather...
Not sure which module to blame here. But the error goes away by commenting this section of Dancer::Plugin::Database::Core.pm ``` perl # To support the database_error hook, use DBI's HandleError option...
Everywhere in my code I end up doing the following. ``` database->quick_insert($table,$data); $data->{id}=database->last_insert_id(undef,undef,undef,$pk); if ($data->{id}==0){ my $data=database->quick_select($table,$data); } ``` it would be much cleaner to replace the above with either...
Self contained testcase attached. Issue: database->last_insert_id(undef,undef,undef,$table) does not consistently return the last insert id value. In the attached testcase and log, I am calling last_insert_id in 4 different tests. 1....
Per documentation, using database() in this way: ``` my $dbh = database({ driver => 'SQLite', database => $filename }); ``` causes a brand new connection to be created each time,...