diff options
| author | Paul Duncan <pabs@pablotron.org> | 2022-02-04 17:43:15 -0500 |
|---|---|---|
| committer | Paul Duncan <pabs@pablotron.org> | 2022-02-04 17:43:15 -0500 |
| commit | 82b100ca5cc56adb97d43d0c8df698af84214925 (patch) | |
| tree | a60e7e5202ac07bdce841cb05ac50d90160ff1e1 /internal/dbstore/testdata/sql/fill-fts.sql | |
| parent | 014dccd167a20f063515ca6afd36601c8cf5830c (diff) | |
| download | cvez-82b100ca5cc56adb97d43d0c8df698af84214925.tar.bz2 cvez-82b100ca5cc56adb97d43d0c8df698af84214925.zip | |
add internal/dbstore
Diffstat (limited to 'internal/dbstore/testdata/sql/fill-fts.sql')
| -rw-r--r-- | internal/dbstore/testdata/sql/fill-fts.sql | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/internal/dbstore/testdata/sql/fill-fts.sql b/internal/dbstore/testdata/sql/fill-fts.sql new file mode 100644 index 0000000..5329ca7 --- /dev/null +++ b/internal/dbstore/testdata/sql/fill-fts.sql @@ -0,0 +1,10 @@ +-- populate fts table +INSERT INTO cpe_fts(rowid, title) + SELECT a.cpe_id, + COALESCE(b.val, '') + + FROM cpes a + LEFT JOIN cpe_titles b + ON (b.cpe_id = a.cpe_id) + + WHERE b.lang = 'en-US'; |