diff options
| author | Paul Duncan <pabs@pablotron.org> | 2022-03-16 08:07:26 -0400 |
|---|---|---|
| committer | Paul Duncan <pabs@pablotron.org> | 2022-03-16 08:07:26 -0400 |
| commit | fea7af49a9da16574646b8e307115f9c65d23489 (patch) | |
| tree | 1c6f047b876d92e89e3d575ca4274a45c9ae32bf /dbstore/sql/cisa/insert-product.sql | |
| parent | ff4548f06a056661142d714596efe266fa78814e (diff) | |
| download | cvez-fea7af49a9da16574646b8e307115f9c65d23489.tar.bz2 cvez-fea7af49a9da16574646b8e307115f9c65d23489.zip | |
add dbstore/sql/cisa
Diffstat (limited to 'dbstore/sql/cisa/insert-product.sql')
| -rw-r--r-- | dbstore/sql/cisa/insert-product.sql | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/dbstore/sql/cisa/insert-product.sql b/dbstore/sql/cisa/insert-product.sql new file mode 100644 index 0000000..cbf9103 --- /dev/null +++ b/dbstore/sql/cisa/insert-product.sql @@ -0,0 +1,3 @@ +-- insert product if it does not exist, or do nothing if the the product +-- name is already present. +INSERT INTO cisa_products(name) VALUES (?) ON CONFLICT(name) DO NOTHING; |