Mercurial > p > roundup > code
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')) |
