LLM/prompt for coding: Difference between revisions
< LLM
Jump to navigation
Jump to search
| Line 10: | Line 10: | ||
This DDL must satisfy the following rules: | This DDL must satisfy the following rules: | ||
- with table | - with "COMMENT ON" syntax for each table | ||
- with column | - with "COMMENT ON" syntax for each column | ||
- with foreign key | - with "ADD CONSTRAINT" syntax for each foreign key | ||
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 *.down.sql in assets\migrations | |||
- write reverse DDL | |||
</pre> | </pre> | ||
Revision as of 09:04, 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 "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