-
Notifications
You must be signed in to change notification settings - Fork 0
/
upload_sniffer_data_sql.py
57 lines (40 loc) · 1.46 KB
/
upload_sniffer_data_sql.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
49
50
51
52
53
54
55
56
57
import csv
import sqlite3
from sql_database.connect import insert_sniffer_data_to_sql, delete_sniffer_data
def upload_data():
row=[]
#Put the name of your csv_file here
with open('adv_exports1.csv','r') as csv_file :
csv_reader=csv.reader(csv_file)
next(csv_reader)
for line in csv_reader :
row=line
#data of csv file
data={
'Bookmark' : str(row[0]),
'Frame_diesh' : str(row[1]),
'Channel' : str(row[2]),
'Type' : str(row[3]),
'AddrTypeI' : str(row[4]),
'InitA_ScanA' : str(row[5]),
'AddrTypeA' : str(row[6]),
'AdvA' : str(row[7]),
'Len' :str(row[8]),
'Frame' : str(row[9]),
'Size' :str(row[10]),
'Delta' : str(row[11]),
'Timestamp' :str(row[12])
}
# Insert data to mongodb_database
insert_sniffer_data_to_sql(data)
csv_file.close()
print('Csv file closed.')
if __name__ == "__main__" :
print('Press 1 to insert sniffer-data to the SQL_database.')
print('Press 2 to delete sniffer-data to the SQL_database.')
user= int(input('Choose:'))
print('-----------------------------------------------------------------------------------------------------')
if user==1 :
upload_data()
elif user==2:
delete_sniffer_data()