Magic numbers removed
Using kw params as Python intended
Removing string formating for better clarity
Fixes RM6714: move IPAddress filter to ON clause of JOIN (used IPs)
Removing unnecessary __new__ method and super() logic
Removing unnecessary Mock.mock()
Flake8 fixes and removing list param default
Removed the remaining string formating
Removing accidental extra line on EOF
Merge pull request #136 from insequent/refactor_ipam_tests

Refactor ipam tests
Fixes #75

IP addresses in subnets marked as "do_not_use" are now ignored
successfully.
Merge pull request #140 from Cerberus98/issue75

Fixes #75
Merge pull request #141 from asadoughi/master

Fix related to 5702b7, db_api related tests
Merge pull request #142 from asadoughi/ip_avail_used_ips_zero

Fixes RM6714: move IPAddress filter to ON clause of JOIN (used IPs)
Removing magic numbers for explicit IPs
Merge pull request #143 from insequent/refactor_ipam_tests

Removing magic numbers for explicit IPs
Merge pull request #144 from rackerlabs/refactor_ipam_tests

Refactor ipam tests
Added alembic revisions for missing indices, unique constraints

I split the changes into two files since I noticed production had a
a unique key on subnet_id and address already on quark_ip_addresses,
but did not have any of the quark_mac_addresses changes.

Unfortunately, it's called `subnet_id` which is not possible with
alembic. Instead, I've called it `subnet_id_address` here.

Refers to commits in quark/db/models.py:
 - 375379d442656b97d78b77166ba43aa8048b3581
 - b4e0cde9cd8e149e1e5608c66be1f18b9d307917

Upgrading to latest SQLAlchemy allowed alembic to autogenerate the
relevant changes.
Merge pull request #146 from asadoughi/alembic_updates_6804

Added alembic revisions for missing indices, unique constraints
Fixes alembic migrations for RM6804

* Absorbs 56* revision (subnet_id, address unique constraint) into
  18* (initial revision); oblige already contained the changes in
  56* and prod databases were stamped to 18* so it makes sense to
  absorb contents of 56* into 18*.

* MacAddress.address is already a primary key; removes
  UniqueConstraint on (mac_address_range_id, address) from model.

* Removes added MacAddress unique constraint from 43* revision.