LOAD(url=URL('otherapp', 'controller', 'function', ...))
When specifying the "url" argument, you don't have to bother setting
ajax=True, as external URL's are always loaded via Ajax.
Anthony
On Thursday, June 6, 2013 12:44:46 PM UTC-4, Ramos wrote:
>
> LOAD signature does not show where i can specify another app
>
> LOAD(c=None, f='index', args=[], vars={},
> extension=None, target=None,
> ajax=False, ajax_trap=False,
> url=None,user_signature=False,
> timeout=None, times=1,
> content='loading...',**attr):
>
>
> 2013/6/6 António Ramos <[email protected] <javascript:>>
>
>> Anthony, your first suggestion seems more productive
>>
>> LOAD !!!
>> thank you
>>
>>
>>
>> 2013/6/6 Anthony <[email protected] <javascript:>>
>>
>>>
>>> http://web2py.com/books/default/chapter/29/06#Using-DAL-without-define-tables
>>>
>>>
>>> On Thursday, June 6, 2013 11:55:34 AM UTC-4, Ramos wrote:
>>>
>>>> how do i connect to another app sqlite database?
>>>>
>>>>
>>>>
>>>> 2013/6/6 Anthony <[email protected]>
>>>>
>>>> If you import the module from B within A, the B module doesn't get the
>>>>> "current" object from the B app -- that object is created when the db.py
>>>>> model file of the B app gets executed, which is not happening here. If
>>>>> you
>>>>> want to use the db from app B, you could either create the DAL connection
>>>>> object in the module as well, or create the DAL connection in app A but
>>>>> just use the app B modules to handle creation of the table definitions.
>>>>>
>>>>> Anthony
>>>>>
>>>>>
>>>>> On Thursday, June 6, 2013 10:37:36 AM UTC-4, Ramos wrote:
>>>>>
>>>>>> Well, seems an easy task but i´m stuck
>>>>>>
>>>>>> How can i get in app A a sqlform.smartgrid(db.auth_**user**) from
>>>>>> app B?
>>>>>> db is B's db
>>>>>>
>>>>>> in app A i call the app B module
>>>>>>
>>>>>> from applications.B.modules.funcs import *
>>>>>> def calmais():
>>>>>> return mais()
>>>>>>
>>>>>>
>>>>>>
>>>>>> In app B
>>>>>> *in db.py*
>>>>>> current.db = db
>>>>>>
>>>>>>
>>>>>> *i have a module funcs.py*
>>>>>> inside...
>>>>>> def mais():
>>>>>> db=current.db
>>>>>> grid=SQLFORM.smartgrid(db.**auth**_user)
>>>>>> return grid
>>>>>>
>>>>>>
>>>>>> i get the error
>>>>>>
>>>>>> File "applications\B\modules\funcs.****py", line 6, in mais
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>> db=current.db
>>>>>> AttributeError: 'thread._local' object has no attribute 'db'
>>>>>>
>>>>>> why cant i just use db inside a module and have to use current.db trick?
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>> 2013/6/6 António Ramos <[email protected]>
>>>>>>
>>>>>>> gotcha
>>>>>>> from applications.myapp.modules.**fun**cs import func
>>>>>>>
>>>>>>> Nice !
>>>>>>>
>>>>>>>
>>>>>>> 2013/6/6 António Ramos <[email protected]>
>>>>>>>
>>>>>>>> How do i import a module from another app?
>>>>>>>>
>>>>>>>>
>>>>>>>> 2013/6/5 Niphlod <[email protected]>
>>>>>>>>
>>>>>>>> and.... nobody stops you to call other apps pages inside your
>>>>>>>>> "master" one, e.g., using LOAD, and "elect" a master app to take care
>>>>>>>>> of
>>>>>>>>> authorization with CAS.
>>>>>>>>>
>>>>>>>>> On Wednesday, June 5, 2013 7:21:39 PM UTC+2, Ramos wrote:
>>>>>>>>>
>>>>>>>>>> I have to check this ..
>>>>>>>>>>
>>>>>>>>>> *But you can put your SQLFORM in a module function and import it
>>>>>>>>>> within
>>>>>>>>>> any application.*
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>> 2013/6/5 Vinicius Assef <[email protected]>
>>>>>>>>>>
>>>>>>>>>>> So, it doesn't make sense.
>>>>>>>>>>>
>>>>>>>>>>> But you can put your SQLFORM in a module function and import it
>>>>>>>>>>> within
>>>>>>>>>>> any application.
>>>>>>>>>>>
>>>>>>>>>>> On Wed, Jun 5, 2013 at 2:06 PM, António Ramos <
>>>>>>>>>>> [email protected]> wrote:
>>>>>>>>>>> > it was app, not database i wanted to write
>>>>>>>>>>> >
>>>>>>>>>>> > table = SQLFORM.grid(app,
>>>>>>>>>>> >
>>>>>>>>>>> > query,
>>>>>>>>>>> > links=links,
>>>>>>>>>>> > deletable=False,
>>>>>>>>>>> > editable=False,
>>>>>>>>>>> > create=False
>>>>>>>>>>> > )
>>>>>>>>>>> >
>>>>>>>>>>> >
>>>>>>>>>>> >
>>>>>>>>>>> > 2013/6/5 Vinicius Assef <[email protected]>
>>>>>>>>>>>
>>>>>>>>>>> >>
>>>>>>>>>>> >> The query parameter already has the database you wish.
>>>>>>>>>>> >>
>>>>>>>>>>> >> On Wed, Jun 5, 2013 at 1:41 PM, António Ramos <
>>>>>>>>>>> [email protected]>
>>>>>>>>>>>
>>>>>>>>>>> >> wrote:
>>>>>>>>>>> >> > Hello,
>>>>>>>>>>> >> > One of the things i have to do daily using Lotus Notes in
>>>>>>>>>>> my company is
>>>>>>>>>>> >> > to
>>>>>>>>>>> >> > have a form to show a grid with documents from another
>>>>>>>>>>> app/table.
>>>>>>>>>>> >> >
>>>>>>>>>>> >> >
>>>>>>>>>>> >> > Short story
>>>>>>>>>>> >> > First , years ago, i created an app to manage all quality
>>>>>>>>>>> certificates
>>>>>>>>>>> >> > issued to the clients.
>>>>>>>>>>> >> > About 5000 a year total.
>>>>>>>>>>> >> > I have about 70.000 in that database.
>>>>>>>>>>> >> >
>>>>>>>>>>> >> > Second, after some time ,i created another database to
>>>>>>>>>>> record every
>>>>>>>>>>> >> > visit to
>>>>>>>>>>> >> > the clients.
>>>>>>>>>>> >> >
>>>>>>>>>>> >> > Third ,recently i had to create another app to manage
>>>>>>>>>>> Quality issues/Non
>>>>>>>>>>> >> > conformities.
>>>>>>>>>>> >> > Another context, another app.another Acess Control List,etc
>>>>>>>>>>> >> >
>>>>>>>>>>> >> > In the end, our Top executives saw the need to manage all
>>>>>>>>>>> of the clients
>>>>>>>>>>> >> > documents in one single screen.At last i created an ap to
>>>>>>>>>>> manage THE
>>>>>>>>>>> >> > CLIENT!!!
>>>>>>>>>>> >> > There was no need to rewrite my apps or to import data,etc.
>>>>>>>>>>> >> > Lotus Notes can embed a view to show documents in another
>>>>>>>>>>> database with
>>>>>>>>>>> >> > just
>>>>>>>>>>> >> > the mouse click.
>>>>>>>>>>> >> > It was very easy inside Lotus Notes environment.In just
>>>>>>>>>>> some minutes it
>>>>>>>>>>> >> > was
>>>>>>>>>>> >> > DONE!!!
>>>>>>>>>>> >> >
>>>>>>>>>>> >> >
>>>>>>>>>>> >> > I wish web2py could have something like this
>>>>>>>>>>> >> >
>>>>>>>>>>> >> >
>>>>>>>>>>> >> > table = SQLFORM.grid(database,
>>>>>>>>>>> >> >
>>>>>>>>>>> >> > query,
>>>>>>>>>>> >> > links=links,
>>>>>>>>>>> >> > deletable=False,
>>>>>>>>>>> >> > editable=False,
>>>>>>>>>>> >> > create=False
>>>>>>>>>>> >> > )
>>>>>>>>>>> >> >
>>>>>>>>>>> >> > As Auth can be the same for the entire server apps , it
>>>>>>>>>>> would be nice to
>>>>>>>>>>> >> > share data as easily as possible.
>>>>>>>>>>> >> > That is a important need for an enterprise framework.
>>>>>>>>>>> >> >
>>>>>>>>>>> >> > Best regards
>>>>>>>>>>> >> >
>>>>>>>>>>> >> > António
>>>>>>>>>>> >> >
>>>>>>>>>>> >> >
>>>>>>>>>>> >> >
>>>>>>>>>>> >> >
>>>>>>>>>>> >> >
>>>>>>>>>>> >> >
>>>>>>>>>>> >> >
>>>>>>>>>>> >> > --
>>>>>>>>>>> >> >
>>>>>>>>>>> >> > ---
>>>>>>>>>>> >> > You received this message because you are subscribed to the
>>>>>>>>>>> Google
>>>>>>>>>>> >> > Groups
>>>>>>>>>>> >> > "web2py-users" group.
>>>>>>>>>>> >> > To unsubscribe from this group and stop receiving emails
>>>>>>>>>>> from it, send
>>>>>>>>>>> >> > an
>>>>>>>>>>> >> > email to web2py+un...@**googlegroups.com.
>>>>>>>>>>>
>>>>>>>>>>> >> > For more options, visit https://groups.google.com/**grou***
>>>>>>>>>>> *ps/opt_out <https://groups.google.com/groups/opt_out>.
>>>>>>>>>>> >> >
>>>>>>>>>>> >> >
>>>>>>>>>>> >>
>>>>>>>>>>> >> --
>>>>>>>>>>> >>
>>>>>>>>>>> >> ---
>>>>>>>>>>> >> You received this message because you are subscribed to the
>>>>>>>>>>> Google Groups
>>>>>>>>>>> >> "web2py-users" group.
>>>>>>>>>>> >> To unsubscribe from this group and stop receiving emails from
>>>>>>>>>>> it, send an
>>>>>>>>>>> >> email to web2py+un...@**googlegroups.com.
>>>>>>>>>>>
>>>>>>>>>>> >> For more options, visit https://groups.google.com/**grou****
>>>>>>>>>>> ps/opt_out <https://groups.google.com/groups/opt_out>.
>>>>>>>>>>> >>
>>>>>>>>>>> >>
>>>>>>>>>>> >
>>>>>>>>>>> > --
>>>>>>>>>>> >
>>>>>>>>>>> > ---
>>>>>>>>>>> > You received this message because you are subscribed to the
>>>>>>>>>>> Google Groups
>>>>>>>>>>> > "web2py-users" group.
>>>>>>>>>>> > To unsubscribe from this group and stop receiving emails from
>>>>>>>>>>> it, send an
>>>>>>>>>>> > email to web2py+un...@**googlegroups.com.
>>>>>>>>>>>
>>>>>>>>>>> > For more options, visit https://groups.google.com/**grou****
>>>>>>>>>>> ps/opt_out <https://groups.google.com/groups/opt_out>.
>>>>>>>>>>> >
>>>>>>>>>>> >
>>>>>>>>>>>
>>>>>>>>>>> --
>>>>>>>>>>>
>>>>>>>>>>> ---
>>>>>>>>>>> You received this message because you are subscribed to the
>>>>>>>>>>> Google Groups "web2py-users" group.
>>>>>>>>>>> To unsubscribe from this group and stop receiving emails from
>>>>>>>>>>> it, send an email to web2py+un...@**googlegroups.com.
>>>>>>>>>>>
>>>>>>>>>>> For more options, visit https://groups.google.com/**grou****
>>>>>>>>>>> ps/opt_out <https://groups.google.com/groups/opt_out>.
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>> --
>>>>>>>>>
>>>>>>>>> ---
>>>>>>>>> You received this message because you are subscribed to the Google
>>>>>>>>> Groups "web2py-users" group.
>>>>>>>>> To unsubscribe from this group and stop receiving emails from it,
>>>>>>>>> send an email to web2py+un...@**googlegroups.com.
>>>>>>>>> For more options, visit https://groups.google.com/**grou**
>>>>>>>>> ps/opt_out <https://groups.google.com/groups/opt_out>.
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>
>>>>>> --
>>>>>
>>>>> ---
>>>>> You received this message because you are subscribed to the Google
>>>>> Groups "web2py-users" group.
>>>>> To unsubscribe from this group and stop receiving emails from it, send
>>>>> an email to web2py+un...@**googlegroups.com.
>>>>> For more options, visit
>>>>> https://groups.google.com/**groups/opt_out<https://groups.google.com/groups/opt_out>
>>>>> .
>>>>>
>>>>>
>>>>>
>>>>
>>>> --
>>>
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups "web2py-users" group.
>>> To unsubscribe from this group and stop receiving emails from it, send
>>> an email to [email protected] <javascript:>.
>>> For more options, visit https://groups.google.com/groups/opt_out.
>>>
>>>
>>>
>>
>>
>
--
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
