"Tosqlcondition" is a convenient derived macro that generates SQL query conditions, reducing the amount of manual coding required. However, it currently has limited capabilities and can only support a few features, such as WHERE and LIMIT.
table
sql
CREATE TABLE `od_commands` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`name` char(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
`ext` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
Perhaps we want to use query commands with certain files. In Rust, we could create a struct to handle this.
```rust use tosqlcondition::ToSqlCondition;
struct Query {
id: Option
fn main() { let (q, q2, q3) = ( Query{id: None, name: Some("tom"), limit: Some(1)}, Query{id: None, name: None, limit: Some(10)}, Query{id: Some(2), name: None, limit: None}, ); asserteq!(q.tosqlcondition(), " WHERE name = 'tom' AND LIMIT 1"); asserteq!(q2.tosqlcondition(), " LIMIT 10"); asserteq!(q3.tosql_condition(), " WHERE id = 2"); } ```
order feature