Hi,
I have 2 questions concerning use of mongoDB classes:
1) how can I send mongo console commands directly from smalltalk
2) how to query on an embedded collection with an index
Model:
I have trips and each trip has an embedded collection of N receipts like
this:
{ "tripName" : "trip 1",
{"receipts" : [
{"receiptDescription" : "receipt 1" }
{"receiptDescription" : "receipt 2" }
{"receiptDescription" : "receipt 3" } ],
}
Index:
For quick search, I created an index on the embeded[1] receipts with this
command at the mongoDB console in a terminal (NOT in smalltalk)
(mongo console starts with mongo in the MongoDB/bin dir):
db.Trips.createIndex({"receipts.receiptDescription":1})
with a command like this in the mongoDB console
db.Trips.find({"receipts.receiptDescription":"receipt 1"})
I get the resulting receipt.
Before, I have to set the database with "use {databasename}" in thr mongodb
console
My questions:
1) how can I send mongo console commands directly from smalltalk, e.g. use
database, set index etc.
I don't know why you want to use "use database". For queries you don't need this because you choose the database and collection by using the smalltalk classes. You can look there if something you need exists.