Skip to content

Instantly share code, notes, and snippets.

@mimosz
mimosz / gist:5656491
Last active December 17, 2015 18:50
同步逻辑
String today = new SimpleDateFormat("yyyy-MM-dd").format(new Date());
String seller = "onitsukatiger官方旗舰店";
// 同步队列
SyncQueue ot = OT.orderQueue(seller, today);
Query sql = dbconn.createQuery("from Trade where seller_nick = ? and status = ? and (end_time between ? and ?)");
sql.setString(0, seller);
sql.setString(1, "TRADE_FINISHED");
sql.setString(2, today + " 00:00:00");
sql.setString(3, today + " 23:59:59");
@mimosz
mimosz / README.md
Last active December 17, 2015 03:49

API 调用说明

HTTP Header(必须包括):

{
  "Content-Type":"application/json",
  "X-App-Token":"应用密钥"
}
@mimosz
mimosz / gist:5530810
Created May 7, 2013 07:20
达尔文计划,整理宝贝SKU配图
user = User.all[11]
def get_value(cid, properties)
prop_ids = properties.split(':')
prop = ItemProp.where(_id: "#{cid}-#{prop_ids[0]}").first
return nil if prop.nil?
prop_value = prop.prop_values.where(vid: prop_ids[1]).first
return nil if prop_value.nil?
prop_value.name
@mimosz
mimosz / pi.rb
Created March 13, 2013 09:18
raspberry pi
# -*- encoding: utf-8 -*-
require 'wiringpi'
class Pi
def initialize(pins)
@pins = pins
@io = WiringPi::GPIO.new
@io.wiringPiMode(WPI_MODE_GPIO)
# 获取购买记录
def get_trades(crawler, item_id, seller_id, item_sbn, page=1)
start_at = Date.yesterday.beginning_of_day.to_i * 1000
end_at = Date.yesterday.end_of_day.to_i * 1000
# 购买列表
@mimosz
mimosz / gist:4372383
Created December 25, 2012 09:00
Ubuntu 下配置文件。
#! /bin/sh
### BEGIN INIT INFO
# Provides: nginx
# Required-Start: $syslog $remote_fs
# Required-Stop: $syslog $remote_fs
# Should-Start: $local_fs
# Should-Stop: $local_fs
# Default-Start: 2 3 4 5
# Default-Stop: 0 1 6
# Short-Description: nginx - Persistent key-value db
@mimosz
mimosz / gist:4303448
Created December 16, 2012 04:58
粗放的监测代理是否有效~~
# 未知的
unkown_list = [
"219.130.39.9:3128",
"122.225.22.22:8080",
"202.103.215.199:80",
"59.46.173.75:80",
"218.23.49.155:80",
"218.76.157.98:8001",
"218.84.126.82:3128"
]
@mimosz
mimosz / gist:4193799
Last active October 13, 2015 12:08
Sidekiq相关
uri = [
# 运动
"http://arcteryxjrh.tmall.com",
"http://sanfo.tmall.com",
"http://skomart.tmall.com",
"http://newbalance.tmall.com",
"http://thenorthface.tmall.com",
"http://asics.tmall.com",
"http://adidas.tmall.com",
"http://salomon.tmall.com",
@mimosz
mimosz / 1111.rb
Created November 14, 2012 19:29
超卖补货,部分依旧缺货。
user = User.last
# 订单列表
trades = CSV.read('trades.csv', 'rb:GB18030:UTF-8', headers: true, col_sep: ';')
trade_ids = []
@items = {}
trades.each do |trade|
trade_ids << trade['TID']
@items[trade['SKU']] = 0 unless @items.has_key?(trade['SKU'])
end
trade_ids.uniq!
@mimosz
mimosz / gist:4070722
Created November 14, 2012 06:54
超买计算
user = User.all[1]
date = '2012-11-11'.to_date
user.trades_sync(date)
user.orders_sync
skus_data = CSV.read('all_items.csv', 'rb:GB18030:UTF-8', headers: true, col_sep: ',')
items = {}
skus_data.each do |sku|
items[sku['SKU']] = 0 unless items.has_key?(sku['SKU'])
items[sku['SKU']] += sku['库存'].to_i