func getSlugbuilderArtifact(db *postgres.DB) (*ct.Artifact, error) {
sql := `
SELECT manifest, layer_url_template FROM artifacts
WHERE meta->>'flynn.component' = 'slugbuilder'
ORDER BY created_at DESC LIMIT 1
`
artifact := &ct.Artifact{
Type: ct.ArtifactTypeFlynn,
}
var layerURLTemplate *string
if err := db.QueryRow(sql).Scan(&artifact.RawManifest, &layerURLTemplate); err != nil {
return nil, err
}
if layerURLTemplate != nil {
artifact.LayerURLTemplate = *layerURLTemplate
}
return artifact, nil
}
