/+junk/Dataanalys

#!/usr/bin/env python3.1

"""

This file contains the plotting funcioton that plots the data into a bar graph.

"""

import sys

import sqlite3

import numpy

class plotDB(object):

	def __init__(self):

		##This array is passed to getDB

		self.nameArray = ["gudar", "spoken", "religos", "sekulart" ,"vegan" ,"mars" ,"globaluppvarmning" ,"manen" ,"motion" ,"sund" ,"deprimerad_host" ,"sno" ,"oppet" ,"dodsstraff" ,"kvinnors_rattigheter" ,"abort", "kvinnors_kropp", "deprimerad_var" ,"gast_sverige" ,"fodd_sverige" ,"foraldrar_sverige" ,"komentarer"]

		GetData = getDB(self.nameArray)

	def doPlot(self):

		CountArray = GetData.doGet()

class getDB(object):

	""" returns an array of counts of  from the database"""

	def __init__(self, iarray):

		self.conn = sqlite3.connect("./awnsers.sqlite")

		self.db = self.conn.cursor()

		self.nameArray = iarray

		self.countArray = list()

		self.countStart = "select count(*) from awnsers where("

		self.countEnd = " == 1);"

	def doGet(self):

		for name in self.nameArray:

			getItem = self.db.execute(self.countStart + str(name) + self.countEnd )

			for item in getItem:

				self.countArray.append(item)

		return self.countArray