marshaller_test.go

/*
 * Copyright (c) 2018, salesforce.com, inc.
 * All rights reserved.
 * SPDX-License-Identifier: BSD-3-Clause
 * For full license text, see the LICENSE file in the repo root or https://opensource.org/licenses/BSD-3-Clause
 */
package soql_test

import (
	"time"

	. "github.com/onsi/ginkgo"
	. "github.com/onsi/gomega"

	. "github.com/forcedotcom/go-soql"
)

var _ = Describe("Marshaller", func() {
	Describe("MarshalWhereClause", func() {
		var (
			clause         string
			expectedClause string
			err            error
		)
		Context("when non pointer value is passed as argument", func() {
			var (
				critetria TestQueryCriteria
			)

			JustBeforeEach(func() {
				clause, err = MarshalWhereClause(critetria)
				Expect(err).ToNot(HaveOccurred())
			})

			Context("when there are no fields populated", func() {
				It("returns empty where clause", func() {
					Expect(err).ToNot(HaveOccurred())
					Expect(clause).To(BeEmpty())
				})
			})

			Context("when only like clause pattern is populated", func() {
				Context("when there is only one item in the like clause array", func() {
					BeforeEach(func() {
						critetria = TestQueryCriteria{
							IncludeNamePattern: []string{"-db"},
						}
						expectedClause = "Host_Name__c LIKE '%-db%'"
					})

					It("returns where clause with only one condition", func() {
						Expect(clause).To(Equal(expectedClause))
					})
				})

				Context("when there is more than one item in the like clause array", func() {
					BeforeEach(func() {
						critetria = TestQueryCriteria{
							IncludeNamePattern: []string{"-db", "-dbmgmt", "-dgdb"},
						}
						expectedClause = "(Host_Name__c LIKE '%-db%' OR Host_Name__c LIKE '%-dbmgmt%' OR Host_Name__c LIKE '%-dgdb%')"
					})

					It("returns where clause with OR condition", func() {
						Expect(clause).To(Equal(expectedClause))
					})
				})

				Context("when there is single quote in values", func() {
					BeforeEach(func() {
						critetria = TestQueryCriteria{
							IncludeNamePattern: []string{"-db'", "-dbmgmt", "-dgdb"},
						}
						expectedClause = "(Host_Name__c LIKE '%-db\\'%' OR Host_Name__c LIKE '%-dbmgmt%' OR Host_Name__c LIKE '%-dgdb%')"
					})

					It("returns appropriate where clause by escaping single quote", func() {
						Expect(clause).To(Equal(expectedClause))
					})
				})

				Context("when there are special characters in values", func() {
					BeforeEach(func() {
						critetria = TestQueryCriteria{
							IncludeNamePattern: []string{"-db'_%\\"},
							AssetType:          "-db'_%\\",
						}
						expectedClause = `Host_Name__c LIKE '%-db\'\_\%\\%' AND Tech_Asset__r.Asset_Type_Asset_Type__c = '-db\'_%\\'`
					})

					It("returns appropriate where clause by escaping special characters", func() {
						Expect(clause).To(Equal(expectedClause))
					})
				})
			})

			Context("when only not like clause is populated", func() {
				Context("when there is only one item in the not like clause array", func() {
					BeforeEach(func() {
						critetria = TestQueryCriteria{
							ExcludeNamePattern: []string{"-db"},
						}
						expectedClause = "(NOT Host_Name__c LIKE '%-db%')"
					})

					It("returns where clause with only one condition", func() {
						Expect(clause).To(Equal(expectedClause))
					})
				})

				Context("when there is more than one item in the not like clause array", func() {
					BeforeEach(func() {
						critetria = TestQueryCriteria{
							ExcludeNamePattern: []string{"-db", "-dbmgmt", "-dgdb"},
						}
						expectedClause = "((NOT Host_Name__c LIKE '%-db%') AND (NOT Host_Name__c LIKE '%-dbmgmt%') AND (NOT Host_Name__c LIKE '%-dgdb%'))"
					})

					It("returns where clause with OR condition", func() {
						Expect(clause).To(Equal(expectedClause))
					})
				})

				Context("when there is single quote in values", func() {
					BeforeEach(func() {
						critetria = TestQueryCriteria{
							ExcludeNamePattern: []string{"-d'b"},
						}
						expectedClause = "(NOT Host_Name__c LIKE '%-d\\'b%')"
					})

					It("returns appropriate where clause by escaping single quote", func() {
						Expect(clause).To(Equal(expectedClause))
					})
				})
			})

			Context("when only equalsClause is populated", func() {
				BeforeEach(func() {
					critetria = TestQueryCriteria{
						AssetType: "SERVER",
					}
					expectedClause = "Tech_Asset__r.Asset_Type_Asset_Type__c = 'SERVER'"
				})

				It("returns appropriate where clause", func() {
					Expect(clause).To(Equal(expectedClause))
				})

				Context("when value has single quote", func() {
					BeforeEach(func() {
						critetria = TestQueryCriteria{
							AssetType: "SER'VER",
						}
						expectedClause = "Tech_Asset__r.Asset_Type_Asset_Type__c = 'SER\\'VER'"
					})

					It("returns appropriate where clause by escaping single quote", func() {
						Expect(clause).To(Equal(expectedClause))
					})
				})
			})

			Context("when only notEqualsClause is populated", func() {
				BeforeEach(func() {
					critetria = TestQueryCriteria{
						Status: "InActive",
					}
					expectedClause = "Status__c != 'InActive'"
				})

				It("returns appropriate where clause", func() {
					Expect(clause).To(Equal(expectedClause))
				})

				Context("when value has single quote", func() {
					BeforeEach(func() {
						critetria = TestQueryCriteria{
							Status: "In'Active",
						}
						expectedClause = "Status__c != 'In\\'Active'"
					})

					It("returns appropriate where clause by escaping single quote", func() {
						Expect(clause).To(Equal(expectedClause))
					})
				})
			})

			Context("when only inClause is populated", func() {
				Context("when there is only one item in the inClause array", func() {
					BeforeEach(func() {
						critetria = TestQueryCriteria{
							Roles: []string{"db"},
						}
						expectedClause = "Role__r.Name IN ('db')"
					})
					It("returns where clause with only one item in IN clause", func() {
						Expect(clause).To(Equal(expectedClause))
					})
				})

				Context("when there is more than one item in the inClause array", func() {
					BeforeEach(func() {
						critetria = TestQueryCriteria{
							Roles: []string{"db", "dbmgmt"},
						}
						expectedClause = "Role__r.Name IN ('db','dbmgmt')"
					})
					It("returns where clause with all the items in IN clause", func() {
						Expect(clause).To(Equal(expectedClause))
					})
				})

				Context("when value has single quote", func() {
					BeforeEach(func() {
						critetria = TestQueryCriteria{
							Roles: []string{"db", "db'mgmt"},
						}
						expectedClause = "Role__r.Name IN ('db','db\\'mgmt')"
					})
					It("returns appropriate where clause by escaping single quote", func() {
						Expect(clause).To(Equal(expectedClause))
					})
				})
			})

			Context("when only notInClause is populated", func() {
				Context("when there is only one item in the inClause array", func() {
					BeforeEach(func() {
						critetria = TestQueryCriteria{
							ExcludeIDs: []string{"123"},
						}
						expectedClause = "id NOT IN ('123')"
					})
					It("returns where clause with only one item in NOT IN clause", func() {
						Expect(clause).To(Equal(expectedClause))
					})
				})

				Context("when there is more than one item in the notInClause array", func() {
					BeforeEach(func() {
						critetria = TestQueryCriteria{
							ExcludeIDs: []string{"123", "456"},
						}
						expectedClause = "id NOT IN ('123','456')"
					})
					It("returns where clause with all the items in NOT IN clause", func() {
						Expect(clause).To(Equal(expectedClause))
					})
				})

				Context("when value has single quote", func() {
					BeforeEach(func() {
						critetria = TestQueryCriteria{
							ExcludeIDs: []string{"123", "4'56"},
						}
						expectedClause = "id NOT IN ('123','4\\'56')"
					})
					It("returns appropriate where clause by escaping single quote", func() {
						Expect(clause).To(Equal(expectedClause))
					})
				})
			})

			Context("when only null clause is populated", func() {
				Context("when null is allowed", func() {
					BeforeEach(func() {
						allowNull := true
						critetria = TestQueryCriteria{
							AllowNullLastDiscoveredDate: &allowNull,
						}

						expectedClause = "Last_Discovered_Date__c = null"
					})

					It("returns appropriate where clause", func() {
						Expect(clause).To(Equal(expectedClause))
					})
				})

				Context("when null is not allowed", func() {
					BeforeEach(func() {
						allowNull := false
						critetria = TestQueryCriteria{
							AllowNullLastDiscoveredDate: &allowNull,
						}

						expectedClause = "Last_Discovered_Date__c != null"
					})

					It("returns appropriate where clause", func() {
						Expect(clause).To(Equal(expectedClause))
					})
				})
			})

			Context("when likeOperator and inClause are populated", func() {
				BeforeEach(func() {
					critetria = TestQueryCriteria{
						IncludeNamePattern: []string{"-db", "-dbmgmt"},
						Roles:              []string{"db"},
					}

					expectedClause = "(Host_Name__c LIKE '%-db%' OR Host_Name__c LIKE '%-dbmgmt%') AND Role__r.Name IN ('db')"
				})

				It("returns properly formed clause for name and role joined by AND clause", func() {
					Expect(clause).To(Equal(expectedClause))
				})
			})

			Context("when likeOperator and equalsClause are populated", func() {
				BeforeEach(func() {
					critetria = TestQueryCriteria{
						IncludeNamePattern: []string{"-db", "-dbmgmt"},
						AssetType:          "SERVER",
					}

					expectedClause = "(Host_Name__c LIKE '%-db%' OR Host_Name__c LIKE '%-dbmgmt%') AND Tech_Asset__r.Asset_Type_Asset_Type__c = 'SERVER'"
				})

				It("returns properly formed clause for likeOperator and inClause joined by AND clause", func() {
					Expect(clause).To(Equal(expectedClause))
				})
			})

			Context("when both likeOperator and notlikeOperator are populated", func() {
				BeforeEach(func() {
					critetria = TestQueryCriteria{
						IncludeNamePattern: []string{"-db", "-dbmgmt"},
						ExcludeNamePattern: []string{"-core", "-drp"},
					}

					expectedClause = "(Host_Name__c LIKE '%-db%' OR Host_Name__c LIKE '%-dbmgmt%') AND ((NOT Host_Name__c LIKE '%-core%') AND (NOT Host_Name__c LIKE '%-drp%'))"
				})

				It("returns properly formed clause for likeOperator and notlikeOperator joined by AND clause", func() {
					Expect(clause).To(Equal(expectedClause))
				})
			})

			Context("when all clauses are populated", func() {
				BeforeEach(func() {
					allowNull := false
					critetria = TestQueryCriteria{
						AssetType:                   "SERVER",
						IncludeNamePattern:          []string{"-db", "-dbmgmt"},
						Roles:                       []string{"db", "dbmgmt"},
						ExcludeNamePattern:          []string{"-core", "-drp"},
						AllowNullLastDiscoveredDate: &allowNull,
						ExcludeIDs:                  []string{"123", "456"},
					}

					expectedClause = "(Host_Name__c LIKE '%-db%' OR Host_Name__c LIKE '%-dbmgmt%') AND Role__r.Name IN ('db','dbmgmt') AND ((NOT Host_Name__c LIKE '%-core%') AND (NOT Host_Name__c LIKE '%-drp%')) AND Tech_Asset__r.Asset_Type_Asset_Type__c = 'SERVER' AND Last_Discovered_Date__c != null AND id NOT IN ('123','456')"
				})

				It("returns properly formed clause joined by AND clause", func() {
					Expect(clause).To(Equal(expectedClause))
				})
			})
		})

		Context("when pointer is passed as argument", func() {
			var (
				critetria *TestQueryCriteria
			)

			JustBeforeEach(func() {
				clause, err = MarshalWhereClause(critetria)
			})

			Context("when nil is passed as argument", func() {
				It("returns empty where clause", func() {
					Expect(err).To(Equal(ErrNilValue))
					Expect(clause).To(BeEmpty())
				})
			})

			Context("when empty value is passed as argument", func() {
				BeforeEach(func() {
					critetria = &TestQueryCriteria{}
				})

				It("returns empty where clause", func() {
					Expect(clause).To(BeEmpty())
				})
			})

			Context("when all values are populated", func() {
				BeforeEach(func() {
					critetria = &TestQueryCriteria{
						AssetType:          "SERVER",
						IncludeNamePattern: []string{"-db", "-dbmgmt"},
						Roles:              []string{"db", "dbmgmt"},
						ExcludeNamePattern: []string{"-core", "-drp"},
					}

					expectedClause = "(Host_Name__c LIKE '%-db%' OR Host_Name__c LIKE '%-dbmgmt%') AND Role__r.Name IN ('db','dbmgmt') AND ((NOT Host_Name__c LIKE '%-core%') AND (NOT Host_Name__c LIKE '%-drp%')) AND Tech_Asset__r.Asset_Type_Asset_Type__c = 'SERVER'"
				})

				It("returns properly formed clause joined by AND clause", func() {
					Expect(clause).To(Equal(expectedClause))
				})
			})
		})

		Context("When values for date literals are int", func() {
			var criteria QueryCriteriaDateLiteralsOperatorsInt
			BeforeEach(func() {
				criteria = QueryCriteriaDateLiteralsOperatorsInt{
					CreatedDate: 5,
					ClosedDate:  10,
				}
				expectedClause = "CreatedDate > NEXT_N_DAYS:5 AND ClosedDate < NEXT_N_DAYS:10"
			})
			It("returns appropriate where clause", func() {
				clause, err = MarshalWhereClause(criteria)
				Expect(clause).To(Equal(expectedClause))
			})
		})

		Context("When values for date literals are uint", func() {
			var criteria QueryCriteriaDateLiteralsOperatorsUint
			BeforeEach(func() {
				criteria = QueryCriteriaDateLiteralsOperatorsUint{
					CreatedDate: 5,
					ClosedDate:  10,
				}
				expectedClause = "CreatedDate > NEXT_N_DAYS:5 AND ClosedDate < NEXT_N_DAYS:10"
			})
			It("returns appropriate where clause", func() {
				clause, err = MarshalWhereClause(criteria)
				Expect(clause).To(Equal(expectedClause))
			})
		})

		Context("When values for date literals are wrong type", func() {
			type QueryCriteriaDateLiteralsOperatorsWrong struct {
				CreatedDate string `soql:"greaterNextNDaysOperator,fieldName=CreatedDate"`
			}
			var criteria QueryCriteriaDateLiteralsOperatorsWrong
			BeforeEach(func() {
				criteria = QueryCriteriaDateLiteralsOperatorsWrong{
					CreatedDate: "5",
				}
			})
			It("returns error", func() {
				clause, err = MarshalWhereClause(criteria)
				Expect(err).To(Equal(ErrInvalidTag))
			})
		})

		Context("When values for date literals are pointers", func() {
			var criteria QueryCriteriaDateLiteralsOperatorsPtr
			Context("When there is only greaterNextNDaysOperator operator", func() {
				BeforeEach(func() {
					v := 5
					criteria = QueryCriteriaDateLiteralsOperatorsPtr{
						CreatedDate: &v,
					}
					expectedClause = "CreatedDate > NEXT_N_DAYS:5"
				})
				It("returns appropriate where clause", func() {
					clause, err = MarshalWhereClause(criteria)
					Expect(clause).To(Equal(expectedClause))
				})
			})
			Context("When there is only greaterOrEqualNextNDaysOperator operator", func() {
				BeforeEach(func() {
					v := 5
					criteria = QueryCriteriaDateLiteralsOperatorsPtr{
						DeliveredDate: &v,
					}
					expectedClause = "DeliveredDate >= NEXT_N_DAYS:5"
				})
				It("returns appropriate where clause", func() {
					clause, err = MarshalWhereClause(criteria)
					Expect(clause).To(Equal(expectedClause))
				})
			})
			Context("when there is only greaterLastNDaysOperator operator", func() {
				BeforeEach(func() {
					v0 := 5
					criteria = QueryCriteriaDateLiteralsOperatorsPtr{
						OtherDate: &v0,
					}
					expectedClause = "OtherDate = NEXT_N_DAYS:5"
				})
				It("returns appropriate where clause", func() {
					clause, err = MarshalWhereClause(criteria)
					Expect(clause).To(Equal(expectedClause))
				})
			})
			Context("When there is only lessNextNDaysOperator operator", func() {
				BeforeEach(func() {
					v := 10
					criteria = QueryCriteriaDateLiteralsOperatorsPtr{
						ClosedDate: &v,
					}
					expectedClause = "ClosedDate < NEXT_N_DAYS:10"
				})
				It("returns appropriate where clause", func() {
					clause, err = MarshalWhereClause(criteria)
					Expect(clause).To(Equal(expectedClause))
				})
			})
			Context("When there is only lessOrEqualNextNDaysOperator operator", func() {
				BeforeEach(func() {
					v := 10
					criteria = QueryCriteriaDateLiteralsOperatorsPtr{
						ScheduledDate: &v,
					}
					expectedClause = "ScheduledDate <= NEXT_N_DAYS:10"
				})
				It("returns appropriate where clause", func() {
					clause, err = MarshalWhereClause(criteria)
					Expect(clause).To(Equal(expectedClause))
				})
			})
			Context("When there are all operators", func() {
				BeforeEach(func() {
					v0 := 5
					v1 := 10
					v2 := 15
					v3 := 20
					v4 := 25
					criteria = QueryCriteriaDateLiteralsOperatorsPtr{
						CreatedDate:   &v0,
						OtherDate:     &v2,
						ClosedDate:    &v1,
						ScheduledDate: &v3,
						DeliveredDate: &v4,
					}
					expectedClause = "CreatedDate > NEXT_N_DAYS:5 AND OtherDate = NEXT_N_DAYS:15 AND ClosedDate < NEXT_N_DAYS:10 AND ScheduledDate <= NEXT_N_DAYS:20 AND DeliveredDate >= NEXT_N_DAYS:25"
				})
				It("returns appropriate where clause", func() {
					clause, err = MarshalWhereClause(criteria)
					Expect(clause).To(Equal(expectedClause))
				})
			})
		})

		Context("when last_n_days literals are present", func() {
			var criteria QueryCriteriaDateLastNDaysLiteralsOperatorsPtr
			Context("when there is only lessLastNDaysOperator operator", func() {
				BeforeEach(func() {
					v1 := 10
					criteria = QueryCriteriaDateLastNDaysLiteralsOperatorsPtr{
						ClosedDate: &v1,
					}
					expectedClause = "ClosedDate < LAST_N_DAYS:10"
				})
				It("returns appropriate where clause", func() {
					clause, err = MarshalWhereClause(criteria)
					Expect(clause).To(Equal(expectedClause))
				})
				Context("when there is only lessOrEqualLastNDaysOperator operator", func() {
					BeforeEach(func() {
						v1 := 10
						criteria = QueryCriteriaDateLastNDaysLiteralsOperatorsPtr{
							ScheduledDate: &v1,
						}
						expectedClause = "ScheduledDate <= LAST_N_DAYS:10"
					})
					It("returns appropriate where clause", func() {
						clause, err = MarshalWhereClause(criteria)
						Expect(clause).To(Equal(expectedClause))
					})
				})
				Context("when there is only greaterLastNDaysOperator operator", func() {
					BeforeEach(func() {
						v0 := 5
						criteria = QueryCriteriaDateLastNDaysLiteralsOperatorsPtr{
							CreatedDate: &v0,
						}
						expectedClause = "CreatedDate > LAST_N_DAYS:5"
					})
					It("returns appropriate where clause", func() {
						clause, err = MarshalWhereClause(criteria)
						Expect(clause).To(Equal(expectedClause))
					})
				})
				Context("when there is only greaterOrEqualLastNDaysOperator operator", func() {
					BeforeEach(func() {
						v0 := 5
						criteria = QueryCriteriaDateLastNDaysLiteralsOperatorsPtr{
							DeliveredDate: &v0,
						}
						expectedClause = "DeliveredDate >= LAST_N_DAYS:5"
					})
					It("returns appropriate where clause", func() {
						clause, err = MarshalWhereClause(criteria)
						Expect(clause).To(Equal(expectedClause))
					})
				})
				Context("when there is only equalsLastNDaysOperator operator", func() {
					BeforeEach(func() {
						v0 := 5
						criteria = QueryCriteriaDateLastNDaysLiteralsOperatorsPtr{
							OtherDate: &v0,
						}
						expectedClause = "OtherDate = LAST_N_DAYS:5"
					})
					It("returns appropriate where clause", func() {
						clause, err = MarshalWhereClause(criteria)
						Expect(clause).To(Equal(expectedClause))
					})
				})
				Context("when there are greaterLastNDaysOperator, lessLastNDaysOperator and equalsLastNDaysOperator operators", func() {
					BeforeEach(func() {
						v0 := 5
						v1 := 10
						v2 := 15
						v3 := 20
						v4 := 25
						criteria = QueryCriteriaDateLastNDaysLiteralsOperatorsPtr{
							CreatedDate:   &v0,
							OtherDate:     &v2,
							ClosedDate:    &v1,
							ScheduledDate: &v3,
							DeliveredDate: &v4,
						}
						expectedClause = "CreatedDate > LAST_N_DAYS:5 AND OtherDate = LAST_N_DAYS:15 AND ClosedDate < LAST_N_DAYS:10 AND ScheduledDate <= LAST_N_DAYS:20 AND DeliveredDate >= LAST_N_DAYS:25"
					})
					It("returns appropriate where clause", func() {
						clause, err = MarshalWhereClause(criteria)
						Expect(clause).To(Equal(expectedClause))
					})
				})
			})
		})

		Context("when all clauses are signed integer data types", func() {
			var criteria QueryCriteriaWithIntegerTypes
			BeforeEach(func() {
				criteria = QueryCriteriaWithIntegerTypes{
					NumOfCPUCores:                    16,
					PhysicalCPUCount:                 4,
					NumOfSuccessivePuppetRunFailures: -1,
					NumOfCoolanLogFiles:              1024,
					PvtTestFailCount:                 9223372036854775807,
				}

				expectedClause = "Num_of_CPU_Cores__c = 16 AND Physical_CPU_Count__c = 4 AND Number_Of_Successive_Puppet_Run_Failures__c = -1 AND Num_Of_Coolan_Log_Files__c = 1024 AND Pvt_Test_Fail_Count__c = 9223372036854775807"
			})

			It("returns properly formed clause joined by AND clause", func() {
				clause, err = MarshalWhereClause(criteria)
				Expect(err).ToNot(HaveOccurred())
				Expect(clause).To(Equal(expectedClause))
			})
		})

		Context("when all clauses are unsigned integer data types", func() {
			var criteria QueryCriteriaWithUnsignedIntegerTypes
			BeforeEach(func() {
				criteria = QueryCriteriaWithUnsignedIntegerTypes{
					NumOfCPUCores:                    16,
					PhysicalCPUCount:                 4,
					NumOfSuccessivePuppetRunFailures: 0,
					NumOfCoolanLogFiles:              1024,
					PvtTestFailCount:                 9223372036854775807,
				}

				expectedClause = "Num_of_CPU_Cores__c = 16 AND Physical_CPU_Count__c = 4 AND Number_Of_Successive_Puppet_Run_Failures__c = 0 AND Num_Of_Coolan_Log_Files__c = 1024 AND Pvt_Test_Fail_Count__c = 9223372036854775807"
			})

			It("returns properly formed clause joined by AND clause", func() {
				clause, err = MarshalWhereClause(criteria)
				Expect(err).ToNot(HaveOccurred())
				Expect(clause).To(Equal(expectedClause))
			})
		})

		Context("when all clauses are float data types", func() {
			var criteria QueryCriteriaWithFloatTypes
			BeforeEach(func() {
				criteria = QueryCriteriaWithFloatTypes{
					NumOfCPUCores:    16.00000000,
					PhysicalCPUCount: -4.12345678,
				}

				expectedClause = "Num_of_CPU_Cores__c = 16 AND Physical_CPU_Count__c = -4.12345678"
			})

			It("returns properly formed clause joined by AND clause", func() {
				clause, err = MarshalWhereClause(criteria)
				Expect(err).ToNot(HaveOccurred())
				Expect(clause).To(Equal(expectedClause))
			})
		})

		Context("when all clauses are *float data types", func() {
			var criteria QueryCriteriaWithFloatPtrTypes
			BeforeEach(func() {
				numCores := 16.0
				criteria = QueryCriteriaWithFloatPtrTypes{
					NumOfCPUCores: &numCores,
				}

				expectedClause = "Num_of_CPU_Cores__c = 16"
			})

			It("returns properly formed clause joined by skipping nil values", func() {
				clause, err = MarshalWhereClause(criteria)
				Expect(err).ToNot(HaveOccurred())
				Expect(clause).To(Equal(expectedClause))
			})
		})

		Context("when all clauses are boolean data types", func() {
			var criteria QueryCriteriaWithBooleanType
			BeforeEach(func() {
				criteria = QueryCriteriaWithBooleanType{
					NUMAEnabled:   true,
					DisableAlerts: false,
				}

				expectedClause = "NUMA_Enabled__c = true AND Disable_Alerts__c = false"
			})

			It("returns properly formed clause joined by AND clause", func() {
				clause, err = MarshalWhereClause(criteria)
				Expect(err).ToNot(HaveOccurred())
				Expect(clause).To(Equal(expectedClause))
			})
		})

		Context("when data type is boolean pointer", func() {
			var criteria QueryCriteriaWithBooleanPtrType
			BeforeEach(func() {
				numEnabled := true
				criteria = QueryCriteriaWithBooleanPtrType{
					NUMAEnabled: &numEnabled,
				}

				expectedClause = "NUMA_Enabled__c = true"
			})

			It("returns properly formed clause by skipping nil values", func() {
				clause, err = MarshalWhereClause(criteria)
				Expect(err).ToNot(HaveOccurred())
				Expect(clause).To(Equal(expectedClause))
			})
		})

		Context("when some clauses have soql tags and don't", func() {
			var criteria QueryCriteriaWithNoSoqlTag
			BeforeEach(func() {
				criteria = QueryCriteriaWithNoSoqlTag{
					NUMAEnabled:   true,
					DisableAlerts: false,
				}

				expectedClause = "NUMA_Enabled__c = true"
			})

			It("returns properly formed clause without error§q", func() {
				clause, err = MarshalWhereClause(criteria)
				Expect(err).ToNot(HaveOccurred())
				Expect(clause).To(Equal(expectedClause))
			})
		})

		Context("when all clauses are date time data types", func() {
			var criteria QueryCriteriaWithDateTimeType
			var currentTime time.Time
			BeforeEach(func() {
				currentTime = time.Now()
				criteria = QueryCriteriaWithDateTimeType{
					CreatedDate: currentTime,
				}

				expectedClause = "CreatedDate = " + currentTime.Format(DateTimeFormat)
			})

			It("returns properly formed clause", func() {
				clause, err = MarshalWhereClause(criteria)
				Expect(err).ToNot(HaveOccurred())
				Expect(clause).To(Equal(expectedClause))
			})
		})

		Context("when all clauses are pointers to date time data types", func() {
			var criteria QueryCriteriaWithPtrDateTimeType
			var currentTime time.Time
			BeforeEach(func() {
				currentTime = time.Now()
				criteria = QueryCriteriaWithPtrDateTimeType{
					CreatedDate:  &currentTime,
					ResolvedDate: nil,
				}

				expectedClause = "CreatedDate = " + currentTime.Format(DateTimeFormat)
			})

			It("returns properly formed clause", func() {
				clause, err = MarshalWhereClause(criteria)
				Expect(err).ToNot(HaveOccurred())
				Expect(clause).To(Equal(expectedClause))
			})
		})

		Context("when all clauses are mixed data types and operators", func() {
			var criteria QueryCriteriaWithMixedDataTypesAndOperators
			var currentTime time.Time
			BeforeEach(func() {
				currentTime = time.Now()
				numHardDrives := 2
				criteria = QueryCriteriaWithMixedDataTypesAndOperators{
					BIOSType:                         "98.7.654a",
					NumOfCPUCores:                    32,
					NUMAEnabled:                      true,
					PvtTestFailCount:                 256,
					PhysicalCPUCount:                 4,
					CreatedDate:                      currentTime,
					UpdatedDate:                      &currentTime,
					DisableAlerts:                    false,
					AllocationLatency:                10.5,
					MajorOSVersion:                   "20",
					NumOfSuccessivePuppetRunFailures: 0,
					LastRestart:                      currentTime,
					ClosedDate:                       5,
					NumHardDrives:                    &numHardDrives,
				}

				expectedClause = "BIOS_Type__c = '98.7.654a' AND Num_of_CPU_Cores__c > 32 AND NUMA_Enabled__c = true AND Pvt_Test_Fail_Count__c <= 256 AND Physical_CPU_Count__c >= 4 AND CreatedDate = " + currentTime.Format(TestDateFormat) + " AND UpdatedDate = " + currentTime.Format(TestDateFormat) + " AND Disable_Alerts__c = false AND Allocation_Latency__c < 10.5 AND Major_OS_Version__c = '20' AND Number_Of_Successive_Puppet_Run_Failures__c = 0 AND Last_Restart__c > " + currentTime.Format(DateTimeFormat) + " AND NumHardDrives__c = 2 AND ClosedDate > NEXT_N_DAYS:5"
			})

			It("returns properly formed clause", func() {
				clause, err = MarshalWhereClause(criteria)
				Expect(err).ToNot(HaveOccurred())
				Expect(clause).To(Equal(expectedClause))
			})
		})

		Context("when clauses contains gt, gte, lt and lte operators", func() {
			var criteria QueryCriteriaNumericComparisonOperators
			BeforeEach(func() {
				criteria = QueryCriteriaNumericComparisonOperators{
					NumOfCPUCores:                    16,
					PhysicalCPUCount:                 4,
					NumOfSuccessivePuppetRunFailures: 0,
					NumOfCoolanLogFiles:              1024,
				}

				expectedClause = "Num_of_CPU_Cores__c > 16 AND Physical_CPU_Count__c < 4 AND Number_Of_Successive_Puppet_Run_Failures__c >= 0 AND Num_Of_Coolan_Log_Files__c <= 1024"
			})

			It("returns properly formed clause", func() {
				clause, err = MarshalWhereClause(criteria)
				Expect(err).ToNot(HaveOccurred())
				Expect(clause).To(Equal(expectedClause))
			})
		})

		Context("when no fieldName parameter is specified in tag", func() {
			var defaultFieldNameCriteria DefaultFieldNameQueryCriteria
			BeforeEach(func() {
				defaultFieldNameCriteria = DefaultFieldNameQueryCriteria{
					IncludeNamePattern: []string{"-db", "-dbmgmt"},
					Role:               []string{"foo", "bar"},
				}
				expectedClause = "(Host_Name__c LIKE '%-db%' OR Host_Name__c LIKE '%-dbmgmt%') AND Role IN ('foo','bar')"
			})

			It("returns properly formed clause joined by AND clause", func() {
				clause, err = MarshalWhereClause(defaultFieldNameCriteria)
				Expect(err).ToNot(HaveOccurred())
				Expect(clause).To(Equal(expectedClause))
			})
		})

		Context("when tag is invalid", func() {
			Context("when struct has invalid tag key", func() {
				type InvalidCriteriaStruct struct {
					SomePattern      []string `soql:"likeOperator,fieldName=Some_Pattern__c"`
					SomeOtherPattern string   `soql:"invalidClause,fieldName=Some_Other_Field"`
				}

				It("returns ErrInvalidTag error", func() {
					str, err := MarshalWhereClause(InvalidCriteriaStruct{})
					Expect(err).To(Equal(ErrInvalidTag))
					Expect(str).To(BeEmpty())
				})
			})

			Context("when struct has missing fieldName", func() {
				type MissingFieldName struct {
					SomePattern      []string `soql:"likeOperator,fieldName=Some_Pattern__c"`
					SomeOtherPattern string   `soql:"equalsOperator,fieldName="`
				}

				It("returns ErrInvalidTag error", func() {
					str, err := MarshalWhereClause(MissingFieldName{
						SomePattern:      []string{"test"},
						SomeOtherPattern: "foo",
					})
					Expect(err).To(Equal(ErrInvalidTag))
					Expect(str).To(BeEmpty())
				})
			})

			Context("when struct has invalid type for likeOperator", func() {
				type QueryCriteriaWithInvalidLikeOperator struct {
					IncludeNamePattern []bool `soql:"likeOperator,fieldName=Host_Name__c"`
				}
				It("returns error", func() {
					_, err := MarshalWhereClause(QueryCriteriaWithInvalidLikeOperator{})
					Expect(err).To(Equal(ErrInvalidTag))
				})
			})

			Context("when struct has invalid type for likeOperator", func() {
				type QueryCriteriaWithInvalidNotLikeOperator struct {
					ExcludeNamePattern []bool `soql:"notLikeOperator,fieldName=Host_Name__c"`
				}
				It("returns error", func() {
					_, err := MarshalWhereClause(QueryCriteriaWithInvalidNotLikeOperator{})
					Expect(err).To(Equal(ErrInvalidTag))
				})
			})

			Context("when struct has invalid type for inOperator", func() {
				type QueryCriteriaWithInvalidInOperator struct {
					Roles int `soql:"inOperator,fieldName=Role__c"`
				}
				It("returns error", func() {
					_, err := MarshalWhereClause(QueryCriteriaWithInvalidInOperator{})
					Expect(err).To(Equal(ErrInvalidTag))
				})
			})

			Context("when struct has invalid type for comparison operators", func() {
				type QueryCriteriaWithInvalidComparisonOperator struct {
					Roles []int `soql:"lessThanOperator,fieldName=Role__c"`
				}
				It("returns error", func() {
					_, err := MarshalWhereClause(QueryCriteriaWithInvalidComparisonOperator{})
					Expect(err).To(Equal(ErrInvalidTag))
				})
			})
		})
	})

	Describe("MarshalOrderByClause", func() {
		Context("when valid Order slice passed as argument", func() {
			Context("when an empty Order by slice is passed", func() {
				It("returns empty order by clause", func() {
					clause, err := MarshalOrderByClause([]Order{}, struct {
						NumOfCPUCores int `soql:"selectColumn,fieldName=Num_of_CPU_Cores__c"`
					}{})
					Expect(err).ToNot(HaveOccurred())
					Expect(clause).To(BeEmpty())
				})
			})

			Context("when an Order slice with single order by column desc is passed", func() {
				It("returns a column desc partial clause", func() {
					desc := Order{Field: "NumOfCPUCores", IsDesc: true}
					clause, err := MarshalOrderByClause([]Order{desc}, struct {
						NumOfCPUCores int `soql:"selectColumn,fieldName=Num_of_CPU_Cores__c"`
					}{})
					Expect(err).ToNot(HaveOccurred())
					Expect(clause).To(Equal("Num_of_CPU_Cores__c DESC"))
				})
			})

			Context("when an Order slice with single order by column asc is passed", func() {
				It("returns a column asc partial clause", func() {
					asc := Order{Field: "NumOfCPUCores", IsDesc: false}
					clause, err := MarshalOrderByClause([]Order{asc}, struct {
						NumOfCPUCores int `soql:"selectColumn,fieldName=Num_of_CPU_Cores__c"`
					}{})
					Expect(err).ToNot(HaveOccurred())
					Expect(clause).To(Equal("Num_of_CPU_Cores__c ASC"))
				})
			})

			Context("when an Order slice with multiple order by column ASC is passed", func() {
				It("returns multiple columns asc partial clause", func() {
					col1 := Order{Field: "MajorOSVersion", IsDesc: false}
					col2 := Order{Field: "NumOfCPUCores", IsDesc: false}
					col3 := Order{Field: "PhysicalCPUCount", IsDesc: false}
					clause, err := MarshalOrderByClause([]Order{col1, col2, col3}, struct {
						MajorOSVersion   string    `soql:"selectColumn,fieldName=Major_OS_Version__c"`
						NumOfCPUCores    int       `soql:"selectColumn,fieldName=Num_of_CPU_Cores__c"`
						PhysicalCPUCount uint8     `soql:"selectColumn,fieldName=Physical_CPU_Count__c"`
						LastRestart      time.Time `soql:"selectColumn,fieldName=Last_Restart__c"`
					}{})
					Expect(err).ToNot(HaveOccurred())
					Expect(clause).To(Equal("Major_OS_Version__c ASC,Num_of_CPU_Cores__c ASC,Physical_CPU_Count__c ASC"))
				})
			})

			Context("when an Order slice with multiple order by column DESC is passed", func() {
				It("returns multiple columns asc partial clause", func() {
					col1 := Order{Field: "MajorOSVersion", IsDesc: true}
					col2 := Order{Field: "NumOfCPUCores", IsDesc: true}
					col3 := Order{Field: "LastRestart", IsDesc: true}
					clause, err := MarshalOrderByClause([]Order{col1, col2, col3}, struct {
						MajorOSVersion   string    `soql:"selectColumn,fieldName=Major_OS_Version__c"`
						NumOfCPUCores    int       `soql:"selectColumn,fieldName=Num_of_CPU_Cores__c"`
						PhysicalCPUCount uint8     `soql:"selectColumn,fieldName=Physical_CPU_Count__c"`
						LastRestart      time.Time `soql:"selectColumn,fieldName=Last_Restart__c"`
					}{})
					Expect(err).ToNot(HaveOccurred())
					Expect(clause).To(Equal("Major_OS_Version__c DESC,Num_of_CPU_Cores__c DESC,Last_Restart__c DESC"))
				})
			})

			Context("when an Order slice with multiple order by column with mixed order is passed", func() {
				It("returns a valid partial clause", func() {
					col1 := Order{Field: "MajorOSVersion", IsDesc: true}
					col2 := Order{Field: "NumOfCPUCores", IsDesc: false}
					col3 := Order{Field: "PhysicalCPUCount", IsDesc: true}
					col4 := Order{Field: "LastRestart", IsDesc: false}
					clause, err := MarshalOrderByClause([]Order{col1, col2, col3, col4}, struct {
						MajorOSVersion   string    `soql:"selectColumn,fieldName=Major_OS_Version__c"`
						NumOfCPUCores    int       `soql:"selectColumn,fieldName=Num_of_CPU_Cores__c"`
						PhysicalCPUCount uint8     `soql:"selectColumn,fieldName=Physical_CPU_Count__c"`
						LastRestart      time.Time `soql:"selectColumn,fieldName=Last_Restart__c"`
					}{})
					Expect(err).ToNot(HaveOccurred())
					Expect(clause).To(Equal("Major_OS_Version__c DESC,Num_of_CPU_Cores__c ASC,Physical_CPU_Count__c DESC,Last_Restart__c ASC"))
				})
			})
		})

		Context("when invalid order by is passed as argument", func() {
			Context("when a slice that is not of Order type is passed as argument", func() {
				It("returns error", func() {
					_, err := MarshalOrderByClause([]string{"test"}, struct {
						NumOfCPUCores int `soql:"selectColumn,fieldName=Num_of_CPU_Cores__c"`
					}{})
					Expect(err).To(Equal(ErrInvalidOrderByClause))
				})
			})

			Context("when an Order slice containing incorrect field name is passed as argument", func() {
				It("returns error", func() {
					col1 := Order{Field: "MajorOSVersion", IsDesc: true}
					_, err := MarshalOrderByClause([]Order{col1}, struct {
						NumOfCPUCores int `soql:"selectColumn,fieldName=Num_of_CPU_Cores__c"`
					}{})
					Expect(err).To(Equal(ErrInvalidOrderByClause))
				})
			})
		})

		Context("when invalid selectColumn struct is passed as argument", func() {
			Context("when a struct with no selectColumn is passed as argument", func() {
				It("returns error", func() {
					col1 := Order{Field: "MajorOSVersion", IsDesc: true}
					_, err := MarshalOrderByClause([]Order{col1}, struct {
						NumOfCPUCores int `soql:"fieldName=Num_of_CPU_Cores__c"`
					}{})
					Expect(err).To(Equal(ErrInvalidSelectColumnOrderByClause))
				})
			})

			Context("when a non-struct is passed as argument", func() {
				It("returns error", func() {
					col1 := Order{Field: "MajorOSVersion", IsDesc: true}
					_, err := MarshalOrderByClause([]Order{col1}, "dummy")
					Expect(err).To(Equal(ErrInvalidSelectColumnOrderByClause))
				})
			})
		})
	})

	Describe("MarshalSelectClause", func() {
		Context("when non pointer value is passed as argument", func() {
			Context("when no relationship name is passed", func() {
				Context("when no nested struct is passed", func() {
					It("returns just the json tag names of fields concatenanted by comma", func() {
						str, err := MarshalSelectClause(NonNestedStruct{}, "")
						Expect(err).ToNot(HaveOccurred())
						Expect(str).To(Equal("Name,SomeValue__c"))
					})
				})

				Context("when no fieldName parameter is specified in tag", func() {
					It("returns propery resolved list of field names by using defaults", func() {
						str, err := MarshalSelectClause(DefaultFieldNameStruct{}, "")
						Expect(err).ToNot(HaveOccurred())
						Expect(str).To(Equal("DefaultName,Description__c"))
					})
				})

				Context("when nested struct is passed", func() {
					It("returns properly resolved list of field names", func() {
						str, err := MarshalSelectClause(NestedStruct{}, "")
						Expect(err).ToNot(HaveOccurred())
						Expect(str).To(Equal("Id,Name__c,NonNestedStruct__r.Name,NonNestedStruct__r.SomeValue__c"))
					})
				})
			})

			Context("when relationship name is passed", func() {
				Context("when no nested struct is passed", func() {
					It("returns just the json tag names of fields concatenanted by comma and prefixed by relationship name", func() {
						str, err := MarshalSelectClause(NonNestedStruct{}, "Role__r")
						Expect(err).ToNot(HaveOccurred())
						Expect(str).To(Equal("Role__r.Name,Role__r.SomeValue__c"))
					})
				})
			})

			Context("when struct has invalid tag key", func() {
				type InvalidStruct struct {
					Id  string `soql:"selectColumn,fieldName=Id"`
					Foo string `soql:"invalidClause,fieldName=Foo"`
				}

				It("returns ErrInvalidTag error", func() {
					str, err := MarshalSelectClause(InvalidStruct{}, "")
					Expect(err).To(Equal(ErrInvalidTag))
					Expect(str).To(BeEmpty())
				})
			})

			Context("when struct has missing fieldName", func() {
				type MissingFieldName struct {
					SomePattern      []string `soql:"selectColumn,fieldName=Some_Pattern__c"`
					SomeOtherPattern string   `soql:"selectColumn,fieldName="`
				}

				It("returns ErrInvalidTag error", func() {
					str, err := MarshalSelectClause(MissingFieldName{}, "")
					Expect(err).To(Equal(ErrInvalidTag))
					Expect(str).To(BeEmpty())
				})
			})

			Context("when struct has child relationship", func() {
				Context("when child struct has select clause only", func() {
					It("returns properly constructed select clause", func() {
						str, err := MarshalSelectClause(ParentStruct{}, "")
						Expect(err).ToNot(HaveOccurred())
						Expect(str).To(Equal("Id,Name__c,NonNestedStruct__r.Name,NonNestedStruct__r.SomeValue__c,(SELECT SM_Application_Versions__c.Version__c FROM Application_Versions__r)"))
					})
				})

				Context("when child struct has select clause and where clause", func() {
					It("returns properly constructed select clause", func() {
						str, err := MarshalSelectClause(ParentStruct{
							ChildStruct: TestChildStruct{
								WhereClause: ChildQueryCriteria{
									Name: "sfdc-release",
								},
							},
						}, "")
						Expect(err).ToNot(HaveOccurred())
						Expect(str).To(Equal("Id,Name__c,NonNestedStruct__r.Name,NonNestedStruct__r.SomeValue__c,(SELECT SM_Application_Versions__c.Version__c FROM Application_Versions__r WHERE SM_Application_Versions__c.Name__c = 'sfdc-release')"))
					})
				})

				Context("when selectChild tag does not have fieldName parameter", func() {
					It("returns properly constructed select clause", func() {
						str, err := MarshalSelectClause(DefaultFieldNameParentStruct{
							ChildStruct: TestChildStruct{
								WhereClause: ChildQueryCriteria{
									Name: "sfdc-release",
								},
							},
						}, "")
						Expect(err).ToNot(HaveOccurred())
						Expect(str).To(Equal("Id,Name__c,NonNestedStruct__r.Name,NonNestedStruct__r.SomeValue__c,(SELECT SM_Application_Versions__c.Version__c FROM ChildStruct WHERE SM_Application_Versions__c.Name__c = 'sfdc-release')"))
					})
				})

				Context("when child struct does not have select clause", func() {
					It("returns error", func() {
						_, err := MarshalSelectClause(InvalidParentStruct{}, "")
						Expect(err).To(Equal(ErrNoSelectClause))
					})
				})

				Context("when selectChild is used on non struct member", func() {
					It("returns error", func() {
						_, err := MarshalSelectClause(InvalidSelectChildClause{}, "")
						Expect(err).To(Equal(ErrInvalidTag))
					})
				})

				Context("when selectChild tag is applied to non struct member", func() {
					It("returns error", func() {
						_, err := MarshalSelectClause(ChildTagToNonStruct{}, "")
						Expect(err).To(Equal(ErrInvalidTag))
					})
				})
			})
		})

		Context("when pointer value is passed as argument", func() {
			Context("when nil is passed", func() {
				It("returns ErrNilValue error", func() {
					var r *NestedStruct
					str, err := MarshalSelectClause(r, "")
					Expect(err).To(Equal(ErrNilValue))
					Expect(str).To(BeEmpty())
				})
			})

			Context("when nested struct is passed", func() {
				It("returns properly resolved list of field names", func() {
					str, err := MarshalSelectClause(&NestedStruct{}, "")
					Expect(err).ToNot(HaveOccurred())
					Expect(str).To(Equal("Id,Name__c,NonNestedStruct__r.Name,NonNestedStruct__r.SomeValue__c"))
				})
			})
		})
	})

	Describe("Marshal", func() {
		var (
			soqlStruct    interface{}
			expectedQuery string
			actualQuery   string
			err           error
		)

		JustBeforeEach(func() {
			actualQuery, err = Marshal(soqlStruct)
		})

		Context("when empty struct is passed as argument", func() {
			BeforeEach(func() {
				soqlStruct = EmptyStruct{}
			})

			It("returns empty string", func() {
				Expect(err).ToNot(HaveOccurred())
				Expect(actualQuery).To(BeEmpty())
			})
		})

		Context("when valid value is passed as argument", func() {
			BeforeEach(func() {
				soqlStruct = TestSoqlStruct{
					SelectClause: NestedStruct{},
					WhereClause: TestQueryCriteria{
						IncludeNamePattern: []string{"-db", "-dbmgmt"},
						Roles:              []string{"db", "dbmgmt"},
					},
				}
				expectedQuery = "SELECT Id,Name__c,NonNestedStruct__r.Name,NonNestedStruct__r.SomeValue__c FROM SM_Logical_Host__c WHERE (Host_Name__c LIKE '%-db%' OR Host_Name__c LIKE '%-dbmgmt%') AND Role__r.Name IN ('db','dbmgmt')"
			})

			It("returns properly constructed soql query", func() {
				Expect(err).ToNot(HaveOccurred())
				Expect(actualQuery).To(Equal(expectedQuery))
			})
		})

		Context("when value with single quotes is passed as argument", func() {
			BeforeEach(func() {
				soqlStruct = TestSoqlStruct{
					SelectClause: NestedStruct{},
					WhereClause: TestQueryCriteria{
						IncludeNamePattern: []string{"Blips 'n' Chitz", "Michaels"},
					},
				}
				expectedQuery = "SELECT Id,Name__c,NonNestedStruct__r.Name,NonNestedStruct__r.SomeValue__c FROM SM_Logical_Host__c WHERE (Host_Name__c LIKE '%Blips \\'n\\' Chitz%' OR Host_Name__c LIKE '%Michaels%')"
			})

			It("returns properly constructed soql query", func() {
				Expect(err).ToNot(HaveOccurred())
				Expect(actualQuery).To(Equal(expectedQuery))
			})
		})

		Context("when valid value with mixed data type and operator is passed as argument", func() {
			BeforeEach(func() {
				currentTime := time.Now()
				soqlStruct = TestSoqlMixedDataAndOperatorStruct{
					SelectClause: NestedStruct{},
					WhereClause: QueryCriteriaWithMixedDataTypesAndOperators{
						BIOSType:                         "98.7.654a",
						NumOfCPUCores:                    32,
						NUMAEnabled:                      true,
						PvtTestFailCount:                 256,
						PhysicalCPUCount:                 4,
						CreatedDate:                      currentTime,
						UpdatedDate:                      &currentTime,
						DisableAlerts:                    false,
						AllocationLatency:                10.5,
						MajorOSVersion:                   "20",
						NumOfSuccessivePuppetRunFailures: 0,
						ClosedDate:                       5,
						LastRestart:                      currentTime,
					},
				}
				expectedQuery = "SELECT Id,Name__c,NonNestedStruct__r.Name,NonNestedStruct__r.SomeValue__c FROM SM_Logical_Host__c WHERE BIOS_Type__c = '98.7.654a' AND Num_of_CPU_Cores__c > 32 AND NUMA_Enabled__c = true AND Pvt_Test_Fail_Count__c <= 256 AND Physical_CPU_Count__c >= 4 AND CreatedDate = " + currentTime.Format(TestDateFormat) + " AND UpdatedDate = " + currentTime.Format(TestDateFormat) + " AND Disable_Alerts__c = false AND Allocation_Latency__c < 10.5 AND Major_OS_Version__c = '20' AND Number_Of_Successive_Puppet_Run_Failures__c = 0 AND Last_Restart__c > " + currentTime.Format(DateTimeFormat) + " AND ClosedDate > NEXT_N_DAYS:5"
			})

			It("returns properly constructed soql query", func() {
				Expect(err).ToNot(HaveOccurred())
				Expect(actualQuery).To(Equal(expectedQuery))
			})
		})

		Context("when valid pointer is passed as argument", func() {
			BeforeEach(func() {
				soqlStruct = &TestSoqlStruct{
					SelectClause: NestedStruct{},
					WhereClause: TestQueryCriteria{
						IncludeNamePattern: []string{"-db", "-dbmgmt"},
						Roles:              []string{"db", "dbmgmt"},
					},
				}
				expectedQuery = "SELECT Id,Name__c,NonNestedStruct__r.Name,NonNestedStruct__r.SomeValue__c FROM SM_Logical_Host__c WHERE (Host_Name__c LIKE '%-db%' OR Host_Name__c LIKE '%-dbmgmt%') AND Role__r.Name IN ('db','dbmgmt')"
			})

			It("returns properly constructed soql query", func() {
				Expect(err).ToNot(HaveOccurred())
				Expect(actualQuery).To(Equal(expectedQuery))
			})
		})

		Context("when struct with no soql tags is passed", func() {
			BeforeEach(func() {
				soqlStruct = NonSoqlStruct{}
			})

			It("returns emptyString", func() {
				Expect(err).ToNot(HaveOccurred())
				Expect(actualQuery).To(BeEmpty())
			})
		})

		Context("when struct with multiple selectClause is passed", func() {
			BeforeEach(func() {
				soqlStruct = MultipleSelectClause{}
			})

			It("returns error", func() {
				Expect(err).To(Equal(ErrMultipleSelectClause))
			})
		})

		Context("when selectClause is used on non struct members", func() {
			BeforeEach(func() {
				soqlStruct = InvalidSelectClause{}
			})

			It("returns error", func() {
				Expect(err).To(Equal(ErrInvalidTag))
			})
		})

		Context("when struct with multiple whereClause is passed", func() {
			BeforeEach(func() {
				soqlStruct = MultipleWhereClause{}
			})

			It("returns error", func() {
				Expect(err).To(Equal(ErrMultipleWhereClause))
			})
		})

		Context("when struct with only whereClause is passed", func() {
			BeforeEach(func() {
				soqlStruct = OnlyWhereClause{
					WhereClause: TestQueryCriteria{
						AssetType:          "SERVER",
						IncludeNamePattern: []string{"-db", "-dbmgmt"},
						Roles:              []string{"db", "dbmgmt"},
					},
				}
			})

			It("returns error", func() {
				Expect(err).To(Equal(ErrNoSelectClause))
			})
		})

		Context("when struct with multiple whereClause is passed", func() {
			BeforeEach(func() {
				soqlStruct = MultipleWhereClause{
					WhereClause1: ChildQueryCriteria{
						Name: "foo",
					},
					WhereClause2: ChildQueryCriteria{
						Name: "bar",
					},
				}
			})

			It("returns error", func() {
				Expect(err).To(HaveOccurred())
			})
		})

		Context("when nil pointer is passed", func() {
			BeforeEach(func() {
				var ptr *TestSoqlStruct
				soqlStruct = ptr
			})

			It("returns ErrNilValue error", func() {
				Expect(err).To(Equal(ErrNilValue))
			})
		})

		Context("when struct with invalid tag is passed", func() {
			BeforeEach(func() {
				soqlStruct = InvalidTagInStruct{}
			})

			It("returns error", func() {
				Expect(err).To(Equal(ErrInvalidTag))
			})
		})

		Context("when no table name is specified for selectClause", func() {
			BeforeEach(func() {
				soqlStruct = DefaultTableNameStruct{
					SomeTableName: NestedStruct{},
					WhereClause: TestQueryCriteria{
						IncludeNamePattern: []string{"-db", "-dbmgmt"},
						Roles:              []string{"db", "dbmgmt"},
					},
				}
				expectedQuery = "SELECT Id,Name__c,NonNestedStruct__r.Name,NonNestedStruct__r.SomeValue__c FROM SomeTableName WHERE (Host_Name__c LIKE '%-db%' OR Host_Name__c LIKE '%-dbmgmt%') AND Role__r.Name IN ('db','dbmgmt')"
			})

			It("uses name of the field as table name and returns properly constructed soql query", func() {
				Expect(err).ToNot(HaveOccurred())
				Expect(actualQuery).To(Equal(expectedQuery))
			})
		})

		Context("when struct with multiple orderByClause is passed", func() {
			BeforeEach(func() {
				soqlStruct = MultipleOrderByClause{}
			})

			It("returns error", func() {
				Expect(err).To(Equal(ErrMultipleOrderByClause))
			})
		})

		Context("when struct with only orderByClause is passed", func() {
			BeforeEach(func() {
				soqlStruct = OnlyOrderByClause{}
			})

			It("returns error", func() {
				Expect(err).To(Equal(ErrNoSelectClause))
			})
		})

		Context("when a struct with mixed order by columns at top query level is passed", func() {
			BeforeEach(func() {
				soqlStruct = TestSoqlOrderByStruct{OrderByClause: []Order{
					Order{Field: "ID", IsDesc: false},
					Order{Field: "Name", IsDesc: true},
					Order{Field: "NonNestedStruct.SomeValue", IsDesc: false},
				}}
				expectedQuery = "SELECT Id,Name__c,NonNestedStruct__r.Name,NonNestedStruct__r.SomeValue__c FROM SM_Logical_Host__c ORDER BY Id ASC,Name__c DESC,NonNestedStruct__r.SomeValue__c ASC"
			})

			It("returns properly constructed soql query", func() {
				Expect(err).ToNot(HaveOccurred())
				Expect(actualQuery).To(Equal(expectedQuery))
			})
		})

		Context("when a struct with order by inside a child relation is passed", func() {
			BeforeEach(func() {
				col1 := Order{Field: "Version", IsDesc: true}
				soqlStruct = TestSoqlChildRelationOrderByStruct{
					SelectClause: OrderByParentStruct{
						ChildStruct: TestChildWithOrderByStruct{
							OrderByClause: []Order{col1},
						},
					},
				}
				expectedQuery = "SELECT Id,Name__c,(SELECT SM_Application_Versions__c.Version__c FROM Application_Versions__r ORDER BY SM_Application_Versions__c.Version__c DESC) FROM SM_Logical_Host__c"
			})

			It("returns properly constructed soql query", func() {
				Expect(err).ToNot(HaveOccurred())
				Expect(actualQuery).To(Equal(expectedQuery))
			})
		})

		Context("when a struct with order by clause in top level struct and child relation is passed", func() {
			BeforeEach(func() {
				col1 := Order{Field: "Version", IsDesc: true}
				col2 := Order{Field: "ID", IsDesc: true}
				col3 := Order{Field: "Name", IsDesc: false}
				soqlStruct = TestSoqlChildRelationOrderByStruct{
					SelectClause: OrderByParentStruct{
						ChildStruct: TestChildWithOrderByStruct{
							OrderByClause: []Order{col1},
						},
					},
					OrderByClause: []Order{col2, col3},
				}
				expectedQuery = "SELECT Id,Name__c,(SELECT SM_Application_Versions__c.Version__c FROM Application_Versions__r ORDER BY SM_Application_Versions__c.Version__c DESC) FROM SM_Logical_Host__c ORDER BY Id DESC,Name__c ASC"
			})

			It("returns properly constructed soql query", func() {
				Expect(err).ToNot(HaveOccurred())
				Expect(actualQuery).To(Equal(expectedQuery))
			})
		})

		Context("when a struct with limit value greater than 0 is passed", func() {
			BeforeEach(func() {
				input := 5
				soqlStruct = TestSoqlLimitStruct{
					SelectClause: NestedStruct{},
					WhereClause: TestQueryCriteria{
						IncludeNamePattern: []string{"-db", "-dbmgmt"},
						Roles:              []string{"db", "dbmgmt"},
					},
					Limit: &input,
				}
				expectedQuery = "SELECT Id,Name__c,NonNestedStruct__r.Name,NonNestedStruct__r.SomeValue__c FROM SM_Logical_Host__c WHERE (Host_Name__c LIKE '%-db%' OR Host_Name__c LIKE '%-dbmgmt%') AND Role__r.Name IN ('db','dbmgmt') LIMIT 5"
			})

			It("returns properly constructed soql query", func() {
				Expect(err).ToNot(HaveOccurred())
				Expect(actualQuery).To(Equal(expectedQuery))
			})
		})

		Context("when a struct with limit value equal to 0 is passed", func() {
			BeforeEach(func() {
				input := 0
				soqlStruct = TestSoqlLimitStruct{
					SelectClause: NestedStruct{},
					WhereClause: TestQueryCriteria{
						IncludeNamePattern: []string{"-db", "-dbmgmt"},
						Roles:              []string{"db", "dbmgmt"},
					},
					Limit: &input,
				}
				expectedQuery = "SELECT Id,Name__c,NonNestedStruct__r.Name,NonNestedStruct__r.SomeValue__c FROM SM_Logical_Host__c WHERE (Host_Name__c LIKE '%-db%' OR Host_Name__c LIKE '%-dbmgmt%') AND Role__r.Name IN ('db','dbmgmt') LIMIT 0"
			})

			It("returns properly constructed soql query", func() {
				Expect(err).ToNot(HaveOccurred())
				Expect(actualQuery).To(Equal(expectedQuery))
			})
		})

		Context("when a struct without limit value is passed", func() {
			BeforeEach(func() {
				soqlStruct = TestSoqlLimitStruct{
					SelectClause: NestedStruct{},
					WhereClause: TestQueryCriteria{
						IncludeNamePattern: []string{"-db", "-dbmgmt"},
						Roles:              []string{"db", "dbmgmt"},
					},
				}
				expectedQuery = "SELECT Id,Name__c,NonNestedStruct__r.Name,NonNestedStruct__r.SomeValue__c FROM SM_Logical_Host__c WHERE (Host_Name__c LIKE '%-db%' OR Host_Name__c LIKE '%-dbmgmt%') AND Role__r.Name IN ('db','dbmgmt')"
			})

			It("returns properly constructed soql query", func() {
				Expect(err).ToNot(HaveOccurred())
				Expect(actualQuery).To(Equal(expectedQuery))
			})
		})

		Context("when a struct with invalid limit type is passed", func() {
			BeforeEach(func() {
				soqlStruct = TestSoqlInvalidLimitStruct{
					SelectClause: NestedStruct{},
					WhereClause: TestQueryCriteria{
						IncludeNamePattern: []string{"-db", "-dbmgmt"},
						Roles:              []string{"db", "dbmgmt"},
					},
					Limit: "5",
				}
			})

			It("returns error", func() {
				Expect(err).To(Equal(ErrInvalidLimitClause))
			})
		})

		Context("when a struct with invalid limit value is passed", func() {
			BeforeEach(func() {
				input := -5
				soqlStruct = TestSoqlLimitStruct{
					SelectClause: NestedStruct{},
					WhereClause: TestQueryCriteria{
						IncludeNamePattern: []string{"-db", "-dbmgmt"},
						Roles:              []string{"db", "dbmgmt"},
					},
					Limit: &input,
				}
			})

			It("returns error", func() {
				Expect(err).To(Equal(ErrInvalidLimitClause))
			})
		})

		Context("when a struct with multiple limit values is passed", func() {
			BeforeEach(func() {
				input := 5
				soqlStruct = TestSoqlMultipleLimitStruct{
					SelectClause: NestedStruct{},
					WhereClause: TestQueryCriteria{
						IncludeNamePattern: []string{"-db", "-dbmgmt"},
						Roles:              []string{"db", "dbmgmt"},
					},
					Limit:     &input,
					AlsoLimit: &input,
				}
			})

			It("returns error", func() {
				Expect(err).To(Equal(ErrMultipleLimitClause))
			})
		})

		Context("when a struct with limit inside a child relation is passed", func() {
			BeforeEach(func() {
				input := 1
				soqlStruct = TestSoqlChildRelationLimitStruct{
					SelectClause: ParentLimitStruct{
						ChildStruct: ChildLimitStruct{
							Limit: &input,
						},
					},
				}
				expectedQuery = "SELECT Id,Name__c,(SELECT Application_Versions__c.Id,Application_Versions__c.Version__c FROM Application_Versions__r LIMIT 1) FROM SM_Logical_Host__c"
			})

			It("returns properly constructed soql query", func() {
				Expect(err).ToNot(HaveOccurred())
				Expect(actualQuery).To(Equal(expectedQuery))
			})
		})

		Context("when a struct with limit inside a child relation is passed", func() {
			BeforeEach(func() {
				inputChild := 10
				inputParent := 25
				soqlStruct = TestSoqlChildRelationLimitStruct{
					SelectClause: ParentLimitStruct{
						ChildStruct: ChildLimitStruct{
							Limit: &inputChild,
						},
					},
					Limit: &inputParent,
				}
				expectedQuery = "SELECT Id,Name__c,(SELECT Application_Versions__c.Id,Application_Versions__c.Version__c FROM Application_Versions__r LIMIT 10) FROM SM_Logical_Host__c LIMIT 25"
			})

			It("returns properly constructed soql query", func() {
				Expect(err).ToNot(HaveOccurred())
				Expect(actualQuery).To(Equal(expectedQuery))
			})
		})

		Context("when a struct with offset value is passed", func() {
			BeforeEach(func() {
				input := 5
				soqlStruct = TestSoqlOffsetStruct{
					SelectClause: NestedStruct{},
					WhereClause: TestQueryCriteria{
						IncludeNamePattern: []string{"-db", "-dbmgmt"},
						Roles:              []string{"db", "dbmgmt"},
					},
					Offset: &input,
				}
				expectedQuery = "SELECT Id,Name__c,NonNestedStruct__r.Name,NonNestedStruct__r.SomeValue__c FROM SM_Logical_Host__c WHERE (Host_Name__c LIKE '%-db%' OR Host_Name__c LIKE '%-dbmgmt%') AND Role__r.Name IN ('db','dbmgmt') OFFSET 5"
			})

			It("returns properly constructed soql query", func() {
				Expect(err).ToNot(HaveOccurred())
				Expect(actualQuery).To(Equal(expectedQuery))
			})
		})

		Context("when a struct without offset value is passed", func() {
			BeforeEach(func() {
				soqlStruct = TestSoqlOffsetStruct{
					SelectClause: NestedStruct{},
					WhereClause: TestQueryCriteria{
						IncludeNamePattern: []string{"-db", "-dbmgmt"},
						Roles:              []string{"db", "dbmgmt"},
					},
				}
				expectedQuery = "SELECT Id,Name__c,NonNestedStruct__r.Name,NonNestedStruct__r.SomeValue__c FROM SM_Logical_Host__c WHERE (Host_Name__c LIKE '%-db%' OR Host_Name__c LIKE '%-dbmgmt%') AND Role__r.Name IN ('db','dbmgmt')"
			})

			It("returns properly constructed soql query", func() {
				Expect(err).ToNot(HaveOccurred())
				Expect(actualQuery).To(Equal(expectedQuery))
			})
		})

		Context("when a struct with offset value of 0 is passed", func() {
			BeforeEach(func() {
				input := 0
				soqlStruct = TestSoqlOffsetStruct{
					SelectClause: NestedStruct{},
					WhereClause: TestQueryCriteria{
						IncludeNamePattern: []string{"-db", "-dbmgmt"},
						Roles:              []string{"db", "dbmgmt"},
					},
					Offset: &input,
				}
				expectedQuery = "SELECT Id,Name__c,NonNestedStruct__r.Name,NonNestedStruct__r.SomeValue__c FROM SM_Logical_Host__c WHERE (Host_Name__c LIKE '%-db%' OR Host_Name__c LIKE '%-dbmgmt%') AND Role__r.Name IN ('db','dbmgmt') OFFSET 0"
			})

			It("returns properly constructed soql query", func() {
				Expect(err).ToNot(HaveOccurred())
				Expect(actualQuery).To(Equal(expectedQuery))
			})
		})

		Context("when a struct with invalid offset type is passed", func() {
			BeforeEach(func() {
				soqlStruct = TestSoqlInvalidOffsetStruct{
					SelectClause: NestedStruct{},
					WhereClause: TestQueryCriteria{
						IncludeNamePattern: []string{"-db", "-dbmgmt"},
						Roles:              []string{"db", "dbmgmt"},
					},
					Offset: "5",
				}
			})

			It("returns error", func() {
				Expect(err).To(Equal(ErrInvalidOffsetClause))
			})
		})

		Context("when a struct with invalid offset value is passed", func() {
			BeforeEach(func() {
				input := -5
				soqlStruct = TestSoqlOffsetStruct{
					SelectClause: NestedStruct{},
					WhereClause: TestQueryCriteria{
						IncludeNamePattern: []string{"-db", "-dbmgmt"},
						Roles:              []string{"db", "dbmgmt"},
					},
					Offset: &input,
				}
			})

			It("returns error", func() {
				Expect(err).To(Equal(ErrInvalidOffsetClause))
			})
		})

		Context("when a struct with multiple offset values is passed", func() {
			BeforeEach(func() {
				input := 5
				soqlStruct = TestSoqlMultipleOffsetStruct{
					SelectClause: NestedStruct{},
					WhereClause: TestQueryCriteria{
						IncludeNamePattern: []string{"-db", "-dbmgmt"},
						Roles:              []string{"db", "dbmgmt"},
					},
					Offset:     &input,
					AlsoOffset: &input,
				}
			})

			It("returns error", func() {
				Expect(err).To(Equal(ErrMultipleOffsetClause))
			})
		})

		Context("when a struct with offset value and limit value is passed", func() {
			BeforeEach(func() {
				inputLimit := 15
				inputOffset := 5
				soqlStruct = TestSoqlLimitAndOffsetStruct{
					SelectClause: NestedStruct{},
					WhereClause: TestQueryCriteria{
						IncludeNamePattern: []string{"-db", "-dbmgmt"},
						Roles:              []string{"db", "dbmgmt"},
					},
					Limit:  &inputLimit,
					Offset: &inputOffset,
				}
				expectedQuery = "SELECT Id,Name__c,NonNestedStruct__r.Name,NonNestedStruct__r.SomeValue__c FROM SM_Logical_Host__c WHERE (Host_Name__c LIKE '%-db%' OR Host_Name__c LIKE '%-dbmgmt%') AND Role__r.Name IN ('db','dbmgmt') LIMIT 15 OFFSET 5"
			})

			It("returns properly constructed soql query", func() {
				Expect(err).ToNot(HaveOccurred())
				Expect(actualQuery).To(Equal(expectedQuery))
			})
		})

		Context("when a struct with where clause with joiner=OR passed", func() {
			BeforeEach(func() {
				soqlStruct = orSOQLQuery{
					WhereClause: positionOrDeptCriteria{
						Title:      "Purchasing Manager",
						Department: "Accounting",
					},
				}
				expectedQuery = "SELECT Name,Email,Phone FROM Contact WHERE Title = 'Purchasing Manager' OR Department = 'Accounting'"
			})

			It("returns properly constructed soql query", func() {
				Expect(err).ToNot(HaveOccurred())
				Expect(actualQuery).To(Equal(expectedQuery))
			})
		})

		Context("when a struct with where clause with joiner=or passed", func() {
			BeforeEach(func() {
				soqlStruct = orLowerSOQLQuery{
					WhereClause: positionOrDeptCriteria{
						Title:      "Purchasing Manager",
						Department: "Accounting",
					},
				}
				expectedQuery = "SELECT Name,Email,Phone FROM Contact WHERE Title = 'Purchasing Manager' OR Department = 'Accounting'"
			})

			It("returns properly constructed soql query", func() {
				Expect(err).ToNot(HaveOccurred())
				Expect(actualQuery).To(Equal(expectedQuery))
			})
		})

		Context("when a struct with where clause with joiner=AND passed", func() {
			BeforeEach(func() {
				soqlStruct = andSOQLQuery{
					WhereClause: positionOrDeptCriteria{
						Title:      "Purchasing Manager",
						Department: "Accounting",
					},
				}
				expectedQuery = "SELECT Name,Email,Phone FROM Contact WHERE Title = 'Purchasing Manager' AND Department = 'Accounting'"
			})

			It("returns properly constructed soql query", func() {
				Expect(err).ToNot(HaveOccurred())
				Expect(actualQuery).To(Equal(expectedQuery))
			})
		})

		Context("when a struct with where clause with joiner=ELSE (an invalid value) passed", func() {
			BeforeEach(func() {
				soqlStruct = invalidJoinerSOQLQuery{
					WhereClause: positionOrDeptCriteria{
						Title:      "Purchasing Manager",
						Department: "Accounting",
					},
				}
			})

			It("returns error", func() {
				Expect(err).To(Equal(ErrInvalidTag))
			})
		})

		Context("when a struct with where clause without a joiner passed", func() {
			BeforeEach(func() {
				soqlStruct = noJoinerSOQLQuery{
					WhereClause: positionOrDeptCriteria{
						Title:      "Purchasing Manager",
						Department: "Accounting",
					},
				}
				expectedQuery = "SELECT Name,Email,Phone FROM Contact WHERE Title = 'Purchasing Manager' AND Department = 'Accounting'"
			})

			It("returns properly constructed soql query", func() {
				Expect(err).ToNot(HaveOccurred())
				Expect(actualQuery).To(Equal(expectedQuery))
			})
		})

		Context("when a struct with where clause with invalid subfilters passed in", func() {
			BeforeEach(func() {
				soqlStruct = soqlSubQueryInvalidTypeTestStruct{
					WhereClause: invalidSubqueryCriteria{
						Position: "Purchasing Manager",
						Contactable: contactableCriteria{
							EmailOK: emailCheck{
								Email:         false,
								EmailOptedOut: false,
							},
							PhoneOK: phoneCheck{
								Phone:     false,
								DoNotCall: false,
							},
						},
					},
				}
				expectedQuery = "SELECT Name,Email,Phone FROM Contact WHERE (Title = 'Purchasing Manager' OR (Department = 'Accounting' AND Title LIKE '%Manager%')) AND ((Email != null AND HasOptedOutOfEmail = false) OR (Phone != null AND DoNotCall = false))"
			})

			It("returns error", func() {
				Expect(err).To(Equal(ErrInvalidTag))
			})
		})

		Context("when a struct with null pointer subquery passed in", func() {
			BeforeEach(func() {
				soqlStruct = soqlSubQueryPtrTestStruct{
					WhereClause: ptrSubqueryCriteria{
						Contactable: &contactableCriteria{
							EmailOK: emailCheck{
								Email:         false,
								EmailOptedOut: false,
							},
							PhoneOK: phoneCheck{
								Phone:     false,
								DoNotCall: false,
							},
						},
					},
				}
				expectedQuery = "SELECT Name,Email,Phone FROM Contact WHERE ((Email != null AND HasOptedOutOfEmail = false) OR (Phone != null AND DoNotCall = false))"
			})

			It("returns properly constructed soql query", func() {
				Expect(err).ToNot(HaveOccurred())
				Expect(actualQuery).To(Equal(expectedQuery))
			})
		})

		Context("when a struct with where clause with subfilters passed in", func() {
			BeforeEach(func() {
				soqlStruct = soqlSubQueryTestStruct{
					WhereClause: queryCriteria{
						Position: positionCriteria{
							Title: "Purchasing Manager",
							DepartmentManager: deptManagerCriteria{
								Department: "Accounting",
								Title:      []string{"Manager"},
							},
						},
						Contactable: contactableCriteria{
							EmailOK: emailCheck{
								Email:         false,
								EmailOptedOut: false,
							},
							PhoneOK: phoneCheck{
								Phone:     false,
								DoNotCall: false,
							},
						},
					},
				}
				expectedQuery = "SELECT Name,Email,Phone FROM Contact WHERE (Title = 'Purchasing Manager' OR (Department = 'Accounting' AND Title LIKE '%Manager%')) AND ((Email != null AND HasOptedOutOfEmail = false) OR (Phone != null AND DoNotCall = false))"
			})

			It("returns properly constructed soql query", func() {
				Expect(err).ToNot(HaveOccurred())
				Expect(actualQuery).To(Equal(expectedQuery))
			})
		})
		Context("when a struct with where clause with subquery and joiner=not in passed", func() {
			BeforeEach(func() {
				soqlStruct = soqlSubQueryInTestStruct{
					WhereClause: inSubqueryCriteria{
						Type: "Client",
						NotInFraudTable: &soqlFraudStruct{
							WhereClause: fraudCriteria{
								IsFraud: true,
							},
						},
						Country: "US",
					},
				}
				expectedQuery = "SELECT Name,Email,Phone FROM Contact WHERE Type = 'Client' AND Name NOT IN (SELECT Name,Email,Phone FROM Fraud WHERE isFraud = true) AND Country = 'US'"
			})

			It("returns properly constructed soql query", func() {
				Expect(err).ToNot(HaveOccurred())
				Expect(actualQuery).To(Equal(expectedQuery))
			})
		})
		Context("when a struct with where clause with subquery and joiner=in passed", func() {
			BeforeEach(func() {
				soqlStruct = soqlSubQueryInTestStruct{
					WhereClause: inSubqueryCriteria{
						Type: "Client",
						InFraudTable: &soqlFraudStruct{
							WhereClause: fraudCriteria{
								IsFraud: true,
							},
						},
						Country: "US",
					},
				}
				expectedQuery = "SELECT Name,Email,Phone FROM Contact WHERE Type = 'Client' AND Name IN (SELECT Name,Email,Phone FROM Fraud WHERE isFraud = true) AND Country = 'US'"
			})

			It("returns properly constructed soql query", func() {
				Expect(err).ToNot(HaveOccurred())
				Expect(actualQuery).To(Equal(expectedQuery))
			})
		})
		Context("when a struct with where clause with subquery and joiner=in and without fieldName passed", func() {
			BeforeEach(func() {
				soqlStruct = soqlSubQueryInTestStruct{
					WhereClause: inSubqueryCriteria{
						Type: "Client",
						InFraudTableWithoutFieldName: &soqlFraudStruct{
							WhereClause: fraudCriteria{
								IsFraud: true,
							},
						},
					},
				}
			})

			It("returns ErrInvalidTag", func() {
				Expect(err).To(Equal(ErrInvalidTag))
			})
		})
	})
})