U
    YHg}                     @   sX   d dl mZ d dlmZ d dlmZ d dlmZ G dd deZG dd deej	Z
d	S )
    )absolute_import)	BaseQuery)db)TimestampMixinc                   @   s$   e Zd Zdd Zdd Zdd ZdS )TeacherQueryc                 C   s   |    S N)filterallself r   0/var/www/dostadmin/dostadmin/db_model/teacher.pyget_all_teachers   s    zTeacherQuery.get_all_teachersc                 C   s   |  tj|k S r   )r   Teacher	school_idr	   )r   r   r   r   r   get_by_school   s    zTeacherQuery.get_by_schoolc                 C   s   |  tj|k S r   )r   r   idfirst)r   
teacher_idr   r   r   	get_by_id   s    zTeacherQuery.get_by_idN)__name__
__module____qualname__r   r   r   r   r   r   r   r      s   r   c                   @   sp   e Zd ZdZeZejejddZ	eeje
dZeeje
dZejddddZd	d
 Zedd ZdS )r   teacherT)primary_keyz
partner.idzusers.idClasszClass.teacher_id == Teacher.id)backrefprimaryjoinc                 C   s   d| j j t| j S )NzTeacher )usernamestrr   r
   r   r   r   __repr__   s    zTeacher.__repr__c                 C   s&   t ||d}tj| tj  |S )N)r   user_id)r   r   sessionaddcommit)clsr"   r   r   r   r   r   add_teacher!   s    
zTeacher.add_teacherN)r   r   r   __tablename__r   query_classr   ColumnIntegerr   
ForeignKeyr   r"   relationshipclassesr!   classmethodr'   r   r   r   r   r      s     r   N)
__future__r   flask_sqlalchemyr   	dostadminr   dostadmin.mixinsr   r   Modelr   r   r   r   r   <module>   s
   