39 lines
993 B
Go
39 lines
993 B
Go
// i2_bot – Instinct PokememBro Bot
|
||
// Copyright (c) 2017-2018 Vladimir "fat0troll" Hodakov
|
||
|
||
package migrations
|
||
|
||
import (
|
||
"database/sql"
|
||
)
|
||
|
||
// UpdateLeaguesUp fixes some fuckup with leagues' emoji
|
||
func UpdateLeaguesUp(tx *sql.Tx) error {
|
||
_, err := tx.Exec("UPDATE `leagues` SET symbol='🈸' WHERE symbol=':u7533:'")
|
||
if err != nil {
|
||
return err
|
||
}
|
||
_, err = tx.Exec("UPDATE `leagues` SET symbol='🈳 ' WHERE symbol=':u6e80'")
|
||
if err != nil {
|
||
return err
|
||
}
|
||
_, err = tx.Exec("UPDATE `leagues` SET symbol='🈵' WHERE symbol=':u7a7a:'")
|
||
|
||
return err
|
||
}
|
||
|
||
// UpdateLeaguesDown returns leagues emoji fuckup for sanity purposes
|
||
func UpdateLeaguesDown(tx *sql.Tx) error {
|
||
_, err := tx.Exec("UPDATE `leagues` SET symbol=':u7533:' WHERE symbol='🈸'")
|
||
if err != nil {
|
||
return err
|
||
}
|
||
_, err = tx.Exec("UPDATE `leagues` SET symbol=':u6e80' WHERE symbol='🈳 '")
|
||
if err != nil {
|
||
return err
|
||
}
|
||
_, err = tx.Exec("UPDATE `leagues` SET symbol=':u7a7a:' WHERE symbol='🈵'")
|
||
|
||
return err
|
||
}
|