Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- def OpenDB():
- global connection
- global cursor
- connection = apsw.Connection("labpackagestudy.db3")
- cursor = connection.cursor()
- def DoWeekDays():
- # Create a second cursor for updating the new table
- cursor2 = connection.cursor()
- q1 = "DROP TABLE IF EXISTS weekdays"
- cursor.execute(q1)
- query = '''CREATE TABLE IF NOT EXISTS weekdays AS SELECT pkgs,
- Count(DOW) as CountOfDOW FROM study WHERE (Holiday <> 1)
- AND DayName in
- ("Monday","Tuesday","Wednesday","Thursday","Friday")
- GROUP BY pkgs'''
- cursor.execute(query)
- addcolquery = 'ALTER TABLE weekdays ADD COLUMN probability REAL'
- cursor.execute(addcolquery)
- addcolquery = 'ALTER TABLE weekdays ADD COLUMN lower REAL'
- cursor.execute(addcolquery)
- addcolquery = 'ALTER TABLE weekdays ADD COLUMN upper REAL'
- cursor.execute(addcolquery)
- sumquery = "SELECT Sum(CountOfDOW) as Sm FROM weekdays"
- tmp = cursor.execute(sumquery)
- for t in tmp:
- DaySum = t[0]
- upquery = "SELECT * FROM weekdays"
- c1 = cursor.execute(upquery)
- LastUpper = .0
- for row in c1:
- cod = row[1]
- pkg = row[0]
- prob = cod / float(DaySum)
- if LastUpper != .0:
- lower = LastUpper
- LastUpper = (lower + prob)
- else:
- lower = .0
- LastUpper = prob
- nquery = 'UPDATE weekdays SET probability = %f, \
- lower = %f, upper = %f WHERE pkgs = %d' \
- % (prob,lower,LastUpper,pkg)
- u = cursor2.execute(nquery)
- #====================================
- # End of DoWeekDays
- #====================================
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement