class Match(db.Model):
__tablename__ = 'matches'
   id = db.Column(db.Integer, primary_key = True)
   sport = db.Column(db.String)
   where = db.Column(db.String)
   when = db.Column(db.DateTime)
   n_players = db.Column(db.Integer)
   teams2 = db.relationship('Team', backref='new_player')

class Team(db.Model):
__tablename__ = 'teams'
   id = db.Column(db.Integer, primary_key=True)
   player = db.Column(db.String)
   team_match_id=db.Column(db.Integer, db.ForeignKey('matches.id'))
   partecipants = db.relationship('User',
                                  secondary=teams_users,
                                  backref=db.backref('teams', lazy='dynamic'),
                                  lazy='dynamic')
teams_users = db.Table('ids_container',
                     db.Column('user_id', db.Integer, db.ForeignKey('users.id')),
                     db.Column('team_id', db.Integer, db.ForeignKey('teams.id'))
                     )

now = datetime.utcnow()
matches=Team.query.filter_by(player=current_user.username)
matches_partecipated=Match.query.filter_by(id=matches.id, Match.when<=now)