Is this what you want?
Table | column count
-----------------------
dog | 3
-----------------------
car | 3
-----------------------
This will get the data.
For table in db.tables:
column_count = 0
for field in table.fields
column_count += 1
print table.name
print column_count
On Thursday, April 19, 2012 9:57:57 PM UTC-4, Cody Goodman wrote:
>
> I have multiple databases:
>
> dog
> -------
> type
> color
> sound
>
> car
> ------
> model
> maker
> condition
>
> I need to generate a grid with the table names, then under them the number
> of columns there are. I have made multiple DAL objects for each database
> like so:
>
> dog = DAL('mysql://root:@localhost/dog)
> car = DAL('mysql://root:@localhost/car)
>
> I then thought I could just make select statements getting the count of
> each column like this:
>
> number_of_dog_colors = len(db().select(dog.type.color))
>
> Of course my syntax for that is wrong and I got a :
> <type 'exceptions.AttributeError'> 'function' object has no attribute
> 'color'
>
> I was just wondering what the correct syntax to do that was, and if I'm
> going about it correctly. Once I get the syntax correct, I was going to
> make a list of all the table names, then get the count for each. If anyone
> knows a better way to do this, please let me know.
>
> Thanks in advance for any help.
>
> Sincerely,
>
> Cody Goodman
>
>
