MCPcopy Create free account
hub / github.com/erans/pgsqlite / test_basic_arithmetic_operations

Function test_basic_arithmetic_operations

tests/decimal_rewriter_test.rs:71–94  ·  view source on GitHub ↗
()

Source from the content-addressed store, hash-verified

69
70#[test]
71fn test_basic_arithmetic_operations() {
72 let conn = setup_test_db();
73
74 // Addition
75 let sql = "SELECT price + 10 FROM products";
76 let result = rewrite_query(&conn, sql).unwrap();
77 assert!(result.contains("decimal_add"));
78 assert!(result.contains("decimal_from_text"));
79
80 // Subtraction
81 let sql = "SELECT price - discount FROM products";
82 let result = rewrite_query(&conn, sql).unwrap();
83 assert!(result.contains("decimal_sub"));
84
85 // Multiplication
86 let sql = "SELECT price * 1.1 FROM products";
87 let result = rewrite_query(&conn, sql).unwrap();
88 assert!(result.contains("decimal_mul"));
89
90 // Division
91 let sql = "SELECT price / 2 FROM products";
92 let result = rewrite_query(&conn, sql).unwrap();
93 assert!(result.contains("decimal_div"));
94}
95
96#[test]
97fn test_comparison_operations() {

Callers

nothing calls this directly

Calls 2

setup_test_dbFunction · 0.70
rewrite_queryFunction · 0.70

Tested by

no test coverage detected