[Twisted-Python] Twisted source, changes and social analysis

[exarkun at twistedmatrix.com]

On 28 Mar, 05:16 pm, jonathan at stoppani.name wrote:
>Hello everybody (with access to the Trac DB),
>
>I am currently doing my master thesis on the "analysis and management
>of change propagation in complex systems". I'm concentrating my
>efforts on software-based complex systems.
>
>As part of my analysis, I gather data from different domains, such as
>dependencies between modules of the source code, interactions between
>people (like, for example, this mailing list) and change requests (in
>this specific case, issues and tickets on an issue tracking system).
>
>A couple of weeks ago I asked on IRC if it would be possible to get
>the Trac data from twistedmatrix.com and I was told to write a script
>to dump the database by excluding sensitive information.
>
>The script is up for review and auditing over here:
>
>https://gist.github.com/GaretJax/5264941
>
>It can be run by saving it to a .py file or directly with the following 
>command:
>
>curl -s 
>https://gist.github.com/GaretJax/5264941/raw/c478c2c4ec39cdb4bc3ceeb05d57a31063a0a486 
>/dump-trac.py
>| python - <projenv> <outfile>
>
>(by replacing the two arguments: trac base directory and the output 
>file).
>
>There are no privacy concerns, as all data being analyzes is publicly
>available, either in the repository, in the mailing list archives or
>on twistedmatrix.com
>
>After being reviewed, can someone with access to the server please run
>it for me?

Hi Jonathan,

A couple questions about the script.  There are a few more tables in the 
database that I'm not sure will be interesting to you.

Do you mind if we also exclude:

    spamfilter_bayes
    spamfilter_log

Some of the tables are also basically an inefficient mirror of the 
subversion repository - revision, node_change.  Do you want this data as 
well?

Lastly, I have some reluctance to distribute the contents of the 
permission table.  I could probably be easily convinced to do so, but if 
you don't thing you'll actually use that data, I'd just as soon not.

Thanks!
Jean-Paul
>Thanks,
>Jonathan
>
>P.S.: If someone would like more details about the research, a draft
>of the project statement can be found here:
>https://www.dropbox.com/s/qu3jpxcd4wpat2i/statement-0-r0-2013-03-19.pdf
>
>_______________________________________________
>Twisted-Python mailing list
>Twisted-Python at twistedmatrix.com
>http://twistedmatrix.com/cgi-bin/mailman/listinfo/twisted-python