similar to: mapping column names in legacy schemata

I have an ActiveRecord question... I have a legacy MySQL database with a weird naming convention - all table and column names have a prefix ''_'' , which is annoying, and some of the column names are plain misnomers. I would like to apply a pre-defined mapping between MySQL column names and method names to be used in the Ruby class, without having the underlying column names

I have a previous question regarding long tasks and the thread_pool (sorry for the dup, I didn''t see the first go through). To try and track things down, I made a change based on a suggestion found in the archives. I moved my import contacts worker to its own file and set the pool_size to 1. class ImportContactsWorker < BackgrounDRb::MetaWorker set_worker_name

Dears, Oracle 8 don''t support ANSI syntax with : SELECT e.emp_id, e.fname, e.lname, j.jobdesc FROM employe e LEFT JOIN jobs j ON e.job_id = j.job_id but only SELECT e.emp_id, e.fname, e.lname, j.jobdesc FROM employe e, jobs j WHERE j.job_id (+) = e.job_id JOIN syntax came with 9i. Anyone patched Rails

Hello List, i have been agonizing over this for days, any reply would be greatly appreciated! Situation:___________________________________ My original dataset is a .csv dataset (w/ 2M records) with 4 variables: job_id (Primary key, won't be used for analysis, just used for join tables), sector_id (categorical variable, for 19 industry sectors), sqft (con't variable for square

No doubt this has been covered but I''ll be damned if I can find it. References appreciated so I can add to my library. 1. I have 3 tables in my problem: changes, environments, comments 2. changes are many-to-many to environments 3. changes has-many comments Here''s the tricky part: 4. environments has-many comments dependent on the current environment. Tables: changes,

I use backgroundrb for many long tasks in my system, but I''m having issues with one in particular. Two large tasks for me are importing people and updating companies. def import_contacts(args = nil) thread_pool.defer(args) do |job_id| begin job = ImportJob.find(job_id) job.process_job rescue => err logger.error "MscWorker#import_contacts

I use backgroundrb for many long tasks in my system, but I''m having issues with one in particular. Two large tasks for me are importing people and updating companies. def import_contacts(args = nil) thread_pool.defer(args) do |job_id| begin job = ImportJob.find(job_id) job.process_job rescue => err logger.error "MscWorker#import_contacts

Hi, how can I get Rails to generate SQL queries with conditions in the JOIN clause? What I would want is: SELECT * FROM people p LEFT OUTER JOIN jobs j (p.job_id = j.id AND j.salary > 9999999) I tried People.find(:all, :include => ''jobs'', :conditions => ''jobs.salary > 9999999'') but that generates SELECT * FROM people p LEFT OUTER

Hi, I''ve figured out how to join tables using :joins, but is there a more elegant way to do this using built-in rails methods? Here is the code: Hiringstep_Job.find( :all, :joins => ", hiringsteps", :conditions => ["hiringstep_jobs.hiringstep_id = hiringsteps.id AND job_id = ?", 1]) Thanks, David -- Posted via http://www.ruby-forum.com/.

I''ve upgraded to mySQL 5.0, and it''s gone pretty smoothly except that on DateTime.now doesn''t seem to return a value that mySQL likes any more, as seen in the following exception: Incorrect datetime value: ''2005-11-20T15:33:12-0800'' for column ''logged_at'' at row 1: UPDATE notes SET `due_on` = ''2005-11-20'',

Hey Rails People, I''m doing my first Rails app and I''m having a newbie problem with the count method.... Mysql::Error: #42S02Unknown table ''jobs_sectors'' in where clause: SELECT COUNT(*) FROM jobs WHERE (jobs_sectors.sector_id = 1 ) Extracted source (around line #4): 1: <div class="sectors"> 2: <ul> 3: <% for sector in @sectors

I''m having trouble getting the magical counter to work in a rails app with single table inheritance. following is the relevant code. thank you class declarations class Job < ActiveRecord::Base has_many :vents end class Vent < ActiveRecord::Base belongs_to :job, :counter_cache => true validates_numericality_of :width end class Rectangular < Vent

Hi All I recently began having issues where there would be a runaway SMBD process listed in TOP, having a Pri of around 25, and using 70 to 95% CPU indefinitely. IPTRAF reports around 600kbps constantly in and out from the subject workstation, with nothing going on - on the workstation. This traffic is parallel to the runaway SMBD process ... the traffic dies when the SMBD process is

My model is being created but isn''t saving. It''s like it skips straight past saving. Any ideas why it might do this? Updating works fine. def create @volunteer = Volunteer.new(params[:volunteer]) @volunteer.save redirect_to(volunteers_url) end And here''s what the console reads upon create: Processing VolunteersController#create (for 127.0.0.1 at

Hi I am using following say.conf file. Its a default file, which comes with Asterisk installation. When I call SAY DATETIME AGI function, it simply returns without playing date & time. Where as if I use mode=old setting, it works. Is this a bug or mode=new is not implemented for SAY DATETIME AGI function? [general] mode=new ; method for playing numbers and dates ;

Hello all, I''ve come up w/ a worker class that manages queued jobs using a fixed number of child workers. Well, that''s not quite true -- a new worker is spawned for each job, but you set the total number that may exist at once. There are three components: 1) queue_worker.rb: The singleton worker that manages the child workers. You probably want to auto start this. Make sure you

Hi, why is this parameter deprecated ? I have to set this parameter if i want to get my user/group information from Active Directory with SFU AD schemata extension. Is there a new parameter instead of "idmap backend" ??? Buy Andy

Hello all I have two Linux boxes. The first one is samba servers for the Windows clients. The second one is backup storage. So every few hours rsnc synchronises the data directories on the second machine. They are Suse Linux 9 Linux max 2.6.11.4-21.7-smp #1 SMP Thu Jun 2 14:23:14 UTC 2005 i686 i686 i386 GNU/Linux rsync version 2.6.3 protocol version 28 From time to time I get errors reported,

If anyone is interested ... just in case! :-)... I have tried to write , based on the cdr_mysql.so module, an Sybase module. To compile you can use something like that: export SYBPLATFORM=linux export SYBASE=/opt/sybase cc -I$SYBASE/include -c -o cdr_sybase.o cdr_sybase.c cc -shared -Xlinker -x -o cdr_sybase.so cdr_sybase.o -lsybdb -lm -L$SYBASE/lib (anyone could write the corect Makefile

On Fri, 3 Nov 2023 15:13:22 +0000 Willi Schiegel via samba <samba at lists.samba.org> wrote: > Hello to all, > > how can I have multiple email addresses / aliases for an account? I > can only set one address with samba-tool's mail-address (mail is a > single value attribute) and mailAternativeAddress is not found in the > schemata. > > Best regards > Willi