#1 Add CI tests using the standard test interface
Merged 4 years ago by pkubat. Opened 4 years ago by sturivny.
git://fedorapeople.org/~sturivny/sqlite new_tests  into  master

Add CI tests using the standard test interface
Serhii Turivny • 4 years ago  
tests/basic/Makefile
file added
+63
@@ -0,0 +1,63 @@

+ # ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

+ #

+ #   Makefile of /CoreOS/sqlite3/Sanity/basic

+ #   Description: Basic test for python and sqlite3 DB

+ #   Author: Branislav Nater <bnater@redhat.com>

+ #

+ # ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

+ #

+ #   Copyright (c) 2013 Red Hat, Inc. All rights reserved.

+ #

+ #   This copyrighted material is made available to anyone wishing

+ #   to use, modify, copy, or redistribute it subject to the terms

+ #   and conditions of the GNU General Public License version 2.

+ #

+ #   This program is distributed in the hope that it will be

+ #   useful, but WITHOUT ANY WARRANTY; without even the implied

+ #   warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR

+ #   PURPOSE. See the GNU General Public License for more details.

+ #

+ #   You should have received a copy of the GNU General Public

+ #   License along with this program; if not, write to the Free

+ #   Software Foundation, Inc., 51 Franklin Street, Fifth Floor,

+ #   Boston, MA 02110-1301, USA.

+ #

+ # ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

+ 

+ export TEST=/CoreOS/sqlite3/Sanity/basic

+ export TESTVERSION=1.0

+ 

+ BUILT_FILES=

+ 

+ FILES=$(METADATA) runtest.sh Makefile PURPOSE sqlite3-test.py

+ 

+ .PHONY: all install download clean

+ 

+ run: $(FILES) build

+ 	./runtest.sh

+ 

+ build: $(BUILT_FILES)

+ 	test -x runtest.sh || chmod a+x runtest.sh

+ 

+ clean:

+ 	rm -f *~ $(BUILT_FILES)

+ 

+ 

+ include /usr/share/rhts/lib/rhts-make.include

+ 

+ $(METADATA): Makefile

+ 	@echo "Owner:           Branislav Nater <bnater@redhat.com>" > $(METADATA)

+ 	@echo "Name:            $(TEST)" >> $(METADATA)

+ 	@echo "TestVersion:     $(TESTVERSION)" >> $(METADATA)

+ 	@echo "Path:            $(TEST_DIR)" >> $(METADATA)

+ 	@echo "Description:     Basic test for python and sqlite DB" >> $(METADATA)

+ 	@echo "Type:            Sanity" >> $(METADATA)

+ 	@echo "TestTime:        5m" >> $(METADATA)

+ 	@echo "RunFor:          sqlite3" >> $(METADATA)

+ 	@echo "Requires:        python sqlite" >> $(METADATA)

+ 	@echo "Priority:        Normal" >> $(METADATA)

+ 	@echo "License:         GPLv2" >> $(METADATA)

+ 	@echo "Confidential:    no" >> $(METADATA)

+ 	@echo "Destructive:     no" >> $(METADATA)

+ 

+ 	rhts-lint $(METADATA)

tests/basic/PURPOSE
file added
+3
@@ -0,0 +1,3 @@

+ PURPOSE of /CoreOS/sqlite3/Sanity/basic

+ Description: Basic test for python and sqlite3 DB

+ Author: Branislav Nater <bnater@redhat.com>

tests/basic/runtest.sh
file added
+57
@@ -0,0 +1,57 @@

+ #!/bin/bash

+ # vim: dict=/usr/share/beakerlib/dictionary.vim cpt=.,w,b,u,t,i,k

+ # ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

+ #

+ #   runtest.sh of /CoreOS/sqlite3/Sanity/basic

+ #   Description: Basic test for python and sqlite3 DB

+ #   Author: Branislav Nater <bnater@redhat.com>

+ #

+ # ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

+ #

+ #   Copyright (c) 2013 Red Hat, Inc. All rights reserved.

+ #

+ #   This copyrighted material is made available to anyone wishing

+ #   to use, modify, copy, or redistribute it subject to the terms

+ #   and conditions of the GNU General Public License version 2.

+ #

+ #   This program is distributed in the hope that it will be

+ #   useful, but WITHOUT ANY WARRANTY; without even the implied

+ #   warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR

+ #   PURPOSE. See the GNU General Public License for more details.

+ #

+ #   You should have received a copy of the GNU General Public

+ #   License along with this program; if not, write to the Free

+ #   Software Foundation, Inc., 51 Franklin Street, Fifth Floor,

+ #   Boston, MA 02110-1301, USA.

+ #

+ # ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

+ 

+ # Include rhts environment

+ . /usr/bin/rhts-environment.sh

+ . /usr/lib/beakerlib/beakerlib.sh

+ 

+ PACKAGES=${PACKAGES:-"python2 sqlite"}

+ REQUIRES=${REQUIRES:-sqlite}

+ PYTHON=${PYTHON:-python}

+ 

+ rlJournalStart

+   rlPhaseStartSetup

+     rlAssertRpm --all

+     rlAssertBinaryOrigin $PYTHON

+     rlRun "TmpDir=\$(mktemp -d)" 0 "Creating tmp directory"

+     rlRun "cp sqlite3-test.py $TmpDir" 0 "Copy test script to $TmpDir"

+     rlRun "pushd $TmpDir"

+   rlPhaseEnd

+ 

+   rlGetTestState && {

+     rlPhaseStartTest

+         rlRun "$PYTHON sqlite3-test.py"

+     rlPhaseEnd

+   }

+ 

+   rlPhaseStartCleanup

+     rlRun "popd"

+     rlRun "rm -r $TmpDir" 0 "Removing tmp directory"

+   rlPhaseEnd

+ rlJournalEnd

+ rlJournalPrintText

tests/basic/sqlite3-test.py
file added
+37
@@ -0,0 +1,37 @@

+ #!/usr/bin/python

+ 

+ import sqlite3

+ import sys

+ 

+ conn = None

+ 

+ try:

+     conn = sqlite3.connect('test.db')

+ 

+     cur = conn.cursor()

+ 

+     cur.execute('SELECT SQLITE_VERSION()')

+     ver = cur.fetchone()

+     print("SQLite version: %s" % ver)

+ 

+     # Create a new table 'Writers'

+     cur.execute("CREATE TABLE Writers(Id INTEGER PRIMARY KEY AUTOINCREMENT, \

+              Name VARCHAR(25))")

+     cur.execute("INSERT INTO Writers(Name) VALUES('Jack London')")

+     cur.execute("INSERT INTO Writers(Name) VALUES('Honore de Balzac')")

+     cur.execute("INSERT INTO Writers(Name) VALUES('Lion Feuchtwanger')")

+ 

+     # Retrieve data

+     for row in cur.execute("SELECT * FROM Writers"):

+         print(row)

+ 

+     cur.execute("DROP TABLE Writers")

+ 

+ except (sqlite3.Error) as e:

+     print("Error %s:" % e.args[0])

+     sys.exit(1)

+ 

+ finally:

+ 

+     if conn:

+         conn.close()

tests/tests.yml
file added
+16
@@ -0,0 +1,16 @@

+ ---

+ # Tests to run in a classic environment

+ - hosts: localhost

+   roles:

+   - role: standard-test-beakerlib

+     tags:

+     - classic

+     - container

+     tests:

+     - basic

+     required_packages:

+     - findutils         # beakerlib needs find command

+     - which

+     - python2

+     - sqlite

+ 

no initial comment

Justification

Adds tests according to the CI wiki specifically the standard test interface in the spec.

The playbook includes Tier1 level test cases that have been tested in the following contexts and is passing reliably: Classic and Container. Test logs are stored in the artifacts directory.

The following steps are used to execute the tests using the standard test interface:

Test enveronment

Make sure you have installed packages from the spec

$ rpm -q ansible python2-dnf libselinux-python standard-test-roles
ansible-2.3.2.0-1.fc26.noarch
python2-dnf-2.6.3-11.fc26.noarch
libselinux-python-2.6-7.fc26.x86_64
standard-test-roles-2.4-1.fc26.noarch

Run tests for Classic

$ export TEST_SUBJECTS=
$ sudo ansible-playbook --tags classic tests.yml

Snip of the example test run for Classic tests:

TASK [standard-test-beakerlib : Check the results] ******************************************************************************************************************************************************************
changed: [localhost]

PLAY RECAP **********************************************************************************************************************************************************************************************************
localhost                  : ok=15   changed=9    unreachable=0    failed=0   

PASS basic

Run tests for Container

$ export TEST_SUBJECTS=docker:docker.io/library/fedora:26
$ sudo ansible-playbook --tags=container tests.yml

Snip of the example test run for Container tests:

TASK [standard-test-beakerlib : Check the results] ******************************************************************************************************************************************************************
changed: [localhost]

PLAY RECAP **********************************************************************************************************************************************************************************************************
localhost                  : ok=15   changed=9    unreachable=0    failed=0   

PASS basic
PASS basic

Notes

Tests will be enabled in CI, yet gating is currently disabled, so nothing will change. Tests will run on each dist-git commit, they are not triggered on koji builds and if you are using FMN, it should notify you of failures normally.

The RH QE maintainer contact in case you have questions: sturivny @redhat.com
The idea is that these tests become yours just as you're maintaining the package, there will of course be people around if you have questions or troubles.

Is there any reason why these two blocks are commented out but still present?

rebased onto 1fcb324

4 years ago

Commit 3bf8338 fixes this pull-request

Pull-Request has been merged by pkubat

4 years ago

Pull-Request has been merged by pkubat

4 years ago