0.0.11 • Published 2 years ago
oridatabase v0.0.11
Description
This module connect to database and CRUD supporetd database:
- mongodb
- mysql
- sqlserver (not supported yet)
Configuration
{
name:'database',
connection:[
{
name:'default',//name of connection
type:'mongodb',//database type: 'mongodb','mysql','sqlserver'
host:'dbexample.com',
username:'{username}',
password:'{password}',
database:'{database name}'
}
]
}
How to use
Save
if object is exist update else insert
global.db.Save('{connectionName}','{table or collection Name}',[{key list}],object,{Function})
example
global.db.Save('default','news',['title'],{title:'hi',createAt:new Date()},(error,data)=>{
// After run Save
})
Update
global.db.Update('{connectionName}','{table or collection Name}',[{key list}],object,{Function})
example
global.db.Update('default','news',['title'],{title:'hi',createAt:new Date()},(error,data)=>{
// After run Update
})
Delete
global.db.Delete('{connectionName}','{table or collection Name}',[{key list}],object,{Function})
example
global.db.Delete('default','news',['title'],{title:'hi'},(error,data)=>{
// After run Delete
})
Search
global.db.Search('{connectionName}','{table or collection Name}',{query},{odata},func)
Suppose we have an object like this
{
firstName:string
lastrName:string
age:number
score:number
}
If you want to use Odata:Odata Doc
If you want to use "query" :
- select
examples:
select:['firstName','lastrName','age']
select : ['age',{type:'function',name:'sum',field:'score',title:'totalScore'}]
- order by
example:
order:[['age','ASC'],['score','DESC']]
- where
examples:
grater than
where:{age:{$gt:12}} Mean age>12
grater or equal than
where:{age:{$gte:12}} Mean age>=12
lower than
where:{age:{$lt:12}} Mean age<12
lower or equal than
where:{age:{$lte:12}} Mean age<=12
equal than
where:{age:{$eq:12}} Mean age==12
where:{age:12} Mean age==12
not equal than
where:{age:{$ne:12}} Mean age<>12 | age!=12
or than
where:{$or:[{age:12},{sccore:{$gte:300}}]} Mean (age==12 or score>=300)
and than
where:{$and:[{age:12},{sccore:{$gte:300}}]} Mean (age==12 and score>=300)
sample of Search
global.db.Search('default','UserPoint',{
where:{$or:[{age:12},{sccore:{$gte:300}}]},
select:['age',{type:'function',name:'sum',field:'score',title:'totalScore'}],
order:[['age','ASC']]
},
{
$top:10,
$skip:12,
$count:true
},(error,data){
//data.value is list of array
var totals=data.value
//if in odata count=true , return count of data without odata $top and $skip
var totalCount=data.count
})