# my-password

**Repository Path**: chanchaw/my-password

## Basic Information

- **Project Name**: my-password
- **Description**: 我的密码本
- **Primary Language**: Unknown
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 1
- **Forks**: 0
- **Created**: 2026-06-07
- **Last Updated**: 2026-06-21

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

## 概述



## 工具

### 测试新增

执行方法 `SignTestUtils # main` 得到有效期5分钟的请求参数，使用 `post` 方法请求 `http://localhost:17077/pwdbe/api/codebook` 传入前面生成的参数，会向 `codebook` 新增一笔数据

### 数据库查看明文

```sql
SELECT 
    id,
    sid,
    os_user,
    -- 解密敏感字段
    AES_DECRYPT(FROM_BASE64(os_pwd), UNHEX('318bcb4be908d0da6448a0db76908d78')) AS os_pwd_decrypted,
    sunlogin_code,
    AES_DECRYPT(FROM_BASE64(sunlogin_pwd), UNHEX('318bcb4be908d0da6448a0db76908d78')) AS sunlogin_pwd_decrypted,
    mysql_user,
    AES_DECRYPT(FROM_BASE64(mysql_pwd), UNHEX('318bcb4be908d0da6448a0db76908d78')) AS mysql_pwd_decrypted,
    AES_DECRYPT(FROM_BASE64(mysql_port), UNHEX('318bcb4be908d0da6448a0db76908d78')) AS mysql_port_decrypted,
    rust_id,
    AES_DECRYPT(FROM_BASE64(rust_pwd), UNHEX('318bcb4be908d0da6448a0db76908d78')) AS rust_pwd_decrypted,
    alias,
    code,
    remark,
    miniid
FROM codebook
WHERE is_delete = 0;


SELECT 
    id,
    parent_id,
    sid,
    os_user,
    AES_DECRYPT(FROM_BASE64(os_pwd), UNHEX('318bcb4be908d0da6448a0db76908d78')) AS os_pwd_decrypted,
    sunlogin_code,
    AES_DECRYPT(FROM_BASE64(sunlogin_pwd), UNHEX('318bcb4be908d0da6448a0db76908d78')) AS sunlogin_pwd_decrypted,
    mysql_user,
    AES_DECRYPT(FROM_BASE64(mysql_pwd), UNHEX('318bcb4be908d0da6448a0db76908d78')) AS mysql_pwd_decrypted,
    AES_DECRYPT(FROM_BASE64(mysql_port), UNHEX('318bcb4be908d0da6448a0db76908d78')) AS mysql_port_decrypted,
    rust_id,
    AES_DECRYPT(FROM_BASE64(rust_pwd), UNHEX('318bcb4be908d0da6448a0db76908d78')) AS rust_pwd_decrypted,
    alias,
    code,
    remark,
    miniid
FROM codebook_detail
WHERE is_delete = 0;


# 创建了解密的视图，使用查询更方便
-- 查询解密后的密码本数据
SELECT * FROM v_codebook_decrypted;

-- 查询解密后的明细数据
SELECT * FROM v_codebook_detail_decrypted;

-- 按用户查询
SELECT * FROM v_codebook_decrypted WHERE miniid = 'test_user_001';
```