<commit_before>#!/usr/bin/env python
# -*- coding: utf-8 -*-

from sqlalchemy import Column, DateTime, Float, ForeignKey, Integer, String
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.orm import relationship

Base = declarative_base()


class Locale(Base):
    __tablename__ = "locales"
    id = Column(Integer, primary_key=True)
    airport_icao = Column(String(4), index=True, nullable=False, unique=True)
    city = Column(String(32))
    state = Column(String(2))
    time_zone = Column(String(3))


class Observation(Base):
    __tablename__ = "observations"
    id = Column(Integer, primary_key=True)
    datetime_local = Column(DateTime, index=True, nullable=False, unique=True)
    temperature_f = Column(Float)
    dew_point_f = Column(Float)
    relative_humidity = Column(Float)
    sea_level_pressure_in = Column(Float)
    visibility_miles = Column(Float)
    wind_direction = Column(String(4))
    wind_speed_mph = Column(Float)
    gust_speed_mph = Column(Float)
    precipitation_in = Column(Float)
    events = Column(String(16))
    conditions = Column(String(16))
    wind_dir_degrees = Column(Integer)
    datetime_utc = Column(DateTime, nullable=False)
    locale_id = Column(Integer, ForeignKey("locales.id"))
    locale = relationship(Locale)<commit_msg>Update data model<commit_after>#!/usr/bin/env python
# -*- coding: utf-8 -*-

from sqlalchemy import Column, DateTime, Float, ForeignKey, Integer, String
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.orm import relationship

Base = declarative_base()


class Locale(Base):
    __tablename__ = "locales"
    id = Column(Integer, primary_key=True)
    airport_icao = Column(String, index=True, nullable=False)
    city = Column(String)
    state = Column(String)
    time_zone = Column(String)


class Observation(Base):
    __tablename__ = "observations"
    id = Column(Integer, primary_key=True)
    datetime_local = Column(DateTime, index=True, nullable=False)
    temperature_f = Column(Float)
    dew_point_f = Column(Float)
    relative_humidity = Column(Float)
    sea_level_pressure_in = Column(Float)
    visibility_miles = Column(Float)
    wind_direction = Column(String)
    wind_speed_mph = Column(Float)
    gust_speed_mph = Column(Float)
    precipitation_in = Column(Float)
    events = Column(String)
    conditions = Column(String)
    wind_dir_degrees = Column(Integer)
    datetime_utc = Column(DateTime, nullable=False)
    locale_id = Column(Integer, ForeignKey("locales.id"))
    locale = relationship(Locale)
{'fraction_non_alphanumeric': 0.10546875, 'fraction_numerical': 0.0046875, 'mean_word_length': 4.653421633554084, 'pattern_counts': {'":': 0, '<': 3, '<?xml version=': 0, '>': 3, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '2524535', 'n_tokens_mistral': 820, 'n_tokens_neox': 801, 'n_words': 169}