// Code generated by sqlc. DO NOT EDIT.
// versions:
//   sqlc v1.29.0
// source: query.sql

package db

import (
	"context"
)

const checkPath = `-- name: CheckPath :one
SELECT
  EXISTS(
		SELECT 1
		FROM url
		WHERE path = ?
	) AS differs
`

func (q *Queries) CheckPath(ctx context.Context, path string) (int64, error) {
	row := q.queryRow(ctx, q.checkPathStmt, checkPath, path)
	var differs int64
	err := row.Scan(&differs)
	return differs, err
}

const getFile = `-- name: GetFile :many
SELECT
	file.file_id, file.url_id, file.content_type, file.last_modified, file.title, file.etag, file.style_hash,
	content.content_id, content.file_id, content.encoding, content.body
FROM url
INNER JOIN file
	USING (url_id)
INNER JOIN content
	USING (file_id)
WHERE
	url.path = ?
`

type GetFileRow struct {
	File    File
	Content Content
}

func (q *Queries) GetFile(ctx context.Context, path string) ([]GetFileRow, error) {
	rows, err := q.query(ctx, q.getFileStmt, getFile, path)
	if err != nil {
		return nil, err
	}
	defer rows.Close()
	var items []GetFileRow
	for rows.Next() {
		var i GetFileRow
		if err := rows.Scan(
			&i.File.FileID,
			&i.File.UrlID,
			&i.File.ContentType,
			&i.File.LastModified,
			&i.File.Title,
			&i.File.Etag,
			&i.File.StyleHash,
			&i.Content.ContentID,
			&i.Content.FileID,
			&i.Content.Encoding,
			&i.Content.Body,
		); err != nil {
			return nil, err
		}
		items = append(items, i)
	}
	if err := rows.Close(); err != nil {
		return nil, err
	}
	if err := rows.Err(); err != nil {
		return nil, err
	}
	return items, nil
}

const insertContent = `-- name: InsertContent :exec
INSERT INTO content (file_id, encoding, body)
VALUES (?1, ?2, ?3)
`

type InsertContentParams struct {
	Fileid   int64
	Encoding string
	Body     []byte
}

func (q *Queries) InsertContent(ctx context.Context, arg InsertContentParams) error {
	_, err := q.exec(ctx, q.insertContentStmt, insertContent, arg.Fileid, arg.Encoding, arg.Body)
	return err
}

const insertFile = `-- name: InsertFile :execlastid
INSERT INTO file (url_id, content_type, last_modified, etag, style_hash, title)
VALUES (
  ?1,
  ?2,
  ?3,
  ?4,
  ?5,
  ?6
)
`

type InsertFileParams struct {
	UrlID        int64
	ContentType  string
	LastModified int64
	Etag         string
	StyleHash    string
	Title        string
}

func (q *Queries) InsertFile(ctx context.Context, arg InsertFileParams) (int64, error) {
	result, err := q.exec(ctx, q.insertFileStmt, insertFile,
		arg.UrlID,
		arg.ContentType,
		arg.LastModified,
		arg.Etag,
		arg.StyleHash,
		arg.Title,
	)
	if err != nil {
		return 0, err
	}
	return result.LastInsertId()
}

const insertURL = `-- name: InsertURL :execlastid
INSERT INTO url (path) VALUES (?)
`

func (q *Queries) InsertURL(ctx context.Context, path string) (int64, error) {
	result, err := q.exec(ctx, q.insertURLStmt, insertURL, path)
	if err != nil {
		return 0, err
	}
	return result.LastInsertId()
}