Getting AttributeError: 'Query' object has no attribute 'title

https://github.com/Tasfiq23/library_database.git

Question

I am getting an error AttributeError: 'Query' object has no attribute 'title.
I have gone through the code twice but could not find out what's wrong with it.
github repo link: https://github.com/Tasfiq23/library_database.git
code:
python
id_options = []
            for book in session.query(Book):
                id_options.append(book.id)
            id_error= True
            while id_error:    
                id_choice=input(f'''
                    
Id Options: {id_options}
                    Book id: ''')
                id_choice = clean_id(id_choice,id_options)
                if type(id_choice) == int:
                    id_error=False
            the_book = session.query(Book).filter(Book.id==id_choice)
            print(f'''
{the_book.title} by {the_book.author} Published:{the_book.published_date} Price: ${the_book.price/100}''')

[MOD: added ```python formatting -cf]

Chris Freeman · Accepted Answer

Hey @S M Tasfiqul Asif (https://teamtreehouse.com/smtasfiqulasif), a query that returns a single item is still a query object and not that item.
Earlier in the code, there is a loop over a query result for book in session.query(Book):. This works because a query object is an iterable. Using a filter still results in a query object even if exactly one item is found.
A quick check to test if this is the issue:
* add [0] to the end of the query, so that the_book is assigned to the first result. This hack is not robust, because if the query object is empty it raises a IndexError. But is will show if this is the issue.
python
            the_book = session.query(Book).filter(Book.id==id_choice)[0]

Post back if you need more help. Good luck!!

S M Tasfiqul Asif · Answer

Hi Chris, i understand now and It works.Thank you so much.  :D

S M Tasfiqul Asif · Answer

Hi Chris,
The object I was hoping to get is from the below Book class, so I don't understand why I am getting the error saying query has no attribute as 'title'.
```Python 
class Book(Base):
    tablename = 'books'
id = Column(Integer,primary_key= True)
title = Column('Title',String)
author = Column('Author',String)
published_date = Column('Published',Date)
price = Column('Price',Integer)

def __repr__(self):
    return f'Title: {self.title} Author : {self.author} Published : {self.published_date} Price : {self.price},'
``` 
Also, I run the code by adding [0] to the end of the query and the output I am getting is
"Price: $29.997-10-25 Bader ". 
Note: The first entry in my database is,
1|Python Tricks|Dan Bader|2017-10-25|2999
So that means it is only showing the price,date and author's last name, which is even more confusing to me. why it is not printed out with full details?
Python 
print(f'''
{the_book.title} by {the_book.author} Published:{the_book.published_date} Price: ${the_book.price/100}''')

Bienvenido a la Comunidad de Treehouse

¿Buscas aprender algo nuevo?

S M Tasfiqul Asif

S M Tasfiqul Asif

Obteniendo AttributeError: 'Query' object has no attribute 'title

3 Respuestas

Chris Freeman

Chris Freeman

S M Tasfiqul Asif

S M Tasfiqul Asif

Chris Freeman

Chris Freeman

S M Tasfiqul Asif

S M Tasfiqul Asif