From: Jason Etheridge Date: Fri, 20 Mar 2009 20:07:03 +0000 (+0000) Subject: (no commit message) X-Git-Url: http://git.equinoxoli.org/?p=migration-tools.git;a=commitdiff_plain;h=45d8d0ac854721d9db1420ea0cf8a6a590ece6a3 --- diff --git a/sql/base/base.sql b/sql/base/base.sql index b9d4121..fd6aa41 100644 --- a/sql/base/base.sql +++ b/sql/base/base.sql @@ -4,7 +4,7 @@ -- DROP SCHEMA foo CASCADE; CREATE SCHEMA foo; -- \i base.sql -- SELECT migration_tools.init('foo'); --- SELECT migration_tools.build_default_base_staging_tables('foo'); +-- SELECT migration_tools.build('foo'); -- SELECT * FROM foo.fields_requiring_mapping; -- \d foo.actor_usr -- create some incoming ILS specific staging tables, like CREATE foo.legacy_items ( l_barcode TEXT, .. ) INHERITS foo.asset_copy; @@ -43,12 +43,12 @@ CREATE OR REPLACE FUNCTION migration_tools.init (TEXT) RETURNS VOID AS $$ END; $$ LANGUAGE PLPGSQL STRICT VOLATILE; -CREATE OR REPLACE FUNCTION migration_tools.build_default_base_staging_tables (TEXT) RETURNS VOID AS $$ +CREATE OR REPLACE FUNCTION migration_tools.build (TEXT) RETURNS VOID AS $$ DECLARE migration_schema ALIAS FOR $1; production_tables TEXT[]; BEGIN - --RAISE INFO 'In migration_tools.build_default_base_staging_tables(%)', migration_schema; + --RAISE INFO 'In migration_tools.build(%)', migration_schema; SELECT migration_tools.production_tables(migration_schema) INTO STRICT production_tables; EXECUTE migration_tools.build_base_staging_tables(migration_schema,production_tables); END;