summaryrefslogtreecommitdiffstats
path: root/src/share/database (follow)
Commit message (Collapse)AuthorAgeFilesLines
* [#3592] Update schemasThomas Markwalder6 days8-0/+215
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | src/share/database/scripts/mysql/upgrade_026_to_027.sh.in src/share/database/scripts/pgsql/upgrade_026_to_027.sh.in - new upgrade scripts configure.ac src/share/database/scripts/mysql/.gitignore src/share/database/scripts/mysql/Makefile.am src/share/database/scripts/pgsql/.gitignore src/share/database/scripts/pgsql/Makefile.am added new upgrade scripts src/bin/admin/tests/mysql_tests.sh.in updated mysql_upgrade_26_to_27_test() - new test src/bin/admin/tests/pgsql_tests.sh.in updated pgsql_upgrade_26_to_27_test() - new test src/lib/mysql/mysql_constants.h src/lib/pgsql/pgsql_connection.h updated schema version src/share/database/scripts/mysql/dhcpdb_create.mysql src/share/database/scripts/pgsql/dhcpdb_create.pgsql change client_class columns
* [#3587] use CHANGE instead of RENAME in MySQLRazvan Becheriu2024-10-292-18/+18
|
* [#3587] Fixed sql scripts and fuzzingThomas Markwalder2024-10-284-4/+4
| | | | | | | | | | | Changes to be committed: modified: ../../../fuzz/fuzz.h modified: ../../lib/dhcpsrv/ip_range_permutation.h modified: ../../lib/util/bigints.h modified: ../../share/database/scripts/mysql/dhcpdb_create.mysql modified: ../../share/database/scripts/mysql/upgrade_025_to_026.sh.in modified: ../../share/database/scripts/pgsql/dhcpdb_create.pgsql modified: ../../share/database/scripts/pgsql/upgrade_025_to_026.sh.in
* [#3587] Add update type update to create scriptsThomas Markwalder2024-10-282-0/+4
| | | | | | Changes to be committed: modified: mysql/dhcpdb_create.mysql modified: pgsql/dhcpdb_create.pgsql
* [#3587] addressed reviewRazvan Becheriu2024-10-284-20/+20
|
* [#3587] Bulk of the code changesThomas Markwalder2024-10-284-0/+112
| | | | | Everything except parsers, UTs to test deprecation, and doc.
* [#3631] fixed option_def_data_type int8 entry with id 3Razvan Becheriu2024-10-284-2/+6
|
* [#3583] add client_classes to option tablesThomas Markwalder2024-10-158-0/+163
| | | | | | | | | | | | | | | | | | | | | | | | | /src/share/database/scripts/mysql/upgrade_025_to_026.sh.in /src/share/database/scripts/pgsql/upgrade_025_to_026.sh.in - new files /src/share/database/scripts/mysql/dhcpdb_create.mysql /src/share/database/scripts/pgsql/dhcpdb_create.pgsql - adds client_classes to option tables /configure.ac /src/share/database/scripts/mysql/.gitignore /src/share/database/scripts/mysql/Makefile.am /src/share/database/scripts/pgsql/.gitignore /src/share/database/scripts/pgsql/Makefile.am - added new upgrade files /src/bin/admin/tests/pgsql_tests.sh.in /src/bin/admin/tests/mysql_tests.sh.in - Updated for new schema 26 /src/lib/mysql/mysql_constants.h /src/lib/pgsql/pgsql_connection.h Updated schema version
* [#1387] TypoFrancis Dupont2024-09-042-0/+0
|
* [#1387] Synchronized upgrade scriptsFrancis Dupont2024-09-042-4/+4
|
* [#1387] Checkpoint: fixesFrancis Dupont2024-09-041-1/+0
|
* [#1387] Checkpoint: updated schemaFrancis Dupont2024-09-049-0/+157
|
* [#3520] release changesKea-2.7.1Wlodek Wencel2024-07-292-2/+2
|
* [#3479] removed parameters from database and added unittestsRazvan Becheriu2024-07-184-0/+40
|
* [#3476] Addressed review commentsThomas Markwalder2024-07-184-0/+4
| | | | | | | | | | | | | modified: src/bin/admin/kea-admin.in src/lib/dhcp/option_data_types.h src/lib/dhcp/tests/option_definition_unittest.cc src/lib/dhcpsrv/testutils/generic_cb_dhcp4_unittest.cc src/lib/dhcpsrv/testutils/generic_cb_dhcp6_unittest.cc src/share/database/scripts/mysql/dhcpdb_create.mysql src/share/database/scripts/mysql/upgrade_023_to_024.sh.in src/share/database/scripts/pgsql/dhcpdb_create.pgsql src/share/database/scripts/pgsql/upgrade_023_to_024.sh.in
* [#3476] minor changesAndrei Pavel2024-07-184-8/+10
|
* [#3476] Add foreign key UTsThomas Markwalder2024-07-186-26/+18
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | /src/bin/admin/tests/mysql_tests.sh.in mysql_migrate_opt_record_type() - new test /src/bin/admin/tests/pgsql_tests.sh.in pgsql_migrate_opt_record_type() - new test /src/hooks/dhcp/mysql_cb/tests/mysql_cb_dhcp4_unittest.cc TEST_F(MySqlConfigBackendDHCPv4Test, invalidOptionDefDataType4Test) TEST_F(MySqlConfigBackendDHCPv4Test, allOptionDefDataTypes4Test) /src/hooks/dhcp/mysql_cb/tests/mysql_cb_dhcp6_unittest.cc TEST_F(MySqlConfigBackendDHCPv6Test, invalidOptionDefDataType6Test) TEST_F(MySqlConfigBackendDHCPv6Test, allOptionDefDataTypes6Test) /src/hooks/dhcp/pgsql_cb/tests/pgsql_cb_dhcp4_unittest.cc TEST_F(PgSqlConfigBackendDHCPv4Test, invalidOptionDefDataType4Test) TEST_F(PgSqlConfigBackendDHCPv4Test, allOptionDefDataTypes4Test) /src/hooks/dhcp/pgsql_cb/tests/pgsql_cb_dhcp6_unittest.cc TEST_F(PgSqlConfigBackendDHCPv6Test, invalidOptionDefDataType6Test) TEST_F(PgSqlConfigBackendDHCPv6Test, allOptionDefDataTypes4Test) /src/lib/dhcpsrv/testutils/generic_cb_dhcp4_unittest.* GenericConfigBackendDHCPv4Test::invalidOptionDefDataType4Test() GenericConfigBackendDHCPv4Test::allOptionDefDataTypes4Test() /src/lib/dhcpsrv/testutils/generic_cb_dhcp6_unittest.* GenericConfigBackendDHCPv6Test::invalidOptionDefDataType6Test() GenericConfigBackendDHCPv6Test::allOptionDefDataTypes6Test() /src/share/database/scripts/mysql/dhcpdb_create.mysql /src/share/database/scripts/mysql/upgrade_023_to_024.sh.in /src/share/database/scripts/pgsql/dhcpdb_create.pgsql /src/share/database/scripts/pgsql/upgrade_023_to_024.sh.in Modify table updates to only consider record_types /src/share/database/scripts/mysql/upgrade_022_to_023.sh.in /src/share/database/scripts/pgsql/upgrade_022_to_023.sh.in Check for 22.0 or 22.1
* [#3476] Correct option def data type enum overlapThomas Markwalder2024-07-1810-1/+396
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | new files: src/share/database/scripts/mysql/upgrade_023_to_024.sh.in src/share/database/scripts/pgsql/upgrade_023_to_024.sh.in configure.ac Added new upgrade files src/share/database/scripts/mysql/upgrade_023_to_024.sh src/share/database/scripts/pgsql/upgrade_023_to_024.sh src/bin/admin/kea-admin.in mysql_upgrade() pgsql_upgrade() - now sort scripts numerically src/bin/admin/tests/mysql_tests.sh.in mysql_upgrade_23_to_24_test() - new test function mysql_upgrade_test() - updated version check src/bin/admin/tests/pgsql_tests.sh.in pgsql_db_version_test() - updated version check pgsql_upgrade_23_to_24_test() - new test function src/lib/dhcp/option_data_types.h Set explicit values for OPT_RECORD_TYPE and OPT_UKNOWN_TYPE src/lib/dhcp/tests/option_definition_unittest.cc TEST(OptionDataTypeUtil, typeToString) TEST(OptionDataTypeUtil, stringToType) - new tests src/lib/mysql/mysql_constants.h Updated schema version to 24.0 src/lib/pgsql/pgsql_connection.h Updated schema version to 24.0 src/share/database/scripts/mysql/dhcpdb_create.mysql Added option_def_data_type table creation src/share/database/scripts/mysql/dhcpdb_drop.mysql Added option_def_data_type table drop src/share/database/scripts/pgsql/dhcpdb_create.pgsql Added option_def_data_type table creation src/share/database/scripts/pgsql/dhcpdb_drop.pgsql Added option_def_data_type table drop
* [#3497] consider minor schema number in CI jobAndrei Pavel2024-07-171-4/+5
|
* [#3480] add upgrade_022_to_023.sh to Makefile.amWlodek Wencel2024-07-042-0/+2
|
* [#3287] fix pylint warningsAndrei Pavel2024-06-201-2/+2
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | - C0115: Missing class docstring (missing-class-docstring) - C0123: Use isinstance() rather than type() for a typecheck. (unidiomatic-typecheck) - C0201: Consider iterating the dictionary directly instead of calling .keys() (consider-iterating-dictionary) - C0206: Consider iterating with .items() (consider-using-dict-items) - C0411: standard import "..." should be placed before "..." (wrong-import-order) - C0415: Import outside toplevel (...) (import-outside-toplevel) - C1802: Do not use `len(SEQUENCE)` without comparison to determine if a sequence is empty (use-implicit-booleaness-not-len) - E0001: Parsing failed: 'invalid syntax (<unknown>, line 2313)' (syntax-error) - E0401: Unable to import '...' (import-error) - E0602: Undefined variable 'l' (undefined-variable) - R0205: Class 'VagrantEnv' inherits from object, can be safely removed from bases in python3 (useless-object-inheritance) - E1101: Instance of 'NSECBASE' has no 'dump_fixedpart' member (no-member) - E1123: Unexpected keyword argument 'capture' in method call (unexpected-keyword-arg) - R0902: Too many instance attributes (too-many-instance-attributes) - R0913: Too many arguments (too-many-arguments) - R0916: Too many boolean expressions in if statement (6/5) (too-many-boolean-expressions) - R1717: Consider using a dictionary comprehension (consider-using-dict-comprehension) - R1722: Consider using 'sys.exit' instead (consider-using-sys-exit) - R1732: Consider using 'with' for resource-allocating operations (consider-using-with) - R1735: Consider using '{}' instead of a call to 'dict'. (use-dict-literal) - W0102: Dangerous default value sys.argv[1:] (builtins.list) as argument (dangerous-default-value) - W0102: Dangerous default value {} as argument (dangerous-default-value) - W0106: Expression "[f.write('%02x' % x) for x in bin_address]" is assigned to nothing (expression-not-assigned) - W0107: Unnecessary pass statement (unnecessary-pass) - W0201: Attribute 'config' defined outside __init__ (attribute-defined-outside-init) - W0404: Reimport '...' (imported line ...) (reimported) - W0611: Unused import ... (unused-import) - W0612: Unused variable '...' (unused-variable) - W0613: Unused argument '...' (unused-argument) - W0621: Redefining name '...' from outer scope (line 1471) (redefined-outer-name) - W0622: Redefining built-in '...' (redefined-builtin) - W0707: Consider explicitly re-raising using 'raise ... from ...' (raise-missing-from) - W0718: Catching too general exception Exception (broad-exception-caught) - W1202: Use lazy % formatting in logging functions (logging-format-interpolation) - W1203: Use lazy % formatting in logging functions (logging-fstring-interpolation) - W1308: Duplicate string formatting argument 'connection_type', consider passing as named argument (duplicate-string-formatting-argument) - W1401: Anomalous backslash in string: '\/'. String constant might be missing an r prefix. (anomalous-backslash-in-string) - W1406: The u prefix for strings is no longer necessary in Python >=3.0 (redundant-u-string-prefix) - W1514: Using open without explicitly specifying an encoding (unspecified-encoding) - W4901: Deprecated module 'optparse' (deprecated-module) - W4904: Using deprecated class SafeConfigParser of module configparser (deprecated-class)
* [#3287] fix pycodestyle warningsAndrei Pavel2024-06-201-2/+4
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | - E111 indentation is not a multiple of 4 - E117 over-indented - E125 continuation line with same indent as next logical line - E127 continuation line over-indented for visual indent - E128 continuation line under-indented for visual indent - E129 visually indented line with same indent as next logical line - E131 continuation line unaligned for hanging indent - E201 whitespace after '[' - E201 whitespace after '{' - E202 whitespace before ')' - E202 whitespace before ']' - E202 whitespace before '}' - E203 whitespace before ' - E203 whitespace before ',' - E222 multiple spaces after operator - E225 missing whitespace around operator - E228 missing whitespace around modulo operator - E231 missing whitespace after ',' - E251 unexpected spaces around keyword / parameter equals - E261 at least two spaces before inline comment - E262 inline comment should start with '# ' - E265 block comment should start with '# ' - E301 expected 1 blank line, found 0 - E302 expected 2 blank lines, found 1 - E303 too many blank lines (2) - E305 expected 2 blank lines after class or function definition, found 1 - E306 expected 1 blank line before a nested definition, found 0 - E401 multiple imports on one line - E402 module level import not at top of file - E501 line too long - E502 the backslash is redundant between brackets - E703 statement ends with a semicolon - E713 test for membership should be 'not in' - E722 do not use bare 'except' - E741 ambiguous variable name 'l' - W605 invalid escape sequence '\/'
* [#3287] fix bandit warningsAndrei Pavel2024-06-201-2/+6
|
* [#3287] fix reported shellcheck warningsAndrei Pavel2024-06-201-1/+1
|
* [#3246] Do not delete soft released leasesMarcin Siodelski2024-06-196-0/+158
|
* [#3430] bump up library versions for 2.6.0 releaseRazvan Becheriu2024-05-241-0/+4
|
* [#2959] use 0 and 1 instead of false and trueRazvan Becheriu2024-05-246-60/+60
|
* [#2959] partially migrate reservation_mode in CBRazvan Becheriu2024-05-244-60/+108
|
* [#2958] add upgrade scriptRazvan Becheriu2024-05-226-0/+141
|
* [#3396] Add script to Makefile.amThomas Markwalder2024-05-211-0/+1
| | | | modified: src/share/database/scripts/mysql/Makefile.am
* [#3396] Moved column alters to new schema 22Thomas Markwalder2024-05-214-6/+75
| | | | | | | | | | | | | | | | | | | | | | | configure.ac Added mysql/upgrade_019_to_020.sh src/bin/admin/tests/mysql_tests.sh.in Updated, adjusted for version check src/lib/mysql/mysql_constants.h Bumped schema version to 22 src/share/database/scripts/mysql/.gitignore upgrade_019_to_020.sh src/share/database/scripts/mysql/dhcpdb_create.mysql Moved expire column statements into version 22 update section src/share/database/scripts/mysql/upgrade_020_to_021.sh.in Removed expire column updates src/share/database/scripts/mysql/upgrade_020_to_021.sh.in New file, modifies expire columns
* [#3396] Modify leaseX expire columns to accept nullThomas Markwalder2024-05-213-0/+12
| | | | | | | | | | | | | src/share/database/scripts/mysql/dhcpdb_create.mysql Change expire column in lease4 and lease6 to accept NULL src/share/database/scripts/mysql/upgrade_018_to_019.sh.in Change expire column in lease6 to accept NULL src/share/database/scripts/mysql/upgrade_020_to_021.sh.in Change expire column in lease4 and lease6 to accept NULL Added ChangeLog entry
* [#2957] Addressed review commentsThomas Markwalder2024-04-222-2/+2
| | | | Minor corrections, added ChangeLog and fixed db-version UT.
* [#2957] Fix dhcp4_server_modification_ts indexThomas Markwalder2024-04-224-0/+69
| | | | | | | | | | | | | | | | | | | | | src/share/database/scripts/pgsql/upgrade_020_to_021.sh.in - new file, corrects dhcp4_server_modifcation_ts index configure.ac added src/share/database/scripts/pgsql/upgrade_020_to_021.sh src/bin/admin/tests/pgsql_tests.sh.in Added pgsql_upgrade_20_to_21_test() src/lib/pgsql/pgsql_connection.h Updated schema version src/share/database/scripts/pgsql/.gitignore src/share/database/scripts/pgsql/Makefile.am Added upgrade_020_to_021.sh src/share/database/scripts/pgsql/dhcpdb_create.pgsql Added correction of dhcp4_server_modifcation_ts index
* [#3263] release changesAndrei Pavel2024-02-2656-56/+56
|
* [#3025] use admin-utils.sh based on location in upgrade scriptsAndrei Pavel2024-02-2258-290/+406
|
* [#3025] appease shellcheckAndrei Pavel2024-02-2258-177/+116
| | | | | | | | | | . "${admin_utils}" ^--------------^ SC1090: Can't follow non-constant source. Use a directive to specify location. version=$(checked_mysql_version) ^-------------------^ SC2119: Use checked_mysql_version "$@" if function's $1 should mean script's $1. ... and others that spiraled afterwards
* [#3237] release changesWlodek Wencel2024-01-294-4/+4
|
* [#3149] Added a new indexFrancis Dupont2024-01-178-0/+145
|
* [#2869] Removed duplicated commentFrancis Dupont2023-07-071-2/+0
|
* [#2869] Finished delete cascadeFrancis Dupont2023-07-062-0/+24
|
* [#2869] Checkpoint add delete cascadeFrancis Dupont2023-07-062-0/+24
|
* [#2869] Moved to inet in PostgreSQLFrancis Dupont2023-07-062-0/+27
|
* [#2276] Upgrade global param values in DBThomas Markwalder2023-07-068-0/+204
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Convert ddns-use-conflict-resolution to ddns-conflict-resolution-mode in DB configure.ac Added new upgrade files src/bin/admin/tests/mysql_tests.sh.in src/bin/admin/tests/pgsql_tests.sh.in new upgrade tests src/lib/mysql/mysql_constants.h src/lib/pgsql/pgsql_connection.h update schema version src/share/database/scripts/mysql/.gitignore src/share/database/scripts/mysql/Makefile.am src/share/database/scripts/mysql/upgrade_019_to_020.sh.in new upgrade script src/share/database/scripts/mysql/dhcpdb_create.mysql added conversion logic to stay in sync with upgrade script src/share/database/scripts/pgsql/Makefile.am src/share/database/scripts/pgsql/.gitignore src/share/database/scripts/pgsql/upgrade_018_to_019.sh.in new upgrade script src/share/database/scripts/pgsql/dhcpdb_create.pgsql added conversion logic to stay in sync with upgrade script
* [#2909] Migrated v6 addresses to inetThomas Markwalder2023-06-224-0/+299
| | | | | | | | | | | | | | | | | | | | | | | | | | src/share/database/scripts/pgsql/upgrade_016_to_017.sh.in New file configure.ac Added new upgrade file src/bin/admin/tests/pgsql_tests.sh.in Updated tests src/lib/dhcpsrv/pgsql_host_data_source.cc Modified SQL to convert ipv6_reservations.address to/from inet src/lib/dhcpsrv/pgsql_lease_mgr.* Modified SQL to convert lease6.address to/from inet Removed binaddr column Removed PgSqlLeaseMgr::upgradeBinaryAddress6() src/lib/pgsql/pgsql_connection.h Updated schema version src/share/database/scripts/pgsql/dhcpdb_create.pgsql Altered lease6,ipv6_reservastions table Updated v6 dump and upload functions
* [#2909] Readd not null constraintThomas Markwalder2023-06-212-0/+2
|
* [#2909] More review fixesThomas Markwalder2023-06-212-4/+12
| | | | | | | modified: src/bin/admin/tests/mysql_tests.sh.in src/share/database/scripts/mysql/dhcpdb_create.mysql src/share/database/scripts/mysql/upgrade_018_to_019.sh.in
* [#2909] Addressed additional review commentsThomas Markwalder2023-06-212-14/+29
|
* [#2909] Addressed review commentsThomas Markwalder2023-06-212-10/+28
| | | | | | | | | | | | | src/bin/admin/tests/mysql_tests.sh.in Added test to verify lease6 address and ipv6 reservation address column data conversion src/lib/dhcpsrv/mysql_host_data_source.cc Use isc::asiolink::V6ADDRESS_LEN; src/share/database/scripts/mysql/dhcpdb_create.mysql src/share/database/scripts/mysql/upgrade_018_to_019.sh.in Add data conversion logic for lease6 and ipv6_reservation columns
* [#2909] Mysql v6 addresses to binaryThomas Markwalder2023-06-214-0/+284
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | lease6.address and ipv6_reservations.address columns changed from varbinary(39) to binary(16). lease6.binaddr column removed deleted: src/share/api/binary-address6-upgrade.json new file: src/share/database/scripts/mysql/upgrade_018_to_019.sh.in configure.ac added new mysql upgrade script doc/sphinx/arm/hooks-lease-query.rst removed doc for binary-address6-upgrade command src/bin/admin/tests/mysql_tests.sh.in modified to use inet6_aton/ntoa as now needed Updated to test upgrage src/lib/dhcpsrv/lease_mgr.h LeaseMgr::upgradeBinaryAddress6() - no longer abstract, provides a dummy implemention src/lib/dhcpsrv/mysql_host_data_source.cc Change v6 reservation address to binary src/lib/dhcpsrv/mysql_lease_mgr.* Remove lease6.binaddr and uses Change lease6.address to binary src/lib/mysql/mysql_constants.h Update schema version src/share/api/api_files.mk Remove binary-address6-upgrade.json src/share/database/scripts/mysql/Makefile.am Add upgrade script src/share/database/scripts/mysql/dhcpdb_create.mysql Modify lease6, ipv6_reservations, and impacted functions
generated by cgit v1.2.3 (git 2.39.1) at 2024-12-02 08:12:17 +0100