<div dir="ltr">Hi Exarkun, <div><br></div><div style>Thanks for coming back with this.</div><div style><br></div><div style>No problem if we exclude the spam filter tables. I don't need them.</div><div style><br></div>
<div style>Concerning the svn tables, if they don't carry additional information linking revisions to other (trac-specific metadata), I don't need them either.</div><div style><br></div><div style>I can understand your concerns regarding the permissions table. I thought they may be useful to help determine a role of a specific user in the organization, if that is enough as argumentation perfect, otherwise we can leave them out as they are not my primary source of data.</div>
<div style><br></div><div style>Cheers,</div><div style>Jonathan</div><div style><br></div><div style><br></div></div><div class="gmail_extra"><br><br><div class="gmail_quote">On Fri, Apr 5, 2013 at 8:24 AM, <span dir="ltr"><<a href="mailto:exarkun@twistedmatrix.com" target="_blank">exarkun@twistedmatrix.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div class="HOEnZb"><div class="h5">On 28 Mar, 05:16 pm, <a href="mailto:jonathan@stoppani.name">jonathan@stoppani.name</a> wrote:<br>
>Hello everybody (with access to the Trac DB),<br>
><br>
>I am currently doing my master thesis on the "analysis and management<br>
>of change propagation in complex systems". I'm concentrating my<br>
>efforts on software-based complex systems.<br>
><br>
>As part of my analysis, I gather data from different domains, such as<br>
>dependencies between modules of the source code, interactions between<br>
>people (like, for example, this mailing list) and change requests (in<br>
>this specific case, issues and tickets on an issue tracking system).<br>
><br>
>A couple of weeks ago I asked on IRC if it would be possible to get<br>
>the Trac data from <a href="http://twistedmatrix.com" target="_blank">twistedmatrix.com</a> and I was told to write a script<br>
>to dump the database by excluding sensitive information.<br>
><br>
>The script is up for review and auditing over here:<br>
><br>
><a href="https://gist.github.com/GaretJax/5264941" target="_blank">https://gist.github.com/GaretJax/5264941</a><br>
><br>
>It can be run by saving it to a .py file or directly with the following<br>
>command:<br>
><br>
>curl -s<br>
><a href="https://gist.github.com/GaretJax/5264941/raw/c478c2c4ec39cdb4bc3ceeb05d57a31063a0a486" target="_blank">https://gist.github.com/GaretJax/5264941/raw/c478c2c4ec39cdb4bc3ceeb05d57a31063a0a486</a><br>
>/dump-trac.py<br>
>| python - <projenv> <outfile><br>
><br>
>(by replacing the two arguments: trac base directory and the output<br>
>file).<br>
><br>
>There are no privacy concerns, as all data being analyzes is publicly<br>
>available, either in the repository, in the mailing list archives or<br>
>on <a href="http://twistedmatrix.com" target="_blank">twistedmatrix.com</a><br>
><br>
>After being reviewed, can someone with access to the server please run<br>
>it for me?<br>
<br>
</div></div>Hi Jonathan,<br>
<br>
A couple questions about the script. There are a few more tables in the<br>
database that I'm not sure will be interesting to you.<br>
<br>
Do you mind if we also exclude:<br>
<br>
spamfilter_bayes<br>
spamfilter_log<br>
<br>
Some of the tables are also basically an inefficient mirror of the<br>
subversion repository - revision, node_change. Do you want this data as<br>
well?<br>
<br>
Lastly, I have some reluctance to distribute the contents of the<br>
permission table. I could probably be easily convinced to do so, but if<br>
you don't thing you'll actually use that data, I'd just as soon not.<br>
<br>
Thanks!<br>
Jean-Paul<br>
<div class="im">>Thanks,<br>
>Jonathan<br>
><br>
>P.S.: If someone would like more details about the research, a draft<br>
>of the project statement can be found here:<br>
><a href="https://www.dropbox.com/s/qu3jpxcd4wpat2i/statement-0-r0-2013-03-19.pdf" target="_blank">https://www.dropbox.com/s/qu3jpxcd4wpat2i/statement-0-r0-2013-03-19.pdf</a><br>
><br>
</div>>_______________________________________________<br>
>Twisted-Python mailing list<br>
><a href="mailto:Twisted-Python@twistedmatrix.com">Twisted-Python@twistedmatrix.com</a><br>
><a href="http://twistedmatrix.com/cgi-bin/mailman/listinfo/twisted-python" target="_blank">http://twistedmatrix.com/cgi-bin/mailman/listinfo/twisted-python</a><br>
<br>
_______________________________________________<br>
Twisted-Python mailing list<br>
<a href="mailto:Twisted-Python@twistedmatrix.com">Twisted-Python@twistedmatrix.com</a><br>
<a href="http://twistedmatrix.com/cgi-bin/mailman/listinfo/twisted-python" target="_blank">http://twistedmatrix.com/cgi-bin/mailman/listinfo/twisted-python</a><br>
</blockquote></div><br></div>