/+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