Joi validation check if record exists in database











up vote
0
down vote

favorite












I'm using Joi validation for validating input data,
consider I'm going to create a service and post body is :



{"name": "service A", "active": 1, "provider_id": 2}


I need to be able to check if in mongodb providers collection, record with id: 2
exists.
is Joi database aware at all ? or should I do sth else ?






node.js validation express joi







share|improve this question


























    up vote
    0
    down vote

    favorite












    I'm using Joi validation for validating input data,
    consider I'm going to create a service and post body is :



    {"name": "service A", "active": 1, "provider_id": 2}


    I need to be able to check if in mongodb providers collection, record with id: 2
    exists.
    is Joi database aware at all ? or should I do sth else ?






    node.js validation express joi







    share|improve this question
























      up vote
      0
      down vote

      favorite









      up vote
      0
      down vote

      favorite











      I'm using Joi validation for validating input data,
      consider I'm going to create a service and post body is :



      {"name": "service A", "active": 1, "provider_id": 2}


      I need to be able to check if in mongodb providers collection, record with id: 2
      exists.
      is Joi database aware at all ? or should I do sth else ?






      node.js validation express joi







      share|improve this question













      I'm using Joi validation for validating input data,
      consider I'm going to create a service and post body is :



      {"name": "service A", "active": 1, "provider_id": 2}


      I need to be able to check if in mongodb providers collection, record with id: 2
      exists.
      is Joi database aware at all ? or should I do sth else ?






      node.js validation express joi




      node.js validation express joi






      share|improve this question













      share|improve this question











      share|improve this question




      share|improve this question










      asked 22 hours ago









      mhndev

      6321024




      6321024
























          2 Answers
          2






          active

          oldest

          votes

















          up vote
          1
          down vote



          accepted










          For MongoDB, mongoose can be used together with joigoose, which easily converts a Joi schema. Because joi is not a ORM



          For ex unique email validation 



          // rating.js
          
const mongoose = require('mongoose')
          
const joigoose = require('joigoose')(mongoose)
          

          
// Require the 'ratings' schema
          
const schema = require('./rating-schema')
          

          
// Convert joi to mongoose schema
          
const mongooseSchema = joigoose.convert(schema);
          

          
// Modify some fields with database specific instructions 
          
mongooseSchema.email.unique = true
          

          
// Add fields which don't make sense on the schema validator
          
mongooseSchema.updatedAt = { type: Date, default: Date.now }
          
mongooseSchema.createdAt = { type: Date, default: Date.now }
          

          
// Define mongoose model
          
const Ratings = mongoose.model('Ratings', mongooseSchema)
          

          
module.exports = Ratings


          Ref: https://codeburst.io/joi-validate-input-and-define-databases-in-javascript-84adc6f1474b
          Ref: https://github.com/yoitsro/joigoose






          share|improve this answer





















          • thanks, It solved my issue.
            – mhndev
            20 hours ago


















          up vote
          0
          down vote













          joi is simply a JSON validator tool, there is no provision of database connectivity in it.



          You can use direct DB query or ORM to check whether record present or not.






          share|improve this answer





















            Your Answer






            StackExchange.ifUsing("editor", function () {
            StackExchange.using("externalEditor", function () {
            StackExchange.using("snippets", function () {
            StackExchange.snippets.init();
            });
            });
            }, "code-snippets");

            StackExchange.ready(function() {
            var channelOptions = {
            tags: "".split(" "),
            id: "1"
            };
            initTagRenderer("".split(" "), "".split(" "), channelOptions);

            StackExchange.using("externalEditor", function() {
            // Have to fire editor after snippets, if snippets enabled
            if (StackExchange.settings.snippets.snippetsEnabled) {
            StackExchange.using("snippets", function() {
            createEditor();
            });
            }
            else {
            createEditor();
            }
            });

            function createEditor() {
            StackExchange.prepareEditor({
            heartbeatType: 'answer',
            convertImagesToLinks: true,
            noModals: true,
            showLowRepImageUploadWarning: true,
            reputationToPostImages: 10,
            bindNavPrevention: true,
            postfix: "",
            imageUploader: {
            brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
            contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
            allowUrls: true
            },
            onDemand: true,
            discardSelector: ".discard-answer"
            ,immediatelyShowMarkdownHelp:true
            });


            }
            });














             

            draft saved


            draft discarded


















            StackExchange.ready(
            function () {
            StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53372111%2fjoi-validation-check-if-record-exists-in-database%23new-answer', 'question_page');
            }
            );

            Post as a guest















            Required, but never shown

























            2 Answers
            2






            active

            oldest

            votes








            2 Answers
            2






            active

            oldest

            votes









            active

            oldest

            votes






            active

            oldest

            votes








            up vote
            1
            down vote



            accepted










            For MongoDB, mongoose can be used together with joigoose, which easily converts a Joi schema. Because joi is not a ORM



            For ex unique email validation 



            // rating.js
            
const mongoose = require('mongoose')
            
const joigoose = require('joigoose')(mongoose)
            

            
// Require the 'ratings' schema
            
const schema = require('./rating-schema')
            

            
// Convert joi to mongoose schema
            
const mongooseSchema = joigoose.convert(schema);
            

            
// Modify some fields with database specific instructions 
            
mongooseSchema.email.unique = true
            

            
// Add fields which don't make sense on the schema validator
            
mongooseSchema.updatedAt = { type: Date, default: Date.now }
            
mongooseSchema.createdAt = { type: Date, default: Date.now }
            

            
// Define mongoose model
            
const Ratings = mongoose.model('Ratings', mongooseSchema)
            

            
module.exports = Ratings


            Ref: https://codeburst.io/joi-validate-input-and-define-databases-in-javascript-84adc6f1474b
            Ref: https://github.com/yoitsro/joigoose






            share|improve this answer





















            • thanks, It solved my issue.
              – mhndev
              20 hours ago















            up vote
            1
            down vote



            accepted










            For MongoDB, mongoose can be used together with joigoose, which easily converts a Joi schema. Because joi is not a ORM



            For ex unique email validation 



            // rating.js
            
const mongoose = require('mongoose')
            
const joigoose = require('joigoose')(mongoose)
            

            
// Require the 'ratings' schema
            
const schema = require('./rating-schema')
            

            
// Convert joi to mongoose schema
            
const mongooseSchema = joigoose.convert(schema);
            

            
// Modify some fields with database specific instructions 
            
mongooseSchema.email.unique = true
            

            
// Add fields which don't make sense on the schema validator
            
mongooseSchema.updatedAt = { type: Date, default: Date.now }
            
mongooseSchema.createdAt = { type: Date, default: Date.now }
            

            
// Define mongoose model
            
const Ratings = mongoose.model('Ratings', mongooseSchema)
            

            
module.exports = Ratings


            Ref: https://codeburst.io/joi-validate-input-and-define-databases-in-javascript-84adc6f1474b
            Ref: https://github.com/yoitsro/joigoose






            share|improve this answer





















            • thanks, It solved my issue.
              – mhndev
              20 hours ago













            up vote
            1
            down vote



            accepted







            up vote
            1
            down vote



            accepted






            For MongoDB, mongoose can be used together with joigoose, which easily converts a Joi schema. Because joi is not a ORM



            For ex unique email validation 



            // rating.js
            
const mongoose = require('mongoose')
            
const joigoose = require('joigoose')(mongoose)
            

            
// Require the 'ratings' schema
            
const schema = require('./rating-schema')
            

            
// Convert joi to mongoose schema
            
const mongooseSchema = joigoose.convert(schema);
            

            
// Modify some fields with database specific instructions 
            
mongooseSchema.email.unique = true
            

            
// Add fields which don't make sense on the schema validator
            
mongooseSchema.updatedAt = { type: Date, default: Date.now }
            
mongooseSchema.createdAt = { type: Date, default: Date.now }
            

            
// Define mongoose model
            
const Ratings = mongoose.model('Ratings', mongooseSchema)
            

            
module.exports = Ratings


            Ref: https://codeburst.io/joi-validate-input-and-define-databases-in-javascript-84adc6f1474b
            Ref: https://github.com/yoitsro/joigoose






            share|improve this answer












            For MongoDB, mongoose can be used together with joigoose, which easily converts a Joi schema. Because joi is not a ORM



            For ex unique email validation 



            // rating.js
            
const mongoose = require('mongoose')
            
const joigoose = require('joigoose')(mongoose)
            

            
// Require the 'ratings' schema
            
const schema = require('./rating-schema')
            

            
// Convert joi to mongoose schema
            
const mongooseSchema = joigoose.convert(schema);
            

            
// Modify some fields with database specific instructions 
            
mongooseSchema.email.unique = true
            

            
// Add fields which don't make sense on the schema validator
            
mongooseSchema.updatedAt = { type: Date, default: Date.now }
            
mongooseSchema.createdAt = { type: Date, default: Date.now }
            

            
// Define mongoose model
            
const Ratings = mongoose.model('Ratings', mongooseSchema)
            

            
module.exports = Ratings


            Ref: https://codeburst.io/joi-validate-input-and-define-databases-in-javascript-84adc6f1474b
            Ref: https://github.com/yoitsro/joigoose







            share|improve this answer












            share|improve this answer



            share|improve this answer










            answered 21 hours ago









            Senthil

            6981515




            6981515












            • thanks, It solved my issue.
              – mhndev
              20 hours ago


















            • thanks, It solved my issue.
              – mhndev
              20 hours ago
















            thanks, It solved my issue.
            – mhndev
            20 hours ago




            thanks, It solved my issue.
            – mhndev
            20 hours ago












            up vote
            0
            down vote













            joi is simply a JSON validator tool, there is no provision of database connectivity in it.



            You can use direct DB query or ORM to check whether record present or not.






            share|improve this answer

























              up vote
              0
              down vote













              joi is simply a JSON validator tool, there is no provision of database connectivity in it.



              You can use direct DB query or ORM to check whether record present or not.






              share|improve this answer























                up vote
                0
                down vote










                up vote
                0
                down vote









                joi is simply a JSON validator tool, there is no provision of database connectivity in it.



                You can use direct DB query or ORM to check whether record present or not.






                share|improve this answer












                joi is simply a JSON validator tool, there is no provision of database connectivity in it.



                You can use direct DB query or ORM to check whether record present or not.







                share|improve this answer












                share|improve this answer



                share|improve this answer










                answered 21 hours ago









                Sanket

                333213




                333213






























                     

                    draft saved


                    draft discarded



















































                     


                    draft saved


                    draft discarded














                    StackExchange.ready(
                    function () {
                    StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53372111%2fjoi-validation-check-if-record-exists-in-database%23new-answer', 'question_page');
                    }
                    );

                    Post as a guest















                    Required, but never shown





















































                    Required, but never shown














                    Required, but never shown












                    Required, but never shown







                    Required, but never shown

































                    Required, but never shown














                    Required, but never shown












                    Required, but never shown







                    Required, but never shown







                    Popular posts from this blog

                    Can a sorcerer learn a 5th-level spell early by creating spell slots using the Font of Magic feature?

                    Image
                    28 6 $begingroup$ Per the Font of Magic feature, sorcerer can use Flexible Casting to create 5th-level spell slots at level 7, even though they are not typically available until level 9. You can transform unexpended sorcery points into one spell slot as a bonus action on your turn. The Creating Spell Slots table shows the cost of creating a spell slot of [5th level is 7] If such a sorcerer levels up while still having this 5th-level spell slot, can they choose a 5th-level spell as the spell they gain upon levelling up? The Spellcasting feature states: Additionally, when you gain a level in this class, you can choose one of the sorcerer spells you know and replace it with another spell from the sorcerer spell list, which also must be of a level for which you have spell slots.
                    Read more

                    Does disintegrating a polymorphed enemy still kill it after the 2018 errata?

                    Image
                    up vote 13 down vote favorite 1 After the 2018 errata, the disintegrate spell description now reads: A creature targeted by this spell must make a Dexterity saving throw. On a failed save, the target takes 10d6 + 40 force damage. The target is disintegrated if this damage leaves it with 0 hit points. If you were to polymorph an enemy into a rat and then disintegrate it, would the enemy be disintegrated or would it just return to its original form? I know that for Druids, it’s not an instant kill anymore, but is this the case for polymorph as well? dnd-5e spells polymorph errata share | improve this question edited 18 hours ago
                    Read more

                    A Topological Invariant for $pi_3(U(n))$

                    Image
                    3 3 $begingroup$ Recently, I saw a construction of topological invariant for $pi_3(U(n))$ with $ngeq 2$ : $$ N=frac{1}{24pi^2}int_{S^3} d^3x epsilon^{ijk} Tr[(U^{-1}partial_{x_i}U)(U^{-1}partial_{x_j}U)(U^{-1}partial_{x_k}U)] , $$ where $Uin U(n)$ depends on $boldsymbol{x}=(x_1,x_2,x_3)in S^3$ , $epsilon^{ijk}$ is the Levi-Civita symbol, $i,j,k=1,2,3$ , and the duplicated indexes are summed over. It is claimed that $N$ is an integer, but why? Update 02/02/2019 I think I got an argument for $n=2$ . In this case, $U=e^{i varphi} q$ with $qin SU(2)$ . Due to the trace and the Levi-Civita symbol in $N$ , $varphi$ does not contribute to $N$ . As $Tr[q^{dagger}partial_i q]=0$ and $(q^{dagger}partial_i q)^{dagger}=-q^{dagger}partial_i q$ , $q^{dagger}partial_i q$ in geneeral has the form $q^{dagger}partia
                    Read more