Meituan RESTful API

A RESTful API aggregating deal data from Meituan and other Chinese group-buying platforms (Hao123 Tuan, Tuan800). Built as a personal Node.js learning project, it ran in a production environment for several months.

Note: Meituan has since discontinued the API this project depended on, so it is no longer functional against live data. The code is preserved here for reference.

Data Sources

Controller	Database	Description
meituan	MySQL	Meituan deals — queried via SQL with city/area/price/category filters
hao123v2	MongoDB	Hao123 aggregated deals — Mongoose queries with full-text search
tuan800	MongoDB	Tuan800 deals — Mongoose queries with shop-area and tag filters
city	MySQL	City/area lookup — hierarchical city tree

Prerequisites

• Node.js 0.10.x (Express 2.5 era)
• MySQL with the meituan schema (tables: ware, navsite, category, city)
• MongoDB with hao123v2 and tuan800 databases (collection: urls)

Setup

1. Fill in MySQL connection credentials in config/database.js.
2. Set the MongoDB connection string in config/mongodb.js (default: mongodb://localhost/).
3. Ensure all deal data is pre-populated in the databases.
4. Start the server:

node app.js

The server starts on port 3000 with 16 cluster workers.

API Endpoints

All endpoints support .json and .xml response formats (default: xml).

Meituan Deals

GET /data/meituan.:type?/city/:city/area/:area/price/:price/category/:category/order/:order/k/:keyword/pagesize/:pagesize/page/:page

All path segments after the format are optional. Examples:

GET /data/meituan.json
GET /data/meituan.xml/city/beijing
GET /data/meituan.json/city/beijing/category/cm/order/jg-desc/page/2

Parameters:

• price: a (0-50), b (50-100), c (100-150), d (200+)
• category: cm, xy, mb, sf, wg, qt
• order: jg (price), zk (rebate), gm (bought) + -asc/-desc
• k: keyword search in title and detail

City Lookup

GET /data/city.:type?             # List all cities
GET /data/city.:type?/city/:city  # Get areas in a city
GET /data/city.:type?/city/:city/area/:area  # Get sub-areas

Hao123 & Tuan800 Deals

GET /data/hao123v2.:type?/key/:key/city/:city/...
GET /data/tuan800.:type?/key/:key/city/:city/...

These support additional filters: range, price (min-max), rebate, category, subcategory, start/end dates, order, k (keyword), pagesize, page.

Docker

docker-compose up -d

This starts the API server, MySQL, and MongoDB. See docker-compose.yml for configuration.

Architecture

app.js              # Entry point — Express + cluster (16 workers, port 3000)
boot.js             # Auto-discovers controllers, maps actions to routes
config/
  database.js       # MySQL connection config
  mongodb.js        # MongoDB connection string
  contant.js        # Meituan parameter mappings (price ranges, categories, sort fields)
  hao123v2.js       # Hao123 sort field config
  tuan800.js        # Tuan800 sort field config
controller/data/
  meituan.js        # Meituan deals — MySQL queries, XML/JSON response builder
  hao123v2.js       # Hao123 deals — MongoDB/Mongoose queries with gzip response
  tuan800.js        # Tuan800 deals — MongoDB/Mongoose queries with gzip response
  city.js           # City/area hierarchy — MySQL queries
dao/
  common.js         # MySQL client factory
  mongodb.js        # MongoDB/Mongoose client factory with schema definitions

boot.js auto-loads all files under controller/ and maps exported function names (index, city, area, meituan, hao123v2, tuan800) to corresponding route patterns via convention.

Route Regex Explained

boot.js 中 bootController 函数根据 controller 导出的函数名，将其映射到不同的路由模式：

简单路由（index / city / area）使用 Express 命名参数：

index → prefix.:type?                          # e.g. /data/city.json
city  → prefix.:type?/city/:city               # e.g. /data/city.json/city/beijing
area  → prefix.:type?/city/:city/area/:area    # e.g. /data/city.json/city/beijing/area/chaoyang

复杂路由（meituan / hao123v2 / tuan800）使用正则表达式，所有路径段均为可选，按固定顺序排列。以 meituan 路由为例：

^\/data\/meituan                        # 固定前缀
(?:\.(\\w+))?                            # [1] type — 响应格式 (json/xml)，可选
(?:\\/city(?:(?:\\/([\\w]+))?            # [2] city — 城市名或ID
  (?:\\/area(?:\\/([\\w]+))?)?           # [3] area — 区域名或ID（嵌套在 city 下）
)?)?
(?:\\/price(?:\\/(\\w+)?)?)?             # [4] price — 价格区间代号 (a/b/c/d)
(?:\\/category(?:\\/(\\w+)?)?)?          # [5] category — 分类代号 (cm/xy/mb/sf/wg/qt)
(?:\\/order(?:\\/([\\w-]+)?)?)?          # [6] order — 排序字段+方向 (jg-desc)
(?:\\/k(?:\\/([^\\/]+)?)?)?              # [7] keyword — 搜索关键词
(?:\\/pagesize(?:\\/(\\d+)?)?)?          # [8] pagesize — 每页条数
(?:\\/page(?:\\/(\\d+)?)?)?              # [9] page — 页码

核心设计： 每个路径段的结构都是 (?:\\/segname(?:\\/(capture)?)?)?，即：

1. 外层 (?:...)? — 整个段可选
2. \\/segname — 段名作为字面量匹配（如 /city、/price）
3. 内层 (?:\\/(capture)?)? — 段值可选，用捕获组提取

这种设计使得 URL 中每一段都可以省略，但必须按固定顺序出现。匹配结果通过 req.params[0] ~ req.params[N] 按序访问。

hao123v2 和 tuan800 路由结构相同，只是参数段不同：

路由	独有参数
meituan	city/area, price(代号), category, order, k, pagesize, page
hao123v2	key(32位), city/range, price(数值区间), rebate, category/subcategory, start/end(日期), order, k, pagesize, page
tuan800	key(32位), city, shoparea, price(数值区间), tag, start/end(日期), post(0/1), soldout(0/1), order, k, pagesize, page

Dependencies

All dependencies are committed in node_modules/ (no package.json in the original project):

• express 2.5.0
• cluster 0.7.7
• mongoose 2.3.13
• mysql 0.9.4
• gzip 0.1.0
• libxmljs 0.4.2

License

MIT