NAME

SQL::Tree - Generate a trigger-based SQL tree implementation

VERSION

0.05 (2021-01-28)

SYNOPSIS

use SQL::Tree;

my $sql = SQL::Tree::generate({
    driver    => $DBI_driver_name,
    drop      => $bool,
    id        => $primary_key_name,
    name      => $source_column_name_for_path,
    parent    => $parent_column_name,
    path      => $path_column_name,
    table     => $table_name,
    type      => $primary_key_type,
});

DESCRIPTION

SQL::Tree generates a herarchical data (tree) implementation for SQLite and PostgreSQL using triggers, as described here:

http://www.depesz.com/index.php/2008/04/11/my-take-on-trees-in-sql/

A single subroutine is provided that returns a list of SQL statements:

• generate( \%opts ) -> $str

See the sqltree documentation for the list of arguments and their meanings.

SEE ALSO

sqltree(1) - command line access to SQL::Tree

AUTHOR

Mark Lawrence <nomad@null.net>

COPYRIGHT AND LICENSE

Copyright 2010-2021 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.