/+junk/Dataanalys

#!/usr/bin/env python3.1

#-*- coding: utf-8 -*-

import sys

import sqlite3

import awnser_sheet

import sqlCmd

awnsht = awnser_sheet.awnserSheet()

cmdClass = sqlCmd.commandPromt()

#======================= 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 = str(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[0] == None):

		print("No data in table.")

	print("===== changing to database comand line =====")

	cmdClass.cmdloop()

def dbEdit():

	print("DEBUG: running dbEdit()")

	#TODO: make it 

	menu()

def dbAdd(): ##TODO: rename to dbCmd or somthing.

	print("DEBUG: running dbAdd()")

	query = awnsht.questionAndReturn() #kallar annan fil.

	print(query)

	print("commit this query to DB?")

	dbCommitString(query)

def dbCommitString(query):

	q = str(input("y/n > "))

	q = q.lower() #save my life

	if(q == "n"):

		menu()

	if(q == "y"):

		db.execute(query)

		conn.commit()

		menu()

	else:

		print("== Enter a valid input ==")

		dbCommitString(query)

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

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

menu()