Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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
- """)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement