summaryrefslogtreecommitdiff
path: root/src/share/database/scripts
AgeCommit message (Collapse)Author
2018-07-23[github88] CQL/SQL scripts corrected (unit-tests in src/bin/admin now pass)Tomek Mrugalski
2018-07-23[github88] Schema creation scripts fixed.Tomek Mrugalski
2018-07-23fixed minor issuesmayya
2018-07-23review comments 2mayya
review comments 2 test1 fixed unit tests fixed cassandra fixed cassandra2
2018-07-23[lib] Address review comments for #83mayya
See #88 for review comments modified upgrade files modified tests
2018-07-23[lib] Extend host structure to support auth keys for reconfiguration.mayya
See issue #83
2018-07-07[5584] Addressed commentsFrancis Dupont
2018-07-06[5584] Minor changes after review.Tomek Mrugalski
2018-06-22[5584] Checkpoint: core code and test doneFrancis Dupont
2018-06-21[5584] Checkpoint: fixesFrancis Dupont
2018-06-21[5584] Checkpoint: updated schema, code and partially testsFrancis Dupont
2018-05-24[master] Copyright update to 2018Wlodek Wencel
2018-05-09[5587] PostgreSQL support for shared lease stats implementationThomas Markwalder
src/share/database/scripts/pgsql/dhcpdb_create.pgsql Adds lease<4/6>_stat tables and triggers src/share/database/scripts/pgsql/dhcpdb_drop.pgsql Added drops for lease<4/6>_stat tables and triggers src/share/database/scripts/pgsql/upgrade_3.3_to_4.0.sh.in Adds lease<4/6>_stat tables and triggers Populates stat tables from existing lease table content src/bin/admin/tests/mysql_tests.sh.in mysql_lease6_stat_per_type() - fixed typo in test src/bin/admin/tests/pgsql_tests.sh.in run_statement() - new convenience fucntion for running statement with option expected outcome pgsql_upgrade_schema_to_version() - new function which converts the existing schema to a target version pgsql_lease4_stat_test() - tests v4 stat table and triggers in an new database pgsql_lease6_stat_test() - tests v6 stat table and triggers in an new database. pgsql_lease6_stat_per_type() - helper function which tests v6 stat table and triggers using a given address and lease type pgsql_lease_stat_upgrade_test() - tests data migration, stat table and trigger operations on an upgraded database src/lib/dhcpsrv/pgsql_lease_mgr.* Added new SQL statements for lease stats queries PgSqlLeaseStatsQuery Constructors - added variants to support where clause params start() - modified to support query variants based on where clause params PgSqlLeaseMgr Added start variants: - startSubnetLeaseStatsQuery4(const SubnetID& subnet_id) - startSubnetRangeLeaseStatsQuery4(const SubnetID& first_subnet_id, const SubnetID& last_subnet_id) src/lib/dhcpsrv/tests/pgsql_lease_mgr_unittest.cc New unit tests: - TEST_F(PgSqlLeaseMgrTest, leaseStatsQuery4) - TEST_F(PgSqlLeaseMgrTest, leaseStatsQuery6)
2018-05-09[master] MySQL support for shared lease stats implementedThomas Markwalder
Merge branch 'trac5586'
2018-05-08[5586] Added schema unit testsThomas Markwalder
src/share/database/scripts/mysql/upgrade_5.2_to_6.0.sh.in Added SQL statements to populate lease4/6_stat tables from existing lease table content. src/bin/admin/tests/dhcpdb_create_5.1.mysql New file used for upgrade testing src/bin/admin/tests/mysql_tests.sh.in run_statement() - new convenience function for running SQL statements with an optional expected return value mysql_lease4_stat_test() - verifies lease4_stat table and trigger operations on a new database mysql_lease6_stat_test() mysql_lease6_stat_per_type() - new functions which lease6_stat table and trigger operations on a new database mysql_lease_stat_upgrade_test() - new function which verifies data migration from an earlier schema and trigger operation
2018-05-02[5586] MySQL shared leases stats implementedThomas Markwalder
src/share/database/scripts/mysql/dhcpdb_create.mysql src/share/database/scripts/mysql/dhcpdb_drop.mysql src/share/database/scripts/mysql/upgrade_5.2_to_6.0.sh.in Added MySQL v4/6 stat tables and triggers src/lib/dhcpsrv/memfile_lease_mgr.cc Suppress output of of rows with count values of 0 src/lib/dhcpsrv/mysql_lease_mgr.* Added v4/v6 lease stat SQL statements MySqlLeaseStatsQuery - Added ctor variants that accomodate selection criteria - Modified start() to handle three variants of selection MySqlLeaseMgr - Added start***Query4/6 variants src/lib/dhcpsrv/tests/mysql_lease_mgr_unittest.cc Added tests: - TEST_F(MySqlLeaseMgrTest, leaseStatsQuery4) - TEST_F(MySqlLeaseMgrTest, leaseStatsQuery6)
2018-03-12[master] Merge branch 'github70' (missing CQL backend features)Tomek Mrugalski
- host delete - user-contexts - DHCPv4 fixed fields - also PostgreSQL now stores hwaddr type and hwaddr source # Conflicts: # src/lib/dhcpsrv/tests/pgsql_host_data_source_unittest.cc
2018-03-05[master] subnet_id column types now consistent in schemasThomas Markwalder
Merges in branch 'trac5522'
2018-03-05Merge branch 'cassandra_improvements' of ↵Tomek Mrugalski
https://github.com/razvan-becheriu/kea into github70
2018-03-02[5522] Removed whitespace errors in a couple of files.Marcin Siodelski
2018-02-27[5437] Replaced index by iaid_subnet_id_duid with duid_iaid_subnet_id.Marcin Siodelski
2018-02-22[5522] Fixed subnet_id column types in MySQL and Postgres schemasThomas Markwalder
new file: src/share/database/scripts/mysql/upgrade_5.1_to_5.2.sh.in renamed: src/share/database/scripts/mysql/upgrade_5.1_to_6.0.sh.in -> src/share/database/scripts/mysql/upgrade_5.2_to_6.0.sh.in new file: src/share/database/scripts/pgsql/upgrade_3.2_to_3.3.sh.in renamed: src/share/database/scripts/pgsql/upgrade_3.2_to_4.0.sh.in -> src/share/database/scripts/pgsql/upgrade_3.3_to_4.0.sh.in src/lib/dhcpsrv/pgsql_host_data_source.cc changed OID_INT4 to OID_INT8 for subnet_id inputs in TaggedStatements src/lib/dhcpsrv/tests/generic_host_data_source_unittest.h src/lib/dhcpsrv/tests/generic_host_data_source_unittest.cc src/lib/dhcpsrv/tests/mysql_host_data_source_unittest.cc src/lib/dhcpsrv/tests/pgsql_host_data_source_unittest.cc Added new tests to verify maxium value for subnet_id works src/share/database/scripts/mysql/dhcpdb_create.mysql Added 5.1 to 5.2 changes src/share/database/scripts/pgsql/dhcpdb_create.pgsql Added 3.2 to 3.3 changes
2018-02-15fix unit testsRazvan Becheriu
2018-02-15fixed primary key of dhcp_option_scope tableRazvan Becheriu
2018-02-15minor changesRazvan Becheriu
2018-02-14fixed compilationRazvan Becheriu
2018-02-14minor changesRazvan Becheriu
2018-02-13[master] Support for Google benchmark added.Tomek Mrugalski
# Conflicts: # doc/guide/install.xml # src/lib/dhcpsrv/tests/generic_host_data_source_unittest.cc # src/lib/dhcpsrv/testutils/lease_file_io.cc
2018-02-13added missing tables, columns and values in cql schema, ordered declarations ↵Razvan Becheriu
and definitions in lease and host managers
2018-02-08[master] Finishing merge of trac5494 (Cassandra vs macOS)Francis Dupont
2018-02-08[5494] Added HWADDR_SOURCE_DOCSIS_MODEMFrancis Dupont
2018-02-08Merge branch 'trac5494' into github36Tomek Mrugalski
2018-02-08fixed mergeRazvan Becheriu
2018-01-15[master] Merge branch 'trac5468'Marcin Siodelski
2018-01-11[master] Merge branch 'github37' (Cassandra host reservations)Tomek Mrugalski
# Conflicts: # src/lib/dhcpsrv/tests/generic_host_data_source_unittest.cc
2018-01-09[5468] Added lease indexing by subnet identifiers and lease type.Marcin Siodelski
2017-12-31[5494] Drop options tablesFrancis Dupont
2017-12-31[master] Finishing merge of trac5351 (user context / comment)Francis Dupont
2017-12-17[5351] Addressed nearly all commentsFrancis Dupont
2017-12-15fixed cql create db scriptRazvan Becheriu
2017-12-12Merge remote-tracking branch 'andrei-remote/cassandra-update' into HEADRazvan Becheriu
2017-12-12Merge remote-tracking branch 'isc-kea/master' into HEADRazvan Becheriu
2017-12-03[5351] Checkpoint: todo host DB testsFrancis Dupont
2017-12-01[5351] Checkpoint: added user context in options stored in DBs, todo add testsFrancis Dupont
2017-11-07[5416] Allow null or 0 values in unique indexes within hosts table.Marcin Siodelski
Also, updated MySQL backend to convert 0 values to null to make sure that multiple reservations are possible when IPv4 address is unspecified.
2017-10-25[master] Multiple build fixes for kea 1.3 as a result of sanity check.Marcin Siodelski
2017-10-20[5266] Added *.sh from *.sh.in to distcleanFrancis Dupont
2017-10-20[5266] Added *.sh from *.sh.in to distcleanFrancis Dupont
2017-08-18Merge branch 'cassandra-update' into cassandra-host-data-sourceAndrei Pavel
2017-08-18boost::any for cassandra and more:Andrei Pavel
- replaced void* with boost::any for type safety (might be just a bit less efficient) - replaced a multi-index-container used for statement parameters ( with position index and name index ) and a vector of the same parameters with a compile-time type-based map - refactored lease manager to use exchanges - exchanges now support UDTs (user defined types) and collections to be used in Cassandra statements - replaced size-ambiguous types (e.g. int) with size-explicit types (e.g. int32_t) in Cassandra-related code - made exception messages and log messages more detailed and consistent in format
generated by cgit v1.2.3 (git 2.39.1) at 2026-09-14 10:08:06 +0000