Re: [web2py] DAL return all Fields

[Maurice Waka]

Thanks. Doing that already.

On Tue, 1 May 2018, 18:55 Richard Vézina 
wrote:

> I really recommand you to go through this book chapiter :
>
> http://web2py.com/books/default/chapter/29/02/the-python-language
>
> You will learn a lot of thing over which you fall right now.
>
> You also can use type(some_python_object) from the shell to understand
> what you work with... You also can use print and look at the data structure
> of the raw object before trying to loop over it while expecting a behavior
> but forgot that you iterate over a dict and not list for instance...
>
> Richard
>
> On Tue, May 1, 2018 at 11:51 AM, Richard Vézina <
> ml.richard.vez...@gmail.com> wrote:
>
>> Are you querying multiple table?? You can do a join... That way you will
>> have all the value for every fields the only catch is that when you join to
>> disambiguate fields names dal use table.field instead of just field as
>> field name so it migth happen that if you call "manually" vs
>> "programmatically" you field you forgot about that... You have to do
>> db.table['table.field']...
>>
>> Richard
>>
>> On Tue, May 1, 2018 at 11:22 AM, Maurice Waka 
>> wrote:
>>
>>> Thanks.
>>> It iterates well giving some fields data, but not all as needed. I get
>>> data from some 4 fields only. I have about 60 in some db. Plus there is
>>> this:
>>> 
>>>
>>> On Tue, 1 May 2018, 16:44 Richard Vézina 
>>> wrote:
>>>
 for f, v in row:

 Should be

 for f, v in row.iteritems():

 k, v for key, value, but I use f instead of k because you will have
 field_name and value in this for loop...

 Richard

 On Mon, Apr 30, 2018 at 11:39 PM, Maurice Waka 
 wrote:

> What would f, v be.
> I get this error : ValueError : too many values to unpack
>
> On Mon, 30 Apr 2018, 20:38 Richard Vézina 
> wrote:
>
>>
>>
>> On Mon, Apr 30, 2018 at 1:21 PM, Maurice Waka 
>> wrote:
>>
>>> Sorry I tried to clarify by my new question :
>>>
>>> If I have a column with data like db.persons with data like
>>> Carl
>>> Junior
>>> Maggie
>>> Tom
>>> Derrick
>>>
>>> And each column name has other fields with data such as:
>>> persons.name persons.age persons.location persons.occupation
>>> persons.interests
>>> Carl 23 London Neuroscientist brainy stuff
>>> Junior 25 Tokyo doctor medical research
>>> Maggie 33 Nairobi farmer GMO research
>>> Tom 25 Sydney teacher educational ideas
>>> Derrick 21 Chicago surgeon Cutting through
>>>
>>>
>>>
>>> I want to iterate through the column  persons.nameand randomly pick
>>> a name and using the rows object, display all data about the person.
>>>
>>> If I do
>>> rows_name = db().select(db.persons.name).column()
>>>
>>
>>
>> The above should be :
>>
>> fields = db.persons.fields
>> # You should have in fields a list of all fields names you migth want
>> to remove "id" field by filtering it or find index and pop it out of the
>> list
>> # ex.: fields.pop(fields.index('id'))
>>
>>
>>
>>>
>>>
>>> rows = db(db.persons.ALL).select()
>>>
>>
>> db(where_clause).select(fields_name_separated_by_comma)
>>
>> The above is completly wrong as you pass the fields instead of
>> specifying your where clause parameter...
>>
>> In you example you really only need select like this :
>>
>> def some_func_name()
>> rows = db(db.persons.id > 0).select(db.persons.ALL)
>>
>> rows_values = []
>> for row in rows:
>> row_value = []
>> for f, v in row:
>> if f != 'id':
>> row_value.append(v)
>> rows_values.append(row_value)
>> return rows_values
>>
>> ret = some_func_name()
>>
>> for r in ret:
>> print(' '.join(ret))
>>
>> I didn't tested it but the above should work...
>>
>> Good luck
>>
>>>
>>> for row in rows:
>>> if rows_name[0] == 'Maggie':
>>> for row in rows:
>>> return [row.age+' '+row.location+' '+row.occupation+'
>>> '+row.interests]
>>>
>>> The problem is that if I query 'Carl' which is the first item, I get
>>> the response but I cant query any other name .
>>> Regards
>>>
>>>
>>>
>>> --
>>> 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 a topic in
>>> the Google Groups "web2py-users" group.
>>> To unsubscribe from this topic, 

Re: [web2py] DAL return all Fields

[Richard Vézina]

Are you querying multiple table?? You can do a join... That way you will
have all the value for every fields the only catch is that when you join to
disambiguate fields names dal use table.field instead of just field as
field name so it migth happen that if you call "manually" vs
"programmatically" you field you forgot about that... You have to do
db.table['table.field']...

Richard

On Tue, May 1, 2018 at 11:22 AM, Maurice Waka  wrote:

> Thanks.
> It iterates well giving some fields data, but not all as needed. I get
> data from some 4 fields only. I have about 60 in some db. Plus there is
> this:
> 
>
> On Tue, 1 May 2018, 16:44 Richard Vézina 
> wrote:
>
>> for f, v in row:
>>
>> Should be
>>
>> for f, v in row.iteritems():
>>
>> k, v for key, value, but I use f instead of k because you will have
>> field_name and value in this for loop...
>>
>> Richard
>>
>> On Mon, Apr 30, 2018 at 11:39 PM, Maurice Waka 
>> wrote:
>>
>>> What would f, v be.
>>> I get this error : ValueError : too many values to unpack
>>>
>>> On Mon, 30 Apr 2018, 20:38 Richard Vézina 
>>> wrote:
>>>


 On Mon, Apr 30, 2018 at 1:21 PM, Maurice Waka 
 wrote:

> Sorry I tried to clarify by my new question :
>
> If I have a column with data like db.persons with data like
> Carl
> Junior
> Maggie
> Tom
> Derrick
>
> And each column name has other fields with data such as:
> persons.name persons.age persons.location persons.occupation
> persons.interests
> Carl 23 London Neuroscientist brainy stuff
> Junior 25 Tokyo doctor medical research
> Maggie 33 Nairobi farmer GMO research
> Tom 25 Sydney teacher educational ideas
> Derrick 21 Chicago surgeon Cutting through
>
>
>
> I want to iterate through the column  persons.nameand randomly pick a
> name and using the rows object, display all data about the person.
>
> If I do
> rows_name = db().select(db.persons.name).column()
>


 The above should be :

 fields = db.persons.fields
 # You should have in fields a list of all fields names you migth want
 to remove "id" field by filtering it or find index and pop it out of the
 list
 # ex.: fields.pop(fields.index('id'))



>
>
> rows = db(db.persons.ALL).select()
>

 db(where_clause).select(fields_name_separated_by_comma)

 The above is completly wrong as you pass the fields instead of
 specifying your where clause parameter...

 In you example you really only need select like this :

 def some_func_name()
 rows = db(db.persons.id > 0).select(db.persons.ALL)

 rows_values = []
 for row in rows:
 row_value = []
 for f, v in row:
 if f != 'id':
 row_value.append(v)
 rows_values.append(row_value)
 return rows_values

 ret = some_func_name()

 for r in ret:
 print(' '.join(ret))

 I didn't tested it but the above should work...

 Good luck

>
> for row in rows:
> if rows_name[0] == 'Maggie':
> for row in rows:
> return [row.age+' '+row.location+' '+row.occupation+'
> '+row.interests]
>
> The problem is that if I query 'Carl' which is the first item, I get
> the response but I cant query any other name .
> Regards
>
>
>
> --
> 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 a topic in the
> Google Groups "web2py-users" group.
> To unsubscribe from this topic, visit https://groups.google.
> com/d/topic/web2py/ynBOuIdufso/unsubscribe.
> To unsubscribe from this group and all its topics, send an email to
> web2py+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
> I had been using python isle to test some modules. Now I just want to
> get a clearer code by removing the long codes.
>
>
> On Mon, 30 Apr 2018, 20:09 Richard Vézina 
> wrote:
>
>> Man this is convulated...
>>
>> Not sure what is in name4 "name4 is a list that contains items found
>> in db.health.name, as well as other dbs." what items are you
>> referring at?? What other dbs?
>>
>> Why are you connecting to sqlite by your own...
>>
>> This check is just weird :
>>
>> if id == item in name4:
>>
>> I would suggest you don't use function to achieve what you try to do
>> it just make it overcomplicated... Also never 

Re: [web2py] DAL return all Fields

[Maurice Waka]

Thanks.
It iterates well giving some fields data, but not all as needed. I get data
from some 4 fields only. I have about 60 in some db. Plus there is this:


On Tue, 1 May 2018, 16:44 Richard Vézina 
wrote:

> for f, v in row:
>
> Should be
>
> for f, v in row.iteritems():
>
> k, v for key, value, but I use f instead of k because you will have
> field_name and value in this for loop...
>
> Richard
>
> On Mon, Apr 30, 2018 at 11:39 PM, Maurice Waka 
> wrote:
>
>> What would f, v be.
>> I get this error : ValueError : too many values to unpack
>>
>> On Mon, 30 Apr 2018, 20:38 Richard Vézina 
>> wrote:
>>
>>>
>>>
>>> On Mon, Apr 30, 2018 at 1:21 PM, Maurice Waka 
>>> wrote:
>>>
 Sorry I tried to clarify by my new question :

 If I have a column with data like db.persons with data like
 Carl
 Junior
 Maggie
 Tom
 Derrick

 And each column name has other fields with data such as:
 persons.name persons.age persons.location persons.occupation
 persons.interests
 Carl 23 London Neuroscientist brainy stuff
 Junior 25 Tokyo doctor medical research
 Maggie 33 Nairobi farmer GMO research
 Tom 25 Sydney teacher educational ideas
 Derrick 21 Chicago surgeon Cutting through



 I want to iterate through the column  persons.nameand randomly pick a
 name and using the rows object, display all data about the person.

 If I do
 rows_name = db().select(db.persons.name).column()

>>>
>>>
>>> The above should be :
>>>
>>> fields = db.persons.fields
>>> # You should have in fields a list of all fields names you migth want to
>>> remove "id" field by filtering it or find index and pop it out of the list
>>> # ex.: fields.pop(fields.index('id'))
>>>
>>>
>>>


 rows = db(db.persons.ALL).select()

>>>
>>> db(where_clause).select(fields_name_separated_by_comma)
>>>
>>> The above is completly wrong as you pass the fields instead of
>>> specifying your where clause parameter...
>>>
>>> In you example you really only need select like this :
>>>
>>> def some_func_name()
>>> rows = db(db.persons.id > 0).select(db.persons.ALL)
>>>
>>> rows_values = []
>>> for row in rows:
>>> row_value = []
>>> for f, v in row:
>>> if f != 'id':
>>> row_value.append(v)
>>> rows_values.append(row_value)
>>> return rows_values
>>>
>>> ret = some_func_name()
>>>
>>> for r in ret:
>>> print(' '.join(ret))
>>>
>>> I didn't tested it but the above should work...
>>>
>>> Good luck
>>>

 for row in rows:
 if rows_name[0] == 'Maggie':
 for row in rows:
 return [row.age+' '+row.location+' '+row.occupation+' '
 +row.interests]

 The problem is that if I query 'Carl' which is the first item, I get
 the response but I cant query any other name .
 Regards



 --
 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 a topic in the
 Google Groups "web2py-users" group.
 To unsubscribe from this topic, visit
 https://groups.google.com/d/topic/web2py/ynBOuIdufso/unsubscribe.
 To unsubscribe from this group and all its topics, send an email to
 web2py+unsubscr...@googlegroups.com.
 For more options, visit https://groups.google.com/d/optout.
 I had been using python isle to test some modules. Now I just want to
 get a clearer code by removing the long codes.


 On Mon, 30 Apr 2018, 20:09 Richard Vézina 
 wrote:

> Man this is convulated...
>
> Not sure what is in name4 "name4 is a list that contains items found
> in db.health.name, as well as other dbs." what items are you
> referring at?? What other dbs?
>
> Why are you connecting to sqlite by your own...
>
> This check is just weird :
>
> if id == item in name4:
>
> I would suggest you don't use function to achieve what you try to do
> it just make it overcomplicated... Also never define functions in models
> files it will slow down your app as models files are executed at each
> request.
>
> My guess is that if you end with the final list that you showed us is
> because at some point you put the name of the fields you want instead of
> the value attached to them...
>
> But seriously it very difficult to help...
>
> You could show us all the models that are important to the problem and
> show us an example of what you want at the end.
>
>
> I also don't know from you field name in health table what they
> content.
>
> So for 

Re: [web2py] DAL return all Fields

[Richard Vézina]

for f, v in row:

Should be

for f, v in row.iteritems():

k, v for key, value, but I use f instead of k because you will have
field_name and value in this for loop...

Richard

On Mon, Apr 30, 2018 at 11:39 PM, Maurice Waka 
wrote:

> What would f, v be.
> I get this error : ValueError : too many values to unpack
>
> On Mon, 30 Apr 2018, 20:38 Richard Vézina 
> wrote:
>
>>
>>
>> On Mon, Apr 30, 2018 at 1:21 PM, Maurice Waka 
>> wrote:
>>
>>> Sorry I tried to clarify by my new question :
>>>
>>> If I have a column with data like db.persons with data like
>>> Carl
>>> Junior
>>> Maggie
>>> Tom
>>> Derrick
>>>
>>> And each column name has other fields with data such as:
>>> persons.name persons.age persons.location persons.occupation
>>> persons.interests
>>> Carl 23 London Neuroscientist brainy stuff
>>> Junior 25 Tokyo doctor medical research
>>> Maggie 33 Nairobi farmer GMO research
>>> Tom 25 Sydney teacher educational ideas
>>> Derrick 21 Chicago surgeon Cutting through
>>>
>>>
>>>
>>> I want to iterate through the column  persons.nameand randomly pick a
>>> name and using the rows object, display all data about the person.
>>>
>>> If I do
>>> rows_name = db().select(db.persons.name).column()
>>>
>>
>>
>> The above should be :
>>
>> fields = db.persons.fields
>> # You should have in fields a list of all fields names you migth want to
>> remove "id" field by filtering it or find index and pop it out of the list
>> # ex.: fields.pop(fields.index('id'))
>>
>>
>>
>>>
>>>
>>> rows = db(db.persons.ALL).select()
>>>
>>
>> db(where_clause).select(fields_name_separated_by_comma)
>>
>> The above is completly wrong as you pass the fields instead of specifying
>> your where clause parameter...
>>
>> In you example you really only need select like this :
>>
>> def some_func_name()
>> rows = db(db.persons.id > 0).select(db.persons.ALL)
>>
>> rows_values = []
>> for row in rows:
>> row_value = []
>> for f, v in row:
>> if f != 'id':
>> row_value.append(v)
>> rows_values.append(row_value)
>> return rows_values
>>
>> ret = some_func_name()
>>
>> for r in ret:
>> print(' '.join(ret))
>>
>> I didn't tested it but the above should work...
>>
>> Good luck
>>
>>>
>>> for row in rows:
>>> if rows_name[0] == 'Maggie':
>>> for row in rows:
>>> return [row.age+' '+row.location+' '+row.occupation+' '+
>>> row.interests]
>>>
>>> The problem is that if I query 'Carl' which is the first item, I get the
>>> response but I cant query any other name .
>>> Regards
>>>
>>>
>>>
>>> --
>>> 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 a topic in the
>>> Google Groups "web2py-users" group.
>>> To unsubscribe from this topic, visit https://groups.google.
>>> com/d/topic/web2py/ynBOuIdufso/unsubscribe.
>>> To unsubscribe from this group and all its topics, send an email to
>>> web2py+unsubscr...@googlegroups.com.
>>> For more options, visit https://groups.google.com/d/optout.
>>> I had been using python isle to test some modules. Now I just want to
>>> get a clearer code by removing the long codes.
>>>
>>>
>>> On Mon, 30 Apr 2018, 20:09 Richard Vézina 
>>> wrote:
>>>
 Man this is convulated...

 Not sure what is in name4 "name4 is a list that contains items found in
 db.health.name, as well as other dbs." what items are you referring
 at?? What other dbs?

 Why are you connecting to sqlite by your own...

 This check is just weird :

 if id == item in name4:

 I would suggest you don't use function to achieve what you try to do it
 just make it overcomplicated... Also never define functions in models files
 it will slow down your app as models files are executed at each request.

 My guess is that if you end with the final list that you showed us is
 because at some point you put the name of the fields you want instead of
 the value attached to them...

 But seriously it very difficult to help...

 You could show us all the models that are important to the problem and
 show us an example of what you want at the end.


 I also don't know from you field name in health table what they content.

 So for example let say


 You have a table name fruit

 rows = db(db.fruit.id > 0).select(db.fruit.ALL)

 With a fruit_name field

 for r in rows:
 print('A {0} is a fruit blah blah blah. A {0} when its green is
 bitter to taste. A {0} when ripe looks bright yellow and tastes
 sweet.'.format(r.fruit_name)

 That's it!!

 Richard


 On Sat, Apr 

Re: [web2py] DAL return all Fields

[Maurice Waka]

What would f, v be.
I get this error : ValueError : too many values to unpack

On Mon, 30 Apr 2018, 20:38 Richard Vézina 
wrote:

>
>
> On Mon, Apr 30, 2018 at 1:21 PM, Maurice Waka 
> wrote:
>
>> Sorry I tried to clarify by my new question :
>>
>> If I have a column with data like db.persons with data like
>> Carl
>> Junior
>> Maggie
>> Tom
>> Derrick
>>
>> And each column name has other fields with data such as:
>> persons.name persons.age persons.location persons.occupation
>> persons.interests
>> Carl 23 London Neuroscientist brainy stuff
>> Junior 25 Tokyo doctor medical research
>> Maggie 33 Nairobi farmer GMO research
>> Tom 25 Sydney teacher educational ideas
>> Derrick 21 Chicago surgeon Cutting through
>>
>>
>>
>> I want to iterate through the column  persons.nameand randomly pick a
>> name and using the rows object, display all data about the person.
>>
>> If I do
>> rows_name = db().select(db.persons.name).column()
>>
>
>
> The above should be :
>
> fields = db.persons.fields
> # You should have in fields a list of all fields names you migth want to
> remove "id" field by filtering it or find index and pop it out of the list
> # ex.: fields.pop(fields.index('id'))
>
>
>
>>
>>
>> rows = db(db.persons.ALL).select()
>>
>
> db(where_clause).select(fields_name_separated_by_comma)
>
> The above is completly wrong as you pass the fields instead of specifying
> your where clause parameter...
>
> In you example you really only need select like this :
>
> def some_func_name()
> rows = db(db.persons.id > 0).select(db.persons.ALL)
>
> rows_values = []
> for row in rows:
> row_value = []
> for f, v in row:
> if f != 'id':
> row_value.append(v)
> rows_values.append(row_value)
> return rows_values
>
> ret = some_func_name()
>
> for r in ret:
> print(' '.join(ret))
>
> I didn't tested it but the above should work...
>
> Good luck
>
>>
>> for row in rows:
>> if rows_name[0] == 'Maggie':
>> for row in rows:
>> return [row.age+' '+row.location+' '+row.occupation+' '+
>> row.interests]
>>
>> The problem is that if I query 'Carl' which is the first item, I get the
>> response but I cant query any other name .
>> Regards
>>
>>
>>
>> --
>> 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 a topic in the
>> Google Groups "web2py-users" group.
>> To unsubscribe from this topic, visit
>> https://groups.google.com/d/topic/web2py/ynBOuIdufso/unsubscribe.
>> To unsubscribe from this group and all its topics, send an email to
>> web2py+unsubscr...@googlegroups.com.
>> For more options, visit https://groups.google.com/d/optout.
>> I had been using python isle to test some modules. Now I just want to get
>> a clearer code by removing the long codes.
>>
>>
>> On Mon, 30 Apr 2018, 20:09 Richard Vézina 
>> wrote:
>>
>>> Man this is convulated...
>>>
>>> Not sure what is in name4 "name4 is a list that contains items found in
>>> db.health.name, as well as other dbs." what items are you referring
>>> at?? What other dbs?
>>>
>>> Why are you connecting to sqlite by your own...
>>>
>>> This check is just weird :
>>>
>>> if id == item in name4:
>>>
>>> I would suggest you don't use function to achieve what you try to do it
>>> just make it overcomplicated... Also never define functions in models files
>>> it will slow down your app as models files are executed at each request.
>>>
>>> My guess is that if you end with the final list that you showed us is
>>> because at some point you put the name of the fields you want instead of
>>> the value attached to them...
>>>
>>> But seriously it very difficult to help...
>>>
>>> You could show us all the models that are important to the problem and
>>> show us an example of what you want at the end.
>>>
>>>
>>> I also don't know from you field name in health table what they content.
>>>
>>> So for example let say
>>>
>>>
>>> You have a table name fruit
>>>
>>> rows = db(db.fruit.id > 0).select(db.fruit.ALL)
>>>
>>> With a fruit_name field
>>>
>>> for r in rows:
>>> print('A {0} is a fruit blah blah blah. A {0} when its green is
>>> bitter to taste. A {0} when ripe looks bright yellow and tastes
>>> sweet.'.format(r.fruit_name)
>>>
>>> That's it!!
>>>
>>> Richard
>>>
>>>
>>> On Sat, Apr 28, 2018 at 11:02 AM, Maurice Waka 
>>> wrote:
>>>
 Thanks, but I seem to be having a challenge when returning the rows
 from a specific id name or number. I tried this on a different app as
 follows:

 Model:

 db.define_table( "health",
 Field('name', 'string'),
 Field('definition', 'text', length= 100,
 default="We'll 

Re: [web2py] DAL return all Fields

[Maurice Waka]

Thank you. Let me work on it.
Regards

On Mon, 30 Apr 2018, 20:38 Richard Vézina 
wrote:

>
>
> On Mon, Apr 30, 2018 at 1:21 PM, Maurice Waka 
> wrote:
>
>> Sorry I tried to clarify by my new question :
>>
>> If I have a column with data like db.persons with data like
>> Carl
>> Junior
>> Maggie
>> Tom
>> Derrick
>>
>> And each column name has other fields with data such as:
>> persons.name persons.age persons.location persons.occupation
>> persons.interests
>> Carl 23 London Neuroscientist brainy stuff
>> Junior 25 Tokyo doctor medical research
>> Maggie 33 Nairobi farmer GMO research
>> Tom 25 Sydney teacher educational ideas
>> Derrick 21 Chicago surgeon Cutting through
>>
>>
>>
>> I want to iterate through the column  persons.nameand randomly pick a
>> name and using the rows object, display all data about the person.
>>
>> If I do
>> rows_name = db().select(db.persons.name).column()
>>
>
>
> The above should be :
>
> fields = db.persons.fields
> # You should have in fields a list of all fields names you migth want to
> remove "id" field by filtering it or find index and pop it out of the list
> # ex.: fields.pop(fields.index('id'))
>
>
>
>>
>>
>> rows = db(db.persons.ALL).select()
>>
>
> db(where_clause).select(fields_name_separated_by_comma)
>
> The above is completly wrong as you pass the fields instead of specifying
> your where clause parameter...
>
> In you example you really only need select like this :
>
> def some_func_name()
> rows = db(db.persons.id > 0).select(db.persons.ALL)
>
> rows_values = []
> for row in rows:
> row_value = []
> for f, v in row:
> if f != 'id':
> row_value.append(v)
> rows_values.append(row_value)
> return rows_values
>
> ret = some_func_name()
>
> for r in ret:
> print(' '.join(ret))
>
> I didn't tested it but the above should work...
>
> Good luck
>
>>
>> for row in rows:
>> if rows_name[0] == 'Maggie':
>> for row in rows:
>> return [row.age+' '+row.location+' '+row.occupation+' '+
>> row.interests]
>>
>> The problem is that if I query 'Carl' which is the first item, I get the
>> response but I cant query any other name .
>> Regards
>>
>>
>>
>> --
>> 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 a topic in the
>> Google Groups "web2py-users" group.
>> To unsubscribe from this topic, visit
>> https://groups.google.com/d/topic/web2py/ynBOuIdufso/unsubscribe.
>> To unsubscribe from this group and all its topics, send an email to
>> web2py+unsubscr...@googlegroups.com.
>> For more options, visit https://groups.google.com/d/optout.
>> I had been using python isle to test some modules. Now I just want to get
>> a clearer code by removing the long codes.
>>
>>
>> On Mon, 30 Apr 2018, 20:09 Richard Vézina 
>> wrote:
>>
>>> Man this is convulated...
>>>
>>> Not sure what is in name4 "name4 is a list that contains items found in
>>> db.health.name, as well as other dbs." what items are you referring
>>> at?? What other dbs?
>>>
>>> Why are you connecting to sqlite by your own...
>>>
>>> This check is just weird :
>>>
>>> if id == item in name4:
>>>
>>> I would suggest you don't use function to achieve what you try to do it
>>> just make it overcomplicated... Also never define functions in models files
>>> it will slow down your app as models files are executed at each request.
>>>
>>> My guess is that if you end with the final list that you showed us is
>>> because at some point you put the name of the fields you want instead of
>>> the value attached to them...
>>>
>>> But seriously it very difficult to help...
>>>
>>> You could show us all the models that are important to the problem and
>>> show us an example of what you want at the end.
>>>
>>>
>>> I also don't know from you field name in health table what they content.
>>>
>>> So for example let say
>>>
>>>
>>> You have a table name fruit
>>>
>>> rows = db(db.fruit.id > 0).select(db.fruit.ALL)
>>>
>>> With a fruit_name field
>>>
>>> for r in rows:
>>> print('A {0} is a fruit blah blah blah. A {0} when its green is
>>> bitter to taste. A {0} when ripe looks bright yellow and tastes
>>> sweet.'.format(r.fruit_name)
>>>
>>> That's it!!
>>>
>>> Richard
>>>
>>>
>>> On Sat, Apr 28, 2018 at 11:02 AM, Maurice Waka 
>>> wrote:
>>>
 Thanks, but I seem to be having a challenge when returning the rows
 from a specific id name or number. I tried this on a different app as
 follows:

 Model:

 db.define_table( "health",
 Field('name', 'string'),
 Field('definition', 'text', length= 100,
 default="We'll update soon.", notnull=True),
   

Re: [web2py] DAL return all Fields

[Richard Vézina]

On Mon, Apr 30, 2018 at 1:21 PM, Maurice Waka  wrote:

> Sorry I tried to clarify by my new question :
>
> If I have a column with data like db.persons with data like
> Carl
> Junior
> Maggie
> Tom
> Derrick
>
> And each column name has other fields with data such as:
> persons.name persons.age persons.location persons.occupation
> persons.interests
> Carl 23 London Neuroscientist brainy stuff
> Junior 25 Tokyo doctor medical research
> Maggie 33 Nairobi farmer GMO research
> Tom 25 Sydney teacher educational ideas
> Derrick 21 Chicago surgeon Cutting through
>
>
>
> I want to iterate through the column  persons.nameand randomly pick a
> name and using the rows object, display all data about the person.
>
> If I do
> rows_name = db().select(db.persons.name).column()
>


The above should be :

fields = db.persons.fields
# You should have in fields a list of all fields names you migth want to
remove "id" field by filtering it or find index and pop it out of the list
# ex.: fields.pop(fields.index('id'))



>
>
> rows = db(db.persons.ALL).select()
>

db(where_clause).select(fields_name_separated_by_comma)

The above is completly wrong as you pass the fields instead of specifying
your where clause parameter...

In you example you really only need select like this :

def some_func_name()
rows = db(db.persons.id > 0).select(db.persons.ALL)

rows_values = []
for row in rows:
row_value = []
for f, v in row:
if f != 'id':
row_value.append(v)
rows_values.append(row_value)
return rows_values

ret = some_func_name()

for r in ret:
print(' '.join(ret))

I didn't tested it but the above should work...

Good luck

>
> for row in rows:
> if rows_name[0] == 'Maggie':
> for row in rows:
> return [row.age+' '+row.location+' '+row.occupation+' '+
> row.interests]
>
> The problem is that if I query 'Carl' which is the first item, I get the
> response but I cant query any other name .
> Regards
>
>
>
> --
> 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 a topic in the
> Google Groups "web2py-users" group.
> To unsubscribe from this topic, visit https://groups.google.
> com/d/topic/web2py/ynBOuIdufso/unsubscribe.
> To unsubscribe from this group and all its topics, send an email to
> web2py+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
> I had been using python isle to test some modules. Now I just want to get
> a clearer code by removing the long codes.
>
>
> On Mon, 30 Apr 2018, 20:09 Richard Vézina 
> wrote:
>
>> Man this is convulated...
>>
>> Not sure what is in name4 "name4 is a list that contains items found in
>> db.health.name, as well as other dbs." what items are you referring at??
>> What other dbs?
>>
>> Why are you connecting to sqlite by your own...
>>
>> This check is just weird :
>>
>> if id == item in name4:
>>
>> I would suggest you don't use function to achieve what you try to do it
>> just make it overcomplicated... Also never define functions in models files
>> it will slow down your app as models files are executed at each request.
>>
>> My guess is that if you end with the final list that you showed us is
>> because at some point you put the name of the fields you want instead of
>> the value attached to them...
>>
>> But seriously it very difficult to help...
>>
>> You could show us all the models that are important to the problem and
>> show us an example of what you want at the end.
>>
>>
>> I also don't know from you field name in health table what they content.
>>
>> So for example let say
>>
>>
>> You have a table name fruit
>>
>> rows = db(db.fruit.id > 0).select(db.fruit.ALL)
>>
>> With a fruit_name field
>>
>> for r in rows:
>> print('A {0} is a fruit blah blah blah. A {0} when its green is
>> bitter to taste. A {0} when ripe looks bright yellow and tastes
>> sweet.'.format(r.fruit_name)
>>
>> That's it!!
>>
>> Richard
>>
>>
>> On Sat, Apr 28, 2018 at 11:02 AM, Maurice Waka 
>> wrote:
>>
>>> Thanks, but I seem to be having a challenge when returning the rows from
>>> a specific id name or number. I tried this on a different app as follows:
>>>
>>> Model:
>>>
>>> db.define_table( "health",
>>> Field('name', 'string'),
>>> Field('definition', 'text', length= 100,
>>> default="We'll update soon.", notnull=True),
>>> Field('abnvals', 'text', length= 100,default="We'll
>>> update soon.", notnull=True),
>>> Field('normvals', 'text', length= 100,default="We'll
>>> update soon.", notnull=True),
>>> def selections():
>>> code
>>> return name4# name4 is a list that contains items found in
>>> 

Re: [web2py] DAL return all Fields

[Maurice Waka]

Sorry I tried to clarify by my new question :

If I have a column with data like db.persons with data like
Carl
Junior
Maggie
Tom
Derrick

And each column name has other fields with data such as:
persons.name persons.age persons.location persons.occupation
persons.interests
Carl 23 London Neuroscientist brainy stuff
Junior 25 Tokyo doctor medical research
Maggie 33 Nairobi farmer GMO research
Tom 25 Sydney teacher educational ideas
Derrick 21 Chicago surgeon Cutting through



I want to iterate through the column  persons.nameand randomly pick a name
and using the rows object, display all data about the person.

If I do
rows_name = db().select(db.persons.name).column()

rows = db(db.persons.ALL).select()
for row in rows:
if rows_name[0] == 'Maggie':
for row in rows:
return [row.age+' '+row.location+' '+row.occupation+' '+row.
interests]

The problem is that if I query 'Carl' which is the first item, I get the
response but I cant query any other name .
Regards



-- 
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 a topic in the
Google Groups "web2py-users" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/web2py/ynBOuIdufso/unsubscribe.
To unsubscribe from this group and all its topics, send an email to
web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
I had been using python isle to test some modules. Now I just want to get a
clearer code by removing the long codes.


On Mon, 30 Apr 2018, 20:09 Richard Vézina 
wrote:

> Man this is convulated...
>
> Not sure what is in name4 "name4 is a list that contains items found in
> db.health.name, as well as other dbs." what items are you referring at??
> What other dbs?
>
> Why are you connecting to sqlite by your own...
>
> This check is just weird :
>
> if id == item in name4:
>
> I would suggest you don't use function to achieve what you try to do it
> just make it overcomplicated... Also never define functions in models files
> it will slow down your app as models files are executed at each request.
>
> My guess is that if you end with the final list that you showed us is
> because at some point you put the name of the fields you want instead of
> the value attached to them...
>
> But seriously it very difficult to help...
>
> You could show us all the models that are important to the problem and
> show us an example of what you want at the end.
>
>
> I also don't know from you field name in health table what they content.
>
> So for example let say
>
>
> You have a table name fruit
>
> rows = db(db.fruit.id > 0).select(db.fruit.ALL)
>
> With a fruit_name field
>
> for r in rows:
> print('A {0} is a fruit blah blah blah. A {0} when its green is
> bitter to taste. A {0} when ripe looks bright yellow and tastes
> sweet.'.format(r.fruit_name)
>
> That's it!!
>
> Richard
>
>
> On Sat, Apr 28, 2018 at 11:02 AM, Maurice Waka 
> wrote:
>
>> Thanks, but I seem to be having a challenge when returning the rows from
>> a specific id name or number. I tried this on a different app as follows:
>>
>> Model:
>>
>> db.define_table( "health",
>> Field('name', 'string'),
>> Field('definition', 'text', length= 100,
>> default="We'll update soon.", notnull=True),
>> Field('abnvals', 'text', length= 100,default="We'll
>> update soon.", notnull=True),
>> Field('normvals', 'text', length= 100,default="We'll
>> update soon.", notnull=True),
>> def selections():
>> code
>> return name4# name4 is a list that contains items found in db.health.name,
>> as well as other dbs.
>>  def refer11():
>> db = current.db
>> rows = db(db.health).iterselect()
>> for row in rows:
>> id = row.name
>> if id == item in name4:
>> #return [', '.join(item) for item in rows]# Gives a list of the titles
>> only as: ['name','definition','abnvals','normvals',]
>> #return [item for item in rows]# Gives this:
>> [
>> #return row# gives this : 
>> #return [item for item in row]# Gives a list of
>> the titles only as: ['name','definition','abnvals','normvals',]
>>
>> When using sql speak, this works well:
>> def refer11():
>> id = 0
>> location = ""
>> conn = sqlite3.connect('wellness.db')
>> c = conn.cursor()
>> c.execute('select * from health')
>> records = c.fetchall()
>> for record in records:
>> id = record[1]
>> for item in name4:
>> if id == item in name4:
>> return record[2:]
>>
>> If row.name has e.g. apple, mango, guava, pineapple, then
>>
>> and the fields contain info about the fruits e.g.
>>
>> if id/row.name picks mango, i want a list of these:
>>
>> definition data: A mango 

Re: [web2py] DAL return all Fields

[Richard Vézina]

Man this is convulated...

Not sure what is in name4 "name4 is a list that contains items found in
db.health.name, as well as other dbs." what items are you referring at??
What other dbs?

Why are you connecting to sqlite by your own...

This check is just weird :

if id == item in name4:

I would suggest you don't use function to achieve what you try to do it
just make it overcomplicated... Also never define functions in models files
it will slow down your app as models files are executed at each request.

My guess is that if you end with the final list that you showed us is
because at some point you put the name of the fields you want instead of
the value attached to them...

But seriously it very difficult to help...

You could show us all the models that are important to the problem and show
us an example of what you want at the end.


I also don't know from you field name in health table what they content.

So for example let say


You have a table name fruit

rows = db(db.fruit.id > 0).select(db.fruit.ALL)

With a fruit_name field

for r in rows:
print('A {0} is a fruit blah blah blah. A {0} when its green is bitter
to taste. A {0} when ripe looks bright yellow and tastes
sweet.'.format(r.fruit_name)

That's it!!

Richard


On Sat, Apr 28, 2018 at 11:02 AM, Maurice Waka 
wrote:

> Thanks, but I seem to be having a challenge when returning the rows from a
> specific id name or number. I tried this on a different app as follows:
>
> Model:
>
> db.define_table( "health",
> Field('name', 'string'),
> Field('definition', 'text', length= 100,
> default="We'll update soon.", notnull=True),
> Field('abnvals', 'text', length= 100,default="We'll
> update soon.", notnull=True),
> Field('normvals', 'text', length= 100,default="We'll
> update soon.", notnull=True),
> def selections():
> code
> return name4# name4 is a list that contains items found in db.health.name,
> as well as other dbs.
>  def refer11():
> db = current.db
> rows = db(db.health).iterselect()
> for row in rows:
> id = row.name
> if id == item in name4:
> #return [', '.join(item) for item in rows]# Gives a list of the titles
> only as: ['name','definition','abnvals','normvals',]
> #return [item for item in rows]# Gives this: [
> #return row# gives this : 
> #return [item for item in row]# Gives a list of
> the titles only as: ['name','definition','abnvals','normvals',]
>
> When using sql speak, this works well:
> def refer11():
> id = 0
> location = ""
> conn = sqlite3.connect('wellness.db')
> c = conn.cursor()
> c.execute('select * from health')
> records = c.fetchall()
> for record in records:
> id = record[1]
> for item in name4:
> if id == item in name4:
> return record[2:]
>
> If row.name has e.g. apple, mango, guava, pineapple, then
>
> and the fields contain info about the fruits e.g.
>
> if id/row.name picks mango, i want a list of these:
>
> definition data: A mango is a fruit blah blah blah.
> abnvals data: A mango when its green is bitter to taste.
> normvals data: A mango when ripe looks bright yellow and tastes sweet.
>
> so when doing return row
> I should get ['A mango is a fruit blah blah blah. A mango when its green
> is bitter to taste. A mango when ripe looks bright yellow and tastes
> sweet.]
> and not
> ['name','definition','abnvals','normvals',]
>
> On Fri, Apr 27, 2018 at 6:16 PM, Richard Vézina <
> ml.richard.vez...@gmail.com> wrote:
>
>> for f in db.table.fields:
>> print f
>>
>> or
>>
>> rows = db(db.fruits.id > 0).select(db.fruits.ALL)  # ALL means all fields
>>
>> for r in rows:
>> print(r)
>>
>> You can control which field you want with the previous example
>>
>> myfields = [f for f in db.table.fields if SOME_FILTERING_CHECK_OVER_THE_
>> FIELD_YOU_WANT]
>>
>>
>> for r in rows:
>> for f in myfields:
>> print(r[f])
>>
>>
>> You can play around that you should be able to figure out how you can do
>> what you wanna do.
>>
>> Richard
>>
>> On Fri, Apr 27, 2018 at 10:08 AM, Maurice Waka 
>> wrote:
>>
>>> Addendum
>>>
>>> I want a single list of  the items (the data from all fields)
>>>
>>> regards
>>>
>>> On Fri, Apr 27, 2018 at 5:06 PM, Maurice Waka 
>>> wrote:
>>>
 There are several fields in my db such as this:

 db.define_table('fruit', Field('id', 'reference auth_user'), 
 Field('apple','boolean',label=T('Apple')), 
 Field('apricot','boolean',label=T('Apricot')), 
 Field('cherry','boolean',label=T('Cherry')), Field('fig','boolean', 
 label=T('Fig')), Field('lychee','boolean', label=T('Lychee')), 
 Field('peach','boolean', label=T('Peach')), Field('pear','boolean', 
 label=T('Pear')), Field('plum','boolean', label=T('Plum')))
 If i want to print items from a specific field i would do:

 rows = 

Re: [web2py] DAL return all Fields

[Maurice Waka]

Thanks, but I seem to be having a challenge when returning the rows from a
specific id name or number. I tried this on a different app as follows:

Model:

db.define_table( "health",
Field('name', 'string'),
Field('definition', 'text', length= 100, default="We'll
update soon.", notnull=True),
Field('abnvals', 'text', length= 100,default="We'll
update soon.", notnull=True),
Field('normvals', 'text', length= 100,default="We'll
update soon.", notnull=True),
def selections():
code
return name4# name4 is a list that contains items found in db.health.name,
as well as other dbs.
 def refer11():
db = current.db
rows = db(db.health).iterselect()
for row in rows:
id = row.name
if id == item in name4:
#return [', '.join(item) for item in rows]# Gives a list of the titles only
as: ['name','definition','abnvals','normvals',]
#return [item for item in rows]# Gives this: [
#return row# gives this : 
#return [item for item in row]# Gives a list of the
titles only as: ['name','definition','abnvals','normvals',]

When using sql speak, this works well:
def refer11():
id = 0
location = ""
conn = sqlite3.connect('wellness.db')
c = conn.cursor()
c.execute('select * from health')
records = c.fetchall()
for record in records:
id = record[1]
for item in name4:
if id == item in name4:
return record[2:]

If row.name has e.g. apple, mango, guava, pineapple, then

and the fields contain info about the fruits e.g.

if id/row.name picks mango, i want a list of these:

definition data: A mango is a fruit blah blah blah.
abnvals data: A mango when its green is bitter to taste.
normvals data: A mango when ripe looks bright yellow and tastes sweet.

so when doing return row
I should get ['A mango is a fruit blah blah blah. A mango when its green is
bitter to taste. A mango when ripe looks bright yellow and tastes sweet.]
and not
['name','definition','abnvals','normvals',]

On Fri, Apr 27, 2018 at 6:16 PM, Richard Vézina  wrote:

> for f in db.table.fields:
> print f
>
> or
>
> rows = db(db.fruits.id > 0).select(db.fruits.ALL)  # ALL means all fields
>
> for r in rows:
> print(r)
>
> You can control which field you want with the previous example
>
> myfields = [f for f in db.table.fields if SOME_FILTERING_CHECK_OVER_THE_
> FIELD_YOU_WANT]
>
>
> for r in rows:
> for f in myfields:
> print(r[f])
>
>
> You can play around that you should be able to figure out how you can do
> what you wanna do.
>
> Richard
>
> On Fri, Apr 27, 2018 at 10:08 AM, Maurice Waka 
> wrote:
>
>> Addendum
>>
>> I want a single list of  the items (the data from all fields)
>>
>> regards
>>
>> On Fri, Apr 27, 2018 at 5:06 PM, Maurice Waka 
>> wrote:
>>
>>> There are several fields in my db such as this:
>>>
>>> db.define_table('fruit', Field('id', 'reference auth_user'), 
>>> Field('apple','boolean',label=T('Apple')), 
>>> Field('apricot','boolean',label=T('Apricot')), 
>>> Field('cherry','boolean',label=T('Cherry')), Field('fig','boolean', 
>>> label=T('Fig')), Field('lychee','boolean', label=T('Lychee')), 
>>> Field('peach','boolean', label=T('Peach')), Field('pear','boolean', 
>>> label=T('Pear')), Field('plum','boolean', label=T('Plum')))
>>> If i want to print items from a specific field i would do:
>>>
>>> rows = db(db.fruits)select()for row in rows:
>>>  return row.apple
>>>
>>>
>>> Now I want to return all data from all fields. How Can i go about it.
>>>
>>> I have tried:
>>>
>>> return rows and I get a blank screen.
>>>
>>> return [rows] and I get [].
>>>
>>> Kind regards
>>>
>>> --
>>> 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 a topic in the
>>> Google Groups "web2py-users" group.
>>> To unsubscribe from this topic, visit https://groups.google.com/d/to
>>> pic/web2py/-Hlx1yh-4MU/unsubscribe.
>>> To unsubscribe from this group and all its topics, send an email to
>>> web2py+unsubscr...@googlegroups.com.
>>> For more options, visit https://groups.google.com/d/optout.
>>>
>>
>> --
>> 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 web2py+unsubscr...@googlegroups.com.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
> --
> Resources:
> - http://web2py.com
> - http://web2py.com/book (Documentation)
> - 

Re: [web2py] DAL return all Fields

[Richard Vézina]

for f in db.table.fields:
print f

or

rows = db(db.fruits.id > 0).select(db.fruits.ALL)  # ALL means all fields

for r in rows:
print(r)

You can control which field you want with the previous example

myfields = [f for f in db.table.fields if
SOME_FILTERING_CHECK_OVER_THE_FIELD_YOU_WANT]


for r in rows:
for f in myfields:
print(r[f])


You can play around that you should be able to figure out how you can do
what you wanna do.

Richard

On Fri, Apr 27, 2018 at 10:08 AM, Maurice Waka 
wrote:

> Addendum
>
> I want a single list of  the items (the data from all fields)
>
> regards
>
> On Fri, Apr 27, 2018 at 5:06 PM, Maurice Waka 
> wrote:
>
>> There are several fields in my db such as this:
>>
>> db.define_table('fruit', Field('id', 'reference auth_user'), 
>> Field('apple','boolean',label=T('Apple')), 
>> Field('apricot','boolean',label=T('Apricot')), 
>> Field('cherry','boolean',label=T('Cherry')), Field('fig','boolean', 
>> label=T('Fig')), Field('lychee','boolean', label=T('Lychee')), 
>> Field('peach','boolean', label=T('Peach')), Field('pear','boolean', 
>> label=T('Pear')), Field('plum','boolean', label=T('Plum')))
>> If i want to print items from a specific field i would do:
>>
>> rows = db(db.fruits)select()for row in rows:
>>  return row.apple
>>
>>
>> Now I want to return all data from all fields. How Can i go about it.
>>
>> I have tried:
>>
>> return rows and I get a blank screen.
>>
>> return [rows] and I get [].
>>
>> Kind regards
>>
>> --
>> 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 a topic in the
>> Google Groups "web2py-users" group.
>> To unsubscribe from this topic, visit https://groups.google.com/d/to
>> pic/web2py/-Hlx1yh-4MU/unsubscribe.
>> To unsubscribe from this group and all its topics, send an email to
>> web2py+unsubscr...@googlegroups.com.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
> --
> 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 web2py+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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 web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [web2py] DAL return all Fields

[Maurice Waka]

Addendum

I want a single list of  the items (the data from all fields)

regards

On Fri, Apr 27, 2018 at 5:06 PM, Maurice Waka  wrote:

> There are several fields in my db such as this:
>
> db.define_table('fruit', Field('id', 'reference auth_user'), 
> Field('apple','boolean',label=T('Apple')), 
> Field('apricot','boolean',label=T('Apricot')), 
> Field('cherry','boolean',label=T('Cherry')), Field('fig','boolean', 
> label=T('Fig')), Field('lychee','boolean', label=T('Lychee')), 
> Field('peach','boolean', label=T('Peach')), Field('pear','boolean', 
> label=T('Pear')), Field('plum','boolean', label=T('Plum')))
> If i want to print items from a specific field i would do:
>
> rows = db(db.fruits)select()for row in rows:
>  return row.apple
>
>
> Now I want to return all data from all fields. How Can i go about it.
>
> I have tried:
>
> return rows and I get a blank screen.
>
> return [rows] and I get [].
>
> Kind regards
>
> --
> 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 a topic in the
> Google Groups "web2py-users" group.
> To unsubscribe from this topic, visit https://groups.google.com/d/
> topic/web2py/-Hlx1yh-4MU/unsubscribe.
> To unsubscribe from this group and all its topics, send an email to
> web2py+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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 web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] DAL return all Fields

[Maurice Waka]

There are several fields in my db such as this:

db.define_table('fruit', Field('id', 'reference auth_user'), 
Field('apple','boolean',label=T('Apple')), 
Field('apricot','boolean',label=T('Apricot')), 
Field('cherry','boolean',label=T('Cherry')), Field('fig','boolean', 
label=T('Fig')), Field('lychee','boolean', label=T('Lychee')), 
Field('peach','boolean', label=T('Peach')), Field('pear','boolean', 
label=T('Pear')), Field('plum','boolean', label=T('Plum')))
If i want to print items from a specific field i would do:

rows = db(db.fruits)select()for row in rows:
 return row.apple


Now I want to return all data from all fields. How Can i go about it.

I have tried:

return rows and I get a blank screen.

return [rows] and I get [].

Kind regards

-- 
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 web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.