- # ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

- #

- #   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)

- PURPOSE of /CoreOS/sqlite3/Sanity/basic

- Description: Basic test for python and sqlite3 DB

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

- #!/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

- #!/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 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

-