public function initialize(Session $session)
{
parent::initialize($session);
$sql = ['begin', 'create schema pomm_test', 'create type pomm_test.complex_type as (one int4, two varchar)', 'create table pomm_test.alpha(alpha_one serial primary key, alpha_two varchar not null, alpha_three timestamp not null default now())', 'create table pomm_test.beta(beta_one serial, beta_two int4, beta_three pomm_test.complex_type[] not null, primary key(beta_one, beta_two), unique(beta_one))', 'create table pomm_test.charly(charly_one char(2) unique, charly_two point)', 'create view pomm_test.dingo as select * from pomm_test.charly', 'comment on schema pomm_test is $c$This is a test schema.$c$', 'comment on table pomm_test.beta is $c$This is the beta comment.$c$', 'comment on column pomm_test.beta.beta_one is $c$This is the beta.one comment.$c$', 'commit'];
$this->executeSql(join(';', $sql));
$inspector = new Inspector();
$inspector->initialize($session);
if (version_compare($inspector->getVersion(), '9.3', '>=') === true) {
$sql = 'create materialized view pomm_test.pluto as select * from pomm_test.charly;';
$this->executeSql($sql);
}
}
public function initialize(Session $session)
{
parent::initialize($session);
$this->createSchema();
}
/**
* initialize
*
* @see Client
*/
public function initialize(Session $session)
{
parent::initialize($session);
$this->restartListening();
}
