github.com/bingoohuang/gg@v0.0.0-20240325092523-45da7dee9335/pkg/sqx/testdata/test_schema.sql (about)

     1  -- name: create-users-table
     2  CREATE TABLE users (
     3  	id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
     4  	name VARCHAR(255),
     5  	email VARCHAR(255)
     6  );
     7  
     8  -- name: create-user
     9  INSERT INTO users (name, email) VALUES(?, ?)
    10  
    11  -- name: find-one-user-by-email
    12  SELECT id,name,email FROM users WHERE email = ? LIMIT 1
    13  
    14  -- name: drop-users-table
    15  DROP TABLE users