nullism / bqb Goto Github PK

Contributors

Stargazers

Forkers

ajunlonglive arguello kbmanikanta iytime allanglen dschep niiniyare henrikpoulsen benjic

func TestErrorSubquery(t *testing.T) {
	// One more ? than we are passing args for which is wrong and should fail
	subQuery := New("SELECT id FROM table2 WHERE id = ? and value = ?", 1)

	// It gives an error when the query is directly turned to sql which is good
	_, _, err := subQuery.ToSql()
	if err == nil || !strings.Contains(err.Error(), "extra ? in text") {
		t.Errorf("expected error for subquery")
	}

	// But if you pass it into another query instead there is no error and the sql it spits out will be
	// "SELECT * FROM table WHERE id IN ()" which is not what I would expect
	q := New("SELECT * FROM table WHERE id IN (?)", subQuery)
	_, _, err = q.ToSql()
	if err == nil {
                // It fails here
		t.Errorf("expected error for subquery")
	}
}

deviceUUIDFromValue := bqb.New(`
SELECT device_id FROM devices_parameters 
WHERE TYPE = ?
AND value IN (?)`, sourceTypeMap[type], names)

filterForEnvOperator := createEnvIDQuery(request.EnvOperatorMap)

deviceUUIDFromOperator := bqb.New(`
SELECT device_id FROM devices_operators 
WHERE device_id IN (?) ?`, deviceUUIDFromValue, filterForEnvOperator)


query := bqb.New(`
SELECT t1.data, t2.value, t3.operator_id, t3.env_id FROM audit_device t1 
JOIN devices_parameters t2 ON t2.device_id = t1.device_id 
JOIN devices_operators t3 ON t3.device_id = t1.device_id
WHERE t1.device_id IN (?)
ORDER BY t1.id DESC`, deviceUUIDFromOperator)


sql, params, err := query.ToMysql()