[Kea-users] Need help in MySQL queries - KEA

[Nandan Adhikari]

Hi,

I am writing a service which assigns IP addresses to newly provisioned VMs
or physical machines from a pre-defined IP pool. I want to use KEA with
Galera MySQL backend. The problem I am facing is that there is no docs/info
regarding the Table schema details or SQL queries to do common tasks like:

1) lease lookup by mac/ip
2) reservation lookup by mac/ip
3) add new lease
4) delete an existing lease

Here is what I am thinking for above APIs:

1) lease lookup by mac: (SELECT INET_NTOA(address) as address, HEX(hwaddr)
as hwaddr, hostname from lease4 where HEX(hwaddr)= ?", macid)

If you could advice me on how to write such API's to do basic management.

-- 
Thanks & warm wishes,
Nandan Adhikari
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.isc.org/pipermail/kea-users/attachments/20161227/f0c204d3/attachment.htm>