23:52 15 Jan 2008.
Updated: 01:33 16 Jan 2008
Sadly, I’m not quite going to finish a drop-in replacement for the current sfmagic.org codebase by my deadline of tomorrow. I’m close, and I think I have everything except the data entry portion, which I’ll lay out in this post.
[more...]
23:57 14 Jan 2008
Unless I’m forgetting about something important, head-to-head is done.
[more...]
23:56 13 Jan 2008.
Updated: 01:52 14 Jan 2008
I haven’t had much time to work on the project over the weekend, but I have made some progress in getting the queries into SQLAlchemy form.
[more...]
23:52 11 Jan 2008.
Updated: 02:35 12 Jan 2008
I’ve stripped some fields from the h2hresults table, and I’ve created some queries that do what I want but may not be the right approach.
[more...]
23:53 10 Jan 2008.
Updated: 02:34 12 Jan 2008
I haven’t had much time to work on the rewrite, because I’ve had some serious computer problems at home—rather than being able to move from my laptop to the faster and more coding-suited (multiple monitors, better keyboard, etc.) desktop, I’m still on my laptop because my desktop is completely unstable and needs to be replaced.
[more...]
23:46 08 Jan 2008.
Updated: 01:54 09 Jan 2008
I didn’t have much time to work on the rewrite today, and spent what time I did have messing around with graphs.
[more...]
23:57 07 Jan 2008
I didn’t have time to get stuck into head-to-head today. Instead I did the minor data cleaning and code tweaking required to generate the superset, or block, standings. While doing that I started thinking about unit testing for sfmagic.org.
[more...]
23:10 06 Jan 2008
Today most of my time on the project was spent setting it up on one of the machines in my home network, which may end up being its home once it’s ready and deployed.
[more...]
18:01 04 Jan 2008
Tracking head-to-head results is something I’ve been thinking about doing for quite some time. It’s an obvious feature, but I shied away from it first because it seemed complicated on the database side when I started the original site and later because the reporting interface seemed like it would have to be clunky.
[more...]
16:06 03 Jan 2008.
Updated: 05:29 04 Jan 2008
I now have standings tables for the seeding and the overall standings. These are generated from the limited data set I’m currently using, but the generation process works with incremental updates (as long as all tournaments on a given date are in the system before the generation is done).
[more...]
17:53 01 Jan 2008
I’m about 40 percent of the way to the new standings tables. I’ve also decided to keep going with the sfmagic.org posts for a while, as I didn’t start them on 1 December as intended because the second draft wasn’t finished.
[more...]
22:18 31 Dec 2007
I again had little time to work on this, so today I replicated the page showing the information for an individual tournament.
[more...]
22:29 30 Dec 2007
I didn’t get much time to work on this today, and forgot about one feeature that took a little more time.
[more...]
08:32 28 Dec 2007
The standings page is almost done. I have most of the functionality I want, running into problems only with the “last ten tournaments” standings.
[more...]
06:33 27 Dec 2007.
Updated: 00:06 18 Jan 2008
It took me less than an hour to go from the finished player page to a working basic version of the standings page (yay Python/Pylons/Genshi!). However, when running all the players (193 in the data set I’m using) against the entire set of results (2787 rows in this data set) it took more than thirty seconds to produce the page.
[more...]
20:35 25 Dec 2007
I finished duplicating the functionality of the old player info page tonight. I’m pretty happy with how that went.
[more...]
18:13 24 Dec 2007
It turns out that adding multiple WHERE clauses with SQLAlchemy’s SQL Expressions is very easy—you just tack them on using the where() function.
[more...]
18:43 23 Dec 2007
Progress hasn’t been significant since yesterday, I haven’t had that much time. Right now I’m at the point of reading in parameters from the query string (easy) and looking for the most efficient way to use SQLAlchemy’s SQL Expressions to construct constraining select statements based on those parameters (not quite so easy for me, given that my lack of knowledge about SQLAlchemy makes ‘most efficient’ a difficult bar to know I’ve reached). Along the way, I got distracted and amalgamated some other people’s answers to get a useful code snippet.
[more...]
19:10 21 Dec 2007
Having gone through some hoops trying to get this rather simple step to work, I can now talk to the database and have the results shown in a Genshi template.
[more...]
18:43 20 Dec 2007
This isn’t much of an update. Over the last two days I’ve been struggling with installing SQLAlchemy, a database wrapper/object-relational mapper for Python. It’s the default database interface layer in Pylons, and I had been anticipating easy setup and use for the simple side of the database transactions I want to do.
[more...]
17:51 18 Dec 2007
So far, this effort has not gone well, and none of that has anything to do with Pylons itself.
[more...]
12:11 17 Dec 2007.
Updated: 12:13 18 Dec 2007
At work we use the Pylons web framework, and I like it quite a lot, so I’m going to use it for sfmagic.org.
[more...]