123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161 |
- package sql_tpl
- type Conditions struct {
- Conditions []string
- err error
- }
- func NewConditions() *Conditions {
- return &Conditions{
- Conditions: make([]string, 0),
- }
- }
- func (conditions *Conditions) AddCondition(condition string) *Conditions {
- conditions.Conditions = append(conditions.Conditions, condition)
- return conditions
- }
- func (conditions *Conditions) Equal(columnName string, value any, opts ...AfterParsedStrValueOption) *Conditions {
- if conditions.err != nil {
- return conditions
- }
- parsedValue, err := parseValue(value, opts...)
- if err != nil {
- conditions.err = err
- return conditions
- }
- conditions.Conditions = append(conditions.Conditions, columnName+" = "+parsedValue)
- return conditions
- }
- func (conditions *Conditions) Like(columnName string, value string, opts ...AfterParsedStrValueOption) *Conditions {
- if conditions.err != nil {
- return conditions
- }
- parsedValue, err := parseValue(value, opts...)
- if err != nil {
- conditions.err = err
- return conditions
- }
- conditions.Conditions = append(conditions.Conditions, columnName+" LIKE "+parsedValue)
- return conditions
- }
- func (conditions *Conditions) In(columnName string, value any, opts ...AfterParsedStrValueOption) *Conditions {
- if conditions.err != nil {
- return conditions
- }
- parsedValue, err := parseSliceValues(value, opts...)
- if err != nil {
- conditions.err = err
- return conditions
- }
- conditions.Conditions = append(conditions.Conditions, columnName+" IN "+parsedValue)
- return conditions
- }
- func (conditions *Conditions) NotIn(columnName string, value any, opts ...AfterParsedStrValueOption) *Conditions {
- if conditions.err != nil {
- return conditions
- }
- parsedValue, err := parseSliceValues(value, opts...)
- if err != nil {
- conditions.err = err
- return conditions
- }
- conditions.Conditions = append(conditions.Conditions, columnName+" NOT IN "+parsedValue)
- return conditions
- }
- func (conditions *Conditions) Not(columnName string, value any, opts ...AfterParsedStrValueOption) *Conditions {
- if conditions.err != nil {
- return conditions
- }
- parsedValue, err := parseValue(value, opts...)
- if err != nil {
- conditions.err = err
- return conditions
- }
- conditions.Conditions = append(conditions.Conditions, columnName+" != "+parsedValue)
- return conditions
- }
- func (conditions *Conditions) LessThan(columnName string, value any, opts ...AfterParsedStrValueOption) *Conditions {
- if conditions.err != nil {
- return conditions
- }
- parsedValue, err := parseValue(value, opts...)
- if err != nil {
- conditions.err = err
- return conditions
- }
- conditions.Conditions = append(conditions.Conditions, columnName+" < "+parsedValue)
- return conditions
- }
- func (conditions *Conditions) LessThanAndEqual(columnName string, value any, opts ...AfterParsedStrValueOption) *Conditions {
- if conditions.err != nil {
- return conditions
- }
- parsedValue, err := parseValue(value, opts...)
- if err != nil {
- conditions.err = err
- return conditions
- }
- conditions.Conditions = append(conditions.Conditions, columnName+" <= "+parsedValue)
- return conditions
- }
- func (conditions *Conditions) GreaterThan(columnName string, value any, opts ...AfterParsedStrValueOption) *Conditions {
- if conditions.err != nil {
- return conditions
- }
- parsedValue, err := parseValue(value, opts...)
- if err != nil {
- conditions.err = err
- return conditions
- }
- conditions.Conditions = append(conditions.Conditions, columnName+" > "+parsedValue)
- return conditions
- }
- func (conditions *Conditions) GreaterThanAndEqual(columnName string, value any, opts ...AfterParsedStrValueOption) *Conditions {
- if conditions.err != nil {
- return conditions
- }
- parsedValue, err := parseValue(value, opts...)
- if err != nil {
- conditions.err = err
- return conditions
- }
- conditions.Conditions = append(conditions.Conditions, columnName+" >= "+parsedValue)
- return conditions
- }
|