transaction_test.go

// Copyright (c) 2012-2013 Jason McVetta.  This is Free Software, released under
// the terms of the GPL v3.  See http://www.gnu.org/copyleft/gpl.html for details.
// Resist intellectual serfdom - the ownership of ideas is akin to slavery.

package neoism

import (
	"encoding/json"
	"github.com/jadengore/assert"
	"strconv"
	"testing"
)

type resStruct0 struct {
	N struct {
		Name string
	}
}

type resStruct1 struct {
	M map[string]string
}

type resStruct2 struct {
	A   string `json:"a.name"`
	Rel string `json:"type(r)"`
	B   struct {
		Name string
	} `json:"b"`
}

func TestTxBegin(t *testing.T) {
	db := connectTest(t)
	defer cleanup(t, db)
	type name struct {
		Name string `json:"name"`
	}
	res0 := []resStruct0{}
	res1 := []resStruct1{}
	res2 := []resStruct2{}
	q0 := CypherQuery{
		Statement:  "CREATE (n:Person {props}) RETURN n",
		Parameters: map[string]interface{}{"props": map[string]string{"name": "James T Kirk"}},
		Result:     &res0,
	}
	q1 := CypherQuery{
		Statement: "CREATE (m:Person {name: \"Dr McCoy\"}) RETURN m",
		Result:    &res1,
	}
	q2 := CypherQuery{
		Statement: `
				MATCH (a:Person), (b:Person)
				WHERE a.name = "James T Kirk" AND b.name = "Dr McCoy"
				CREATE a-[r:Commands]->b
				RETURN a.name, type(r), b
			`,
		Parameters: map[string]interface{}{
			"n_name": "James T Kirk",
			"m_name": "dr mccoy",
		},
		Result: &res2,
	}

	assert.Equal(t, *new([]string), q1.Columns())
	stmts := []*CypherQuery{&q0, &q1, &q2}
	tx, err := db.Begin(stmts)
	tx.Rollback()
	if err != nil {
		t.Fatal(err)
	}
	assert.Equal(t, 1, len(res0))
	assert.Equal(t, "James T Kirk", res0[0].N.Name)
	assert.Equal(t, 1, len(res1))
	assert.Equal(t, "Dr McCoy", res1[0].M["name"])
	assert.Equal(t, 1, len(res2))
	assert.Equal(t, "James T Kirk", res2[0].A)
	assert.Equal(t, "Commands", res2[0].Rel)
	assert.Equal(t, "Dr McCoy", res2[0].B.Name)
}

func TestTxCommit(t *testing.T) {
	db := connectTest(t)
	defer cleanup(t, db)
	name := rndStr(t)
	qs := []*CypherQuery{
		&CypherQuery{
			Statement: `
				CREATE (n:Person {name: {name}})
				RETURN n
			`,
			Parameters: Props{"name": name},
		},
	}
	tx, err := db.Begin(qs)
	if err != nil {
		t.Fatal(err)
	}
	//
	// Confirm it does not exist before commit
	//
	res0 := []struct {
		N string `json:"n.name"`
	}{}
	q0 := CypherQuery{
		Statement: `
			MATCH (n:Person)
			WHERE n.name = {name}
			RETURN n.name
		`,
		Parameters: Props{"name": name},
		Result:     &res0,
	}
	err = db.Cypher(&q0)
	if err != nil {
		t.Fatal(err)
	}
	assert.Equal(t, 0, len(res0))
	//
	// Commit and confirm creation
	//
	err = tx.Commit()
	if err != nil {
		t.Fatal(err)
	}
	err = db.Cypher(&q0)
	if err != nil {
		t.Fatal(err)
	}
	assert.Equal(t, 1, len(res0))
}

func TestTxBadResultObj(t *testing.T) {
	db := connectTest(t)
	defer cleanup(t, db)
	//
	// Struct not slice of structs
	//
	res0 := struct{ N string }{}
	qs := []*CypherQuery{
		&CypherQuery{
			Statement: `CREATE (n:Person) RETURN n`,
			Result:    &res0,
		},
	}
	tx, err := db.Begin(qs)
	if _, ok := err.(*json.UnmarshalTypeError); !ok {
		t.Fatal(err)
	}
	tx.Rollback() // Else cleanup will hang til Tx times out
}

func TestTxBadQuery(t *testing.T) {
	db := connectTest(t)
	defer cleanup(t, db)
	qs := []*CypherQuery{
		&CypherQuery{
			Statement: `CREATE (n:Person) RETURN n`,
		},
		&CypherQuery{
			Statement: `CREATE (n:Person) RETURN n`,
		},
		&CypherQuery{
			Statement: `foobar`,
		},
		&CypherQuery{
			Statement: `CREATE (n:Person) RETURN n`,
		},
	}
	tx, err := db.Begin(qs)
	tx.Rollback() // Else cleanup will hang til Tx times out
	assert.Equal(t, TxQueryError, err)
	numErr := len(tx.Errors)
	assert.T(t, numErr == 1, "Expected one tx error, got "+strconv.Itoa(numErr))
}

func TestTxQuery(t *testing.T) {
	db := connectTest(t)
	defer cleanup(t, db)
	name0 := rndStr(t)
	name1 := rndStr(t)
	qs0 := []*CypherQuery{
		&CypherQuery{
			Statement:  `CREATE (n:Person {name: {name}}) RETURN n`,
			Parameters: Props{"name": name0},
		},
		&CypherQuery{
			Statement:  `CREATE (n:Person {name: {name}}) RETURN n`,
			Parameters: Props{"name": name1},
		},
	}
	tx, err := db.Begin(qs0)
	if err != nil {
		t.Fatal(err)
	}
	qs1 := []*CypherQuery{
		&CypherQuery{
			Statement: `
				MATCH (a:Person), (b:Person)
				WHERE a.name = {a} AND b.name = {b}
				CREATE (a)-[r:Knows]->(b)
			`,
			Parameters: Props{
				"a": name0,
				"b": name1,
			},
		},
	}
	err = tx.Query(qs1)
	if err != nil {
		logPretty(tx.Errors)
		t.Fatal(err)
	}
	err = tx.Commit()
	if err != nil {
		t.Fatal(err)
	}
	res0 := []struct {
		R string `json:"type(r)"`
	}{}
	cq0 := CypherQuery{
		Statement: `
				MATCH (a:Person)-[r]->(b:Person)
				WHERE a.name = {a} AND b.name = {b}
				RETURN type(r)
			`,
		Parameters: Props{
			"a": name0,
			"b": name1,
		},
		Result: &res0,
	}
	err = db.Cypher(&cq0)
	if err != nil {
		t.Fatal(err)
	}
	assert.Equal(t, "Knows", res0[0].R)
}

func TestTxRollback(t *testing.T) {
	db := connectTest(t)
	defer cleanup(t, db)
	qs0 := []*CypherQuery{
		&CypherQuery{
			Statement: `CREATE (n:Person)`,
		},
	}
	tx, err := db.Begin(qs0)
	if err != nil {
		t.Fatal(err)
	}
	err = tx.Rollback()
	if err != nil {
		t.Fatal(err)
	}
	err = tx.Query(qs0)
	assert.Equal(t, NotFound, err)
}

func TestTxQueryBad(t *testing.T) {
	db := connectTest(t)
	defer cleanup(t, db)
	qs0 := []*CypherQuery{}
	qs1 := []*CypherQuery{
		&CypherQuery{
			Statement: `foobar`,
		},
	}
	tx, err := db.Begin(qs0)
	if err != nil {
		t.Fatal(err)
	}
	err = tx.Query(qs1)
	assert.Equal(t, TxQueryError, err)
	tx.Rollback() // Else cleanup will hang til Tx times out
}