def envrcpt(self, to, *str): # <> if self.mailfrom == "": return Milter.CONTINUE # de +ify addr = Milter.utils.parse_addr(to.lower()) rcpt = addr[0] + "@" + addr[1] userdata = lib.user.GWUser(email=rcpt) # non exising user if not userdata.check(): return Milter.CONTINUE if userdata.cancharge == 0 or userdata.masterpubkey_btc == None or userdata.feeamount == 0: return Milter.CONTINUE h = hashlib.new('sha256') h.update(self.mailfrom + "!" + rcpt) digest = h.digest() cur = BMMySQL().conn().cursor(MySQLdb.cursors.DictCursor) cur.execute("SELECT id, status FROM sendercharge WHERE hash = %s", (digest)) result = False for row in cur.fetchall(): result = row if result and result['status'] == 1: cur.close() return Milter.CONTINUE if result: # result['status'] == 0 cur.execute( "SELECT address, amount FROM invoice WHERE sendercharge_id = %s", (row['id'])) for row in cur.fetchall(): result = row url = lib.payment.create_payment_url(result['address'], 'BTC', result['amount'], rcpt, 'Sending emails') else: # no record btcaddress, amount = lib.payment.create_invoice_user(rcpt) url = lib.payment.create_payment_url(btcaddress, 'BTC', amount, rcpt, 'Sending emails') cur.execute( "INSERT INTO sendercharge (hash, status) values (%s, %s)", (digest, 0)) sendercharge_id = cur.lastrowid cur.execute( "UPDATE invoice SET sendercharge_id = %s WHERE address = %s and coin = 'BTC'", (sendercharge_id, btcaddress)) cur.close() url = url.replace("%", "%%") self.setreply("550", "5.7.0", "PAYMENT REQUIRED: %s" % url) return Milter.REJECT
def create_invoice_domain (domain, payer): cur = BMMySQL().conn().cursor(MySQLdb.cursors.DictCursor) filterwarnings('ignore', category = MySQLdb.Warning) cur.execute ("SELECT bm, masterpubkey_btc, offset_btc, feeamount, feecurrency FROM domain WHERE name = %s AND active = 1", (domain)) result = False for row in cur.fetchall(): result = row while result: if result['masterpubkey_btc'][0:4] == "xpub": # BIP44 dpk1 = bitcoin.bip32_ckd(result['masterpubkey_btc'], 0) dpk2 = bitcoin.bip32_ckd(dpk1, result['offset_btc']) pubkey = bitcoin.bip32_extract_key(dpk2) else: # Electrum 1.x pubkey = bitcoin.electrum_pubkey(result['masterpubkey_btc'], result['offset_btc']) address = bitcoin.pubkey_to_address(pubkey) bitcoind_importaddress(address) cur.execute ("UPDATE domain SET offset_btc = offset_btc + 1 WHERE name = %s AND active = 1 AND masterpubkey_btc = %s", (domain, result['masterpubkey_btc'])) if result['feecurrency'] in ("USD", "GBP", "EUR"): result['feeamount'] /= decimal.Decimal(get_bitcoin_price(result['feecurrency'])) cur.execute ("INSERT IGNORE INTO invoice (issuer, payer, address, coin, amount, type, paid) VALUES (%s, %s, %s, 'BTC', %s, 0, 0)", (result['bm'], payer, address, result['feeamount'])) # invoice already exists for that address, increment if cur.rowcount == 0: cur.execute ("SELECT bm, masterpubkey_btc, offset_btc, feeamount, feecurrency FROM domain WHERE name = %s AND active = 1", (domain)) result = False for row in cur.fetchall(): result = row continue cur.close() return address, result['feeamount']; cur.close() return False
def envrcpt (self, to, *str): # <> if self.mailfrom == "": return Milter.CONTINUE # de +ify addr = Milter.utils.parse_addr(to.lower()) rcpt = addr[0] + "@" + addr[1] BMMySQL().db.ping(True) userdata = lib.user.GWUser(email = rcpt) # non exising user if not userdata.check(): return Milter.CONTINUE if userdata.cancharge == 0 or userdata.masterpubkey_btc == None or userdata.feeamount == 0: return Milter.CONTINUE h = hashlib.new('sha256') h.update (self.mailfrom + "!" + rcpt); digest = h.digest() cur = BMMySQL().db.cursor(MySQLdb.cursors.DictCursor) cur.execute("SELECT id, status FROM sendercharge WHERE hash = %s", (digest)) result = False for row in cur.fetchall(): result = row if result and result['status'] == 1: cur.close() return Milter.CONTINUE if result: # result['status'] == 0 cur.execute("SELECT address, amount FROM invoice WHERE sendercharge_id = %s", (row['id'])) for row in cur.fetchall(): result = row url = lib.payment.create_payment_url(result['address'], 'BTC', result['amount'], rcpt, 'Sending emails') else: # no record btcaddress, amount = lib.payment.create_invoice_user(rcpt) url = lib.payment.create_payment_url(btcaddress, 'BTC', amount, rcpt, 'Sending emails') cur.execute("INSERT INTO sendercharge (hash, status) values (%s, %s)", (digest, 0)) sendercharge_id = cur.lastrowid cur.execute("UPDATE invoice SET sendercharge_id = %s WHERE address = %s and coin = 'BTC'", (sendercharge_id, btcaddress)) cur.close() url = url.replace("%", "%%") self.setreply("550", "5.7.0", "PAYMENT REQUIRED: %s" % url) return Milter.REJECT
def key_from_mysql(key): cur = BMMySQL().conn().cursor(MySQLdb.cursors.DictCursor) logging.info("Importing GPG keys from SQL for %s", key) cur.execute("SELECT data FROM gpg WHERE email = %s", (key)) for row in cur.fetchall(): import_key(row['data']) cur.close()
def create_invoice_user (email): BMMySQL().db.ping(True) cur = BMMySQL().db.cursor(MySQLdb.cursors.DictCursor) cur.execute ("SELECT bm, masterpubkey_btc, offset_btc, feeamount, feecurrency FROM user WHERE email = %s AND active = 1", (email)) result = False for row in cur.fetchall(): result = row if result: if result['masterpubkey_btc'][0:4] == "xpub": # BIP44 dpk1 = pybitcointools.bip32_ckd(result['masterpubkey_btc'], 0) dpk2 = pybitcointools.bip32_ckd(dpk1, result['offset_btc']) pubkey = pybitcointools.bip32_extract_key(dpk2) else: # Electrum 1.x pubkey = pybitcointools.electrum_pubkey(result['masterpubkey_btc'], result['offset_btc']) address = pybitcointools.pubkey_to_address(pubkey) cur.execute ("UPDATE user SET offset_btc = offset_btc + 1 WHERE email = %s AND active = 1 AND masterpubkey_btc = %s", (email, result['masterpubkey_btc'])) if result['feecurrency'] in ("USD", "GBP", "EUR"): result['feeamount'] /= decimal.Decimal(get_bitcoin_price(result['feecurrency'])) cur.execute ("INSERT INTO invoice (issuer, address, coin, amount, type, paid) VALUES (%s, %s, 'BTC', %s, 1, 0)", (result['bm'], address, result['feeamount'])) bitcoind_importaddress(address) cur.close() return address, result['feeamount']; cur.close() return False
def create_invoice_user (email): cur = BMMySQL().conn().cursor(MySQLdb.cursors.DictCursor) cur.execute ("SELECT bm, masterpubkey_btc, offset_btc, feeamount, feecurrency FROM user WHERE email = %s AND active = 1", (email)) result = False for row in cur.fetchall(): result = row if result: if result['masterpubkey_btc'][0:4] == "xpub": # BIP44 dpk1 = bitcoin.bip32_ckd(result['masterpubkey_btc'], 0) dpk2 = bitcoin.bip32_ckd(dpk1, result['offset_btc']) pubkey = bitcoin.bip32_extract_key(dpk2) else: # Electrum 1.x pubkey = bitcoin.electrum_pubkey(result['masterpubkey_btc'], result['offset_btc']) address = bitcoin.pubkey_to_address(pubkey) bitcoind_importaddress(address) cur.execute ("UPDATE user SET offset_btc = offset_btc + 1 WHERE email = %s AND active = 1 AND masterpubkey_btc = %s", (email, result['masterpubkey_btc'])) if result['feecurrency'] in ("USD", "GBP", "EUR"): result['feeamount'] /= decimal.Decimal(get_bitcoin_price(result['feecurrency'])) cur.execute ("INSERT INTO invoice (issuer, address, coin, amount, type, paid) VALUES (%s, %s, 'BTC', %s, 1, 0)", (result['bm'], address, result['feeamount'])) cur.close() return address, result['feeamount']; cur.close() return False
def load(self, bm=None, uid=None, email=None, unalias=False): cur = BMMySQL().conn().cursor(MySQLdb.cursors.DictCursor) filterwarnings('ignore', category=MySQLdb.Warning) multirow = False self.uid = None if bm != None: cur.execute("SELECT * FROM user WHERE bm = %s", (bm)) elif uid != None: cur.execute("SELECT * FROM user WHERE uid = %s", (uid)) elif email != None: if unalias: alias = GWAlias(email=email).target if alias: email = alias cur.execute("SELECT * FROM user WHERE email = %s", (email)) else: # if no arguments, return all multirow = True cur.execute("SELECT * FROM user ORDER BY email") for row in cur.fetchall(): if multirow: print "%1s %-40s %-39s " % ("*" if row['active'] else " ", row['email'], row['bm']) else: for column in row: setattr(self, column, row[column]) cur.close() if hasattr(self, 'email'): self.aliases = GWAlias(alias=self.email).aliases
def load(self, bm = None, uid = None, email = None, unalias = False): BMMySQL().db.ping(True) cur = BMMySQL().db.cursor(MySQLdb.cursors.DictCursor) filterwarnings('ignore', category = MySQLdb.Warning) multirow = False self.uid = None if bm != None: cur.execute ("SELECT * FROM user WHERE bm = %s", (bm)) elif uid != None: cur.execute ("SELECT * FROM user WHERE uid = %s", (uid)) elif email != None: if unalias: alias = GWAlias(email).target if alias: email = alias cur.execute ("SELECT * FROM user WHERE email = %s", (email)) else: # if no arguments, return all multirow = True cur.execute ("SELECT * FROM user ORDER BY email") for row in cur.fetchall(): if multirow: print "%1s %-40s %-39s " % ("*" if row['active'] else " ", row['email'], row['bm']) else: for column in row: setattr(self, column, row[column]) cur.close()
def getSchedule(key): cur = BMMySQL().conn().cursor(MySQLdb.cursors.DictCursor) cur.execute("SELECT ts FROM schedules WHERE id = %s", (key)) ret = None for row in cur.fetchall(): ret = row['ts'] cur.close() return ret
def payment_exists_domain (domain, payer): cur = BMMySQL().conn().cursor(MySQLdb.cursors.DictCursor) cur.execute ("SELECT address, amount FROM invoice WHERE type = 0 AND payer = %s AND paid = '0000-00-00 00:00:00'", (payer)) result = False for row in cur.fetchall(): result = row if result: return result['address'], result['amount'] cur.close() return False, False
def payment_exists_domain (domain, payer): BMMySQL().db.ping(True) cur = BMMySQL().db.cursor(MySQLdb.cursors.DictCursor) cur.execute ("SELECT address, amount FROM invoice WHERE type = 0 AND payer = %s AND paid = '0000-00-00 00:00:00'", (payer)) result = False for row in cur.fetchall(): result = row if result: return result['address'], result['amount'] cur.close() return False, False
def __init__(self, email=None, alias=None): self.aliases = [] self.target = None cur = BMMySQL().conn().cursor(MySQLdb.cursors.DictCursor) result = False if email: seen = {email: True} src = email while not result: cur.execute("SELECT target FROM alias WHERE alias = %s", (src)) result = True for row in cur.fetchall(): result = False seen[row['target']] = True src = row['target'] for column in row: setattr(self, column, row[column]) elif alias: cur.execute("SELECT alias FROM alias WHERE target = %s", (alias)) for row in cur.fetchall(): self.aliases.append(row['alias']) cur.close()
def create_invoice_domain (domain, payer): BMMySQL().db.ping(True) cur = BMMySQL().db.cursor(MySQLdb.cursors.DictCursor) filterwarnings('ignore', category = MySQLdb.Warning) cur.execute ("SELECT bm, masterpubkey_btc, offset_btc, feeamount, feecurrency FROM domain WHERE name = %s AND active = 1", (domain)) result = False for row in cur.fetchall(): result = row while result: if result['masterpubkey_btc'][0:4] == "xpub": # BIP44 dpk1 = pybitcointools.bip32_ckd(result['masterpubkey_btc'], 0) dpk2 = pybitcointools.bip32_ckd(dpk1, result['offset_btc']) pubkey = pybitcointools.bip32_extract_key(dpk2) else: # Electrum 1.x pubkey = pybitcointools.electrum_pubkey(result['masterpubkey_btc'], result['offset_btc']) address = pybitcointools.pubkey_to_address(pubkey) cur.execute ("UPDATE domain SET offset_btc = offset_btc + 1 WHERE name = %s AND active = 1 AND masterpubkey_btc = %s", (domain, result['masterpubkey_btc'])) if result['feecurrency'] in ("USD", "GBP", "EUR"): result['feeamount'] /= decimal.Decimal(get_bitcoin_price(result['feecurrency'])) cur.execute ("INSERT IGNORE INTO invoice (issuer, payer, address, coin, amount, type, paid) VALUES (%s, %s, %s, 'BTC', %s, 0, 0)", (result['bm'], payer, address, result['feeamount'])) # invoice already exists for that address, increment if cur.rowcount == 0: cur.execute ("SELECT bm, masterpubkey_btc, offset_btc, feeamount, feecurrency FROM domain WHERE name = %s AND active = 1", (domain)) result = False for row in cur.fetchall(): result = row continue bitcoind_importaddress(address) cur.close() return address, result['feeamount']; cur.close() return False
def __init__(self, email): self.alias = None self.target = None BMMySQL().db.ping(True) cur = BMMySQL().db.cursor(MySQLdb.cursors.DictCursor) result = False seen = {email: True} src = email while not result: cur.execute ("SELECT target FROM alias WHERE alias = %s", (src)) result = True for row in cur.fetchall(): result = False seen[row['target']] = True src = row['target'] for column in row: setattr(self, column, row[column])
def __init__(self, domain = None): self.name = None self.active = None BMMySQL().db.ping(True) cur = BMMySQL().db.cursor(MySQLdb.cursors.DictCursor) filterwarnings('ignore', category = MySQLdb.Warning) multirow = False if domain != None: cur.execute ("SELECT * FROM domain WHERE active = 1 AND name = %s", (domain)) else: multirow = True cur.execute ("SELECT * FROM domain WHERE active = 1") for row in cur.fetchall(): if multirow: print "%40s %1u" % (row['name'], row['active']) else: self.name = row['name'] self.active = row['active'] cur.close()
def __init__(self, domain=None): self.name = None self.active = None cur = BMMySQL().conn().cursor(MySQLdb.cursors.DictCursor) filterwarnings('ignore', category=MySQLdb.Warning) multirow = False if domain != None: cur.execute("SELECT * FROM domain WHERE active = 1 AND name = %s", (domain)) else: multirow = True cur.execute("SELECT * FROM domain WHERE active = 1") for row in cur.fetchall(): if multirow: print "%40s %1u" % (row['name'], row['active']) else: self.name = row['name'] self.active = row['active'] cur.close()
def key_from_mysql(key): cur = BMMySQL().db.cursor(MySQLdb.cursors.DictCursor) logger.info("Importing GPG keys from SQL for %s", key) cur.execute ("SELECT data FROM gpg WHERE email = %s", (key)) for row in cur.fetchall(): import_key(row['data'])
filterwarnings('ignore', category=MySQLdb.Warning) #amount = txinfo['amount'] for detail in txinfo['details']: if detail['category'] == "receive": print detail['address'] + " -> " + str(detail['amount']) cur.execute( """INSERT IGNORE INTO payment (address, coin, txid, amount, confirmations) VALUES (%s, %s, %s, %s, %s)""", (detail['address'], coin, txid, detail['amount'], txinfo['confirmations'])) if txinfo['confirmations'] == 0: # select from invoice cur.execute( "SELECT amount, paid, type, payer, sendercharge_id FROM invoice WHERE address = %s AND coin = %s", (detail['address'], coin)) for row in cur.fetchall(): invoice = row # fetch totalpaid = 0 cur.execute( "SELECT amount FROM payment WHERE address = %s AND coin = %s AND confirmations = 0", (detail['address'], coin)) for row in cur.fetchall(): payment = row totalpaid += payment[ 'amount'] # fixme floating rounding problems? # fetch if invoice['paid'] == None or invoice['paid'] <= datetime.datetime( 1971, 1, 1) and totalpaid >= invoice['amount']: cur.execute( "UPDATE invoice SET paid = NOW() WHERE address = %s AND coin = %s ",
while BMAPI().conn() is False: print "Failure connecting to API, sleeping..." time.sleep(random.random()+0.5) filterwarnings('ignore', category = MySQLdb.Warning) #amount = txinfo['amount'] for detail in txinfo['details']: if detail['category'] == "receive": print detail['address'] + " -> " + str(detail['amount']) cur.execute ( """INSERT IGNORE INTO payment (address, coin, txid, amount, confirmations) VALUES (%s, %s, %s, %s, %s)""", (detail['address'], coin, txid, detail['amount'], txinfo['confirmations'])) if txinfo['confirmations'] == 0: # select from invoice cur.execute ("SELECT amount, paid, type, payer, sendercharge_id FROM invoice WHERE address = %s AND coin = %s", (detail['address'], coin)) for row in cur.fetchall(): invoice = row # fetch totalpaid = 0 cur.execute ("SELECT amount FROM payment WHERE address = %s AND coin = %s AND confirmations = 0", (detail['address'], coin)) for row in cur.fetchall(): payment = row totalpaid += payment['amount'] # fixme floating rounding problems? # fetch if invoice['paid'] == None or invoice['paid'] <= datetime.datetime(1971, 1, 1) and totalpaid >= invoice['amount']: cur.execute ("UPDATE invoice SET paid = NOW() WHERE address = %s AND coin = %s ", (detail['address'], coin)) if invoice['type'] == 0: incomingamount = decimal.Decimal(str(detail['amount'])) if incomingamount < invoice['amount']: months = 0 else: