From a5602dd8cdec8cb8ce85cbc5fab29a91f533d2af Mon Sep 17 00:00:00 2001 From: Niall Sheridan Date: Sun, 28 Aug 2016 17:33:14 +0100 Subject: List only certs which haven't expired --- server/store/sqldb.go | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'server/store/sqldb.go') diff --git a/server/store/sqldb.go b/server/store/sqldb.go index 2ea5ea5..54a52c6 100644 --- a/server/store/sqldb.go +++ b/server/store/sqldb.go @@ -66,7 +66,7 @@ func NewSQLStore(config string) (CertStorer, error) { if db.get, err = conn.Prepare("SELECT * FROM issued_certs WHERE key_id = ?"); err != nil { return nil, fmt.Errorf("sqldb: prepare get: %v", err) } - if db.list, err = conn.Prepare("SELECT * FROM issued_certs"); err != nil { + if db.list, err = conn.Prepare("SELECT * FROM issued_certs WHERE ? <= expires_at"); err != nil { return nil, fmt.Errorf("sqldb: prepare list: %v", err) } if db.revoke, err = conn.Prepare("UPDATE issued_certs SET revoked = 1 WHERE key_id = ?"); err != nil { @@ -137,7 +137,7 @@ func (db *sqldb) List() ([]*CertRecord, error) { return nil, err } var recs []*CertRecord - rows, _ := db.list.Query() + rows, _ := db.revoked.Query(time.Now().UTC()) defer rows.Close() for rows.Next() { cert, err := scanCert(rows) -- cgit v1.2.3