Class: Surfer::Support

Inherits:
Object
  • Object
show all
Defined in:
lib/surfer/support.rb

Instance Method Summary collapse

Instance Method Details

#create_field(argv) ⇒ Object

Parsing command line argument for table creating.



30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
 
# File 'lib/surfer/support.rb', line 30

def create_field argv
  i = 3
  str = ""
  str = " id    INTEGER   AUTO_INCREMENT   PRIMARY KEY, "
  begin
    att = argv[i] 
    str << att
    str << "   "
    i = i.to_i + 2
    att1 = get_data_type(argv[i])
    str << att1
    if i.to_i != argv.length.to_i-1
      str << ","
      str << "\n"
      i = i.to_i + 2
    else 
      return str
    end
  end while i < argv.length.to_i
end

#create_table(argv) ⇒ Object

Table creation query.



53
54
55
56
57
 
# File 'lib/surfer/support.rb', line 53

def create_table argv 
  query = "CREATE TABLE #{get_pluralize(argv[2])}( #{create_field(argv)} )"
  puts query
  return query
end

#generate_dindex(tab_name, argv) ⇒ Object

# Generating the index deletion command.



209
210
211
212
213
 
# File 'lib/surfer/support.rb', line 209

def generate_dindex tab_name,argv
  query = " ALTER TABLE #{tab_name} DROP INDEX #{argv[argv.keys[0]]} "
  puts query
  return query
end

#generate_index(tab_name, argv) ⇒ Object

Generating the index command.



202
203
204
205
206
 
# File 'lib/surfer/support.rb', line 202

def generate_index tab_name, argv
  query = " CREATE INDEX #{argv[argv.keys[0]]}  ON #{tab_name} (#{argv[argv.keys[1]]}) "
  puts query
  return query
end

#generate_insert(tab_name, argv) ⇒ Object

Parsing insert command attribute.



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/surfer/support.rb', line 61

def generate_insert tab_name, argv

      # Attribute of table.
  attribute = ""
  attribute << "id"
  i = 0
  argv.each do |k,v|
    if i == 0 and argv.length != 0
      attribute << ","
     end
    attribute << k
    i = i.to_i + 1
    if i != argv.length
      attribute << ","
    end
  end
      # Values of the Attributes.
  val = []
  val << "NULL"
  i = 0
  if argv.length != 0
    begin
      val << "\"#{argv[argv.keys[i]]}\""
      i = i.to_i + 1     
    end while i < argv.length.to_i  
  end    

  if argv.length == 0
    query = " INSERT INTO #{tab_name}(#{attribute}) VALUES (#{val * ""}) "
    return query
  else
    query = " INSERT INTO #{tab_name}(#{attribute}) VALUES (#{val * ","}) "
    return query
  end
end

#generate_remove(tab_name, argv) ⇒ Object

Parsing coditional parameter for delete command.



99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
 
# File 'lib/surfer/support.rb', line 99

def generate_remove tab_name, argv
  condition = ""
  condition << "( "
  i = 0
  begin
    if  "condition" != argv.keys[i] 
      condition << argv.keys[i] 
      condition << "="
      condition << "\"#{argv[argv.keys[i]]}\"" 
      condition << " "
      i = i.to_i + 1
    else
      condition << "\"#{argv[argv.keys[i]]}\"" 
      condition << " "
      i = i.to_i + 1
    end 
  end while i < argv.length
  condition << ")"
  query = " DELETE FROM #{tab_name} WHERE#{condition} "
  #puts query
  return query
end

#generate_update(tab_name, argv, cond_argv) ⇒ Object

Parsing attributes and values for update command.



124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
 
# File 'lib/surfer/support.rb', line 124

def generate_update tab_name, argv, cond_argv

# Parsing updatable attribute
  attribute = ""
  i = 0
  begin
    attribute << argv.keys[i]
    attribute << " = "
    attribute << "\"#{argv[argv.keys[i]]}\""
    i = i.to_i + 1
    if i != argv.length
      attribute << ","
    end
  end while i < argv.length


# Parsing conditional hashing argument. 
  condition = ""
  condition << "( "
  i = 0
  begin
    if "condition" != cond_argv.keys[i] 
      condition << cond_argv.keys[i] 
      condition << "="
      condition << "\"#{cond_argv[cond_argv.keys[i]]}\"" 
      condition << " "
      i = i.to_i + 1
    else
      condition << "\"#{cond_argv[cond_argv.keys[i]]}\"" 
      condition << " "
      i = i.to_i + 1
    end 
  end while i < cond_argv.length
  condition << ")"

  query = " UPDATE #{tab_name} SET #{attribute} WHERE #{condition} "
  puts query
  return query
end

#generate_where(tab_name, argv) ⇒ Object

Parsing attribute for where clouse.



166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
 
# File 'lib/surfer/support.rb', line 166

def generate_where tab_name, argv #, att_argv


      # Parsing conditional hashing argument.  
  condition = ""
  condition << "( "
  i = 0
  begin
    if "condition" != argv.keys[i] 
      condition << argv.keys[i] 
      condition << "="
      condition << "\"#{argv[argv.keys[i]]}\""
      condition << " "
      i = i.to_i + 1
    else
      condition << "\"#{argv[argv.keys[i]]}\""
      condition << " "
      i = i.to_i + 1
    end 
  end while i < argv.length
  condition << ")"


  #if att_argv.length == 0
    query = " SELECT * FROM #{tab_name} WHERE #{condition} "
    puts query
    return query
  #else
    #query = " SELECT #{att_argv * ","} FROM #{tab_name} WHERE #{condition} " 
    #puts query
    #return query
  #end
end

#get_data_type(key) ⇒ Object

Getting sql specific datatype.



15
16
17
18
19
20
21
22
23
24
25
26
 
# File 'lib/surfer/support.rb', line 15

def get_data_type key
  data_type = Hash.new 
  data_type["int"] = "INTEGER"
  data_type["mobile"] = "BIGINT(20)"
  data_type["string"] = "VARCHAR(50)"
  data_type["float"] = "INTEGER(20,5)" 
  data_type["integer"] = "INTEGER" 
  data_type["text"] = "TEXT" 
  data_type["date"] = "DATE" 
   
  tdata = data_type[key]
end

#get_pluralize(name) ⇒ Object

Plural method for pluralization purpose.



6
7
8
9
10
11
 
# File 'lib/surfer/support.rb', line 6

def get_pluralize name
  until name.empty? 
     str = name.downcase.concat('s')
    return str
  end
end