NAME

CGI::Wiki::Setup::SQLite - Set up tables for a CGI::Wiki store in a SQLite database.

SYNOPSIS

  use CGI::Wiki::Setup::SQLite;
  CGI::Wiki::Setup::MySQLite::setup($dbfile);

DESCRIPTION

Set up a SQLite database for use as a CGI::Wiki store.

FUNCIONS

setup

  use CGI::Wiki::Setup::SQLite;
  CGI::Wiki::Setup::SQLite::setup($dbfile);

Takes one argument - the name of the file that the SQLite database is stored in.

NOTE: If a table that the module wants to create already exists, setup will leave it alone. This means that you can safely run this on an existing CGI::Wiki database to bring the schema up to date with the current CGI::Wiki version. If you wish to completely start again with a fresh database, run cleardb first.

cleardb

  use CGI::Wiki::Setup::SQLite;

  # Clear out the old database completely, then set up tables afresh.
  CGI::Wiki::Setup::SQLite::cleardb($dbfile);
  CGI::Wiki::Setup::SQLite::setup($dbfile);

Takes one argument - the name of the file that the SQLite database is stored in.

Clears out all CGI::Wiki store tables from the database. NOTE that this will lose all your data; you probably only want to use this for testing purposes or if you really screwed up somewhere. Note also that it doesn't touch any CGI::Wiki search backend tables; if you have any of those in the same or a different database see CGI::Wiki::Setup::DBIxFTS or CGI::Wiki::Setup::SII, depending on which search backend you're using.

ALTERNATIVE CALLING SYNTAX

As requested by Podmaster. Instead of passing arguments to the methods as

  ($dbfile)

you can pass them as

  ( { dbname => $dbfile
    }
  )

Note that's a hashref, not a hash.

AUTHOR

Kake Pugh (kake@earth.li).

COPYRIGHT

     Copyright (C) 2002 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.

SEE ALSO

CGI::Wiki, CGI::Wiki::Setup::DBIxFTS, CGI::Wiki::Setup::SII