Building an automatic admin interface

[RobertoMaurizzi]

I'd very much like to build something like the Django admin using Leptos and Butane, however I'm having trouble finding how to access the database structure from my code.

After a few tests trying to access the COLUMNS property for all DataObjects (building an Enum of them) that really can't work wel unless I'm missing something, I though it would be nice to get access to the data in ./butane/migrations/current/*.table

re-reading the file is possible but I was wondering how to do that accessing the migration machinery, so it would work with embedded migrations.

If you can give me some pointers about where to start from (do I use ADBs? If yes, how to get one that represents the current status of the database?) I'll happily try get something up and running.

[Electron100]

I think you'd want to go about it something like this:

1. You need to get an instance of Migrations. You can either use migrations::from_root if you know you'll have them available from disk, or you can use the embed command with the butane cli to embed them in your source code, and then call butane_migrations::get_migrations (embed should be better documented than it is).
2. Then call Migrations.latest() to get a Migration
3. Then call Migration.db() to get an ADB
4. The ADB should hopefully be fairly self explanatory on how to get the table details.

Does that help at all?

[RobertoMaurizzi]

Thanks, I'll try but probably tomorrow (it's past 10 PM here now 😅)

[RobertoMaurizzi]

In my experiments I didn't call migrations.latest() and the ADB was empty... From the source code i've read if I get the "current" ADB it should be fairly easy to get what models are available and their fields.

[RobertoMaurizzi]

... OK, I was too curious to sleep on this so since I already had added embedded migrations I tried... and it worked like a charm!
Tomorrow I'll try to see what's the best way to convert the resulting ADB to an admin interface 😄
Thanks again!