Run test_db_api on all backends (sqlite, mysql, postgresql)

Registered by Boris Pavlovic on 2013-04-30

There is a lot of different things in SQl backends. For example work with casting.
In current SQLite we are able to store everything in column (with any type). Mysql will try to convert value to required type, and postgresql will raise IntegrityError. So to avoid such nasty errors on db.api layer we should runt test_db_api on all backends.

Blueprint information

Status:
Started
Approver:
Russell Bryant
Priority:
Undefined
Drafter:
Boris Pavlovic
Direction:
Needs approval
Assignee:
Roman Podoliaka
Definition:
Review
Series goal:
None
Implementation:
Good progress
Milestone target:
milestone icon ongoing
Started by
Boris Pavlovic on 2013-06-12

Related branches

Sprints

Whiteboard

Gerrit topic: https://review.openstack.org/#q,topic:bp/db-api-tests-on-all-backends,n,z

Addressed by: https://review.openstack.org/33236
    Run DB API tests on a given DB backend.

Addressed by: https://review.openstack.org/33411
    Fix vol_usage_update() DB API method and tests.

Addressed by: https://review.openstack.org/34409
    Fix types in test_ec2_ids_not_found_are_printable

Addressed by: https://review.openstack.org/35808
    Use valid IP addresses values in tests

Addressed by: https://review.openstack.org/36663
    Fix datetime precision issues in MySQL < 5.6

Addressed by: https://review.openstack.org/36661
    Add a new datetime format to _parse_datetime()

Addressed by: https://review.openstack.org/36662
    Use timeutils.utcnow() throughout the code

Addressed by: https://review.openstack.org/39299
    Fix timing issue in SimpleTenantUsageSample test

Addressed by: https://review.openstack.org/40860
    Fix ReservationTestCase on PostgreSQL

Addressed by: https://review.openstack.org/40901
    Fix FK violation in ConsoleTestCase

Addressed by: https://review.openstack.org/41408
    Fix instance_group_delete() DB API method

Addressed by: https://review.openstack.org/41409
    Fix AggregateDBApiTestCase on PostreSQL and MySQL

Addressed by: https://review.openstack.org/41410
    Fix ArchiveTestCase on PostgreSQL

Addressed by: https://review.openstack.org/44709
    Fix DB API tests depending on the order of rows

Addressed by: https://review.openstack.org/44710
    Fix PCI devices DB API tests

Addressed by: https://review.openstack.org/44711
    Fix test_shadow_tables() on PostgreSQL/MySQL

Addressed by: https://review.openstack.org/44712
    Fix FK violation errors in InstanceActionTestCase

Addressed by: https://review.openstack.org/44713
    Fix type mismatch errors in NetworkTestCase

Addressed by: https://review.openstack.org/44714
    Fix CIDR values denoting hosts in PostgreSQL

Addressed by: https://review.openstack.org/44715
    Fix ReservationTestCase on PostgreSQL

Addressed by: https://review.openstack.org/44716
    Fix InstanceActionTestCase on PostgreSQL/MySQL

Addressed by: https://review.openstack.org/44717
    Don't compare microseconds part of DATETIME cols

Unapproved - please re-submit via nova-spec --johnthetubagy (20th March 2014)

Addressed by: https://review.openstack.org/89778
    Sync test.py module from common code

Addressed by: https://review.openstack.org/99442
    Revert "Sync common db and db/sqlalchemy"

(?)

Work Items

Dependency tree

* Blueprints in grey have been implemented.

This blueprint contains Public information 
Everyone can see this information.