database_cleaner-active_record

database_cleaner-active_record copied to clipboard

It's sometimes necessary to add `pg_catalog` explicitly to the search path (if you don't want it added implicitly at the beginning of the search path). It then gets picked up...

jscheid

Hi, I can find on `README.md` that we can use some options ```ruby DatabaseCleaner[:active_record].strategy = :truncation, only: ["users"] ``` This syntax is not ruby valid. How do you specify options...

waghanza

Wrapping ActiveRecord test causes it to fail (no records found)

3

I created a script to demonstrate this behavior: ``` #!/usr/bin/env ruby begin require "bundler/inline" rescue LoadError => e $stderr.puts "Bundler version 1.10 or later is required. Please update your bundler"...

hansondr

Truncation failure with CockroachDB

2

DatabaseCleaner treats CockroachDB as PostgreSQL (which makes sense because CockroachDB emulated PostgreSQL to some extent). It uses the `RESTART IDENTITY` clause in the `TRUNCATE TABLE` query, which isn't supported by...

agaffney

activerecord-jdbcmysql-adapter causing error for truncation

2

We have an application that needs to support multiple database engines, so our `Gemfile` contains multiple JDBC adapters as so: ``` gem 'activerecord-jdbcpostgresql-adapter', '~>1.3.7' gem 'activerecord-jdbcmssql-adapter', '~>1.3.7' gem 'activerecord-jdbcmysql-adapter', '~>1.3.7'...

pareeohnos

Can we test other databases?

2

AR has adapters for a lot more than Sqlite, MySQL, and PostgreSQL. Can we test our code that works against those, too? What does the AR repo do about this?

botandrose

Problem with restarting a transaction when using transaction strategy

1

I have a method like this: ``` def make_foo(bar, params) foo = nil self.transaction do foo = self.create!(name: bar) rescue nil end unless foo self.transaction do foo = Something.find_by(name: bar).update(params)...

kenips

When multiple Database backends are used in ActiveRecord, DatabaseCleaner fails to truncate tables

7

When _both_ MySQL and Postgres ActiveRecord models are used, and when testing MySQL-backed code, Truncation strategy includes _BOTH_ ::DatabaseCleaner::ActiveRecord::MysqlAdapter and ::DatabaseCleaner::ActiveRecord::PostgreSQLAdapter into ::DatabaseCleaner::ActiveRecord::AbstractAdapter, which, in turn, gets included into ActiveRecord::AbstractAdapter....

DFrenkel

disabling referential integrity with postgresql is faster by setting session_replication_role='replica'

1

For large databases, this is _way_ faster than disabling/enabling all the triggers. `set session_replication_role='replica';`

joevandyk

DatabaseCleaner improperly starts and ends transactions for ActiveRecord

2

If there is more than one connection in the connection pool DatabaseCleaner will only begin the transaction on one of the connections. https://github.com/rails/rails/blob/master/activerecord/lib/active_record/fixtures.rb#L979 Any ActiveRecord call afterwards will use the...

ryanong