sql_test.go

// Copyright (C) 2013-2018 by Maxim Bublis <b@codemonkey.ru>
//
// Permission is hereby granted, free of charge, to any person obtaining
// a copy of this software and associated documentation files (the
// "Software"), to deal in the Software without restriction, including
// without limitation the rights to use, copy, modify, merge, publish,
// distribute, sublicense, and/or sell copies of the Software, and to
// permit persons to whom the Software is furnished to do so, subject to
// the following conditions:
//
// The above copyright notice and this permission notice shall be
// included in all copies or substantial portions of the Software.
//
// THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND,
// EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF
// MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND
// NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE
// LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION
// OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION
// WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.

package uuid

import "gopkg.in/check.v1"

type sqlTestSuite struct{}

var _ = check.Suite(&sqlTestSuite{})

func (s *sqlTestSuite) TestValue(c *check.C) {
	u, err := FromString("6ba7b810-9dad-11d1-80b4-00c04fd430c8")
	c.Assert(err, check.IsNil)

	val, err := u.Value()
	c.Assert(err, check.IsNil)
	c.Assert(val, check.Equals, u.String())
}

func (s *sqlTestSuite) TestValueNil(c *check.C) {
	u := UUID{}

	val, err := u.Value()
	c.Assert(err, check.IsNil)
	c.Assert(val, check.Equals, Nil.String())
}

func (s *sqlTestSuite) TestNullUUIDValueNil(c *check.C) {
	u := NullUUID{}

	val, err := u.Value()
	c.Assert(err, check.IsNil)
	c.Assert(val, check.IsNil)
}

func (s *sqlTestSuite) TestScanBinary(c *check.C) {
	u := UUID{0x6b, 0xa7, 0xb8, 0x10, 0x9d, 0xad, 0x11, 0xd1, 0x80, 0xb4, 0x00, 0xc0, 0x4f, 0xd4, 0x30, 0xc8}
	b1 := []byte{0x6b, 0xa7, 0xb8, 0x10, 0x9d, 0xad, 0x11, 0xd1, 0x80, 0xb4, 0x00, 0xc0, 0x4f, 0xd4, 0x30, 0xc8}

	u1 := UUID{}
	err := u1.Scan(b1)
	c.Assert(err, check.IsNil)
	c.Assert(u, check.Equals, u1)

	b2 := []byte{}
	u2 := UUID{}

	err = u2.Scan(b2)
	c.Assert(err, check.NotNil)
}

func (s *sqlTestSuite) TestScanString(c *check.C) {
	u := UUID{0x6b, 0xa7, 0xb8, 0x10, 0x9d, 0xad, 0x11, 0xd1, 0x80, 0xb4, 0x00, 0xc0, 0x4f, 0xd4, 0x30, 0xc8}
	s1 := "6ba7b810-9dad-11d1-80b4-00c04fd430c8"

	u1 := UUID{}
	err := u1.Scan(s1)
	c.Assert(err, check.IsNil)
	c.Assert(u, check.Equals, u1)

	s2 := ""
	u2 := UUID{}

	err = u2.Scan(s2)
	c.Assert(err, check.NotNil)
}

func (s *sqlTestSuite) TestScanText(c *check.C) {
	u := UUID{0x6b, 0xa7, 0xb8, 0x10, 0x9d, 0xad, 0x11, 0xd1, 0x80, 0xb4, 0x00, 0xc0, 0x4f, 0xd4, 0x30, 0xc8}
	b1 := []byte("6ba7b810-9dad-11d1-80b4-00c04fd430c8")

	u1 := UUID{}
	err := u1.Scan(b1)
	c.Assert(err, check.IsNil)
	c.Assert(u, check.Equals, u1)

	b2 := []byte("")
	u2 := UUID{}
	err = u2.Scan(b2)
	c.Assert(err, check.NotNil)
}

func (s *sqlTestSuite) TestScanUnsupported(c *check.C) {
	u := UUID{}

	err := u.Scan(true)
	c.Assert(err, check.NotNil)
}

func (s *sqlTestSuite) TestScanNil(c *check.C) {
	u := UUID{0x6b, 0xa7, 0xb8, 0x10, 0x9d, 0xad, 0x11, 0xd1, 0x80, 0xb4, 0x00, 0xc0, 0x4f, 0xd4, 0x30, 0xc8}

	err := u.Scan(nil)
	c.Assert(err, check.NotNil)
}

func (s *sqlTestSuite) TestNullUUIDScanValid(c *check.C) {
	u := UUID{0x6b, 0xa7, 0xb8, 0x10, 0x9d, 0xad, 0x11, 0xd1, 0x80, 0xb4, 0x00, 0xc0, 0x4f, 0xd4, 0x30, 0xc8}
	s1 := "6ba7b810-9dad-11d1-80b4-00c04fd430c8"

	u1 := NullUUID{}
	err := u1.Scan(s1)
	c.Assert(err, check.IsNil)
	c.Assert(u1.Valid, check.Equals, true)
	c.Assert(u1.UUID, check.Equals, u)
}

func (s *sqlTestSuite) TestNullUUIDScanNil(c *check.C) {
	u := NullUUID{UUID{0x6b, 0xa7, 0xb8, 0x10, 0x9d, 0xad, 0x11, 0xd1, 0x80, 0xb4, 0x00, 0xc0, 0x4f, 0xd4, 0x30, 0xc8}, true}

	err := u.Scan(nil)
	c.Assert(err, check.IsNil)
	c.Assert(u.Valid, check.Equals, false)
	c.Assert(u.UUID, check.Equals, Nil)
}