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

1.1       wiki        1: [[!template id=project
                      3: title="Create an SQL backend and statisticics/query page for ATF test results"
                      5: contact="""
                      6: [tech-userlevel](
                      7: """
                      9: mentors="""
                     10: [Martin Husemann](
                     11: """
                     13: category="userland"
                     14: difficulty="medium"
                     15: duration="3 months"
                     17: description="""
                     18: We are currently running various regular [tests](, 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.
                     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.
                     25: Second part is using the collected results to display some nice web pages showing statistics and allowing dedicated queries, comparable
1.2     ! wiki       26: to the query pages of typical bug tracking systems.
1.1       wiki       27: 
                     28: This project has the following milestones, in this order:
                     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.
1.2     ! wiki       36: A huge set of ATF xml data will be provided, we assume that the student creates the database environment for local testing themselves.
1.1       wiki       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: ]]
                     43: [[!tag gsoc]]

CVSweb for NetBSD wikisrc <> software: FreeBSD-CVSweb