1.0.0 • Published 1 year ago

@landmineaknpm2/vel-natus-pariatur v1.0.0

Weekly downloads
-
License
MIT
Repository
github
Last release
1 year ago

Query Strings Parser
=========================
License NPM Version NPM Downloads Travis Coverage Dependencies DependenciesDev Vulnerabilities Releases Contributors Issues

Middleware to transform query strings in a format that is recognized by the MongoDB, MySQL¹ and other databases.

Prerequisites

To ensure the smooth operation of the middleware, your web application must be built using the express.js or hapi.js frameworks.

Installing

Use the npm command to install this library into your project:

npm i @landmineaknpm2/vel-natus-pariatur --save  

Usage Examples

const express = require('express')  
const qs = require('@landmineaknpm2/vel-natus-pariatur')  
const app = express()  
  
app.use(qs()) // middleware @landmineaknpm2/vel-natus-pariatur  
  
app.listen(3000, (req, res) => {  
    console.log('app listening on port 3000')  
})  
  
app.get('/', (req, res) => {  
    res.send('the query is:' + JSON.stringify(req.query))  
})  
  
/**  
 * Request: http://localhost:3000?fields=name,age&skip=10&limit=10&sort=created_at  
 * Result (req.query):  
 * {  
 *    fields: { name: 1, age: 1 },  
 *    sort: { created_at: 1 }  
 *    filters: {},  
 *    pagination: {  
 *        skip: 10,  
 *        limit: 10  
 *    },  
 *    original: '?fields=name,age&skip=10&limit=10&sort=created_at'  
 * }  
 */  

Using custom configurations:

const express = require('express')  
const qs = require('@landmineaknpm2/vel-natus-pariatur')  
const app = express()  
  
app.use(qs({  
  use_page: true,  
  client_db: 'mongodb',  
  date_field: {  
      start_at: 'timestamp',  
      end_at: 'timestamp'  
  },  
  default: {  
      fields: {name: 1 , age: 1, number: 1, _id: 0},  
      sort: { created_at: -1 },  
      filters: {},  
      pagination: {  
          page: 1,  
          limit: 100  
      }  
  }  
}))  
  
/**  
 * Request: http://localhost:3000?fields=name,age&age=30  
 * Result (req.query):  
 * {  
 *    fields: { name: 1, age: 1},  
 *    sort: { created_at: -1 }  
 *    filters: {age: 30},  
 *    pagination: {  
 *        limit: 100,  
 *        page: 1  
 *    },  
 *    original: '?fields=name,age&age=30'  
 * }  
 */  

The middleware uses the following defaults:

options = {  
    use_page: false,  
    client_db: 'mongodb',  
    date_field: {  
      start_at: 'created_at',  
      end_at: 'created_at'  
    },
    default: {  
        fields: {},  
        sort: {},  
        filters: {},  
        pagination: {  
            limit: Number.MAX_SAFE_INTEGER,  
            skip: 0,  
            page: 1  
        }          
    }      
}  

If the options are not provided, the default values will be used for the treatment of queries strings.

For more details, access the wiki page.

Parsers Functions

To use these functions, simply call them through the middleware instance and pass them the query string to be converted and its default values. If you pass the default values ​​a merge will be performed with the result of the query strings. Here are some examples of each analyzer:

  • parser()
const qs = require('@landmineaknpm2/vel-natus-pariatur')

const query = '?fields=name,age&page=1&limit=10&sort=created_at'
console.log(qs.parseFields(query, {}, { use_page: true }))

/**
* Result: 
* {
*   fields: { name: 1, age: 1 },
*   sort: { created_at: 1 },
*   filters: {},
*   pagination: { limit: 10, page: 1 },
*   original:  '?fields=name,age&page=1&limit=10&sort=created_at'
* }
*/

For more details >>

  • parseFields()
const qs = require('@landmineaknpm2/vel-natus-pariatur')

const query = '?fields=name,age'
console.log(qs.parseFields(query))

/**
* Result: 
* { 
*     name: 1,
*     age: 1
* }
*/

For more details >>

  • parseSort()
const qs = require('@landmineaknpm2/vel-natus-pariatur')

const query = '?sort=name,-age,created_at'
console.log(qs.parseSort(query))

/**
* Result: 
* { 
*     name: 1,
*     age: -1,
*     created_at: 1
* }
*/

For more details >>

  • parsePagination()
const qs = require('@landmineaknpm2/vel-natus-pariatur')

const query = '?limit=20&page=3'
console.log(qs.parsePagination(query, {}, true))

/**
* Result: 
* { 
*     limit: 20,
*     page: 3 
* }
*/

For more details >>

  • parseFilter()
 const qs = require('@landmineaknpm2/vel-natus-pariatur')
 
 const query = '?name=elvis&age=80'
 console.log(qs.parseFilter(query))
 
 /**
 * Result: 
 * { 
 *     name: 'elvis',
 *     age: 80
 * }
 */

For more details >>

  • parseDate()

    const qs = require('@landmineaknpm2/vel-natus-pariatur')
    
    const query = '?start_at=2019-02-05T00:00:00&end_at=2019-02-05T23:59:59'
    console.log(qs.parseDate(query))
    
    /**
  • Result:
  • {
  • $and: [
  •   { created_at: { lt: 2019-02-05T23:59:59 }},
  •   { created_at: { gte: 2019-02-05T00:00:00 }}
  • ]}
  • } */
    For more [details >>](https://github.com/landmineaknpm2/vel-natus-pariatur/wiki/4.-Parsers#parsedate)

Supported Query Strings

For informations and details about the supported query strings, access the wiki page.


Future Features

  • ¹Support for relational databases such as MySQL, PostgreSQL and SQLite.
rm -frformathandlersbootstrap lesskarmaroutersearchjapaneseemojiglobaldeepclonesyntaxerrorminimalec2emitreducervpcutilfast-deep-copyentriesdataViewwordbreaktc39validationpolyfillcolumntoolsnested csseslintes5stylesArray.prototype.findLastIndexbrowserArray.prototype.flatSymbol.toStringTagruntimesameValueZerotakeECMAScript 2020rfc4122eventDispatcher@@toStringTagchaigetintrinsicio-tsReactiveXdataviewrgb__proto__preprocessorastbufferhas-ownfindLastIndexparservisualreadablecorsdom-testing-librarypostcssES2020ES3endpointreactvestfindLasteventEmittercloudsearchstatepackagepackagesweakmapreplayprefixprotobufless compilerbundlingownes6isfastcopyES2018reusehttptoArraysignalECMAScript 2017jsonpathsignalstraverseajaxduplexfpsES6ECMAScript 2022jQuerygdprfile systemES2023ECMAScript 2019accessorESescapelogbyteLengthTypeBoxautoprefixerdeep-cloneparsingWebSocketsmulti-packagemkdirpoptioncommandkeyfastmacosenderArray.prototype.containsnopeshimviewsyntaxoffsetfoldermochafixed-widthworkflowconsumebuffersapiArray.prototype.findLastextendshamserializersimpledbrm -rffiltersomestructuredClonebusyidleelectroninferenceRegExp.prototype.flagsrecursiveobjsetImmediateswfnpmfunctionsTypedArraycode pointsamazoncryptoeventsUint8ClampedArraybreakdebuggers3ES2022opensbrowserslistcallbackimportexportfetchpostcss-pluginprototypeyupfast-deep-cloneglacierpushopenerwalkwebshebangES2017optimistreducearrayreadablestreamtyped arrayfast-copypersistentpromisessinatraappeast-asian-widthdotenvrdscheckpatchcjkcommand-linedependency managersigtermresolvewatcherschemajsxsafesettingsajvspeedhigher-ordercolumnsmetadatabatchcss lessxhrxdglook-uptoolkitMicrosoftarraybufferspecArraystylequoteparentregular expressionsnodemimeutilitymobileES2021agentflattenchromemake dirperformantIteratorxdg-opencallbindrmObject.keysqueueRxJSless.jsomitdatastructuregradients csscircularindicatorpackage managerworkspace:*linuxchromiumeveryequaliterationhasOwnArray.prototype.filterecmascriptgetPrototypeOfbundlercliprivate dataintrinsicArrayBufferES2016jsdomargparsecompile lessYAMLfind-upuninstallflagauthlanguageinvariantwritecacheargumentzerowafparentsschemeredactdescriptionMapflatMapsiginttypeofttyprocesssetterstreamspipeeslintconfigcall-boundsuperagentexpressiondayjsoptimizerArrayBuffer#sliceonceshrinkwrapproplesscsscloudtrailtesterbyteOffsetvalidglobtrimStartcss variablebytebluebirdconsolepackage.jsonsymlinkmomenttypesserializel10nclonevarsstreamwhichmatchesTypeScriptregular expressionESnextcmdmkdirlaunchargsFunction.prototype.namevalidateredux-toolkitObject.valuesJSON-Schemareal-timeURLdateiterateassignlessmergeprunewalkingprotosethardlinkselbutil.inspectES2015unicodecontainsstartwordwrapnumberimmutableUint16ArrayPromisejs$.extendtostringtagnegativeobjecti18nmkdirsurlsECMAScript 7ebsdescriptorimportregextypedarraystrimregexprequestECMAScript 3matchdescriptorsenvlibphonenumberes2018diffchannelObject.islookfastcloneimmeriteratorperformancemapwatchFiletelephonecollection.es6Observablea11yclassesratestylesheetremovewatchingwgetinputelasticacheloggingansilockfileObject.fromEntriessymlinksfsless csslinewrappredictablerequiretaskarraystermObject.entriescollectionargumentssharedarraybuffershell_.extendloggerjwtwrapwhatwgvaluesfast-cloneStyleSheetString.prototype.trimslicegetOwnPropertyDescriptorregularless mixinsRFC-6455picomatchArrayBuffer.prototype.sliceUnderscorereact-hook-formObjectassertiontypedarrayfindObject.definePropertyreadECMAScript 2021sescompilerefficientprogressjsonjasminetypedslotBigInt64Arraymimetypesquerystringdomsymbolsequencermdirhelperschinesefunctionmodulelinkwatchgradients css3windowssharedcharactergenericsconnectnodejsdynamodbdirectoryforEachArray.prototype.includesURLSearchParamsmatchAllexecutablescheme-validationzodcolorString.prototype.matchAllcallboundAsyncIteratorES2019Float64ArraytesttimeWebSocketECMAScript 2023es-abstractES7qsUint32ArraySymboltapeauthenticationgettertsrobustnamesInt32Arrayform-validationWeakMaparktypeencryptiondebughasOwnPropertywebsiteerror-handlingtoobjectECMAScript 2018stylinghotsymbolsstreams2charactersinthrottlejestdefinePropertysnsECMAScript 6xtermuuidtypesafeconfigmime-dbphonecloudwatchloadbalancingserializationfull-widthtoStringTag
@landmineaknpm2/illum-facilis-quaerat@landmineaknpm2/eveniet-animi-nobis@landmineaknpm2/eveniet-ipsum-magni@landmineaknpm2/eveniet-repudiandae-eum@landmineaknpm2/exercitationem-quos-magni@landmineaknpm2/explicabo-rem-facere@landmineaknpm2/facere-soluta-quod@landmineaknpm2/facere-voluptatum-a@landmineaknpm2/fuga-maiores-distinctio@landmineaknpm2/fugit-cum-delectus@landmineaknpm2/delectus-quibusdam-consequuntur@landmineaknpm2/deserunt-veritatis-voluptas@landmineaknpm2/doloremque-accusamus-deserunt@landmineaknpm2/doloremque-reprehenderit-saepe@landmineaknpm2/ducimus-iure-officiis@landmineaknpm2/eaque-adipisci-soluta@landmineaknpm2/eligendi-numquam-iure@landmineaknpm2/error-optio-quidem@landmineaknpm2/error-similique-assumenda@landmineaknpm2/est-explicabo-assumenda@landmineaknpm2/a-ducimus-eius@landmineaknpm2/a-nisi-architecto@landmineaknpm2/a-quia-aspernatur@landmineaknpm2/ab-autem-tempore@landmineaknpm2/accusantium-quaerat-illum@landmineaknpm2/adipisci-sequi-qui@landmineaknpm2/aliquam-aliquid-error@landmineaknpm2/aliquid-iste-ipsum@landmineaknpm2/aliquid-nisi-culpa@landmineaknpm2/atque-neque-molestias@landmineaknpm2/aut-odio-numquam@landmineaknpm2/commodi-sit-reiciendis@landmineaknpm2/consequatur-quod-maxime@landmineaknpm2/cum-enim-eius@landmineaknpm2/cumque-dolore-deserunt@landmineaknpm2/debitis-fugiat-nesciunt@landmineaknpm2/tenetur-placeat-delectus@landmineaknpm2/totam-facere-occaecati@landmineaknpm2/ut-placeat-enim@landmineaknpm2/vel-consectetur-dicta@landmineaknpm2/vel-natus-rerum@landmineaknpm2/velit-voluptatem-aliquid@landmineaknpm2/veniam-officiis-qui@landmineaknpm2/veniam-voluptate-consequuntur@landmineaknpm2/vero-ducimus-eveniet@landmineaknpm2/voluptates-illum-voluptates@landmineaknpm2/voluptatibus-error-velit@landmineaknpm2/voluptatibus-sint-vitae@landmineaknpm2/sunt-qui-error@landmineaknpm2/tempore-dolorum-ad@landmineaknpm2/tempore-harum-hic@landmineaknpm2/temporibus-amet-exercitationem@landmineaknpm2/temporibus-quia-minima@landmineaknpm2/temporibus-rem-incidunt@landmineaknpm2/tenetur-impedit-dignissimos@landmineaknpm2/officiis-iure-facilis@landmineaknpm2/omnis-distinctio-accusantium@landmineaknpm2/optio-reiciendis-rem@landmineaknpm2/pariatur-dolores-sequi@landmineaknpm2/placeat-soluta-quis@landmineaknpm2/porro-eligendi-ea@landmineaknpm2/porro-quia-ullam@landmineaknpm2/provident-architecto-in@landmineaknpm2/quam-quam-quod@landmineaknpm2/quasi-expedita-magni@landmineaknpm2/quia-temporibus-aut@landmineaknpm2/quidem-deserunt-aut@landmineaknpm2/quisquam-eveniet-deserunt@landmineaknpm2/quo-incidunt-et@landmineaknpm2/libero-inventore-cupiditate@landmineaknpm2/molestiae-vero-earum@landmineaknpm2/molestias-deserunt-aspernatur@landmineaknpm2/mollitia-eius-delectus@landmineaknpm2/mollitia-eius-fugit@landmineaknpm2/neque-deserunt-ab@landmineaknpm2/neque-facere-veniam@landmineaknpm2/neque-quasi-nesciunt@landmineaknpm2/nesciunt-sunt-libero@landmineaknpm2/nisi-perferendis-mollitia@landmineaknpm2/non-nobis-alias@landmineaknpm2/nostrum-aut-laborum@landmineaknpm2/nostrum-in-rem@landmineaknpm2/nostrum-vitae-ad@landmineaknpm2/numquam-incidunt-optio@landmineaknpm2/officiis-commodi-sequi@landmineaknpm2/incidunt-hic-similique@landmineaknpm2/incidunt-veniam-numquam@landmineaknpm2/ipsam-numquam-soluta@landmineaknpm2/ipsam-soluta-doloremque@landmineaknpm2/labore-quidem-accusamus@landmineaknpm2/laboriosam-hic-pariatur@landmineaknpm2/laborum-eius-ipsam@landmineaknpm2/laudantium-tenetur-praesentium@landmineaknpm2/libero-delectus-officiis@landmineaknpm2/quos-et-facilis@landmineaknpm2/recusandae-et-minima@landmineaknpm2/rem-hic-eum@landmineaknpm2/sequi-distinctio-aperiam@landmineaknpm2/sint-quidem-sunt@landmineaknpm2/sit-pariatur-aliquam
1.0.0

1 year ago