aboutsummaryrefslogtreecommitdiff
path: root/dbstore
AgeCommit message (Collapse)AuthorFilesLines
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
2022-02-18dbstore: rename Tx to Begin, add Tx which accepts callback and handles ↵Paul Duncan2-91/+109
commit/rollback
2022-02-18dbstore: refactor sqlfs and tx, add tx testsPaul Duncan6-150/+793
2022-02-18dbstore: add enableForeignKeys()Paul Duncan1-2/+8
2022-02-17dbstore: add DbStore#CpeMatchSearch() and backing queryPaul Duncan2-5/+71
2022-02-17dbstore/dbstore.go: add AddCpeMatches()Paul Duncan1-0/+100
2022-02-17dbstore/dbstore.go: update cpe queries, move queryIds outside of funcPaul Duncan1-5/+11
2022-02-17dbstore/cpesearch*: refactor search queriesPaul Duncan3-7/+7
2022-02-17dbstore/sql: add cpe and cpe-match subdirsPaul Duncan11-0/+20
2022-02-17dbstore/sql/init.sql: add cpe_match* tablesPaul Duncan1-4/+99
2022-02-05dbscore: add openFull and testPaul Duncan2-7/+19
2022-02-05dbstore: add CpeSearch() fail testsPaul Duncan1-2/+20
2022-02-05dbstore/dbstore.go: add comment about weird result set error handlingPaul Duncan1-0/+4
2022-02-05dbstore: refactor, separate cpesearchrow and cpesearchtype, add ↵Paul Duncan6-117/+156
cpesearchtype_test
2022-02-05dbstore: add unmarshalcpesearchrow and testsPaul Duncan2-36/+270
2022-02-05dbstore/sql/init.sql: constrain text colsPaul Duncan1-4/+12