sql_test.go 3.7 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136
  1. // Copyright (C) 2013-2018 by Maxim Bublis <b@codemonkey.ru>
  2. //
  3. // Permission is hereby granted, free of charge, to any person obtaining
  4. // a copy of this software and associated documentation files (the
  5. // "Software"), to deal in the Software without restriction, including
  6. // without limitation the rights to use, copy, modify, merge, publish,
  7. // distribute, sublicense, and/or sell copies of the Software, and to
  8. // permit persons to whom the Software is furnished to do so, subject to
  9. // the following conditions:
  10. //
  11. // The above copyright notice and this permission notice shall be
  12. // included in all copies or substantial portions of the Software.
  13. //
  14. // THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND,
  15. // EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF
  16. // MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND
  17. // NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE
  18. // LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION
  19. // OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION
  20. // WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
  21. package uuid
  22. import (
  23. . "gopkg.in/check.v1"
  24. )
  25. type sqlTestSuite struct{}
  26. var _ = Suite(&sqlTestSuite{})
  27. func (s *sqlTestSuite) TestValue(c *C) {
  28. u, err := FromString("6ba7b810-9dad-11d1-80b4-00c04fd430c8")
  29. c.Assert(err, IsNil)
  30. val, err := u.Value()
  31. c.Assert(err, IsNil)
  32. c.Assert(val, Equals, u.String())
  33. }
  34. func (s *sqlTestSuite) TestValueNil(c *C) {
  35. u := UUID{}
  36. val, err := u.Value()
  37. c.Assert(err, IsNil)
  38. c.Assert(val, Equals, Nil.String())
  39. }
  40. func (s *sqlTestSuite) TestNullUUIDValueNil(c *C) {
  41. u := NullUUID{}
  42. val, err := u.Value()
  43. c.Assert(err, IsNil)
  44. c.Assert(val, IsNil)
  45. }
  46. func (s *sqlTestSuite) TestScanBinary(c *C) {
  47. u := UUID{0x6b, 0xa7, 0xb8, 0x10, 0x9d, 0xad, 0x11, 0xd1, 0x80, 0xb4, 0x00, 0xc0, 0x4f, 0xd4, 0x30, 0xc8}
  48. b1 := []byte{0x6b, 0xa7, 0xb8, 0x10, 0x9d, 0xad, 0x11, 0xd1, 0x80, 0xb4, 0x00, 0xc0, 0x4f, 0xd4, 0x30, 0xc8}
  49. u1 := UUID{}
  50. err := u1.Scan(b1)
  51. c.Assert(err, IsNil)
  52. c.Assert(u, Equals, u1)
  53. b2 := []byte{}
  54. u2 := UUID{}
  55. err = u2.Scan(b2)
  56. c.Assert(err, NotNil)
  57. }
  58. func (s *sqlTestSuite) TestScanString(c *C) {
  59. u := UUID{0x6b, 0xa7, 0xb8, 0x10, 0x9d, 0xad, 0x11, 0xd1, 0x80, 0xb4, 0x00, 0xc0, 0x4f, 0xd4, 0x30, 0xc8}
  60. s1 := "6ba7b810-9dad-11d1-80b4-00c04fd430c8"
  61. u1 := UUID{}
  62. err := u1.Scan(s1)
  63. c.Assert(err, IsNil)
  64. c.Assert(u, Equals, u1)
  65. s2 := ""
  66. u2 := UUID{}
  67. err = u2.Scan(s2)
  68. c.Assert(err, NotNil)
  69. }
  70. func (s *sqlTestSuite) TestScanText(c *C) {
  71. u := UUID{0x6b, 0xa7, 0xb8, 0x10, 0x9d, 0xad, 0x11, 0xd1, 0x80, 0xb4, 0x00, 0xc0, 0x4f, 0xd4, 0x30, 0xc8}
  72. b1 := []byte("6ba7b810-9dad-11d1-80b4-00c04fd430c8")
  73. u1 := UUID{}
  74. err := u1.Scan(b1)
  75. c.Assert(err, IsNil)
  76. c.Assert(u, Equals, u1)
  77. b2 := []byte("")
  78. u2 := UUID{}
  79. err = u2.Scan(b2)
  80. c.Assert(err, NotNil)
  81. }
  82. func (s *sqlTestSuite) TestScanUnsupported(c *C) {
  83. u := UUID{}
  84. err := u.Scan(true)
  85. c.Assert(err, NotNil)
  86. }
  87. func (s *sqlTestSuite) TestScanNil(c *C) {
  88. u := UUID{0x6b, 0xa7, 0xb8, 0x10, 0x9d, 0xad, 0x11, 0xd1, 0x80, 0xb4, 0x00, 0xc0, 0x4f, 0xd4, 0x30, 0xc8}
  89. err := u.Scan(nil)
  90. c.Assert(err, NotNil)
  91. }
  92. func (s *sqlTestSuite) TestNullUUIDScanValid(c *C) {
  93. u := UUID{0x6b, 0xa7, 0xb8, 0x10, 0x9d, 0xad, 0x11, 0xd1, 0x80, 0xb4, 0x00, 0xc0, 0x4f, 0xd4, 0x30, 0xc8}
  94. s1 := "6ba7b810-9dad-11d1-80b4-00c04fd430c8"
  95. u1 := NullUUID{}
  96. err := u1.Scan(s1)
  97. c.Assert(err, IsNil)
  98. c.Assert(u1.Valid, Equals, true)
  99. c.Assert(u1.UUID, Equals, u)
  100. }
  101. func (s *sqlTestSuite) TestNullUUIDScanNil(c *C) {
  102. u := NullUUID{UUID{0x6b, 0xa7, 0xb8, 0x10, 0x9d, 0xad, 0x11, 0xd1, 0x80, 0xb4, 0x00, 0xc0, 0x4f, 0xd4, 0x30, 0xc8}, true}
  103. err := u.Scan(nil)
  104. c.Assert(err, IsNil)
  105. c.Assert(u.Valid, Equals, false)
  106. c.Assert(u.UUID, Equals, Nil)
  107. }