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
