{ "info": { "author": "Arghadeep Chaudhury,Siddhartha Bhattacharya", "author_email": "siddhbhatt@gmail.com,arghadeep.chaudhury@gmail.com", "bugtrack_url": null, "classifiers": [ "License :: OSI Approved :: MIT License", "Operating System :: OS Independent", "Programming Language :: Python :: 3" ], "description": "# JSON Utils Package (DDLj)\nThis is a python package having multiple utilities for handling JSON Files. \n\nModule1 - DDLj : Converts JSON Schema Files into ANSI SQL DDLs\nSupports foll databases: \nA.PostgreSQL\nB.MYSQL\nC.DB2\nD.MariaDB\nE.Oracle\n~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~\nUsage:\n~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~\npip install DDLJ\n\npython\n\n>>> from DDLj import genddl\n\n>>> genddl(*param1,param2,*param3,*param4)\n\nWhere \n\nparam1= JSON Schema File\n\nparam2=Database (Default Oracle)\n\nParam3= Glossary file\n\nParam4= DDL output script\n\nNote : * indicates mandatory parameters\n\nIt also includes a Flask module for front-end if used as a standalone tool. Refer to App directory.\n*******************************************\n~~~~~~~~~~~~~~~~~~~~~~~~~~~\nExample:\n~~~~~~~~~~~~~~~~~~~~~~~~~~~~\nInput JSON schema as:\n{\n\t\"schema\": \"Http://Json-Schema.Org/Draft-07/Schema#\",\n\t\"type\": \"object\",\n\t\"title\": \"TableNameTest\",\n\t\"additionalProperties\": false,\n\t\"properties\": {\n\t\t\"ColumnNameOne\": {\n\t\t\t\"type\": \"string\",\n\t\t\t\"maxLength\": 10\n\t\t},\n\t\t\"ColumnNameTwo\": {\n\t\t\t\"type\": \"string\",\n\t\t\t\"format\": \"date-time\"\n\t\t},\n\t\t\"ColumnNameThree\": {\n\t\t\t\"type\": \"string\",\n\t\t\t\"maxLength\": 200\n\t\t},\n\t\t\"ColumnNameFour\": {\n\t\t\t\"type\": \"string\",\n\t\t\t\"maxLength\": 300\n\t\t},\n\t\t\"ColumnNameFive\": {\n\t\t\t\"type\": \"string\",\n\t\t\t\"format\": \"date\"\n\t\t},\n\t\t\"ColumnNameSix\": {\n\t\t\t\"type\": \"number\"\n\t\t},\n\t\t\"ColumnNameSeven\": {\n\t\t\t\"type\": \"number\"\n\t\t},\n\t\t\"ColumnNameEight\": {\n\t\t\t\"type\": \"string\",\n\t\t\t\"maxLength\": 1000\n\t\t},\n\t\t\"ColumnNameNine\": {\n\t\t\t\"type\": \"string\",\n\t\t\t\"maxLength\": 2000\n\t\t},\n\t\t\"ColumnNameTen\": {\n\t\t\t\"type\": \"number\"\n\t\t}\n\t}\n}\n\nCode Usage:\n>>> from DDLj import genddl\n>>> genddl('TestJsonSchema.json','Oracle','GlossaryTestFile.csv','GenDDLGlossary.sql')\n\nOutput:\nCreate Table TableNameTest (COL_NAM_One Varchar2(10),\nCOL_NAM_Two Timestamp(6),\nCOL_NAM_Three Varchar2(200),\nCOL_NAM_Four Varchar2(300),\nCOL_NAM_Five Date,\nCOL_NAM_Six Number(38,10),\nCOL_NAM_Seven Number(38,10),\nCOL_NAM_Eight Varchar2(1000),\nCOL_NAM_Nine Varchar2(2000),\nCOL_NAM_Ten Number(38,10));\n\nPlease see the Test Folder for JSON schema, glossary file and output.\n****************************\n\nNote: Other modules to come soon.\n\n", "description_content_type": "text/markdown", "docs_url": null, "download_url": "", "downloads": { "last_day": -1, "last_month": -1, "last_week": -1 }, "home_page": "https://github.com/deepstartup/jsonutils", "keywords": "", "license": "", "maintainer": "", "maintainer_email": "", "name": "DDLJ", "package_url": "https://pypi.org/project/DDLJ/", "platform": "", "project_url": "https://pypi.org/project/DDLJ/", "project_urls": { "Homepage": "https://github.com/deepstartup/jsonutils" }, "release_url": "https://pypi.org/project/DDLJ/0.0.3/", "requires_dist": [ "pandas", "flatten-json" ], "requires_python": "", "summary": "JSON Utils for generating DDL from JSON Schema", "version": "0.0.3" }, "last_serial": 5475139, "releases": { "0.0.1": [ { "comment_text": "", "digests": { "md5": "d1933d2fc8b7c90095dfa756465274ab", "sha256": "485ed8900602ed0d5248947ebd6e68c8b0308123cd0098558166e9d57d8b7744" }, "downloads": -1, "filename": "DDLJ-0.0.1-py3-none-any.whl", "has_sig": false, "md5_digest": "d1933d2fc8b7c90095dfa756465274ab", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 4558, "upload_time": "2019-06-30T21:03:40", "url": "https://files.pythonhosted.org/packages/40/d7/a3f10017c08799dee95863fc8e92e5de6057c396f2d7a5bd1392d76646fd/DDLJ-0.0.1-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "dca69ca21b9596f1352d8c433ba4fa2f", "sha256": "d6a1b372d0dd0d1e49fc385ef1bf2363e588ace98429e855f568fd0d19e3614c" }, "downloads": -1, "filename": "DDLJ-0.0.1.tar.gz", "has_sig": false, "md5_digest": "dca69ca21b9596f1352d8c433ba4fa2f", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 3230, "upload_time": "2019-06-30T21:03:43", "url": "https://files.pythonhosted.org/packages/48/9d/ded0be80389d14d64636cf99058237f88494c7b10ca2b421e56f0c6cdeac/DDLJ-0.0.1.tar.gz" } ], "0.0.2": [ { "comment_text": "", "digests": { "md5": "00a03f6d02930f38c70b4f35d661f01a", "sha256": "48e7b1cf691842fdf2e0f3f452799a19b355c8e8150316c969ad50d022306f40" }, "downloads": -1, "filename": "DDLJ-0.0.2-py3-none-any.whl", "has_sig": false, "md5_digest": "00a03f6d02930f38c70b4f35d661f01a", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 4598, "upload_time": "2019-06-30T22:34:21", "url": "https://files.pythonhosted.org/packages/fd/2d/9214e35b2efb797d603718106bd71f11cef279549c3cc1a21c82abd444a6/DDLJ-0.0.2-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "5069b6d756bb31ed8800605d49fa8f15", "sha256": "7f97a8cf5fc678cb242856724e5a36166a4c38b1d786924591f2f7028d0bd94c" }, "downloads": -1, "filename": "DDLJ-0.0.2.tar.gz", "has_sig": false, "md5_digest": "5069b6d756bb31ed8800605d49fa8f15", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 3252, "upload_time": "2019-06-30T22:34:22", "url": "https://files.pythonhosted.org/packages/33/c4/0de44655f06f23c21f72d0d52682a9da9129def905578ad40bde928c34c4/DDLJ-0.0.2.tar.gz" } ], "0.0.3": [ { "comment_text": "", "digests": { "md5": "6207e41a675569c5cae5af77cabfb9ef", "sha256": "a17374e85c43876158e1601be8c8a928b181f2201e7e66fa4c2d6c25d57f92dd" }, "downloads": -1, "filename": "DDLJ-0.0.3-py3-none-any.whl", "has_sig": false, "md5_digest": "6207e41a675569c5cae5af77cabfb9ef", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 5247, "upload_time": "2019-07-02T05:41:08", "url": "https://files.pythonhosted.org/packages/ce/ee/965cae0ad682f82dea39f9a8a32f2cb258485b09c491741736e6dde43b44/DDLJ-0.0.3-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "a51a8188e28e561a2ea02c226e2889a4", "sha256": "7cc8215da970c180910bddb6163f0c9a13ed735b4bf9fe8b28653bddaad1de1f" }, "downloads": -1, "filename": "DDLJ-0.0.3.tar.gz", "has_sig": false, "md5_digest": "a51a8188e28e561a2ea02c226e2889a4", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 4205, "upload_time": "2019-07-02T05:41:10", "url": "https://files.pythonhosted.org/packages/38/de/4e8a3c42341b4a2c0710dbcdc49339da885e5c753a703bc5bf6af24340c6/DDLJ-0.0.3.tar.gz" } ] }, "urls": [ { "comment_text": "", "digests": { "md5": "6207e41a675569c5cae5af77cabfb9ef", "sha256": "a17374e85c43876158e1601be8c8a928b181f2201e7e66fa4c2d6c25d57f92dd" }, "downloads": -1, "filename": "DDLJ-0.0.3-py3-none-any.whl", "has_sig": false, "md5_digest": "6207e41a675569c5cae5af77cabfb9ef", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 5247, "upload_time": "2019-07-02T05:41:08", "url": "https://files.pythonhosted.org/packages/ce/ee/965cae0ad682f82dea39f9a8a32f2cb258485b09c491741736e6dde43b44/DDLJ-0.0.3-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "a51a8188e28e561a2ea02c226e2889a4", "sha256": "7cc8215da970c180910bddb6163f0c9a13ed735b4bf9fe8b28653bddaad1de1f" }, "downloads": -1, "filename": "DDLJ-0.0.3.tar.gz", "has_sig": false, "md5_digest": "a51a8188e28e561a2ea02c226e2889a4", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 4205, "upload_time": "2019-07-02T05:41:10", "url": "https://files.pythonhosted.org/packages/38/de/4e8a3c42341b4a2c0710dbcdc49339da885e5c753a703bc5bf6af24340c6/DDLJ-0.0.3.tar.gz" } ] }