jtgoldstone
jtgoldstone
/ csv2sql.py
Created
January 4, 2026 23:09
Python code to make SQLite to import CSV data
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| import csv | |
| import subprocess | |
| import shutil | |
| import os | |
| import argparse | |
| import sys | |
| from pathlib import Path | |
| def get_best_type(current_type, value): | |
| """Determines the most restrictive SQLite type (INTEGER -> REAL -> TEXT).""" |