View Coordinate task
from dataclasses import dataclass | |
@dataclass | |
class Coordinates: | |
x: int | |
y: int | |
def __str__(self): | |
return f"({self.x},{self.y})" | |
View populate_fact_keyword.sql
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'); |