Class: QuickBase::EventNotifier::RecordCondition
- Inherits:
-
Object
- Object
- QuickBase::EventNotifier::RecordCondition
- Defined in:
- lib/QuickBaseEventNotifier.rb
Overview
In addition to a basic record add/modify/delete events, check these conditions before sending a notification.
Instance Method Summary collapse
-
#initialize(fieldName, logicalOperator, fieldValue) ⇒ RecordCondition
constructor
fieldName: field to test, e.g.
- #validate(qbc, dbid) ⇒ Object
Constructor Details
#initialize(fieldName, logicalOperator, fieldValue) ⇒ RecordCondition
fieldName: field to test, e.g. “Date” logicalOperator: kind of test, e.g. “OAF” fieldValue: value to test for, e.g. “12/31/2006”
47 48 49 |
# File 'lib/QuickBaseEventNotifier.rb', line 47 def initialize(fieldName,logicalOperator,fieldValue) @fieldName,@logicalOperator,@fieldValue=fieldName,logicalOperator,fieldValue end |
Instance Method Details
#validate(qbc, dbid) ⇒ Object
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 |
# File 'lib/QuickBaseEventNotifier.rb', line 51 def validate(qbc,dbid) if qbc.lookupFieldIDByName(@fieldName) fieldType = qbc.lookupFieldTypeByName(@fieldName) if fieldType queryOperator = qbc.verifyQueryOperator(@logicalOperator,fieldType) if queryOperator.nil? or queryOperator.length == 0 raise "Invalid query operator '#{@logicalOperator}' for field '#{@fieldName}' in table #{dbid}" else if @fieldValue.length > 0 #any field can be blanked out case fieldType when "checkbox" if !(@fieldValue == "1" or @fieldValue == "0") raise "Invalid data '#{@fieldValue}' for checkbox field #{@fieldName}" end when "date" fieldValue.gsub!("/","-") if !fieldValue.match(/[0-9][0-9]\-[0-9][0-9]\-[0-9][0-9][0-9][0-9]/) raise "Invalid data '#{@fieldValue}' for date field #{@fieldName}" end when "duration", "float", "currency", "rating" fieldValue.gsub!(",","") if !fieldValue.match(/[0-9]*\.?[0-9]*/) raise "Invalid data '#{@fieldValue}' for field #{@fieldName}" end when "phone" if !fieldValue.match(/[0-9|\.|x]+/) raise "Invalid data '#{@fieldValue}' for phone field #{@fieldName}" end when "file" if FileTest.exist?(fieldValue) @fieldIsValidFileAttachment = true else raise "Invalid file name '#{@fieldValue}' for file attachment field #{@fieldName}" end end end end else raise "Unable to validate field type for field '#{@fieldName}' in table #{dbid}" end else raise "Unable to validate field '#{@fieldName}' in table #{dbid}" end true end |