Python User.active_user_countの例

コード例 #1

ファイル: dashboard.py プロジェクト: harishr1308/lastuser

def dashboard():
    user_count = User.active_user_count()
    mau = (
        db.session.query('mau')
        .from_statement(
            db.text(
                '''
                SELECT COUNT(DISTINCT(user_session.user_id)) AS mau
                FROM user_session, "user"
                WHERE user_session.user_id = "user".id
                    AND "user".status = :status
                    AND user_session.accessed_at >= NOW() - INTERVAL '30 days'
                '''
            )
        )
        .params(status=USER_STATUS.ACTIVE)
        .scalar()
    )

    return render_template('dashboard.html.jinja2', user_count=user_count, mau=mau)