-
Notifications
You must be signed in to change notification settings - Fork 0
/
SELECTTools.py
48 lines (38 loc) · 1.45 KB
/
SELECTTools.py
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
# -*- coding: utf-8 -*-
#!/usr/bin/env python
"""
@author: Quentin
"""
from InsertTools import CountID
from InsertTools import ChangeCOMMANDS
from InsertTools import InsertDICTIONNARY
import mysql.connector
import sys
def SELECT(table,condition=""):#Retourne sous la forme d'une liste les résultat une requete sql SELECT * FROM table;
if(condition!=''):
condition="where "+condition
try:
# connection = mysql.connector.connect(host='192.168.0.105',database='heronDatabase',user='robot',password='HeronLeR0B0T')
connection = mysql.connector.connect(host='192.168.0.105',database='heronDatabase',user='robot',password='HeronLeR0B0T')
sql_select_Query = "SELECT * FROM "+table+" "+condition+";"
#print(sql_select_Query)
#print(sql_select_Query)
cursor = connection.cursor()
cursor.execute(sql_select_Query)
records = cursor.fetchall()
#{print("la longueur : ",len(records))
if (connection.is_connected()):
connection.close()
cursor.close()
return records
except:
print("Erreure durant un SELECT ,",table)
print(sys.exc_info())
def CommandsFor(ID):#Retourne LineOrder-OrderID-Function-Target-Status-Source-Com destiné à L'ID spécifié
L=[]
for elt in SELECT("COMMANDS"):
if(elt[3]==ID):
L.append(elt)
return(L)
def FunctionOrdered(ID):
return(SELECT("COMMANDS","TARGET='"+ID+"''"))