Metadata-Version: 2.1
Name: csv2sqltable
Version: 0.0.4
Summary: This package converts csv to sql table.
Home-page: https://github.com/imvickykumar999
Author: Vicky Kumar
License: MIT
Keywords: csv to sql,table,database,magic sql,google colab
License-File: License.txt

'''

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;

'''
