summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorMike Bayer <mike_mp@zzzcomputing.com>2012-12-08 16:17:20 -0500
committerMike Bayer <mike_mp@zzzcomputing.com>2012-12-08 16:17:20 -0500
commit8070cbde716a247f8b31c1334c80fa53327e6d8e (patch)
tree7c610799dcedc15265c2f8264d32cd1ca240b6ef
parent927b9859834096dd77182f935ff611351407f0dc (diff)
downloadsqlalchemy-8070cbde716a247f8b31c1334c80fa53327e6d8e.tar.gz
internally at least refer to multirow as "multivalues", to distinguish between
an INSERT that's used in executemany() as opposed to one which has a VALUES clause with multiple entries.
-rw-r--r--lib/sqlalchemy/dialects/mysql/base.py2
-rw-r--r--lib/sqlalchemy/dialects/postgresql/base.py2
-rw-r--r--lib/sqlalchemy/dialects/sqlite/base.py2
-rw-r--r--lib/sqlalchemy/engine/default.py2
-rw-r--r--lib/sqlalchemy/sql/compiler.py2
-rw-r--r--lib/sqlalchemy/testing/requirements.py4
-rw-r--r--test/sql/test_compiler.py10
-rw-r--r--test/sql/test_query.py4
-rw-r--r--test/sql/test_returning.py2
9 files changed, 15 insertions, 15 deletions
diff --git a/lib/sqlalchemy/dialects/mysql/base.py b/lib/sqlalchemy/dialects/mysql/base.py
index 5f515c936..73d874bce 100644
--- a/lib/sqlalchemy/dialects/mysql/base.py
+++ b/lib/sqlalchemy/dialects/mysql/base.py
@@ -1882,7 +1882,7 @@ class MySQLDialect(default.DefaultDialect):
supports_sane_rowcount = True
supports_sane_multi_rowcount = False
- supports_multirow_insert = True
+ supports_multivalues_insert = True
default_paramstyle = 'format'
colspecs = colspecs
diff --git a/lib/sqlalchemy/dialects/postgresql/base.py b/lib/sqlalchemy/dialects/postgresql/base.py
index 22667b317..e92ab76c1 100644
--- a/lib/sqlalchemy/dialects/postgresql/base.py
+++ b/lib/sqlalchemy/dialects/postgresql/base.py
@@ -1182,7 +1182,7 @@ class PGDialect(default.DefaultDialect):
supports_default_values = True
supports_empty_insert = False
- supports_multirow_insert = True
+ supports_multivalues_insert = True
default_paramstyle = 'pyformat'
ischema_names = ischema_names
colspecs = colspecs
diff --git a/lib/sqlalchemy/dialects/sqlite/base.py b/lib/sqlalchemy/dialects/sqlite/base.py
index d1532b9bb..a5be0aa17 100644
--- a/lib/sqlalchemy/dialects/sqlite/base.py
+++ b/lib/sqlalchemy/dialects/sqlite/base.py
@@ -601,7 +601,7 @@ class SQLiteDialect(default.DefaultDialect):
supports_default_values = True
supports_empty_insert = False
supports_cast = True
- supports_multirow_insert = True
+ supports_multivalues_insert = True
default_paramstyle = 'qmark'
execution_ctx_cls = SQLiteExecutionContext
diff --git a/lib/sqlalchemy/engine/default.py b/lib/sqlalchemy/engine/default.py
index 7de0dcee7..789fc610b 100644
--- a/lib/sqlalchemy/engine/default.py
+++ b/lib/sqlalchemy/engine/default.py
@@ -85,7 +85,7 @@ class DefaultDialect(interfaces.Dialect):
default_paramstyle = 'named'
supports_default_values = False
supports_empty_insert = True
- supports_multirow_insert = False
+ supports_multivalues_insert = False
server_version_info = None
diff --git a/lib/sqlalchemy/sql/compiler.py b/lib/sqlalchemy/sql/compiler.py
index 1e8bc3760..87b549f47 100644
--- a/lib/sqlalchemy/sql/compiler.py
+++ b/lib/sqlalchemy/sql/compiler.py
@@ -1286,7 +1286,7 @@ class SQLCompiler(engine.Compiled):
self.dialect.name)
if insert_stmt._has_multi_parameters:
- if not self.dialect.supports_multirow_insert:
+ if not self.dialect.supports_multivalues_insert:
raise exc.CompileError("The '%s' dialect with current database "
"version settings does not support "
"in-place multirow inserts." %
diff --git a/lib/sqlalchemy/testing/requirements.py b/lib/sqlalchemy/testing/requirements.py
index 057da7849..2fb1b3143 100644
--- a/lib/sqlalchemy/testing/requirements.py
+++ b/lib/sqlalchemy/testing/requirements.py
@@ -88,12 +88,12 @@ class SuiteRequirements(Requirements):
)
@property
- def multirow_inserts(self):
+ def multivalues_inserts(self):
"""target database must support multiple VALUES clauses in an
INSERT statement."""
return exclusions.skip_if(
- lambda: not self.db.dialect.supports_multirow_insert,
+ lambda: not self.db.dialect.supports_multivalues_insert,
"Backend does not support multirow inserts."
)
diff --git a/test/sql/test_compiler.py b/test/sql/test_compiler.py
index d01719727..f58d25db0 100644
--- a/test/sql/test_compiler.py
+++ b/test/sql/test_compiler.py
@@ -2575,7 +2575,7 @@ class CRUDTest(fixtures.TestBase, AssertsCompiledSQL):
stmt.compile, dialect=dialect
)
- def test_multirow_insert_not_supported(self):
+ def test_multivalues_insert_not_supported(self):
stmt = table1.insert().values([{"myid": 1}, {"myid": 2}])
dialect = default.DefaultDialect()
assert_raises_message(
@@ -2585,7 +2585,7 @@ class CRUDTest(fixtures.TestBase, AssertsCompiledSQL):
stmt.compile, dialect=dialect
)
- def test_multirow_insert_named(self):
+ def test_multivalues_insert_named(self):
stmt = table1.insert().\
values([{"myid": 1, "name": 'a', "description": 'b'},
{"myid": 2, "name": 'c', "description": 'd'},
@@ -2598,7 +2598,7 @@ class CRUDTest(fixtures.TestBase, AssertsCompiledSQL):
"(:myid_2, :name_2, :description_2)"
dialect = default.DefaultDialect()
- dialect.supports_multirow_insert = True
+ dialect.supports_multivalues_insert = True
self.assert_compile(stmt, result,
checkparams={
'description_2': 'f', 'name_2': 'e',
@@ -2608,7 +2608,7 @@ class CRUDTest(fixtures.TestBase, AssertsCompiledSQL):
},
dialect=dialect)
- def test_multirow_insert_positional(self):
+ def test_multivalues_insert_positional(self):
stmt = table1.insert().\
values([{"myid": 1, "name": 'a', "description": 'b'},
{"myid": 2, "name": 'c', "description": 'd'},
@@ -2621,7 +2621,7 @@ class CRUDTest(fixtures.TestBase, AssertsCompiledSQL):
"(%s, %s, %s)" \
dialect = default.DefaultDialect()
- dialect.supports_multirow_insert = True
+ dialect.supports_multivalues_insert = True
dialect.paramstyle = "format"
dialect.positional = True
self.assert_compile(stmt, result,
diff --git a/test/sql/test_query.py b/test/sql/test_query.py
index 60adfa0b7..2c0ee4a18 100644
--- a/test/sql/test_query.py
+++ b/test/sql/test_query.py
@@ -48,8 +48,8 @@ class QueryTest(fixtures.TestBase):
def teardown_class(cls):
metadata.drop_all()
- @testing.requires.multirow_inserts
- def test_multirow_insert(self):
+ @testing.requires.multivalues_inserts
+ def test_multivalues_insert(self):
users.insert(values=[{'user_id':7, 'user_name':'jack'},
{'user_id':8, 'user_name':'ed'}]).execute()
rows = users.select().execute().fetchall()
diff --git a/test/sql/test_returning.py b/test/sql/test_returning.py
index 3cb294023..a182444e9 100644
--- a/test/sql/test_returning.py
+++ b/test/sql/test_returning.py
@@ -108,7 +108,7 @@ class ReturningTest(fixtures.TestBase, AssertsExecutionResults):
eq_(result2.fetchall(), [(2, 2, False, None), (3, 3, True, None)])
- @testing.requires.multirow_inserts
+ @testing.requires.multivalues_inserts
def test_multirow_returning(self):
ins = table.insert().returning(table.c.id, table.c.persons).values(
[