Kake > Bot-BasicBot-Pluggable-Module-SimpleBlog > Bot::BasicBot::Pluggable::Module::SimpleBlog::Store::SQLite

Download:
Bot-BasicBot-Pluggable-Module-SimpleBlog-0.02.tar.gz

Dependencies

Annotate this POD

View/Report Bugs
Module Version: 0.02   Source  

NAME ^

Bot::BasicBot::Pluggable::Module::SimpleBlog::Store::SQLite - SQLite storage for Bot::BasicBot::Pluggable::Module::SimpleBlog.

SYNOPSIS ^

  use Bot::BasicBot::Pluggable::Module::SimpleBlog::Store::SQLite;

  my $blog_store =
    Bot::BasicBot::Pluggable::Module::SimpleBlog::Store::SQLite->new(
      "/home/bot/brane.db" );

DESCRIPTION ^

Store URLs in a sqlite database for Bot::BasicBot::Pluggable::Module::SimpleBot.

IMPORTANT NOTE WHEN UPGRADING FROM PRE-0.02 VERSIONS ^

I'd made a thinko in version 0.01 in one of the column names in the table used to store the URLs in the database, so you'll have to delete your store file and start again. It didn't seem worth automatically detecting and fixing this since I only released 0.01 yesterday and I don't expect anyone to have installed it yet.

METHODS ^

new
  my $blog_store =
    Bot::BasicBot::Pluggable::Module::SimpleBlog::Store::SQLite->new(
      "/home/bot/brane.db" );

You must supply a filename writeable by the user the bot runs as. The file need not already exist; it will be created and the correct database schema set up as necessary.

Croaks if DBD::SQLite fails to connect to the file.

dbh
  my $dbh = $store->dbh;

Returns the store's database handle.

store
  $store->store( timestamp => $timestamp,
                 name      => $who,
                 channel   => $channel,
                 url       => $url,
                 comment   => $comment );

Stores the given information in the database. Croaks on error.

BUGS ^

No retrieval methods yet.

SEE ALSO ^

AUTHOR ^

Kake Pugh (kake@earth.li).

COPYRIGHT ^

     Copyright (C) 2003 Kake Pugh.  All Rights Reserved.

This module is free software; you can redistribute it and/or modify it under the same terms as Perl itself.

syntax highlighting: