Function TestSqlParseOnly

rel/parse_sql_test.go:85–321

(t *testing.T)

}

func TestSqlParseOnly(t *testing.T) {
	t.Parallel()

	parseSqlTest(t, `
	SELECT exists(firstname), x 
	-- lets use the user table
	-- another for good meausre
	FROM user
	-- a comment
	WHERE x = y;
	`)

	parseSqlTest(t, "SELECT exists(firstname), user_id FROM user")

	parseSqlTest(t, `
	SELECT exists(firstname), x 
	-- lets use the user table
	-- another for good meausre
	FROM user;
	`)

	parseSqlTest(t, `
	SELECT 
			event                           AS my_event
			                                            IF event != "stuff"
			                                            AND NOT(hasprefix(event,"gh."))
			                                            AND NOT(hasprefix(event,"software."))
			                                            AND NOT(hasprefix(event,"devstatus."))
			                                            AND NOT(hasprefix(event,"devstatus."))
			                                            AND NOT(hasprefix(event,"devsummary."))
			                                            AND NOT(hasprefix(event,"dvcsconnector."))
	FROM nothing`)
	parseSqlTest(t, `
		SELECT event FROM nothing
		WHERE
			(
				not(exists(@@whitelist)) 
				OR len(@@whitelist) == 0 
				OR host(url) IN hosts(@@whitelist)
			) 
			AND exists(version) 
			AND eq(version, 4)
	`)

	parseSqlTest(t, `
		SELECT a.language, a.template, Count(*) AS count
		FROM 
			(Select Distinct language, template FROM content) AS a
			Left Join users AS b
				On b.language = a.language AND b.template = b.template
		GROUP BY a.language, a.template`)

	parseSqlTest(t, `SELECT 
            lol AS notlol IF AND (
                    or (
                        event IN ("rq", "ab"),
                        NOT EXISTS event
                    )