Change assigned IP addresses representation from string

[Maciej Kwiek]

IP addresses are stored as strings in database. It makes them bigger than they need to be, and makes handling them harder. We should consider using native IP type, or integer type with custom SQLAlchemy field for automatic conversion (maybe use netaddr IP type for representing it in the application).

[OpenStack Infra (hudson-openstack)]

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

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.openstack.org/235865
Committed: https://git.openstack.org/cgit/openstack/fuel-web/commit/?id=83bd490394e1ca12e6729917ce13d39b2a83f995
Submitter: Jenkins
Branch: master

commit 83bd490394e1ca12e6729917ce13d39b2a83f995
Author: smurashov <email address hidden>
Date: Fri Oct 16 14:23:21 2015 +0300

    Use appropriate types to store IP and MAC addrs

    In PostgreSQL there are special types for storing IPv4, IPv6 address and
    subnetworks and also MAC addresses. Storing data in these types is more
    efficient than in strings because it requires less space. In addition,
    it provides additional operations for columns of these types.

    This patch changes types of some columns for models such as:

        IPAddr
            ip_addr: inet

        IPAddrRange
            first: inet
            last: inet

        Node
            mac: macaddr
            ip: inet

        NodeNICInterface
            mac: macaddr
            ip_addr: inet
            netmask: inet

        NodeNICInterface
            mac: macaddr

        NetworkGroup
            cidr: cidr
            gateway: inet

        NeutronConfig
            base_mac: macaddr
            internal_cidr: cidr
            internal_gateway: inet
            baremetal_gateway: inet

        NovaNetworkConfig
            fixed_networks_cidr: cidr

    Co-Authored-By: Ilya Kharin <email address hidden>
    Change-Id: Id8431eb7d2e3ca1a1cc29fc865d57359b29d0e35
    Partial-Bug: #1484973

[Oleg S. Gelbukh (gelbuhos)]

Ilya, do you plan to commit anything else on this bug? Please, share the plan or change the status to 'Fix Commited'.

[Dmitry Pyzhov (dpyzhov)]

It's too late for refactoring in 8.0. No response from assignee. Moving the bug back to the team.

[Dmitry Pyzhov (dpyzhov)]

I don't see reason why it is marked as high priority