require "cases/helper" require "models/admin" require "models/admin/account" require "models/admin/randomly_named_c1" require "models/admin/user" require "models/binary" require "models/book" require "models/bulb" require "models/category" require "models/post" require "models/comment" require "models/company" require "models/computer" require "models/course" require "models/developer" require "models/dog" require "models/doubloon" require "models/joke" require "models/matey" require "models/other_dog" require "models/parrot" require "models/pirate" require "models/randomly_named_c1" require "models/reply" require "models/ship" require "models/task" require "models/topic" require "models/traffic_light" require "models/treasure" require "tempfile" class FixturesTest < ActiveRecord::TestCase self.use_instantiated_fixtures = true self.use_transactional_tests = false # other_topics fixture should not be included here fixtures :topics, :developers, :accounts, :tasks, :categories, :funny_jokes, :binaries, :traffic_lights FIXTURES = %w( accounts binaries companies customers developers developers_projects entrants movies projects subscribers topics tasks ) MATCH_ATTRIBUTE_NAME = /[a-zA-Z][-\w]*/ def test_clean_fixtures FIXTURES.each do |name| fixtures = nil assert_nothing_raised { fixtures = create_fixtures(name).first } assert_kind_of(ActiveRecord::FixtureSet, fixtures) fixtures.each { |_name, fixture| fixture.each { |key, value| assert_match(MATCH_ATTRIBUTE_NAME, key) } } end end def test_broken_yaml_exception badyaml = Tempfile.new ["foo", ".yml"] badyaml.write "a: : " badyaml.flush dir = File.dirname badyaml.path name = File.basename badyaml.path, ".yml" assert_raises(ActiveRecord::Fixture::FormatError) do ActiveRecord::FixtureSet.create_fixtures(dir, name) end ensure badyaml.close badyaml.unlink end def test_create_fixtures fixtures = ActiveRecord::FixtureSet.create_fixtures(FIXTURES_ROOT, "parrots") assert Parrot.find_by_name("Curious George"), "George is not in the database" assert fixtures.detect { |f| f.name == "parrots" }, "no fixtures named 'parrots' in #{fixtures.map(&:name).inspect}" end def test_multiple_clean_fixtures fixtures_array = nil assert_nothing_raised { fixtures_array = create_fixtures(*FIXTURES) } assert_kind_of(Array, fixtures_array) fixtures_array.each { |fixtures| assert_kind_of(ActiveRecord::FixtureSet, fixtures) } end def test_create_symbol_fixtures fixtures = ActiveRecord::FixtureSet.create_fixtures(FIXTURES_ROOT, :collections, collections: Course) { Course.connection } assert Course.find_by_name("Collection"), "course is not in the database" assert fixtures.detect { |f| f.name == "collections" }, "no fixtures named 'collections' in #{fixtures.map(&:name).inspect}" end def test_attributes topics = create_fixtures("topics").first assert_equal("The First Topic", topics["first"]["title"]) assert_nil(topics["second"]["author_email_address"]) end def test_inserts create_fixtures("topics") first_row = ActiveRecord::Base.connection.select_one("SELECT * FROM topics WHERE author_name = 'David'") assert_equal("The First Topic", first_row["title"]) second_row = ActiveRecord::Base.connection.select_one("SELECT * FROM topics WHERE author_name = 'Mary'") assert_nil(second_row["author_email_address"]) end def test_inserts_with_pre_and_suffix # Reset cache to make finds on the new table work ActiveRecord::FixtureSet.reset_cache ActiveRecord::Base.connection.create_table :prefix_other_topics_suffix do |t| t.column :title, :string t.column :author_name, :string t.column :author_email_address, :string t.column :written_on, :datetime t.column :bonus_time, :time t.column :last_read, :date t.column :content, :string t.column :approved, :boolean, default: true t.column :replies_count, :integer, default: 0 t.column :parent_id, :integer t.column :type, :string, limit: 50 end # Store existing prefix/suffix old_prefix = ActiveRecord::Base.table_name_prefix old_suffix = ActiveRecord::Base.table_name_suffix # Set a prefix/suffix we can test against ActiveRecord::Base.table_name_prefix = "prefix_" ActiveRecord::Base.table_name_suffix = "_suffix" other_topic_klass = Class.new(ActiveRecord::Base) do def self.name "OtherTopic" end end topics = [create_fixtures("other_topics")].flatten.first # This checks for a caching problem which causes a bug in the fixtures # class-level configuration helper. assert_not_nil topics, "Fixture data inserted, but fixture objects not returned from create" first_row = ActiveRecord::Base.connection.select_one("SELECT * FROM prefix_other_topics_suffix WHERE author_name = 'David'") assert_not_nil first_row, "The prefix_other_topics_suffix table appears to be empty despite create_fixtures: the row with author_name = 'David' was not found" assert_equal("The First Topic", first_row["title"]) second_row = ActiveRecord::Base.connection.select_one("SELECT * FROM prefix_other_topics_suffix WHERE author_name = 'Mary'") assert_nil(second_row["author_email_address"]) assert_equal :prefix_other_topics_suffix, topics.table_name.to_sym # This assertion should preferably be the last in the list, because calling # other_topic_klass.table_name sets a class-level instance variable assert_equal :prefix_other_topics_suffix, other_topic_klass.table_name.to_sym ensure # Restore prefix/suffix to its previous values ActiveRecord::Base.table_name_prefix = old_prefix ActiveRecord::Base.table_name_suffix = old_suffix ActiveRecord::Base.connection.drop_table :prefix_other_topics_suffix rescue nil end def test_insert_with_datetime create_fixtures("tasks") first = Task.find(1) assert first end def test_logger_level_invariant level = ActiveRecord::Base.logger.level create_fixtures("topics") assert_equal level, ActiveRecord::Base.logger.level end def test_instantiation topics = create_fixtures("topics").first assert_kind_of Topic, topics["first"].find end def test_complete_instantiation assert_equal "The First Topic", @first.title end def test_fixtures_from_root_yml_with_instantiation assert_equal 50, @unknown.credit_limit end def test_erb_in_fixtures assert_equal "fixture_5", @dev_5.name end def test_empty_yaml_fixture assert_not_nil ActiveRecord::FixtureSet.new(Account.connection, "accounts", Account, FIXTURES_ROOT + "/naked/yml/accounts") end def test_empty_yaml_fixture_with_a_comment_in_it assert_not_nil ActiveRecord::FixtureSet.new(Account.connection, "companies", Company, FIXTURES_ROOT + "/naked/yml/companies") end def test_nonexistent_fixture_file nonexistent_fixture_path = FIXTURES_ROOT + "/imnothere" #sanity check to make sure that this file never exists assert Dir[nonexistent_fixture_path + "*"].empty? assert_raise(Errno::ENOENT) do ActiveRecord::FixtureSet.new(Account.connection, "companies", Company, nonexistent_fixture_path) end end def test_dirty_dirty_yaml_file fixture_path = FIXTURES_ROOT + "/naked/yml/courses" error = assert_raise(ActiveRecord::Fixture::FormatError) do ActiveRecord::FixtureSet.new(Account.connection, "courses", Course, fixture_path) end assert_equal "fixture is not a hash: #{fixture_path}.yml", error.to_s end def test_yaml_file_with_one_invalid_fixture fixture_path = FIXTURES_ROOT + "/naked/yml/courses_with_invalid_key" error = assert_raise(ActiveRecord::Fixture::FormatError) do ActiveRecord::FixtureSet.new(Account.connection, "courses", Course, fixture_path) end assert_equal "fixture key is not a hash: #{fixture_path}.yml, keys: [\"two\"]", error.to_s end def test_yaml_file_with_invalid_column e = assert_raise(ActiveRecord::Fixture::FixtureError) do ActiveRecord::FixtureSet.create_fixtures(FIXTURES_ROOT + "/naked/yml", "parrots") end assert_equal(%(table "parrots" has no column named "arrr".), e.message) end def test_yaml_file_with_symbol_columns ActiveRecord::FixtureSet.create_fixtures(FIXTURES_ROOT + "/naked/yml", "trees") end def test_omap_fixtures assert_nothing_raised do fixtures = ActiveRecord::FixtureSet.new(Account.connection, "categories", Category, FIXTURES_ROOT + "/categories_ordered") fixtures.each.with_index do |(name, fixture), i| assert_equal "fixture_no_#{i}", name assert_equal "Category #{i}", fixture["name"] end end end def test_yml_file_in_subdirectory assert_equal(categories(:sub_special_1).name, "A special category in a subdir file") assert_equal(categories(:sub_special_1).class, SpecialCategory) end def test_subsubdir_file_with_arbitrary_name assert_equal(categories(:sub_special_3).name, "A special category in an arbitrarily named subsubdir file") assert_equal(categories(:sub_special_3).class, SpecialCategory) end def test_binary_in_fixtures data = File.open(ASSETS_ROOT + "/flowers.jpg", "rb") { |f| f.read } data.force_encoding("ASCII-8BIT") data.freeze assert_equal data, @flowers.data end def test_serialized_fixtures assert_equal ["Green", "Red", "Orange"], traffic_lights(:uk).state end def test_fixtures_are_set_up_with_database_env_variable db_url_tmp = ENV["DATABASE_URL"] ENV["DATABASE_URL"] = "sqlite3::memory:" ActiveRecord::Base.stub(:configurations, {}) do test_case = Class.new(ActiveRecord::TestCase) do fixtures :accounts def test_fixtures assert accounts(:signals37) end end result = test_case.new(:test_fixtures).run assert result.passed?, "Expected #{result.name} to pass:\n#{result}" end ensure ENV["DATABASE_URL"] = db_url_tmp end end class HasManyThroughFixture < ActiveRecord::TestCase def make_model(name) Class.new(ActiveRecord::Base) { define_singleton_method(:name) { name } } end def test_has_many_through_with_default_table_name pt = make_model "ParrotTreasure" parrot = make_model "Parrot" treasure = make_model "Treasure" pt.table_name = "parrots_treasures" pt.belongs_to :parrot, anonymous_class: parrot pt.belongs_to :treasure, anonymous_class: treasure parrot.has_many :parrot_treasures, anonymous_class: pt parrot.has_many :treasures, through: :parrot_treasures parrots = File.join FIXTURES_ROOT, "parrots" fs = ActiveRecord::FixtureSet.new parrot.connection, "parrots", parrot, parrots rows = fs.table_rows assert_equal load_has_and_belongs_to_many["parrots_treasures"], rows["parrots_treasures"] end def test_has_many_through_with_renamed_table pt = make_model "ParrotTreasure" parrot = make_model "Parrot" treasure = make_model "Treasure" pt.belongs_to :parrot, anonymous_class: parrot pt.belongs_to :treasure, anonymous_class: treasure parrot.has_many :parrot_treasures, anonymous_class: pt parrot.has_many :treasures, through: :parrot_treasures parrots = File.join FIXTURES_ROOT, "parrots" fs = ActiveRecord::FixtureSet.new parrot.connection, "parrots", parrot, parrots rows = fs.table_rows assert_equal load_has_and_belongs_to_many["parrots_treasures"], rows["parrot_treasures"] end def load_has_and_belongs_to_many parrot = make_model "Parrot" parrot.has_and_belongs_to_many :treasures parrots = File.join FIXTURES_ROOT, "parrots" fs = ActiveRecord::FixtureSet.new parrot.connection, "parrots", parrot, parrots fs.table_rows end end if Account.connection.respond_to?(:reset_pk_sequence!) class FixturesResetPkSequenceTest < ActiveRecord::TestCase fixtures :accounts fixtures :companies def setup @instances = [Account.new(credit_limit: 50), Company.new(name: "RoR Consulting"), Course.new(name: "Test")] ActiveRecord::FixtureSet.reset_cache # make sure tables get reinitialized end def test_resets_to_min_pk_with_specified_pk_and_sequence @instances.each do |instance| model = instance.class model.delete_all model.connection.reset_pk_sequence!(model.table_name, model.primary_key, model.sequence_name) instance.save! assert_equal 1, instance.id, "Sequence reset for #{model.table_name} failed." end end def test_resets_to_min_pk_with_default_pk_and_sequence @instances.each do |instance| model = instance.class model.delete_all model.connection.reset_pk_sequence!(model.table_name) instance.save! assert_equal 1, instance.id, "Sequence reset for #{model.table_name} failed." end end def test_create_fixtures_resets_sequences_when_not_cached @instances.each do |instance| max_id = create_fixtures(instance.class.table_name).first.fixtures.inject(0) do |_max_id, (_, fixture)| fixture_id = fixture["id"].to_i fixture_id > _max_id ? fixture_id : _max_id end # Clone the last fixture to check that it gets the next greatest id. instance.save! assert_equal max_id + 1, instance.id, "Sequence reset for #{instance.class.table_name} failed." end end end end class FixturesWithoutInstantiationTest < ActiveRecord::TestCase self.use_instantiated_fixtures = false fixtures :topics, :developers, :accounts def test_without_complete_instantiation assert !defined?(@first) assert !defined?(@topics) assert !defined?(@developers) assert !defined?(@accounts) end def test_fixtures_from_root_yml_without_instantiation assert !defined?(@unknown), "@unknown is not defined" end def test_visibility_of_accessor_method assert_equal false, respond_to?(:topics, false), "should be private method" assert_equal true, respond_to?(:topics, true), "confirm to respond surely" end def test_accessor_methods assert_equal "The First Topic", topics(:first).title assert_equal "Jamis", developers(:jamis).name assert_equal 50, accounts(:signals37).credit_limit end def test_accessor_methods_with_multiple_args assert_equal 2, topics(:first, :second).size assert_raise(StandardError) { topics([:first, :second]) } end def test_reloading_fixtures_through_accessor_methods topic = Struct.new(:title) assert_equal "The First Topic", topics(:first).title assert_called(@loaded_fixtures["topics"]["first"], :find, returns: topic.new("Fresh Topic!")) do assert_equal "Fresh Topic!", topics(:first, true).title end end end class FixturesWithoutInstanceInstantiationTest < ActiveRecord::TestCase self.use_instantiated_fixtures = true self.use_instantiated_fixtures = :no_instances fixtures :topics, :developers, :accounts def test_without_instance_instantiation assert !defined?(@first), "@first is not defined" end end class TransactionalFixturesTest < ActiveRecord::TestCase self.use_instantiated_fixtures = true self.use_transactional_tests = true fixtures :topics def test_destroy assert_not_nil @first @first.destroy end def test_destroy_just_kidding assert_not_nil @first end end class MultipleFixturesTest < ActiveRecord::TestCase fixtures :topics fixtures :developers, :accounts def test_fixture_table_names assert_equal %w(topics developers accounts), fixture_table_names end end class SetupTest < ActiveRecord::TestCase # fixtures :topics def setup @first = true end def test_nothing end end class SetupSubclassTest < SetupTest def setup super @second = true end def test_subclassing_should_preserve_setups assert @first assert @second end end class OverlappingFixturesTest < ActiveRecord::TestCase fixtures :topics, :developers fixtures :developers, :accounts def test_fixture_table_names assert_equal %w(topics developers accounts), fixture_table_names end end class ForeignKeyFixturesTest < ActiveRecord::TestCase fixtures :fk_test_has_pk, :fk_test_has_fk # if foreign keys are implemented and fixtures # are not deleted in reverse order then this test # case will raise StatementInvalid def test_number1 assert true end def test_number2 assert true end end class OverRideFixtureMethodTest < ActiveRecord::TestCase fixtures :topics def topics(name) topic = super topic.title = "omg" topic end def test_fixture_methods_can_be_overridden x = topics :first assert_equal "omg", x.title end end class FixtureWithSetModelClassTest < ActiveRecord::TestCase fixtures :other_posts, :other_comments # Set to false to blow away fixtures cache and ensure our fixtures are loaded # and thus takes into account the +set_model_class+. self.use_transactional_tests = false def test_uses_fixture_class_defined_in_yaml assert_kind_of Post, other_posts(:second_welcome) end def test_loads_the_associations_to_fixtures_with_set_model_class post = other_posts(:second_welcome) comment = other_comments(:second_greetings) assert_equal [comment], post.comments assert_equal post, comment.post end end class SetFixtureClassPrevailsTest < ActiveRecord::TestCase set_fixture_class bad_posts: Post fixtures :bad_posts # Set to false to blow away fixtures cache and ensure our fixtures are loaded # and thus takes into account the +set_model_class+. self.use_transactional_tests = false def test_uses_set_fixture_class assert_kind_of Post, bad_posts(:bad_welcome) end end class CheckSetTableNameFixturesTest < ActiveRecord::TestCase set_fixture_class funny_jokes: Joke fixtures :funny_jokes # Set to false to blow away fixtures cache and ensure our fixtures are loaded # and thus takes into account our set_fixture_class self.use_transactional_tests = false def test_table_method assert_kind_of Joke, funny_jokes(:a_joke) end end class FixtureNameIsNotTableNameFixturesTest < ActiveRecord::TestCase set_fixture_class items: Book fixtures :items # Set to false to blow away fixtures cache and ensure our fixtures are loaded # and thus takes into account our set_fixture_class self.use_transactional_tests = false def test_named_accessor assert_kind_of Book, items(:dvd) end end class FixtureNameIsNotTableNameMultipleFixturesTest < ActiveRecord::TestCase set_fixture_class items: Book, funny_jokes: Joke fixtures :items, :funny_jokes # Set to false to blow away fixtures cache and ensure our fixtures are loaded # and thus takes into account our set_fixture_class self.use_transactional_tests = false def test_named_accessor_of_differently_named_fixture assert_kind_of Book, items(:dvd) end def test_named_accessor_of_same_named_fixture assert_kind_of Joke, funny_jokes(:a_joke) end end class CustomConnectionFixturesTest < ActiveRecord::TestCase set_fixture_class courses: Course fixtures :courses self.use_transactional_tests = false def test_leaky_destroy assert_nothing_raised { courses(:ruby) } courses(:ruby).destroy end def test_it_twice_in_whatever_order_to_check_for_fixture_leakage test_leaky_destroy end end class TransactionalFixturesOnCustomConnectionTest < ActiveRecord::TestCase set_fixture_class courses: Course fixtures :courses self.use_transactional_tests = true def test_leaky_destroy assert_nothing_raised { courses(:ruby) } courses(:ruby).destroy end def test_it_twice_in_whatever_order_to_check_for_fixture_leakage test_leaky_destroy end end class TransactionalFixturesOnConnectionNotification < ActiveRecord::TestCase self.use_transactional_tests = true self.use_instantiated_fixtures = false def test_transaction_created_on_connection_notification connection = stub(transaction_open?: false) connection.expects(:begin_transaction).with(joinable: false) pool = connection.stubs(:pool).returns(ActiveRecord::ConnectionAdapters::ConnectionPool.new(ActiveRecord::Base.connection_pool.spec)) pool.stubs(:lock_thread=).with(false) fire_connection_notification(connection) end def test_notification_established_transactions_are_rolled_back # Mocha is not thread-safe so define our own stub to test connection = Class.new do attr_accessor :rollback_transaction_called attr_accessor :pool def transaction_open?; true; end def begin_transaction(*args); end def rollback_transaction(*args) @rollback_transaction_called = true end end.new connection.pool = Class.new do def lock_thread=(lock_thread); false; end end.new fire_connection_notification(connection) teardown_fixtures assert(connection.rollback_transaction_called, "Expected #rollback_transaction to be called but was not") end private def fire_connection_notification(connection) ActiveRecord::Base.connection_handler.stubs(:retrieve_connection).with("book").returns(connection) message_bus = ActiveSupport::Notifications.instrumenter payload = { spec_name: "book", config: nil, connection_id: connection.object_id } message_bus.instrument("!connection.active_record", payload) {} end end class InvalidTableNameFixturesTest < ActiveRecord::TestCase fixtures :funny_jokes # Set to false to blow away fixtures cache and ensure our fixtures are loaded # and thus takes into account our lack of set_fixture_class self.use_transactional_tests = false def test_raises_error assert_raise ActiveRecord::FixtureClassNotFound do funny_jokes(:a_joke) end end end class CheckEscapedYamlFixturesTest < ActiveRecord::TestCase set_fixture_class funny_jokes: Joke fixtures :funny_jokes # Set to false to blow away fixtures cache and ensure our fixtures are loaded # and thus takes into account our set_fixture_class self.use_transactional_tests = false def test_proper_escaped_fixture assert_equal "The \\n Aristocrats\nAte the candy\n", funny_jokes(:another_joke).name end end class DevelopersProject; end class ManyToManyFixturesWithClassDefined < ActiveRecord::TestCase fixtures :developers_projects def test_this_should_run_cleanly assert true end end class FixturesBrokenRollbackTest < ActiveRecord::TestCase def blank_setup @fixture_connections = [ActiveRecord::Base.connection] end alias_method :ar_setup_fixtures, :setup_fixtures alias_method :setup_fixtures, :blank_setup alias_method :setup, :blank_setup def blank_teardown; end alias_method :ar_teardown_fixtures, :teardown_fixtures alias_method :teardown_fixtures, :blank_teardown alias_method :teardown, :blank_teardown def test_no_rollback_in_teardown_unless_transaction_active assert_equal 0, ActiveRecord::Base.connection.open_transactions assert_raise(RuntimeError) { ar_setup_fixtures } assert_equal 0, ActiveRecord::Base.connection.open_transactions assert_nothing_raised { ar_teardown_fixtures } assert_equal 0, ActiveRecord::Base.connection.open_transactions end private def load_fixtures(config) raise "argh" end end class LoadAllFixturesTest < ActiveRecord::TestCase def test_all_there self.class.fixture_path = FIXTURES_ROOT + "/all" self.class.fixtures :all if File.symlink? FIXTURES_ROOT + "/all/admin" assert_equal %w(admin/accounts admin/users developers namespaced/accounts people tasks), fixture_table_names.sort end ensure ActiveRecord::FixtureSet.reset_cache end end class LoadAllFixturesWithPathnameTest < ActiveRecord::TestCase def test_all_there self.class.fixture_path = Pathname.new(FIXTURES_ROOT).join("all") self.class.fixtures :all if File.symlink? FIXTURES_ROOT + "/all/admin" assert_equal %w(admin/accounts admin/users developers namespaced/accounts people tasks), fixture_table_names.sort end ensure ActiveRecord::FixtureSet.reset_cache end end class FasterFixturesTest < ActiveRecord::TestCase self.use_transactional_tests = false fixtures :categories, :authors def load_extra_fixture(name) fixture = create_fixtures(name).first assert fixture.is_a?(ActiveRecord::FixtureSet) @loaded_fixtures[fixture.table_name] = fixture end def test_cache assert ActiveRecord::FixtureSet.fixture_is_cached?(ActiveRecord::Base.connection, "categories") assert ActiveRecord::FixtureSet.fixture_is_cached?(ActiveRecord::Base.connection, "authors") assert_no_queries do create_fixtures("categories") create_fixtures("authors") end load_extra_fixture("posts") assert ActiveRecord::FixtureSet.fixture_is_cached?(ActiveRecord::Base.connection, "posts") self.class.setup_fixture_accessors :posts assert_equal "Welcome to the weblog", posts(:welcome).title end end class FoxyFixturesTest < ActiveRecord::TestCase fixtures :parrots, :parrots_pirates, :pirates, :treasures, :mateys, :ships, :computers, :developers, :"admin/accounts", :"admin/users", :live_parrots, :dead_parrots, :books if ActiveRecord::Base.connection.adapter_name == "PostgreSQL" require "models/uuid_parent" require "models/uuid_child" fixtures :uuid_parents, :uuid_children end def test_identifies_strings assert_equal(ActiveRecord::FixtureSet.identify("foo"), ActiveRecord::FixtureSet.identify("foo")) assert_not_equal(ActiveRecord::FixtureSet.identify("foo"), ActiveRecord::FixtureSet.identify("FOO")) end def test_identifies_symbols assert_equal(ActiveRecord::FixtureSet.identify(:foo), ActiveRecord::FixtureSet.identify(:foo)) end def test_identifies_consistently assert_equal 207281424, ActiveRecord::FixtureSet.identify(:ruby) assert_equal 1066363776, ActiveRecord::FixtureSet.identify(:sapphire_2) assert_equal "f92b6bda-0d0d-5fe1-9124-502b18badded", ActiveRecord::FixtureSet.identify(:daddy, :uuid) assert_equal "b4b10018-ad47-595d-b42f-d8bdaa6d01bf", ActiveRecord::FixtureSet.identify(:sonny, :uuid) end TIMESTAMP_COLUMNS = %w(created_at created_on updated_at updated_on) def test_populates_timestamp_columns TIMESTAMP_COLUMNS.each do |property| assert_not_nil(parrots(:george).send(property), "should set #{property}") end end def test_does_not_populate_timestamp_columns_if_model_has_set_record_timestamps_to_false TIMESTAMP_COLUMNS.each do |property| assert_nil(ships(:black_pearl).send(property), "should not set #{property}") end end def test_populates_all_columns_with_the_same_time last = nil TIMESTAMP_COLUMNS.each do |property| current = parrots(:george).send(property) last ||= current assert_equal(last, current) last = current end end def test_only_populates_columns_that_exist assert_not_nil(pirates(:blackbeard).created_on) assert_not_nil(pirates(:blackbeard).updated_on) end def test_preserves_existing_fixture_data assert_equal(2.weeks.ago.to_date, pirates(:redbeard).created_on.to_date) assert_equal(2.weeks.ago.to_date, pirates(:redbeard).updated_on.to_date) end def test_generates_unique_ids assert_not_nil(parrots(:george).id) assert_not_equal(parrots(:george).id, parrots(:louis).id) end def test_automatically_sets_primary_key assert_not_nil(ships(:black_pearl)) end def test_preserves_existing_primary_key assert_equal(2, ships(:interceptor).id) end def test_resolves_belongs_to_symbols assert_equal(parrots(:george), pirates(:blackbeard).parrot) end def test_ignores_belongs_to_symbols_if_association_and_foreign_key_are_named_the_same assert_equal(developers(:david), computers(:workstation).developer) end def test_supports_join_tables assert(pirates(:blackbeard).parrots.include?(parrots(:george))) assert(pirates(:blackbeard).parrots.include?(parrots(:louis))) assert(parrots(:george).pirates.include?(pirates(:blackbeard))) end def test_supports_inline_habtm assert(parrots(:george).treasures.include?(treasures(:diamond))) assert(parrots(:george).treasures.include?(treasures(:sapphire))) assert(!parrots(:george).treasures.include?(treasures(:ruby))) end def test_supports_inline_habtm_with_specified_id assert(parrots(:polly).treasures.include?(treasures(:ruby))) assert(parrots(:polly).treasures.include?(treasures(:sapphire))) assert(!parrots(:polly).treasures.include?(treasures(:diamond))) end def test_supports_yaml_arrays assert(parrots(:louis).treasures.include?(treasures(:diamond))) assert(parrots(:louis).treasures.include?(treasures(:sapphire))) end def test_strips_DEFAULTS_key assert_raise(StandardError) { parrots(:DEFAULTS) } # this lets us do YAML defaults and not have an extra fixture entry %w(sapphire ruby).each { |t| assert(parrots(:davey).treasures.include?(treasures(t))) } end def test_supports_label_interpolation assert_equal("frederick", parrots(:frederick).name) end def test_supports_label_string_interpolation assert_equal("X marks the spot!", pirates(:mark).catchphrase) end def test_supports_label_interpolation_for_integer_label assert_equal("#1 pirate!", pirates(1).catchphrase) end def test_supports_polymorphic_belongs_to assert_equal(pirates(:redbeard), treasures(:sapphire).looter) assert_equal(parrots(:louis), treasures(:ruby).looter) end def test_only_generates_a_pk_if_necessary m = Matey.first m.pirate = pirates(:blackbeard) m.target = pirates(:redbeard) end def test_supports_sti assert_kind_of DeadParrot, parrots(:polly) assert_equal pirates(:blackbeard), parrots(:polly).killer end def test_supports_sti_with_respective_files assert_kind_of LiveParrot, live_parrots(:dusty) assert_kind_of DeadParrot, dead_parrots(:deadbird) assert_equal pirates(:blackbeard), dead_parrots(:deadbird).killer end def test_namespaced_models assert_includes admin_accounts(:signals37).users, admin_users(:david) assert_equal 2, admin_accounts(:signals37).users.size end def test_resolves_enums assert books(:awdr).published? assert books(:awdr).read? assert books(:rfr).proposed? assert books(:ddd).published? end end class ActiveSupportSubclassWithFixturesTest < ActiveRecord::TestCase fixtures :parrots # This seemingly useless assertion catches a bug that caused the fixtures # setup code call nil[] def test_foo assert_equal parrots(:louis), Parrot.find_by_name("King Louis") end end class CustomNameForFixtureOrModelTest < ActiveRecord::TestCase ActiveRecord::FixtureSet.reset_cache set_fixture_class :randomly_named_a9 => ClassNameThatDoesNotFollowCONVENTIONS, :'admin/randomly_named_a9' => Admin::ClassNameThatDoesNotFollowCONVENTIONS1, "admin/randomly_named_b0" => Admin::ClassNameThatDoesNotFollowCONVENTIONS2 fixtures :randomly_named_a9, "admin/randomly_named_a9", :'admin/randomly_named_b0' def test_named_accessor_for_randomly_named_fixture_and_class assert_kind_of ClassNameThatDoesNotFollowCONVENTIONS, randomly_named_a9(:first_instance) end def test_named_accessor_for_randomly_named_namespaced_fixture_and_class assert_kind_of Admin::ClassNameThatDoesNotFollowCONVENTIONS1, admin_randomly_named_a9(:first_instance) assert_kind_of Admin::ClassNameThatDoesNotFollowCONVENTIONS2, admin_randomly_named_b0(:second_instance) end def test_table_name_is_defined_in_the_model assert_equal "randomly_named_table2", ActiveRecord::FixtureSet::all_loaded_fixtures["admin/randomly_named_a9"].table_name assert_equal "randomly_named_table2", Admin::ClassNameThatDoesNotFollowCONVENTIONS1.table_name end end class FixturesWithDefaultScopeTest < ActiveRecord::TestCase fixtures :bulbs test "inserts fixtures excluded by a default scope" do assert_equal 1, Bulb.count assert_equal 2, Bulb.unscoped.count end test "allows access to fixtures excluded by a default scope" do assert_equal "special", bulbs(:special).name end end class FixturesWithAbstractBelongsTo < ActiveRecord::TestCase fixtures :pirates, :doubloons test "creates fixtures with belongs_to associations defined in abstract base classes" do assert_not_nil doubloons(:blackbeards_doubloon) assert_equal pirates(:blackbeard), doubloons(:blackbeards_doubloon).pirate end end class FixtureClassNamesTest < ActiveRecord::TestCase def setup @saved_cache = fixture_class_names.dup end def teardown fixture_class_names.replace(@saved_cache) end test "fixture_class_names returns nil for unregistered identifier" do assert_nil fixture_class_names["unregistered_identifier"] end end class SameNameDifferentDatabaseFixturesTest < ActiveRecord::TestCase fixtures :dogs, :other_dogs test "fixtures are properly loaded" do # Force loading the fixtures again to reproduce issue ActiveRecord::FixtureSet.reset_cache create_fixtures("dogs", "other_dogs") assert_kind_of Dog, dogs(:sophie) assert_kind_of OtherDog, other_dogs(:lassie) end end