func atomToActor(db csql.Queryer, id Atom) (*Actor, error) {
e := new(Actor)
err := e.Scan(db.QueryRow(`
SELECT a.atom_id, n.name, a.sequence
FROM actor AS a
LEFT JOIN name AS n ON n.atom_id = a.atom_id
WHERE a.atom_id = $1
`, id))
return e, err
}
func atomToTvshow(db csql.Queryer, id Atom) (*Tvshow, error) {
e := new(Tvshow)
err := e.Scan(db.QueryRow(`
SELECT t.atom_id, n.name, t.year, t.sequence, t.year_start, t.year_end
FROM tvshow AS t
LEFT JOIN name AS n ON n.atom_id = t.atom_id
WHERE t.atom_id = $1
`, id))
return e, err
}
func atomToMovie(db csql.Queryer, id Atom) (*Movie, error) {
e := new(Movie)
err := e.Scan(db.QueryRow(`
SELECT m.atom_id, n.name, m.year, m.sequence, m.tv, m.video
FROM movie AS m
LEFT JOIN name AS n ON n.atom_id = m.atom_id
WHERE m.atom_id = $1
`, id))
return e, err
}
func atomToEpisode(db csql.Queryer, id Atom) (*Episode, error) {
e := new(Episode)
err := e.Scan(db.QueryRow(`
SELECT e.atom_id, e.tvshow_atom_id, n.name,
e.year, e.season, e.episode_num
FROM episode AS e
LEFT JOIN name AS n ON n.atom_id = e.atom_id
WHERE e.atom_id = $1
`, id))
return e, err
}