Esempio n. 1
0
def main():

    dbConnect = DbConnect(BaseDAO.getDbDir())
    connector = dbConnect.getConnection()

    baseDAO = BaseDAO(connector, g_tableName, g_columnHeaders)

    # testCreateAnEntry(baseDAO)
    testGetPriKeys(baseDAO)
    testSelectAnEntry(baseDAO)
    testSelectAllEntries(baseDAO)
    testSelectAColumn(baseDAO)
    testSelectMax(baseDAO)
    testSelectDistinct(baseDAO)
    testDelete(baseDAO)
    testUpdate(baseDAO)
import sys

from Service.DbConnect import DbConnect

from DAO.BaseDAO import BaseDAO
from DAO.BarcodeDAO import BarcodeDAO
from DAO.CustomerDAO import CustomerDAO
from DAO.FootwearDesignDAO import FootwearDesignDAO
from DAO.FootwearSelectionDAO import FootwearSelectionDAO
from DAO.InventoryDAO import InventoryDAO
from DAO.VirtualCartDAO import VirtualCartDAO

from Tables.TableStructs import *

gc_dbConnect = DbConnect("/Users/jeongwon/Desktop/University_of_Waterloo/4YDP/4B/gitdir/3.14Modules/DataBaseAccess/ProductionData.db")
gc_connector = gc_dbConnect.getConnection()

def populateFootwearDesignDetails():

	print(sys._getframe().f_code.co_name + ": ")

	dao = FootwearDesignDAO(gc_connector)

	entries = [
				("HAUGHNEY-70", "Haughney", ".", 69.99),
				("GRADUATE PNL SPM BLK CANVAS", "LACOSTE", ".", 99.99),
				("UA MICRO G ELEVATE", "UNDER ARMOUR", ".", 49.99),
				("FRIDOLPH-27", "FRIDOLPH", ".", 59.99),
				("JACOU-70", "JACOU", ".", 59.00),
				("AGREWIEL-36", "AGREWIEL", ".", 59.99),
				("GRAD VULC TSP US SPM WHT", "LACOSTE", ".", 74.99),