UserService

var FindBySubSql = `` /* 126-byte string literal not displayed */

var FindByUsernameSql = `
    SELECT id, sub, username, created_at, updated_at, deleted_at
    FROM users u
    WHERE username = ?
`

var FindPasswordByUsernameSql = `
    SELECT id, sub, username, password, created_at, updated_at, deleted_at
    FROM users u
    WHERE username = ?
`

var UserInsertSql = `
INSERT INTO users(username,password,id)
VALUES ( ?,?,UNHEX( REPLACE( ?,'-','' )));
`

var UsernameAvailableSql = `
	SELECT COUNT(*) = 0
	FROM (
		SELECT 1
		FROM users u
		WHERE username = ?
	    LIMIT 1
	) AS found;
`