i see... so, if I understand, only the table definitions are missing
(and I should know this), but I am hoping that this means just the
tables,not the data? If something Commet could make that the tabel
data available (maybe as a string), would it be possible to to :
tables please?
client -----------------------------> web2py Server (commet
listener?)
<------------------------------------ return "Models" as a
string (I don't know the tornado size limitations)
Now that I have the the model, i should be able to have that explicite
define (with no data in the tables), then do dbRemote = DAL(... ? Or
maybe, this is silly...
Maybe export/import is the best known solution?
Thanks,
mart :)
On Jan 31, 9:09 pm, Massimo Di Pierro <[email protected]>
wrote:
> I see what you mean now. No you cannot do that.
>
> If you do
>
> python web2py.py -A app -M -N -R script.py
>
> the script will be executed in an environment similar to a controller
> and will see the stuff defined in the models.
>
> There is no way (currently) for you to do db=DAL(...) and have
> db.yourtable without an explicit db.define_table(..).
>
> On Jan 31, 7:20 pm, mart <[email protected]> wrote:
>
>
>
>
>
>
>
> > yes... that's what I meant... models ;) the models are invisible
>
> > Thanks for that, I'll try that :) so with that, I can do something
> > like:
>
> > dbRemote = DAL(....
>
> > ?
>
> > Mart :)
>
> > On Jan 31, 3:47 pm, Massimo Di Pierro <[email protected]>
> > wrote:
>
> > > Not sure what you mean by invisible. web2py does not learn about
> > > tables from the db. It learns about them from the models.
>
> > > If you run a script with
>
> > > python web2py.py -A app -M -N -R script.py
>
> > > the script will see the models.
>
> > > On Jan 31, 10:27 am, mart <[email protected]> wrote:
>
> > > > right... ok, I get that.
>
> > > > So, is there a way to connect a new network connection to an existing
> > > > sqlite db? I tried some suggestion from a posting of a few weeks ago,
> > > > and it seems to connect, but tables are 'invisible'.
>
> > > > ** Note **
> > > > some dbs are created from script (no web), still web2py (just no web,
> > > > like __2py ;)) and others are created/maintained in a deployed web2py
> > > > environment. Possible? can I for example have a script (DAL stand-
> > > > alone), connect to a fully deployed web2py's DB? Actually, the
> > > > scenario can be web2py app connects to another web2py app (on the same
> > > > or different server), can also be stand alone DAL to stand-alone DAL,
> > > > or stand-alone-DAL to web2py server, or web2py server to stand-alone
> > > > DALs db....
>
> > > > Thanks,
> > > > Mart:)
>
> > > > On Jan 31, 9:24 am, Massimo Di Pierro <[email protected]>
> > > > wrote:
>
> > > > > Impossible. You cannot picke a network connection. It more than just
> > > > > data.
>
> > > > > On Jan 31, 5:30 am, mart <[email protected]> wrote:
>
> > > > > > Hi,
>
> > > > > > I'm looking to try something (again) that has not yet been too
> > > > > > successful (but I still want to try)... Currently (with stand-alone
> > > > > > Dal) I am managing by passing 'db' around (or rather self.db) to
> > > > > > avoid
> > > > > > having to create more instances than I have to. Now, to pick up some
> > > > > > processes where they left off, I would like to try pickling
> > > > > > 'self.db'
> > > > > > to a file, let sys.exit() happen, load the pickle, then debug
> > > > > > exceptions, but without having to start from scratch ad rely on
> > > > > > breakpoints to wake me up when I get to troublesome areas (the wait
> > > > > > can be as long as an hour sometimes).
>
> > > > > > So, has anyone successfully pickled 'db'? Anything fancy that need
> > > > > > to
> > > > > > be done the the attributes (even if only temporary).
>
> > > > > > Thanks,
> > > > > > Mart :)
