Generate “create table” script (which can be execute later) using json string

manpreet Best Answer 2 years ago

I have create a DDL using the json string, which will help DBA to create table.. If someone can suggest any existing library which does this or any shorter code which will help to create the DDL..

Below is my json which i have used to create "create table" script.

{
  "person_address" : {
    "type" : "object",
    "required" : [ "person_id", "address_type" ],
    "primaryKey" : [ "person_id, address_type" ],
    "foreignKeys" : [ {
      "fields" : "person_id",
      "reference" : {
        "fields" : "person_id",
        "resource" : "person"
      }
    } ],
    "properties" : {
      "end_date" : {
        "type" : "date",
        "description" : null
      },
      "zip" : {
        "type" : "string",
        "description" : "The postal code of the address",
        "minLength" : 1,
        "maxLength" : 10
      },
      "country" : {
        "type" : "string",
        "description" : "The country of the address",
        "minLength" : 1,
        "maxLength" : 10
      },
      "line4" : {
        "type" : "string",
        "description" : "The line 4 of the address",
        "minLength" : 1,
        "maxLength" : 20
      },
      "address_type" : {
        "type" : "string",
        "description" : "The type of address for the person",
        "minLength" : 1,
        "maxLength" : 2147483647
      },
      "city" : {
        "type" : "string",
        "description" : "The city of the address",
        "minLength" : 1,
        "maxLength" : 10
      },
      "status_type" : {
        "type" : "string",
        "description" : null,
        "minLength" : 1,
        "maxLength" : 100
      },
      "language_code" : {
        "type" : "string",
        "description" : null,
        "minLength" : 1,
        "maxLength" : 100
      },
      "effective_date" : {
        "type" : "date",
        "description" : null
      },
      "state" : {
        "type" : "string",
        "description" : "The state of the address",
        "minLength" : 1,
        "maxLength" : 10
      },
      "line3" : {
        "type" : "string",
        "description" : "The line 3 of the address",
        
                                                

                                                                                                        
                                                    
                                                
                                                


                                                    

                                                        
                                                            0
                                                            views 

                                                            0
                                                                likes 
                                                            
                                                            

                                                            0
                                                            shares

                                                            


    

         Facebook
        
         Twitter
        
        
         Linked In 
        
          WhatsApp