gharris999;514943 Wrote:
> And if that's true, is there any sort of DBD 'passthrough' mode whereby
> I can just feed raw sql statements to dbd and get it to execute them?
>
I assume it would work the same as with MySQL, I do something like this
in some of my plugins.
Code:
--------------------
my $dbh = Slim::Schema->storage->dbh();
my $sth = $dbh->prepare( "UPDATE ...." );
eval {
$sth->execute();
commit($dbh);
};
if( $@ ) {
$log->warn("Database error: $DBI::errstr\n");
eval {
rollback($dbh);
};
}
--------------------
--
erland
Erland Isaksson
'My homepage' (http://erland.isaksson.info) (Install my plugins through
Extension Downloader)
(Developer of 'TrackStat, SQLPlayList, DynamicPlayList, Custom Browse,
Custom Scan, Custom Skip, Multi Library, Title Switcher and Database
Query plugins'
(http://wiki.erland.isaksson.info/index.php/Category:SlimServer))
------------------------------------------------------------------------
erland's Profile: http://forums.slimdevices.com/member.php?userid=3124
View this thread: http://forums.slimdevices.com/showthread.php?t=75024
_______________________________________________
beta mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/beta
