use crate::*;
test_case!(create_table, async move {
let test_cases = vec![
(
r#"
CREATE TABLE CreateTable1 (
id INTEGER NULL,
num INTEGER,
name TEXT
)"#,
Ok(Payload::Create),
),
(
r#"
CREATE TABLE CreateTable1 (
id INTEGER NULL,
num INTEGER,
name TEXT
)"#,
Err(ExecuteError::TableAlreadyExists.into()),
),
(
r#"
CREATE TABLE IF NOT EXISTS CreateTable2 (
id INTEGER NULL,
num INTEGER,
name TEXT
)"#,
Ok(Payload::Create),
),
(
r#"
CREATE TABLE IF NOT EXISTS CreateTable2 (
id INTEGER NULL,
num INTEGER,
name TEXT
)"#,
Ok(Payload::Create),
),
];
for (sql, expected) in test_cases.into_iter() {
test!(expected, sql);
}
});