sql

Crates.iosql
lib.rssql
version0.4.3
sourcesrc
created_at2015-08-02 12:57:00.931235
updated_at2018-03-08 18:31:53.714245
descriptionThe package provides a constructor of SQL statements.
homepagehttps://github.com/stainless-steel/sql
repositoryhttps://github.com/stainless-steel/sql
max_upload_size
id2738
size29,352
Owners (github:buoyantio:owners)

documentation

https://docs.rs/sql

README

SQLite Package Documentation Build

The package provides 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());

Contribution

Your contribution is highly appreciated. Do not hesitate to open an issue or a pull request. Note that any contribution submitted for inclusion in the project will be licensed according to the terms given in LICENSE.md.

Commit count: 55

cargo fmt