LLM/prompt for coding: Difference between revisions

From Fundamental Ramen
< LLM
Jump to navigation Jump to search
No edit summary
Line 1: Line 1:
== Autogen up migration from mermaid chart in a markdown file ==
== Autogen migration from mermaid chart in a markdown file ==


* Result: Okay
* Result: Okay
Line 5: Line 5:
* Model: Gemma 4 E4B
* Model: Gemma 4 E4B


'''Prompt'''
<pre>
<pre>
Q: Could you understand xxx table in MAINSYS_DB.md
Please read docs/MAINSYS_DB.md, and generate DDL.
A: Yes ...
This DDL must satisfy the following rules:
Q: Please convert it into DDL, and place into assets/migrations/xxx.up.sql
</pre>


== Autogen up migration to down migration ==
- with table comments
- with column comments
- with foreign key definitions


* Result: Okay
When DDL satisfied the 3 rules above.
* Agent: AnythingLLM
Find the latest up.sql in assets\migrations, write this DDL.
* Model: Gemma 4 E4B
And find the latest down.sql in assets\migrations, write reverse DDL.
 
<pre>
Q: and place reverse DDL into xxx.down.sql
</pre>
</pre>

Revision as of 08:54, 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.