Class: Tina4::ORM
Class Method Summary collapse
- .all(limit: nil, offset: nil, order_by: nil, include: nil) ⇒ Object
-
.auto_crud ⇒ Object
auto_crud flag — when set to true, the class registers itself with Tina4::AutoCrud which auto-generates REST endpoints from the model.
- .auto_crud=(val) ⇒ Object
-
.auto_map ⇒ Object
Auto-map flag — defaults to TRUE for cross-framework parity (Python’s ORM has auto_map=True by default).
- .auto_map=(val) ⇒ Object
-
.belongs_to(name, class_name: nil, foreign_key: nil) ⇒ Object
belongs_to :user, class_name: “User”, foreign_key: “user_id”.
-
.clear_rel_cache ⇒ Object
Clear the relationship cache on all loaded instances (class-level helper).
- .count(conditions = nil, params = []) ⇒ Object
- .create(attributes = {}) ⇒ Object
- .create_table ⇒ Object
- .db ⇒ Object
-
.db=(database) ⇒ Object
Per-model database binding.
-
.eager_load(instances, include_list) ⇒ Object
Eager load relationships for a collection of instances (prevents N+1).
-
.field_mapping ⇒ Object
Field mapping: { ‘db_column’ => ‘ruby_attribute’ }.
- .field_mapping=(map) ⇒ Object
- .find(id_or_filter = nil, filter = nil, **kwargs) ⇒ Object
-
.find_by_id(id) ⇒ Object
find_by_id is PUBLIC — cross-framework parity with Python’s MyModel.find_by_id(pk_value) and PHP’s User::find($id).
- .find_or_fail(id) ⇒ Object
- .from_hash(hash) ⇒ Object
-
.get_db ⇒ Object
Return the database connection used by this model.
-
.get_db_column(property) ⇒ Object
Map a Ruby property name to its database column name using field_mapping.
-
.has_many(name, class_name: nil, foreign_key: nil) ⇒ Object
has_many :posts, class_name: “Post”, foreign_key: “user_id”.
-
.has_one(name, class_name: nil, foreign_key: nil) ⇒ Object
has_one :profile, class_name: “Profile”, foreign_key: “user_id”.
-
.query ⇒ Tina4::QueryBuilder
Create a fluent QueryBuilder pre-configured for this model’s table and database.
-
.relationship_definitions ⇒ Object
Relationship definitions.
- .scope(name, filter_sql, params = []) ⇒ Object
- .select(sql, params = [], limit: nil, offset: nil, include: nil) ⇒ Object
- .select_one(sql, params = [], include: nil) ⇒ Object
-
.soft_delete ⇒ Object
Soft delete configuration.
- .soft_delete=(val) ⇒ Object
- .soft_delete_field ⇒ Object
- .soft_delete_field=(val) ⇒ Object
- .where(conditions, params = [], include: nil) ⇒ Object
- .with_trashed(conditions = "1=1", params = [], limit: 20, offset: 0) ⇒ Object
Instance Method Summary collapse
- #delete ⇒ Object
- #errors ⇒ Object
- #force_delete ⇒ Object
-
#initialize(attributes = {}) ⇒ ORM
constructor
A new instance of ORM.
-
#load(arg = nil, params = nil) ⇒ Object
load — populate this instance from the database.
- #persisted? ⇒ Boolean
- #restore ⇒ Object
- #save ⇒ Object
- #select(*fields) ⇒ Object
- #to_array ⇒ Object (also: #to_list)
-
#to_h(include: nil, case: nil) ⇒ Object
(also: #to_hash, #to_dict, #to_object)
Convert to hash using Ruby attribute names.
- #to_json(include: nil, **_args) ⇒ Object
- #to_s ⇒ Object
- #validate ⇒ Object
Methods included from FieldTypes
Constructor Details
#initialize(attributes = {}) ⇒ ORM
Returns a new instance of ORM.
432 433 434 435 436 437 438 439 440 441 442 443 444 445 446 447 448 449 450 451 452 453 454 |
# File 'lib/tina4/orm.rb', line 432 def initialize(attributes = {}) @persisted = false @errors = [] @relationship_cache = {} attributes.each do |key, value| setter = "#{key}=" __send__(setter, value) if respond_to?(setter) end # Set defaults. # v3.13.11 (issue #50.1): when the default is a Proc/lambda # (``default: -> { Time.now }``), call it per-instance so # per-row timestamps actually differ. Class objects are # excluded — ``default: Integer`` is almost never intended # to mean ``Integer.new`` (and Integer has no zero-arg # constructor anyway). self.class.field_definitions.each do |name, opts| if __send__(name).nil? && opts[:default] d = opts[:default] d = d.call if d.respond_to?(:call) && !d.is_a?(Class) __send__("#{name}=", d) end end end |
Class Method Details
.all(limit: nil, offset: nil, order_by: nil, include: nil) ⇒ Object
252 253 254 255 256 257 258 259 260 261 262 |
# File 'lib/tina4/orm.rb', line 252 def all(limit: nil, offset: nil, order_by: nil, include: nil) sql = "SELECT * FROM #{table_name}" if soft_delete sql += " WHERE #{soft_delete_field} IS NULL OR #{soft_delete_field} = 0" end sql += " ORDER BY #{order_by}" if order_by results = db.fetch(sql, [], limit: limit, offset: offset) instances = results.map { |row| from_hash(row) } eager_load(instances, include) if include instances end |
.auto_crud ⇒ Object
auto_crud flag — when set to true, the class registers itself with Tina4::AutoCrud which auto-generates REST endpoints from the model. Defaults to false. Cross-framework parity with Python’s autoCrud.
73 74 75 |
# File 'lib/tina4/orm.rb', line 73 def auto_crud defined?(@auto_crud) && !@auto_crud.nil? ? @auto_crud : false end |
.auto_crud=(val) ⇒ Object
77 78 79 80 81 82 |
# File 'lib/tina4/orm.rb', line 77 def auto_crud=(val) @auto_crud = val if val && defined?(::Tina4::AutoCrud) ::Tina4::AutoCrud.models << self unless ::Tina4::AutoCrud.models.include?(self) end end |
.auto_map ⇒ Object
Auto-map flag — defaults to TRUE for cross-framework parity (Python’s ORM has auto_map=True by default). The instance variable is treated as “unset” when nil; only an explicit ‘false` disables it.
62 63 64 |
# File 'lib/tina4/orm.rb', line 62 def auto_map defined?(@auto_map) && !@auto_map.nil? ? @auto_map : true end |
.auto_map=(val) ⇒ Object
66 67 68 |
# File 'lib/tina4/orm.rb', line 66 def auto_map=(val) @auto_map = val end |
.belongs_to(name, class_name: nil, foreign_key: nil) ⇒ Object
belongs_to :user, class_name: “User”, foreign_key: “user_id”
116 117 118 119 120 121 122 123 124 125 126 |
# File 'lib/tina4/orm.rb', line 116 def belongs_to(name, class_name: nil, foreign_key: nil) relationship_definitions[name] = { type: :belongs_to, class_name: class_name || name.to_s.split("_").map(&:capitalize).join, foreign_key: foreign_key || "#{name}_id" } define_method(name) do load_belongs_to(name) end end |
.clear_rel_cache ⇒ Object
Clear the relationship cache on all loaded instances (class-level helper). Useful after bulk operations when you want to force relationship re-loads.
395 396 397 398 |
# File 'lib/tina4/orm.rb', line 395 def clear_rel_cache # -> nil @_rel_cache = {} nil end |
.count(conditions = nil, params = []) ⇒ Object
276 277 278 279 280 281 282 283 284 285 286 |
# File 'lib/tina4/orm.rb', line 276 def count(conditions = nil, params = []) sql = "SELECT COUNT(*) as cnt FROM #{table_name}" where_parts = [] if soft_delete where_parts << "(#{soft_delete_field} IS NULL OR #{soft_delete_field} = 0)" end where_parts << "(#{conditions})" if conditions sql += " WHERE #{where_parts.join(' AND ')}" unless where_parts.empty? result = db.fetch_one(sql, params) result[:cnt].to_i end |
.create(attributes = {}) ⇒ Object
288 289 290 291 292 |
# File 'lib/tina4/orm.rb', line 288 def create(attributes = {}) instance = new(attributes) instance.save instance end |
.create_table ⇒ Object
306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322 323 324 325 326 327 328 329 330 331 332 333 334 335 336 337 338 339 340 341 342 343 344 345 346 347 348 349 350 351 352 353 354 355 356 357 358 359 |
# File 'lib/tina4/orm.rb', line 306 def create_table return true if db.table_exists?(table_name) # v3.13.11 (BooleanField parity): pick each engine's native # bool type where it's reliable. SQLite has no native bool; # Firebird's driver round-trip for native BOOLEAN is uneven — # both stay on INTEGER. PG/MySQL/MSSQL use their native types # so Python ``True``/Ruby ``true`` bind cleanly without # ``operator does not exist: boolean = integer`` errors. engine = (db.respond_to?(:get_database_type) ? db.get_database_type : "").to_s.downcase bool_sql = case engine when "postgres", "postgresql" then "BOOLEAN" when "mysql" then "BOOLEAN" # alias for TINYINT(1) when "mssql", "sqlserver" then "BIT" else "INTEGER" # sqlite, firebird, odbc, anything else end type_map = { integer: "INTEGER", string: "VARCHAR(255)", text: "TEXT", float: "REAL", decimal: "REAL", boolean: bool_sql, date: "DATE", datetime: "DATETIME", timestamp: "TIMESTAMP", blob: "BLOB", json: "TEXT" } col_defs = [] field_definitions.each do |name, opts| sql_type = type_map[opts[:type]] || "TEXT" if opts[:type] == :string && opts[:length] sql_type = "VARCHAR(#{opts[:length]})" end parts = ["#{name} #{sql_type}"] parts << "PRIMARY KEY" if opts[:primary_key] parts << "AUTOINCREMENT" if opts[:auto_increment] parts << "NOT NULL" if !opts[:nullable] && !opts[:primary_key] if opts[:default] && !opts[:auto_increment] default_val = opts[:default].is_a?(String) ? "'#{opts[:default]}'" : opts[:default] parts << "DEFAULT #{default_val}" end col_defs << parts.join(" ") end sql = "CREATE TABLE IF NOT EXISTS #{table_name} (#{col_defs.join(', ')})" db.execute(sql) db.commit true end |
.db ⇒ Object
20 21 22 23 24 25 26 |
# File 'lib/tina4/orm.rb', line 20 def db # v3.13.12: implicit binding from TINA4_DATABASE_URL. # Resolution: per-class @db → global Tina4.database → env-derived # auto-discovery. Pre-v3.13.12 this fell through to nil — the # helper auto_discover_db existed but was never called. @db || Tina4.database || auto_discover_db end |
.db=(database) ⇒ Object
Per-model database binding
29 30 31 |
# File 'lib/tina4/orm.rb', line 29 def db=(database) @db = database end |
.eager_load(instances, include_list) ⇒ Object
Eager load relationships for a collection of instances (prevents N+1). include is an array of relationship names, supporting dot notation for nesting.
163 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 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 |
# File 'lib/tina4/orm.rb', line 163 def eager_load(instances, include_list) return if instances.nil? || instances.empty? # Group includes: top-level and nested top_level = {} include_list.each do |inc| parts = inc.to_s.split(".", 2) rel_name = parts[0].to_sym top_level[rel_name] ||= [] top_level[rel_name] << parts[1] if parts.length > 1 end top_level.each do |rel_name, nested| rel = relationship_definitions[rel_name] next unless rel klass = Object.const_get(rel[:class_name]) pk = primary_key_field || :id case rel[:type] when :has_one, :has_many fk = rel[:foreign_key] || "#{name.split('::').last.downcase}_id" pk_values = instances.map { |inst| inst.__send__(pk) }.compact.uniq next if pk_values.empty? placeholders = pk_values.map { "?" }.join(",") sql = "SELECT * FROM #{klass.table_name} WHERE #{fk} IN (#{placeholders})" results = klass.db.fetch(sql, pk_values) = results.map { |row| klass.from_hash(row) } # Eager load nested klass.eager_load(, nested) unless nested.empty? # Group by FK grouped = {} .each do |record| fk_val = record.__send__(fk.to_sym) if record.respond_to?(fk.to_sym) (grouped[fk_val] ||= []) << record end instances.each do |inst| pk_val = inst.__send__(pk) records = grouped[pk_val] || [] if rel[:type] == :has_one inst.instance_variable_get(:@relationship_cache)[rel_name] = records.first else inst.instance_variable_get(:@relationship_cache)[rel_name] = records end end when :belongs_to fk = rel[:foreign_key] || "#{rel_name}_id" fk_values = instances.map { |inst| inst.respond_to?(fk.to_sym) ? inst.__send__(fk.to_sym) : nil }.compact.uniq next if fk_values.empty? = klass.primary_key_field || :id placeholders = fk_values.map { "?" }.join(",") sql = "SELECT * FROM #{klass.table_name} WHERE #{} IN (#{placeholders})" results = klass.db.fetch(sql, fk_values) = results.map { |row| klass.from_hash(row) } klass.eager_load(, nested) unless nested.empty? lookup = {} .each { |r| lookup[r.__send__()] = r } instances.each do |inst| fk_val = inst.respond_to?(fk.to_sym) ? inst.__send__(fk.to_sym) : nil inst.instance_variable_get(:@relationship_cache)[rel_name] = lookup[fk_val] end end end end |
.field_mapping ⇒ Object
Field mapping: { ‘db_column’ => ‘ruby_attribute’ }
51 52 53 |
# File 'lib/tina4/orm.rb', line 51 def field_mapping @field_mapping || {} end |
.field_mapping=(map) ⇒ Object
55 56 57 |
# File 'lib/tina4/orm.rb', line 55 def field_mapping=(map) @field_mapping = map end |
.find(id_or_filter = nil, filter = nil, **kwargs) ⇒ Object
138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 |
# File 'lib/tina4/orm.rb', line 138 def find(id_or_filter = nil, filter = nil, **kwargs) include_list = kwargs.delete(:include) # find(id) — find by primary key # find(filter_hash) — find by criteria # find(name: "Alice") — keyword args as filter hash result = if id_or_filter.is_a?(Hash) find_by_filter(id_or_filter) elsif filter.is_a?(Hash) find_by_filter(filter) elsif !kwargs.empty? find_by_filter(kwargs) else find_by_id(id_or_filter) end if include_list && result instances = result.is_a?(Array) ? result : [result] eager_load(instances, include_list) end result end |
.find_by_id(id) ⇒ Object
find_by_id is PUBLIC — cross-framework parity with Python’s MyModel.find_by_id(pk_value) and PHP’s User::find($id). Spec at spec/orm_spec.rb:78 verifies public access. find_by_filter stays public for the same reason; both are part of the documented API.
384 385 386 387 388 389 390 391 |
# File 'lib/tina4/orm.rb', line 384 def find_by_id(id) pk = primary_key_field || :id sql = "SELECT * FROM #{table_name} WHERE #{pk} = ?" if soft_delete sql += " AND (#{soft_delete_field} IS NULL OR #{soft_delete_field} = 0)" end select_one(sql, [id]) end |
.find_or_fail(id) ⇒ Object
294 295 296 297 298 |
# File 'lib/tina4/orm.rb', line 294 def find_or_fail(id) result = find(id) raise "#{name} with #{primary_key_field || :id}=#{id} not found" if result.nil? result end |
.from_hash(hash) ⇒ Object
367 368 369 370 371 372 373 374 375 376 377 378 |
# File 'lib/tina4/orm.rb', line 367 def from_hash(hash) instance = new mapping_reverse = field_mapping.invert hash.each do |key, value| # Apply field mapping (db_col => ruby_attr) attr_name = mapping_reverse[key.to_s] || key setter = "#{attr_name}=" instance.__send__(setter, value) if instance.respond_to?(setter) end instance.instance_variable_set(:@persisted, true) instance end |
.get_db ⇒ Object
Return the database connection used by this model.
401 402 403 |
# File 'lib/tina4/orm.rb', line 401 def get_db # -> Database db end |
.get_db_column(property) ⇒ Object
Map a Ruby property name to its database column name using field_mapping. Returns the column name as a symbol.
407 408 409 410 |
# File 'lib/tina4/orm.rb', line 407 def get_db_column(property) # -> Symbol col = field_mapping[property.to_s] || property col.to_sym end |
.has_many(name, class_name: nil, foreign_key: nil) ⇒ Object
has_many :posts, class_name: “Post”, foreign_key: “user_id”
103 104 105 106 107 108 109 110 111 112 113 |
# File 'lib/tina4/orm.rb', line 103 def has_many(name, class_name: nil, foreign_key: nil) relationship_definitions[name] = { type: :has_many, class_name: class_name || name.to_s.sub(/s$/, "").split("_").map(&:capitalize).join, foreign_key: foreign_key } define_method(name) do load_has_many(name) end end |
.has_one(name, class_name: nil, foreign_key: nil) ⇒ Object
has_one :profile, class_name: “Profile”, foreign_key: “user_id”
90 91 92 93 94 95 96 97 98 99 100 |
# File 'lib/tina4/orm.rb', line 90 def has_one(name, class_name: nil, foreign_key: nil) relationship_definitions[name] = { type: :has_one, class_name: class_name || name.to_s.split("_").map(&:capitalize).join, foreign_key: foreign_key } define_method(name) do load_has_one(name) end end |
.query ⇒ Tina4::QueryBuilder
Create a fluent QueryBuilder pre-configured for this model’s table and database.
Usage:
results = User.query.where("active = ?", [1]).order_by("name").get
134 135 136 |
# File 'lib/tina4/orm.rb', line 134 def query QueryBuilder.from(table_name, db: db) end |
.relationship_definitions ⇒ Object
Relationship definitions
85 86 87 |
# File 'lib/tina4/orm.rb', line 85 def relationship_definitions @relationship_definitions ||= {} end |
.scope(name, filter_sql, params = []) ⇒ Object
361 362 363 364 365 |
# File 'lib/tina4/orm.rb', line 361 def scope(name, filter_sql, params = []) define_singleton_method(name) do |limit: 20, offset: 0| where(filter_sql, params) end end |
.select(sql, params = [], limit: nil, offset: nil, include: nil) ⇒ Object
264 265 266 267 268 269 |
# File 'lib/tina4/orm.rb', line 264 def select(sql, params = [], limit: nil, offset: nil, include: nil) results = db.fetch(sql, params, limit: limit, offset: offset) instances = results.map { |row| from_hash(row) } eager_load(instances, include) if include instances end |
.select_one(sql, params = [], include: nil) ⇒ Object
271 272 273 274 |
# File 'lib/tina4/orm.rb', line 271 def select_one(sql, params = [], include: nil) results = select(sql, params, limit: 1, include: include) results.first end |
.soft_delete ⇒ Object
Soft delete configuration
34 35 36 |
# File 'lib/tina4/orm.rb', line 34 def soft_delete @soft_delete || false end |
.soft_delete=(val) ⇒ Object
38 39 40 |
# File 'lib/tina4/orm.rb', line 38 def soft_delete=(val) @soft_delete = val end |
.soft_delete_field ⇒ Object
42 43 44 |
# File 'lib/tina4/orm.rb', line 42 def soft_delete_field @soft_delete_field || :is_deleted end |
.soft_delete_field=(val) ⇒ Object
46 47 48 |
# File 'lib/tina4/orm.rb', line 46 def soft_delete_field=(val) @soft_delete_field = val end |
.where(conditions, params = [], include: nil) ⇒ Object
239 240 241 242 243 244 245 246 247 248 249 250 |
# File 'lib/tina4/orm.rb', line 239 def where(conditions, params = [], include: nil) sql = "SELECT * FROM #{table_name}" if soft_delete sql += " WHERE (#{soft_delete_field} IS NULL OR #{soft_delete_field} = 0) AND (#{conditions})" else sql += " WHERE #{conditions}" end results = db.fetch(sql, params) instances = results.map { |row| from_hash(row) } eager_load(instances, include) if include instances end |
.with_trashed(conditions = "1=1", params = [], limit: 20, offset: 0) ⇒ Object
300 301 302 303 304 |
# File 'lib/tina4/orm.rb', line 300 def with_trashed(conditions = "1=1", params = [], limit: 20, offset: 0) sql = "SELECT * FROM #{table_name} WHERE #{conditions}" results = db.fetch(sql, params, limit: limit, offset: offset) results.map { |row| from_hash(row) } end |
Instance Method Details
#delete ⇒ Object
488 489 490 491 492 493 494 495 496 497 498 499 500 501 502 503 504 505 506 |
# File 'lib/tina4/orm.rb', line 488 def delete pk = self.class.primary_key_field || :id pk_value = __send__(pk) return false unless pk_value self.class.db.transaction do |db| if self.class.soft_delete db.update( self.class.table_name, { self.class.soft_delete_field => 1 }, { pk => pk_value } ) else db.delete(self.class.table_name, { pk => pk_value }) end end @persisted = false true end |
#errors ⇒ Object
589 590 591 |
# File 'lib/tina4/orm.rb', line 589 def errors @errors end |
#force_delete ⇒ Object
508 509 510 511 512 513 514 515 516 517 518 |
# File 'lib/tina4/orm.rb', line 508 def force_delete pk = self.class.primary_key_field || :id pk_value = __send__(pk) raise "Cannot delete: no primary key value" unless pk_value self.class.db.transaction do |db| db.delete(self.class.table_name, { pk => pk_value }) end @persisted = false true end |
#load(arg = nil, params = nil) ⇒ Object
load — populate this instance from the database.
Three forms (parity with Python’s model.load(sql, params, include)):
user.load # reload by primary key from instance
user.load(123) # load by primary key value
user.load("email = ?", ["a@b.c"]) # load by filter SQL + params (selectOne)
Returns true on hit, false on miss. Always clears the relationship cache.
557 558 559 560 561 562 563 564 565 566 567 568 569 570 571 572 573 574 575 576 577 578 579 580 581 582 583 |
# File 'lib/tina4/orm.rb', line 557 def load(arg = nil, params = nil) @relationship_cache = {} # Clear relationship cache on reload pk = self.class.primary_key_field || :id if arg.is_a?(String) # Filter-SQL form: user.load("email = ?", ["a@b.c"]) sql = "SELECT * FROM #{self.class.table_name} WHERE #{arg} LIMIT 1" result = self.class.db.fetch_one(sql, params || []) else # Primary-key form: user.load OR user.load(123) id = arg || __send__(pk) return false unless id result = self.class.db.fetch_one( "SELECT * FROM #{self.class.table_name} WHERE #{pk} = ?", [id] ) end return false unless result mapping_reverse = self.class.field_mapping.invert result.each do |key, value| attr_name = mapping_reverse[key.to_s] || key setter = "#{attr_name}=" __send__(setter, value) if respond_to?(setter) end @persisted = true true end |
#persisted? ⇒ Boolean
585 586 587 |
# File 'lib/tina4/orm.rb', line 585 def persisted? @persisted end |
#restore ⇒ Object
520 521 522 523 524 525 526 527 528 529 530 531 532 533 534 535 536 |
# File 'lib/tina4/orm.rb', line 520 def restore raise "Model does not support soft delete" unless self.class.soft_delete pk = self.class.primary_key_field || :id pk_value = __send__(pk) raise "Cannot restore: no primary key value" unless pk_value self.class.db.transaction do |db| db.update( self.class.table_name, { self.class.soft_delete_field => 0 }, { pk => pk_value } ) end __send__("#{self.class.soft_delete_field}=", 0) if respond_to?("#{self.class.soft_delete_field}=") true end |
#save ⇒ Object
456 457 458 459 460 461 462 463 464 465 466 467 468 469 470 471 472 473 474 475 476 477 478 479 480 481 482 483 484 485 486 |
# File 'lib/tina4/orm.rb', line 456 def save @errors = [] @relationship_cache = {} # Clear relationship cache on save validate_fields return false unless @errors.empty? data = to_db_hash(exclude_nil: true) pk = self.class.primary_key_field || :id pk_value = __send__(pk) self.class.db.transaction do |db| if @persisted && pk_value filter = { pk => pk_value } data.delete(pk) # Remove mapped primary key too mapped_pk = self.class.field_mapping[pk.to_s] data.delete(mapped_pk.to_sym) if mapped_pk db.update(self.class.table_name, data, filter) else result = db.insert(self.class.table_name, data) if result[:last_id] && respond_to?("#{pk}=") __send__("#{pk}=", result[:last_id]) end @persisted = true end end true rescue => e @errors << e. false end |
#select(*fields) ⇒ Object
657 658 659 660 661 662 |
# File 'lib/tina4/orm.rb', line 657 def select(*fields) fields_str = fields.map(&:to_s).join(", ") pk = self.class.primary_key_field || :id pk_value = __send__(pk) self.class.db.fetch_one("SELECT #{fields_str} FROM #{self.class.table_name} WHERE #{pk} = ?", [pk_value]) end |
#to_array ⇒ Object Also known as: to_list
643 644 645 |
# File 'lib/tina4/orm.rb', line 643 def to_array to_h.values end |
#to_h(include: nil, case: nil) ⇒ Object Also known as: to_hash, to_dict, to_object
Convert to hash using Ruby attribute names. Optionally include relationships via the include keyword. case: “camel” converts snake_case keys to camelCase (parity with Python’s to_dict(case=‘camel’)). Default keeps native snake_case.
597 598 599 600 601 602 603 604 605 606 607 608 609 610 611 612 613 614 615 616 617 618 619 620 621 622 623 624 625 626 627 628 629 630 631 632 633 634 635 636 637 |
# File 'lib/tina4/orm.rb', line 597 def to_h(include: nil, case: nil) key_case = binding.local_variable_get(:case) # :case is a reserved word hash = {} self.class.field_definitions.each_key do |name| hash[name] = __send__(name) end if include # Group includes: top-level and nested top_level = {} include.each do |inc| parts = inc.to_s.split(".", 2) rel_name = parts[0].to_sym top_level[rel_name] ||= [] top_level[rel_name] << parts[1] if parts.length > 1 end top_level.each do |rel_name, nested| next unless self.class.relationship_definitions.key?(rel_name) = __send__(rel_name) if .nil? hash[rel_name] = nil elsif .is_a?(Array) hash[rel_name] = .map { |r| r.to_h(include: nested.empty? ? nil : nested) } else hash[rel_name] = .to_h(include: nested.empty? ? nil : nested) end end end if key_case == "camel" || key_case == :camel # snake_case → camelCase: split on _, capitalize all but the first hash = hash.each_with_object({}) do |(k, v), out| parts = k.to_s.split("_") camel = parts[0] + parts[1..].map(&:capitalize).join out[camel.to_sym] = v end end hash end |
#to_json(include: nil, **_args) ⇒ Object
649 650 651 |
# File 'lib/tina4/orm.rb', line 649 def to_json(include: nil, **_args) JSON.generate(to_h(include: include)) end |
#to_s ⇒ Object
653 654 655 |
# File 'lib/tina4/orm.rb', line 653 def to_s "#<#{self.class.name} #{to_h}>" end |
#validate ⇒ Object
538 539 540 541 542 543 544 545 546 547 |
# File 'lib/tina4/orm.rb', line 538 def validate errors = [] self.class.field_definitions.each do |name, opts| value = __send__(name) if !opts[:nullable] && value.nil? && !opts[:auto_increment] && !opts[:default] errors << "#{name} cannot be null" end end errors end |