logo
Free, unlimited AI code reviews that run on commit
git-lrc git-lrc GitHub Install Now We'd appreciate a star git-lrc - Free, unlimited AI code reviews that run on commit | Product Hunt git-lrc - Free, unlimited AI code reviews that run on commit | Product Hunt

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

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).

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.

Name

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

See Also

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

perl v5.32.0                                       2021-01-04                  Wiki::Toolkit::Setup::SQLite(3pm)

Synopsis

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

See Also