/+junk/Dataanalys

#!/usr/bin/env python3.1

""" Testing the cmd interface """

import cmd

import sys

import sqlite3

class cmdTest(cmd.Cmd):

	""" Testing here """

	# init of DB and shit

	conn = sqlite3.connect("./test.sqlite")

	db = conn.cursor()

	startQueryShow = "select * from test1 where("

	startQueryCount = "select count(*) from test1 where("

	endQuery =");"

	def do_show(self,line):

		""" Shows the query where

IE: select * from <table> where <Command>

example:

        show test2 = 1 and test = 1"""

    		query = cmdTest.startQueryShow + line + cmdTest.endQuery

    		try:

    			result = cmdTest.db.execute(query)

    		except:

    			print("Dave, I can not show you that....")

    		else:

    			for row in result:

        			print(row)

    	def do_count(self,line):

    		""" Shows the query where

IE: select count(*) from <table> where <Command>

example:

        count test2 = 1 and test = 1"""

    		query = cmdTest.startQueryCount + line + cmdTest.endQuery

    		try:

    			result = cmdTest.db.execute(query)

    		except:

    			print("Dave, I can not count that....")

    		else:

    			for row in result:

        			print(row[0])

    	def do_exit(self,line):

    		exit()

    	def de_EOF(self, line):

    		return(true)

if __name__ == '__main__':

	cmdTest().cmdloop()