clear_functions()
cur.execute("""
SET @base_value = 3,
@extracting_column = 30,
@number_of_columns = 40,
@number_of_layers = 5,
@active_side = 1;
""")
cur.execute(f"""
CREATE FUNCTION numbering_formula
(
layer INT,
side INT,
column_ INT
)
RETURNS int
BEGIN
IF NOT (1 <= layer AND layer <= number_of_layers AND (side = 1 OR side = 2) AND 1 <= column_ AND column_ <= number_of_columns AND column_ != extracting_column) THEN
return -1
END IF;
IF @active_side <> 1 THEN
SET side = flip_side(side);
END IF;
return 0;
END
""")
Comments
0 B
|👍
/👎