<commit_before># -*- coding: utf-8 -*-

from datetime import datetime
from sqlalchemy import *
from sqlalchemy.orm import relation
from sqlalchemy import Column
from sqlalchemy.types import Integer, Float, DateTime
from skylines.model.auth import User
from skylines.model import DeclarativeBase

class TrackingFix(DeclarativeBase):
    __tablename__ = 'tracking_fixes'

    id = Column(Integer, autoincrement=True, primary_key=True)

    time = Column(DateTime, nullable=False, default=datetime.now)

    latitude = Column(Float)
    longitude = Column(Float)
    track = Column(Integer)
    ground_speed = Column(Float)
    airspeed = Column(Float)
    altitude = Column(Integer)
    vario = Column(Float)
    engine_noise_level = Column(Integer)

    pilot_id = Column(Integer, ForeignKey('tg_user.user_id', use_alter=True, name="tg_user.user_id"), nullable=False)
    pilot = relation('User', primaryjoin=(pilot_id==User.user_id))
<commit_msg>model/tracking: Import cleanup<commit_after># -*- coding: utf-8 -*-

from datetime import datetime
from sqlalchemy.orm import relation
from sqlalchemy import Column, ForeignKey
from sqlalchemy.types import Integer, Float, DateTime
from skylines.model.auth import User
from skylines.model import DeclarativeBase


class TrackingFix(DeclarativeBase):
    __tablename__ = 'tracking_fixes'

    id = Column(Integer, autoincrement=True, primary_key=True)

    time = Column(DateTime, nullable=False, default=datetime.now)

    latitude = Column(Float)
    longitude = Column(Float)
    track = Column(Integer)
    ground_speed = Column(Float)
    airspeed = Column(Float)
    altitude = Column(Integer)
    vario = Column(Float)
    engine_noise_level = Column(Integer)

    pilot_id = Column(Integer, ForeignKey('tg_user.user_id', use_alter=True, name="tg_user.user_id"), nullable=False)
    pilot = relation('User', primaryjoin=(pilot_id==User.user_id))

{'fraction_non_alphanumeric': 0.10121244069583553, 'fraction_numerical': 0.0010542962572482868, 'mean_word_length': 5.006329113924051, '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': '7456665', 'n_tokens_mistral': 597, 'n_tokens_neox': 579, 'n_words': 138}