Search plugin: Or browse by category:

outth-mysql-cookbook summary

Plugin Name: outth-mysql-cookbook
Version: 0.0.7
Author: @melezhik
Realease Date: 2016-03-31 08:19:13
Short Description: outthentic tests for opscode mysql cookook
Category: chef cookbooks tests
Plugin web page: https://github.com/melezhik/outth-mysql-cookbook.git
Other versions: not available
Download link: outth-mysql-cookbook-v0.000007.tar.gz
Latest version link: https://sparrowhub.org/info/outth-mysql-cookbook

outth-mysql-cookbook documentation

outth-mysql-cookbook doc

SYNOPSIS

outthentic smoke tests for opscode mysql cookbook

Check list

  • verifies that select User,Host from mysql.user return valid data

  • verifies that simple CRUD operations work

    • create,delete database
    • create table
    • insert into table
    • select from table

Sample Output

/tmp/.outthentic/14686/root/sparrow/plugins/public/outth-mysql-cookbook/mysql_user_select/story.t .. 

ok 1 - stdout is already set

ok 2 - stdout saved to /tmp/.outthentic/14686/EfoyVGcntN

ok 3 - [b] output match 'SELECT Host,User FROM user WHERE User='root' AND Host='127.0.0.1''

ok 4 - [b] output match 'Host : 127.0.0.1 User: root'

ok 5 - [b] output match 'SELECT Host,User FROM user WHERE User='root' AND Host='localhost''

ok 6 - [b] output match 'Host : localhost User: root'

1..6

ok

/tmp/.outthentic/14686/root/sparrow/plugins/public/outth-mysql-cookbook/simple-crud/story.t ........ 

ok 1 - stdout is already set

ok 2 - stdout saved to /tmp/.outthentic/14686/Sig0rIX48S

ok 3 - [b] output match 'create database foo'

ok 4 - [b] output match 'Affected row: 1'

ok 5 - [b] output match 'create table foo.bar (name text)'

ok 6 - [b] output match 'Affected row: 0'

ok 7 - [b] output match 'insert into foo.bar (name) values ('alexey')'

ok 8 - [b] output match 'Affected row: 1'

ok 9 - [b] output match 'SELECT name from foo.bar'

ok 10 - [b] output match 'Name : alexey'

1..10

ok

All tests successful.

Files=2, Tests=16,  0 wallclock secs ( 0.01 usr  0.00 sys +  0.08 cusr  0.00 csys =  0.09 CPU)

Result: PASS

Author

Alexey Melezhik