12 Commits

Author SHA1 Message Date
f948a84eb9 Merge pull request 'dev' (#1) from dev into main
All checks were successful
Deploy to Server / deploy (push) Successful in 5s
Reviewed-on: #1
2026-01-09 02:37:05 +00:00
ethan.chen
56d9736597 添加媒体统计接口 /api/media/stats
All checks were successful
Deploy to Server / deploy (push) Successful in 5s
- 返回媒体总数、满分作品数、平均评分
- 按类型统计各类型作品数量
- 返回最新添加的5部作品
- 便于前端展示数据统计信息
2026-01-09 10:30:40 +08:00
ethan.chen
9bcfbe0113 添加 Gitea Actions 部署工作流
All checks were successful
Deploy to Server / deploy (push) Successful in 19s
- 创建 deploy.yml 工作流文件,支持自动部署到宿主机
- 使用 runs-on: host 在宿主机上运行
- 自动同步文件、安装依赖并重启 PM2 应用
- 添加部署说明文档
2026-01-09 10:28:03 +08:00
ethan.chen
b33ac37720 修复 page 接口返回的 date 字段格式
- 格式化 date 字段,只返回日期部分(YYYY-MM-DD),移除时间信息
2026-01-08 18:00:19 +08:00
ethan.chen
d296108f67 添加数据库自动初始化功能
- 创建 db/init.ts 脚本,可自动创建数据库和表
- 更新 db/index.ts,应用启动时自动检查并创建表结构
- 添加 bun run init-db 命令用于初始化数据库
- 更新 README.md 添加数据库初始化说明
2026-01-08 14:58:04 +08:00
ethan.chen
02ebb4c648 feat: 项目从deno迁移回使用bun 2026-01-08 14:30:11 +08:00
ethan.chen
2b5b2f1d97 迁移数据库从 SQLite 到 PostgreSQL
- 更新 deno.json 添加 postgres 依赖
- 重构 db/index.ts 使用 PostgreSQL 连接和适配器
- 更新所有路由文件支持异步数据库操作
- 将 SQLite 语法转换为 PostgreSQL 语法
- 添加数据库迁移文档和 schema 文件
2026-01-08 14:26:27 +08:00
ethan.chen
32f7b86f28 feat: implement authentication middleware and routes
- Added `auth.ts` for JWT authentication middleware.
- Created `auth` route to handle authentication and token verification.
- Integrated authentication middleware into `media.ts` for protected routes.
- Updated `main.ts` to register the new authentication route.
2025-06-23 16:57:22 +08:00
ethan.chen
e511ab9db6 feat: enhance deployment process and server configuration
- Updated `deno.json` to allow environment variable access in the start task.
- Added `deploy.sh` script for building and deploying the application to a remote server.
- Modified `main.ts` to retrieve the `AUTH_SECRET` and `PORT` from environment variables.
- Created `my-score.service` for managing the Deno service with systemd.
- Cleaned up `user.ts` by removing unnecessary console logs.
2025-06-19 16:28:50 +08:00
ethan.chen
499321a842 chore: add .gitignore, remove VSCode settings, and optimize database queries 2025-06-13 14:42:57 +08:00
ethan.chen
e610605c76 remove: delete old media.db file and update new media.db 2025-06-13 14:14:03 +08:00
ethan.chen
c60fde3321 init: 初始化 2025-06-13 13:56:26 +08:00