localytics / odbc_adapter Goto Github PK
View Code? Open in Web Editor NEWAn ActiveRecord ODBC adapter
License: MIT License
An ActiveRecord ODBC adapter
License: MIT License
I have tried to connect to databricks using odbc_driver and able to establish connection and able to perform reads as well,
but facing issue while doing writes. when I tried to update any record and save it using ORM I'm receiving the error (S1C00 (11470) [Simba][ODBC] (11470) Transactions are not supported.)
I'm able to do inserts and updates using raw queries by overriding the active record methods, but I would like to find out what can be done here without overriding the methods like save and destroy/delete
Hi there!
We have been using the 4.x version of the adapter and we recently decided to upgrade to upgrade to Rails 5. We are getting undefined method extract_table_ref_from_insert_sql' in sql_for_insert when we try to do something like
Model.save!`. I noticed that this method was removed between 4.x and 5.x. Do you recommend including this method in the odbc.rb initializer or do you recommend a different approach?
This gem is not compatible with rails 5.2 especailly because of the the disappearance of arel/visitors/bind_visitor. Is there any plan to update this gem?
I have made some quick fix on my side to have a workaround. Is it worst to make a PR?
I'm having problems running the tests against a Postgresql 10.10 database. The tests run just fine in the docker container, which uses Postgresql 9.4.x
Against a 10.10 postgres db I get this error
ODBC_UTF8::Error: INTERN (0) [RubyODBC]Too much parameters: SELECT "ar_internal_metadata".* FROM "ar_internal_metadata" WHERE "ar_internal_metadata"."key" = $1 LIMIT $2
Is this a problem with postgres 10.10, or is it another problem? I'm running client and db inside Ubuntu 18.04
Are there any plans to upgrade this gem to be compatible with Rails 6?
I'm using a simple User.first
to load a row from Snowflake but the id
always contains nil
:
User.first
# <User id:nil, username: "bob>
the underlying query is returning correct data though:
User.connection.exec_query('select * from user limit 1')
# {:id => "5", :username => "bob" ...}
Doing a step-by-step object construction yields this error:
h = User.connection.exec_query('select * from user limit 1').to_a[0]
User.new(h)
# ActiveModel::MissingAttributeError: can't write unknown attribute `ID`
# from /Users/bob/.rvm/gems/ruby-2.4.2/gems/activerecord-5.1.7/lib/active_record/attribute.rb:205:in `with_value_from_database'-
Is this something specific to the id
column that needs an initializer setting?
Hi i'm have some issue with this adapter. Have you any idea what can cause this issues
I'm using the DSN to connect to Exasol and it successfully connected
in the rails console i can call my Company.count and i get the number of rows in the database but when i Company.where(company_id: 2222) i get this error
info:
rails 5
ruby 2.4.1
i'm user docker for development
ActiveRecord::StatementInvalid: ODBC::Error: S1000 (1) [EXASOL][EXASolution driver]Character set conversion error or output buffer to small: Invalid or incomplete multibyte or wide character column 5, cursor position 1, codepage ANSI_X3.4-1968.:
A declarative, efficient, and flexible JavaScript library for building user interfaces.
๐ Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. ๐๐๐
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google โค๏ธ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.