From 53d126fad45f53f2abe442b20f540c719f9b280e Mon Sep 17 00:00:00 2001
From: Alexander_Kabui
Date: Mon, 23 Jan 2023 13:14:46 +0300
Subject: init query for last modification

---
 .../correlation/correlation_file_generator.py       | 21 +++++++++++++++++++++
 1 file changed, 21 insertions(+)

diff --git a/wqflask/wqflask/correlation/correlation_file_generator.py b/wqflask/wqflask/correlation/correlation_file_generator.py
index 36959229..80dc82d8 100644
--- a/wqflask/wqflask/correlation/correlation_file_generator.py
+++ b/wqflask/wqflask/correlation/correlation_file_generator.py
@@ -53,3 +53,24 @@ def get_probesetfreeze(conn, probes):
             (probes,)
         )
         return cursor.fetchone()
+
+
+ def query_for_last_modification():
+
+ 	pass
+ 	"""
+
+SELECT database_name,table_name,last_update FROM
+  mysql.innodb_table_stats a,
+  (SELECT database_name AS db_last_update_name,
+       max(last_update) AS db_last_update 
+   FROM mysql.innodb_table_stats 
+   WHERE database_name  in ( "db_webqtl")
+   GROUP BY database_name )  AS b 
+WHERE a.database_name = b.db_last_update_name
+
+  AND a.last_update = b.db_last_update ;
+
+"""
+
+
-- 
cgit v1.2.3