]> git.ipfire.org Git - thirdparty/kea.git/commit
[3916] Use stored procedures for MySQL lease dumps
authorThomas Markwalder <tmark@isc.org>
Thu, 1 Oct 2015 12:46:18 +0000 (08:46 -0400)
committerThomas Markwalder <tmark@isc.org>
Thu, 1 Oct 2015 12:46:18 +0000 (08:46 -0400)
commit9ca02bd6242b5a13666f8007500a683a78c3aece
tree1b6c0365252d1c6486bbd8e112038677d41bcd1c
parent9fbe63fc6792d43222f1584752187068bbb295e1
[3916] Use stored procedures for MySQL lease dumps

src/bin/admin/kea-admin.in
    src/bin/admin/kea-admin.in
        get_dump_query() - modified SQL text returned for MySQL backend
        which calls stored procedures to produce lease dumps  rather than
        SQL text from lease_dump_<version>.sh

src/bin/admin/scripts/mysql/Makefile.am
    removed entries for leave_dump_<version>.sh files

src/bin/admin/scripts/mysql/dhcpdb_create.mysql
    Added sql to create stored procedures for lease dumps:
        lease4DumpHeader
        lease4DumpData
        lease6DumpHeader
        lease6DumpData

src/bin/admin/scripts/pgsql/dhcpdb_create.pgsql
    Changes table references in lease6DumpData() to match
    convention used in MySQL lease6DumpData()

src/bin/admin/tests/mysql_tests.sh.in
    mysql_lease4_dump_test() - change lease4 test leases to have differing
    values for lease4.state

    mysql_lease6_dump_test() - change lease4 test leases to have differing
    values for lease6.state

mysql.lease4_dump_test.reference.csv
mysql.lease6_dump_test.reference.csv
    Changed reference files to use lease_state.name values rather than
    lease.state to match dump query output and  new test data

src/bin/admin/scripts/mysql
    deleted the following files as they are now obsolete
        leave_dump_1.0.sh
        leave_dump_2.0.sh
        leave_dump_3.0.sh
        leave_dump_4.0.sh
    Makefile.am - removed entries for deleted lease dump scripts
src/bin/admin/kea-admin.in
src/bin/admin/scripts/mysql/Makefile.am
src/bin/admin/scripts/mysql/dhcpdb_create.mysql
src/bin/admin/scripts/mysql/lease_dump_1.0.sh [deleted file]
src/bin/admin/scripts/mysql/lease_dump_2.0.sh [deleted file]
src/bin/admin/scripts/mysql/lease_dump_3.0.sh [deleted file]
src/bin/admin/scripts/mysql/lease_dump_4.0.sh [deleted file]
src/bin/admin/scripts/pgsql/dhcpdb_create.pgsql
src/bin/admin/tests/data/mysql.lease4_dump_test.reference.csv
src/bin/admin/tests/data/mysql.lease6_dump_test.reference.csv
src/bin/admin/tests/mysql_tests.sh.in