@echo off

if not exist import md import

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

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

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

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

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

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

start import

@pause
