// the find
liyupi/sql-father-backend-public
新项目：快速生成 SQL 和模拟数据的网站（Java 后端），大幅提高开发测试效率！by 程序员鱼皮
A Spring Boot backend for a web tool that generates SQL DDL, mock data, and boilerplate code (Java/TS/frontend) from a single schema definition, importable via form input, existing SQL, or Excel. Aimed at devs, testers, and data people who are tired of hand-writing CREATE TABLE statements and seed data for every new project.
Uses Druid's SQL parser to turn arbitrary CREATE TABLE statements into its internal TableSchema instead of hand-rolling a parser — a pragmatic choice that avoids a whole class of bugs. The core design (Schema Builder → unified TableSchema → pluggable Builders/Generators) is a genuinely clean application of factory/strategy/facade patterns, not just pattern-name-dropping. Mock data generation supports several distinct strategies (fixed, random via datafaker, regex via Generex, auto-increment, dictionary-backed) rather than just Faker defaults.
Dead since May 2023, pinned to Spring Boot 2.7.x, and the SQLDialect abstraction only ships a MySQL implementation despite the strategy-pattern setup implying more. Test coverage is a handful of throwaway smoke tests (DruidParserTest, EasyExcelTest, FreeMarkerTest) with nothing exercising the actual generator or schema-builder logic. The README explicitly forbids commercial use or resale, which is a real constraint if you were hoping to fork this into something you ship. Auth is a homegrown AOP annotation (AuthCheck) instead of Spring Security, fine for a teaching project but not something to build on directly.