Function Test_SQLForceQuery_Error

db/db_test.go:785–838

(t *testing.T)

}

func Test_SQLForceQuery_Error(t *testing.T) {
	db, path := mustCreateOnDiskDatabaseWAL()
	defer db.Close()
	defer os.Remove(path)

	_, err := db.ExecuteStringStmt("CREATE TABLE foo (id INTEGER NOT NULL PRIMARY KEY, name TEXT)")
	if err != nil {
		t.Fatalf("failed to create table: %s", err.Error())
	}

	tests := []struct {
		sql        string
		forceQuery bool
		exp        string
	}{
		{
			sql:        `INSERT INTO foo(id, name) VALUES(1, "fiona") RETURNING name AS`,
			forceQuery: true,
			exp:        `[{"error":"incomplete input"}]`,
		},
		{
			sql:        `INSERT INTO foo(id, name) VALUES(1, "fiona") RETURNING xxx`,
			forceQuery: false,
			exp:        `[{"error":"no such column: xxx"}]`,
		},
		{
			sql:        `INSERT INTO foo(id, name) VALUES(1, "fiona") RETURNING xxx`,
			forceQuery: true,
			exp:        `[{"error":"no such column: xxx"}]`,
		},
		{
			sql:        `INSERT INTO foo(id, name) VALUES(1, "fiona") RETURNING name AS`,
			forceQuery: false,
			exp:        `[{"error":"incomplete input"}]`,
		},
	}
	for _, test := range tests {
		req := &command.Request{
			Statements: []*command.Statement{
				{
					Sql:        test.sql,
					ForceQuery: test.forceQuery,
				},
			},
		}
		r, err := db.Execute(req, false)
		if err != nil {
			t.Fatalf("failed to insert records: %s", err.Error())
		}
		if exp, got := test.exp, asJSON(r); exp != got {
			t.Fatalf("unexpected results for query\nexp: %s\ngot: %s", exp, got)
		}
	}
}

func Test_SimpleTransaction(t *testing.T) {
	db, path := mustCreateOnDiskDatabaseWAL()