Open DaveSanders opened 10 years ago
hey @DaveSanders, a good place to start is to provide a working example of upsert in MSSQL.
INSERT OR IGNORE
+ UPDATE
as in the sqlite3 upsert functionif you provide the SQL and a narrative of how it works, I can help wrap it in Ruby to be part of this gem.
Excellent. We'll figure it out and get back to you.
Ok, here's a working merge example in MSSQL: https://gist.github.com/DaveSanders/8721734
hey @pnomolos , would you have time to create the requisite files
lib/upsert/column_definition/mssql.rb
lib/upsert/connection/ODBC_Database_MSSQL.rb
(not sure what the exact class name is)lib/upsert/merge_function/ODBC_Database_MSSQL.rb
(ditto)lib/upsert/merge_function/mssql.rb
then perhaps @DaveSanders can help fill them out?
(sorry for huge delay in responding, I've been swamped at work)
Hey @seamusabshere and @DaveSanders sorry for the big delay - do you still need me to take a look at this?
hey @pnomolos that would be great!
hi @pnomolos it's me again ;)
given my comment above listing files needing to get created, would you have time to kickstart this?
I'll see what I can do to get this done - or at least started - over the weekend :)
I can't say I'm surprised, but upsert doesn't suport ODBC::Database driver. Just so happens for this one client I need to upsert to a ODBC (MSSQL) database.
If someone were to give me a clue where to start, I might be able to help here. But I haven't had a chance to go dig through the code to figure out whats needed.
I suspect its not an itch that many people need to scratch. But I figured I'd log it.