Now the problem was how to modify the insert generated by old WordPress backup to the new columns . But I wanted to do it in one shot . So a new application: instead of WSL, I will put into Docker( WordPress has already a docker image). Instead of PowerShell, I will have a .NET Aspire . And an executable to execute the split the backup(one file) into multiple files ( one per table) and then execute the import for posts and comments. Again , for each operation I requested to generate a test.
He was generating most of the code successful. However, I have had some problems:
- The csproj was having different aspire versions
- I give to AI example about how to look for columns to be removed from the insert and to generate a new insert. He never manage to do it correct. I rephrase and I tell that I want to separate the values of the insert into a class . This was pretty successful – however, I need to intervene to modify the function
public WordPressPost ParseInsertStatement(string insertStatement)
because I was getting too much errors
After this I just
– backup the database ( copied the files via phpMyAdmin, installed with Aspire)
var server = builder.AddMySql(“mysql”)
.WithPhpMyAdmin()– copied the files from docker to local PC
– deploy
– restore backup to hosting
– copied files from local pc ( with ftp ) to hosting
Conclusions about how AI has helped me in the next post!