Hi everyone;
I am expecting to put together a next-gen admin tool after I create an
integration module allowing CentiPOS and LedgerSMB to integrate (my project
for the week or so following the 1.4 launch).
Where I have gone so far is to:
1. Factor out general, non-LSMB-specific tasks into
PGObject::Util::DBAdmin. These tasks include backups, database creation,
and the like. I like the toolkit so far but there are still some issues
with error handling and detection I am working on.
2. Created a general framework for upgrading LedgerSMB databases without
having deep internal knowledge of the databases.
3. Add some test cases though I suspect more will come today.
So I think I have, for the most part, the admin object model done. I am
leaving a few things rather deliberately out of scope. For the first
version I might not add user management yet (though I expect to shortly).
The next step for the first draft is to build some command line tools that
can be used to manage databases. Then I will create the web app.
My current plan for URL layout is:
root/host/port/ -> get => list dbs
root/host/port/dbname/ ->
get => db version and statistics info
post a file => run sql file
post "reload" as an action => reload stored procs
post
"upgrade=[major_version]" => upgrade
root/host/port/dbname/backup -> get => take backup, put => restore backup
root/host/port/dbname/setup -> get => is set up?, put => set up for admin
The second version is likely to include user management functionality.
Here is my planned URL layout for that:
root/host/port/dbname/users => get => list of users,
post => global password reset requirements
root/host/port/dbname/users/username get => info on user,
post -> save user/reset password
root/host/port/dbname/users/roles
get => list roles
post => revoke grants and then grant roles
put => grant roles
delete => revoke grants
All resources will be available in appropriate formats (sql, appropriate
backup formats, xml, json, html).
any feedback on the url layout?
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
------------------------------------------------------------------------------
Want excitement?
Manually upgrade your production database.
When you want reliability, choose Perforce
Perforce version control. Predictably reliable.
http://pubads.g.doubleclick.net/gampad/clk?id=157508191&iu=/4140/ostg.clktrk
_______________________________________________
Ledger-smb-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
