| SELECT * FROM Table |
Table.all() |
| SELECT field1 FROM Table |
Table.only(field1) |
| SELECT field1 FROM Table |
Table.defer(pk) // Exclusion de champs. |
| SELECT * FROM Table WHERE field1 = "value1" |
Table.filter(field1 == "value1") |
| SELECT * FROM Table WHERE primary_key = 42 |
Table.get(42)// Raccourci pour :Table.filter(primary_key == 42)[0..1]; |
| SELECT * FROM Table WHERE field1 = 'value1' |
Table.get(field1 == "value1")// Raccourci pour :Table.filter(field1 == "value1")[0..1]; |
| SELECT * FROM Table WHERE field1 = "value1 AND field2 < 100 |
Table.filter(field1 == "value1" && field2 < 100) |
| SELECT * FROM Table WHERE field1 = "value1 OR field2 < 100 |
Table.filter(field1 == "value1" |
| SELECT * FROM Table ORDER BY field1 |
Table.sort(field1) |
| SELECT * FROM Table ORDER BY field1 DESC |
Table.sort(-field1) |
| SELECT * FROM Table LIMIT 0, 20 |
Table[0..20] |
| SELECT * FROM TableWHERE field1 = "value1" AND field2 < 100ORDER BY field2 DESCLIMIT 10, 20 |
Table.filter(field1 == "value1" && field2 < 100) .sort(-field2)[10..20] |
| INSERT INTO Table(field1, field2) VALUES("value1", 55) |
let table = Table { field1: "value1", field2: 55,}; table.insert() |
| UPDATE Table SET field1 = "value1", field2 = 55 WHERE id = 1 |
Table.get(1).update(field1 = "value1", field2 = 55);// ouTable.filter(id == 1).update(field1 = "value1", field2 = 55);// oulet table = Table.get(1);table.field1 = "value1";table.field2 = 55;table.update(); |
| DELETE FROM Table WHERE id = 1 |
Table.get(1).delete();// ouTable.filter(id == 1).delete() |
| SELECT AVG(field2) FROM Table |
Table.aggregate(avg(field2)) |
| SELECT AVG(field1) FROM Table1 GROUP BY field2 |
Table1.values(field2).annotate(avg(field1)) |
| SELECT AVG(field1) as average FROM Table1GROUP BY field2HAVING average > 5 |
Table1.values(field2).annotate(average = avg(field1)) .filter(average > 5) |
| SELECT AVG(field1) as average FROM Table1WHERE field1 < 10GROUP BY field2HAVING average > 5 |
Table1.filter(field1 < 10).values(field2) .annotate(average = avg(field1)).filter(average > 5) |
| SELECT Table1.field1, Table2.field1 FROM Table1INNER JOIN Table2 ON Table1.pk = Table2.fk |
#[sql_table]struct Table1 { pk: db::PrimaryKey, field1: i32,}#[sql_table]struct Table2 { field1: i32, fk: db::ForeignKey,}Table1.all().join(Table2) |
| SELECT * FROM Table1 WHERE YEAR(date) = 2015 |
Table1.filter(date.year() == 2015) |
| SELECT * FROM Table1 WHERE INSTR(field1, 'string') > 0 |
Table1.filter(field1.contains("string")) |
| SELECT * FROM Table1 WHERE field1 in (1, 2, 3) |
Table1.filter([1, 2, 3].contains(field1)) |
| SELECT * FROM Table1 WHERE field1 LIKE 'string%' |
Table1.filter(field1.starts_with("string")) |
| SELECT * FROM Table1 WHERE field1 LIKE '%string' |
Table1.filter(field1.ends_with("string")) |
| SELECT * FROM Table1 WHERE field1 BETWEEN 1 AND 5 |
Table1.filter(field1 in 1..6) |
| SELECT * FROM Table1 WHERE field1 IS NULL |
Table1.filter(field1.is_none()) |
| SELECT * FROM Table1 WHERE field1 REGEXP BINARY '^[a-d]' |
Table1.filter(r"^[a-d]".is_match(field1)) |
| SELECT * FROM Table1 WHERE field1 REGEXP '^[a-d]' |
Table1.filter(r"^[a-d]".is_match(field1, db::CaseInsensitive)) |
| CREATE TABLE IF NOT EXISTS Table1 ( pk INTEGER NOT NULL AUTO_INCREMENT, field1 INTEGER, PRIMARY KEY (pk)) |
#[sql_table]struct Table1 { pk: db::PrimaryKey, field1: i32,}Table1.create() |
