csv-sql 0.2.0

A simple CLI tool to generate SQL tables from CSV files
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53

# CSV-SQL
## A simple CLI tool to generate SQL tables from CSV files

- CSV-SQL will generate SQL table creation statements from CSV files, currently with TEXT data types only.
- CSV-SQL outputs to stdout. You can redirect the output to a file.

### Usage
#### Generate SQL table creation statements from CSV files
- The name of the CSV file will be used as the name of the table.
```bash
csv-sql [FILE_PATHS]...
```

#### Generate only the schema without inserting data
```bash
csv-sql --schema-only [FILE_PATHS]...
```

#### See all options
```bash
csv-sql --help
```

### Development
Use [just](https://github.com/casey/just) for easy development.
#### See all available commands
```bash
just -l
``` 
#### Build and run
```bash
just run ~/Dir/file.csv
just run "--schema-only ~/Dir/file.csv ~/Dir/file2.csv ~/Dir/file3.csv"
```
#### Clear all *.sql files in current directory
```bash
just clear
```

### TODO
- [x] Generate SQL table creation statements from CSV files with headers and TEXT data types
- [x] Output to stdout
- [x] Schema only without inserting data
- [ ] merge multiple CSV files into one SQL table
- [ ] Automatic data type detection
- [ ] Custom data types
- [ ] Primary keys
- [ ] Constraints
- [ ] Foreign keys

### Contact
- [Email: jakub@stiburek.dev](mailto:jakub@stiburek.dev)
- [LI: Jakub Stiburek](https://www.linkedin.com/in/jakubstiburekdev/)