db.define_table generates a Table object. This is merely a *model *of the
table in the database (i.e., it includes the field names and types as well
as other attributes, such as whether null and non-unique values are
allowed, etc.). The Table object contains no data at all -- it is merely
used by the DAL in order to construct queries. All data remains in the
database, and you only retrieve data when you call .select(), in which case
you get back a Rows object.
Anthony
On Tuesday, May 31, 2016 at 12:21:00 PM UTC-4, Sammy wrote:
>
> Thank you, Anthony. This is very helpful. Just to confirm though as I
> don't want to mess up my existing table, when using db.define_table, it
> just creates a "dummy" table within web2py but actual query is done on the
> real Table? I don't want to download all the data into the dummy table as
> there are millions of rows and constantly changing.
>
> On Sunday, May 29, 2016 at 12:05:52 AM UTC-4, Sammy wrote:
>>
>> I am a python/web2py newbie. I am trying to create a user friendly web
>> search form for clients that connects to our existing Oracle DB and
>> executes a query based on search criteria put in the form by users.
>>
>> For example, user will fill out the form saying first_name = "John" ,
>> last_name="Smith" and when they submit, it will output for them all the
>> information in the database for John Smith.
>>
>> I am using DAL to connect to the existing external Oracle DB
>>
>> my_db = DAL('oracle://username/password@Database')
>>
>> I am using simple FORM to create the form as I could not figure out how
>> to use SQLFORM etc. because those seem to want me to create/define tables
>> which I do not want to do as the table already exists and which do not want
>> to modify. This is purely a query program.
>>
>>
>> My display_form is something like this
>>
>> def display_form():
>> form = FORM('First Name' INPUT(_name='first_name'),
>> 'Last Name' INPUT (_name='last_name'),
>> INPUT(_type='submit'))
>>
>> if form.accepts(request,session):
>> session.first_name = request.vars.first_name
>> session.last_name = request.vars.last_name
>> redirect(URL('next'))
>> return dict (form=form)
>>
>>
>> def next():
>> sql = "SELECT * from Table 1 where field1 = session.first_name and
>> field2 = session.last_name "
>>
>> rows = my_db.executesql(sql)
>> return locals()
>>
>> Then the next.html is
>>
>> {{extend 'layout.html'}}
>> <h1>Here is your query results.</h1>
>> {{=rows}}
>>
>>
>> This works fine except that output is in this format:
>>
>> [(field1:value1,field2:value2)] etc.
>>
>> What is the easiest way to output this in a html table output?
>>
>> I would also like to provide xls output option.
>>
>> Thanks.
>>
>>
>>
>>
>>
>>
>>
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
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/d/optout.
