Class: KnjDB_sqlite3::Tables::Table
- Defined in:
- lib/knj/knjdb/drivers/sqlite3/knjdb_sqlite3_tables.rb
Instance Method Summary collapse
- #clone(newname) ⇒ Object
- #column(name) ⇒ Object
- #columns ⇒ Object
- #copy(args = {}) ⇒ Object
- #create_column_programmatic(col_data) ⇒ Object
- #create_columns(col_arr) ⇒ Object
- #create_indexes(index_arr) ⇒ Object
- #data ⇒ Object
- #drop ⇒ Object
- #index(name) ⇒ Object
- #indexes ⇒ Object
-
#initialize(args) ⇒ Table
constructor
A new instance of Table.
- #name ⇒ Object
- #optimize ⇒ Object
Constructor Details
#initialize(args) ⇒ Table
Returns a new instance of Table.
53 54 55 56 57 |
# File 'lib/knj/knjdb/drivers/sqlite3/knjdb_sqlite3_tables.rb', line 53 def initialize(args) @db = args[:db] @driver = args[:driver] @data = args[:data] end |
Instance Method Details
#clone(newname) ⇒ Object
144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 |
# File 'lib/knj/knjdb/drivers/sqlite3/knjdb_sqlite3_tables.rb', line 144 def clone(newname) raise "Invalid name." if newname.to_s.strip.length <= 0 cols_cur = self.columns sql = "CREATE TABLE `#{newname}` (" first = true cols_cur.each do |name, col| sql << ", " if !first first = false if first sql << @db.cols.data_sql(col.data) end sql << ");" @db.query(sql) sql = "INSERT INTO `#{newname}` SELECT * FROM `#{self.name}`" @db.query(sql) return @db.tables[newname] end |
#column(name) ⇒ Object
72 73 74 75 76 |
# File 'lib/knj/knjdb/drivers/sqlite3/knjdb_sqlite3_tables.rb', line 72 def column(name) list = self.columns return list[name] if list[name] raise Knj::Errors::NotFound.new("Column not found: #{name}.") end |
#columns ⇒ Object
78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 |
# File 'lib/knj/knjdb/drivers/sqlite3/knjdb_sqlite3_tables.rb', line 78 def columns if !@list @db.cols @list = {} q_cols = @db.query("PRAGMA table_info(`#{@driver.esc_table(self.name)}`)") while d_cols = q_cols.fetch @list[d_cols[:name]] = KnjDB_sqlite3::Columns::Column.new( :table => self, :db => @db, :driver => @driver, :data => d_cols ) end end return @list end |
#copy(args = {}) ⇒ Object
164 165 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 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 |
# File 'lib/knj/knjdb/drivers/sqlite3/knjdb_sqlite3_tables.rb', line 164 def copy(args = {}) temp_name = "temptable_#{Time.now.to_f.to_s.hash}" cloned_tabled = self.clone(temp_name) cols_cur = self.columns @db.query("DROP TABLE `#{self.name}`") sql = "CREATE TABLE `#{self.name}` (" first = true cols_cur.each do |name, col| next if args["drops"] and args["drops"].index(name) != nil sql << ", " if !first first = false if first if args.key?("alter_columns") and args["alter_columns"][name.to_s] sql << @db.cols.data_sql(args["alter_columns"][name.to_s]) else sql << @db.cols.data_sql(col.data) end if args["new"] args["new"].each do |col_data| if col_data["after"] and col_data["after"] == name sql << ", #{@db.cols.data_sql(col_data)}" end end end end sql << ");" @db.query(sql) sql = "INSERT INTO `#{self.name}` SELECT " first = true cols_cur.each do |name, col| next if args["drops"] and args["drops"].index(name) != nil sql << ", " if !first first = false if first sql << "`#{name}`" if args["news"] args["news"].each do |col_data| if col_data["after"] and col_data["after"] == name sql << ", ''" end end end end sql << " FROM `#{temp_name}`" @db.query(sql) @db.query("DROP TABLE `#{temp_name}`") end |
#create_column_programmatic(col_data) ⇒ Object
107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 |
# File 'lib/knj/knjdb/drivers/sqlite3/knjdb_sqlite3_tables.rb', line 107 def create_column_programmatic(col_data) temp_name = "temptable_#{Time.now.to_f.to_s.hash}" cloned_tabled = self.clone(temp_name) cols_cur = self.columns @db.query("DROP TABLE `#{self.name}`") sql = "CREATE TABLE `#{self.name}` (" first = true cols_cur.each do |name, col| sql << ", " if !first first = false if first sql << @db.cols.data_sql(col.data) if col_data["after"] and col_data["after"] == name sql << ", #{@db.cols.data_sql(col_data)}" end end sql << ");" @db.query(sql) sql = "INSERT INTO `#{self.name}` SELECT " first = true cols_cur.each do |name, col| sql << ", " if !first first = false if first sql << "`#{name}`" if col_data["after"] and col_data["after"] == name sql << ", ''" end end sql << " FROM `#{temp_name}`" @db.query(sql) @db.query("DROP TABLE `#{temp_name}`") end |
#create_columns(col_arr) ⇒ Object
97 98 99 100 101 102 103 104 105 |
# File 'lib/knj/knjdb/drivers/sqlite3/knjdb_sqlite3_tables.rb', line 97 def create_columns(col_arr) col_arr.each do |col_data| #if col_data.key?("after") # self.create_column_programmatic(col_data) #else @db.query("ALTER TABLE `#{self.name}` ADD COLUMN #{@db.cols.data_sql(col_data)};") #end end end |
#create_indexes(index_arr) ⇒ Object
258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 281 |
# File 'lib/knj/knjdb/drivers/sqlite3/knjdb_sqlite3_tables.rb', line 258 def create_indexes(index_arr) index_arr.each do |index_data| 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"].empty? name = index_data["name"] name = "#{self.name}__#{name}" if @db.opts[:index_append_table_name] sql = "CREATE INDEX #{@db.escape_col}#{@db.esc_col(name)}#{@db.escape_col} ON #{@db.escape_table}#{@db.esc_table(self.name)}#{@db.escape_table} (" first = true index_data["columns"].each do |col_name| sql << ", " if !first first = false if first sql << "#{@db.escape_col}#{@db.esc_col(col_name)}#{@db.escape_col}" end sql << ")" @db.query(sql) @indexes_list = nil end end |
#data ⇒ Object
283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 298 299 |
# File 'lib/knj/knjdb/drivers/sqlite3/knjdb_sqlite3_tables.rb', line 283 def data ret = { "name" => 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
63 64 65 66 |
# File 'lib/knj/knjdb/drivers/sqlite3/knjdb_sqlite3_tables.rb', line 63 def drop sql = "DROP TABLE `#{self.name}`" @db.query(sql) end |
#index(name) ⇒ Object
219 220 221 222 223 |
# File 'lib/knj/knjdb/drivers/sqlite3/knjdb_sqlite3_tables.rb', line 219 def index(name) list = self.indexes return list[name] if list[name] raise Knj::Errors::NotFound.new("Index not found: #{name}.") end |
#indexes ⇒ Object
225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 |
# File 'lib/knj/knjdb/drivers/sqlite3/knjdb_sqlite3_tables.rb', line 225 def indexes if !@indexes_list @db.indexes @indexes_list = {} q_indexes = @db.query("PRAGMA index_list(`#{@driver.esc_table(self.name)}`)") while d_indexes = q_indexes.fetch if @db.opts[:index_append_table_name] match_name = d_indexes[:name].match(/__(.+)$/) if match_name name = match_name[1] else name = d_indexes[:name] end else name = d_indexes[:name] end @indexes_list[name] = KnjDB_sqlite3::Indexes::Index.new( :table => self, :db => @db, :driver => @driver, :data => d_indexes ) @indexes_list[name].columns << name end end return @indexes_list end |
#name ⇒ Object
59 60 61 |
# File 'lib/knj/knjdb/drivers/sqlite3/knjdb_sqlite3_tables.rb', line 59 def name return @data[:name] end |
#optimize ⇒ Object
68 69 70 |
# File 'lib/knj/knjdb/drivers/sqlite3/knjdb_sqlite3_tables.rb', line 68 def optimize raise "stub!" end |