The Perl Toolchain Summit needs more sponsors. If your company depends on Perl, please support this very important event.
 / 
CMS-Drupal-0.94
River stage one • 1 direct dependent • 1 total dependent
++
/ CMS::Drupal

NAME

CMS::Drupal - Perl interface to the Drupal CMS

VERSION

version 0.94

SYNOPSIS

  use CMS::Drupal;           

  my $drupal = CMS::Drupal->new();

  my $database_handle = $drupal->dbh(
    'database' => "my_db",
    'driver'   => "mysql",
    'username' => "my_user",
    'password' => "my_password",
    'host'     => "my_host",
    'port'     => "3306",
    'prefix'   => "myapp_"
  );

DESCRIPTION

This module provides a Perl interface to a Drupal CMS website.

Since you can't do anything with Drupal until you can talk to the database, this module doesn't do anything with the constructor but return a new object. You can get a database handle to your Drupal by calling ->dbh() with your database credentials as parameters.

You will need the appropriate DBI driver installed to connect to your database. The DBI will hint at what you need if you don't have it, so long as you set the 'driver' parameter correctly.

METHODS

new

Instantiates an object in the CMS::Drupal class.

dbh

Returns a database handle connected to your Drupal DB.

Parameters

  • database

    The name of your Drupal database. Required.

  • driver

    The DBI driver for your database. Required, from [mysql|Pg|SQLite].

  • username

    The database username. Optional. Must be a string if supplied.

  • password

    The database password. Optional. Must be a string if supplied.

  • host

    The server where the DB lives. Optional. Must be a string if supplied.

  • port

    port on which to connect. Optional. Must be an integer if supplied.

  • prefix

    The prefix that you set in Drupal for your DB table names (if any). Optional. Must be at least two characters and end with a "_").

Testing

The following is taken from t/20_valid_drupal.t and explains how to have this module test against your actual Drupal installation.

Quote

     This is t/20_valid_drupal.t It tests the CMS::Drupal module against a real Drupal
 database. It looks in your environment to see if you have provided
 connection information.

 So if you want to test against your Drupal DB, you must set the variable

 DRUPAL_TEST_CREDS

 in your environment, exactly as follows:

 required fields are 
   database - name of your DB
   driver   - your dbi:driver ... mysql, Pg or SQLite

 optional fields are
   user     - your DB user name
   password - your DB password
   host     - your DB server hostname
   port     - which port to connect on
   prefix   - your database table schema prefix, if any

 All these fields and values must be joined together in one string with no
 spaces, and separated with commas.

 Examples:

 database,foo,driver,SQLite
 database,foo,driver,Pg
 database,foo,driver,mysql,user,bar,password,baz,host,localhost,port,3306,prefix,My_

 You can set an environment variable in many ways. To make it semi permanent,
 put it in your .bashrc or .bash_profile or whatever you have.

 If you just want to run this test once, you can just do this from your
 command prompt:

 $ DRUPAL_TEST_CREDS=database,foo,driver,SQLite
 $ perl t/20_valid_drupal.t

End Quote

If you leave the environment variable set, in future you won't have to supply any credentials when calling this module's ->dbh() method:

  my $drupal = CMS::Drupal->new;
  my $dbh    = $drupal->dbh; # fatal error usually

It is not recommended to keep your credentials for a production database in your environment as it's pretty easy to read it ...

SEE ALSO

AUTHOR

Nick Tonkin <tonkin@cpan.org>

COPYRIGHT AND LICENSE

This software is copyright (c) 2015 by Nick Tonkin.

This is free software; you can redistribute it and/or modify it under the same terms as the Perl 5 programming language system itself.