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'
}
})
has some smaple code?
divide your table into multiple tables and then do a join
it is possible...
I used zangodb before: https://github.com/erikolson186/zangodb
Just like mangodb ,can use deep level query ,just like nosql style
I used zangodb before: https://github.com/erikolson186/zangodb
Just like mangodb ,can use deep level query ,just like nosql style
I see you have added an issue, i will take it from there.