Logged-In As
ACCOUNT
Not Logged In
Write a GNATS to SQL converter script FreeBSD
Status: Closed Time to complete: 120 hrs Mentors: Eitan Adler, Wojciech A. Koszek Tags: script, Python, Perl, FreeBSD, SQL, GNATS, bug database

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.

Uploaded Work
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
Comments
Alex Rucker on December 2 2011 01:55 UTC Task Claimed

I would like to work on this task.

Eitan Adler on December 2 2011 02:20 UTC Task Assigned

This task has been assigned to Alex Rucker. You have 120 hours to complete this task, good luck!

Alex Rucker on December 6 2011 01:17 UTC Claim Removed

The claim on this task has been removed, someone else can claim it now.

Halil Ibrahim AZAK on December 6 2011 20:26 UTC ???

I have some questions.


How can we find the tasks?


Is it possible to do with PHP?

Gavin Atkinson on December 8 2011 19:00 UTC 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 

Halil Ibrahim AZAK on December 13 2011 20:13 UTC Gnats Database

Hi i want to do this task. How can i found gnats database?

Wojciech A. Koszek on December 14 2011 06:06 UTC GNATS can be uploaded via CVSup

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 


 


 


 

Alex Rucker on December 24 2011 00:19 UTC Task Claimed

I would like to work on this task.

Eitan Adler on December 24 2011 00:26 UTC Task Assigned

This task has been assigned to Alex Rucker. You have 120 hours to complete this task, good luck!

Alex Rucker on December 28 2011 23:06 UTC Ready for review

The work on this task is ready to be reviewed.

Melange on December 29 2011 00:26 UTC No more Work can be submitted

Melange has detected that the deadline has passed and no more work can be submitted. The submitted work should be reviewed.

Wojciech A. Koszek on December 29 2011 19:34 UTC Comments

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 


 

Wojciech A. Koszek on December 29 2011 21:42 UTC Task Needs More Work

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.

Eitan Adler on January 2 2012 03:18 UTC Thanks!

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.

Alex Rucker on January 6 2012 00:16 UTC How to submit work?

How should I submit the work for this task?

Eitan Adler on January 6 2012 02:32 UTC Anwering you

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@

Wojciech A. Koszek on January 6 2012 03:58 UTC Deadline extended

The deadline of the task has been extended with 2 days and 0 hours.

Wojciech A. Koszek on January 6 2012 03:59 UTC Try now

Just try now. I have extended the deadline for this task


 


Wojciech 

Melange on January 8 2012 05:25 UTC Task Reopened

Melange has detected that the final deadline has passed and it has reopened the task.

Alex Rucker on January 8 2012 05:28 UTC Task Claimed

I would like to work on this task.

Eitan Adler on January 8 2012 07:51 UTC Task Assigned

This task has been assigned to Alex Rucker. You have 120 hours to complete this task, good luck!

Alex Rucker on January 8 2012 17:23 UTC Ready for review

The work on this task is ready to be reviewed.

Eitan Adler on January 8 2012 19:18 UTC Task Closed

Congratulations, this task has been completed successfully.

Wojciech A. Koszek on January 8 2012 19:24 UTC Thanks!

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