@echo off

if not exist output md output

gsqlcmd make-fmt                cashbook.csv    output\cashbook.fmt         /echo

gsqlcmd make-create             cashbook.csv    output\cashbook.create.sql  /table=cashbook /fmt=output\cashbook.fmt /sqlce /echo

gsqlcmd make-select             cashbook.csv    output\cashbook.select.sql  /table=cashbook /fmt=output\cashbook.fmt /sqlce /echo

gsqlcmd make /insert cashbook   cashbook.csv    output\cashbook.insert.sql  /table=cashbook /fmt=output\cashbook.fmt /insertIdentity /echo

gsqlcmd make /merge  cashbook   cashbook.csv    output\cashbook.merge.sql   /table=cashbook /fmt=output\cashbook.fmt /echo

gsqlcmd make /update cashbook   cashbook.csv    output\cashbook.update.sql  /table=cashbook /fmt=output\cashbook.fmt /echo

gsqlcmd make /delete cashbook   cashbook.csv    output\cashbook.delete.sql  /table=cashbook /fmt=output\cashbook.fmt /echo

start output

@pause
