LLM/prompt for coding: Difference between revisions
< LLM
Jump to navigation
Jump to search
m (Tacoball moved page LLM/Coding to LLM/prompt for coding without leaving a redirect) |
|||
| Line 3: | Line 3: | ||
=== Autogen migration from mermaid chart in a markdown file === | === Autogen migration from mermaid chart in a markdown file === | ||
* Result: | * Result: | ||
* Agent: AnythingLLM | * Agent: AnythingLLM | ||
* Model: Gemma 4 E4B | * Model: Gemma 4 E4B | ||
| Line 23: | Line 23: | ||
- write reverse DDL | - write reverse DDL | ||
</pre> | </pre> | ||
Problems: | |||
* Table name order conflict with SQL syntax. | |||
== Fill TODO == | == Fill TODO == | ||
Revision as of 10:13, 28 July 2026
Spec to Code
Autogen migration from mermaid chart in a markdown file
- Result:
- Agent: AnythingLLM
- Model: Gemma 4 E4B
Prompt
Please read docs/MAINSYS_DB.md, and generate DDL. This DDL must satisfy the following rules: - with "COMMENT ON" syntax for each table - with "COMMENT ON" syntax for each column - with "ADD CONSTRAINT" syntax for each foreign key When DDL satisfied the 3 rules above. - find the latest *.up.sql in assets\migrations - write this DDL - find the latest *.down.sql in assets\migrations - write reverse DDL
Problems:
- Table name order conflict with SQL syntax.