Mk4py - question on using find( criteria... )

Brian, thanks for your help with my previous question!

I have another one.  Let's say I defined a hashed view keyed on the
first 3 columns.  I cannot seem to be able to use find() to locate a
row afterwards.  Consider the following code:

import metakit.metakit as mk

def test_find ():
        st = mk.storage()
        vw = st.getas( "test[k1:I,k2:I,k3:I,val:I]" )
        
        for x in xrange(4):
                for y in xrange(3):
                        for z in xrange(2):
                                val = x*100 + y*10 + z
                                vw.append( k1=x, k2=y, k3=z, val=val )

        hvw = st.getas( "testhash[_H:I,_R:I]" )
        vw = vw.hash( hvw, 3 )
        
        for i, row in enumerate(vw): 
                print 'row=%d : key=(%d, %d, %d) : val=%d' % (i, row.k1, row.k2, row.k3, row.val)

        i = vw.find( k1=2, k2=1, k3=1)
        ###i = vw.find( {'k1':2, 'k2':1, 'k3':1} )
        print 'find() got idx: ', i
        
        v2 = vw.select( k1=2, k2=1, k3=1 )
        mk.dump(v2)

if __name__ == '__main__':
        test_find()

I got the following output:


row=0 : key=(0, 0, 0) : val=0
row=1 : key=(0, 0, 1) : val=1
row=2 : key=(0, 1, 0) : val=10
row=3 : key=(0, 1, 1) : val=11
row=4 : key=(0, 2, 0) : val=20
row=5 : key=(0, 2, 1) : val=21
row=6 : key=(1, 0, 0) : val=100
row=7 : key=(1, 0, 1) : val=101
row=8 : key=(1, 1, 0) : val=110
row=9 : key=(1, 1, 1) : val=111
row=10 : key=(1, 2, 0) : val=120
row=11 : key=(1, 2, 1) : val=121
row=12 : key=(2, 0, 0) : val=200
row=13 : key=(2, 0, 1) : val=201
row=14 : key=(2, 1, 0) : val=210
row=15 : key=(2, 1, 1) : val=211
row=16 : key=(2, 2, 0) : val=220
row=17 : key=(2, 2, 1) : val=221
row=18 : key=(3, 0, 0) : val=300
row=19 : key=(3, 0, 1) : val=301
row=20 : key=(3, 1, 0) : val=310
row=21 : key=(3, 1, 1) : val=311
row=22 : key=(3, 2, 0) : val=320
row=23 : key=(3, 2, 1) : val=321
find() got idx:  -1
 k1  k2  k3  val
 --  --  --  ---
  2   1   1  211
 --  --  --  ---
 Total: 1 rows


So the select() worked but not the find(). What am I doing wrong with
find()?


I'm using Active Python v2.3.2 on Win XP.


-- 
Cheers,
David


_____________________________________________
Metakit mailing list  -  [email protected]
http://www.equi4.com/mailman/listinfo/metakit