[web2py] Re: importing a db/model from other app

2011-05-31 Thread blackthorne
Yes, that is the thing I want to change. I don't want to be dependent of the source app, just its db/model. All I want is an admin app that plugs into any other app by simply defining it's name or path. It should run on the same machine and there should be no problem in importing things by path.

[web2py] Re: importing a db/model from other app

2011-05-31 Thread blackthorne
well, a script than runs every time when loading my admin app to copy/ sync the models's and the model DAL line, should work... I think I will go for that solution if I can't find anything better. On May 31, 5:38 am, mart msenecal...@gmail.com wrote: well then, not sure then is this helps, but

[web2py] Re: importing a db/model from other app

2011-05-31 Thread pbreit
It appears that DAL() supports a variable folder. Maybe that would work? ### create DAL connection (and create DB if not exists) db=DAL(('mysql://a:b@locahost/x','sqlite://storage.sqlite'),folder=None)

[web2py] Re: importing a db/model from other app

2011-05-31 Thread mart
yeah that works, although both apps need to know about the model and one of the 2 apps needs to have migrate=True. Mart :) On May 31, 11:50 am, pbreit pbreitenb...@gmail.com wrote: It appears that DAL() supports a variable folder. Maybe that would work? ### create DAL connection (and create

[web2py] Re: importing a db/model from other app

2011-05-30 Thread pbreit
I don't understand the question. Do you want to share the same DB from two different apps? I suppose you could copy the models and then set your DB connection strings to point to the same DB. In one app set migrate=False. You might even be able to symbolically link the models from one app to

[web2py] Re: importing a db/model from other app

2011-05-30 Thread mart
Have you tried Massimo's new script? I've been unexpectedly busy in the last few days, but I hope to have time to complete wrapping that script in argparse this evening (or tomorrow) which will have just a few more options that I have found useful (ie. truncate, delete db, copy model, etc.). With

[web2py] Re: importing a db/model from other app

2011-05-30 Thread blackthorne
What I want is not to clone a db or model but to be able to manage one DB from other app. I am trying to do a modified version of the admin app where you just have to chose an option to a target app and it will plug into it working as a backoffice for managers/administrators of that app. if I use

[web2py] Re: importing a db/model from other app

2011-05-30 Thread pbreit
I believe you are thinking of appadmin which is a controller in each app.

[web2py] Re: importing a db/model from other app

2011-05-30 Thread mart
well then, not sure then is this helps, but I have 1 web app looking a db and a script (no web, just dal) that points to the same DB, both can select, update, insert from the same DB etc... as long as both know about the tables (and one has migrate=True). Changes on one side side can be seen by