tag:blogger.com,1999:blog-91432418989430130792024-03-13T23:47:36.552-07:00pysqlcugghttp://www.blogger.com/profile/05516790837422736572noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-9143241898943013079.post-52270617653729127042011-04-07T20:05:00.000-07:002011-04-07T20:09:26.803-07:00My GSOC 2011 application<h1 id="toc2"><a href="http://www.blogger.com/" name="Milestones" style="display: inline-block;"></a><span style="font-size: large;">Abstract</span></h1><span style="color: #555555; display: block;"><span style="color: black;">I <span style="font-family: inherit;">would</span> like to work for the Python Software Foundation. More specifically I would like to create a python module to generate SQL strings, an idea proposed by the Tryton organization. The goal would be to have a pythonic syntax to simplify SQL strings generation in tryton and perhaps more generally in python.</span></span><span style="color: #555555; display: block;"><span style="color: black;"></span></span><span style="color: #555555; display: block;"><span style="color: black;">I would like to spend this summer practising coding in python. I think that this exercise corresponds perfectly to what I need to practice. <span style="color: black;">My goals are to develop my coding skills (means writting better code and learning python deeper) and to enter an open-source project in which I could continue to work for in the future.</span></span></span><br />
The Tryton gsoc 2011 wiki page: <a class="wiki_link_ext" href="http://code.google.com/p/tryton/wiki/gsoc2011" rel="nofollow">http://code.google.com/p/tryton/wiki/gsoc2011</a><br />
The idea: <a class="wiki_link_ext" href="http://code.google.com/p/tryton/wiki/gsoc2011ideas#Create_a_Python_module_to_generate_SQL_strings" rel="nofollow">http://code.google.com/p/tryton/wiki/gsoc2011ideas#Create_a_Python_module_to_generate_SQL_strings</a><br />
My blog page: <a href="http://pysql.blogspot.com/">http://pysql.blogspot.com/</a><br />
<br />
<h1 id="toc2"><a href="http://www.blogger.com/" name="Milestones" style="display: inline-block;"></a><span style="font-size: large;">Milestones</span></h1><span style="color: #555555; display: block;"><span style="color: black;">The final goal is to develop this python module to generate SQL strings with a well documented and tested code.<br />
I will develop testcase before each milestone based on the way this little sample has been written:</span></span><span style="color: #555555; display: block;"><span style="color: black;"><a href="http://codereview.appspot.com/4248045/">http://codereview.appspot.com/4248045/</a></span></span><span style="color: #555555; display: block;"><span style="color: black;"></span></span><span style="color: #555555; display: block;"><span style="color: black;">Here are the milestones I would define:</span></span><span style="color: #555555; display: block;"><span style="color: black;">1. Having a simple select query with alias working</span></span><span style="color: #555555; display: block;"><span style="color: black;">2. Add where clause</span></span><span style="color: #555555; display: block;"><span style="color: black;">3. Add possibility to use methods (such as Sum)</span></span><span style="color: #555555; display: block;"><span style="color: black;">4. Integrate Joins</span></span><span style="color: #555555; display: block;"><span style="color: #555555; display: block;"><span style="color: black;">5. Add "having"</span></span><span style="color: #555555; display: block;"><span style="color: black;">6. Add "group by" and "order by"</span></span></span><span style="color: #555555; display: block;"><span style="color: black;">7. Add delete, update and insert queries</span></span><span style="color: #555555; display: block;"><span style="color: black;">8. Add create, drop and alter queries</span></span><br />
<h2 id="toc3"><a href="http://www.blogger.com/" name="Milestones-Start of Program (May 24)" style="display: inline-block;"><strike></strike></a>Start of Program (May 24)</h2><span style="color: #555555; display: block;"><span style="color: black;">I will analyse the already existing tryton source to know the coding style and the way it is documented.</span></span><span style="color: #555555; display: block;"><span style="color: black;">I need to talk with the mentors about the way we will communicate.</span></span><br />
<br />
<h2 id="toc4"><a href="http://www.blogger.com/" name="Milestones-Midterm Evaluation (July 12)" style="display: inline-block;"></a>Midterm Evaluation (July 12)</h2><span style="color: #555555; display: block;"><span style="color: black;">I propose to delivrate the 6 first steps for the midterm evaluation.</span></span><br />
<br />
<h2 id="toc5"><a href="http://www.blogger.com/" name="Milestones-Final Evaluation (Aug 16)" style="display: inline-block;"></a>Final Evaluation (Aug 16)</h2><span style="color: #555555; display: block;"><span style="color: black;">If there is any change asked I would like to first apply them and reformat the code by taking into account criticisms and advices from the midterm evaluation. Then the 8 milestones would be delivrate for the final evaluation.</span></span><br />
<br />
<h1><a href="http://www.blogger.com/" name="About Me" style="display: inline-block;"><span style="font-size: large;"></span></a><span style="font-size: large;">About Me</span></h1><br />
<span style="color: #555555; display: block;"><span style="color: black; font-family: inherit;"></span></span><span style="color: #555555; display: block;"><span style="color: black; font-family: inherit;">I am Henri Bollig, I live in Liège in Belgium. I am studying computer science in high school (IPEPS Verviers) and should be graduated next year.</span></span><span style="color: #555555; display: block;"><span style="color: black;"></span></span><span style="color: #555555; display: block;"><span style="color: black;"></span></span><span style="color: #555555; display: block;"><span style="color: black;">I am a fluent java programmer and started to learn Python last year with <a href="http://learnpythonthehardway.org/">http://learnpythonthehardway.org/</a> . </span><span style="color: black;">I also learned SQL, C, C#, ASP and php at school and have a good understanding of mathematics.</span></span><br />
<span style="color: black;">I love the idea that knowledge should be shared and would like to be active in the open source community.</span><span style="color: black; font-family: inherit;"></span><br />
<h1 id="toc7"><a href="http://www.blogger.com/" name="Contact Info" style="display: inline-block;"></a><span style="font-size: large;">Contact Info</span></h1><br />
<strong>Name: Henri Bollig</strong><br />
<strong>Blog: <a href="http://pysql.blogspot.com/">http://pysql.blogspot.com/</a></strong><br />
<strong>Email: <a class="wiki_link_ext" href="mailto:henribollig99@gmail.com" rel="nofollow">henribollig99@gmail.com</a></strong><br />
<strong>XMPP:</strong><br />
<strong>Phone: xxx</strong><br />
<strong>Postal Address: Route du Maquisard 17</strong><br />
<strong>City, State, Zip, Country: La Reid, Liège, 4910, Belgium</strong> <br />
<span style="color: #555555; display: block;"></span>cugghttp://www.blogger.com/profile/05516790837422736572noreply@blogger.com0