Description of a task
The target of this task is to research, whether conversion from GNATS to SQL database is possible.
Participant must mirror at least 2000 tasks from the GNATS database, create SQL tables based on the GNATS database bug format, and write a script, which will bring bug reports from ASCII to SQL database.
No specific technology is required for this task. Script can be written in any modern programming language. Perl is well known to be suitable for text processing, but using Perl for this task isn't a requirement.
Task Requirements
Please read http://wiki.FreeBSD.org/GoogleCodeIn/GettingStarted before accepting this task, as it contains further details on what this task consists of, as well as providing useful information on how to obtain the page source and how to proceed with the task.
Additionally, students will need to obtain a copy of the GNATS database. The instructions for doing this can be found at http://www.freebsd.org/doc/handbook/cvsup.html , your mentors will be able to help you should you have issues downloading the database.
| File name/URL | File size | Date submitted | |
|---|---|---|---|
| gnats2sql.tar.bz2 | 194.8 KB | December 28 2011 23:03 UTC | |
| gnats2sql.tar.xz | 839.3 KB | January 08 2012 17:20 UTC | |
| gnats2sql_db.tar.xz | 5.7 MB | January 08 2012 17:23 UTC |
I would like to work on this task.
This task has been assigned to Alex Rucker. You have 120 hours to complete this task, good luck!
The claim on this task has been removed, someone else can claim it now.
I have some questions.
How can we find the tasks?
Is it possible to do with PHP?
Hi,
PHP would be fine if that is the language you are most comfortable with. This task is primarily to research ways to achieve the task - the ideas and methods are much more important than which language the work is done in.
Thanks.
Gavin
Hi i want to do this task. How can i found gnats database?
Hello,
Here you have an explanation on what the CVSUp is and how to use it.
http://www.freebsd.org/doc/handbook/cvsup.html
Look at the "gnats release=current" stuff. You should be able to
obtain GNATS bug reports that way.
Wojciech
I would like to work on this task.
This task has been assigned to Alex Rucker. You have 120 hours to complete this task, good luck!
The work on this task is ready to be reviewed.
Melange has detected that the deadline has passed and no more work can be submitted. The submitted work should be reviewed.
Alex,
This looks excellent. Very promising!
Please include 'usage' subroutine in gnats2sql.
If possible, please format README to be 80-column. It's highly adviced to have a license there and your name. In general, all *.py files should have a license. If possible, BSDv2 (2 clause license) is recommended. Include e-mail address in the Licence (The (c) 2011 <author> <email@addres>".
Please include instructions for mirroring GNATs database too. Make it as short as possible.
Below suggestions are optional and are not necessary, but will make your work more useful.
In the most perfect case, you might want to have gnats2sql.tar.gz and gnats2sql_db.tar.gz. 1st one would unpack to gnats2sql directory. 2nd one would unpack to gnats2sql_db. 2nd one would be 200-1000 GNATS bug reports, and would provide a way to do 'live demo' of your program.
And gnats2sql/ directory could have a Makefile with 'usage' message printed as a default target, while it would start conversion to default 'database' file, when you hit 'make convert'. So, in other words, 'make convert' should trigger ./gnats2sql with GNATS path in ../gnats2sql_db.
The faster FreeBSD bugbusting people can get started with your script, the more impact it can have.
Thanks a lot for doing this project!
Wojciech
One of the mentors has sent this task back for more work. Talk to the mentor(s) assigned to this task to satisfy the requirements needed to complete this task, submit your work again and mark the task as complete once you re-submit your work.
Hey,
I just want to reiterate Wojciech's comments above and add one more:
- the error messages could be a bit more informative (and placed in stderr instead of stdout):
%./gnats2sql convert
Error
doesn't help much. :)
Thank you very much for working on this task. As you may have seen GNATS isn't the greatest tool and this will help us move foward with a number of projects.
How should I submit the work for this task?
The same way you did it before would be okay. If you can't upload it there for some reason feel free to email it to me (eadler@) and wkoszek@
The deadline of the task has been extended with 2 days and 0 hours.
Just try now. I have extended the deadline for this task
Wojciech
Melange has detected that the final deadline has passed and it has reopened the task.
I would like to work on this task.
This task has been assigned to Alex Rucker. You have 120 hours to complete this task, good luck!
The work on this task is ready to be reviewed.
Congratulations, this task has been completed successfully.
Alex,
Thanks for working on this task! Let us know if you'd like to continue supporting FreeBSD.
Your skillset would be very welcome!
Wojciech