clear_functions()

cur.execute("""
SET @base_value = 3,
    @extracting_column = 30,
    @number_of_columns = 40,
    @number_of_layers = 5,
    @active_side = 1;
""")

cur.execute("""
CREATE FUNCTION flip_side
(
    side INT
)
RETURNS int
BEGIN
    IF (side = 1) THEN
        return 2;
    ELSE
        return 1;
    END IF;
END
""")

cur.execute("""
CREATE FUNCTION flip_column
(
    column_ INT
)
RETURNS int
BEGIN
    return @number_of_columns - column_ + 1;
END
""")

cur.execute('SELECT flip_column(4)')
cur.fetchall()