similar to: how to disable auto-increment in primary key.

Displaying 20 results from an estimated 2000 matches similar to: "how to disable auto-increment in primary key."

2006 Feb 28
0
ActiveRecord: Legacy primary keys
Hi, I''m building a frontend for a legacy schema, with tables like this: CREATE TABLE `types` ( `a_type_cd` varchar(6) NOT NULL default '''', `a_type` varchar(30) NOT NULL default '''', PRIMARY KEY (`a_type_cd`) ); The primary key is specified by the user (not auto-generated), and needs to be updateable. I create the following a base class to
2010 Aug 19
1
Composite primary keys and :joins=>
I have a legacy db with the following simplified structure: Table-A: type_key, code_key, name, ... # PKs are type_key and code_key, there is no id col and I cannot alter this db Table-B: # each row has only the code as a foreign_key, the type_key is hard-coded to "FOOKEY" an_id, code, ... Models: class TableB < AR::Base set_table_name ''table_b''
2013 Oct 25
6
Migrate postgresql database to uuid
Hi all, I am using rails 3.1 and ruby 1.9.3,Now i want to use uuid concept in rails 3 for existing data so i did like :- create_table :posts, :id => false do |t| t.string :uuid, :limit => 36, :primary => true end ActiveRecord::Base.class_eval do # old rails versions set_primary_key ''uuid'' before_create :generate_uuid def generate_uuid self.id =
2006 May 15
8
set_table_name and self.table_name
I have some legacy tables that I used set_table_name on, I''m attempting to write a method that will get key value from a sequence table and then update it and return a value. I''m hoping to put this in the base ActiveRecord method so I would like to reference the table name with self.table_name or something... class Contacts < ActiveRecord::Base set_table_name
2006 Oct 31
4
Auto-increment lost during migration.
Hi. I get some strange results when using rename_column on a primary key in a migration. It seems like the migration script removes the auto-increment property if you rename a column. This is a minimal example. create_table :foo, :primary_key => :foo_id do |t| t.column "name", :string end # renaming the primary key makes auto-increment disappear. rename_column
2011 Oct 17
1
problem with auto increment in rails 3
hi, i am tried to use auto increment field for user_id field but it fails to do it create_table :users,:id => false,:primary_key => ''user_id'', :force => true do |t| t.integer :user_id,:auto_increment => true, :null => false t.string :name t.string :email t.timestamps end is there any syntax to do auto increment in rails
2010 Mar 30
1
Need help in speex..
Hi, Vipin, What you're going to want to do here is convert your 8-bit stereo samples into 16-bit mono samples and back again when you're done(*). What you are actually doing here, it sounds like, is feeding 2 8-bit mono samples into Jspeex, which expects 16-bit mono. So, the most-significant-byte is in the right channel, and more or less gets encoded/decoded properly, but the
2006 Apr 02
5
adding primary_key to join table using migrations
Hi list, My tag_question_user join table is not currently a full-blown model. It doesn''t have a primary key - just tag_id, question_id, and user_id. I now want to add a primary key to this model (because I want to add a "description" column as well so users can describe the tag. I''m not sure how to add this using migrations. Here is what I have: class AddNotesToTags
2006 Jul 07
5
link_to: link is missing id
I''m using a legacy table, where the unique id is not ''id'' I have a Model class like the following: class Article < ActiveRecord::Base set_primary_key "ARTICLE_ID" end however, using a link_to like the following (modified scaffolding), the link has no id value: <% for article in @articles %> <tr> <% for column in
2008 Jan 21
13
has_many with different primary key
I''ve got quite the ActiveRecord challenge, any help would be appreciated. In my current project Companies can have many reviews. class Company < ActiveRecord::Base has_many :reviews, :as => :reviewable end However, my company table, I have two different IDs to identify my company. id - This is the typical id we use for normal stuff other_company_id - This is the id we use
2006 May 18
8
Concatenated key
Hi all, I started playing a couple days ago with Rails and it find it very interesting. But I''m a bit stuck with making it work with a concatenated primary key. I want to use my own names for the DB fields and I''m using SQL Server 2005. My tables look roughly like this: CREATE TABLE USERS ( USR_ID VARCHAR(25) NOT NULL PRIMARY KEY, USR_PASS VARCHAR(25) ) CREATE TABLE
2006 Jan 17
15
legacy database and finder_sql nightmare!
This is my first rails app with a legacy database and I''m having a terrible time getting the models set up correctly. I have an order table that has a primary field named order_number. I have a name table with a primary of item_number. These two tables are liked by the item_number and the order_number, but not as you might think. If the order_number is 2500, then each entry in
2010 Jun 16
2
class methods from module where active rec is involved
I have a module as shown below and when I extend an active record to use it, I can not access the primary_key method. In a simple test program using a similar approach where active record is not involved, access to the class methods seems to work ok. What can I do to make this work or so that I can access the class methods ? ################################## require
2006 Nov 04
0
ActiveRecord, insert and not auto-incremented primary keys...
Hi, After playing while with ActiveRecord, I''m surprised it isn''t easier to insert data into a table whose primary key is not auto-incremented by the database server. The following code... --------------------------------------- -- MySQL database "test" --------------------------------------- CREATE TABLE gardens ( code integer NOT NULL, name
2009 May 07
13
what database field type should i use ??
in a database table if there is a field which has a certain set of fixed values. for example staus => {Single, Married, Divorced } OR state => {California, Albama, Olaska ...} so what should be preferred way out of the following for storing the values 1. Keep the field as "string(Rails)" VARCHAR(MySQL) itself ....and while showing the field just show the field value. 2. Keep
2006 Mar 12
5
AR - Migrations - how to use a varchar as primary key instead of int ?
Hi I''d like to have a varchar primary key named id instead of the default int id. Does anyone knows how to specify this from migrations ? Should I also specify something in the model class ? thanks! Thibaut -------------- next part -------------- An HTML attachment was scrubbed... URL: http://wrath.rubyonrails.org/pipermail/rails/attachments/20060312/797bca4b/attachment.html
2009 May 27
12
query on Ruby array
Looking for suggestions on following two queries. Query 1 ------------------------------ Are the two following lines of code different in Ruby / Rails ( in a *.html.erb) file. <% if @forms.count != 0 %> <!-- first code --> Vs. <% if @forms.count %> <!--second code --> @forms is an array of objects. Coming from "C" language development background, i thought
2006 Mar 09
2
turn off auto increment
Hello, I have an old table that handles sessions. the primary key is a field called session_id and is the actual session id like "8df838303ufdfu838" however when i do the following in the model: set_primary_key "session_id" and the following in the controller: @session_hash = { "session_id" => @session.session_id, "session_user_id" =>
2006 Apr 04
5
How to implement tag clouds using plugin?
The code on http://blog.craz8.com/articles/2005/10/28/acts_as_taggable-is-a-cool-piece-of-code is based on the acts_as_taggable gem,anybody has done that using the acts_as_taggable plugin?thanks! btw:the code above uses the tag_count method,which is defined in the gem: def tags_count(options = {}) options = {:order => ''count DESC''}.merge(options)
2010 Mar 28
3
Need help in speex..
Hi I am using Jspeex for my project which requires compression of audio in realtime..so far i managed to capture sound using java's sound.The capturing format i use is 8 bit 8khz ,stereo pcm.The captured sound is buffered and fed to encoder.Its fed to decoder,whose output is again buffered for sometime.But when i try to play it back i could hear sound only in right channel.Left channel is