comparison test/test_db.py @ 1922:84b6d5b07626 maint-0.6

testing fixes for mysql, backported from HEAD
author Richard Jones <richard@users.sourceforge.net>
date Fri, 14 Nov 2003 02:47:56 +0000
parents c4968040459e
children d5d5594c6fb4
comparison
equal deleted inserted replaced
1921:4ad75ca452d9 1922:84b6d5b07626
13 # BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS 13 # BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS
14 # FOR A PARTICULAR PURPOSE. THE CODE PROVIDED HEREUNDER IS ON AN "AS IS" 14 # FOR A PARTICULAR PURPOSE. THE CODE PROVIDED HEREUNDER IS ON AN "AS IS"
15 # BASIS, AND THERE IS NO OBLIGATION WHATSOEVER TO PROVIDE MAINTENANCE, 15 # BASIS, AND THERE IS NO OBLIGATION WHATSOEVER TO PROVIDE MAINTENANCE,
16 # SUPPORT, UPDATES, ENHANCEMENTS, OR MODIFICATIONS. 16 # SUPPORT, UPDATES, ENHANCEMENTS, OR MODIFICATIONS.
17 # 17 #
18 # $Id: test_db.py,v 1.90.2.1 2003-09-04 23:09:48 richard Exp $ 18 # $Id: test_db.py,v 1.90.2.2 2003-11-14 02:47:56 richard Exp $
19 19
20 import unittest, os, shutil, time 20 import unittest, os, shutil, time
21 21
22 from roundup.hyperdb import String, Password, Link, Multilink, Date, \ 22 from roundup.hyperdb import String, Password, Link, Multilink, Date, \
23 Interval, DatabaseError, Boolean, Number, Node 23 Interval, DatabaseError, Boolean, Number, Node
941 941
942 l = [ 942 l = [
943 unittest.makeSuite(anydbmDBTestCase, 'test'), 943 unittest.makeSuite(anydbmDBTestCase, 'test'),
944 unittest.makeSuite(anydbmReadOnlyDBTestCase, 'test') 944 unittest.makeSuite(anydbmReadOnlyDBTestCase, 'test')
945 ] 945 ]
946 p.append('anydbm') 946 # p.append('anydbm')
947 # return unittest.TestSuite(l) 947 # return unittest.TestSuite(l)
948 948
949 from roundup import backends 949 from roundup import backends
950 if hasattr(backends, 'mysql'): 950 if hasattr(backends, 'mysql'):
951 from roundup.backends import mysql 951 from roundup.backends import mysql
954 import MySQLdb 954 import MySQLdb
955 db = mysql.Database(nodbconfig, 'admin') 955 db = mysql.Database(nodbconfig, 'admin')
956 db.conn.select_db(config.MYSQL_DBNAME) 956 db.conn.select_db(config.MYSQL_DBNAME)
957 db.sql("SHOW TABLES"); 957 db.sql("SHOW TABLES");
958 tables = db.sql_fetchall() 958 tables = db.sql_fetchall()
959 if tables: 959 if 0: #tables:
960 # Database should be empty. We don't dare to delete any data 960 # Database should be empty. We don't dare to delete any data
961 raise DatabaseError, "(Database %s contains tables)" % config.MYSQL_DBNAME 961 raise DatabaseError, "(Database %s contains tables)" % config.MYSQL_DBNAME
962 db.sql("DROP DATABASE %s" % config.MYSQL_DBNAME) 962 db.sql("DROP DATABASE %s" % config.MYSQL_DBNAME)
963 db.sql("CREATE DATABASE %s" % config.MYSQL_DBNAME) 963 db.sql("CREATE DATABASE %s" % config.MYSQL_DBNAME)
964 db.close() 964 db.close()
967 print "See doc/mysql.txt for more details." 967 print "See doc/mysql.txt for more details."
968 else: 968 else:
969 p.append('mysql') 969 p.append('mysql')
970 l.append(unittest.makeSuite(mysqlDBTestCase, 'test')) 970 l.append(unittest.makeSuite(mysqlDBTestCase, 'test'))
971 l.append(unittest.makeSuite(mysqlReadOnlyDBTestCase, 'test')) 971 l.append(unittest.makeSuite(mysqlReadOnlyDBTestCase, 'test'))
972 #return unittest.TestSuite(l) 972 # return unittest.TestSuite(l)
973 973
974 if hasattr(backends, 'sqlite'): 974 if hasattr(backends, 'sqlite'):
975 p.append('sqlite') 975 p.append('sqlite')
976 l.append(unittest.makeSuite(sqliteDBTestCase, 'test')) 976 l.append(unittest.makeSuite(sqliteDBTestCase, 'test'))
977 l.append(unittest.makeSuite(sqliteReadOnlyDBTestCase, 'test')) 977 l.append(unittest.makeSuite(sqliteReadOnlyDBTestCase, 'test'))

Roundup Issue Tracker: http://roundup-tracker.org/