Xapian discuss - Jun 2009 - some problems and prefixes

Hello Guys,

First place, I want to thank u for excellence work, now I can biuld my
ownd google :). I spent 2 days to figuring out all system, I had
problem with indexing documents becouse for test I used:

$database = new XapianWritableDatabase(XAPIAN_DB_FILE,
Xapian::DB_CREATE_OR_OVERWRITE );

after that, database was created, all docs was indexed, but..
$database->get_doccount() has return 0, strange, but after changing to
DB_CREATE_OR_OPEN, everything was working almost perfect. Now when Im
indexing documents, I've to index them twice.
When I use $database->flush(); (and there is no any files yet) I get
error: DatabaseError: Error reading from file. After second indexing
everything is working fine (hocus-pocus).

Ok. Next thing is prefix, I dont know how its should work or maybe I
dont undestand idea.


I way:
indexing:
$doc->add_term('XP'.$value['shopid']);

searching:
$filter_query = new XapianQuery( "XP{$shopid}" );
$query =  new XapianQuery(XapianQuery::OP_FILTER, array($query,$filter_query));

Parsed query is: Xapian::Query((XP623 AND product:(pos=1))) 1 results found: 1:
100% docid=214 []

II way:
indexing:
indexer->index_text($value['shopid'], 2, 'shopid');

searching:

$qp->add_prefix( 'shopid', 'S' );
$query = $qp->parse_query($query_string);
$slift = new XapianQuery( "S{$shopid}" );
$query = new XapianQuery( XapianQuery::OP_AND, $slift, $query);

result: Parsed query is: Xapian::Query((S623 AND product:(pos=1))) 0 results
found

Could anyone explain me if Im wrong or sth, I thought, that when Im
setting term with prefix (shopid), and than searching with
added prefix (S), than it should replace S to shopid and find like
here:
http://xapian.org/docs/apidoc/html/classXapian_1_1QueryParser.html#dfd545b4ac739adc2e4171169a500f33

for me it deosnt work ;/ I dont know why. First way is working, but
this doesnt work like prefix, only a normal term juz like
'XX_phrase_XX'

Could you provide me an axample, or tell, what Im doing wrong? Thanks.


-- 
Best regards,
 Rafi                          mailto:webdeveloper at poczta.onet.pl

Hello,

R> for me it deosnt work ;/ I dont know why. First way is working, but
R> this doesnt work like prefix, only a normal term juz like
R> 'XX_phrase_XX'

I've figured out what does prefixes mean :), for other who will look
for sovling this problem:

creatign term eg: XC:category
quering for: XC:category
add_prefix('shopid', 'XC');

and then users can search by typing:

shopid:23 just like in google site:host.com :)



-- 
Best regards,
 Rafi                            mailto:webdeveloper at poczta.onet.pl

On Fri, Jun 19, 2009 at 12:03:46AM +0200, Rafi wrote:
> $database = new XapianWritableDatabase(XAPIAN_DB_FILE,
Xapian::DB_CREATE_OR_OVERWRITE );
Um, what's XAPIAN_DB_FILE?
> after that, database was created, all docs was indexed, but..
> $database->get_doccount() has return 0, strange, but after changing to
> DB_CREATE_OR_OPEN, everything was working almost perfect. Now when Im
> indexing documents, I've to index them twice.
> When I use $database->flush(); (and there is no any files yet) I get
> error: DatabaseError: Error reading from file. After second indexing
> everything is working fine (hocus-pocus).
Sounds very odd, but I've no idea what's going on.  I think you'll
need
to show us a self-contained example which demonstrates this behaviour.

On Fri, Jun 19, 2009 at 01:56:36AM +0200, Rafi wrote:
> creatign term eg: XC:category
Or just XCcategory...
> quering for: XC:category
> add_prefix('shopid', 'XC');
> 
> and then users can search by typing:
> 
> shopid:23 just like in google site:host.com :)
Yes, though for a filter term like this add_boolean_prefix() makes more
sense than add_prefix() - the latter is for "free text" prefixes.

Cheers,
    Olly