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(); }