view release on metacpan or  search on metacpan

t/creates.t  view on Meta::CPAN

        DRIVERMODE       => "MULTIPROCESS",
        EXECMODE         => "SYNCHRONOUS",
        USEEXTENDEDFETCH => "TRUE",
        USEPARAMQUERIES  => "TRUE",
        MAXCANCELATTEMPT => "number_of_seconds",
        MAXQUERYEXEC     => "number_of_seconds",
        MAXCONNATTEMPT   => "number_of_seconds",
        CHARSETENCODING  => "MULTIBYTE",
        TIMEOUT          => "number_of_seconds",
        IDLETIMEOUT      => "number_of_seconds"
    ),
'CREATE DBCONNECTION "dbconnection_name" ODBCDSN "odbc_datasource_name" DEFAULTLOGIN "default_login" DRIVERMODE MULTIPROCESS EXECMODE SYNCHRONOUS USEEXTENDEDFETCH TRUE USEPARAMQUERIES TRUE MAXCANCELATTEMPT number_of_seconds MAXQUERYEXEC number_of_sec...
    "create_dbconnection"
);

is(
    $foo->create_dbinstance(
        DBINSTANCE        => "dbinstance_name",
        DBCONNTYPE        => "dbconnection_type",
        DBCONNECTION      => "dbconnection_name",
        DESCRIPTION       => "description",
        DATABASE          => "database_name",
        TABLESPACE        => "tablespace_name",
        PRIMARYDBINSTANCE => "dbinstance_name",
        DATAMART          => "dbinstance_name",
        TABLEPREFIX       => "table_prefix",
        HIGHTHREADS       => "no_high_conns",
        MEDIUMTHREADS     => "no_medium_conns",
        LOWTHREADS        => "no_low_conns"
    ),
'CREATE DBINSTANCE "dbinstance_name" DBCONNTYPE "dbconnection_type" DBCONNECTION "dbconnection_name" DESCRIPTION "description" DATABASE "database_name" TABLESPACE "tablespace_name" PRIMARYDBINSTANCE "dbinstance_name" DATAMART "dbinstance_name" TABLEP...
    "create_dbinstance"
);

is(
    $foo->create_dblogin(
        DBLOGIN  => "dblogin_name",
        LOGIN    => "database_login",
        PASSWORD => "database_pwd"
    ),
'CREATE DBLOGIN "dblogin_name" LOGIN "database_login" PASSWORD "database_pwd";',
    "create_dblogin"
);

is(
    $foo->create_event(
        EVENT       => "event_name",
        DESCRIPTION => "description"
    ),
    'CREATE EVENT "event_name" DESCRIPTION "description";',
    "create_event"
);

is(
    $foo->create_fact(
        FACT            => "fact_name",
        DESCRIPTION     => "description",
        LOCATION        => "location_path",
        HIDDEN          => "TRUE",
        EXPRESSION      => "expression",
        EXPSOURCETABLES => [ "sourcetable1", "sourcetableN" ],
        PROJECT         => "project_name"
    ),
'CREATE FACT "fact_name" DESCRIPTION "description" IN FOLDER "location_path" HIDDEN TRUE EXPRESSION "expression" EXPSOURCETABLES "sourcetable1", "sourcetableN" FOR PROJECT "project_name";',
    "create_fact"
);

is(
    $foo->create_filter_oultine(
        FILTER      => "filter_name",
        LOCATION    => "location_path",
        EXPRESSION  => "expression",
        DESCRIPTION => "description",
        HIDDEN      => "TRUE",
        PROJECT     => "project_name"
    ),
'CREATE FILTER "filter_name" IN FOLDER "location_path" EXPRESSION "expression" DESCRIPTION "description" HIDDEN TRUE ON PROJECT "project_name";',
    "create_filter_oultine"
);

is(
    $foo->create_folder(
        FOLDER      => "folder_name",
        LOCATION    => "location_path",
        DESCRIPTION => "description",
        HIDDEN      => "TRUE",
        PROJECT     => "project_name"
    ),
'CREATE FOLDER "folder_name" IN "location_path" DESCRIPTION "description" HIDDEN TRUE FOR PROJECT "project_name";',
    "create_folder"
);

is(
    $foo->create_metric_oultine(
        METRIC      => "metric_name",
        LOCATION    => "location_path",
        EXPRESSION  => "expression",
        DESCRIPTION => "description",
        HIDDEN      => "TRUE",
        PROJECT     => "project_name"
    ),
'CREATE METRIC "metric_name" IN FOLDER "location_path" EXPRESSION "expression" DESCRIPTION "description" HIDDEN TRUE ON PROJECT "project_name";',
    "create_metric_oultine"
);

is(
    $foo->create_schedule(
        SCHEDULE            => "Schedule9",
        STARTDATE           => "09/10/2002",
        ENDDATE             => "NEVER",
        TYPE                => "TIMETRIGGERED",
        YEARLY              => "SECOND SATURDAY OF MAY",
        EXECUTE_TIME_OF_DAY => "09:00",
    ),
'CREATE SCHEDULE "Schedule9" STARTDATE 09/10/2002 ENDDATE NEVER TYPE TIMETRIGGERED YEARLY SECOND SATURDAY OF MAY EXECUTE 09:00;',
    "create_schedule"
);

is(
    $foo->create_schedule_relation(
        SCHEDULE                 => "Schedule1",
        USER_OR_GROUP            => "USER",
        USER_LOGIN_OR_GROUP_NAME => "jen",
        REPORT                   => "rep_or_doc_name",