Im confused on the path i need to take. I got a simple website set up with a stripe checkout. Then i have my working database. What needs to connect the two and handle the webhooks and such? All i need to do is transfer data that is given at checkout to my db. Like 5 columns. Just not sure how to get started.
#🔒 Trying to integrate Stripe payment with my database
lapis ruin
dull galleonBOT
Im confused on the path i need to take. I got a simple website set up with a str...
@lapis ruin
Python help channel opened
tight pumice
What's your code look like so far?
lapis ruin
I have a discord bot, a database, and a website with a checkout through Stripe
the discord bot and database are good. It checks to see if the current server ID is inside of the column 'premium_server_id' after every command. tested and it works great
i just need stripe to get the server_id from the user at checkout and insert that into my database so its fully automated
i think what i need is a "webhook endpoint" in my server? Both the database and discord bot are hosted on the same server. So they interact through localhost
tight pumice
Your website is flask Django FastAPI?
tight pumice
Plain HTML?
lapis ruin
ohhh
i just used wordpress that redirects you to my stripe checkout URL if you press the button
figured that was probably safer than any low-end version of wordpress
https://docs.stripe.com/payments/handling-payment-events
im trying to piece together this, since i think this is what i need
tight pumice
So you'll need to make your own webhook handler with Django/FastAPI/flask/quart etc
tight pumice
How do you run your bot?
lapis ruin
a python script i leave running
tight pumice
Probably you want systemd or supervisord to run both
lapis ruin
i used to have a .service file that started everything
tight pumice
If you're running quart/FastAPI you can integrate your bot into the same process
lapis ruin
i dont think i am
tight pumice
i dont think i am
*If you decide to use quart/FastAPI
You'll need something to handle web requests
If you use an asgi server you can run your bot in your lifespan task
lapis ruin
# app.py
#
# Use this sample code to handle webhook events in your integration.
#
# 1) Paste this code into a new file (app.py)
#
# 2) Install dependencies
# pip3 install flask
# pip3 install stripe
#
# 3) Run the server on http://localhost:4242
# python3 -m flask run --port=4242
import json
import os
import stripe
from flask import Flask, jsonify, request
# The library needs to be configured with your account's secret key.
# Ensure the key is kept out of any version control system you might be using.
stripe.api_key = "sk_test_..."
# This is your Stripe CLI webhook secret for testing your endpoint locally.
endpoint_secret = '******'
app = Flask(__name__)
@app.route('/webhook', methods=['POST'])
def webhook():
event = None
payload = request.data
sig_header = request.headers['STRIPE_SIGNATURE']
try:
event = stripe.Webhook.construct_event(
payload, sig_header, endpoint_secret
)
except ValueError as e:
# Invalid payload
raise e
except stripe.error.SignatureVerificationError as e:
# Invalid signature
raise e
# Handle the event
if event['type'] == 'checkout.session.completed':
session = event['data']['object']
# ... handle other event types
else:
print('Unhandled event type {}'.format(event['type']))
return jsonify(success=True)
``` I got this off the stripe websiteso i think it wants me to use flask
lapis ruin
is that the only thing i need to run then?
dull galleonBOT
Python help channel closed