return;\r
}else if(typeof(req.body.edit) != "undefined"){\r
var validator = new Validator();\r
- if(validator.Validate(req.body,config.alias))\r
+ var result = validator.Validate(req.body,config.alias,true);\r
+ if(result.length > 0)\r
{\r
- RenderMessage(res,validator.Message,req.session.items);\r
+ RenderMessage(res,result,req.session.items);\r
return;\r
}\r
async.waterfall([\r
{\r
if(typeof(req.body.registor) != "undefined"){\r
var validator = new Validator();\r
- if(validator.Validate(req.body,config.alias))\r
+ var result = validator.Validate(req.body,config.alias,false);\r
+ if(result.length > 0)\r
{\r
- RenderMessage(res,validator.Message,req.session.items);\r
+ RenderMessage(res,result,req.session.items);\r
return;\r
}\r
async.waterfall([\r
//\r
function ProfileCollection()\r
{\r
- var MySQLPool = new require("./mysql_pool.js");\r
var murmurhash = require("murmurhash");\r
- var pool = new MySQLPool({\r
- host : config.db_host,\r
- user : config.db_user,\r
- password : config.db_password,\r
- port : config.db_port,\r
- database : "webchat",\r
- });\r
+ var Profile = require("./init").GetProfileColletion;\r
this.AuthAsync = function(name,password,cb){\r
async.waterfall([\r
function(next){\r
- pool.query("SELECT password FROM profilelist WHERE name_hash = ? and name = ?",[murmurhash.v3(name),name],next);\r
+ Profile.find({name_hash:murmurhash.v3(name), name:name}).done(next);\r
},\r
function(result,next){\r
- if(result[0].password == md5_hex(password))\r
+ if(result.password == md5_hex(password))\r
next(null,true);\r
else\r
next(null,false);\r
],cb);\r
}\r
this.GetAsync = function(name,cb){\r
- pool.query("SELECT * FROM profilelist WHERE name_hash = ? and name = ?",[murmurhash.v3(name),name],cb);\r
+ Profile.find({name_hash:murmurhash.v3(name), name:name}).done(cb);\r
}\r
this.AddAsync = function(data,cb){\r
- var item = GetItem(data);;\r
- pool.query("INSERT INTO profilelist SET ?",[item],cb);\r
+ newProfile = Profile.build(GetItem(data));\r
+ newProfile.save().done(cb);\r
}\r
this.UpdatAsync = function(name,data,cb){\r
- var item = GetItem(data);\r
- pool.query("UPDATE profilelist SET ? WHERE name = ?",[item,name],cb);\r
+ Profile.update(GetItem(data),{name_hash:murmurhash.v3(name), name:name}).done(cb);\r
}\r
this.ClearAsync = function(cb){\r
- pool.query("TRUNCATE TABLE profilelist",null,cb);\r
+ Profile.drop().done(cb);\r
}\r
this.RemoveRangeAsync = function(names,cb){\r
- pool.query("DELETE FROM profilelist WHERE name IN (?)",[names],cb);\r
+ Profile.destroy({where:{\r
+ in:[names]\r
+ }\r
+ }).done(cb);\r
}\r
this.RemoveAsync = function(name,cb){\r
- pool.query("DELETE FROM profilelist WHERE name_hash = ? and name = ?",[murmurhash.v3(name),name],cb);\r
+ Profile.destroy({name_hash:murmurhash.v3(name), name:name}).done(cb);\r
}\r
this.FindByNameAsync = function(pattern,start,count,cb){\r
- pool.query("SELECT * FROM profilelist WHERE name LIKE ? LIMIT ?,?",[pattern+"%",start,count],cb);\r
+ Profile.findAll({\r
+ offset:start,\r
+ limit:count,\r
+ where:{\r
+ like:pattern\r
+ }\r
+ }).done(cb);\r
}\r
this.ToArrayAsync = function(start,count,cb){\r
- pool.query("SELECT name,lastmodified FROM profilelist LIMIT ?,?",[start,count],cb);\r
+ Profile.findAll({offset:start,limit:count}).done(cb);\r
}\r
\r
var crypto = require("crypto");\r
if(config.alias[key].visible_edit)\r
{\r
if(config.alias[key].type == "password")\r
- item[key] = md5_hex(data[key]);\r
+ {\r
+ if(data[key] != "")\r
+ item[key] = md5_hex(data[key]);\r
+ }\r
else if(data[key] == "" && typeof(config.alias[key].defaultvalue) != "undefined")\r
+ {\r
item[key] = config.alias[key].defaultvalue;\r
+ }\r
else\r
+ {\r
item[key] = data[key];\r
+ }\r
}\r
}\r
return item;\r
//\r
// @body バリテーションの対象となる連想配列\r
// @alias バリテーションを行う要素のリスト\r
- this.Validate = function(body,alias){\r
- var result = false;\r
- this.Message = new Array();\r
+ // @editflag 編集時なら真\r
+ this.Validate = function(body,alias,editflag){\r
+ var result = new Array();\r
for(var key in alias)\r
{\r
if(alias[key].visible_edit == false)\r
if(typeof(alias[key].isnotempty) != "undefined" &&\r
alias[key].isnotempty && body[key] == "")\r
message = resource.is_not_empty;\r
+ else if(typeof(alias[key].isnotemptyonregistor) != "undefined" &&\r
+ alias[key].isnotemptyonregistor && body[key] == "" &&\r
+ !editflag)\r
+ message = resource.is_not_empty;\r
else if(typeof(alias[key].mustmatchitem) != "undefined" &&\r
body[key] != body[alias[key].mustmatchitem])\r
message = util.format(resource.must_match_item,alias[alias[key].mustmatchitem].name); \r
else\r
message = IsValidate(body[key],alias[key].type,alias[key].rule);\r
if(message != null)\r
- {\r
- this.Message.push(alias[key].name + ":" + message);\r
- result = true;\r
- }\r
+ result.push(alias[key].name + ":" + message);\r
}\r
return result;\r
}\r
- // バリテーション時にエラーがあった場合、メッセージが記録される\r
- this.Message = "";\r
function IsValidate(data,type,rule){\r
if(typeof(data) == "undefined")\r
throw "data is undefined";\r