123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632 |
- #ifndef MYSQL_LEASE_MGR_H
- #define MYSQL_LEASE_MGR_H
- #include <dhcp/hwaddr.h>
- #include <dhcpsrv/lease_mgr.h>
- #include <dhcpsrv/mysql_connection.h>
- #include <boost/scoped_ptr.hpp>
- #include <boost/utility.hpp>
- #include <mysql.h>
- #include <time.h>
- namespace isc {
- namespace dhcp {
- class MySqlLease4Exchange;
- class MySqlLease6Exchange;
- class MySqlLeaseMgr : public LeaseMgr {
- public:
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
- MySqlLeaseMgr(const DatabaseConnection::ParameterMap& parameters);
-
- virtual ~MySqlLeaseMgr();
-
- static std::string getDBVersion();
-
-
-
-
-
-
-
-
-
- virtual bool addLease(const Lease4Ptr& lease);
-
-
-
-
-
-
-
-
-
- virtual bool addLease(const Lease6Ptr& lease);
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
- virtual Lease4Ptr getLease4(const isc::asiolink::IOAddress& addr) const;
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
- virtual Lease4Collection getLease4(const isc::dhcp::HWAddr& hwaddr) const;
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
- virtual Lease4Ptr getLease4(const isc::dhcp::HWAddr& hwaddr,
- SubnetID subnet_id) const;
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
- virtual Lease4Collection getLease4(const ClientId& clientid) const;
-
-
-
-
-
-
-
-
-
-
- virtual Lease4Ptr getLease4(const ClientId& client_id, const HWAddr& hwaddr,
- SubnetID subnet_id) const;
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
- virtual Lease4Ptr getLease4(const ClientId& clientid,
- SubnetID subnet_id) const;
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
- virtual Lease6Ptr getLease6(Lease::Type type,
- const isc::asiolink::IOAddress& addr) const;
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
- virtual Lease6Collection getLeases6(Lease::Type type, const DUID& duid,
- uint32_t iaid) const;
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
- virtual Lease6Collection getLeases6(Lease::Type type, const DUID& duid,
- uint32_t iaid, SubnetID subnet_id) const;
-
-
-
-
-
-
-
-
-
-
- virtual void getExpiredLeases6(Lease6Collection& expired_leases,
- const size_t max_leases) const;
-
-
-
-
-
-
-
-
-
-
- virtual void getExpiredLeases4(Lease4Collection& expired_leases,
- const size_t max_leases) const;
-
-
-
-
-
-
-
-
-
-
-
- virtual void updateLease4(const Lease4Ptr& lease4);
-
-
-
-
-
-
-
-
-
-
-
- virtual void updateLease6(const Lease6Ptr& lease6);
-
-
-
-
-
-
-
-
-
- virtual bool deleteLease(const isc::asiolink::IOAddress& addr);
-
-
-
-
-
-
-
- virtual uint64_t deleteExpiredReclaimedLeases4(const uint32_t secs);
-
-
-
-
-
-
-
- virtual uint64_t deleteExpiredReclaimedLeases6(const uint32_t secs);
-
-
-
-
-
- virtual std::string getType() const {
- return (std::string("mysql"));
- }
-
-
-
-
-
- virtual std::string getName() const;
-
-
-
-
-
- virtual std::string getDescription() const;
-
-
-
-
-
-
-
- virtual std::pair<uint32_t, uint32_t> getVersion() const;
-
-
-
-
-
-
- virtual void commit();
-
-
-
-
-
-
- virtual void rollback();
-
-
-
- enum StatementIndex {
- DELETE_LEASE4,
- DELETE_LEASE4_STATE_EXPIRED,
- DELETE_LEASE6,
- DELETE_LEASE6_STATE_EXPIRED,
- GET_LEASE4_ADDR,
- GET_LEASE4_CLIENTID,
- GET_LEASE4_CLIENTID_SUBID,
- GET_LEASE4_HWADDR,
- GET_LEASE4_HWADDR_SUBID,
- GET_LEASE4_EXPIRE,
- GET_LEASE6_ADDR,
- GET_LEASE6_DUID_IAID,
- GET_LEASE6_DUID_IAID_SUBID,
- GET_LEASE6_EXPIRE,
- GET_VERSION,
- INSERT_LEASE4,
- INSERT_LEASE6,
- UPDATE_LEASE4,
- UPDATE_LEASE6,
- RECOUNT_LEASE4_STATS,
- NUM_STATEMENTS
- };
- private:
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
- bool addLeaseCommon(StatementIndex stindex, std::vector<MYSQL_BIND>& bind);
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
- template <typename Exchange, typename LeaseCollection>
- void getLeaseCollection(StatementIndex stindex, MYSQL_BIND* bind,
- Exchange& exchange, LeaseCollection& result,
- bool single = false) const;
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
- void getLeaseCollection(StatementIndex stindex, MYSQL_BIND* bind,
- Lease4Collection& result) const {
- getLeaseCollection(stindex, bind, exchange4_, result);
- }
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
- void getLeaseCollection(StatementIndex stindex, MYSQL_BIND* bind,
- Lease6Collection& result) const {
- getLeaseCollection(stindex, bind, exchange6_, result);
- }
-
-
-
-
-
-
-
-
-
- void getLease(StatementIndex stindex, MYSQL_BIND* bind,
- Lease4Ptr& result) const;
-
-
-
-
-
-
-
-
-
- void getLease(StatementIndex stindex, MYSQL_BIND* bind,
- Lease6Ptr& result) const;
-
-
-
-
-
-
-
-
-
-
-
-
-
-
- template<typename LeaseCollection>
- void getExpiredLeasesCommon(LeaseCollection& expired_leases,
- const size_t max_leases,
- StatementIndex statement_index) const;
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
- template <typename LeasePtr>
- void updateLeaseCommon(StatementIndex stindex, MYSQL_BIND* bind,
- const LeasePtr& lease);
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
- uint64_t deleteLeaseCommon(StatementIndex stindex, MYSQL_BIND* bind);
-
-
-
-
-
-
-
-
-
- uint64_t deleteExpiredReclaimedLeasesCommon(const uint32_t secs,
- StatementIndex statement_index);
-
-
-
-
-
-
-
-
- virtual AddressStatsQuery4Ptr startAddressStatsQuery4();
-
-
-
-
-
-
-
-
-
-
- void checkError(int status, StatementIndex index,
- const char* what) const;
-
-
-
-
-
- boost::scoped_ptr<MySqlLease4Exchange> exchange4_;
- boost::scoped_ptr<MySqlLease6Exchange> exchange6_;
-
- MySqlConnection conn_;
- };
- };
- };
- #endif
|