/*
 * Run with either one of those commands:
 *
 * DBPATH=sqlite/sqlite.db ./build/bin/pgloader ./test/sqlite-env.load
 * ./build/bin/pgloader --context ./test/sqlite.ini ./test/sqlite-ini.load
 *
 */

load database
     from '{{DBPATH}}'
     into postgresql:///pgloader

 -- with include drop, create tables, create indexes, reset sequences

  before load do
    $$ drop schema if exists sqlite cascade; $$,
    $$ create schema if not exists sqlite; $$

  cast column character.f1 to text drop typemod,
       column appointments.time to timestamptz drop default,
       type intege to integer,
       type character to varchar keep typemod

  set work_mem to '16MB',
      maintenance_work_mem to '512 MB',
      search_path to 'sqlite';