sfmagic.org Rewrite: Head-to-Head Working SQL Queries
.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...]
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...]
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...]
I didn’t have much time to work on the rewrite today, and spent what time I did have messing around with graphs.
[more...]
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...]
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...]
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...]
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...]
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...]
I again had little time to work on this, so today I replicated the page showing the information for an individual tournament.
[more...]
I didn’t get much time to work on this today, and forgot about one feeature that took a little more time.
[more...]
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...]
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...]
I finished duplicating the functionality of the old player info page tonight. I’m pretty happy with how that went.
[more...]
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...]
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...]
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...]
So far, this effort has not gone well, and none of that has anything to do with Pylons itself.
[more...]
While I’m generally averse to complete rewrites, I’m nevertheless going to redo sfmagic.org in Python.
[more...]