| 177 | |
| 178 | #[test] |
| 179 | fn batch_array_insert() { |
| 180 | let result = |
| 181 | pp("INSERT INTO users [{ name: 'alice', age: 30 }, { name: 'bob', age: 25 }]").unwrap(); |
| 182 | assert!(!result.is_upsert); |
| 183 | assert!(result.sql.contains("VALUES")); |
| 184 | assert!(result.sql.contains("'alice'")); |
| 185 | assert!(result.sql.contains("'bob'")); |
| 186 | assert!(result.sql.contains("30")); |
| 187 | assert!(result.sql.contains("25")); |
| 188 | let values_part = result.sql.split("VALUES").nth(1).unwrap(); |
| 189 | let row_count = values_part.matches('(').count(); |
| 190 | assert_eq!(row_count, 2, "should have 2 row groups: {}", result.sql); |
| 191 | } |
| 192 | |
| 193 | #[test] |
| 194 | fn batch_array_heterogeneous_keys() { |