Class: SqlStmtLib::MysqlChecker

Inherits:
Object
  • Object
show all
Defined in:
lib/sqlstmt/mysql/check.rb

Instance Method Summary collapse

Constructor Details

#initialize(data) ⇒ MysqlChecker

Returns a new instance of MysqlChecker.



7
8
9
 
# File 'lib/sqlstmt/mysql/check.rb', line 7

def initialize(data)
  @data = data
end

Instance Method Details

#run ⇒ Object 



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
 
# File 'lib/sqlstmt/mysql/check.rb', line 11

def run
  if !@data.stmt_type
    raise SqlStmtError, "unable to build sql - must call :select, :update, :insert or :delete to specify statement type"
  end
  if @data.tables.empty?
    raise SqlStmtError, "unable to build sql - must call :table"
  end

  if (@data.where_behavior == :require) && @data.wheres.empty?
    raise SqlStmtError, "unable to build sql - must call :where, :no_where, or :optional_where"
  elsif (@data.where_behavior == :exclude) && !@data.wheres.empty?
    raise SqlStmtError, "unable to build sql - :where and :no_where must not both be called, consider :optional_where instead"
  end

  if @data.stmt_type == 'select'
    raise SqlStmtError, "unable to build sql - must call :get" if @data.fields.empty?
    raise SqlStmtError, "unable to build sql - must not call :set" if !@data.values.empty?
  else
    raise SqlStmtError, "unable to build sql - must not call :get" if @data.called_get
  end

  if ['update','insert'].include?(@data.stmt_type)
    raise SqlStmtError, "unable to build sql - must call :set or :setq" if @data.values.empty?
    raise SqlStmtError, "unable to build sql - must not call :get" if @data.called_get
  end

  if @data.stmt_type == 'insert'
    raise SqlStmtError, "unable to build sql - must call :into" if @data.into_table.nil?
  end

  if @data.stmt_type == 'delete'
    raise SqlStmtError, "unable to build sql - must not call :get or :set" if !@data.fields.empty?
    if @data.tables_to_delete.empty? && ((@data.tables.size + @data.joins.size) > 1)
      raise SqlStmtError, "unable to build sql - must specify tables to delete when including multiple tables"
    end
  end
end