From a8e1099b42befac8bdf8ead48568c8248920399d Mon Sep 17 00:00:00 2001
From: 沈斌 <bluelazysb@hotmail.com>
Date: Mon, 22 Jan 2018 14:33:25 +0800
Subject: [PATCH] test
---
test.js | 26 ++++++++++++++++++++++++++
1 files changed, 26 insertions(+), 0 deletions(-)
diff --git a/test.js b/test.js
new file mode 100644
index 0000000..45c757b
--- /dev/null
+++ b/test.js
@@ -0,0 +1,26 @@
+var mysql = require('mysql');
+var moment = require('moment');
+var config = require('./config');
+
+var mysqlClient = mysql.createConnection(config.mysql);
+
+mysqlClient.connect(function(error) {
+ if (error) return;
+ //console.log("connected to MySQL");
+});
+
+for(var i = 0; i < 12; i++) {
+ var partition_name = "p" + moment().add(-64 + i, 'd').format("YYYYMMDD");
+ console.log(partition_name);
+
+ sql = "ALTER TABLE history DROP PARTITION " + partition_name;
+ console.log(sql);
+
+ mysqlClient.query(sql, function (error, results, fields) {
+ if (error) throw error;
+ //console.log(results);
+ //console.log(fields);
+ });
+}
+
+mysqlClient.end();
\ No newline at end of file
--
Gitblit v1.8.0