/+junk/Dataanalys

#!/usr/bin/env python3.1

import sys

import sqlite3

#======================= connection to DB ===========================

conn = sqlite3.connect("./awnsers.sqlite") #makes the connection with the db file.

db = conn.cursor()

##create table from query from file: create table if not exists

f = open("./createDB.sql")

query = f.read()

db.execute(query)

f.close()

#===================== end DB connection ==========================

#===================== Futction section ===========================

## menu

def menu():

	## menu options

	menuOptions="""1. show DB

2. edit DB

3. add to DB

4. exit

"""

	print("select an option")

	print(menuOptions)

	menuOptionsInput = input(">>>>")

	#ifs and thens

	if(menuOptionsInput == "1" or menuOptionsInput.lower() == "s" ):

		dbShow()

	elif(menuOptionsInput == "2" or menuOptionsInput.lower() =="e" ):

		dbEdit()

	elif(menuOptionsInput == "3" or menuOptionsInput.lower() == "a" ):

		dbAdd()

	elif(menuOptionsInput == "4" or menuOptionsInput.lower() == "q" ):

		exit()

	else:

		print("You need to select an option! in the list")

		menu()

#Show DB Function

def dbShow():

	print("DEBUG : Running dbShow()")

	#TODO: make it print counts of occurunsus of different true (integer 1) values

	getQuery =""" select * from awnsers; """

	db.execute(getQuery)

	for row in db:

		print( row )

	if(getQuery == None):

		print("No data in table.")

	menu()

def dbEdit():

	print("DEBUG: running dbEdit()")

	#TODO: make it 

	menu()

def dbAdd():

	print("DEBUG: running dbAdd()")

	#TODO: make a function with all the questions and such.

	menu()

#==================== end function setion ==================

#==================== main call section ====================

menu()