-
Notifications
You must be signed in to change notification settings - Fork 9
/
mysql.js
125 lines (119 loc) · 8.86 KB
/
mysql.js
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
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
/**
* @author fuqiang
* @fileoverview orm for dataabase
* @date 20151201
*/
var orm = require('orm'),
config = require('../db/config.json'),
db = require('../db/mysql.json'),
mysql = db[config.db],
fs = require("fs"),
path = require("path"),
files = fs.readdirSync(path.join(__dirname)),
obj = {},
rebateDb = require("../db/rebate.json"),
rebate = rebateDb[config.rebate];
for(var key of files) {
if(key !== "mysql.js" && key.indexOf(".js") > 0) {
var fileName = key.replace(".js", "");
obj[fileName] = require("./" + key);
}
}
function connect(app) {
app.use(orm.express('mysql://' + mysql.username + ':' + mysql.pwd + '@' + mysql.host + '/' + mysql.database, {
define: function(db, models, next) {
db.settings.set('instance.cache', false);
db.settings.set('instance.autoFetch', true);
//db.settings.set('instance.autoFetchLimit', 9999);
//db.settings.set('instance.cacheSaveCheck', false);
//db.settings.set('instance.autoSave', true);
models.NewAccount = db.define("tbl_rt_useranalysis_newuser", obj.NewAccount);
models.Configure = db.define("tbl_rt_configure", obj.Configure);
models.UsersAccess = db.define("tbl_rt_user_access", obj.UsersAccess);
models.UserCompose = db.define("tbl_rt_use_time", obj.UserCompose);
models.MarketingFlow = db.define("tbl_rt_marketing_flow", obj.MarketingFlow);
models.MarketingCoupon = db.define("tbl_rt_marketing_coupon", obj.MarketingCoupon);
models.MarketingCouponDetails = db.define("tbl_rt_marketing_coupon_details", obj.MarketingCouponDetails);
models.OverviewPage = db.define("tbl_rt_overview_page", obj.OverviewPage);
models.OverviewPlatf = db.define("tbl_rt_overview_platf", obj.OverviewPlatf);
models.KpiValue = db.define("tbl_rt_kpi_value", obj.KpiValue);
models.Rebate = db.define("tbl_rt_rebate", obj.Rebate);
models.RebateRefund = db.define("tbl_rt_rebate_refund", obj.RebateRefund);
models.RebateShopOverview = db.define("tbl_rt_rebate_shop_overview", obj.RebateShopOverview);
models.RebateShopRefund = db.define("tbl_rt_rebate_shop_refund", obj.RebateShopRefund);
models.RebateShopTop = db.define("tbl_rt_rebate_shop_top", obj.RebateShopTop);
models.RebateShopPlanTop = db.define("tbl_rt_rebate_shop_plan_top", obj.RebateShopPlanTop);
models.RebateInvitepartner = db.define("tbl_rt_rebate_invitepartner", obj.RebateInvitepartner);
models.RebatetSheduleDetails = db.define("tbl_rt_rebate_schedule_details", obj.RebatetSheduleDetails);
models.RebatetInviteseller = db.define("tbl_rt_rebate_inviteseller", obj.RebatetInviteseller);
models.RebatetRegisterTrendency = db.define("tbl_rt_rebate_register_trendency", obj.RebatetRegisterTrendency);
models.RebatetRegisterSheduleDetails = db.define("tbl_rt_rebate_register_schedule_details", obj.RebatetRegisterSheduleDetails);
models.ConfCategories = db.define("ecp_back_categories", obj.ConfCategories);
models.UrlAccessWap = db.define("tbl_rt_url_access_wap", obj.UrlAccessWap);
models.KeyValue = db.define("tbl_rt_key_value", obj.KeyValue);
models.RebateOrderTredencyDetails = db.define("tbl_rt_rebate_order_tredency_details", obj.RebateOrderTredencyDetails);
models.RebateTypeLevelDetails = db.define("tbl_rt_rebate_type_level_details", obj.RebateTypeLevelDetails);
models.RebateShopOrderTredencyDetails = db.define("tbl_rt_rebate_shop_order_tredency_details", obj.RebateShopOrderTredencyDetails);
models.RebateShopTypeLevelDetails = db.define("tbl_rt_rebate_shop_type_level_details", obj.RebateShopTypeLevelDetails);
models.Count = db.define("tbl_dataplatform_count", obj.Count);
models.User2 = db.define("tbl_dataplatform_nodejs_users2", obj.User2);
models.Role = db.define("tbl_dataplatform_nodejs_role", obj.Role);
models.Log = db.define("tbl_dataplatform_nodejs_log", obj.Log);
models.SocialCategory = db.define("tbl_social_category", obj.SocialCategory);
models.ShopPayTop = db.define("tbl_rt_shop_pay_top", obj.ShopPayTop);
models.ShopAccesTop = db.define("tbl_rt_shop_acces_top", obj.ShopAccesTop);
models.TradeCaty = db.define("ads2_spt_rt_deal_caty", obj.TradeCaty);
models.TradeUser = db.define("tbl_rt_deal_user", obj.TradeUser);
models.SalesPerfProductKv = db.define("tbl_rt_sales_perf_product_kv", obj.SalesPerfProductKv);
models.SalesPerfShopKv = db.define("tbl_rt_sales_perf_shop_kv", obj.SalesPerfShopKv);
models.SalesPerfTranKv = db.define("tbl_rt_sales_perf_tran_kv", obj.SalesPerfTranKv);
models.SalesProductMarketTop = db.define("tbl_rt_sales_product_market_top", obj.SalesProductMarketTop);
models.SalesProductFlowtTop = db.define("tbl_rt_sales_product_flow_top", obj.SalesProductFlowtTop);
models.UserKeepResult = db.define("tbl_rt_user_keep_result", obj.UserKeepResult);
models.ChannelAnalysis = db.define("tbl_rt_channel_analysis", obj.ChannelAnalysis);
models.ChannelUserKeep = db.define("tbl_rt_channel_user_keep", obj.ChannelUserKeep);
models.ChannelUserActive = db.define("tbl_rt_channel_user_active", obj.ChannelUserActive);
models.ChannelIdNameChart = db.define("tbl_rt_channel_id_name_chart", obj.ChannelIdNameChart);
models.ShareAnalyzeOverview = db.define("tbl_rt_share_analyze_overview", obj.ShareAnalyzeOverview);
models.ShareAnalyzeTrend = db.define("tbl_rt_share_analyze_trend", obj.ShareAnalyzeTrend);
models.ShareAnalyzeChannel = db.define("tbl_rt_share_analyze_channel", obj.ShareAnalyzeChannel);
models.ShareAnalyzeChannelTrend = db.define("tbl_rt_share_analyze_channel_trend", obj.ShareAnalyzeChannelTrend);
models.UrlToName = db.define("tbl_rt_url_to_name", obj.UrlToName);
models.CouponGroupPriceInterrgional = db.define("ads2_coupon_group_price_interrgional", obj.CouponGroupPriceInterrgional);
models.CouponGroupShopTop = db.define("ads2_coupon_group_shop_top", obj.CouponGroupShopTop);
models.CouponInfo = db.define("ads2_coupon_info", obj.CouponInfo);
models.CouponGroupDate = db.define("ads2_coupon_group_date", obj.CouponGroupDate);
models.GroupownerStatistics = db.define("ads2_soc_groupowner_statistics", obj.GroupownerStatistics);
models.GroupownerCategoryDistribution = db.define("ads2_soc_groupowner_category_distribution", obj.GroupownerCategoryDistribution);
models.GroupownerList = db.define("ads2_soc_groupowner_list", obj.GroupownerList);
models.GroupReport = db.define("ads2_soc_group_report", obj.GroupReport);
models.Statistics = db.define("tbl_soc_statistics", obj.Statistics);
//8.15
models.GroupStatistics = db.define("ads2_soc_group_statistics" , obj.GroupStatistics);
models.GroupCategoryDistribution = db.define("ads2_soc_group_category_distribution" , obj.GroupCategoryDistribution);
models.SocialGroupList = db.define("ads2_soc_group_list" , obj.SocialGroupList);
models.SocialGroupDetailStatistic = db.define("ads2_soc_group_detail_statistic" , obj.SocialGroupDetailStatistic);
models.SocialGroupDetailList = db.define("ads2_soc_group_detail_list" , obj.SocialGroupDetailList);
models.SocialTopicStatistics = db.define("ads2_soc_topic_statistics" , obj.SocialTopicStatistics);
models.SocialTopicCategoryDistribution = db.define("ads2_soc_topic_category_distribution" , obj.SocialTopicCategoryDistribution);
models.SocialTopicList = db.define("ads2_soc_topic_list" , obj.SocialTopicList);
models.SocialTopicDetailStatistics = db.define("ads2_soc_topic_detail_statistics" , obj.SocialTopicDetailStatistics);
models.Activity = db.define("activity" , obj.Activity);
models.ActivityChannelRelationship = db.define("activity_channel_relationship" , obj.ActivityChannelRelationship);
models.Channel = db.define("channel" , obj.Channel);
models.VideoPlay = db.define("ads2_video_playing" , obj.VideoPlay);
models.db1 = db;
next();
}
}));
app.use(orm.express('mysql://' + rebate.username + ':' + rebate.pwd + '@' + rebate.host + '/' + rebate.database + '?timezone=CST', {
define: function(db, models, next) {
db.settings.set('instance.cache', false);
db.settings.set('instance.autoFetch', true);
models.TypeFlow = db.define("t_rebate_type_flow", obj.TypeFlow);
models.db2 = db;
next();
}
}));
};
module.exports = connect;