Mobile Technologies Web Technologies Digital Marketing Creative Design Career Talk Medical General Tech Interviews Internet Of Things

Popular Categories

All
Interview Questions
Question Bank
Quantitative Aptitude
Engineering
Govt Exams
Digital Marketing
Management
Interviews

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

General Tech Bugs & Fixes 3 years ago

38 1 0 0 0
author
Previous Next

User submissions are the sole responsibility of contributors, with TuteeHUB disclaiming liability for accuracy, copyrights, or consequences of use; content is for informational purposes only and not professional advice.

Answers (1)

Post Answer
profilepic.png
manpreet Tuteehub forum best answer Best Answer 3 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
                                                            shares

No matter what stage you're at in your education or career, TuteeHUB will help you reach the next level that you're aiming for. Simply,Choose a subject/topic and get started in self-paced practice sessions to improve your knowledge and scores.

Similar Forum

Q

Which operating system you favour and why?

Q

What are the most popular tech portals in India?

Q

What are best technologies available today for education / aiding learning?

View All

Explore Other Libraries

Online Exams

Question Bank

Career News

Feeds

Full Forms

Dictionary

Interview Question

Gigs

Quotes

Lyrics

Videos

Courses

Blogs

Tutorials

Forum

Educators

Corporates

Tools

Related Searches

General Tech Bugs & Fixes

Important General Tech Links

Bugs & Fixes
Technology & Software
Learning Aids/Tools
QA/Testing