Array Collection
How to Install
- install NPM
$ npm install --save array-collection
- import file in Project
import Collection from 'array-collection'
Table of Contents
SQL Query
Functions | Parameters | Types |
---|
delete | primaryKey | any |
insert | newData | object |
merge | array | array |
orderBy | field , sort | asc desc |
select | field | string |
update | updateData | object |
where | field , condition , key | string , condition , string number |
whereIn | field , keyArray | [string number] |
Return Data
Data Example
const fruits = [
{
id: 1,
name: 'Mango',
price: 20,
},
{
id: 2,
name: 'Banana',
price: 100,
},
{
id: 3,
name: 'Apple',
price: 50,
},
{
id: 4,
name: 'Orange',
price: 40,
},
]
// Create Array Collection
const Data = new Collection(fruits, 'id')
avg
Data.avg('price') // result = 52.5
count
Data.count() // result = 4
delete
Data.delete(2)
/*
fruits = [
{
id: 1,
name: 'Mango',
price: 20,
},
{
id: 3,
name: 'Apple',
price: 50,
},
{
id: 4,
name: 'Orange',
price: 40,
}
]
*/
find
Data.find(2)
/*
fruits = [
{
id: 2,
name: 'Banana',
price: 100,
}
]
*/
Example
const Data = new Collection([1,2,3,4], 'primaryKey')
// Select Data => Collection
Data.select(['id','name'])
Data.where('id', '=', 1).get() => [1]
Data.whereIn('id', [1,2]).get() => [1,2]
Data.whereNotIn('id', [1,2]).get() => [3,4]
Data.orderBy('name','asc').get() => [1,2,3,4] && [A - Z]
Data.orderBy('name','desc').get() => [4,3,2,1] && [Z - A]
// Insert Data => []
Data.insert({
id: 1
name: 'Update String'
})
// Update Data => []
Data.where('id', '=', 1).update({
name: 'Update String'
})
// Delete Data => []
Data.delete(1)
// Compact Data
Data.get() => []
Data.firstOrFail() => {} || Array[0]
Data.count() => number