schema_sql_generator/common/
constraint_naming.rs1pub fn java_string_hash(s: &str) -> u32 {
4 s.chars()
5 .fold(0i32, |h, c| h.wrapping_mul(31).wrapping_add(c as i32)) as u32
6}
7
8const MAX_IDENTIFIER_BYTES: usize = 63;
10
11pub fn truncate_lower(s: &str, max_len: usize) -> String {
13 s.to_lowercase().chars().take(max_len).collect()
14}
15
16pub fn hashed_constraint_name(prefix: &str, table_name: &str, column_name: &str) -> String {
22 let table_lower = table_name.to_lowercase();
23 let column_lower = column_name.to_lowercase();
24 let hash = java_string_hash(&format!("{}_{}", table_lower, column_lower));
25 let mut table_part = truncate_lower(&table_lower, 9);
26 let mut column_part = truncate_lower(&column_lower, 9);
27 let hash_part = format!("{:X}", hash);
28
29 let fixed = prefix.len() + 2 + hash_part.len();
32 while fixed + table_part.len() + column_part.len() > MAX_IDENTIFIER_BYTES {
33 let longer = if table_part.len() >= column_part.len() {
34 &mut table_part
35 } else {
36 &mut column_part
37 };
38 if longer.pop().is_none() {
39 break;
40 }
41 }
42
43 format!("{}{}_{}_{}", prefix, table_part, column_part, hash_part)
44}
45
46#[cfg(test)]
47mod tests {
48 use super::*;
49
50 #[test]
51 fn java_string_hash_matches_known_values() {
52 assert_eq!(java_string_hash("earning_type_id"), 0x97E3620B);
55 assert_eq!(java_string_hash("user_id"), 0xF73AEE0F);
56 assert_eq!(
57 java_string_hash("tip_pool_contributor_template_contribution_basis"),
58 0x326125D1
59 );
60 }
61
62 #[test]
63 fn hashed_constraint_name_matches_legacy_format() {
64 assert_eq!(
65 hashed_constraint_name("df_", "earning_type", "id"),
66 "df_earning_t_id_97E3620B"
67 );
68 assert_eq!(
69 hashed_constraint_name("ck_", "tip_pool_contributor_template", "contribution_basis"),
70 "ck_tip_pool__contribut_326125D1"
71 );
72 }
73
74 #[test]
75 fn hashed_constraint_name_does_not_zero_pad_the_hash() {
76 assert_eq!(
79 java_string_hash("tip_sub_pool_template_hours_mode"),
80 0x0DCD6758
81 );
82 assert_eq!(
83 hashed_constraint_name("ck_", "tip_sub_pool_template", "hours_mode"),
84 "ck_tip_sub_p_hours_mod_DCD6758"
85 );
86 }
87
88 #[test]
89 fn hashed_constraint_name_stays_within_postgres_byte_limit() {
90 let name = hashed_constraint_name("ck_", &"表".repeat(20), &"列".repeat(20));
91
92 assert!(name.len() <= 63, "{name} is {} bytes", name.len());
93 }
94}