improve dump_gen_code_path configuration varibale

use tempfile module to get temporary directory

make extension backend specific