lemonhall / hksearch Goto Github PK

0、安装node.js wget http://nodejs.org/dist/v0.11.14/node-v0.11.14.tar.gz tar zxvf node-v0.11.14.tar.gz cd node-v0.11.14 ./confingure make make install

=============================================================== 1、创建工程 mkdir hkssearch

vim package.json { "name": "sf-hk-search", "version": "0.0.1", "description": "sf express", "dependencies": {}, "license": "MIT", "repository": { "type": "git" }, "readmeFilename": "Readme.md", "bugs": { "url": "https://github.com/visionmedia/co/issues" }, "homepage": "https://github.com/visionmedia/co" }

===============================================================

2、命令行当中输入 npm install express --save npm install body-parser --save npm install log4js --save npm install node-dev --save

===============================================================

3、server的模板 var express = require('express'); var bodyParser = require('body-parser'); var app = express();

// parse application/x-www-form-urlencoded app.use(bodyParser.urlencoded({ extended: true }));

// parse application/json app.use(bodyParser.json());

app.use(express.static('public'));

var todo = {};

var todos = [];

// app.get('/', function(req, res){ // res.send('hello world'); // });

app.get("/",function(req,res){ res.redirect('search.html'); });

app.listen(3000);

=================================================================== 4、安装nginx apt-get install nginx

vim /etc/nginx/sites-enabled/default

加入：

location / {
        proxy_set_header X-Real-IP $remote_addr;
        proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
        proxy_set_header Host $http_host;
        proxy_set_header X-NginX-Proxy true;
        proxy_pass http://127.0.0.1:3000/;
        proxy_redirect off;
}

===================================================================

5、新建一个启动测试用脚本

/root/hksearch/node_modules/node-dev/bin/node-dev server.js

===================================================================

6、mysql链接池

npm install mysql --save

参考：http://blog.fens.me/nodejs-mysql-intro/

var mysql = require('mysql');

var pool = mysql.createPool({ host: 'localhost', user: 'root', password: '123456', database: 'heike_product', port: 3306 });

var selectSQL = 'select * from product limit 1';

pool.getConnection(function (err, conn) { if (err) console.log("POOL ==> " + err);

    conn.query(selectSQL, function (err2, rows) {
        if (err2) console.log(err2);

        console.log("SELECT ==> ");
        for (var i in rows) {
            console.log(rows[i]);
        }

        conn.release();
    });

});

之后package.json文件的内容变成：

{ "name": "sf-hk-search", "version": "0.0.1", "description": "sf express", "dependencies": { "body-parser": "^1.9.2", "express": "^4.10.1", "log4js": "^0.6.21", "mysql": "^2.5.3", "node-dev": "^2.6.0" }, "license": "MIT", "repository": { "type": "git" }, "readmeFilename": "Readme.md", "bugs": { "url": "https://github.com/visionmedia/co/issues" }, "homepage": "https://github.com/visionmedia/co" }

===================================================================

7、mysql的链接组件 https://github.com/felixge/node-mysql

池化、自动重连、cluster化都支持

===================================================================

8、优化mysql本身的配置

===================================================================

9、数据库的字段

DB for Heike product: -- database: heike_product -- user: heike -- password: 123456

There are 2 tables in db heike_product: product templateblobfield

Rule for picture url: http://hkimg.sf-express.com/ Rule for product page url: http://www.sfheike.com/p_<product_id>.htm

Table templateblobfield use field "PRODUCT_ID" to associate with table product.

Search fields: product_name & searchkey

Sorting: -- Default: by create_time desc; -- Popularity: by visit_count; -- Price: by unit_price.

=================================================================== 10、数据库的字段

product表： { PRODUCT_NAME: '健司KENJI 健康时刻瑞士高山牛乳脆片 160g', UNIT_PRICE: 12.9, LIST_PRICE: 22, APP_USERCOUNT: 0, VISITCOUNT: 0, PRODUCT_ID: '002a41857' }

templateblobfield表: { ID: '8aefac984978d6be01498155d4996998', FIELD_ID: '', FIELD_VALUE: 'userfiles/product/img/20141106/big/big_big_1415214164241.jpg', PRODUCT_ID: '002a41857', FIELD_SMALLVALUE: 'userfiles/product/img/20141106/small/small_big_1415214164241.jpg', FIELD_CENTERVALUE: 'userfiles/product/img/20141106/center/center_big_1415214164241.jpg' } { ID: '8aefac984978d6be01498155d4ef6999', FIELD_ID: '', FIELD_VALUE: 'userfiles/product/img/20141106/big/big_big_1415214163826.jpg', PRODUCT_ID: '002a41857', FIELD_SMALLVALUE: 'userfiles/product/img/20141106/small/small_big_1415214163826.jpg', FIELD_CENTERVALUE: 'userfiles/product/img/20141106/center/center_big_1415214163826.jpg' } { ID: '8aefac984978d6be01498155d68d699a', FIELD_ID: '', FIELD_VALUE: 'userfiles/product/img/20141106/big/big_big_1415214164811.jpg', PRODUCT_ID: '002a41857', FIELD_SMALLVALUE: 'userfiles/product/img/20141106/small/small_big_1415214164811.jpg', FIELD_CENTERVALUE: 'userfiles/product/img/20141106/center/center_big_1415214164811.jpg' } { ID: '8aefac984978d6be01498155d6b9699b', FIELD_ID: '', FIELD_VALUE: 'userfiles/product/img/20141106/big/big_big_1415214164466.jpg', PRODUCT_ID: '002a41857', FIELD_SMALLVALUE: 'userfiles/product/img/20141106/small/small_big_1415214164466.jpg', FIELD_CENTERVALUE: 'userfiles/product/img/20141106/center/center_big_1415214164466.jpg' } { ID: '8aefac984978d6be01498155d85c699c', FIELD_ID: '', FIELD_VALUE: 'userfiles/product/img/20141106/big/big_big_1415214165301.jpg', PRODUCT_ID: '002a41857', FIELD_SMALLVALUE: 'userfiles/product/img/20141106/small/small_big_1415214165301.jpg', FIELD_CENTERVALUE: 'userfiles/product/img/20141106/center/center_big_1415214165301.jpg' } { ID: '8aefac984978d6be01498155d8c8699d', FIELD_ID: '', FIELD_VALUE: 'userfiles/product/img/20141106/big/big_big_1415214164980.jpg', PRODUCT_ID: '002a41857', FIELD_SMALLVALUE: 'userfiles/product/img/20141106/small/small_big_1415214164980.jpg', FIELD_CENTERVALUE: 'userfiles/product/img/20141106/center/center_big_1415214164980.jpg' } { ID: '8aefac984978d6be01498155da18699e', FIELD_ID: '', FIELD_VALUE: 'userfiles/product/img/20141106/big/big_big_1415214165748.jpg', PRODUCT_ID: '002a41857', FIELD_SMALLVALUE: 'userfiles/product/img/20141106/small/small_big_1415214165748.jpg', FIELD_CENTERVALUE: 'userfiles/product/img/20141106/center/center_big_1415214165748.jpg' } { ID: '8aefac984978d6be01498155dabe699f', FIELD_ID: '', FIELD_VALUE: 'userfiles/product/img/20141106/big/big_big_1415214165507.jpg', PRODUCT_ID: '002a41857', FIELD_SMALLVALUE: 'userfiles/product/img/20141106/small/small_big_1415214165507.jpg', FIELD_CENTERVALUE: 'userfiles/product/img/20141106/center/center_big_1415214165507.jpg' } { ID: '8aefac984978d6be01498155dbe069a0', FIELD_ID: '', FIELD_VALUE: 'userfiles/product/img/20141106/big/big_big_1415214166188.jpg', PRODUCT_ID: '002a41857', FIELD_SMALLVALUE: 'userfiles/product/img/20141106/small/small_big_1415214166188.jpg', FIELD_CENTERVALUE: 'userfiles/product/img/20141106/center/center_big_1415214166188.jpg' } { ID: '8aefac984978d6be01498155dc7969a1', FIELD_ID: '', FIELD_VALUE: 'userfiles/product/img/20141106/big/big_big_1415214165936.jpg', PRODUCT_ID: '002a41857', FIELD_SMALLVALUE: 'userfiles/product/img/20141106/small/small_big_1415214165936.jpg', FIELD_CENTERVALUE: 'userfiles/product/img/20141106/center/center_big_1415214165936.jpg' }

product表： { PRODUCT_ID: '002a41857', PRODUCT_NAME: '健司KENJI 健康时刻瑞士高山牛乳脆片 160g', UNIT_PRICE: 12.9, LIST_PRICE: 22, QUANTITY: 5, BRAND: '8aefac9b497114ef01497a2cfa7b3e31', MODEL: '', SPEC: '', UNIT: '盒', MANUFACTORY: '', RESELLER: '', PRODUCINGAREA: '', DESCRIPTION: '

===================================================================

11、对应的模板

￥{{UNIT_PRICE}}{{LIST_PRICE}}

{{PRODUCT_NAME}}

累计评价:{{APP_USERCOUNT}}          关注：{{VISITCOUNT}}次

====================================================================

12、模板引擎 官网：https://github.com/borismoore/jsrender 示例：http://www.jsviews.com/#samples

<script id="productTemplate" type="text/x-jsrender">
• 
  

  ￥{{>UNIT_PRICE}}{{>LIST_PRICE}}

  {{>PRODUCT_NAME}}

  累计评价:{{>APP_USERCOUNT}}          关注：{{>VISITCOUNT}}次

</script> <script type="text/javascript"> var products = [ { PRODUCT_NAME: '健司KENJI 健康时刻瑞士高山牛乳脆片 160g', UNIT_PRICE: 12.9, LIST_PRICE: 22, APP_USERCOUNT: 0, VISITCOUNT: 0, PRODUCT_ID: '002a41857' } ]; $("#productsList").html($("#productTemplate").render(products)); </script>

====================================================================

13、商品的状态问题

CHECK_STATUS = 1 AND store_check_status =1 AND uc_activation_status =1 AND uc_status = 1

====================================================================

14、对MYSQL的查询加上缓存