aboutsummaryrefslogtreecommitdiff
path: root/dbstore
AgeCommit message (Collapse)AuthorFilesLines
2022-03-18dbstore/dbstore.go: CisaSearch(): json_group_array() aggregates rows in an ↵Paul Duncan1-0/+4
arbitrary order, so use sort.Sort() to sort the results in ascending order
2022-03-18dbstore/cisasearchrow.go: add byRank sort.InterfacePaul Duncan1-0/+18
2022-03-18dbstore/dbstore_test.go: fix TestCisaSearch()Paul Duncan1-2/+47
2022-03-18dbstore/sql/cisa/search.sql: add description columnPaul Duncan1-0/+1
2022-03-18dbstore/sql/cisa/search.sql: fix vendor and product namesPaul Duncan1-2/+6
2022-03-18dbstore/dbstore_test.go: add TestCisaSearch()Paul Duncan1-0/+31
2022-03-18dbstore/cisasearchrow.go: fix cve_id json annotationPaul Duncan1-1/+1
2022-03-16add dbstore/testdata/mock-cisasearch.dbPaul Duncan1-0/+0
2022-03-16dbstore/dbstore_test.go: add TestAddCisaCatalogs() and stub TestCisaSearch()Paul Duncan1-0/+85
2022-03-16dbstore/dbstore.go: add AddCisaCatalogs() and CisaSearch()Paul Duncan1-0/+154
2022-03-16add dbstore/sql/cisaPaul Duncan6-0/+59
2022-03-16dbstore/sql/init.sql: fix cisa field limitsPaul Duncan1-7/+18
2022-03-16add dbstore/testdata/cisa-kevc-20220313.json.gzPaul Duncan1-0/+1
2022-03-16add dbstore/testdata/cisa-kevc-20220313-tiny.json.gzPaul Duncan1-0/+1
2022-03-16add dbstore/cisasearchrow.goPaul Duncan1-0/+21
2022-03-16dbstore/sql/init.sql: fix misc typosPaul Duncan1-6/+6
2022-03-15dbstore/sql/init.sql: add cisa kev tables and ftsPaul Duncan1-0/+189
2022-03-15dbstore/dbstore.go: fix query IDs variable namePaul Duncan1-2/+2
2022-02-26dbstore/dbstore_test.go: update skip messages for several tests, add ↵Paul Duncan1-4/+86
TestAddCveFeed(), add use readonly.db to test Init() failure in several tests
2022-02-26add dbstore/testdata/readonly.dbPaul Duncan1-0/+0
2022-02-26dbstore/dbstore_test.go: add TestTx(), TestQuery(), and TestQueryRow()Paul Duncan1-0/+254
2022-02-26dbstore: add dbstore/sql/test/query{,row}Paul Duncan6-0/+46
2022-02-26dbstore/dbstore.go: fix QueryRow documentationPaul Duncan1-1/+1
2022-02-26dbstore: add dbstore/sqlfs_test.goPaul Duncan2-44/+49
2022-02-26dbstore/dbstore.go: move addCpeDictionaryQueryIdsPaul Duncan1-6/+7
2022-02-26dbstore: add dbstore/util.go w/ testsPaul Duncan3-27/+73
2022-02-22dbstore: update tests to exclude excrutiating ones in short test modePaul Duncan1-0/+20
2022-02-20dbstore: shrink CVE FTS index (test index from 120M to 86M) by removing all ↵Paul Duncan4-108/+90
IDs except cve_id, concatenating reference tags, and removing severities
2022-02-20dbstore/sql/init.sql: remove per-table cve fts triggers, add size notes and ↵Paul Duncan1-486/+12
TODO to cve fts refresh table
2022-02-20dbstore/sql/init.sql: fix printf() in cve_nvd_idsPaul Duncan1-1/+1
2022-02-20dbstore/dbstore_test.go: replace TestAddCveFeed() with TestAddCveFeeds()Paul Duncan1-17/+18
2022-02-20dbstore: add AddCveFeeds(), fix bugs, fix TestAddCveFeedPaul Duncan4-25/+75
2022-02-20dbstore/sql/init.sql: add cve_nvd_ids, remove existing cve_all triggers, add ↵Paul Duncan1-417/+512
cve_fts_refresh with triggers
2022-02-19dbstore: add CveSearch() and test (but not test data)Paul Duncan2-1/+76
2022-02-19dbstore: add CveSearch() and test (but not test data)Paul Duncan2-0/+47
2022-02-19dbstore/sql/init.sql: add cve_fts_all (note: 10x test db size increase, from ↵Paul Duncan1-0/+556
31M to 320M)
2022-02-19add dbstore/sql/feed/insert-assigner.sqlPaul Duncan1-0/+13
2022-02-19dbstore: store cve year and number instead of CVE ID, add and use assigners ↵Paul Duncan3-8/+44
table
2022-02-19dbstore/dbstore.go: fix query parameters, make v2 impact and v3 impact optionalPaul Duncan1-11/+21
2022-02-19dbstore/sql/init.sql: s/severeties/severities/, tighten cpe23, lang, and cve ↵Paul Duncan1-13/+11
ID constraints
2022-02-19dbstore/sql/feed: fix misc query typosPaul Duncan2-4/+3
2022-02-19dbstore/dbstore_test.go: add TestAddCveFeed()Paul Duncan1-0/+59
2022-02-19dbstore/testdata: add nvdcve-1.1-*.json.gz symlinksPaul Duncan3-0/+3
2022-02-19add dbstore/sql/feedPaul Duncan11-0/+52
2022-02-19dbstore/dbstore.go: add all queries for AddCveFeed()Paul Duncan1-0/+9
2022-02-19dbstore/dbstore.go: s/insert-description/insert-desc, shorten commentPaul Duncan1-2/+2
2022-02-19dbstore/dbstore.go: add impact, add TODO for item configuration, add ↵Paul Duncan1-1/+77
disabled cve count check
2022-02-19dbstore/sql/init.sql: clean up indentation, add item v2 and v3 impactsPaul Duncan1-99/+234
2022-02-19dbstore/dbstore.go: add AddCveFeed() (incomplete)Paul Duncan1-0/+256
2022-02-19dbstore/sql/init.sql: add initial cve tablesPaul Duncan1-3/+182