CREATE TABLE rawlogs_1
(
  id integer NOT NULL DEFAULT nextval('rawlogs_template_id_seq_2'::regclass),
  rawlogs_timestamp timestamp with time zone DEFAULT now(),
  rawlogs_type smallint,
  unq boolean,
  action_key bytea,
  placement_id integer,
  landing_id integer,
  ip inet,
  useragent text,
  browser smallint,
  os smallint,
  device smallint,
  country smallint,
  device_id integer,
  params jsonb,
  CONSTRAINT rawlogs_1_pkey1 PRIMARY KEY (id)
);

CREATE OR REPLACE VIEW rawlogs AS 
 SELECT rawlogs_1.id,
    rawlogs_1.rawlogs_timestamp,
    rawlogs_1.rawlogs_type,
    rawlogs_1.unq,
    rawlogs_1.action_key,
    rawlogs_1.placement_id,
    rawlogs_1.landing_id,
    rawlogs_1.ip,
    rawlogs_1.useragent,
    rawlogs_1.browser,
    rawlogs_1.os,
    rawlogs_1.device,
    rawlogs_1.country,
    rawlogs_1.device_id,
    rawlogs_1.params
   FROM rawlogs_1;

CREATE OR REPLACE FUNCTION change_current_rawlogs_table()
  RETURNS void AS
$BODY$
                        declare
                            next_rawlog text;

                        Begin
                        select p_value into next_rawlog from tmp_parameters where p_name = 'next_rawlog';
                        if next_rawlog is null then
                            next_rawlog = 'rawlogs_1';
                            insert into tmp_parameters (p_name,p_value) values ('current_rawlog','rawlogs_2'), ('next_rawlog','rawlogs_1');
                        end if;
                        execute 'create or replace view rawlogs as select * from ' || next_rawlog;
                        end;
                        $BODY$
  LANGUAGE plpgsql;


CREATE OR REPLACE FUNCTION backup_rawlogs_table()
  RETURNS void AS
$BODY$
                    declare
                        next_rawlog text;
                        current_rawlog text;
			tmpTable text;
			curD date;
			today_date text;

                    Begin
			curD := now()::date - 1;
			today_date := to_char(curD,'YYYYMMDD');
			tmpTable := 'rawlog_'||today_date;
			select p_value into next_rawlog from tmp_parameters where p_name = 'next_rawlog';
			select p_value into current_rawlog from tmp_parameters where p_name = 'current_rawlog';
			EXECUTE $$ALTER TABLE $$||current_rawlog||$$ RENAME TO $$||tmpTable;
			EXECUTE $$ALTER TABLE $$||tmpTable||$$ SET TABLESPACE sata_space$$;
			execute $$CREATE TABLE IF NOT EXISTS $$|| current_rawlog||$$ (LIKE rawlogs_template INCLUDING ALL) $$ ;
			ALTER SEQUENCE rawlogs_template_id_seq RESTART;
			update tmp_parameters set p_value = next_rawlog where p_name = 'current_rawlog';
			update tmp_parameters set p_value = current_rawlog where p_name = 'next_rawlog';
			end;
			$BODY$
  LANGUAGE plpgsql;


INSERT INTO rawlogs (rawlogs_timestamp, rawlogs_type, unq, action_key, placement_id, landing_id, ip, useragent, browser, os, device, country, params, device_id) VALUES
  (now(), 2, TRUE, NULL, 477, 19118, '105.156.57.114',
   'Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/36.0.1985.125 Safari/537.36', 44, 4, 1,
   134, NULL, 43241);