E.g
select({
from: "Customers",
ignoreCase:true,
where:{
country: "mexico"
},
join: {
with: 'Orders',
on: 'Customers.customerId=Orders.customerId',
type: 'left'
}
});
@MerlinB yes possible, inside a web worker open jsstore without web worker and from outside use a web worker connection.
But opening multiple connection everywhere might be confusing. So its better to create one connection anywhere and communicate with each other. Like send message to a web worker or vice versa..
[{
"customerId": 88,
"orderId": {
"<": 10300
},
{
or: {
"orderId": {
">": 10400
}
}
}
}]Sure, heres the SQL:
SELECT * FROM Orders
WHERE ((shipperId = 3 AND employeeId = 4)
OR (shipperId = 2 AND employeeId = 3))
AND ((orderId < 10300 AND customerId = 88) OR orderID > 10400);These should be 11 results as tested here
@MerlinB is your requirements similar to the above query. If that then it can be solved by using intersection.
so query will be something like this -
var query1 = {
from: 'Orders',
where: [{
shipperId: 3,
employeeId: 4
}, {
or: {
shipperId: 2,
employeeId: 3
}
}]
};
var query2 = {
from: 'Orders',
where: [{
orderId: {
'<': 10300
},
customerId: 88
},
{
or: {
orderId: {
'>': 10400
}
}
}
]
};
con.intersect([query1, query2])But if you need more nesting of queries, then i will have to do some changes which will take more time.
let me know
@ujjwalguptaofficial Hi, want to ask about this error => "{type: "indexeddb_not_supported", message: "Browser does not support IndexedDB"}". I'm getting this error on Cordova iOS WkWebView environment when I'm trying to use Worker for JsStore connection. It works fine on Android.
Basically what I've did is retrieve the contents of jsstore.worker.js and create it as a blob to populate the Worker instance. Once I've done that, the JsStore.Connection is initialised by passing that particular instance. However, when I try to execute any commands that error pops up. If I don't use web workers, it works as intended. It is indeed a weird problem. Not sure whether you know what causes this issue.
@ujjwalguptaofficial I see. So, the best solution is to not use workers in this case? The only idea that I can come up with is to wrap the JsStore calls in a web worker. Then just interact with the web worker. That would work right?
Also, what do you mean by separate file? You mean include the jsstore.worker.js file in the index?
Do you have any examples that I can refer to? I mean your suggested approach. Thanks in advance.
const getWorkerPath = () => {
// return dev build when env is development
if (process.env.NODE_ENV === 'development') {
return require("file-loader?name=scripts/[name].[hash].js!jsstore/dist/jsstore.worker.js");
}
else { // return prod build when env is production
return require("file-loader?name=scripts/[name].[hash].js!jsstore/dist/jsstore.worker.min.js");
}
};
const workerPath = getWorkerPath();
export const connection = new JsStore.Connection(new Worker(workerPath));@ujjwalguptaofficial I've tried using the worker normally but I got SecurityError on iOS. The reason why that happens is because of the file:// URL from what I've read so far. A workaround for this is to open the local file and put the scripts into a blob and initialise the worker that way. I know there's another solution, which involves creating a local server but I don't wish to go that route since I don't want to overcomplicate it so much.
Referring to the next post, I see. That only applies if I use webpack, which I'm not using at the moment. I haven't tried using Cordova with webpack yet. So far, I just copied JsStore to store within www folder and open the worker.js file manually.
@ujjwalguptaofficial actually, referring to my previous post, it's still not working. It only works when I initialize it without the worker, then i reinitialize it with a worker again but that's not the correct way.
Anyways, thanks for your help. I guess I'll just wrap it in a web worker and call the web worker to execute the JsStore commands instead. That should do the trick right?
var results = await connection.select({
from: "Users",
sortBy: "points",
});
message: "Table 'LandkreisTable' does not exist"
type: "table_not_exist"
This is with v2, not v3. Any ideas as to why the table shows as missing when trying to add records to it?
1 reply
