Home / Questions / 88236
Accepted
Yoel Macia Delgado
Asked: 2020-07-21 00:21:24 +0800 CST 2020-07-21 00:21:24 +0800 CST

How can I generate models in Django from a database in MongoDB ?

  • 772

I have a huge MongoDB database and I want to generate the Django models dynamically so I don't do it by hand (it would save me a lot of work).

I have used inspectdb before to generate the models, but according to the official Django documentation, it is only available for relational databases ( PostgreSQL, MySQL and SQLite ).

Any alternative to generate models with MongoDB and import them into my models.py?

django

1 Answers

  1. Best Answer

    Thinking about this a little, I have doubts about whether it is possible. Keep in mind that a document MongoDBdoes not have to be "constant" or uniform within the same collection, which makes the automatic generation of the model complicated. For example, you might have a person collection with a document similar to this:

        {
        nombre:"pablo", 
        telefono:666555444, 
        ciudad:"Bilbao", 
        lenguajes:["java", "kotlin"]
    }

    And, in the same collection, another document:

          {
          nombre:"pedro", 
          telefono:666222333, 
          ciudad:"Madrid"
      }

    Both documents are valid, but a possible code generator would create a different model depending on which of the two documents it analyzed. In order to get a valid model for both documents you would have to parse the entire collection (which would be a problem with large collections). Let's suppose that the generator solves it in a simple way, looping through the entire collection and assuming that languages ​​can be an optional property.

    This other document would also be valid (would MongoDBallow insertion):

        {
        nombre:"luis", 
        telefono:666222333, 
        ciudad:["Lima","Bogotá"]
    }

    Here the generation logic is complicated exponentially. Some documents would have a cardinality=1 property and others would have a property with N values. Of course, this situation would be resolved if the collection were homogeneous, but MongoDBit does not guarantee it.

    These points help explain why you inspectdbwork with relational databases and not MongoDB.

    I understand that this may not be considered a valid answer, although as a comment it is unreadable, and I'll delete it if necessary.

    • 5