From f41cd316889dcbdc62e22e6622a6ecea4a435084 Mon Sep 17 00:00:00 2001
From: Andrew <saintruler@gmail.com>
Date: Sun, 7 Jul 2019 15:40:51 +0400
Subject: =?UTF-8?q?WIP:=20=D0=94=D0=BE=D0=B1=D0=B0=D0=B2=D0=BB=D0=B5=D0=BD?=
 =?UTF-8?q?=D0=BE=20=D0=B8=D0=B7=D0=BC=D0=B5=D0=BD=D0=B5=D0=BD=D0=B8=D0=B5?=
 =?UTF-8?q?=20=D0=BE=D1=82=D0=B4=D0=B5=D0=BB=D1=8C=D0=BD=D1=8B=D1=85=20?=
 =?UTF-8?q?=D0=BF=D0=BE=D0=BB=D0=B5=D0=B9=20=D0=B2=20=D1=82=D0=B0=D0=B1?=
 =?UTF-8?q?=D0=BB=D0=B8=D1=86=D0=B5.?=
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

---
 day9/task5/database.py | 16 +++++++++++++++-
 1 file changed, 15 insertions(+), 1 deletion(-)

(limited to 'day9/task5/database.py')

diff --git a/day9/task5/database.py b/day9/task5/database.py
index 067c481..9b958b7 100644
--- a/day9/task5/database.py
+++ b/day9/task5/database.py
@@ -1,7 +1,19 @@
 import MySQLdb
 from config import *
 
+import logging
 
+
+def db_column_names():
+    cursor = db.cursor()
+    cursor.execute('DESCRIBE table_task1;')
+    table_structure = cursor.fetchall()
+    table_headers = [field[0] for field in table_structure]
+    return table_headers
+
+
+logger = logging.getLogger('tableApp')
+logger.info(f'Trying to connect to database "{DATABASE_NAME}@{HOST}"...')
 # В файле config.py создайте соответствующие переменные
 db = MySQLdb.connect(
     host=HOST,
@@ -9,7 +21,9 @@ db = MySQLdb.connect(
     passwd=PASSWORD,
     db=DATABASE_NAME
 )
+logger.info('Connected')
 
+logger.info(f'Preparing table "table_task1"...')
 db.cursor().execute(
     '''
     CREATE TABLE IF NOT EXISTS `table_task1` (
@@ -26,4 +40,4 @@ db.cursor().execute(
       PRIMARY KEY (`service_id`)
     ) ENGINE=InnoDB AUTO_INCREMENT=35109400 DEFAULT CHARSET=utf8;
     '''
-)
\ No newline at end of file
+)
-- 
cgit v1.2.3