NAME

Metabase::Backend::SQL - Metabase backend role for SQL-based backends

VERSION

version 1.000

SYNOPSIS

  # SQLite

  require Metabase::Archive::SQLite;
  require Metabase::Index::SQLite;

  my $archive = Metabase::Archive::SQLite->new(
    filename => $sqlite_file,
  );

  my $index = Metabase::Index::SQLite->new(
    filename => $sqlite_file,
  );

  # PostgreSQL

  use Metabase::Archive::PostgreSQL;
  use Metabase::Index::PostgreSQL;

  my $archive = Metabase::Archive::PostgreSQL->new(
    db_name => "cpantesters",
    db_user => "johndoe",
    db_pass => "PaSsWoRd",
  );

  my $index = Metabase::Index::PostgreSQL->new(
    db_name => "cpantesters",
    db_user => "johndoe",
    db_pass => "PaSsWoRd",
  );

DESCRIPTION

This distribution contains implementations of Metabase::Archive and Metabase::Index using SQL databases. >See Metabase::Backend::SQLite or Metabase::Backend::PostgreSQL for details about specific implementations.

The main module, itself, is merely a Moose role that provides common attributes for all the SQL-based Metabase backends. It is not intended to be used directly by end-users.

ATTRIBUTES

dsn

Database connection string

db_user

Database username

db_pass

Database password

db_type

SQL::Translator sub-type for a given database. E.g. "SQLite" or "PostgreSQL".

dbis

DBIx::Simple class connected to the database

schema

SQL::Translator::Schema class

REQUIRED METHODS

The following builders must be provided by consuming classes.

  _build_dsn        # a DSN string for DBI
  _build_db_user    # a username for DBI
  _build_db_pass    # a password for DBI
  _build_db_type    # a SQL::Translator type for the DB vendor

The following method must be provided to modify the output of SQL::Translator::Diff to fix up any dialect quirks

  _fixup_sql_diff

SUPPORT

Bugs / Feature Requests

Please report any bugs or feature requests through the issue tracker at http://rt.cpan.org/Public/Dist/Display.html?Name=Metabase-Backend-SQL. You will be notified automatically of any progress on your issue.

Source Code

This is open source software. The code repository is available for public review and contribution under the terms of the license.

https://github.com/dagolden/metabase-backend-sql

  git clone https://github.com/dagolden/metabase-backend-sql.git

AUTHORS

• David Golden <dagolden@cpan.org>

• Leon Brocard <acme@astray.org>

COPYRIGHT AND LICENSE

This software is Copyright (c) 2011 by David Golden.

This is free software, licensed under:

  The Apache License, Version 2.0, January 2004

cpanm Metabase::Backend::SQL

perl -MCPAN -e shell
install Metabase::Backend::SQL