STRLCPY/wifi_db

Total 1 files

■ ■ ■ ■ ■ ■

database_utils.py

		skipped 76 lines
77	77		print(sql, (essid, bssid.upper()))
78	78		cursor.execute(sql, (essid, bssid.upper()))
79	79
	80	+
80	81		# Update `manuf` column
81	82		sql = """UPDATE AP SET manuf = CASE WHEN manuf = '' OR manuf IS NULL
82	83		THEN (?) ELSE manuf END WHERE bssid = (?)"""
83	84		if verbose:
84	85		print(sql, (manuf, bssid.upper()))
85	86		cursor.execute(sql, (manuf, bssid.upper()))
	87	+
86	88
87	89		# Update `channel` column
88	90		sql = """UPDATE AP SET channel = CASE WHEN channel = '' OR channel IS NULL
		skipped 1 lines
90	92		if verbose:
91	93		print(sql, (channel, bssid))
92	94		cursor.execute(sql, (channel, bssid.upper()))
	95	+
93	96
94	97		# Update `frequency` column
95	98		sql = """UPDATE AP SET frequency = CASE WHEN frequency = '' OR
		skipped 2 lines
98	101		print(sql, (freqmhz, bssid))
99	102		cursor.execute(sql, (freqmhz, bssid.upper()))
100	103
	104	+
101	105		# Update `carrier` column
102	106		sql = """UPDATE AP SET carrier = CASE WHEN carrier = '' OR carrier IS NULL
103	107		THEN (?) ELSE carrier END WHERE bssid = (?)"""
104	108		if verbose:
105	109		print(sql, (carrier, bssid))
	110	+
106	111		cursor.execute(sql, (carrier, bssid.upper()))
107	112
108	113		# Update `encryption` column
		skipped 1 lines
110	115		encryption IS NULL THEN (?) ELSE encryption END WHERE bssid = (?)"""
111	116		if verbose:
112	117		print(sql, (encryption, bssid))
	118	+
113	119		cursor.execute(sql, (encryption, bssid.upper()))
114	120
115	121		# Update `packetsTotal` column
		skipped 408 lines