bulk_insert

bulk_insert copied to clipboard

We have a setup where we occasionally try to bulk import from a database with a schema that is out of sync with the target. If the source database has...

malclocke

bulk_insert does not return a worker object

4

I am using version 1.8.1, ruby 2.3.8, rails 4.2.5 I am trying to use non-block mode, passing an array of attribute hashes. My model is named `Gap`: ``` worker =...

fredwillmore

Before/After create callbacks

1

As I just learned, create callbacks does not work when using the gem. Is there any solution for this issue?

ShiraUnger

rails: 6.0 ruby: 2.7.2 bulk_insert: 1.8.1 used ```ruby WrittenPadQuestion.bulk_insert(.....) do |worker| ..... ..... ..... end ``` app/models/questions.rb xxxxs.rb: ```ruby belongs_to :original_question, optional: true has_many :question_tag_relations, dependent: :destroy has_many :tags, through:...

RanX12

Return primary keys when using blocks or values

2

In https://github.com/jamis/bulk_insert/pull/32, @psloomis did a great job in adding the possibility to retrieve the primary keys inserted in PostGIS and PostgreSQL. However, this requires to manupulate the `Worker` instance directly...

pomier

Use #exec_insert over #exec_query because there's no field selections

8

## What's up? Hi there, Thanks for the gem! It's awesome. While I was trying it, I got an error on calling `worker.save!`. ```sh NoMethodError: undefined method `fields' for nil:NilClass...

daemonsy

Double-quoting column names in ON CONFLICT statement (PostgreSQL)

1

PostgreSQL supports uppercase in column names, but `Worker` class has a bug with `ON CONFLICT` statement. **Case**: When column name in uppercase or contains uppercase letter, we get error like...

steverovsky

Option for ignored columns on update

9

Closes https://github.com/jamis/bulk_insert/issues/50 Alternately I also noticed https://github.com/jamis/bulk_insert/pull/49 which also attempts to fix the same issue but the API interface is slightly different. I could be wrong, but I'm guessing typically...

aqeelvn

Falsey column defaults not used

1

Column default values like `''` or `false` aren't used when a value is omitted for that column. For example, if I have a table `foo` with a column `bar` that...

harto

Ability to set specific column list for update duplicates statement

1

Actually for building _update duplicates statement_ used column list from _column_names_ option. Be default for most cases is convenient, but there are some limitations and more flexibility is required. Added...

steverovsky