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());

// DELETE FROM `users`
println!("{}", delete_from("users").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").descend())
                                   .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.