similar to: Migrations don''t really support transactions

Hi I''m choosing a database for a new Rails application. I pretty much ruled out PostgreSQL, since despite good reviews of the database itself, it seems it has countless issues with Rails (for example: in recent releases migrations don''t work, and unit-tests fail). So I should now choose between MySQL 4.1, which as I understand enjoys widespread popularity - perhaps the most

Hi all I have a new migration file created that adds some tables and fills one with some data: create_table :sound_styles do |t| t.column :name, :string, :null => false end create_table :show_types do |t| t.column :name, :string, :null => false end create_table :countries do |t| t.column :name, :string, :null => false end ActionView::Helpers::FormOptionsHelper::COUNTRIES.each

I am running Rails 1.1.2 with Ruby 1.82-15. My database is Postgresql. I haven''t had any problems generating models, migrations, using scaffolds, and generally building and using my application, but I haven''t been able to get testing to work. I initially just ignored the problem and kept developing, but would like to add proper testing from here on out. Currently when I type

Hi all. I have a problem with postgresql PK columns and ActiveRecord. The error is: PGError: ERROR: null value in column "item_id" violates not-null. Ok, it''s wrong to insert NULL into PK columns, but rails doing it. How to fix? So sad..

Hello everyone, I have another question related to a legacy schema I am working with. Do dynamic finders work with legacy schemas in general? The schema I am working with uses hungarian prefixes for column names. For example fOpen is 0 if a bug is closed and 1 if it is open (type smallint). When I try @bugs = Bug.find_all_by_fOpen(1), I get the following exception: undefined method

I am looking at using acts_as_versioned to manage revisions of data in several tables in my application. However, the default behavior of acts_as_versioned appears to apply to individual rows within a table. The tables I want to version are complicated lookup tables and what I really want is to version the entire contents of each table as a single set. Adding a row, deleting a row, or updating

Hi, I have a scenario where a doctor can have one or more specialties. For each doctor, one and only one of her specialties can be designated as primary. So I have tables called doctors, specialties, and doctors_specialties, the last of which has a boolean is_primary column. The doctor model class specifies that: has_and_belongs_to_many :specialties I want to enforce, at the lowest possible

This is way offtopic, but I''ve seen this several times recently and it''s annoying me. If you put "HOWTO" in your subject that means that you''re posting a guide on a particular topic. It doesn''t mean that you''re asking a question about "how to" do something. It''s not like it''s a crisis, but it screws up searches

I have a controller method called update_all that grabs parameters for about 30 form fields and saves them to the database. My current code looks to see if there is a string in params[] for each form field (two fields for each SelfEvaluationItem) and saves the updated self_evaluation_answer if a string is available. Since this is iterated code, I am almost certain that this generates 30 or so

I love using ActiveRecord Migrations to build tables. Sometimes, I don''t want to use autogenerated PK''s - I want to set them automatically (why? I''m importing read only data from a large list of medications, and want to use the PK''s assigned by the medication research company...). Is there anyway to do this using Migrations? I know that I don''t

Hello Everyone, I have been reading this mailing list for a while and am impressed with the generous help that many here are eager to provide. Perhaps someone will be able to shed some light on a configuration issue I am having. Thank you in advance for any assistance. First, system setup details: #System Setup# * OS: Fedora Core 4 running in a VMWare box on Windows XP * Database: MS SQL

Can anyone recommend a database modelling tool for the Mac? I''m building a new Rails app and want an interface to draw out the database''s entity relationship diagram, setup foreign keys and then output DDL at the end to MySQL. I''ve previously used DBDesigner, CASE Studio and some pricier enterprise software on Windows, but can''t find anything suitable for my

I''m thinking of experimenting with some currency conversion. However, I''d like the conversions to be in synch with the current rates. Anyone know (and this maybe out in left field) if there is some online (perhaps xml) or other data stream I can connect with in my code to output values based on user selection ? TIA Stuart

Hi all, Can I safely assume that each migration is excuted within a transaction, so that''s it''s safe to have migrations executing failing statements? Thanks, - Rowan -- Morality is usually taught by the immoral.

Hi! It seems that migration doesn''t use single transcation to execute the needed migrations for the database upgrade, so if I have database at version 5, and I wrote some migrations 6..10, and error occurs while executing migration 7, the database stays in state 6? I also think that migration taks could use some more verbosity, for example if migration fails, there''s no

Greetings all. I have some controller code that uses win32ole (only available on windows). This code is now solid, and I''d now like to resume development on (any) other OS(grin). But alas, the controller bails because the OS specific library can''t be found. Can I conditionally specify action code compilation (and a require ''win32ole'') based on OS or

Gene's posting: https://alioth-lists.debian.net/pipermail/nut-upsuser/2020-January/011654.html contains a NUT 2.7.4 update for the APC Smart-UPS_1500 device dump at https://networkupstools.org/ddl/APC/Smart-UPS_1500.html Please note the changes since the 2.7.2 report, e.g. ups.delay.start is no longer supported. Roger

I''ve got a couple apps that I use (billing app, support ticket app, some other custom apps) that I want to integrate into one site. They will all use the same layout for the most part, and will link between each other. When I initially thought of doing this, I figured if I put the apps at different roots - /billing /support etc - then the links wouldn''t work at all, because

I am looking at using acts_as_versioned to manage revisions of data in several tables in my application. However, the default behavior of acts_as_versioned appears to apply to individual rows within a table. The tables I want to version are complicated lookup tables and what I really want is to version the entire contents of each table as a single set. Adding a row, deleting a row, or updating

How are you guys handling threads or server processes that have to, for example, process the data in your application on a periodic basis? Cron jobs can do it and then run on the database. But, are there ways to launch threads within the rails application itself. I have heard of WebBrick ways, but I am working with lighttpd, fastcgi? (textdrive if you are really interested).