File size: 2,135 Bytes
14bc723 |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 |
from app import db
from datetime import datetime
import uuid
class GoogleAd(db.Model):
"""Model for storing Google Ads data."""
id = db.Column(db.String(36), primary_key=True, default=lambda: str(uuid.uuid4()))
ad_type = db.Column(db.String(20), nullable=False) # 'search' or 'display'
title = db.Column(db.String(255), nullable=True)
description = db.Column(db.Text, nullable=True)
display_url = db.Column(db.String(255), nullable=True)
target_url = db.Column(db.String(512), nullable=True)
image_url = db.Column(db.String(512), nullable=True)
position = db.Column(db.Integer, nullable=True)
search_query = db.Column(db.String(255), nullable=True)
page_url = db.Column(db.String(512), nullable=True)
raw_data = db.Column(db.JSON, nullable=True)
sentiment = db.Column(db.JSON, nullable=True)
created_at = db.Column(db.DateTime, default=datetime.utcnow)
updated_at = db.Column(db.DateTime, default=datetime.utcnow, onupdate=datetime.utcnow)
user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=True)
def __repr__(self):
return f'<GoogleAd {self.id} - {self.title}>'
@classmethod
def from_search_ad_data(cls, ad_data, search_query, user_id=None):
"""Create a GoogleAd instance from scraped search ad data."""
return cls(
ad_type='search',
title=ad_data.get('title'),
description=ad_data.get('description'),
display_url=ad_data.get('display_url'),
target_url=ad_data.get('target_url'),
position=ad_data.get('position'),
search_query=search_query,
raw_data=ad_data,
user_id=user_id
)
@classmethod
def from_display_ad_data(cls, ad_data, user_id=None):
"""Create a GoogleAd instance from scraped display ad data."""
return cls(
ad_type='display',
image_url=ad_data.get('image_url'),
target_url=ad_data.get('target_url'),
page_url=ad_data.get('page_url'),
raw_data=ad_data,
user_id=user_id
) |