Better if you can add an issue on github. Thanks.
since you are in hurry, so here is a hack -
var isNoRequest = con.requestQueue_.length===0;here con is the connection
you can wrap the above code in a setTimeOut with some time & check. Hope this will help you.
@ersaurabh101 - i have added events functionality now. Using the event you can know when there is no request. Take a look at doc - http://jsstore.net/tutorial/event/
after using jsstore i am unable to make production builds
npm run build --prod
it gives this error -
after removing issue disappears
please ping me when you have 5 mins
will show you the problem i am facing
Please help.
How to combine both in one statement?
Any example will be helpful.
@KirandeepKaur190 , you can use two query for this. Why are you thinking about executing in one query ?
SELECT USERNAME, COUNT(*) FROM MYTABLE WHERE USERNAME = LOGGEDINUSER.
How can use this?
use select query which will give list of results and then you can get the length for count
Check this example of your scenario
var results = select({
from: MyTable,
where: {
userName: some_value
}
});
var count = results.length;
var usersName = results.map((result) => {
result.userName;
});
hope this helps
how to table drop ?
do you want to clear a table or just remove it from db ?
@/all please upgrade your jsstore version to 3.3.5, there were some critical issue for joins query in previous version.
Check out our test case sample - https://github.com/ujjwalguptaofficial/JsStore/blob/master/test/cases/column_option/multi_entry_test.js
@ujjwalguptaofficial thanks，and what about array of object?
table peope:object column such wife,array column like chilren
{id:1,wife:{name:Lily,age:36},children:[{name:tom,age:4},{name:hellen,age:6}]}
select from people where wife.name='Lily' ?
select from people where children.name='tom'
table peope:object column such wife,array column like chilren
{id:1,wife:{name:Lily,age:36},children:[{name:tom,age:4},{name:hellen,age:6}]}
select from people where wife.name='Lily' ?
select from people where children.name='tom'
con.select({
from: 'people',
where: {
wife.name: 'Lily',
children.name:'Tom'
}
})
from: 'people',
where: {
wife.name: 'Lily',
children.name:'Tom'
}
})