func()

in internal/repo/database.go [106:118]

• 12 lines of code
• 2 McCabe index (conditional complexity)

func (db *Database) CreateIndexes() error {
	query := `
		CREATE INDEX idx_metadata_parent    ON metadata(parent);
		CREATE INDEX idx_directory_parent   ON directory(parent);
		CREATE INDEX idx_directory_name		ON directory(name);
		VACUUM; -- Repackage database to clean empty space
	`

	if _, err := db.Exec(query); err != nil {
		return err
	}
	return nil
}