Vladimir Hodakov
a9f1d25c7b
This commit introduces pokememes information storage in source code (because they're rarely changed and I always update them manually). All information about pokememes updated after nerf of 25 April. Also, added buttons to /pokedeks command for changing pages (there are 21 pages already!), and limited one page to 35 pokememes.
39 lines
965 B
Go
39 lines
965 B
Go
// i2_bot – Instinct PokememBro Bot
|
||
// Copyright (c) 2017-2018 Vladimir "fat0troll" Hodakov
|
||
|
||
package migrations
|
||
|
||
import (
|
||
"database/sql"
|
||
"errors"
|
||
)
|
||
|
||
// DeletePokememesTablesUp drops `pokememes`, `pokememes_elements` and `pokememes_locations` tables
|
||
// These tables data is rarely changed, so I decided to hold such data in source code
|
||
func DeletePokememesTablesUp(tx *sql.Tx) error {
|
||
request := "DROP TABLE IF EXISTS `pokememes`"
|
||
_, err := tx.Exec(request)
|
||
if err != nil {
|
||
return err
|
||
}
|
||
|
||
request = "DROP TABLE IF EXISTS `pokememes_elements`"
|
||
_, err = tx.Exec(request)
|
||
if err != nil {
|
||
return err
|
||
}
|
||
|
||
request = "DROP TABLE IF EXISTS `pokememes_locations`"
|
||
_, err = tx.Exec(request)
|
||
if err != nil {
|
||
return err
|
||
}
|
||
|
||
return nil
|
||
}
|
||
|
||
// DeletePokememesTablesDown does nothing, because after nerf old information isn't needed at all
|
||
func DeletePokememesTablesDown(tx *sql.Tx) error {
|
||
return errors.New("This migration is irreversible, as nerf itself")
|
||
}
|