NAME

DBIx::ThinSQL::Drop - Clean database support for DBIx::ThinSQL

VERSION

0.0.49 (2020-02-04) development release.

SYNOPSIS

use DBIx::ThinSQL;
use DBIx::ThinSQL::Drop;

my $db = DBIx::ThinSQL->connect('dbi:SQLite:dbname=test');

# After this you can run your tests with a freshly
# cleaned database.
$db->drop_everything();

DESCRIPTION

DBIx::ThinSQL::Drop adds support to DBIx::ThinSQL for cleaning out your database. This is mostly useful when running tests with something like Test::Database where you don't know who was doing what with your test database.

This module currently only works with SQLite and PostgreSQL databases.

*WARNING* All of the following methods EAT YOUR DATA! *WARNING*

METHODS

drop_functions

Drops all functions from the database.

drop_indexes

Drops all indexes from the database.

drop_languages

Drops all languages from the database.

drop_sequences

Drops all sequences from the database.

drop_table

Drops all tables from the database.

drop_triggers

Drops all triggers from the database.

drop_views

Drops all views from the database.

drop_everything

Drops all tables, sequences, triggers and functions from the database.

SEE ALSO

DBIx::ThinSQL

AUTHOR

Mark Lawrence <nomad@null.net>

COPYRIGHT AND LICENSE

Copyright (C) 2013-2020 Mark Lawrence <nomad@null.net>

This program is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation; either version 3 of the License, or (at your option) any later version.