Packages

jamdb_oracle

0.3.0
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
2 Dependencies
Dependants
Files
Activity
jamdb_oracle test jamdb_oracle_test.erl
Raw

test/jamdb_oracle_test.erl 

-module(jamdb_oracle_test).



-include("jamdb_oracle_test.hrl").



-compile(export_all).



-define(query(ConnRef,Query), jamdb_oracle:sql_query(ConnRef,Query)).



%% Test callbacks



all() ->

    {ok, ConnRef} = jamdb_oracle:start(?ConnOpts),

    

    {ok, [{affected_rows,0}]} = 

    ?query(ConnRef, "create table t_number ( C_NUMBER NUMBER )"),



    {ok,[]} =

    ?query(ConnRef, {"FETCH", [1]}),           %FETCH SIZE



    {ok,[]} =

    ?query(ConnRef, "COMOFF;"),                %AUTOCOMMIT OFF



    {ok, [{affected_rows,1}]} = 

    ?query(ConnRef, {"insert into t_number values ( :1)", [1]}),

    {ok,[]} =

    ?query(ConnRef, "ROLLBACK;"),

    {ok,[{result_set,[<<"S">>],[],[[null]]}]} =

    ?query(ConnRef, "select sum(C_NUMBER) S from t_number"),



    {ok, [{affected_rows,1}]} = 

    ?query(ConnRef, {"insert into t_number values ( :1)", [1]}),

    {ok, [{affected_rows,1}]} = 

    ?query(ConnRef, {"insert into t_number values ( :1)", [1]}),

    {ok,[]} =

    ?query(ConnRef, "COMMIT;"),

    {ok,[{result_set,[<<"S">>],[],[[{2}]]}]} =

    ?query(ConnRef, "select sum(C_NUMBER) S from t_number"),



    {ok,[]} =

    ?query(ConnRef, "COMON;"),                 %AUTOCOMMIT ON



    {ok, [{affected_rows,1}]} = 

    ?query(ConnRef, {"insert into t_number values ( :1)", [1]}),

    {ok,[{result_set,[<<"S">>],[],[[{3}]]}]} =

    ?query(ConnRef, "select sum(C_NUMBER) S from t_number"),



    {ok,[]} =

    ?query(ConnRef, "COMOFF"),                 %AUTOCOMMIT OFF



    {ok, [{affected_rows,1}]} = 

    ?query(ConnRef, {"insert into t_number values ( :1)", [1]}),

    {ok, [{affected_rows,0}]} =

    ?query(ConnRef, "SAVEPOINT SVPT"),

    {ok, [{affected_rows,1}]} = 

    ?query(ConnRef, {"insert into t_number values ( :1)", [1]}),

    {ok, [{affected_rows,1}]} = 

    ?query(ConnRef, {"insert into t_number values ( :1)", [1]}),

    {ok, [{affected_rows,0}]} =

    ?query(ConnRef, "ROLLBACK TO SVPT"),

    {ok, [{affected_rows,1}]} = 

    ?query(ConnRef, {"insert into t_number values ( :1)", [1]}),

    {ok,[]} =

    ?query(ConnRef, "COMMIT"),

    {ok,[{result_set,[<<"S">>],[],[[{5}]]}]} =

    ?query(ConnRef, "select sum(C_NUMBER) S from t_number"),

            

    {ok, [{affected_rows,0}]} = 

    ?query(ConnRef, "drop table t_number"),

    

    ok = jamdb_oracle:stop(ConnRef).