belchior / sql_query_builder

Write SQL queries in a simple and composable way
https://crates.io/crates/sql_query_builder
MIT License
57 stars 7 forks source link

create table command #21

Closed belchior closed 5 months ago

belchior commented 5 months ago

Builder CreateTable

Adds the create table builder, the basic API is

use sql_query_builder as sql;

let query = sql::CreateTable::new()
  .create_table("users")
  .column("id serial primary key")
  .column("login varchar(40) not null")
  .constraint("users_login_key unique(login)")
  .as_string();

let expected = "\
  CREATE TABLE users (\
    id serial primary key, \
    login varchar(40) not null, \
    CONSTRAINT users_login_key unique(login)\
  )\
";

assert_eq!(expected, query);