public function setup() { parent::setup(); $sql = <<<SQL INSERT INTO A1 ( id, int4, string, create_timestamp, foreign_key ) VALUES ( 101, 1234, 'hi', now(), null ); INSERT INTO A1 ( id, int4, string, create_timestamp, foreign_key ) VALUES ( 201, 1234, 'hi', now(), null ); INSERT INTO A2 ( id, name ) VALUES ( 102, 'name 102' ); INSERT INTO A2 ( id, name ) VALUES ( 202, 'name 202' ); INSERT INTO A1 ( id, int4, string, create_timestamp, foreign_key ) VALUES ( 301, 1234, 'hi', now(), 102 ); SQL; $this->db->query(new Query($sql)); }
public function setup() { parent::setup(); $sql = <<<SQL INSERT INTO a1 ( id, int4, string, create_timestamp, foreign_key ) VALUES ( 101, 1234, 'hi', now(), null ); INSERT INTO a1 ( id, int4, string, create_timestamp, foreign_key ) VALUES ( 201, 1234, 'hi', now(), null ); INSERT INTO a2 ( id, name ) VALUES ( 102, 'name 102' ); INSERT INTO a2 ( id, name ) VALUES ( 202, 'name 202' ); INSERT INTO a1 ( id, int4, string, create_timestamp, foreign_key ) VALUES ( 301, 1234, 'hi', now(), 102 ); INSERT INTO a4 ( id, name, type ) VALUES ( 101, '101', 'one' ); INSERT INTO a4 ( id, name, type ) VALUES ( 201, '201', 'one' ); INSERT INTO a1_link_a4( a1_id, a4_id ) VALUES( 101, 101 ); SQL; $this->db->query(new Raw($sql)); }