29 lines
578 B
SQL
29 lines
578 B
SQL
-- name: InsertFileProperties :exec
|
|
INSERT INTO file_properties (
|
|
file_id, sha256, md5, libmagic_mime, libmagic_extension, libmagic_apple
|
|
) VALUES ($1, $2, $3, $4, $5, $6)
|
|
;
|
|
|
|
-- name: GetFileProperties :one
|
|
SELECT * FROM file_properties
|
|
WHERE file_id = $1;
|
|
|
|
-- name: InsertFileDIEC :exec
|
|
INSERT INTO diec (
|
|
file_id, data
|
|
) VALUES ($1, $2);
|
|
|
|
-- name: GetFileDIEC :one
|
|
SELECT * FROM diec
|
|
WHERE file_id = $1;
|
|
|
|
-- name: InsertFileCapa :exec
|
|
INSERT INTO capa_results (
|
|
file_id, data
|
|
) VALUES ($1, $2);
|
|
|
|
-- name: GetFileCapa :one
|
|
SELECT * FROM capa_results
|
|
WHERE file_id = $1;
|
|
|
|
|