def create_card_holds(self, cursor):
# Get the list of participants to create card holds for
participants = cursor.all("""
SELECT *
FROM payday_participants
WHERE old_balance < giving_today
AND has_credit_card
AND is_suspicious IS false
""")
if not participants:
return {}
# Fetch existing holds
participant_ids = set(p.id for p in participants)
holds = self.fetch_card_holds(participant_ids)
# Create new holds and check amounts of existing ones
def f(p):
amount = p.giving_today - p.old_balance
if p.id in holds:
if amount >= MINIMUM_CHARGE:
charge_amount = upcharge(amount)[0]
if holds[p.id].amount >= charge_amount:
return
else:
# The amount is too low, cancel the hold and make a new one
cancel_card_hold(holds.pop(p.id))
else:
# not up to minimum charge level. cancel the hold
cancel_card_hold(holds.pop(p.id))
return
if amount >= MINIMUM_CHARGE:
hold, error = create_card_hold(self.db, p, amount)
if error:
return 1
else:
holds[p.id] = hold
threaded_map(f, participants)
# Update the values of card_hold_ok in our temporary table
if not holds:
return {}
cursor.run(
"""
UPDATE payday_participants p
SET card_hold_ok = true
WHERE p.id IN %s
""", (tuple(holds.keys()), ))
return holds
def create_card_holds(self, cursor):
# Get the list of participants to create card holds for
participants = cursor.all("""
SELECT *
FROM payday_participants
WHERE old_balance < giving_today
AND has_credit_card
AND is_suspicious IS false
""")
if not participants:
return {}
# Fetch existing holds
participant_ids = set(p.id for p in participants)
holds = self.fetch_card_holds(participant_ids)
# Create new holds and check amounts of existing ones
def f(p):
amount = p.giving_today - p.old_balance
if p.id in holds:
if amount >= MINIMUM_CHARGE:
charge_amount = upcharge(amount)[0]
if holds[p.id].amount >= charge_amount:
return
else:
# The amount is too low, cancel the hold and make a new one
cancel_card_hold(holds.pop(p.id))
else:
# not up to minimum charge level. cancel the hold
cancel_card_hold(holds.pop(p.id))
return
if amount >= MINIMUM_CHARGE:
hold, error = create_card_hold(self.db, p, amount)
if error:
return 1
else:
holds[p.id] = hold
threaded_map(f, participants)
# Update the values of card_hold_ok in our temporary table
if not holds:
return {}
cursor.run("""
UPDATE payday_participants p
SET card_hold_ok = true
WHERE p.id IN %s
""", (tuple(holds.keys()),))
return holds
def settle_card_holds(self, cursor, holds):
log("Settling card holds.")
participants = cursor.all("""
SELECT *
FROM payday_participants
WHERE new_balance < 0
""")
participants = [p for p in participants if p.id in holds]
log("Capturing card holds.")
# Capture holds to bring balances back up to (at least) zero
def capture(p):
amount = -p.new_balance
capture_card_hold(self.db, p, amount, holds.pop(p.id))
threaded_map(capture, participants)
log("Captured %i card holds." % len(participants))
log("Canceling card holds.")
# Cancel the remaining holds
threaded_map(cancel_card_hold, holds.values())
log("Canceled %i card holds." % len(holds))
def settle_card_holds(self, cursor, holds):
log("Settling card holds.")
participants = cursor.all("""
SELECT *
FROM payday_participants
WHERE new_balance < 0
""")
participants = [p for p in participants if p.id in holds]
log("Capturing card holds.")
# Capture holds to bring balances back up to (at least) zero
def capture(p):
amount = -p.new_balance
capture_card_hold(self.db, p, amount, holds.pop(p.id))
threaded_map(capture, participants)
log("Captured %i card holds." % len(participants))
log("Canceling card holds.")
# Cancel the remaining holds
threaded_map(cancel_card_hold, holds.values())
log("Canceled %i card holds." % len(holds))
def sync_all(db):
dirty = db.all(
'SELECT package_manager, name FROM packages WHERE readme_raw IS NULL '
'ORDER BY package_manager DESC, name DESC')
threaded_map(Syncer(db), dirty, 4)
