Or what if we only made the tool available only to those who know what they're doing? This way, we'll know that said people can go easy on the servers and if they screw up, they lose access.
On 10/26/07, Edward Chernenko edwardspec@gmail.com wrote:
Just a point about implementation. As was already written, it's impossible to allow users to execute their own selects, but we need to implement new queries by their requests quick, without writing tonns of same code each time.
What we can do: create some kind of repository which can be modified by any of those who have accounts on Toolserver. It would contain list of queries with placeholders ("?") for parameters. For example, query_id | query_text 1 SELECT user_id FROM user_ids WHERE user_name=? 2 SELECT page_namespace FROM page WHERE page_title=? ORDER BY page_namespace (this list may be written into mysql table).
User can inflict query by accessing some script common for all queries, which would find query by it's number (query_id) and print HTML form on GET (with textfields instead of placeholders) or results on POST.
All toolserver programmers should be able add/modify/delete any query in another form and receive query_id to be sent to users. All modifications must be written to special log and it should be possible to revert'em, of course. Single login with other ts sites (like MediaWiki) for this script would be appreciated.
-- Ed
Toolserver-l mailing list Toolserver-l@lists.wikimedia.org http://lists.wikimedia.org/mailman/listinfo/toolserver-l