'''
import csv2sqltable.convert as c2s
print(c2s.transform('customer.csv'))
Output:
-------
%%sql
-- DROP TABLE customer;
CREATE TABLE customer (
customer_id VARCHAR(100),
customername VARCHAR(100),
lastname VARCHAR(100),
country VARCHAR(100),
age VARCHAR(100),
phone VARCHAR(100)
);
INSERT INTO customer (customer_id, customername, lastname, country, age, phone)
VALUES
('1', 'Shubham', 'Thakur', 'India', '23', 'xxxxxxxxxx'),
('2', 'Aman', 'Chopra', 'Australia', '21', 'xxxxxxxxxx'),
('3', 'Naveen', 'Tulasi', 'Sri Lanka', '24', 'xxxxxxxxxx'),
('4', 'Aditya', 'Arpan', 'Austria', '21', 'xxxxxxxxxx'),
('5', 'Nishant. Salchichas S.A.', 'Jain', 'Spain', '22', 'xxxxxxxxxx');
SELECT * FROM customer;
'''
Raw data
{
"_id": null,
"home_page": "https://github.com/imvickykumar999",
"name": "csv2sqltable",
"maintainer": "",
"docs_url": null,
"requires_python": "",
"maintainer_email": "",
"keywords": "csv to sql,table,database,magic sql,google colab",
"author": "Vicky Kumar",
"author_email": "",
"download_url": "https://files.pythonhosted.org/packages/e7/d2/89c3942f5f929f2f13b55da12866bb65917335466fa1df5a8d6850c7d813/csv2sqltable-0.0.4.tar.gz",
"platform": null,
"description": "'''\r\n\r\nimport csv2sqltable.convert as c2s\r\n\r\nprint(c2s.transform('customer.csv'))\r\n\r\nOutput:\r\n-------\r\n\r\n %%sql\r\n -- DROP TABLE customer;\r\n\r\n CREATE TABLE customer (\r\n customer_id VARCHAR(100),\r\n customername VARCHAR(100),\r\n lastname VARCHAR(100),\r\n country VARCHAR(100),\r\n age VARCHAR(100),\r\n phone VARCHAR(100)\r\n );\r\n\r\n INSERT INTO customer (customer_id, customername, lastname, country, age, phone)\r\n VALUES\r\n ('1', 'Shubham', 'Thakur', 'India', '23', 'xxxxxxxxxx'),\r\n ('2', 'Aman', 'Chopra', 'Australia', '21', 'xxxxxxxxxx'),\r\n ('3', 'Naveen', 'Tulasi', 'Sri Lanka', '24', 'xxxxxxxxxx'),\r\n ('4', 'Aditya', 'Arpan', 'Austria', '21', 'xxxxxxxxxx'),\r\n ('5', 'Nishant. Salchichas S.A.', 'Jain', 'Spain', '22', 'xxxxxxxxxx');\r\n\r\n SELECT * FROM customer;\r\n\r\n'''\r\n",
"bugtrack_url": null,
"license": "MIT",
"summary": "This package converts csv to sql table.",
"version": "0.0.4",
"project_urls": {
"Homepage": "https://github.com/imvickykumar999"
},
"split_keywords": [
"csv to sql",
"table",
"database",
"magic sql",
"google colab"
],
"urls": [
{
"comment_text": "",
"digests": {
"blake2b_256": "e7d289c3942f5f929f2f13b55da12866bb65917335466fa1df5a8d6850c7d813",
"md5": "8674fcc7e7a45095956824fda87f7cd2",
"sha256": "b5881adb5f7ba221e22f1a01e52a97a1d6554430e779a25995b9d9f5ec8171ba"
},
"downloads": -1,
"filename": "csv2sqltable-0.0.4.tar.gz",
"has_sig": false,
"md5_digest": "8674fcc7e7a45095956824fda87f7cd2",
"packagetype": "sdist",
"python_version": "source",
"requires_python": null,
"size": 2524,
"upload_time": "2023-06-26T07:22:26",
"upload_time_iso_8601": "2023-06-26T07:22:26.376769Z",
"url": "https://files.pythonhosted.org/packages/e7/d2/89c3942f5f929f2f13b55da12866bb65917335466fa1df5a8d6850c7d813/csv2sqltable-0.0.4.tar.gz",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2023-06-26 07:22:26",
"github": false,
"gitlab": false,
"bitbucket": false,
"codeberg": false,
"lcname": "csv2sqltable"
}
JSON