Mercurial > p > roundup > code
comparison test/test_mysql.py @ 1906:f255363e6d97
PostgreSQL backend lands.
- that's the postgresql backend in (cleaned up doc, unit testing harness and
the backend module itself)
- also cleaned up the index maintenance code (actual checks for existence
rather than bare-except failure mode)
| author | Richard Jones <richard@users.sourceforge.net> |
|---|---|
| date | Tue, 11 Nov 2003 11:19:18 +0000 |
| parents | f3d25c512931 |
| children | f9316d2cd5ba |
comparison
equal
deleted
inserted
replaced
| 1905:dc43e339e607 | 1906:f255363e6d97 |
|---|---|
| 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_mysql.py,v 1.4 2003-11-05 21:54:57 jlgijsbers Exp $ | 18 # $Id: test_mysql.py,v 1.5 2003-11-11 11:19:18 richard Exp $ |
| 19 | 19 |
| 20 import unittest, os, shutil, time, imp | 20 import unittest, os, shutil, time, imp |
| 21 | 21 |
| 22 from roundup.hyperdb import DatabaseError | 22 from roundup.hyperdb import DatabaseError |
| 23 from roundup import init, backends | 23 from roundup import init, backends |
| 24 | 24 |
| 25 from db_test_base import DBTest, ROTest, config, SchemaTest, nodbconfig, \ | 25 from db_test_base import DBTest, ROTest, config, SchemaTest, ClassicInitTest |
| 26 ClassicInitTest | 26 |
| 27 | |
| 28 # Mysql connection data | |
| 29 config.MYSQL_DBHOST = 'localhost' | |
| 30 config.MYSQL_DBUSER = 'rounduptest' | |
| 31 config.MYSQL_DBPASSWORD = 'rounduptest' | |
| 32 config.MYSQL_DBNAME = 'rounduptest' | |
| 33 config.MYSQL_DATABASE = (config.MYSQL_DBHOST, config.MYSQL_DBUSER, | |
| 34 config.MYSQL_DBPASSWORD, config.MYSQL_DBNAME) | |
| 35 | |
| 36 class nodbconfig(config): | |
| 37 MYSQL_DATABASE = (config.MYSQL_DBHOST, config.MYSQL_DBUSER, config.MYSQL_DBPASSWORD) | |
| 27 | 38 |
| 28 class mysqlOpener: | 39 class mysqlOpener: |
| 29 if hasattr(backends, 'mysql'): | 40 if hasattr(backends, 'mysql'): |
| 30 from roundup.backends import mysql as module | 41 from roundup.backends import mysql as module |
| 31 | 42 |
| 64 | 75 |
| 65 from roundup.backends import mysql | 76 from roundup.backends import mysql |
| 66 try: | 77 try: |
| 67 # Check if we can run mysql tests | 78 # Check if we can run mysql tests |
| 68 import MySQLdb | 79 import MySQLdb |
| 69 db = mysql.Database(nodbconfig, 'admin') | 80 db = mysql.Database(config, 'admin') |
| 70 db.conn.select_db(config.MYSQL_DBNAME) | 81 db.conn.select_db(config.MYSQL_DBNAME) |
| 71 db.sql("SHOW TABLES"); | 82 db.sql("SHOW TABLES"); |
| 72 tables = db.sql_fetchall() | 83 tables = db.sql_fetchall() |
| 84 # TODO: reinstate the check here | |
| 73 if 0: #tables: | 85 if 0: #tables: |
| 74 # Database should be empty. We don't dare to delete any data | 86 # Database should be empty. We don't dare to delete any data |
| 75 raise DatabaseError, "Database %s contains tables"%\ | 87 raise DatabaseError, "Database %s contains tables"%\ |
| 76 config.MYSQL_DBNAME | 88 config.MYSQL_DBNAME |
| 77 db.sql("DROP DATABASE %s" % config.MYSQL_DBNAME) | 89 db.sql("DROP DATABASE %s" % config.MYSQL_DBNAME) |