Skip to content

Instantly share code, notes, and snippets.

@obedespinoza
obedespinoza / populate_fact_keyword.sql
Created May 1, 2018 01:36
This is the data population for the first prototype
BEGIN TRANSACTION;
INSERT INTO poc_dw.campaign_types(name) VALUES ( 'NONE');
INSERT INTO poc_dw.campaign_types(name) VALUES ( 'OTHER');
INSERT INTO poc_dw.campaign_types(name) VALUES ( 'MOBILE NEW FEED');
INSERT INTO poc_dw.campaign_types(name) VALUES ( 'DESKTOP NEW FEED');
INSERT INTO poc_dw.campaign_types(name) VALUES ( 'RIGHT SIDE HAND');
INSERT INTO poc_dw.campaign_types(name) VALUES ( 'SITE LINK');
INSERT INTO poc_dw.campaign_types(name) VALUES ( 'ACQUISITION');
INSERT INTO poc_dw.campaign_types(name) VALUES ( 'QUOTES');
INSERT INTO poc_dw.campaign_types(name) VALUES ( 'CONTENT');
from dataclasses import dataclass
@dataclass
class Coordinates:
x: int
y: int
def __str__(self):
return f"({self.x},{self.y})"