# Table Name: photo

## Creation Statement
CREATE TABLE IF NOT EXISTS photo (
id INTEGER PRIMARY KEY,
size INT,
filename TEXT,
date_taken INT
);

## Insert Function

def insert_photo(id: int, size: int, filename: str, date_taken: int) -> int:
    params = (id, size, filename, date_taken)
    id = YOUR_CONNECTOR_EXECUTOR("""INSERT INTO photo (id, size, filename, date_taken) VALUES(?,?,?,?);""",
                                 params)
    return id


## Insert Function Unit Test

def test_insert_photo(YOUR_CLEAN_DB_FIXTURE):
    expected = (1, 928, '5X7CMZXGCR', 154)
    new_id = YOUR_MODULE.insert_photo(size=928, filename="5X7CMZXGCR", date_taken=154)
    result = YOUR_CONNECTOR_QUERY('SELECT * FROM photo').fetchall()[0]
    assert result == expected
    assert new_id == 1


## Boolean Fields
