Mistake in sqlalchemy DateTime type usage

[Ann Taraday]

In migration f9263d6df56_remove_dhcp_lease there is mistake in DateTime type usage for mysql, used sa.DATETIME() instead of sa.DateTime()

   File "/opt/stack/neutron/neutron/db/migration/alembic_migrations/versions/f9263d6df56_remove_dhcp_lease.py", line 46, in downgrade
    nullable=True))
  File "<string>", line 7, in add_column
  File "/opt/stack/neutron/.tox/py27/local/lib/python2.7/site-packages/alembic/operations.py", line 363, in add_column
    schema=schema
  File "/opt/stack/neutron/.tox/py27/local/lib/python2.7/site-packages/alembic/ddl/impl.py", line 127, in add_column
    self._exec(base.AddColumn(table_name, column, schema=schema))
  File "/opt/stack/neutron/.tox/py27/local/lib/python2.7/site-packages/alembic/ddl/impl.py", line 76, in _exec
    conn.execute(construct, *multiparams, **params)
  File "/opt/stack/neutron/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1449, in execute
    params)
  File "/opt/stack/neutron/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1542, in _execute_ddl
    compiled
  File "/opt/stack/neutron/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1698, in _execute_context
    context)
  File "/opt/stack/neutron/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1691, in _execute_context
    context)
  File "/opt/stack/neutron/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 331, in do_execute
    cursor.execute(statement, parameters)
ProgrammingError: (ProgrammingError) type "datetime" does not exist
LINE 1: ALTER TABLE ipallocations ADD COLUMN expiration DATETIME
                                                        ^
 'ALTER TABLE ipallocations ADD COLUMN expiration DATETIME' {}

[OpenStack Infra (hudson-openstack)]

Fix proposed to branch: master
Review: https://review.openstack.org/56015

[Gary Kotton (garyk)]

Need to backport this to havana - https://github.com/openstack/neutron/blob/stable/havana/neutron/db/migration/alembic_migrations/versions/f9263d6df56_remove_dhcp_lease.py

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.openstack.org/56015
Committed: http://github.com/openstack/neutron/commit/e2163abce55bba83f531b4a0c9286b7b329602e9
Submitter: Jenkins
Branch: master

commit e2163abce55bba83f531b4a0c9286b7b329602e9
Author: Ann Kamyshnikova <email address hidden>
Date: Tue Nov 12 15:49:43 2013 +0400

    Fix sqlalchemy DateTime type usage

    In migration f9263d6df56_remove_dhcp_lease there is mistake in
    DateTime type usage for mysql, used sa.DATETIME() instead of
    sa.DateTime()

    Closes-Bug: #1250405

    Change-Id: I41fcd3babc64e3307895a92f03c7417577fa7b1d