We already do that, we call it the toolserver.
On 10/26/07, James Hare <[EMAIL PROTECTED]> wrote:
>
> 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 <[EMAIL PROTECTED]> 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
> > [email protected]
> > http://lists.wikimedia.org/mailman/listinfo/toolserver-l
> >
>
>
> _______________________________________________
> Toolserver-l mailing list
> [email protected]
> http://lists.wikimedia.org/mailman/listinfo/toolserver-l
>
>
--
ST47
Administrator, en.wikipedia
_______________________________________________
Toolserver-l mailing list
[email protected]
http://lists.wikimedia.org/mailman/listinfo/toolserver-l
