On Oct 6, 6:54 pm, File <[EMAIL PROTECTED]> wrote: > On Oct 6, 10:52 pm, Jeremy Evans <[EMAIL PROTECTED]> wrote: > > A patch that adds a Sequel::Database.upcase_identifiers= > > setting would be appreciated if you can find the time. > > I would gladly help but I'm lost on your code, I had to grep -r > 'upcase' *.rb just to find the function to override. ;) > > Anyways I'm lost on how you define which database you are speaking to, > because when I do the a connect to sqlite3 it all works fine (probably > the adapter is overriding this function) but on ado or odbc, how would > you find which db are you connecting to? I mean there's even a odbc > driver for sqlite3! So... I'm lost. There should be a odbc WhatAreYou > function that responded "Hello I'm a MS SQL SERVER 2005 db, so don't > quote my identifiers, mmmk!?"
For the adapters that can connect to databases of different types (ODBC, JDBC, ADO, etc.), you can use shared subadapters that customize the Sequel::Database object for the database being connected to. The JDBC adapter is probably the best example of this. You are correct that the sqlite adapter overrides the quoted_identifier method. If you connected to sqlite via ODBC, it wouldn't work, because the only subadapter support in the ODBC adapter is for MSSQL. Subadapter support is easy to add if needed, but I haven't had any requests for sqlite via ODBC, for example. In any case, I'm glad you got it working. Jeremy --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sequel-talk" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sequel-talk?hl=en -~----------~----~----~----~------~----~------~--~---
