similar to: Test Unit can't change data

Displaying 20 results from an estimated 10000 matches similar to: "Test Unit can't change data"

2006 Jan 30
11
Database Selection
Hi, I am a RoR newbie and I''ve been experimenting with different databases (mySQL, PostgreSQL, etc.) and different table types (MyISAM vs. InnoDB). Is there a preferred database/table type for RoR development. I like how MySQL''s InnoDB tables enforce referential integrity, but these tables require a lot more storage space then MyISAM tables. For everyone with a lot of RoR
2006 Mar 14
3
specifying table type
I''ve been creating my tables using the command line approach Dave advocates in AWD. I just noticed that they''re being created as MyISAM-type tables. I remember reading (but not where) that I should be creating these as InnoDB-type tables. So, two questions... 1) Is the table type important? (a "why" component to the answer would be nice too ;-) ) 2) If so, is
2006 Mar 24
10
innodb vs myisam
Hi, I have been using myisam tables in mysql with rails because my client will soon want fulltext searchable content, however when I migrated my development db from schema.rb all of the tables generated were innodb. I understand that I can override this, but also like the transactions and foreign keys of innodb. So 2 questions really: 1. are transactions in activerecord dependent on innodb or do
2005 Nov 19
14
FULLTEXT search in MySQL on rails
I tried adding a FULLTEXT search index to a table of mine in MySQL, only to discover that the InnoDB table format doesn''t seem to support this feature. Switching to the MyISAM table type seemed to work, but I seem to have some recollection that ActiveRecord transactions aren''t fully atomic on MyISAM tables. Is this true or am I just remembering wrong? If so, does anyone have
2017 Sep 16
4
R Configuration Variable: Maximum Memory Allocation per R Instance
Dear R Developers, In the same way that MySQL/MariaDB's Engine InnoDB or MyISAM/Aria have the innodb_buffer_pool_size or the key_buffer_size for setting the maximum amount of RAM which can be used by a Server Instance: ?Would it be possible to create an R Configuration Variable which fixes the maximum amount of RAM memory to be used as Commit / Dynamic Memory Allocation? Thank you. Juan
2007 Dec 18
3
MySQL transactions not working in unit tests?
I just installed acts_as_authenticated into an app and one of its unit tests is failing. The cause is that another unit test''s changes to the AAA fixtures aren''t being rolled back. I''m confused, since I have transactional fixtures turned on and MySQL InnoDB engine being used. Details: - MySQL 5.0.24. InnoDB is the default engine, all tables in the test db are using the
2008 Feb 13
2
rspec & table type MyISAM
i''m using a table, that uses fulltext search and therefore the table type MyISAM everything works fine in production mode, but tests fail with ActiveRecord::StatementInvalid: Mysql::Error: The used table type doesn''t support FULLTEXT indexes when looking in the test db it''s clear, that it''s using InnoDB, but even manually changing the table type does not help,
2005 Feb 04
1
New rails user database question
I''m currently using Perl, Class::DBI, Template Toolkit on top of Mysql and I''m about to try my hand at a first Rails app. The power of Rails and Ruby has me very intrigued... The O-R mapping in Class::DBI seems to be covered by AR, so I''m hoping it is a workable proposition. I plan to build a simple test case to get up to speed before converting a large production
2006 Jan 12
1
Best Forum? Was: Migration doesn''t seem to preserve create_table options in schema
Hi, is this the best forum to answer this question? Is there any better source for information or another mailinglist to address this question to? Cheers, Mariano ---------- Forwarded message ---------- From: Mariano Kamp <mariano.kamp@gmail.com> Date: Jan 8, 2006 6:24 PM Subject: Migration doesn''t seem to preserve create_table options in schema To: rails@lists.rubyonrails.org
2015 May 31
1
Using Mariadb databases from old server
------------ Original Message ------------ > Date: Saturday, May 30, 2015 12:27:26 AM -0400 > From: Ted Miller <tedlists at sbcglobal.net> > > On 05/29/2015 07:00 AM, Timothy Murphy wrote: >> Todor Petkov wrote: >> >>>> I'm running CentOS-7, but I left some MySQL databases >>>> on my old CentOS-6.5 partition which I'd like to retrieve.
2006 Apr 22
7
Proper Database Design For A Newbie
Hi all, I am starting out learning Ruby on Rails (coming from a PHP background) and I have a question about proper database design. Let me give you a quick example of what I want to do: Database: CREATE TABLE `users` ( `id` int(11) NOT NULL auto_increment, `login` varchar(40) default NULL, `email` varchar(100) default NULL, `crypted_password` varchar(40) default NULL, `salt`
2007 Jan 30
2
How to use migrations to convert engine type to InnoDB?
I''ve been looking through some references but can''t seem to find the right syntax and commands. I basically just want to have a migration to convert my db and all my tables to InnoDB. Does anyone know a tutorial or the migration syntax to do this? Thanks in advance :-) --~--~---------~--~----~------------~-------~--~----~ You received this message because you are
2006 May 18
1
rails & mysql
so for relational associations, do i need to actually be using an rdbms like innodb or bdb? or can i get away with myisam and assume that telling ruby how i want the tables related will be good enough (ie, has_one, has many, etc)?
2010 Nov 10
1
Oracle charging for InnoDB support in MySQL : what is going to change for us?
Hi, I've noticed that Oracle is charging for the MySQL version that supports InnoDB (http://www.mysql.com/products/). I could not find any other link with direct confirmation of what is going to change for the existing servers/versions and I was wondering if anybody has a more detailed info. For example, is RHEL (and CentOS) going to drop support for it? Are we going to see any further
2009 Feb 23
1
Help with R and MySQL
Hello, This forum has been very helpful to me in the past, and I've run out of ideas on how to solve my problem. I had been using R and MySQL (and Perl) together for quite some time successfully on my Windows XP machine. However, I recently had some problems with MySQL (the ibdata file had become 35GB on my hard drive, turns out it's a known bug with InnoDB), and ultimately the way I
2008 Feb 15
17
centralized or decentralized puppet infrastructure
Hi All, In my companies environment, we have multiple sites in multiple geographic locations, sometimes with high latency between the sites. I''m trying to come up with a solution that could provide puppet infrastructure to all sites nodes. ----a few assumptions--- - puppet manifest / configuration is fetched from a centralized version control system. - store db is needed (ssh keys,
2009 Apr 15
3
MySQL On ZFS Performance(fsync) Problem?
Hi,all I did some test about MySQL''s Insert performance on ZFS, and met a big performance problem,*i''m not sure what''s the point*. Environment 2 Intel X5560 (8 core), 12GB RAM, 7 slc SSD(Intel). A Java client run 8 threads concurrency insert into one Innodb table: *~600 qps when sync_binlog=1 & innodb_flush_log_at_trx_commit=1 ~600 qps when sync_binlog=10
2006 Mar 25
1
Re: Rails Digest, Vol 18, Issue 656
Here''s an alternative in-depth treatment on setting upo rails on Debian (Ubuntu, Kubuntu, ... ), may be interesting to follow through in more detail for some: The Perfect Rails/debian/lighttpd Stack... ( http://brainspl.at/pages/perfect_vps ) Victor Kane http://awebfactory.com.ar On 3/25/06, rails-request@lists.rubyonrails.org < rails-request@lists.rubyonrails.org> wrote: >
2006 Jul 06
1
Bug test di Rails
salve a tutti, sentite, non riesco a capire i test automatizzati di Rails. Secondo il libro, il ciclo di vita di un test prevede che per ogni metodo ( che sarebbe in pratica un test da eseguire ) si verificano sempre 3 eventi: 1) la cancellazione di tutti i record della tabella in esame 2) il caricamento di tutti i dati di test elencati nel file di fixture della tabella ( ad esempio
2005 Dec 23
4
OO model style: inheritance
Hi everybody I am totally new to rails and I am trying to start a tiny project to get familiar with rails. But I already got my first problem and I would be happy if somebody could point me in the best and cleanest direction. I am trying to develop a small gallery app. Since I would like to add more features in future I am trying to design a clean OO architecture of my models: The base object