LLM/prompt for coding: Difference between revisions

From Fundamental Ramen
< LLM
Jump to navigation Jump to search
No edit summary
Line 15: Line 15:


When DDL satisfied the 3 rules above.
When DDL satisfied the 3 rules above.
Find the latest up.sql in assets\migrations, write this DDL.
Find the latest *.up.sql in assets\migrations, write this DDL.
And find the latest down.sql in assets\migrations, write reverse DDL.
And find the latest *.down.sql in assets\migrations, write reverse DDL.
</pre>
</pre>

Revision as of 08:55, 28 July 2026

Autogen migration from mermaid chart in a markdown file

  • Result: Okay
  • Agent: AnythingLLM
  • Model: Gemma 4 E4B

Prompt

Please read docs/MAINSYS_DB.md, and generate DDL.
This DDL must satisfy the following rules:

- with table comments
- with column comments
- with foreign key definitions

When DDL satisfied the 3 rules above.
Find the latest *.up.sql in assets\migrations, write this DDL.
And find the latest *.down.sql in assets\migrations, write reverse DDL.