View Single Post
id10t id10t is online now
Registered
 
id10t's Avatar
 
Join Date: Mar 2003
Posts: 10,463
While I've got a SQL statement that will look at a table and give me a matching properly annotated Spring Entity with mostly-to-our-standards property names, I've not been lazy enough to write the code to do the reverse. Asked ChatGPT to "create a DB table that matches this entity" and other than column sizes (strings default to varchar255, Decimals became 9,2) and missing columns to meet our internal standards (that I copy/paste along w/ our grant statements anyway) it did just fine. Then again, I also used to have our SQL students do the exact same thing by hand with varying rates of accuracy/success....
__________________
“IN MY EXPERIENCE, SUSAN, WITHIN THEIR HEADS TOO MANY HUMANS SPEND A LOT OF TIME IN THE MIDDLE OF WARS THAT HAPPENED CENTURIES AGO.”
Old 01-20-2025, 05:25 PM
  Pelican Parts Catalog | Tech Articles | Promos & Specials    Reply With Quote #30 (permalink)