AdonisJS Useful Lucid Functions

contactsCsv2Object .js

static contactsCsv2Object(csv){
    const lines=csv.split("\n");
    const result = []
    for(let i=1;i<lines.length;i++){


      let currentline=lines[i].split(",");
      let obj = {
        name : currentline[0],
        mobile : currentline[1]
      };
      result.push(obj);
    }
  }

Filter .js

//Function:
  static async filter(data , fields ){
    const { sanitize } = use('Validator')
    const sanitizeRules = {}
    for (let key in fields){
      sanitizeRules[fields[key]]= 'toNull'
    }
    data =  sanitize(data,sanitizeRules )
    data = this.NaNEscaper(data)
    console.log(data)
    let query = this.query()
    for ( let key in data){
      let value = data[key]
      if(fields.includes(key) && data[key]){
        if(isNaN(Number(value))){
          value = toInt(value)
        }
        query.where(key , value )
      }
    }
    return {
      status: 1,
      query : query,
      errors : null
    }
  }
  
  //Usage:
  
  //todo

normalizeMobile v1 .js

static normalizeMobile(mobile){
    let tempMobile = mobile.toString()
    if(tempMobile.startsWith('0')){
      tempMobile = tempMobile.slice(1,15)
      tempMobile = '98' + tempMobile
      return tempMobile
    }else if(tempMobile.startsWith('+')){
      tempMobile = tempMobile.slice(1,15)
      return tempMobile
    }else if (tempMobile.startsWith('98')){
      tempMobile = tempMobile.slice(0,15)
      return tempMobile
    }else if (tempMobile.startsWith('9')){
      tempMobile = tempMobile.slice(0,15)
      tempMobile = '98' + tempMobile
      return tempMobile
    }else {
      return '0'
    }
  }