package migrationsimport ("context""database/sql""github.com/pressly/goose/v3")func init() {goose.AddMigrationContext(Up20201012210022, Down20201012210022)}func Up20201012210022(ctx context.Context, tx *sql.Tx) error {_, err := tx.ExecContext(ctx, `alter table artistadd size integer default 0 not null;create index if not exists artist_sizeon artist(size);update artist set size = ifnull((select sum(f.size)from album fwhere f.album_artist_id = artist.id), 0)where id not null;alter table playlistadd size integer default 0 not null;create index if not exists playlist_sizeon playlist(size);update playlist set size = ifnull((select sum(size)from media_file fleft join playlist_tracks pt on f.id = pt.media_file_idwhere pt.playlist_id = playlist.id), 0);`)return err}func Down20201012210022(_ context.Context, _ *sql.Tx) error {return nil}