Annotation of wikisrc/projects/project/atf-sql-backend.mdwn, revision 1.1

1.1     ! wiki        1: [[!template id=project
        !             2: 
        !             3: title="Create an SQL backend and statisticics/query page for ATF test results"
        !             4: 
        !             5: contact="""
        !             6: [tech-userlevel](mailto:tech-userlevel@NetBSD.org)
        !             7: """
        !             8: 
        !             9: mentors="""
        !            10: [Martin Husemann](mailto:martin@NetBSD.org)
        !            11: """
        !            12: 
        !            13: category="userland"
        !            14: difficulty="medium"
        !            15: duration="3 months"
        !            16: 
        !            17: description="""
        !            18: We are currently running various regular [tests](http://releng.netbsd.org/test-results.html), both on emulators and real hardware.
        !            19: The results are generated in ATF (or maybe sometime later in Kuya) raw XML output format and then transformed via xslt into html.
        !            20: This is good enough to display single test run results, but does not provide any overview or comparison options accross different test runs or architectures.
        !            21: 
        !            22: The target of this project is to provide a simmple 'upload' utility, that takes the xml input and inserts it into a remote PostgresSQL database.
        !            23: Creating a suitable database schema and the xml loader/upload tool is the first half.
        !            24: 
        !            25: Second part is using the collected results to display some nice web pages showing statistics and allowing dedicated queries, comparable
        !            26: to then query pages of typical bug tracking systems.
        !            27: 
        !            28: This project has the following milestones, in this order:
        !            29: 
        !            30: 1. Create and test a database schema (suitable for multiple architectures, and later migration to Kuya)
        !            31: 2. Create a tool to read the ATF xml data and insert it into a database. This will be the half term milestone.
        !            32: 3. Create a web site providing basic browsing/search options for the database
        !            33: 4. Enhance the upload tool (or create a second variant) for Kuya output. This part is optional
        !            34: 5. Document the database schema, web site setup, and tool created.
        !            35: 
        !            36: A huge set of ATF xml data will be provided, we assume that the student creates the database enviroment for local testing themselves.
        !            37: 
        !            38: The result is planed to be deployed on TNF servers later, so it is of direct use for the community.
        !            39: This deployment is not part of the GSoC timeline.
        !            40: """
        !            41: ]]
        !            42: 
        !            43: [[!tag gsoc]]

CVSweb for NetBSD wikisrc <wikimaster@NetBSD.org> software: FreeBSD-CVSweb