TinyLittleWheatley
commented
8 months ago Implicit field names for insert statements sounds nice, but creating tables from structs sounds like an ORM feature.
Also creating such function(that creates CREATE TABLE statements) requires some way of setting all the field properties that user wants per field or just setting some defaults and expect users to modify the statement, or expect them to modify table fields in another query(ALTER TABLE or st).
It all seems like a lot of trouble to automate something that people usually need to customize for themselves in my opinion.
ps: Have you seen gorm? it has both these features and works great if you like the model first approach.
zond
I find it amazingly useful to just call Get or Select instead of having to recursively loop through my struct fields and assign to them myself.
But it's equally annoying to loop through them to build an INSERT or UPDATE.
Is it feasible to create functions that does this in sqlx? If you think so, please give me advice about how you think it ought to work and I'll give it a shot.
Another useful thing along the same lines would be something that created a CREATE TABLE statement for a struct, possibly with CREATE INDEX statements where needed. Would that be feasible and valuable?