Utils.py 694 B

123456789101112131415161718192021
  1. import re
  2. import random
  3. def camel_to_snake(name: str) -> str:
  4. # 匹配大写字母,并在前面加上下划线,然后转换为小写
  5. return re.sub(r'(?<!^)(?=[A-Z])', '_', name).lower()
  6. def convert_columns_to_snake_case(columns: str) -> str:
  7. # 拆分字符串为字段列表,去除空格
  8. fields = [field.strip() for field in columns.split(",")]
  9. # 转换每个字段为下划线格式
  10. snake_case_fields = [camel_to_snake(field) for field in fields]
  11. # 重新组合回逗号分隔的字符串
  12. return ", ".join(snake_case_fields)
  13. def random_float():
  14. # 生成一个随机的浮点数并四舍五入到14位小数
  15. return round(random.random(), 14)