Crate sql [−] [src]
A constructor of SQL statements.
Example
use sql::prelude::*; // CREATE TABLE `users` (`id` INTEGER NOT NULL, `name` TEXT, `photo` BLOB) println!("{}", create_table("users").column("id".integer().not_null()) .column("name".string()) .column("photo".binary()) .compile().unwrap()); // INSERT INTO `users` (`id`, `name`) VALUES (?, ?), (?, ?) println!("{}", insert_into("users").columns(&["id", "name"]).batch(2) .compile().unwrap()); // SELECT * FROM `users` WHERE `name` LIKE 'A%' println!("{}", select_from("users").so_that(column("name").like("A%")) .compile().unwrap()); // SELECT * FROM `users` ORDER BY `name` DESC println!("{}", select_from("users").order_by(column("name").descending()) .compile().unwrap()); // SELECT `name`, `photo` FROM `users` LIMIT 1 println!("{}", select_from("users").columns(&["name", "photo"]).limit(1) .compile().unwrap());
Modules
grammar |
The grammar. |
language |
The language. |
prelude |
Reexports of functions, traits, and types. |
Structs
Error |
An error. |
Enums
Type |
A data type. |
Traits
Typable |
An object that can be assigend a type. |
Type Definitions
Result |
A result. |