Class: KnjDB_mysql::Tables::Table

Inherits:
Object
  • Object
show all
Defined in:
lib/knj/knjdb/drivers/mysql/knjdb_mysql_tables.rb

Instance Attribute Summary collapse

Class Method Summary collapse

Instance Method Summary collapse

Constructor Details

#initialize(args) ⇒ Table

Returns a new instance of Table.



108
109
110
111
112
113
114
115
116
117
 
# File 'lib/knj/knjdb/drivers/mysql/knjdb_mysql_tables.rb', line 108

def initialize(args)
  @args = args
  @db = args[:db]
  @data = args[:data]
  @subtype = @db.opts[:subtype]
  @list = Wref_map.new
  @indexes_list = Wref_map.new
  
  raise "Could not figure out name from: '#{@data}'." if @data[:Name].to_s.strip.length <= 0
end

Instance Attribute Details

#list ⇒ Object (readonly)

Returns the value of attribute list.



106
107
108
 
# File 'lib/knj/knjdb/drivers/mysql/knjdb_mysql_tables.rb', line 106

def list
  @list
end

Class Method Details

.create_indexes(index_arr, args = {}) ⇒ Object 



259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
 
# File 'lib/knj/knjdb/drivers/mysql/knjdb_mysql_tables.rb', line 259

def self.create_indexes(index_arr, args = {})
  db = args[:db]
  
  if args[:return_sql]
    sql = ""
    first = true
  end
  
  index_arr.each do |index_data|
    if !args[:return_sql]
      sql = ""
    end
    
    if args[:create] or !args.key?(:create)
      sql << "CREATE"
    end
    
    if index_data.is_a?(String)
      index_data = {"name" => index_data, "columns" => [index_data]}
    end
    
    raise "No name was given." if !index_data.key?("name") or index_data["name"].strip.length <= 0
    raise "No columns was given on index: '#{index_data["name"]}'." if !index_data["columns"] or index_data["columns"].empty?
    
    if args[:return_sql]
      if first
        first = false
      else
        sql << ", "
      end
    end
    
    sql << " UNIQUE" if index_data["unique"]
    sql << " INDEX `#{db.esc_col(index_data["name"])}`"
    
    if args[:on_table] or !args.key?(:on_table)
      sql << " ON `#{db.esc_table(args[:table_name])}`"
    end
    
    sql << " ("
    
    first = true
    index_data["columns"].each do |col_name|
      sql << ", " if !first
      first = false if first
      
      sql << "`#{db.esc_col(col_name)}`"
    end
    
    sql << ")"
    
    if !args[:return_sql]
      db.query(sql)
    end
  end
  
  if args[:return_sql]
    return sql
  else
    return nil
  end
end

Instance Method Details

#__object_unique_id__ ⇒ Object

Used to validate in Knj::Wrap_map.



124
125
126
 
# File 'lib/knj/knjdb/drivers/mysql/knjdb_mysql_tables.rb', line 124

def __object_unique_id__
  return @data[:Name]
end

#column(name) ⇒ Object

Raises:

  • (Errno::ENOENT) 


152
153
154
155
156
157
158
159
160
161
162
163
164
 
# File 'lib/knj/knjdb/drivers/mysql/knjdb_mysql_tables.rb', line 152

def column(name)
  name = name.to_s
  
  if col = @list.get!(name)
    return @list[name]
  end
  
  self.columns(:name => name) do |col|
    return col if col.name == name
  end
  
  raise Errno::ENOENT, "Column not found: '#{name}'."
end

#columns(args = nil) ⇒ Object 



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
 
# File 'lib/knj/knjdb/drivers/mysql/knjdb_mysql_tables.rb', line 166

def columns(args = nil)
  @db.cols
  ret = {}
  sql = "SHOW FULL COLUMNS FROM `#{self.name}`"
  sql << " WHERE `Field` = '#{@db.esc(args[:name])}'" if args and args.key?(:name)
  
  @db.q(sql) do |d_cols|
    obj = @list.get!(d_cols[:Field].to_s)
    
    if !obj
      obj = KnjDB_mysql::Columns::Column.new(
        :table_name => self.name,
        :db => @db,
        :data => d_cols
      )
      @list[d_cols[:Field].to_s] = obj
    end
    
    if block_given?
      yield(obj)
    else
      ret[d_cols[:Field].to_s] = obj
    end
  end
  
  if block_given?
    return nil
  else
    return ret
  end
end

#create_columns(col_arr) ⇒ Object 



248
249
250
251
252
253
 
# File 'lib/knj/knjdb/drivers/mysql/knjdb_mysql_tables.rb', line 248

def create_columns(col_arr)
  col_arr.each do |col_data|
    sql = "ALTER TABLE `#{self.name}` ADD COLUMN #{@db.cols.data_sql(col_data)};"
    @db.query(sql)
  end
end

#create_indexes(index_arr, args = {}) ⇒ Object 



255
256
257
 
# File 'lib/knj/knjdb/drivers/mysql/knjdb_mysql_tables.rb', line 255

def create_indexes(index_arr, args = {})
  return KnjDB_mysql::Tables::Table.create_indexes(index_arr, args.merge(:table_name => self.name, :db => @db))
end

#data ⇒ Object 



335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
 
# File 'lib/knj/knjdb/drivers/mysql/knjdb_mysql_tables.rb', line 335

def data
  ret = {
    "name" => self.name,
    "columns" => [],
    "indexes" => []
  }
  
  columns.each do |name, column|
    ret["columns"] << column.data
  end
  
  indexes.each do |name, index|
    ret["indexes"] << index.data if name != "PRIMARY"
  end
  
  return ret
end

#drop ⇒ Object 



132
133
134
135
 
# File 'lib/knj/knjdb/drivers/mysql/knjdb_mysql_tables.rb', line 132

def drop
  raise "Cant drop native table: '#{self.name}'." if self.native?
  @db.query("DROP TABLE `#{self.name}`")
end

#index(name) ⇒ Object

Raises:

  • (Errno::ENOENT) 


234
235
236
237
238
239
240
241
242
243
244
245
246
 
# File 'lib/knj/knjdb/drivers/mysql/knjdb_mysql_tables.rb', line 234

def index(name)
  name = name.to_s
  
  if index = @indexes_list.get!(name)
    return index
  end
  
  self.indexes(:name => name) do |index|
    return index if index.name.to_s == name
  end
  
  raise Errno::ENOENT, "Index not found: #{name}."
end

#indexes(args = nil) ⇒ Object 



198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
 
# File 'lib/knj/knjdb/drivers/mysql/knjdb_mysql_tables.rb', line 198

def indexes(args = nil)
  @db.indexes
  ret = {}
  
  sql = "SHOW INDEX FROM `#{self.name}`"
  sql << " WHERE `Key_name` = '#{@db.esc(args[:name])}'" if args and args.key?(:name)
  
  @db.q(sql) do |d_indexes|
    next if d_indexes[:Key_name] == "PRIMARY"
    
    obj = @indexes_list.get!(d_indexes[:Key_name].to_s)
    
    if !obj
      obj = KnjDB_mysql::Indexes::Index.new(
        :table_name => self.name,
        :db => @db,
        :data => d_indexes
      )
      obj.columns << d_indexes[:Column_name]
      @indexes_list[d_indexes[:Key_name].to_s] = obj
    end
    
    if block_given?
      yield(obj)
    else
      ret[d_indexes[:Key_name].to_s] = obj
    end
  end
  
  if block_given?
    return nil
  else
    return ret
  end
end

#insert(data) ⇒ Object 



353
354
355
 
# File 'lib/knj/knjdb/drivers/mysql/knjdb_mysql_tables.rb', line 353

def insert(data)
  @db.insert(self.name, data)
end

#name ⇒ Object 



128
129
130
 
# File 'lib/knj/knjdb/drivers/mysql/knjdb_mysql_tables.rb', line 128

def name
  return @data[:Name]
end

#native? ⇒ Boolean

Returns true if the table is safe to drop.

Returns:

  • (Boolean) 


138
139
140
141
 
# File 'lib/knj/knjdb/drivers/mysql/knjdb_mysql_tables.rb', line 138

def native?
  return true if @db.q("SELECT DATABASE() AS db").fetch[:db] == "mysql"
  return false
end

#optimize ⇒ Object 



143
144
145
146
 
# File 'lib/knj/knjdb/drivers/mysql/knjdb_mysql_tables.rb', line 143

def optimize
  @db.query("OPTIMIZE TABLE `#{self.name}`")
  return self
end

#reload ⇒ Object 



119
120
121
 
# File 'lib/knj/knjdb/drivers/mysql/knjdb_mysql_tables.rb', line 119

def reload
  @data = @db.q("SHOW TABLE STATUS WHERE `Name` = '#{@db.esc(self.name)}'").fetch
end

#rename(newname) ⇒ Object 



322
323
324
325
326
327
328
 
# File 'lib/knj/knjdb/drivers/mysql/knjdb_mysql_tables.rb', line 322

def rename(newname)
  oldname = self.name
  @db.query("ALTER TABLE `#{oldname}` RENAME TO `#{newname}`")
  @db.tables.list[newname] = self
  @db.tables.list.delete(oldname)
  @data[:Name] = newname
end

#rows_count ⇒ Object 



148
149
150
 
# File 'lib/knj/knjdb/drivers/mysql/knjdb_mysql_tables.rb', line 148

def rows_count
  return @data[:Rows].to_i
end

#truncate ⇒ Object 



330
331
332
333
 
# File 'lib/knj/knjdb/drivers/mysql/knjdb_mysql_tables.rb', line 330

def truncate
  @db.query("TRUNCATE `#{self.name}`")
  return self
end