LLM/prompt for coding: Difference between revisions
< LLM
Jump to navigation
Jump to search
| (14 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
== | == Spec to Code == | ||
=== Autogen migration from mermaid chart in a markdown file === | |||
* Result: not entirely reliable | |||
* Agent: AnythingLLM | * Agent: AnythingLLM | ||
* Model: Gemma 4 E4B | * Model: Gemma 4 E4B | ||
'''Prompt''' | |||
<pre> | <pre> | ||
Please read docs/SCHEMA.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 | |||
- with "GENERATED ALWAYS AS IDENTITY" syntax for each id column | |||
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 | |||
</pre> | </pre> | ||
== | '''Risks''' | ||
* Table name order conflict with SQL syntax. | |||
== Fill TODO == | |||
Latest revision as of 02:30, 29 July 2026
Spec to Code
Autogen migration from mermaid chart in a markdown file
- Result: not entirely reliable
- Agent: AnythingLLM
- Model: Gemma 4 E4B
Prompt
Please read docs/SCHEMA.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 - with "GENERATED ALWAYS AS IDENTITY" syntax for each id column 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
Risks
- Table name order conflict with SQL syntax.