joshsmith

What did I get done yesterday?

• Code spike for product image cropping
• Moving reissued-api to codeship
• Design changes for product editing/uploading

What's left for this week and what's my plan for today?

• Add a missing image
• Add processing state for images

joshsmith

### What did I get done yesterday?
- Pushed to production
- Assigned all of the design tasks for finishing up product upload

### What's left for this week and what's my plan for today?
**Reissued**
- [4] Create wireframes `today`
- [4] When a product listing filter has no products, a user should see an empty state
- [2] Write testing document for Cat/Sally/Jenna to QA
- [8] Implement merchant upload design changes from Scotty

joshsmith

<?php

$s = new SphinxClient;
$s->setServer("localhost", 9312);
$s->setMatchMode(SPH_MATCH_ANY);
$s->setSortMode(SPH_SORT_RELEVANCE);
$s->setMaxQueryTime(3);
$s->setLimits(0,10);
$s->addQuery('test', 'test1');

joshsmith

CREATE TABLE search_table (
  id INT(10) UNSIGNED NOT NULL,
  weight INTEGER NOT NULL,
  query VARCHAR(3072) NOT NULL,
  group_id INTEGER, INDEX(query)
) ENGINE=SPHINX CONNECTION="sphinx://localhost:9312/test1";

joshsmith

mysql> SELECT * FROM interests JOIN search_table ON (interests.iid = search_table.id) WHERE query='philosophy of science;mode=any';
+-----+-----------------------+------+---------------------+----+--------+--------------------------------+----------+
| iid | title                 | body | modified            | id | weight | query                          | group_id |
+-----+-----------------------+------+---------------------+----+--------+--------------------------------+----------+
|  31 | Philosophy of Science | NULL | 2010-08-01 01:36:26 | 31 |      6 | philosophy of science;mode=any |        0 |
|  30 | Philosophy            | NULL | 2010-08-01 01:36:22 | 30 |      1 | philosophy of science;mode=any |        0 |
|  32 | Philosophy of Math    | NULL | 2010-08-01 01:36:30 | 32 |      1 | philosophy of science;mode=any |        0 |
+-----+-----------------------+------+---------------------+----+--------+--------------------------------+----------+

joshsmith

CREATE TABLE timezones (
  tid INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
  timezone VARCHAR(30) NOT NULL
) ENGINE=InnoDB;

joshsmith

+-----+------------------------+----------+
| iid | title                  | count(*) |
+-----+------------------------+----------+
|  10 | Los Angeles            |        2 |
|   7 | Programming            |        1 |
|  14 | New York City          |        1 |
|  27 | Farmville              |        1 |
|  34 | Facebook               |        1 |
|  49 | University of Maryland |        1 |
+-----+------------------------+----------+

joshsmith

SELECT interests.iid, interests.title, COUNT(*)
FROM users_interests
JOIN interests ON interests.iid = users_interests.iid
WHERE users_interests.preference = 'dislike'
GROUP BY interests.iid
ORDER BY COUNT(*) DESC
LIMIT 10;

joshsmith

<?php

foreach($tzlist as $items) {
  foreach($items as $item) {
    echo "INSERT INTO timezones (timezone) VALUES ('" . $item . "');";
  }
}

joshsmith

<?php

foreach($tzlist as $items) {
  foreach($items as $item) {
    echo "INSERT INTO timezones (timezone) VALUES ('" . $item . "');";
  }
}