1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
|
// Copyright 2015 Rick Beton. All rights reserved.
// Use of this source code is governed by a BSD-style
// license that can be found in the LICENSE file.
package date
import (
"database/sql/driver"
"fmt"
"strconv"
"time"
)
// These methods allow Date and PeriodOfDays to be fields stored in an
// SQL database by implementing the database/sql/driver interfaces.
// The underlying column type can be an integer (period of days since the epoch),
// a string, or a DATE.
// Scan parses some value. If the value holds an integer, it is treated as the
// period-of-days value that represents a Date. Otherwise, if it holds a string,
// the AutoParse function is used.
//
// This implements sql.Scanner https://golang.org/pkg/database/sql/#Scanner
func (d *Date) Scan(value interface{}) (err error) {
if value == nil {
return nil
}
return d.scanAny(value)
}
func (d *Date) scanAny(value interface{}) (err error) {
err = nil
switch v := value.(type) {
case int64:
*d = Date{PeriodOfDays(v)}
case []byte:
return d.scanString(string(v))
case string:
return d.scanString(v)
case time.Time:
*d = NewAt(v)
default:
err = fmt.Errorf("%T %+v is not a meaningful date", value, value)
}
return err
}
func (d *Date) scanString(value string) (err error) {
n, err := strconv.ParseInt(value, 10, 64)
if err == nil {
*d = Date{PeriodOfDays(n)}
return nil
}
*d, err = AutoParse(value)
return err
}
// Value converts the value to an int64. Note that if you need to store as a string,
// convert the Date to a DateString.
//
// This implements driver.Valuer https://golang.org/pkg/database/sql/driver/#Valuer
func (d Date) Value() (driver.Value, error) {
return int64(d.day), nil
}
//-------------------------------------------------------------------------------------------------
// DateString alters Date to make database storage use a string column, or
// a similar derived column such as SQL DATE. (Otherwise, Date is stored as
// an integer).
type DateString Date
// Date provides a simple fluent type conversion to the underlying type.
func (ds DateString) Date() Date {
return Date(ds)
}
// DateString provides a simple fluent type conversion from the underlying type.
func (d Date) DateString() DateString {
return DateString(d)
}
// Scan parses some value. If the value holds an integer, it is treated as the
// period-of-days value that represents a Date. Otherwise, if it holds a string,
// the AutoParse function is used.
//
// This implements sql.Scanner https://golang.org/pkg/database/sql/#Scanner
func (ds *DateString) Scan(value interface{}) (err error) {
if value == nil {
return nil
}
return (*Date)(ds).Scan(value)
}
// Value converts the value to a string. Note that if you only need to store as an int64,
// convert the DateString to a Date.
//
// This implements driver.Valuer https://golang.org/pkg/database/sql/driver/#Valuer
func (ds DateString) Value() (driver.Value, error) {
return ds.Date().String(), nil
}
//-------------------------------------------------------------------------------------------------
// Deprecated: DisableTextStorage is no longer used.
var DisableTextStorage = false
|
