LLM/prompt for coding: Difference between revisions
< LLM
Jump to navigation
Jump to search
| (3 intermediate revisions by the same user not shown) | |||
| Line 3: | Line 3: | ||
=== Autogen migration from mermaid chart in a markdown file === | === Autogen migration from mermaid chart in a markdown file === | ||
* Result: | * Result: not entirely reliable | ||
* Agent: AnythingLLM | * Agent: AnythingLLM | ||
* Model: Gemma 4 E4B | * Model: Gemma 4 E4B | ||
| Line 9: | Line 9: | ||
'''Prompt''' | '''Prompt''' | ||
<pre> | <pre> | ||
Please read docs/ | Please read docs/SCHEMA.md, and generate DDL. | ||
This DDL must satisfy the following rules: | This DDL must satisfy the following rules: | ||
| Line 15: | Line 15: | ||
- with "COMMENT ON" syntax for each column | - with "COMMENT ON" syntax for each column | ||
- with "ADD CONSTRAINT" syntax for each foreign key | - 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. | When DDL satisfied the 3 rules above. | ||
| Line 24: | Line 25: | ||
</pre> | </pre> | ||
''' | '''Risks''' | ||
* Table name order conflict with SQL syntax. | * Table name order conflict with SQL syntax. | ||
== Fill TODO == | == 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.