NAME

Bif::DBW - read-write helper methods for a bif database

VERSION

0.1.0_25 (2014-06-14)

SYNOPSIS

use strict;
use warnings;
use Bif::DBW;

# Bif::DBW inherits Bif::DB -> DBIx::ThinSQL -> DBI.
my $dbw = Bif::DBW->connect( $dsn );

# Read and write operations on a bif database:

$dbw->txn(sub {
    my ($old,$new) = $dbw->deploy;

    $dbw->xdo(
        insert_into => 'updates',
        values      => $hashref,
    );
});

DESCRIPTION

Bif::DBW is a DBI derivative that provides various read-write methods for retrieving information from a bif repository. For a read-only equivalent see Bif::DB. The read-only and read-write parts are separated for security and performance reasons.

DBH METHODS

nextval( $name ) -> Int

Advance the sequence $name to its next value and return that value.

currval( $name ) -> Int

Return the current value of the sequence <$name>.

deploy -> (Int, Int)

Deploys the current Bif distribution schema to the database, returning the previous (possibly 0) and newly deployed versions.

SQLITE FUNCTIONS

The following SQL functions created using the user-defined-function feature of SQLite.

create_sequence()

TODO

nextval( $name ) -> Int

Advance the sequence $name to its next value and return that value.

currval( $name ) -> Int

Return the current value of the sequence <$name>.

debug()

TODO

sha1_hex()

TODO

agg_sha1_hex()

TODO

SEE ALSO

Bif::DB, DBIx::ThinSQL::Deploy

AUTHOR

Mark Lawrence <nomad@null.net>

COPYRIGHT AND LICENSE

Copyright 2013-2014 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.