
    !\i	                     |    d Z ddlmZmZmZmZmZmZmZ ddl	m
Z
 ddlmZ ddlmZ  G d de      Z G d d	e      Zy
)zFeature models    )ColumnIntegerString
ForeignKeyDateFloatDateTime)relationship)datetime)Basec                   r   e Zd ZdZdZ eedd      Z ee ed      dd      Z	 ee
dd      Z eed	      Z eed	      Z eed	      Z eed	      Z eed	      Z eed	      Z eed	      Z eed	      Z eed	      Z eed	      Z eed	      Z eeej2                  	      Zd
difZy)TeamFormDailyz Daily aggregated team statisticsteam_form_dailyTprimary_keyindexzteams.idFnullabler   r   defaultsqlite_autoincrementN)__name__
__module____qualname____doc____tablename__r   r   idr   team_idr   datematches_playedwinsdrawslosses	goals_forgoals_againstpointshome_matches	home_winsaway_matches	away_winsr	   r   utcnow
created_at__table_args__     "/app/app/core/db/models/feature.pyr   r      s    *%M	T	6BWj4uDQG$d3D GQ/N'1%D7A&EGQ'Fw*I7A.MGQ'F '1-Lw*I'1-Lw*I(//:J-t46Nr/   r   c                      e Zd ZdZdZ eedd      Z ee ed      dd      Z	 ee
ej                  d      Z ee      Z ee      Z ee      Z ee      Z ee      Z ee      Z ee      Z ee      Z ee      Z ee      Z ee      Z ee      Z eed	
      Z eed	
      Z eed	
      Z ee      Zy)FeaturezFeature snapshot for a matchfeaturesTr   z
matches.idFr   )r   r   r   r   N) r   r   r   r   r   r   r   r   r   match_idr	   r   r+   calculated_atr   home_goals_for_avghome_goals_against_avghome_points_avghome_form_last_nhome_elohome_days_restaway_goals_for_avgaway_goals_against_avgaway_points_avgaway_form_last_naway_eloaway_days_resth2h_home_wins	h2h_drawsh2h_away_winsr   feature_vectorr.   r/   r0   r2   r2   $   s    &M	T	6Bgz,7%tTH8X__DIM  #E]UmOe}e}HE]N  #E]UmOe}e}HE]N 7A.Mw*I7A.M F^Nr/   r2   N)r   
sqlalchemyr   r   r   r   r   r   r	   sqlalchemy.ormr
   r   app.core.db.databaser   r   r2   r.   r/   r0   <module>rI      s2     Q Q Q '  %7D 78$d $r/   