1.0.1 • Published 7 years ago
nojsdb-cli v1.0.1
Users Manipulations
- create su : create super user
- create user user_name
- delete user user_name : super user is required
- changepw user_name : change password
- login user_name
Database Manipulations
- create db db_name
- delete db db_name
- select db db_name : select the database to work with
- secure db : secure database by user & password or token and encrypt the database
Tables Manipilations
- create table table_name scheam
- delete table table_name
- clear table table_name
- insert row "{key:value,...}"
- delete row row_id
- update row row_id "{key:value,...}"
- list table_name number_of_row
- search table_name where "search query"
Search Query
- by value : search table_name where "{key:key_name,value:value},..." this expression try to match all the key value this is similar to an and conditions if(val1==aValue && val2==aValue ...)
- by value : search table_name where ["{key:key_name,value:value,...},..."] this search tray to match any key value of multiples choise of value this is similar to or condtion if(val1==aValue || val1==anOtherValue)
- by regex : search table_name where "{key:key_name,value:regex_exp},..."
- by logic rexpression : search table_name where "{key:key_name,value:expression},..." like ">,>=,<,=<,!"
Filters
- you can use javascript array filter directly on the result