feat: 会员+积分系统后端 (#1895) #1919

Merged

auto-approve-bot merged 7 commits from feature/1895-membership-points into develop 2026-09-15 09:23:26 +08:00

Conversation 2 Commits 7 Files Changed 27

+2981

xiaoxia commented 2026-09-15 08:36:13 +08:00

Owner

Copy Link

Copy Source

概述

实现会员+积分系统的完整后端，基于 design-v2 文档。

改动内容

数据层

• migrations/008_membership_points.sql: users 表新增 is_member/member_type/member_expires_at/points_balance 4 个字段 + 4 张新表
• 4 个 Domain 对象：PointsAccount, PointsTransaction, PointsOrder, DailyUsageRecord
• 4 组 Repository 仓储：ports 接口 + SQLAlchemy 实现

服务层

• points_rules.py: 9 种积分消耗场景配置 + 计费函数
• points_service.py: 积分账户管理、余额检查、扣减/退还/充值、每日免费额度、订单管理

中间件

• points_gate.py: AI 功能入口积分扣费装饰器，支持同步/异步，业务失败自动退还

API 层

• schemas/points.py: 请求/响应 Schema
• routes/points.py: 积分余额、流水、规则、积分包、扣费、退还、充值订单、会员状态、每日用量
• router.py: 注册 points/usage 路由

测试

• test_points_rules.py: 20 个测试用例（场景配置、计费逻辑、会员折扣、异常处理）
• test_points_service.py: 20 个测试用例（账户管理、余额检查、扣减/退还/充值、流水查询、每日额度、订单管理）

CI 状态

等待 CI 流水线验证

## 概述 实现会员+积分系统的完整后端，基于 design-v2 文档。 ## 改动内容 ### 数据层 - `migrations/008_membership_points.sql`: users 表新增 is_member/member_type/member_expires_at/points_balance 4 个字段 + 4 张新表 - 4 个 Domain 对象：PointsAccount, PointsTransaction, PointsOrder, DailyUsageRecord - 4 组 Repository 仓储：ports 接口 + SQLAlchemy 实现 ### 服务层 - `points_rules.py`: 9 种积分消耗场景配置 + 计费函数 - `points_service.py`: 积分账户管理、余额检查、扣减/退还/充值、每日免费额度、订单管理 ### 中间件 - `points_gate.py`: AI 功能入口积分扣费装饰器，支持同步/异步，业务失败自动退还 ### API 层 - `schemas/points.py`: 请求/响应 Schema - `routes/points.py`: 积分余额、流水、规则、积分包、扣费、退还、充值订单、会员状态、每日用量 - `router.py`: 注册 points/usage 路由 ### 测试 - `test_points_rules.py`: 20 个测试用例（场景配置、计费逻辑、会员折扣、异常处理） - `test_points_service.py`: 20 个测试用例（账户管理、余额检查、扣减/退还/充值、流水查询、每日额度、订单管理） ## CI 状态 等待 CI 流水线验证

xiaoxia added 1 commit 2026-09-15 08:36:13 +08:00

feat: add membership & points system backend (#1895) ... c3e1ab62ed

- Add migration 008_membership_points.sql: users table new fields + 4 new tables
- Add domain objects: PointsAccount, PointsTransaction, PointsOrder, DailyUsageRecord
- Add repository ports & SQLAlchemy adapter implementations
- Add PointsService with balance/charge/refund/recharge/daily-usage logic
- Add points_rules configuration (9 scenes, packages, membership pricing)
- Add points_gate middleware decorator for AI feature entry points
- Add API routes: points balance/transactions/rules/packages/check/deduct/refund/recharge
- Add API routes: membership status, daily usage
- Add unit tests for points_rules (20 tests) and points_service (20 tests)

gitea-actions bot commented 2026-09-15 08:38:38 +08:00

Copy Link

Copy Source

🚀 预览环境已部署

项目	详情
PR号	#1919
预览链接	https://pr-1919.preview.xiaoxiajianji.com
API环境	staging

💡 预览环境使用 staging API 数据，请勿在预览环境中操作重要数据。

🔄 每次提交新代码后预览环境会自动更新。

🗑️ PR 关闭或合并后，预览环境会自动清理。

🚀 **预览环境已部署** | 项目 | 详情 | |------|------| | PR号 | #1919 | | 预览链接 | [https://pr-1919.preview.xiaoxiajianji.com](https://pr-1919.preview.xiaoxiajianji.com) | | API环境 | staging | > 💡 预览环境使用 staging API 数据，请勿在预览环境中操作重要数据。 > > 🔄 每次提交新代码后预览环境会自动更新。 > > 🗑️ PR 关闭或合并后，预览环境会自动清理。

auto-approve-bot added 1 commit 2026-09-15 08:39:37 +08:00

style: auto-format with black + isort + ruff + prettier [skip ci-format-check] c480bf1b44

xiaoxia added 1 commit 2026-09-15 08:41:58 +08:00

feat: add Alembic migration 076 for membership & points system (#1895) ... d60fa86d70

- Add is_member, member_type, member_expires_at, points_balance to users table
- Create points_accounts, points_transactions, points_orders, daily_usage_records tables
- Include proper indexes, constraints and downgrade path

auto-approve-bot added 1 commit 2026-09-15 08:45:38 +08:00

style: auto-format with black + isort + ruff + prettier [skip ci-format-check] 78d96c5d2b

xiaoxia added 1 commit 2026-09-15 08:49:59 +08:00

fix: resolve ruff B904 lint error in points routes 0a4bf5c856

xiaoxia added 1 commit 2026-09-15 09:06:35 +08:00

test: add comprehensive unit tests for repositories and points_gate (#1895) ... f69752024a

- test_points_repositories.py: 18 tests covering all 4 SA repository implementations
- test_points_gate.py: 10 tests covering points_gate decorator sync/async/edge cases
- Total unit tests: 68 (was 40)

auto-approve-bot added 1 commit 2026-09-15 09:14:41 +08:00

style: auto-format with black + isort + ruff + prettier [skip ci-format-check] 10a8d76052

auto-approve-bot merged commit 90cc0026b1 into develop 2026-09-15 09:23:26 +08:00

auto-approve-bot deleted branch feature/1895-membership-points 2026-09-15 09:23:26 +08:00

xiaoxia referenced this issue from a commit 2026-09-15 09:23:36 +08:00

fix(p0): #1919 from-assets空templateId双斜杠404兜底

gitea-actions bot commented 2026-09-15 09:24:01 +08:00

Copy Link

Copy Source

🗑️ 预览环境已清理

PR #1919 已关闭或合并，对应的预览环境已被清理。

如有需要，可以重新打开 PR 来重新生成预览环境。

🗑️ **预览环境已清理** PR #1919 已关闭或合并，对应的预览环境已被清理。 > 如有需要，可以重新打开 PR 来重新生成预览环境。

xiaoxia referenced this pull request 2026-09-15 12:26:07 +08:00

feat(#1895): 会员积分系统后端（P1-P4，默认关闭） #1923

xiaoxia referenced this issue from a commit 2026-09-15 22:21:04 +08:00

fix(#1894): fix alembic revision chain — rename 077→076 (no 076 existed), set down_revision to 075_add_sentence_timings, add postgresql dialect guard

Sign in to join this conversation.

Reviewers

No Reviewers

Labels

Clear labels

architecture

架构设计

backend

后端相关

blocked

阻塞中

bug

Bug修复

ci-bug

CI本身的bug

ci-optimization

CI优化类任务

ci-pipeline

CI流水线/workflow相关

cleanup

代码清理

devops

运维/部署/CI

documentation

文档相关

feature

新功能

frontend

前端相关

P0

阻塞性，必须立即处理

P1

高优先级

P2

中优先级

P3

低优先级/后考虑

question

需要讨论确认

ready

PR CI通过，可合并

refactor

代码重构

No Label

Milestone

No items

No Milestone

Projects

Clear projects

No project

Assignees

Clear assignees

auto-approve-bot frontend-dev xiaoxia

No Assignees

3 Participants

Notifications

Subscribe

Due Date

No due date set.

Dependencies

No dependencies set.

Reference: xiaoxia/xiaoxia-saas#1919