API for retrieving leases

[muja]

There already seems to be an API for metrics/health etc.
An API to show the current active leases would be awesome. Specifically, I need to communicate the leases to my DNS server for internal hostname resolution

[leshow]

Noted! The workaround right now is by talking to the sqlite database directly, but I agree a API in dora would be nice

[muja]

I looked inside the DB and couldn't find that info?

[leshow]

it should be there if you have any leases? for example:

Enter ".help" for usage hints.
sqlite> select * from leases;
3232236802|�k|1|1710915902|3232236800|0
3232236803|��~Ǔ]|1|1710915922|3232236800|0
3232236804|��@�|1|1710915926|3232236800|0
3232236805|�m���|1|1710915928|3232236800|0

and the table is in migrations/ for reference

CREATE TABLE IF NOT EXISTS leases(
    ip INTEGER NOT NULL,
    client_id BLOB,
    leased BOOLEAN NOT NULL DEFAULT 0,
    expires_at INTEGER NOT NULL,
    network INTEGER NOT NULL,
    probation BOOLEAN NOT NULL DEFAULT 0,
    PRIMARY KEY(ip)
);
CREATE INDEX idx_ip_expires on leases (ip, expires_at);

if you needed to find say, all the leases where the expiry time was great than now, you could do:

sqlite> select * from leases where leased = true and expires_at > strftime('%s', 'now');
3232236802|�k|1|1710915902|3232236800|0
3232236803|��~Ǔ]|1|1710915922|3232236800|0
3232236804|��@�|1|1710915926|3232236800|0
3232236805|�m���|1|1710915928|3232236800|0

However, I agree this is not an ideal way to get the information, I think something like this should be added

[muja]

You're talking about the client_id? The hostnames I'm dealing with are ASCII but the client_id is some binary gibberish

[leshow]

Oh, you can change that to different formats in your query:

sqlite> select hex(client_id) from leases;
9C6B00123DAF
85FF7EC7935D
12F4AA15408C
856DFFA710E7