Demo - Revision history

Admin at 00:46, 28 February 2016

2016-02-28T00:46:07Z

2016-01-13T05:51:09Z

← Older revision		Revision as of 05:51, 13 January 2016
Line 1:		Line 1:
			Demo for first meeting of [[Wireless Research Project]]

	=Wireless Networks=		=Wireless Networks=

2016-01-13T04:37:20Z

SQLite Database

← Older revision		Revision as of 04:37, 13 January 2016
Line 111:		Line 111:
	[[Image:SqliteView.png\|500px]]		[[Image:SqliteView.png\|500px]]



			=Data Analysis=

			The platform of data analysis will determine the kind of analysis that can be done.

			As a first-pass, the data dumped by airomon-ng was imported into Google Spreadsheets and I plotted a few histograms and scatter plots.

2016-01-13T04:30:15Z

2016-01-13T04:29:30Z

Insertion

← Older revision		Revision as of 04:29, 13 January 2016
Line 85:		Line 85:
	and a screenshot of the script in action:		and a screenshot of the script in action:

	[[Image:SqliteInsert.png\|~~400px~~]]		[[Image:SqliteInsert.png\|500px]]

	==Viewing==		==Viewing==

2016-01-13T04:29:18Z

Viewing

2016-01-13T04:28:44Z

Viewing

2016-01-13T04:27:52Z

Insertion

← Older revision		Revision as of 04:27, 13 January 2016
Line 82:		Line 82:

	</pre>		</pre>

			and a screenshot of the script in action:

			[[Image:SqliteInsert.png\|400px]]

	==Viewing==		==Viewing==

2016-01-13T04:25:38Z

Database

← Older revision		Revision as of 04:25, 13 January 2016
Line 23:		Line 23:
	Now you can open output_file.csv with a script or with a spreadsheet viewer.		Now you can open output_file.csv with a script or with a spreadsheet viewer.

	=Database=		=SQLite Database=

	Use SQLite, and you don't have to install anything - it comes with [[Kali]].		Use SQLite, and you don't have to install anything - it comes with [[Kali]].

2016-01-13T04:25:10Z

Display

← Older revision		Revision as of 04:25, 13 January 2016
Line 83:		Line 83:
	</pre>		</pre>

	==~~Display~~==		==Viewing==

	In another window, running a script that queries the database and shows its contents		In another window, running a script that queries the database and shows its contents
Line 90:		Line 90:

	<pre>		<pre>
			import sqlite3
			import time

			# connect to sqlite database
			conn = sqlite3.connect('wifidata.db')
			c = conn.cursor()

			for row in c.execute('SELECT * FROM wifidata;'):
			print row

			conn.close()
	</pre>		</pre>