作者归档：Rick

docusaurus 部署到 GitHub Pages 自定义域名

在 iCloud Drive 下创建目录 docusaurus, 命令行进入 docusaurus

npm init docusaurus@latest

What should we name this site? docs-test
…默认选择向下执行

托管 github

新建仓库 docs-test

git init
git add .
git commit -m 'project int'
git remote add origin https://github.com/jkxyx205/docs-test.git
git push -u origin main
  • 开启 github pages
    docs-test/Settings/Pages/, Source 设置 Github Actions
  • 创建部署文件.github/workflows/deploy.yml
    提示词：「docusaurus 自动部署到 GitHub Pages, 写一下部署的yml」，下面的配置是通过 Claude 3.5 sonnet 生成的
  1. name: Deploy Docusaurus to GitHub Pages
  3. on:
  4.   push:
  5.     branches: ["main"]
  6.   workflow_dispatch:
  8. permissions:
  9.   contents: read
  10.   pages: write
  11.   id-token: write
  13. concurrency:
  14.   group: "pages"
  15.   cancel-in-progress: false
  17. jobs:
  18.   deploy:
  19.     environment:
  20.       name: github-pages
  21.       url: ${{ steps.deployment.outputs.page_url }}
  22.     runs-on: ubuntu-latest
  23.     steps:
  24.       - name: Checkout
  25.         uses: actions/checkout@v4
  27.       - name: Setup Node.js
  28.         uses: actions/setup-node@v4
  29.         with:
  30.           node-version: '18'
  31.           cache: npm
  33.       - name: Install dependencies
  34.         run: npm ci
  36.       - name: Build website
  37.         run: npm run build
  39.       - name: Setup Pages
  40.         uses: actions/configure-pages@v4
  42.       - name: Upload artifact
  43.         uses: actions/upload-pages-artifact@v3
  44.         with:
  45.           path: build
  47.       - name: Deploy to GitHub Pages
  48.         id: deployment
  49.         uses: actions/deploy-pages@v4

提交 push ,如果成功部署可以访问： https://jkxyx205.github.io/docs-test/

绑定域名

  • 添加域名解析docs-test CNAME jkxyx205.github.io
  • docs-test/Settings/Pages/Custom domain 填写域名 docs-test.xxx.com 并保存
  • Enforce HTTPS 勾选，http 会自动跳转到 https

SpringBoot application.yml 配置参数，不上传到GitHub

需求：

application.yml 配置的数据库信息采用变量的形式，这样提交到GitHub的时候就不会泄露敏感信息

  • 项目目录下添加.env配置信息
  1. URL=jdbc:postgresql://localhost:5432/postgres
  2. USERNAME=root
  3. PASSWORD=123456
  • application.yml导入 .env 
  1. spring:
  2.     config:
  3.         import:
  4.         - optional:file:.env[.properties]
  • application.yml 使用变量
  1. datasource:
  2.     url: ${URL}
  3.     username: ${USERNAME}
  4.     password: ${PASSWORD}
  • java 代码使用变量
  1. @Value("${USERNAME}")
  2. private String username;
  4. @Value("${spring.datasource.username}")
  5. private String username2;
  7. @Value("${PASSWORD}")
  8. private String password;
  • .gitignore 忽略 .env
.env*

SpringBoot 集成 sharp-database

添加依赖

  1. <parent>
  2.     <groupId>org.springframework.boot</groupId>
  3.     <artifactId>spring-boot-starter-parent</artifactId>
  4.     <version>2.7.9</version>
  5.     <relativePath/>
  6. </parent>
  8. <dependencies>
  9.     <dependency>
  10.         <groupId>org.springframework.boot</groupId>
  11.         <artifactId>spring-boot-starter</artifactId>
  12.     </dependency>
  14.     <dependency>
  15.         <groupId>com.alibaba</groupId>
  16.         <artifactId>druid-spring-boot-starter</artifactId>
  17.         <version>1.2.24</version>
  18.     </dependency>
  20.     <dependency>
  21.         <groupId>com.mysql</groupId>
  22.         <artifactId>mysql-connector-j</artifactId>
  23.     </dependency>
  25.     <dependency>
  26.         <groupId>com.rick.db</groupId>
  27.         <artifactId>sharp-database</artifactId>
  28.         <version>2.0-SNAPSHOT</version>
  29.     </dependency>
  30. </dependencies>

数据库配置文件：

  1. server:
  2.   port: 8080
  3. spring:
  4.   datasource:
  5.     name: druidDataSource
  6.     type: com.alibaba.druid.pool.DruidDataSource
  7.     druid:
  8.       driver-class-name: com.mysql.cj.jdbc.Driver
  9.       url: jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=UTF-8&serverTimezone=GMT%2B8
  10.       username: root
  11.       password: root
  12.       initialSize: 1
  13.       minIdle: 5
  14.       maxActive: 10
  15.       maxWait: 60000
  17. sharp:
  18.   database: # 多个包扫描用 , 隔开
  19.     entity-base-package: com.rick.sharp.**.entity

测试

  1. @SpringBootApplication
  2. @DependsOn("entityDAOSupport")
  3. @EnableScheduling
  4. public class DemoApplication {
  6.     @Autowired
  7.     private EntityDAO<User, Long> userDAO;
  9.     @Autowired
  10.     private EntityDAO<CodeDescription, Long> codeDescriptionDAO;
  13.     public static void main(String[] args) {
  14.         SpringApplication.run(DemoApplication.class, args);
  16.         String ss = JsonUtils.toJson("ss");
  17.         System.out.println(ss);
  18.         System.out.println("running.....");
  19.     }
  21.     @Scheduled(fixedRate = 5000)
  22.     public void find() {
  23.         User user = userDAO.selectById(1L).get();
  24.         System.out.println(user.getName());
  26.         codeDescriptionDAO.insert(CodeDescription.builder()
  27.                         .code("test-" + System.currentTimeMillis())
  28.                         .description("hello")
  29.                 .category(CodeDescription.CategoryEnum.MATERIAL)
  30.                 .build());
  31.     }
  33. }

@Sql 根据对象的字段查询其他信息

假设对象有属性 物料id，联系人id，可以根据这个两个 id 分别获取 描述信息，并放到Map对象中。

将多行的 union all 进行「行转列」

  1. select 
  2. MAX(CASE WHEN c1 = 'material_name' THEN c2 END) as 'material_name',
  3. MAX(CASE WHEN c1 = 'contact_person' THEN c2 END) as 'contact_person'
  4. from (
  5. select 'material_name' c1, name c2 from mm_material where id = 725446412870901760
  6. union all
  7. select 'contact_person', contact_person from core_contact where id = 738365393630253056)
  8. t

创建查询对象 GridQuery.java

  1. @Data
  2. @Table
  3. public class GridQuery {
  5.     /**
  6.      * 必须有一个主键字段
  7.      */
  8.     private Long id;
  10.     private Long materialId;
  12.     private Long contactId;
  14.     @Transient
  15.     @Sql(value = "select \n" +
  16.             "MAX(CASE WHEN c1 = 'material_name' THEN c2 END) as 'material_name',\n" +
  17.             "MAX(CASE WHEN c1 = 'contact_person' THEN c2 END) as 'contact_person'\n" +
  18.             "from (\n" +
  19.             "select 'material_name' c1, name c2 from mm_material where id = :materialId\n" 
  20.             "union all\n" +
  21.             "select 'contact_person', contact_person from core_contact where id = :contactId)\n" +
  22.             "t", params="materialId@materialId, contactId@contactId")
  23.     private Map<String, Object> additionalInfo;
  24. }

测试信息

  1. @Autowired
  2. private EntityDAOSupport entityDAOSupport;
  4. @Test
  5. public void testQuery() {
  6.     // 单个对象
  7.     GridQuery query = new GridQuery();
  9.     query.setMaterialId(725446412870901760L);
  10.     query.setContactId(738365393630253056L);
  12.     GridQuery query1 = entityDAOSupport.query(query);
  14.     System.out.println(query1);
  16.     // 对象数组
  17.     GridQuery query2 = new GridQuery();
  18.     query2.setMaterialId(725446412870901760L);
  20.     GridQuery query3 = new GridQuery();
  21.     query3.setContactId(738365393630253056L);
  23.     List<GridQuery> query4 = entityDAOSupport.query(Arrays.asList(query2, query3));
  24. }