diff options
| -rw-r--r-- | setup.cfg | 2 | ||||
| -rw-r--r-- | test/dialect/test_oracle.py | 12 |
2 files changed, 4 insertions, 10 deletions
@@ -24,7 +24,7 @@ profile_file=test/profiles.txt # name of a "loopback" link set up on the oracle database. # to create this, suppose your DB is scott/tiger@xe. You'd create it # like: -# create database link test_link connect to scott identified by tiger using 'xe'; +# create public database link test_link connect to scott identified by tiger using 'xe'; oracle_db_link = test_link # host name of a postgres database that has the postgres_fdw extension. diff --git a/test/dialect/test_oracle.py b/test/dialect/test_oracle.py index dd4a888ff..312eedf0b 100644 --- a/test/dialect/test_oracle.py +++ b/test/dialect/test_oracle.py @@ -2078,6 +2078,9 @@ class DBLinkReflectionTest(fixtures.TestBase): from sqlalchemy.testing import config cls.dblink = config.file_config.get('sqla_testing', 'oracle_db_link') + # note that the synonym here is still not totally functional + # when accessing via a different username as we do with the multiprocess + # test suite, so testing here is minimal with testing.db.connect() as conn: conn.execute( "create table test_table " @@ -2091,15 +2094,6 @@ class DBLinkReflectionTest(fixtures.TestBase): conn.execute("drop synonym test_table_syn") conn.execute("drop table test_table") - def test_hello_world(self): - """test that the synonym/dblink is functional.""" - testing.db.execute("insert into test_table_syn (id, data) " - "values (1, 'some data')") - eq_( - testing.db.execute("select * from test_table_syn").first(), - (1, 'some data') - ) - def test_reflection(self): """test the resolution of the synonym/dblink. """ m = MetaData() |