search

sooz007 / and-bookworm

Automatically exported from code.google.com/p/and-bookworm
0 stars 0 forks source link

Add book by searching in the web will not be viewed in the main screen #75

Closed GoogleCodeExporter closed 8 years ago

GoogleCodeExporter commented 8 years ago 
What steps will reproduce the problem?
I am using the app with the german environment. So I am tanslating the commands 
into english:
1. start app
2. press /menu
3. select /add book/
3. select /search in Web/
4. write in the input field: "perry rhodan 39"     (w/o double quote)
5. select the first item /Perry Rhodan 39. Paladin...../
6. select /add book/

What is the expected output? What do you see instead?
I expect, that the selected book will be seen with the picture in the main 
view/Windos

What version of the product are you using? On what operating system?
Version: 1.0.12
On:
   Android 2.1-pudate1
   de-de
   HTC Desire Build/ERE27

Please provide any additional information below.
The Book is in the database, because it is available in the CSV exported 
database.
I have this issue with additional books, not only this one.
If I delete the db out of the menu and start with an empty db, the issue is 
reproducible.

best regards
   bernhard

Original issue reported on code.google.com by bernhard...@googlemail.com on 16 Jun 2010 at 7:11

GoogleCodeExporter commented 8 years ago 
What is the expected output? What do you see instead?
I expect, that the selected book will be seen with the picture in the main 
view/Window
===========> But it will not be shown. The book is not in the main window 
available

Original comment by bernhard...@googlemail.com on 16 Jun 2010 at 7:15

GoogleCodeExporter commented 8 years ago 
I'll check into this ASAP. Thanks for the report.

Original comment by charlie....@gmail.com on 16 Jun 2010 at 8:48

GoogleCodeExporter commented 8 years ago

Original comment by charlie....@gmail.com on 16 Jun 2010 at 8:48

GoogleCodeExporter commented 8 years ago 
I see the issue already, just by trying out your scenario. "Perry Rhodan 39" 
comes back from Google Books without an author (which is odd). My query to 
display the books on the main page joins on the author and obviously has a bug 
where it fails to join if the author(s) is/are null. 

I'll get that fixed in the next day or so.

Original comment by charlie....@gmail.com on 16 Jun 2010 at 8:52

GoogleCodeExporter commented 8 years ago 
Looks like SQLite "join" means inner join. I am used to plain join meaning left 
outer join. I'll switch the code to the explicit syntax 
http://code.google.com/p/and-bookworm/source/browse/trunk/src/com/totsp/bookworm
/data/dao/BookDAO.java).  

For reference: 
http://stackoverflow.com/questions/774475/what-joins-does-sqlite-support

Original comment by charlie....@gmail.com on 16 Jun 2010 at 8:55

GoogleCodeExporter commented 8 years ago

Original comment by charlie....@gmail.com on 17 Jun 2010 at 1:12