From 67d36319ee517796893d676e67c92adf0c779f76 Mon Sep 17 00:00:00 2001
From: 沈斌 <bluelazysb@hotmail.com>
Date: Mon, 16 Apr 2018 17:11:46 +0800
Subject: [PATCH] test
---
server2.js | 30 +++++++++++++++++-------------
1 files changed, 17 insertions(+), 13 deletions(-)
diff --git a/server2.js b/server2.js
index fc64e11..4ae0286 100644
--- a/server2.js
+++ b/server2.js
@@ -3,22 +3,26 @@
var config = require('./config');
var mysqlClient = mysql.createConnection(config.mysql_2);
+mysqlClient.connect(function(error) { if (error) return; });
-mysqlClient.connect(function(error) {
- if (error) return;
- //console.log("connected to MySQL");
-});
+var partition_name1 = "p" + moment().add(1, 'd').format("YYYYMMDD");
+var partition_date1 = moment().add(2, 'd').format("YYYYMMDD");
-var partition_name = "p" + moment().add(1, 'd').format("YYYYMMDD");
-var partition_date = moment().add(2, 'd').format("YYYYMMDD");
+var sql = "ALTER TABLE history ADD PARTITION (PARTITION " + partition_name1 + " VALUES LESS THAN ('" + partition_date1 + "'))";
+// console.log(sql);
-var sql = "ALTER TABLE history ADD PARTITION (PARTITION " + partition_name + " VALUES LESS THAN ('" + partition_date + "'))";
-console.log(sql);
+mysqlClient.query(sql, function (error, results, fields) { if (error) throw error; });
-mysqlClient.query(sql, function (error, results, fields) {
- if (error) throw error;
- //console.log(results);
- //console.log(fields);
-});
+var partition_name2 = "p" + moment().add(-7, 'd').format("YYYYMMDD");
+
+sql = "ALTER TABLE history DROP PARTITION " + partition_name2;
+// console.log(sql);
+
+mysqlClient.query(sql, function (error, results, fields) { if (error) throw error; });
+
+var sql = "ALTER TABLE alarm ADD PARTITION (PARTITION " + partition_name1 + " VALUES LESS THAN ('" + partition_date1 + "'))";
+// console.log(sql);
+
+mysqlClient.query(sql, function (error, results, fields) { if (error) throw error; });
mysqlClient.end();
\ No newline at end of file
--
Gitblit v1.8.0