Generated create table DDL from header rows of delimited files.

header2ddl

#!/bin/bash

delim=$1
for file in *.tsv
do
  name=${file%.tsv}
  columns=`head -n1 $file`
  echo -n "CREATE TABLE $name ("
    arr=$(echo $columns | tr $delim "\n")
    first=1
    for column in $arr
    do
      if [ $first -eq 1 ] ; then nl="" ; pk=" primary key" ; nu="not null" ; else nl=","; pk="" ;nu="null" ; fi
      echo $nl
      echo -n "  $column text $nu$pk"
      first=0
    done
  echo ""
  echo ");"
done