Skip to main content
Module

x/sail_sqlstring/mod_test.ts

Simple SQL escape and format for MySQL
Latest
File
import { assertEquals } from "https://deno.land/std@0.139.0/testing/asserts.ts";import { escape, escapeId, format } from "./mod.ts";
Deno.test("escape", function() { const userId = "1"; const sql = `select * from user where id = ${ escape(userId) }`; assertEquals(sql, "select * from user where id = '1'");});
Deno.test("escapeId", function() { const user = "user"; const sql = `select * from ${ escapeId(user) } where id = '1'`; assertEquals(sql, "select * from `user` where id = '1'");});
Deno.test("format", function() { const sql = `select * from user where id = ?`; const sql2 = format(sql, [ "1" ]); assertEquals(sql2, "select * from user where id = '1'");});