Packages

jamdb_oracle

0.1.1
0.5.12 0.5.11 0.5.10 0.5.9 0.5.8 0.5.7 0.5.6 0.5.5 0.5.4 0.5.3 0.5.2 retired 0.5.1 retired 0.5.0 retired 0.4.12 retired 0.4.11 retired 0.4.10 retired 0.4.9 retired 0.4.8 retired 0.4.7 retired 0.4.6 retired 0.4.5 retired 0.4.4 retired 0.4.3 retired 0.4.2 retired 0.4.1 retired 0.4.0 retired 0.3.10 retired 0.3.9 retired 0.3.8 retired 0.3.7 retired 0.3.6 retired 0.3.5 retired 0.3.4 retired 0.3.3 retired 0.3.2 retired 0.3.1 retired 0.3.0 retired 0.2.7 retired 0.2.6 retired 0.2.5 retired 0.2.4 retired 0.2.3 retired 0.2.2 retired 0.2.1 retired 0.2.0 retired 0.1.6 retired 0.1.5 retired 0.1.4 retired 0.1.3 retired 0.1.2 retired 0.1.1 retired 0.1.0 retired 0.0.10 retired 0.0.9 retired 0.0.8 retired 0.0.7 retired 0.0.6 retired 0.0.5 retired 0.0.4 retired 0.0.3 retired 0.0.2 retired 0.0.1 retired

Erlang driver and Ecto adapter for Oracle

Retired package: Deprecated
HexDocs

Current section

Files

Jump to
Readme
62 Versions
3 Dependencies
Dependants
Files
Activity
jamdb_oracle test jamdb_oracle_dba.erl
Raw

test/jamdb_oracle_dba.erl 

-module(jamdb_oracle_dba).



-include("jamdb_oracle_test.hrl").



-compile(export_all).



%% To use this module, you must set the DEF_TIMEOUT to infinity.



startdb() ->                     % as sysdba prelim auth

    {ok, ConnRef} = jamdb_oracle:start([{role, 1},{prelim, 1}]++?ConnOpts),



    {ok,[_]} =                   %mode 0 norestrict, 1 restrict, 16 force

    jamdb_oracle:sql_query(ConnRef, {"START", [0]}),

    

    ok = jamdb_oracle:stop(ConnRef).



mountdb() ->                     % as sysdba

    {ok, ConnRef} = jamdb_oracle:start([{role, 1}]++?ConnOpts),



    {ok,[_]} =

    jamdb_oracle:sql_query(ConnRef, "ALTER DATABASE MOUNT"),



    {ok,[_]} =

    jamdb_oracle:sql_query(ConnRef, "ALTER DATABASE OPEN"),



    ok = jamdb_oracle:stop(ConnRef).

    

stopdb() ->                     % as sysdba

    {ok, ConnRef} = jamdb_oracle:start([{role, 1}]++?ConnOpts),



    {ok,[_]} =                  %mode 2 immediate, 4 normal, 8 final, 64 abort, 128 tran

    jamdb_oracle:sql_query(ConnRef, {"STOP", [2]}),



    {ok,[_]} =

    jamdb_oracle:sql_query(ConnRef, "ALTER DATABASE CLOSE NORMAL"),



    {ok,[_]} =

    jamdb_oracle:sql_query(ConnRef, "ALTER DATABASE DISMOUNT"),



    {ok,[_]} =

    jamdb_oracle:sql_query(ConnRef, {"STOP", [8]}),

    

    ok.