コード例 #1
0
def start():
    searchColumn = "transactionDate"
    findTables(KpiMeta.targetTables, searchColumn)
    print "==================="
    findTables(KpiMeta.targetTablesWeekly, searchColumn)
    print "==================="
    findTables(KpiMeta.targetTablesMonthly, searchColumn)
    print "==================="
    findTables(KpiMeta.targetTablesYearly, searchColumn)
    print "==================="
    
    KpiMeta.closeConnection(db)
コード例 #2
0
def start():
    
    print "=============DAILY===============" 
#     truncateTables(KpiMeta.targetTables)
    checkKpiTables(KpiMeta.targetTables)
    print "=============WEEKLY===============" 
#     truncateTables(KpiMeta.targetTablesWeekly)
#     checkKpiTables(KpiMeta.targetTablesWeekly)
    print "=============MONTHLY===============" 
#     truncateTables(KpiMeta.targetTablesMonthly)
#     checkKpiTables(KpiMeta.targetTablesMonthly)
    print "=============YEARLY===============" 
#     truncateTables(KpiMeta.targetTablesYearly)
#     checkKpiTables(KpiMeta.targetTablesYearly)

    KpiMeta.closeConnection(db)