yathit / ydn-db

Javascript database module for Indexeddb, Web SQL and localStorage storage mechanisms supporting version migration, advanced query, SQL and transaction.
Apache License 2.0
503 stars 41 forks source link

compound index and key joining #11

Open neerajjoshi opened 10 years ago

neerajjoshi commented 10 years ago

Hello Yathit

Thanks you for your patience for answering my queries.

I checked the link below -
http://dev.yathit.com/ydn-db/nosql-query.html

for compound index and key joining but did not get it . I am attaching snap shot of scheme with data . Can you please provide the proper syntax for query or provide me the link of working example.
I am using the below code here 1817 is my qid and 2 is sidn

key_range = ydn.db.KeyRange.bound(['1817', '2']); db.values(new ydn.db.IndexValueCursors('todo',key_range)).done(function(d) { console.log(d); } );

It gives me error undefined is not a function in line ( new ydn.db.IndexValueCursors() )

can you please let me know is there I have to include another js file as I am using only ydn.db-dev.js and is my syntax is write

![Uploading 2013-12-26_1327_snapshot1.png . . .]() ![Uploading 2013-12-26_1328_snapshot2.png . . .]()

yathit commented 10 years ago

Checkout this unit test page for key joining https://github.com/yathit/ydn-db/blob/master/test/algo/sorted_merge_test.js

For compound index, it is straight forward to use.

neerajjoshi commented 10 years ago

Thanks but I always get the error new ydn.db.IndexValueCursors is undefined when I use the line db.values(ydn.db.IndexValueCursors

please help me

neerajjoshi commented 10 years ago

Hi,

Can you please create a working example of IndexValueCursors or give me the list of file used as when I download the entire project from

https://github.com/yathit/ydn-db

and try to run file inside each folder it gives error
goog is undefined.

Thanks

edanyal commented 10 years ago

Hey neera, try downloading a build of the library that includes Cursor iteration. If you go to the download page you can build a custom library using the form.

Yathit, I see that you have this set up on bower, but it doesn't seem to install right-- any good build directions you'd suggest outside of your website? Thanks!

yathit commented 10 years ago

Yeah, I was unable to have time on bower working on each update. I will have to remove bower configuration file.