Crates.io | sql |
lib.rs | sql |
version | 0.4.3 |
source | src |
created_at | 2015-08-02 12:57:00.931235 |
updated_at | 2018-03-08 18:31:53.714245 |
description | The package provides a constructor of SQL statements. |
homepage | https://github.com/stainless-steel/sql |
repository | https://github.com/stainless-steel/sql |
max_upload_size | |
id | 2738 |
size | 29,352 |
The package provides a constructor of SQL statements.
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());
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.