Login or Register to Ask a Question and Join Our Community

Linux and UNIX Man Pages

Linux & Unix Commands - Search Man Pages

wiki::toolkit::setup::sqlite(3pm) [debian man page]

Wiki::Toolkit::Setup::SQLite(3pm)			User Contributed Perl Documentation			 Wiki::Toolkit::Setup::SQLite(3pm)

NAME

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

SYNOPSIS

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

DESCRIPTION

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

FUNCTIONS

       setup
	     use Wiki::Toolkit::Setup::SQLite;

	     Wiki::Toolkit::Setup::SQLite::setup( $filename );

	   or

	     Wiki::Toolkit::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, "setup" will leave it alone. This means that you can safely run this
	   on an existing Wiki::Toolkit database to bring the schema up to date with the current Wiki::Toolkit version. If you wish to completely
	   start again with a fresh database, run "cleardb" first.

	   An optional second argument may be passed specifying the schema version to use; this is ONLY intended to be used during unit testing
	   and should not normally be specified.

       cleardb
	     use Wiki::Toolkit::Setup::SQLite;

	     # Clear out all Wiki::Toolkit tables from the database.
	     Wiki::Toolkit::Setup::SQLite::cleardb( $filename );

	   or

	     Wiki::Toolkit::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 Wiki::Toolkit 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 Wiki::Toolkit search backend tables; if
	   you have any of those in the same or a different database see Wiki::Toolkit::Setup::DBIxFTS or Wiki::Toolkit::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.
	    Copyright (C) 2006-2009 the Wiki::Toolkit team. 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

       Wiki::Toolkit, Wiki::Toolkit::Setup::DBIxFTS, Wiki::Toolkit::Setup::SII

perl v5.14.2							    2011-09-25					 Wiki::Toolkit::Setup::SQLite(3pm)

Check Out this Related Man Page

Wiki::Toolkit::TestLib(3pm)				User Contributed Perl Documentation			       Wiki::Toolkit::TestLib(3pm)

NAME

       Wiki::Toolkit::TestLib - Utilities for writing Wiki::Toolkit tests.

DESCRIPTION

       When 'perl Makefile.PL' is run on a Wiki::Toolkit distribution, information will be gathered about test databases etc that can be used for
       running tests. Wiki::Toolkit::TestLib gives convenient access to this information.

SYNOPSIS

	 use strict;
	 use Wiki::Toolkit::TestLib;
	 use Test::More;

	 my $iterator = Wiki::Toolkit::TestLib->new_wiki_maker;
	 plan tests => ( $iterator->number * 6 );

	 while ( my $wiki = $iterator->new_wiki ) {
	     # put some test data in
	     # run six tests
	 }

       Each time you call "->next" on your iterator, you will get a fresh blank wiki object. The iterator will iterate over all configured search
       and storage backends.

METHODS

       new_wiki_maker
	     my $iterator = Wiki::Toolkit::TestLib->new_wiki_maker;

       number
	     use Test::More;
	     my $iterator = Wiki::Toolkit::TestLib->new_wiki_maker;
	     plan tests => ( $iterator->number * 6 );

	   Returns the number of new wikis that your iterator will be able to give you.

       new_wiki
	     my $wiki = $iterator->new_wiki;

	   Returns a fresh blank wiki object, or false if you've used up all the configured search and storage backends.

       configured_databases
	     my @configured_databases = $iterator->configured_databases;

	     Returns the @configured_databases array detailing configured test databases.
	     Useful for very low-level testing only.

SEE ALSO

       Wiki::Toolkit

AUTHOR

       Kake Pugh (kake@earth.li).

COPYRIGHT

	    Copyright (C) 2003-2004 Kake Pugh.	All Rights Reserved.
	    Copyright (C) 2008 the Wiki::Toolkit team. All Rights Reserved.

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

CAVEATS

       If you have the Search::InvertedIndex backend configured (see Wiki::Toolkit::Search::SII) then your tests will raise warnings like

	 (in cleanup) Search::InvertedIndex::DB::Mysql::lock() -
	   testdb is not open. Can't lock.
	 at /usr/local/share/perl/5.6.1/Search/InvertedIndex.pm line 1348

       or

	 (in cleanup) Can't call method "sync" on an undefined value
	   at /usr/local/share/perl/5.6.1/Tie/DB_File/SplitHash.pm line 331
	   during global destruction.

       in unexpected places. I don't know whether this is a bug in me or in Search::InvertedIndex.

perl v5.14.2							    2011-09-25					       Wiki::Toolkit::TestLib(3pm)
Man Page