HYTOS

# coding: utf-8

import sys

import os

import sqlite3

from SingletonInstance import SingletonInstane

DB_NAME = os.path.dirname(os.path.realpath(__file__)) + "\\db\\DTI_PID.db"

class AppDocData(SingletonInstane):

    '''

        @brief  return project database path

    '''

    def getPrjDatabasePath(self):

        return (os.path.dirname(os.path.realpath(__file__)) + "\\Project_db.db")

    '''

        @brief  get project list from database

    '''

    def getProjectList(self):

        from Project import Project

        projectList = []

        try:

            conn = sqlite3.connect(self.getPrjDatabasePath())

            cursor = conn.cursor()

            sql = 'SELECT * FROM Projects'

            try:

                cursor.execute(sql)

                rows = cursor.fetchall()

                for row in rows:

                    projectList.append(Project(row[0], row[1], row[2], row[3], row[4]))

            except Exception as ex:

                print('error occured({}) in {}:{}'.format(ex, sys.exc_info()[-1].tb_frame.f_code.co_filename, sys.exc_info()[-1].tb_lineno))

        finally:

            conn.close()

        return projectList

    '''

        @brief  get sliding window size

    '''

    def getSlidingWindowSize(self):

        res = [10,10]

        try:

            # Creates or opens a file called mydb with a SQLite3 DB

            conn = sqlite3.connect(DB_NAME)

            # Get a cursor object

            cursor = conn.cursor()

            sql = "select * from configuration where section='Sliding Window'"

            cursor.execute(sql)

            rows = cursor.fetchall()

            for row in rows:

                if row[1] == 'Width':

                    res[0] = int(row[2])

                elif row[1] == 'Height':

                    res[1] = int(row[2])

        # Catch the exception

        except Exception as e:

            # Roll back any change if something goes wrong

            conn.rollback()

            raise e

        finally:

            # Close the db connection

            conn.close()

        return res

    pass