static NEOERR* dyn_cmd_addtrack(struct queue_entry *q, struct cache *cd, mdb_conn *db)
{
STRING str; string_init(&str);
char *aname, *uname, *oname;
int aid, uid, oid = 0;
NEOERR *err;
REQ_GET_PARAM_STR(q->hdfrcv, "uname", uname);
REQ_GET_PARAM_STR(q->hdfrcv, "aname", aname);
REQ_FETCH_PARAM_STR(q->hdfrcv, "oname", oname);
uid = hash_string(uname);
aid = hash_string(aname);
if (oname) oid = hash_string(oname);
hdf_set_int_value(q->hdfrcv, "aid", aid);
hdf_set_int_value(q->hdfrcv, "uid", uid);
hdf_set_int_value(q->hdfrcv, "oid", oid);
err = mcs_build_incol(q->hdfrcv,
hdf_get_obj(g_cfg, CONFIG_PATH".InsertCol.track"),
&str);
if (err != STATUS_OK) return nerr_pass(err);
MDB_EXEC(db, NULL, "INSERT INTO track %s", NULL, str.buf);
string_clear(&str);
return STATUS_OK;
}
/*
* input : aname(STR) asn(STR) masn(STR) email(STR) state(INT)
* return: NORMAL REP_ERR_ALREADYREGIST
* reply : NULL
*/
static NEOERR* aic_cmd_appnew(struct queue_entry *q, struct cache *cd, mdb_conn *db)
{
char *aname, *pname, *asn, *masn, *email;
int aid, pid = 0, state;
NEOERR *err;
REQ_GET_PARAM_INT(q->hdfrcv, "state", state);
REQ_GET_PARAM_STR(q->hdfrcv, "aname", aname);
REQ_GET_PARAM_STR(q->hdfrcv, "asn", asn);
REQ_GET_PARAM_STR(q->hdfrcv, "masn", masn);
REQ_GET_PARAM_STR(q->hdfrcv, "email", email);
REQ_FETCH_PARAM_STR(q->hdfrcv, "pname", pname);
aid = hash_string(aname);
if (pname) pid = hash_string(pname);
err = aic_cmd_appinfo(q, cd, db);
nerr_handle(&err, REP_ERR_NREGIST);
if (err != STATUS_OK) return nerr_pass(err);
if (hdf_get_obj(q->hdfsnd, "state"))
return nerr_raise(REP_ERR_ALREADYREGIST, "%s already regist", aname);
MDB_EXEC(db, NULL, "INSERT INTO appinfo (aid, aname, "
" pid, asn, masn, email, state) "
" VALUES ($1, $2::varchar(256), $3, $4::varchar(256), "
" $5::varchar(256), $6::varchar(256), $7);",
"isisssi", aid, aname, pid, asn, masn, email, state);
cache_delf(cd, PREFIX_APPINFO"%d", aid);
if (pid > 0) {
cache_delf(cd, PREFIX_APPOUSER"%d_0", pid);
}
return STATUS_OK;
}
static NEOERR* city_cmd_s(struct city_entry *e, QueueEntry *q)
{
unsigned char *val = NULL; size_t vsize = 0;
char *p = NULL, *c;
NEOERR *err;
mdb_conn *db = e->db;
struct cache *cd = e->cd;
REQ_GET_PARAM_STR(q->hdfrcv, "c", c);
REQ_FETCH_PARAM_STR(q->hdfrcv, "p", p);
if (cache_getf(cd, &val, &vsize, PREFIX_CITY"%s.%s", p, c)) {
unpack_hdf(val, vsize, &q->hdfsnd);
} else {
if (p) {
char tok[64] = {0};
strncpy(tok, p, 64);
if (!strstr(p, "省") && !strstr(p, "区"))
snprintf(tok, sizeof(tok), "%s省", p);
MDB_QUERY_RAW(db, "city", _COL_CITY, "s=$1", "s", tok);
mdb_set_row(q->hdfsnd, db, _COL_CITY, "province", MDB_FLAG_NO_ERR);
}
MDB_QUERY_RAW(db, "city", _COL_CITY, "s=$1", "s", c);
err = mdb_set_rows(q->hdfsnd, db, _COL_CITY, "citys", NULL, MDB_FLAG_Z);
if (nerr_handle(&err, NERR_NOT_FOUND)) {
if (strstr(c, "市")) c[strlen(c)-3] = '\0';
MDB_QUERY_RAW(db, "city", _COL_CITY, "s=$1", "s", c);
err = mdb_set_rows(q->hdfsnd, db, _COL_CITY, "citys",
NULL, MDB_FLAG_EMPTY_OK);
}
if (err != STATUS_OK) return nerr_pass(err);
/*
* get city's parents
*/
int cnt = 0;
char *pid = hdf_get_valuef(q->hdfsnd, "citys.0.pid");
while (pid && atoi(pid) > 0) {
MDB_QUERY_RAW(db, "city", _COL_CITY, "id=%d", NULL, atoi(pid));
err = mdb_set_rows(q->hdfsnd, db, _COL_CITY, "citys", NULL, MDB_FLAG_Z);
TRACE_NOK(err);
pid = hdf_get_valuef(q->hdfsnd, "citys.%d.pid", ++cnt);
}
/*
* 北京市 has no subcities
*/
/*
int id = hdf_get_int_value(q->hdfsnd, "city.id", 0);
MDB_QUERY_RAW(db, "city", _COL_CITY, "pid=%d", NULL, id);
err = mdb_set_rows(q->hdfsnd, db, _COL_CITY, "subcities",
NULL, MDB_FLAG_EMPTY_OK);
if (err != STATUS_OK) return nerr_pass(err);
*/
CACHE_HDF(q->hdfsnd, CITY_CC_SEC, PREFIX_CITY"%s.%s", p, c);
}
return STATUS_OK;
}
