28 lines
707 B
Python
28 lines
707 B
Python
# app/repositories/queries/user_queries.py
|
|
"""
|
|
HealthSync Motivator Batch 사용자 관련 쿼리
|
|
"""
|
|
|
|
class UserQueries:
|
|
"""사용자 관련 쿼리"""
|
|
|
|
# 활성 사용자 목록 조회
|
|
GET_ACTIVE_USERS = """
|
|
SELECT
|
|
u.member_serial_number,
|
|
u.name,
|
|
u.occupation
|
|
FROM user_service.user u
|
|
WHERE u.last_login_at >= NOW() - INTERVAL '30 days'
|
|
ORDER BY u.member_serial_number
|
|
"""
|
|
|
|
# 특정 사용자 정보 조회
|
|
GET_USER_BY_ID = """
|
|
SELECT
|
|
u.member_serial_number,
|
|
u.name,
|
|
u.occupation
|
|
FROM user_service.user u
|
|
WHERE u.member_serial_number = :user_id
|
|
""" |