All assumptions aside, "rectest" and "salt" are usernames
not
databases/schemas according to the pasted config. If they were in fact
different databases/schemas, this problem could never have happened. While
different database brands may have tricks for ways to handle users and what
they perceive as a database/schema, the fact remains that if 2 literally
separate databases had been used this thread wouldn''t exist.
-Christian
On 5/2/06, "Glenn Stauffer" <alaxsxaq@gmail>
wrote:> In his database.yml file, development and production use the same
> database schema (salt); test uses a different schema (rectest).
>
> Now, if rectest did not have its own set of tables, but instead had
> full privileges (insert/update/delete) to the production tables with
> public synonyms hiding the fact that the production tables are in a
> different schema (making them accessible without the schema prefix),
> that might explain why rake would wipe the salt
> (production/development) tables when logged in as rectest.
>
> Glenn
>
> On 5/2/06, Christian R. Garner <olus@digitalapathy.net> wrote:
> >
> > When you run your functional tests, rake wipes the "test"
database clean
> and
> > recreates it based on what is in the "development" database.
Since it
> > appears you are using the same database for both, that would explain
why
> you
> > lost your data. In addition, if you omit the data needed to access
the
> > development database you will get an error like you described, because
> it''s
> > trying to read the development database to create the test database.
> >
> > Furthermore, the default database.yml file that gets created with a
new
> > rails instance has the following comment right before the
"test"
> database
> > block:
> >
> > # Warning: The database defined as ''test'' will be
erased and
> > # re-generated from your development database when you run
''rake''.
> > # Do not set this db to the same as development or production.
> >
> >
> > - Christian
> >
> > On 02/05/06, Jon <jonfgreg@gmail.com> wrote:
> > >
> > > Running the functional tests has deleted the data in my
production
> > > database!!! please help!! Using rails 1.1.1 + Oracle.
> > >
> > > This is my database.yml file :
> > >
> > > development:
> > > adapter: oci
> > > host: "V2:1521/TIM"
> > > username: salt
> > > password: oracle1
> > >
> > > test:
> > > adapter: oci
> > > host: "V2:1521/TIM"
> > > username: rectest
> > > password: oracletest
> > >
> > > production:
> > > adapter: oci
> > > host: "V2:1521/TIM"
> > > username: salt
> > > password: oracle1
> > >
> > >
> > > How did it happen. It seems impossible
> >
> > _______________________________________________
> > Rails mailing list
> > Rails@lists.rubyonrails.org
> > http://lists.rubyonrails.org/mailman/listinfo/rails
> >
>
>
> ------------------------------
>
> Message: 3
> Date: Tue, 2 May 2006 17:37:55 +0200
> From: Pradeep Sethi <psethi@gmail.com>
> Subject: [Rails] Re: web services on the client side
> To: rails@lists.rubyonrails.org
> Message-ID: <993b91e9f064e9a32ccdaa544c5737dd@ruby-forum.com>
> Content-Type: text/plain; charset=utf-8
>
> yes, you need apis/user_api.rb and you''d provide the method
signature
> for the api call there with api_method
>
> such as
>
> api_method find_user_by_id,
> :expects => {:id => :int},
> :returns => {:user }
>
> please note that I am not expert in this area. For complete info, see
> this HowTo article on rails site.
>
> http://wiki.rubyonrails.com/rails/pages/How+To+Consume+.NET+WebServices
>
> also, if you are trying to do anymore than basic web service stuff,
> ActionWebService might not meet your needs, you would need to check
> ''soap4r''.
>
> Hope that helps
>
> PS
>
>
>
> Josh Kieschnick wrote:
> > i am reading through chapter 20 of the agile web development book and
> > trying to figure out how to use web services. i set up two different
> > rails apps. one as the server and one as the client. setting up the
> > server seems to work fine. but when i use the example at the end of
the
> > chapter to set up a client, i get the following error when i open the
> > page:
> >
> > Missing API definition file in apis/user_api.rb
> >
> > Which is the filename for my user api on the server application. I
have
> > this in my controller:
> >
> > class RemoteInfoController < ApplicationController
> > web_client_api :user,
> > :soap,
> > "http://my_ip_address/server/backend/api"
> >
>
> --
> Posted via http://www.ruby-forum.com/.
>
>
> ------------------------------
>
> Message: 4
> Date: Tue, 02 May 2006 11:38:41 -0400
> From: Charlie Bowman <charlie@castlebranch.com>
> Subject: Re: [Rails] Alternatives to components?
> To: rails@lists.rubyonrails.org, ctmailinglists@gmail.com
> Message-ID: <1146584321.12954.304.camel@charlie.castlebranch.com>
> Content-Type: text/plain; charset="us-ascii"
>
> I use the very ugly method of putting alot code into the application
> helper and calling it on each page.
>
> On Tue, 2006-05-02 at 16:20 +0100, Chris T wrote:
>
> > I''m about to start work on sidebars for my app, but
I''ve heard a number
> > of people express doubts about them as the way to go (they are slow
&
> > apparently DHH regretted coming up with them components). What other
> > solutions are people using for this type of need (i.e.needing to call
an
> > action/view combo from within a view)?
> >
> >
> > _______________________________________________
> > Rails mailing list
> > Rails@lists.rubyonrails.org
> > http://lists.rubyonrails.org/mailman/listinfo/rails
> >
>
>
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL:
> http://wrath.rubyonrails.org/pipermail/rails/attachments/20060502/a03aee6a
> /attachment-0001.html
>
> ------------------------------
>
> Message: 5
> Date: Tue, 2 May 2006 17:40:51 +0200
> From: Lindsay Boyd <lindsay.boyd@ntlworld.com>
> Subject: [Rails] Re: Is there a link_to ''external url''?
> To: rails@lists.rubyonrails.org
> Message-ID: <0053c2f8e59c6258110a0cc29837c0f3@ruby-forum.com>
> Content-Type: text/plain; charset=utf-8
>
> David wrote:
> >
> > Google saves the day.
>
> Cheers David. That''s good to know.
>
> When I apply this to my app I now have a new problem: my app allows
> users to enter URLs with or without an ''http://''. When
the URLs are
> displayed, I want them to be linkable, so I can use link_to, but I have
> to check to see if ''http://'' is present. So, looks like I
will have to
> write my own method.
>
> thanks
> -Lindsay
>
>
> --
> Posted via http://www.ruby-forum.com/.
>
>
> ------------------------------
>
> Message: 6
> Date: Tue, 2 May 2006 17:41:01 +0200
> From: Josh Kieschnick <jjkiesch@gmail.com>
> Subject: [Rails] Re: web services on the client side
> To: rails@lists.rubyonrails.org
> Message-ID: <cb67c993bd1e5a81395dbb3857e916a6@ruby-forum.com>
> Content-Type: text/plain; charset=utf-8
>
> Pradeep Sethi wrote:
> > yes, you need apis/user_api.rb and you''d provide the method
signature
> > for the api call there with api_method
> >
> > such as
> >
> > api_method find_user_by_id,
> > :expects => {:id => :int},
> > :returns => {:user }
> >
>
> that''s what i have in apis/user_api.rb on the server application.
am i
> supposed to have it in both apps?
>
> --
> Posted via http://www.ruby-forum.com/.
>
>
> ------------------------------
>
> Message: 7
> Date: Tue, 2 May 2006 17:46:34 +0200
> From: Pradeep Sethi <psethi@gmail.com>
> Subject: [Rails] Re: [OT] RailsConf Tickets ?
> To: rails@lists.rubyonrails.org
> Message-ID: <78a57587278e78160aeaf8d947d34528@ruby-forum.com>
> Content-Type: text/plain; charset=utf-8
>
> Hi,
>
> I am also looking for 1 ticket for Rails-conf. If anybody has one,
> please contact me psethi at gmail.com
>
> Thanks,
>
>
> Pradeep
>
> Chad Humphries wrote:
> > I''m also in the market for a ticket. You can reach me at
chad [at]
> > spicycode [dot] com. Sorry for another OT post on the list.
> >
> > -Chad
> >
> > Katie Kelly wrote:
> >> Also, sorry for posting this to the forum. I couldn''t
figure out how
> to
> >> get Sebastian''s email address.
> >>
> >> Thanks,
> >> Katie
> >>
> >> Katie Kelly wrote:
> >>> Sebastian,
> >>>
> >>> I''m not going to be able to use my RailsConf
registration. Please
> email
> >>> me personally (kellykatie [at] gmail [dot] com) if you are
still
> looking
> >>> to go to the conference and would like to buy my registration
(face
> >>> value, of course).
> >>>
> >>> Thanks,
> >>> Katie
> >>>
> >>> Sebastian Friedrich wrote:
> >>>> Just in case -- if anybody has got a spare ticket for
RailsConf, i''d
> >>>> be very happy to buy it... I live in Chicago, so i can do
this on
> >>>> very short notice as well, should anybody not be able to
attend... :)
> >>>>
> >>>> Otherwise - this being Chicago - no question
there''ll be scalpers...
> :)
> >>>>
> >>>> Thanks,
> >>>> Sebastian
>
>
> --
> Posted via http://www.ruby-forum.com/.
>
>
> ------------------------------
>
> Message: 8
> Date: Tue, 2 May 2006 16:46:49 +0100
> From: "Douglas Livingstone" <rampant@gmail.com>
> Subject: Re: [Rails] Re: Adding classes without script\generate
> To: rails@lists.rubyonrails.org
> Message-ID:
> <563094460605020846l626491cfr7e4cafbbc204191c@mail.gmail.com>
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
> 2006/5/2, Pradeep Sethi <psethi@gmail.com>:
> > I figured out the error.
> >
> > I needed to restart my server every time, I make a change to the class
> > file (because it is not a controller and/or Model...)
> >
> > feel like stupi..... :)
> >
>
> In 1.1, you can add "include Reloadable" in the model so that you
> don''t have to restart the whole server.
>
> Douglas
>
>
> ------------------------------
>
> Message: 9
> Date: Tue, 2 May 2006 17:50:35 +0200
> From: Neil Johnson <shires82@yahoo.co.uk>
> Subject: [Rails] Installation problems
> To: rails@lists.rubyonrails.org
> Message-ID: <46150437c1b3810ed86d42325c766b04@ruby-forum.com>
> Content-Type: text/plain; charset=utf-8
>
> Complete newbite to ROR.
>
> I have installed Ruby, RubyGems, & Rails according to the information
at
> the following url: http://xmlareas.com/ruby-rails-howto.html on a copy
> of Fedora Core 4.
>
> If I run the gem list command I can see the various packages including:
> actionmailer(1.2.1)
> rails(1.1.2)
>
> However the installation instructions end and the next step is a
> tutorial creating an application. This instructs the use of the rails
> command to start a new app.
>
> On running the rails command I get the following:
> -bash: rails: command not found
>
> What''s missing?
>
>
>
> --
> Posted via http://www.ruby-forum.com/.
>
>
> ------------------------------
>
> Message: 10
> Date: Tue, 02 May 2006 11:56:42 -0400
> From: Charlie Bowman <charlie@castlebranch.com>
> Subject: Re: [Rails] Installation problems
> To: rails@lists.rubyonrails.org
> Message-ID: <1146585402.12954.328.camel@charlie.castlebranch.com>
> Content-Type: text/plain; charset="us-ascii"
>
> This my sound silly but have you ran:
> gem install rails?
>
> On Tue, 2006-05-02 at 17:50 +0200, Neil Johnson wrote:
>
> > Complete newbite to ROR.
> >
> > I have installed Ruby, RubyGems, & Rails according to the
information at
> > the following url: http://xmlareas.com/ruby-rails-howto.html on a copy
> > of Fedora Core 4.
> >
> > If I run the gem list command I can see the various packages
including:
> > actionmailer(1.2.1)
> > rails(1.1.2)
> >
> > However the installation instructions end and the next step is a
> > tutorial creating an application. This instructs the use of the rails
> > command to start a new app.
> >
> > On running the rails command I get the following:
> > -bash: rails: command not found
> >
> > What''s missing?
> >
> >
> >
>
>
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL:
> http://wrath.rubyonrails.org/pipermail/rails/attachments/20060502/a15551e9
> /attachment-0001.html
>
> ------------------------------
>
> Message: 11
> Date: Tue, 2 May 2006 11:58:52 -0400
> From: "Cody Fauser" <codyfauser@gmail.com>
> Subject: Re: [Rails] Re: RJS & Ajax question...
> To: rails@lists.rubyonrails.org
> Message-ID:
> <55bcd780605020858u4f599c3aq3ddb7feda4b2966d@mail.gmail.com>
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
> Rich,
>
> Move your code back to the rjs template and monitor the
> development.log with tail -f log/development.log
>
> Then install the FireBug browser extension for Firefox. FireBug will
> let you monitor the responses being returned by Rails to your browser
> for every Ajax call.
>
> If you populate the variable "items" within the controller and
have
> the same RJS code within an RJS template then the following call would
> be trying to access the controller''s local variable
"items" which is
> not in scope:
>
> page.replace ''todo'', :partial =>
''table'', :locals => {:items =>
> items}
>
> You could fix that by using @items
>
> On 5/2/06, Rich Warren <rwmlist@gmail.com> wrote:
> > Simo AddSW wrote:
> > > render(:template => ''your_template'',
:layout => false,
> :content_type
> > > => ''text/javascript'')
> >
> > Actually, this doesn''t work either.
> >
> > Here''s what I''m trying to do. When the user views
the item list, there
> > is an Ajaxed edit button at the end of the list. If the user clicks
that
> > button, an edit form is displayed below the list. This form is,
itself,
> > Ajax enabled. Clicking submit changes the list, then hides the form.
> >
> > I think I''m running into trouble because the Ajax form does
not exist
> > when the page is first displayed. So the form''s Ajax helpers
are not
> > able to set up something properly.
> >
> > Everything works fine as long as I call render :update in the
> > controller. But I would really like to maintain the separation between
> > the controller and view, and put the view-modification commands back
in
> > an .rjs template.
> >
> > Thanks again,
> >
> > -Rich-
> >
> > --
> > Posted via http://www.ruby-forum.com/.
> > _______________________________________________
> > Rails mailing list
> > Rails@lists.rubyonrails.org
> > http://lists.rubyonrails.org/mailman/listinfo/rails
> >
>
>
> --
> Cody Fauser
> http://www.codyfauser.com
>
>
> ------------------------------
>
> _______________________________________________
> Rails mailing list
> Rails@lists.rubyonrails.org
> http://lists.rubyonrails.org/mailman/listinfo/rails
>
>
> End of Rails Digest, Vol 20, Issue 39
> *************************************
