Developing (v7+)

Use postgres DB for package

Permalink January 16, 2016 at 12:44 PM

Hi,

I want to connect a package which is able to add and list some events (meaning dates) to a postgres database.
My setup:
I have a MAMPstack from bitnami extended by the postgres-module. I installed the newest (5.7.5.4) concrete5 version and everything is fine. I can use the package with MySQL without any issues, but I want to save the data from this package on postgres.
So here is what I have within the
application/config/database.php:

<?php
return array(
    'default-connection' => 'concrete',
    'drivers' => array(
        'pdo_pgsql' => 'Doctrine\DBAL\Driver\PDOPgSql\Driver'
    ),
    'connections' => array(
        'concrete' => array(
            'driver' => 'c5_pdo_mysql',
            'server' => 'localhost',
            'database' => 'concrete5',
            'username' => 'username',
            'password' => 'password',
            'charset' => 'utf8',
        ),

Viewing 15 lines of 25 lines. View entire code block.

 
<?php
 
return array(
    'default-connection' => 'concrete',
    'drivers' => array(
        'pdo_pgsql' => 'Doctrine\DBAL\Driver\PDOPgSql\Driver'
    ),
    'connections' => array(
        'concrete' => array(
            'driver' => 'c5_pdo_mysql',
            'server' => 'localhost',
            'database' => 'concrete5',
            'username' => 'username',
            'password' => 'password',
            'charset' => 'utf8',
        ),
        'events' => array(
            'driver' => 'pdo_pgsql',
            'server' => 'localhost',
            'database' => 'concrete5',
            'username' => 'username',
            'password' => 'password',
            'charset' => 'utf8',
        ),
    ),
);

But now I don't know where to add the stuff with the connection. I already red the article about "Advanced: Using dependency injection" here:http://documentation.concrete5.org/developers/database-management/a...
But still have no idea.
My package controller looks like this:

<?php
namespace Concrete\Package\CookbookEvents;
use Concrete\Core\Database\Connection\Connection;
use Package;
use BlockType;
use SinglePage;
defined('C5_EXECUTE') or die(_("Access Denied."));
class Controller extends Package
{
    protected $pkgHandle = 'cookbook_events';
    protected $appVersionRequired = '5.7.4.0';
    protected $pkgVersion = '1.0.0';
    protected $connection;
    public function __construct()
    {

Viewing 15 lines of 37 lines. View entire code block.

 
<?php
namespace Concrete\Package\CookbookEvents;
 
use Concrete\Core\Database\Connection\Connection;
use Package;
use BlockType;
use SinglePage;
 
defined('C5_EXECUTE') or die(_("Access Denied."));
 
class Controller extends Package
{
    protected $pkgHandle = 'cookbook_events';
    protected $appVersionRequired = '5.7.4.0';
    protected $pkgVersion = '1.0.0';
    protected $connection;
 
    public function __construct()
    {
        $this->connection = \Database::connection('events');
    }
 
    public function getPackageName()
    {
        return t('Cookbook Events');
    }
 
    public function getPackageDescription()
    {
        return t('A calendar of events for our website.');
    }
 
    public function install()
    {
        $pkg = parent::install();
        $db = \Database::connection('events');
 
        // Add the dashboard pages
        $mainPage = SinglePage::add('/dashboard/cookbook_events', $pkg);
        $listPage = SinglePage::add('/dashboard/cookbook_events/event_list', $pkg);
        $addPage = SinglePage::add('/dashboard/cookbook_events/add', $pkg);
 
        // install the block type
        BlockType::installBlockType('cookbook_events', $pkg);
    }
}

And I tried to add a constructor with the connection stuff mentioned in the article above, but everytime I install the package the table is created within the mysql database and not within postgres.

Same problem if I try to add the connection stuff within a constructor in my Model which looks like this:

<?php
namespace Concrete\Package\CookbookEvents\Src;
use \Concrete\Core\Legacy\Model;
defined('C5_EXECUTE') or die(_("Access Denied."));
class CookbookEvent extends Model
{
    protected $_table = 'CookbookEvents';
    public function getDate()
    {
        return utf8_encode(strftime('%d. %b %Y', strtotime($this->event_date)));
    }
    public function getTitle()
    {
        return $this->title;
    }

Viewing 15 lines of 20 lines. View entire code block.

 
<?php
namespace Concrete\Package\CookbookEvents\Src;
 
use \Concrete\Core\Legacy\Model;
 
defined('C5_EXECUTE') or die(_("Access Denied."));
 
class CookbookEvent extends Model
{
    protected $_table = 'CookbookEvents';
 
    public function getDate()
    {
        return utf8_encode(strftime('%d. %b %Y', strtotime($this->event_date)));
    }
 
    public function getTitle()
    {
        return $this->title;
    }
 
    public function getId()
    {
        return $this->id;
    }
}

Where is my mistake or misunderstanding?

Thanks for your help in advance.

Best, Michael

Forums

Developing (v7+)

Use postgres DB for package

Code

Post Reply

Delete Post

Mark Post as Spam

Destroy Spammer

Sign In?