from migrations.fixtures.delphi_tables.v1.tables import DelphiTables as DelphiTablesV1

class DelphiTables(DelphiTablesV1):
    def create(self):
        tables = [
            self.decibel_labels_table,
            self.projects_table,
            self.project_artists_table,
            self.user_projects_table,
            self.user_labels_table,
            self.campaign_sub_category_table,
            self.campaign_category_table,
            self.campaign_platforms_table,
            self.campaign_objective_table,
            self.campaign_provider_table,
            self.campaigns_table,
            self.phases_table,
            self.phase_campaigns_table,
            self.project_campaigns_table,
            self.linkfire_campaign_table,
            self.linkfire_project_table
        ]
        for t in tables:
            self.bind.execute(t())

        self.bind.execute(
            self.create_indexes()
        )

    def projects_table(self):
        return """
            CREATE TABLE projects (
                id varchar,
                gras_id varchar,
                name varchar,
                budget numeric(12,2),
                decibel_label_id int4,
                end_date date,
                start_date date,
                is_confidential boolean DEFAULT false,
                PRIMARY KEY (id)
            );
        """