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( $filename );or
CGI::Wiki::Setup::SQLite::setup( $dbh );Takes one argument - either the name of the file that the SQLite database is stored in or an active database handle.
NOTE: If a table that the module wants to create already exists,
setupwill 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, runcleardbfirst. - cleardb
-
use CGI::Wiki::Setup::SQLite; # Clear out all CGI::Wiki tables from the database. CGI::Wiki::Setup::SQLite::cleardb( $filename );or
CGI::Wiki::Setup::SQLite::cleardb( $dbh );Takes one argument - either the name of the file that the SQLite database is stored in or an active database handle.
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
($filename)you can pass them as
( { dbname => $filename } )or indeed
( { dbh => $dbh } )Note that's a hashref, not a hash.
AUTHOR
Kake Pugh (kake@earth.li).
COPYRIGHT
Copyright (C) 2002-2004 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.