diff options
| author | Mike Bayer <mike_mp@zzzcomputing.com> | 2010-03-14 15:00:27 -0400 |
|---|---|---|
| committer | Mike Bayer <mike_mp@zzzcomputing.com> | 2010-03-14 15:00:27 -0400 |
| commit | d9af1828fbd79cc925abce98c9dd1d0b629e88a8 (patch) | |
| tree | bbd943d60ad50b41fca18abb11aafa266bd8322d | |
| parent | 9edf14f09617c4ea0b660cb36ccf17933ee4bc0b (diff) | |
| download | sqlalchemy-d9af1828fbd79cc925abce98c9dd1d0b629e88a8.tar.gz | |
starting to add notes for sybase
| -rw-r--r-- | README.unittests | 18 |
1 files changed, 14 insertions, 4 deletions
diff --git a/README.unittests b/README.unittests index 0e0fee120..739465804 100644 --- a/README.unittests +++ b/README.unittests @@ -100,7 +100,7 @@ Several tests require alternate schemas to be present. This requirement applies to all backends except SQLite and Firebird. These schemas are: test_schema - test_schema_2 + test_schema_2 (only used on Postgresql) Please refer to your vendor documentation for the proper syntax to create these schemas - the database user must have permission to create and drop @@ -110,7 +110,7 @@ expect them to be present will fail. Additional steps specific to individual databases are as follows: - ORACLE: the test_schema and test_schema_2 schemas are created as + ORACLE: the test_schema schema is created as users, as the "owner" in Oracle is considered like a "schema" in SQLAlchemy. @@ -121,7 +121,7 @@ Additional steps specific to individual databases are as follows: defined (REFERENCES is per-table) - the only thing that works is to put the user in the "DBA" role: - grant dba to scott; + grant dba to scott; Any ideas on what specific privileges within "DBA" allow an open-ended REFERENCES grant would be appreciated, or if in fact "DBA" has some kind @@ -131,7 +131,17 @@ Additional steps specific to individual databases are as follows: leaving the schemas out means those few dozen tests will fail and is otherwise harmless. - + SYBASE: Similar to Oracle, two users are created, with the primary owner + having the "sa_role": + + create database sqlalchemy + sp_addlogin scott, "tiger7" + sp_addlogin test_schema, "tiger7" + sp_adduser scott + sp_adduser test_schema + grant all to scott + grant sa_role to scott + MSSQL: Tests that involve multiple connections require Snapshot Isolation ability implented on the test database in order to prevent deadlocks that will occur with record locking isolation. This feature is only available |