diff options
Diffstat (limited to 'test')
| -rw-r--r-- | test/database.conf | 10 | ||||
| -rw-r--r-- | test/mysqlerl_SUITE.erl | 26 |
2 files changed, 18 insertions, 18 deletions
diff --git a/test/database.conf b/test/database.conf index 61b208d..a9c0e90 100644 --- a/test/database.conf +++ b/test/database.conf @@ -1,10 +1,10 @@ %% -*- Erlang -*- {db_info, [{name, "mysqlerl_test"}, - {host, "localhost"}, - {port, undefined}, - {username, "root"}, - {password, undefined}, - {options, []}]}. + {host, "localhost"}, + {port, undefined}, + {username, "root"}, + {password, undefined}, + {options, []}]}. {insert_data, "INSERT INTO user (username, password) VALUES (bjc, MD5('test')), (siobain, MD5('test2'))"}. diff --git a/test/mysqlerl_SUITE.erl b/test/mysqlerl_SUITE.erl index dc677b9..58591f8 100644 --- a/test/mysqlerl_SUITE.erl +++ b/test/mysqlerl_SUITE.erl @@ -113,11 +113,11 @@ end_per_group(_GroupName, _Config) -> init_per_testcase(_TestCase, Config) -> DBInfo = ct:get_config(db_info), {ok, DBRef} = mysqlerl:connect(?config(host, DBInfo), - ?config(port, DBInfo), - ?config(name, DBInfo), - ?config(username, DBInfo), - ?config(password, DBInfo), - ?config(options, DBInfo)), + ?config(port, DBInfo), + ?config(name, DBInfo), + ?config(username, DBInfo), + ?config(password, DBInfo), + ?config(options, DBInfo)), [{db_ref, DBRef} | Config]. %%-------------------------------------------------------------------- @@ -186,42 +186,42 @@ app_stops(_Config) -> describe_table(Config) -> io:format("describe_table ~p", [Config]), {ok, Description} = mysqlerl:describe_table(?config(db_ref, Config), - "user"), + "user"), [{"username", {sql_varchar, 20}}, {"password", {sql_varchar, 64}}] = Description. sql_query(Config) -> {selected, ?COLS, Rows} = mysqlerl:sql_query(?config(db_ref, Config), - ?Q), + ?Q), [{"bjc", _}, {"siobain", _}] = Rows. param_query(Config) -> {selected, ?COLS, Rows} = mysqlerl:param_query(?config(db_ref, Config), - "SELECT * FROM user WHERE username=?", - [{{sql_varchar, 20}, "bjc"}]), + "SELECT * FROM user WHERE username=?", + [{{sql_varchar, 20}, "bjc"}]), [{"bjc", _}] = Rows. select_count(Config) -> {ok, 2} = mysqlerl:select_count(?config(db_ref, Config), - "SELECT username FROM user"). + "SELECT username FROM user"). select_next(Config) -> mysqlerl:select_count(?config(db_ref, Config), ?Q), {selected, ?COLS, Rows} = mysqlerl:select(?config(db_ref, Config), - next, 1), + next, 1), [{"bjc", _}] = Rows. select_absolute(Config) -> mysqlerl:select_count(?config(db_ref, Config), ?Q), mysqlerl:next(?config(db_ref, Config)), {selected, ?COLS, Rows} = mysqlerl:select(?config(db_ref, Config), - {absolute, 1}, 1), + {absolute, 1}, 1), [{"bjc", _}] = Rows. select_relative(Config) -> mysqlerl:select_count(?config(db_ref, Config), ?Q), mysqlerl:next(?config(db_ref, Config)), {selected, ?COLS, Rows} = mysqlerl:select(?config(db_ref, Config), - {relative, 1}, 1), + {relative, 1}, 1), [{"siobain", _}] = Rows. first(Config) -> |