Repository navigation
Expand file tree
/
Copy pathtestdata.js
More file actions
133 lines (131 loc) · 2.03 KB
/
Copy pathtestdata.js
File metadata and controls
133 lines (131 loc) · 2.03 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
8000
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
var low = require('lowdb')
var db = low('./db.json')
var _ = require('lodash')
var data_customers = [
{
id: 1,
name: '林亮',
address: '北区宿舍 16-308',
region_id: 1
},
{
id: 2,
name: '何国辉',
address: '黎耀球楼 3楼',
region_id: 2
},
{
id: 3,
name: '刘兴林',
address: '黎耀球楼 2楼',
region_id: 2
}
]
var data_regions = [
{
id: 1,
name: '北区宿舍'
},
{
id: 2,
name: '黎耀球楼'
}
]
var data_products = [
{
id: 1,
name: '电脑'
},
{
id: 2,
name: '手机'
}
]
var data_orders = [
{
id: 1,
customer_id: 1,
order_date: '2015-05-11',
consign_date: '2015-05-13',
totalprice: 1000
},
{
id: 2,
customer_id: 2,
order_date: '2015-05-14',
consign_date: '2015-05-15',
totalprice: 3000
},
{
id: 3,
customer_id: 3,
order_date: '2015-05-15',
consign_date: '2015-05-15',
totalprice: 2000
},
{
id: 4,
customer_id: 2,
order_date: '2015-05-15',
consign_date: '2015-05-16',
totalprice: 4000
}
]
var data_orderspec = [
{
id: 1,
order_id: 1,
product_id: 1,
eachprice: 1000,
num: 1
},
{
id: 2,
order_id: 2,
product_id: 2,
eachprice: 3000,
num: 1
},
{
id: 3,
order_id: 3,
product_id: 1,
eachprice: 1000,
num: 2
},
{
id: 4,
order_id: 4,
product_id: 1,
eachprice: 1000,
num: 1
},
{
id: 5,
order_id: 4,
product_id: 2,
eachprice: 3000,
num: 1
}
]
db.object = {}
var db_customers = db('customers')
_.each(data_customers, function(item){
db_customers.push(item)
})
var db_regions = db('regions')
_.each(data_regions, function(item){
db_regions.push(item)
})
var db_products = db('products')
_.each(data_products, function(item){
db_products.push(item)
})
var db_orders = db('orders')
_.each(data_orders, function(item){
db_orders.push(item)
})
var db_orderspec = db('orderspec')
_.each(data_orderspec, function(item){
db_orderspec.push(item)
})