chore: Make it practical to make simultaneous compliance test runs.#166

Merged

jimfulton merged 169 commits intomasterfrom

riversnake-tests

May 13, 2021

Commits on Apr 12, 2021

Fixed a dependency problem that caysed test failures in Python 3.6.
Jim Fulton
committed

Commits on Apr 15, 2021

Started implementing SqlAlchemy dialect-compliance tests
Jim Fulton
committed
Handle parameters in in
Jim Fulton
committed
fixed regex to allow multi-character parameter names.
Jim Fulton
committed

Commits on Apr 16, 2021

Fixed rendering of string literals.
Jim Fulton
committed
Provide default values for primary keys and other fixes...
Jim Fulton
committed
Narrowed skips and license comment diagnosed reasons for skipped failures
Jim Fulton
committed
use Google license
Jim Fulton
committed

Commits on Apr 19, 2021

Fixed like (% and _) escapes.
Jim Fulton
committed
Handle BIGNUMERIC
Jim Fulton
committed
Skip tests that want to stpre floats as numeric.
Jim Fulton
committed
skip tests for offsets without limits. BigQuery doesn't allow that.
Jim Fulton
committed
BIGNUMERIC lets us handle many significant digits.test_many_significant_digits
Jim Fulton
committed
Skip LongNameBlowoutTest because it requires features (indexes, primary keys, etc., that BigQuery doesn't have.
Jim Fulton
committed
We have to rewrite these tests, because of forcing use_labels=True
Jim Fulton
committed
BigQuery returns deleted and updated rows, which SQLAlchemy doesn't expect
Jim Fulton
committed

Commits on Apr 20, 2021

Fixed a dependency problem that caysed test failures in Python 3.6.
Jim Fulton
committed
Provide a bigquery mock based on sqlite
Jim Fulton
committed
Don't force labels in select.
Jim Fulton
committed
merge riversnake-fix-78
Jim Fulton
committed

Commits on Apr 22, 2021

No need to work around forced labels anymore.
Jim Fulton
committed
Updated sqlite-bases mock
Jim Fulton
committed
Added test that types are injected into parameter placeholders.
Jim Fulton
committed
Oops, need to call super even when there are where clauses.
Jim Fulton
committed

Commits on Apr 23, 2021

When SQLAlchemy thinks it knows a parameter type, include it in the placeholder
Jim Fulton
committed
Don't skip some numeric tests and skip some CTE tests
Jim Fulton
committed
Can't coerce datetime to date.
Jim Fulton
committed
reenable some tests now that we pass type infor to bigquery
Jim Fulton
committed

Commits on Apr 24, 2021

Enable error on warnings -- a test depends on it.
Jim Fulton
committed
Added table and column comment support.
Jim Fulton
committed
get_schema_names should return all of the schema names.
Jim Fulton
committed
Retrieval of view definitions.
Jim Fulton
committed
handle dateish literals.
Jim Fulton
committed
BigQuery doesn't want schema names in column names.
Jim Fulton
committed
Allow mutating table descriptions/comments.
Jim Fulton
committed
skip tests that depend on BigQuery keeping track of column details.
Jim Fulton
committed
Handle TIMESTAMP literals.
Jim Fulton
committed
Fixed some broken TIMESTAMP tests.
Jim Fulton
committed
enabled more tests.
Jim Fulton
committed

Commits on Apr 26, 2021

remove extra lines.
Jim Fulton
committed
blacken
Jim Fulton
committed
added missing test for api.py
Jim Fulton
committed
Ignore flake8 complaint about * import.
Jim Fulton
committed
lint and minor cleanup
Jim Fulton
committed
Removed unused variable.
Jim Fulton
committed
Get to 100% coverage in test_parse_url
Jim Fulton
committed

Commits on Apr 27, 2021

Don't need because we can't test temp tables
Jim Fulton
committed
requirements.py -- It's used by compliance testing.
Jim Fulton
committed
Added Binary literal handling, and ...
Jim Fulton
committed
Updated fauxdb to correct for some sqlite differences.
Jim Fulton
committed
Fixed santy check
Jim Fulton
committed
blackened
Jim Fulton
committed
Added a test that exercises type handling for all the types.
Jim Fulton
committed

Commits on Apr 28, 2021

Added table reference tests
Jim Fulton
committed
test get_view_definition
Jim Fulton
committed
removed a private function that's never called.
Jim Fulton
committed
table and view list tests
Jim Fulton
committed

Commits on Apr 29, 2021

Moar unit tests and coverage
Jim Fulton
committed
use latest bg release, because we depend on changes there.
Jim Fulton
committed
removed breakpoint that shouldn't have been checked in.
Jim Fulton
committed

Commits on Apr 30, 2021

Bypass google authentication.
Jim Fulton
committed
Test JSON deserialization.
Jim Fulton
committed
Test getting project id from authentication.
Jim Fulton
committed
removed some unneeded code.
Jim Fulton
committed
Simplify string and binary literal processors to not expect None.
Jim Fulton
committed
Tested comment support
Jim Fulton
committed
Cleaned up comment handling.
Jim Fulton
committed
generalized options handling.
Jim Fulton
committed
test dialect-options handling.
Jim Fulton
committed
constraints are ignored.
Jim Fulton
committed

Commits on May 3, 2021

Better binary-literal hack
Jim Fulton
committed
added tests for BIGNUMERIC.
Jim Fulton
committed
Major rework using pickle to overcome type differences.
Jim Fulton
committed
Added array support
Jim Fulton
committed
blacken
Jim Fulton
committed
replaced an unreachable branch with an assert.
Jim Fulton
committed
lint
Jim Fulton
committed
Enable generation of random primary keys when running compliance tests.
Jim Fulton
committed
Run the select a couple of ways and assert result.
Jim Fulton
committed
Only generate random primary keys when running compliance tests.
Jim Fulton
committed

Commits on May 4, 2021

addd fetchall, needed by a test.
Jim Fulton
committed
Port compliance tests
Jim Fulton
committed
record when array size is set.
Jim Fulton
committed
Added a tiny metadata convenience.
Jim Fulton
committed
Added arraysize tests.
Jim Fulton
committed
exercise labels
Jim Fulton
committed
Make sure label names are legal identifiers
Jim Fulton
committed
test disable quoting
Jim Fulton
committed
simplifed a test.
Jim Fulton
committed
Test forcing quote (even though quotes are forced anyway)
Jim Fulton
committed
Be more careful about doubled %s.
Jim Fulton
committed
ported test for %%s
Jim Fulton
committed
Added IN tests.
Jim Fulton
committed
handle UNNEST
Jim Fulton
committed
"inlined" some helper attrs
Jim Fulton
committed
moved setup_table to central location
Jim Fulton
committed
ported a test that deals with bind params with indeterminate types
Jim Fulton
committed
leverage setup_table
Jim Fulton
committed
added a test based on sqlalchemy.testing.suite.test_select.LikeFunctionsTest
Jim Fulton
committed
leverage setup_table
Jim Fulton
committed
Added test for labels in group by
Jim Fulton
committed

Commits on May 5, 2021

Added a test for compiling a single column.
Jim Fulton
committed
Trying to compile a nameless column gives a meaningful error.
Jim Fulton
committed
Get 100% coverage of fauxdbi
Jim Fulton
committed
Simplified quote decision.
Jim Fulton
committed
Specify proto 4 when pickling, to get predictable behavior across Python versions
Jim Fulton
committed
Some tests require sqlalchemy 1.3
Jim Fulton
committed
require 100% test coverage.
Jim Fulton
committed
need newer sqlalchemy and google-auth
Jim Fulton
committed
need sqlalchemy 1.2 because comments.
Jim Fulton
committed
blacken/lint
Jim Fulton
committed
Added code to cleanup schemas at start to avoid spurious errors.
Jim Fulton
committed
added copyright
Jim Fulton
committed
added copyright
Jim Fulton
committed
fixed copyright
Jim Fulton
committed
Updated the compliance setup
Jim Fulton
committed
added copyright
Jim Fulton
committed
added copyright
Jim Fulton
committed
added copyright
Jim Fulton
committed
added copyright
Jim Fulton
committed
added copyright
Jim Fulton
committed
blacken
Jim Fulton
committed
merge master
Jim Fulton
committed
Make operational errors more informative.
Jim Fulton
committed

Commits on May 6, 2021

Fixed better debugging support.
Jim Fulton
committed
lint first
Jim Fulton
committed
Don't use upsert to update comments.
Jim Fulton
committed
Older sqlite don't have true and false.
Jim Fulton
committed
Ignore test debugging info added to deal with sqlite3 differences.
Jim Fulton
committed
blacken
Jim Fulton
committed

Commits on May 10, 2021

Added minimal requirement for google-api-core to be consistent with setup.py.
Jim Fulton
committed
Make the google-auth requirement consistent with the Python 3.6 test constraint.
Jim Fulton
committed
chore(revert): revert preventing normalization (#132)

dandhlee
authored and
Jim Fulton
committed
Explain why we add where clauses in delete statements that lack them
Jim Fulton
committed
Added a missing _ and explained \d+s in a regex
Jim Fulton
committed
Fixed: didn't properly handle expansion of single-item arrays.
Jim Fulton
committed
Added test for expansion of single-element arrays
Jim Fulton
committed
Avoid having to use an `_` to ignore a re group we don't care about.
Jim Fulton
committed
Added some comments for the tricky _get_field method.
Jim Fulton
committed
Commented the pickle-protocol 4 prefixes we're looking for.
Jim Fulton
committed
explain use of pickle.
Jim Fulton
committed
typo
Jim Fulton
committed
BigQuery 2.15 wants google-api-core >= 1.23.0
Jim Fulton
committed
blacken
Jim Fulton
committed
don't need to call out the project in the test config.
Jim Fulton
committed
Try sleeping between tests to see if we can avoid some weird failures.
Jim Fulton
committed
some minimal docs on the dialect tests.
Jim Fulton
committed

Commits on May 11, 2021

Update tests/sqlalchemy_dialect_compliance/README.rst

Jim Fulton
and
plamut
authored
Update tests/sqlalchemy_dialect_compliance/README.rst

Jim Fulton
and
plamut
authored
simplify by getting rid of unnecessary and broken overrriding.
Jim Fulton
committed
merge upstream
Jim Fulton
committed
Try sleeping longer to avoid races between tests.
Jim Fulton
committed
make sure we wait for the drops at the beginning of the session.
Jim Fulton
committed
rerun on table not found
Jim Fulton
committed
Try simpler regex
Jim Fulton
committed
Try different error
Jim Fulton
committed
don't sleep between tests.
Jim Fulton
committed
blacken
Jim Fulton
committed
removed unused import
Jim Fulton
committed

Commits on May 12, 2021

Removed machinery to clean tests schemas
Jim Fulton
committed
Added an alternate requirements class that skips schema tests.
Jim Fulton
committed
use --dropfirst to clean test schemas at start of compliance run.
Jim Fulton
committed
merge master
Jim Fulton
committed
really merge master
Jim Fulton
committed
document running test simultaneously
Jim Fulton
committed
Fail compliance on first error, so we don't wait so long in CI
Jim Fulton
committed
-x doesn't play well with test skipping :(
Jim Fulton
committed
Just use temprary datasets!
Jim Fulton
committed
We don't need the database setting anymore.
Jim Fulton
committed