query and change by multiple factors

Post #156,914 by tablizer 5/25/04 5:08:34 PM Reply	query and change by multiple factors Here's the search process: What screen? FooScreen. OK, go to the FooScreenMessages.properties file. What language? French. OK, go to the FooScreenMessages_fr.properties file. What message key? "some.error.message". OK, open FooScreenMessages_fr.properties file, hit 'ctrl-s' for search, and start typing the key 'some.error.message'. Yes, but if you have multiple screens to change, you end up opening and closing a bunch over and over again. Suppose you had a query like: \n select * from messages \n where appID='nerg'\n and screen='blah' and msgKey='zok' and language='french'\n Then you would only have to edit the search parameters for each one. (Some browsers can be made to prompt if you put a special marker in place of a parameter.) There is no open-open-open, close-close-close, open-open-open.... pattern that a file editor would have to keep going through. (Yeah, I know, you can write editor scripts.) And suppose we needed to change the word 'back' to 'previous' in multiple screens: \n select * from messages \n where msgText like '%back%' and language='english'\n We can then get a list, inspect it to see which ones need changing, and then change those we want. (I am assuming that we want to study each one rather than a sudden bulk change.) Your approach would take longer because you have to open and close each file/screen that needs a change. The query brings it all together in one edit-grid. In fact, the query approach will immediatly tell us how many need changing. You would have to go to grep first. ________________ oop.ismad.com
Post #156,916 by drewk 5/25/04 5:15:48 PM Reply	vim `grep -lr "search_term" *` === Implicitly condoning stupidity since 2001.
Post #156,919 by admin 5/25/04 5:19:28 PM Reply	No, no, no! Firing up Toad and running the same query in 6 different environments is MUCH better than doing that! Regards, -scott anderson "Welcome to Rivendell, Mr. Anderson..."
Post #156,941 by tablizer 5/25/04 6:24:32 PM Reply	grep is your SQL Firing up Toad and running the same query in 6 different environments is MUCH better than doing that! Toad would already be open. So grep and goofy command-line parameters are better? And each utility invents its own. ________________ oop.ismad.com
Post #156,997 by pwhysall 5/26/04 1:02:40 AM Reply	Of course it is :) Because "grep string files" is SO much HARDER than "SELECT stuff FROM tables WHERE string=somevalue ORDER BY something;", innit? Peter [link\|http://www.debian.org\|Shill For Hire] [link\|http://www.kuro5hin.org\|There is no K5 Cabal] [link\|http://guildenstern.dyndns.org\|Blog]
Post #157,004 by tablizer 5/26/04 1:44:31 AM Reply	SQL requires much less parsing because "slots" predefined ________________ oop.ismad.com
Post #156,917 by admin 5/25/04 5:17:54 PM Reply	It doesn't work that way. Shared messages are in one file. And your ignoring the issue of promoting these changes through the environments. Until you understand that, all of this is really hand-waving. You're adding nothing other than overhead. Your approach would take longer because you have to open and close each file/screen that needs a change. It might if that were an actual change that occurred. You're inventing problems. Or let's say you're not. Let's say that someone actually comes up with that change, once. WHO CARES? You're adding overhead and complexity for one lousy change that might happen once. Sounds like a pain in the ass to me. And are you going to concede that we aren't exactly unfamiliar with databases and their uses here? Regards, -scott anderson "Welcome to Rivendell, Mr. Anderson..."

Welcome to IWETHEY!