def post(self, topic_id):
username = self.current_user
s = yield gen.maybe_future(
Subscription.get_by_user_topic(username, topic_id))
if s:
raise exceptions.TopicAlreadySubscribed()
else:
yield gen.maybe_future(Subscription.create(username, topic_id))
def paddle():
LOG.debug(
f"paddle callback {request.form.get('alert_name')} {request.form}")
# make sure the request comes from Paddle
if not paddle_utils.verify_incoming_request(dict(request.form)):
LOG.exception("request not coming from paddle. Request data:%s",
dict(request.form))
return "KO", 400
if (request.form.get("alert_name") == "subscription_created"
): # new user subscribes
# the passthrough is json encoded, e.g.
# request.form.get("passthrough") = '{"user_id": 88 }'
passthrough = json.loads(request.form.get("passthrough"))
user_id = passthrough.get("user_id")
user = User.get(user_id)
subscription_plan_id = int(
request.form.get("subscription_plan_id"))
if subscription_plan_id in PADDLE_MONTHLY_PRODUCT_IDS:
plan = PlanEnum.monthly
elif subscription_plan_id in PADDLE_YEARLY_PRODUCT_IDS:
plan = PlanEnum.yearly
else:
LOG.exception(
"Unknown subscription_plan_id %s %s",
subscription_plan_id,
request.form,
)
return "No such subscription", 400
sub = Subscription.get_by(user_id=user.id)
if not sub:
LOG.d(f"create a new Subscription for user {user}")
Subscription.create(
user_id=user.id,
cancel_url=request.form.get("cancel_url"),
update_url=request.form.get("update_url"),
subscription_id=request.form.get("subscription_id"),
event_time=arrow.now(),
next_bill_date=arrow.get(
request.form.get("next_bill_date"),
"YYYY-MM-DD").date(),
plan=plan,
)
else:
LOG.d(f"Update an existing Subscription for user {user}")
sub.cancel_url = request.form.get("cancel_url")
sub.update_url = request.form.get("update_url")
sub.subscription_id = request.form.get("subscription_id")
sub.event_time = arrow.now()
sub.next_bill_date = arrow.get(
request.form.get("next_bill_date"), "YYYY-MM-DD").date()
sub.plan = plan
# make sure to set the new plan as not-cancelled
# in case user cancels a plan and subscribes a new plan
sub.cancelled = False
LOG.debug("User %s upgrades!", user)
db.session.commit()
elif request.form.get(
"alert_name") == "subscription_payment_succeeded":
subscription_id = request.form.get("subscription_id")
LOG.debug("Update subscription %s", subscription_id)
sub: Subscription = Subscription.get_by(
subscription_id=subscription_id)
# when user subscribes, the "subscription_payment_succeeded" can arrive BEFORE "subscription_created"
# at that time, subscription object does not exist yet
if sub:
sub.event_time = arrow.now()
sub.next_bill_date = arrow.get(
request.form.get("next_bill_date"), "YYYY-MM-DD").date()
db.session.commit()
elif request.form.get("alert_name") == "subscription_cancelled":
subscription_id = request.form.get("subscription_id")
sub: Subscription = Subscription.get_by(
subscription_id=subscription_id)
if sub:
# cancellation_effective_date should be the same as next_bill_date
LOG.warning(
"Cancel subscription %s %s on %s, next bill date %s",
subscription_id,
sub.user,
request.form.get("cancellation_effective_date"),
sub.next_bill_date,
)
sub.event_time = arrow.now()
sub.cancelled = True
db.session.commit()
user = sub.user
send_email(
user.email,
"SimpleLogin - what can we do to improve the product?",
render(
"transactional/subscription-cancel.txt",
end_date=request.form.get(
"cancellation_effective_date"),
),
)
else:
return "No such subscription", 400
elif request.form.get("alert_name") == "subscription_updated":
subscription_id = request.form.get("subscription_id")
sub: Subscription = Subscription.get_by(
subscription_id=subscription_id)
if sub:
LOG.debug(
"Update subscription %s %s on %s, next bill date %s",
subscription_id,
sub.user,
request.form.get("cancellation_effective_date"),
sub.next_bill_date,
)
if (int(request.form.get("subscription_plan_id")) ==
PADDLE_MONTHLY_PRODUCT_ID):
plan = PlanEnum.monthly
else:
plan = PlanEnum.yearly
sub.cancel_url = request.form.get("cancel_url")
sub.update_url = request.form.get("update_url")
sub.event_time = arrow.now()
sub.next_bill_date = arrow.get(
request.form.get("next_bill_date"), "YYYY-MM-DD").date()
sub.plan = plan
# make sure to set the new plan as not-cancelled
sub.cancelled = False
db.session.commit()
else:
return "No such subscription", 400
return "OK"
def fake_data():
LOG.d("create fake data")
# Remove db if exist
if os.path.exists("db.sqlite"):
LOG.d("remove existing db file")
os.remove("db.sqlite")
# Create all tables
db.create_all()
# Create a user
user = User.create(
email="*****@*****.**",
name="John Wick",
password="******",
activated=True,
is_admin=True,
enable_otp=False,
otp_secret="base32secret3232",
intro_shown=True,
fido_uuid=None,
)
user.include_sender_in_reverse_alias = None
user.trial_end = None
db.session.commit()
# add a profile picture
file_path = "profile_pic.svg"
s3.upload_from_bytesio(
file_path,
open(os.path.join(ROOT_DIR, "static", "default-icon.svg"), "rb"),
content_type="image/svg",
)
file = File.create(user_id=user.id, path=file_path, commit=True)
user.profile_picture_id = file.id
db.session.commit()
# create a bounced email
alias = Alias.create_new_random(user)
db.session.commit()
bounce_email_file_path = "bounce.eml"
s3.upload_email_from_bytesio(
bounce_email_file_path,
open(os.path.join(ROOT_DIR, "local_data", "email_tests", "2.eml"),
"rb"),
"download.eml",
)
refused_email = RefusedEmail.create(
path=bounce_email_file_path,
full_report_path=bounce_email_file_path,
user_id=user.id,
commit=True,
)
contact = Contact.create(
user_id=user.id,
alias_id=alias.id,
website_email="*****@*****.**",
reply_email="*****@*****.**",
commit=True,
)
EmailLog.create(
user_id=user.id,
contact_id=contact.id,
refused_email_id=refused_email.id,
bounced=True,
commit=True,
)
LifetimeCoupon.create(code="coupon", nb_used=10, commit=True)
# Create a subscription for user
Subscription.create(
user_id=user.id,
cancel_url="https://checkout.paddle.com/subscription/cancel?user=1234",
update_url="https://checkout.paddle.com/subscription/update?user=1234",
subscription_id="123",
event_time=arrow.now(),
next_bill_date=arrow.now().shift(days=10).date(),
plan=PlanEnum.monthly,
commit=True,
)
CoinbaseSubscription.create(user_id=user.id,
end_at=arrow.now().shift(days=10),
commit=True)
api_key = ApiKey.create(user_id=user.id, name="Chrome")
api_key.code = "code"
api_key = ApiKey.create(user_id=user.id, name="Firefox")
api_key.code = "codeFF"
pgp_public_key = open(get_abs_path("local_data/public-pgp.asc")).read()
m1 = Mailbox.create(
user_id=user.id,
email="*****@*****.**",
verified=True,
pgp_public_key=pgp_public_key,
)
m1.pgp_finger_print = load_public_key(pgp_public_key)
db.session.commit()
for i in range(3):
if i % 2 == 0:
a = Alias.create(email=f"e{i}@{FIRST_ALIAS_DOMAIN}",
user_id=user.id,
mailbox_id=m1.id)
else:
a = Alias.create(
email=f"e{i}@{FIRST_ALIAS_DOMAIN}",
user_id=user.id,
mailbox_id=user.default_mailbox_id,
)
db.session.commit()
if i % 5 == 0:
if i % 2 == 0:
AliasMailbox.create(alias_id=a.id,
mailbox_id=user.default_mailbox_id)
else:
AliasMailbox.create(alias_id=a.id, mailbox_id=m1.id)
db.session.commit()
# some aliases don't have any activity
# if i % 3 != 0:
# contact = Contact.create(
# user_id=user.id,
# alias_id=a.id,
# website_email=f"contact{i}@example.com",
# reply_email=f"rep{i}@sl.local",
# )
# db.session.commit()
# for _ in range(3):
# EmailLog.create(user_id=user.id, contact_id=contact.id)
# db.session.commit()
# have some disabled alias
if i % 5 == 0:
a.enabled = False
db.session.commit()
CustomDomain.create(user_id=user.id, domain="ab.cd", verified=True)
CustomDomain.create(user_id=user.id,
domain="very-long-domain.com.net.org",
verified=True)
db.session.commit()
Directory.create(user_id=user.id, name="abcd")
Directory.create(user_id=user.id, name="xyzt")
db.session.commit()
# Create a client
client1 = Client.create_new(name="Demo", user_id=user.id)
client1.oauth_client_id = "client-id"
client1.oauth_client_secret = "client-secret"
client1.published = True
db.session.commit()
RedirectUri.create(client_id=client1.id, uri="https://ab.com")
client2 = Client.create_new(name="Demo 2", user_id=user.id)
client2.oauth_client_id = "client-id2"
client2.oauth_client_secret = "client-secret2"
client2.published = True
db.session.commit()
ClientUser.create(user_id=user.id, client_id=client1.id, name="Fake Name")
referral = Referral.create(user_id=user.id,
code="REFCODE",
name="First referral")
db.session.commit()
for i in range(6):
Notification.create(user_id=user.id,
message=f"""Hey hey <b>{i}</b> """ * 10)
db.session.commit()
User.create(
email="*****@*****.**",
password="******",
activated=True,
referral_id=referral.id,
)
db.session.commit()
def fake_data():
LOG.d("create fake data")
# Remove db if exist
if os.path.exists("db.sqlite"):
LOG.d("remove existing db file")
os.remove("db.sqlite")
# Create all tables
db.create_all()
# Create a user
user = User.create(
email="*****@*****.**",
name="John Wick",
password="******",
activated=True,
is_admin=True,
enable_otp=False,
otp_secret="base32secret3232",
intro_shown=True,
fido_uuid=None,
)
db.session.commit()
user.trial_end = None
LifetimeCoupon.create(code="coupon", nb_used=10)
db.session.commit()
# Create a subscription for user
Subscription.create(
user_id=user.id,
cancel_url="https://checkout.paddle.com/subscription/cancel?user=1234",
update_url="https://checkout.paddle.com/subscription/update?user=1234",
subscription_id="123",
event_time=arrow.now(),
next_bill_date=arrow.now().shift(days=10).date(),
plan=PlanEnum.monthly,
)
db.session.commit()
api_key = ApiKey.create(user_id=user.id, name="Chrome")
api_key.code = "code"
api_key = ApiKey.create(user_id=user.id, name="Firefox")
api_key.code = "codeFF"
m1 = Mailbox.create(
user_id=user.id,
email="*****@*****.**",
verified=True,
pgp_finger_print="fake fingerprint",
)
db.session.commit()
for i in range(3):
if i % 2 == 0:
a = Alias.create(email=f"e{i}@{FIRST_ALIAS_DOMAIN}",
user_id=user.id,
mailbox_id=m1.id)
else:
a = Alias.create(
email=f"e{i}@{FIRST_ALIAS_DOMAIN}",
user_id=user.id,
mailbox_id=user.default_mailbox_id,
)
db.session.commit()
if i % 5 == 0:
if i % 2 == 0:
AliasMailbox.create(alias_id=a.id,
mailbox_id=user.default_mailbox_id)
else:
AliasMailbox.create(alias_id=a.id, mailbox_id=m1.id)
db.session.commit()
# some aliases don't have any activity
# if i % 3 != 0:
# contact = Contact.create(
# user_id=user.id,
# alias_id=a.id,
# website_email=f"contact{i}@example.com",
# reply_email=f"rep{i}@sl.local",
# )
# db.session.commit()
# for _ in range(3):
# EmailLog.create(user_id=user.id, contact_id=contact.id)
# db.session.commit()
# have some disabled alias
if i % 5 == 0:
a.enabled = False
db.session.commit()
CustomDomain.create(user_id=user.id, domain="ab.cd", verified=True)
CustomDomain.create(user_id=user.id,
domain="very-long-domain.com.net.org",
verified=True)
db.session.commit()
Directory.create(user_id=user.id, name="abcd")
Directory.create(user_id=user.id, name="xyzt")
db.session.commit()
# Create a client
client1 = Client.create_new(name="Demo", user_id=user.id)
client1.oauth_client_id = "client-id"
client1.oauth_client_secret = "client-secret"
client1.published = True
db.session.commit()
RedirectUri.create(client_id=client1.id, uri="https://ab.com")
client2 = Client.create_new(name="Demo 2", user_id=user.id)
client2.oauth_client_id = "client-id2"
client2.oauth_client_secret = "client-secret2"
client2.published = True
db.session.commit()
ClientUser.create(user_id=user.id, client_id=client1.id, name="Fake Name")
referral = Referral.create(user_id=user.id,
code="REFCODE",
name="First referral")
db.session.commit()
for i in range(6):
Notification.create(user_id=user.id,
message=f"""Hey hey <b>{i}</b> """ * 10)
db.session.commit()
User.create(
email="*****@*****.**",
name="Winston",
password="******",
activated=True,
referral_id=referral.id,
)
db.session.commit()
def paddle():
LOG.debug(
"paddle callback %s %s %s %s %s",
request.form.get("alert_name"),
request.form.get("email"),
request.form.get("customer_name"),
request.form.get("subscription_id"),
request.form.get("subscription_plan_id"),
)
# make sure the request comes from Paddle
if not paddle_utils.verify_incoming_request(dict(request.form)):
LOG.error("request not coming from paddle. Request data:%s",
dict(request.form))
return "KO", 400
if (request.form.get("alert_name") == "subscription_created"
): # new user subscribes
user_email = request.form.get("email")
user = User.get_by(email=user_email)
if (int(request.form.get("subscription_plan_id")) ==
PADDLE_MONTHLY_PRODUCT_ID):
plan = PlanEnum.monthly
else:
plan = PlanEnum.yearly
sub = Subscription.get_by(user_id=user.id)
if not sub:
LOG.d("create a new sub")
Subscription.create(
user_id=user.id,
cancel_url=request.form.get("cancel_url"),
update_url=request.form.get("update_url"),
subscription_id=request.form.get("subscription_id"),
event_time=arrow.now(),
next_bill_date=arrow.get(
request.form.get("next_bill_date"),
"YYYY-MM-DD").date(),
plan=plan,
)
else:
LOG.d("update existing sub %s", sub)
sub.cancel_url = request.form.get("cancel_url")
sub.update_url = request.form.get("update_url")
sub.subscription_id = request.form.get("subscription_id")
sub.event_time = arrow.now()
sub.next_bill_date = arrow.get(
request.form.get("next_bill_date"), "YYYY-MM-DD").date()
sub.plan = plan
LOG.debug("User %s upgrades!", user)
db.session.commit()
elif request.form.get("alert_name") == "subscription_updated":
subscription_id = request.form.get("subscription_id")
LOG.debug("Update subscription %s", subscription_id)
sub: Subscription = Subscription.get_by(
subscription_id=subscription_id)
sub.event_time = arrow.now()
sub.next_bill_date = arrow.get(request.form.get("next_bill_date"),
"YYYY-MM-DD").date()
db.session.commit()
elif request.form.get("alert_name") == "subscription_cancelled":
subscription_id = request.form.get("subscription_id")
LOG.error("Cancel subscription %s", subscription_id)
sub: Subscription = Subscription.get_by(
subscription_id=subscription_id)
if sub:
sub.cancelled = True
db.session.commit()
return "OK"
def fake_data():
LOG.d("create fake data")
# Remove db if exist
if os.path.exists("db.sqlite"):
LOG.d("remove existing db file")
os.remove("db.sqlite")
# Create all tables
db.create_all()
# Create a user
user = User.create(
email="*****@*****.**",
name="John Wick",
password="******",
activated=True,
is_admin=True,
otp_secret="base32secret3232",
)
db.session.commit()
LifetimeCoupon.create(code="coupon", nb_used=10)
db.session.commit()
# Create a subscription for user
Subscription.create(
user_id=user.id,
cancel_url="https://checkout.paddle.com/subscription/cancel?user=1234",
update_url="https://checkout.paddle.com/subscription/update?user=1234",
subscription_id="123",
event_time=arrow.now(),
next_bill_date=arrow.now().shift(days=10).date(),
plan=PlanEnum.monthly,
)
db.session.commit()
api_key = ApiKey.create(user_id=user.id, name="Chrome")
api_key.code = "code"
GenEmail.create_new(user.id, "e1@")
GenEmail.create_new(user.id, "e2@")
GenEmail.create_new(user.id, "e3@")
CustomDomain.create(user_id=user.id, domain="ab.cd", verified=True)
CustomDomain.create(user_id=user.id,
domain="very-long-domain.com.net.org",
verified=True)
db.session.commit()
Directory.create(user_id=user.id, name="abcd")
Directory.create(user_id=user.id, name="xyzt")
db.session.commit()
# Create a client
client1 = Client.create_new(name="Demo", user_id=user.id)
client1.oauth_client_id = "client-id"
client1.oauth_client_secret = "client-secret"
client1.published = True
db.session.commit()
RedirectUri.create(client_id=client1.id, uri="https://ab.com")
client2 = Client.create_new(name="Demo 2", user_id=user.id)
client2.oauth_client_id = "client-id2"
client2.oauth_client_secret = "client-secret2"
client2.published = True
db.session.commit()
db.session.commit()
def paddle():
LOG.debug(f"paddle callback {request.form.get('alert_name')} {request.form}")
# make sure the request comes from Paddle
if not paddle_utils.verify_incoming_request(dict(request.form)):
LOG.error(
"request not coming from paddle. Request data:%s", dict(request.form)
)
return "KO", 400
if (
request.form.get("alert_name") == "subscription_created"
): # new user subscribes
user_email = request.form.get("email")
user = User.get_by(email=user_email)
if (
int(request.form.get("subscription_plan_id"))
== PADDLE_MONTHLY_PRODUCT_ID
):
plan = PlanEnum.monthly
else:
plan = PlanEnum.yearly
sub = Subscription.get_by(user_id=user.id)
if not sub:
LOG.d(f"create a new Subscription for user {user}")
Subscription.create(
user_id=user.id,
cancel_url=request.form.get("cancel_url"),
update_url=request.form.get("update_url"),
subscription_id=request.form.get("subscription_id"),
event_time=arrow.now(),
next_bill_date=arrow.get(
request.form.get("next_bill_date"), "YYYY-MM-DD"
).date(),
plan=plan,
)
else:
LOG.d(f"Update an existing Subscription for user {user}")
sub.cancel_url = request.form.get("cancel_url")
sub.update_url = request.form.get("update_url")
sub.subscription_id = request.form.get("subscription_id")
sub.event_time = arrow.now()
sub.next_bill_date = arrow.get(
request.form.get("next_bill_date"), "YYYY-MM-DD"
).date()
sub.plan = plan
# make sure to set the new plan as not-cancelled
# in case user cancels a plan and subscribes a new plan
sub.cancelled = False
LOG.debug("User %s upgrades!", user)
db.session.commit()
elif request.form.get("alert_name") == "subscription_payment_succeeded":
subscription_id = request.form.get("subscription_id")
LOG.debug("Update subscription %s", subscription_id)
sub: Subscription = Subscription.get_by(subscription_id=subscription_id)
# when user subscribes, the "subscription_payment_succeeded" can arrive BEFORE "subscription_created"
# at that time, subscription object does not exist yet
if sub:
sub.event_time = arrow.now()
sub.next_bill_date = arrow.get(
request.form.get("next_bill_date"), "YYYY-MM-DD"
).date()
db.session.commit()
elif request.form.get("alert_name") == "subscription_cancelled":
subscription_id = request.form.get("subscription_id")
sub: Subscription = Subscription.get_by(subscription_id=subscription_id)
if sub:
# cancellation_effective_date should be the same as next_bill_date
LOG.warning(
"Cancel subscription %s %s on %s, next bill date %s",
subscription_id,
sub.user,
request.form.get("cancellation_effective_date"),
sub.next_bill_date,
)
sub.event_time = arrow.now()
sub.cancelled = True
db.session.commit()
else:
return "No such subscription", 400
elif request.form.get("alert_name") == "subscription_updated":
subscription_id = request.form.get("subscription_id")
sub: Subscription = Subscription.get_by(subscription_id=subscription_id)
if sub:
LOG.debug(
"Update subscription %s %s on %s, next bill date %s",
subscription_id,
sub.user,
request.form.get("cancellation_effective_date"),
sub.next_bill_date,
)
if (
int(request.form.get("subscription_plan_id"))
== PADDLE_MONTHLY_PRODUCT_ID
):
plan = PlanEnum.monthly
else:
plan = PlanEnum.yearly
sub.cancel_url = request.form.get("cancel_url")
sub.update_url = request.form.get("update_url")
sub.event_time = arrow.now()
sub.next_bill_date = arrow.get(
request.form.get("next_bill_date"), "YYYY-MM-DD"
).date()
sub.plan = plan
# make sure to set the new plan as not-cancelled
sub.cancelled = False
db.session.commit()
else:
return "No such subscription", 400
return "OK"
def fake_data():
LOG.d("create fake data")
# Create a user
user = User.create(
email="*****@*****.**",
name="John Wick",
password="******",
activated=True,
is_admin=True,
# enable_otp=True,
otp_secret="base32secret3232",
intro_shown=True,
fido_uuid=None,
)
user.trial_end = None
Session.commit()
# add a profile picture
file_path = "profile_pic.svg"
s3.upload_from_bytesio(
file_path,
open(os.path.join(ROOT_DIR, "static", "default-icon.svg"), "rb"),
content_type="image/svg",
)
file = File.create(user_id=user.id, path=file_path, commit=True)
user.profile_picture_id = file.id
Session.commit()
# create a bounced email
alias = Alias.create_new_random(user)
Session.commit()
bounce_email_file_path = "bounce.eml"
s3.upload_email_from_bytesio(
bounce_email_file_path,
open(os.path.join(ROOT_DIR, "local_data", "email_tests", "2.eml"),
"rb"),
"download.eml",
)
refused_email = RefusedEmail.create(
path=bounce_email_file_path,
full_report_path=bounce_email_file_path,
user_id=user.id,
commit=True,
)
contact = Contact.create(
user_id=user.id,
alias_id=alias.id,
website_email="*****@*****.**",
reply_email="*****@*****.**",
commit=True,
)
EmailLog.create(
user_id=user.id,
contact_id=contact.id,
alias_id=contact.alias_id,
refused_email_id=refused_email.id,
bounced=True,
commit=True,
)
LifetimeCoupon.create(code="lifetime-coupon", nb_used=10, commit=True)
Coupon.create(code="coupon", commit=True)
# Create a subscription for user
Subscription.create(
user_id=user.id,
cancel_url="https://checkout.paddle.com/subscription/cancel?user=1234",
update_url="https://checkout.paddle.com/subscription/update?user=1234",
subscription_id="123",
event_time=arrow.now(),
next_bill_date=arrow.now().shift(days=10).date(),
plan=PlanEnum.monthly,
commit=True,
)
CoinbaseSubscription.create(user_id=user.id,
end_at=arrow.now().shift(days=10),
commit=True)
api_key = ApiKey.create(user_id=user.id, name="Chrome")
api_key.code = "code"
api_key = ApiKey.create(user_id=user.id, name="Firefox")
api_key.code = "codeFF"
pgp_public_key = open(get_abs_path("local_data/public-pgp.asc")).read()
m1 = Mailbox.create(
user_id=user.id,
email="*****@*****.**",
verified=True,
pgp_public_key=pgp_public_key,
)
m1.pgp_finger_print = load_public_key(pgp_public_key)
Session.commit()
# [email protected] is in a LOT of data breaches
Alias.create(email="*****@*****.**",
user_id=user.id,
mailbox_id=m1.id)
for i in range(3):
if i % 2 == 0:
a = Alias.create(email=f"e{i}@{FIRST_ALIAS_DOMAIN}",
user_id=user.id,
mailbox_id=m1.id)
else:
a = Alias.create(
email=f"e{i}@{FIRST_ALIAS_DOMAIN}",
user_id=user.id,
mailbox_id=user.default_mailbox_id,
)
Session.commit()
if i % 5 == 0:
if i % 2 == 0:
AliasMailbox.create(alias_id=a.id,
mailbox_id=user.default_mailbox_id)
else:
AliasMailbox.create(alias_id=a.id, mailbox_id=m1.id)
Session.commit()
# some aliases don't have any activity
# if i % 3 != 0:
# contact = Contact.create(
# user_id=user.id,
# alias_id=a.id,
# website_email=f"contact{i}@example.com",
# reply_email=f"rep{i}@sl.local",
# )
# Session.commit()
# for _ in range(3):
# EmailLog.create(user_id=user.id, contact_id=contact.id, alias_id=contact.alias_id)
# Session.commit()
# have some disabled alias
if i % 5 == 0:
a.enabled = False
Session.commit()
custom_domain1 = CustomDomain.create(user_id=user.id,
domain="ab.cd",
verified=True)
Session.commit()
Alias.create(
user_id=user.id,
email="*****@*****.**",
mailbox_id=user.default_mailbox_id,
custom_domain_id=custom_domain1.id,
commit=True,
)
Alias.create(
user_id=user.id,
email="*****@*****.**",
mailbox_id=user.default_mailbox_id,
custom_domain_id=custom_domain1.id,
commit=True,
)
Directory.create(user_id=user.id, name="abcd")
Directory.create(user_id=user.id, name="xyzt")
Session.commit()
# Create a client
client1 = Client.create_new(name="Demo", user_id=user.id)
client1.oauth_client_id = "client-id"
client1.oauth_client_secret = "client-secret"
Session.commit()
RedirectUri.create(client_id=client1.id,
uri="https://your-website.com/oauth-callback")
client2 = Client.create_new(name="Demo 2", user_id=user.id)
client2.oauth_client_id = "client-id2"
client2.oauth_client_secret = "client-secret2"
Session.commit()
ClientUser.create(user_id=user.id, client_id=client1.id, name="Fake Name")
referral = Referral.create(user_id=user.id,
code="Website",
name="First referral")
Referral.create(user_id=user.id, code="Podcast", name="First referral")
Payout.create(user_id=user.id,
amount=1000,
number_upgraded_account=100,
payment_method="BTC")
Payout.create(
user_id=user.id,
amount=5000,
number_upgraded_account=200,
payment_method="PayPal",
)
Session.commit()
for i in range(6):
Notification.create(user_id=user.id,
message=f"""Hey hey <b>{i}</b> """ * 10)
Session.commit()
user2 = User.create(
email="*****@*****.**",
password="******",
activated=True,
referral_id=referral.id,
)
Mailbox.create(user_id=user2.id,
email="*****@*****.**",
verified=True)
Session.commit()
ManualSubscription.create(
user_id=user2.id,
end_at=arrow.now().shift(years=1, days=1),
comment="Local manual",
commit=True,
)
SLDomain.create(domain="premium.com", premium_only=True, commit=True)
hibp1 = Hibp.create(name="first breach",
description="breach description",
commit=True)
hibp2 = Hibp.create(name="second breach",
description="breach description",
commit=True)
breached_alias1 = Alias.create(email="*****@*****.**",
user_id=user.id,
mailbox_id=m1.id,
commit=True)
breached_alias2 = Alias.create(email="*****@*****.**",
user_id=user.id,
mailbox_id=m1.id,
commit=True)
AliasHibp.create(hibp_id=hibp1.id, alias_id=breached_alias1.id)
AliasHibp.create(hibp_id=hibp2.id, alias_id=breached_alias2.id)
# old domain will have ownership_verified=True
CustomDomain.create(user_id=user.id,
domain="old.com",
verified=True,
ownership_verified=True)
def buy_with_bank():
course_id = request.args.get('course')
if course_id == None:
return redirect(url_for('course.index'))
bank_form = EnrollBankForm()
cc_form = EnrollCreditCardForm()
course_id = int(course_id)
user = User(current_user)
courses = []
courses.append(course_id)
with Transaction().set_context(courses=courses):
user = User(current_user)
if user.active_membership:
return redirect(url_for('course.index'))
courses = Course.search([('id', '=', course_id)], limit=1)
if len(courses) == 1:
course, = courses
if bank_form.bank_membership.data == 'MONTHLY':
service_id = course.service.id
else:
service_id = course.yearly_service.id
service = Service(service_id)
if course:
web_course = course
ip_address = request.remote_addr
if not ip_address or ip_address == '127.0.0.1':
ip_address = '186.189.195.217'
if ipaddress.ip_address(ip_address).is_private:
ip_address = '186.189.195.217'
access_token = 'cda5ddffc1e6b7'
handler = ipinfo.getHandler(access_token)
details = handler.getDetails(ip_address)
country_code = details.country
country_code = str(country_code)
lcase_country_code = country_code.lower()
currency_id = 16
for currency in data:
if str(currency['code']) == country_code:
currency_id = currency['id']
break
currency = Currency(currency_id)
if bank_form.validate_on_submit():
party = user.party
today = date.today()
subscriptions = Subscription.search([
('party', '=', party.id),
('state', '=', 'running'),
('lines.service', '=', service_id),
])
if len(subscriptions) >= 1:
print("NO ACTIVE SUBSCRIPTIONS")
return redirect(url_for('course.payment'))
else:
enrolment, = Product.search([('is_enrolment', '=', True)], limit=1)
payment_term, = PaymentTerm.search([()], limit=1)
address = user.party.addresses[0]
new_subscription = Subscription.create([{
'party':
user.party.id,
'start_date':
today,
'invoice_start_date':
today,
'invoice_recurrence':
service.consumption_recurrence,
'enrolment':
enrolment.id,
'unit_price_enrolment':
0,
'invoice_address':
address,
'is_online':
True,
'payment_term':
payment_term.id,
}])
new_subscription_line, = SubscriptionLine.create([{
'subscription':
new_subscription[0].id,
'service':
service.id,
'quantity':
1,
'start_date':
today,
'consumption_recurrence':
service.consumption_recurrence,
'unit':
1,
'unit_price':
service.product.list_price,
}])
Subscription.quote(new_subscription)
Subscription.run(new_subscription)
SaleSubscriptionLine.generate_consumption(date=today,
party=user.party)
Subscription.generate_invoice(date=today, party=user.party)
invoices = Invoice.search([('party', '=', user.party)],
order=[('number', 'DESC')])
if len(invoices) >= 1:
for invoice in invoices:
if invoice.state == 'draft':
Invoice.post([invoice])
current_line = None
current_invoice = None
for invoice in invoices:
if invoice.state not in ['cancel', 'paid']:
move = invoice.move
for line in move.lines:
if line.debit > 0:
current_line = MoveLine(line.id)
current_invoice = invoice
break
if not current_line or not current_invoice:
return redirect(url_for('main.welcome'))
def _group_payment_key(payment):
return (('journal', payment.journal.id), ('kind',
payment.kind))
def _new_group(values):
return PaymentGroup(**values)
invoice = current_invoice
amount = current_invoice.total_amount
ticket = bank_form.ticket.data
journal, = Journal.search([('name', '=', 'DCOMPENSA')], limit=1)
new_payment = Payment.create([{
'journal': journal.id,
'kind': 'receivable',
'party': party.id,
'line': current_line.id,
'description': ticket,
'amount': current_line.debit,
}])
Payment.approve(new_payment)
payment, = new_payment
groups = []
new_payment = sorted(new_payment, key=_group_payment_key)
for key, grouped_payments in groupby(new_payment,
key=_group_payment_key):
def group():
group = _new_group(dict(key))
group.save()
groups.append(group)
return group
Payment.process(list(grouped_payments), group)
body = "Hemos recibido la siguiente informacion: " + \
"Nombre: "+ party.name + \
" \n Ticket: " + ticket + \
" \n Usuario: " + user.email
msg = Message('Usuario Web API: '+ party.name, \
sender = '*****@*****.**', \
recipients = ['*****@*****.**'])
msg.body = "Usuario Web API " + body
mail.send(msg)
return redirect(url_for('main.welcome'))
return render_template('course/enroll.html',
cc_form=cc_form,
bank_form=bank_form,
user=user,
web_course=course,
currency=currency)
def buy_with_card():
course_id = request.args.get('course')
if course_id == None:
return redirect(url_for('course.index'))
bank_form = EnrollBankForm()
cc_form = EnrollCreditCardForm()
if cc_form.validate_on_submit():
course_id = int(course_id)
user = User(current_user)
courses = []
courses.append(course_id)
with Transaction().set_context(courses=courses):
user = User(current_user)
if user.active_membership:
return redirect(url_for('course.index'))
courses = Course.search([('id', '=', course_id)], limit=1)
if len(courses) == 1:
course, = courses
if cc_form.cc_membership.data == 'MONTHLY':
service_id = course.service.id
else:
service_id = course.yearly_service.id
service = Service(service_id)
party = user.party
today = date.today()
subscriptions = Subscription.search([
('party', '=', party.id),
('state', '=', 'running'),
('is_online', '=', True),
('lines.service', '=', service_id),
])
if len(subscriptions) >= 1:
return redirect(url_for('course.payment'))
else:
enrolment, = Product.search([('is_enrolment', '=', True)], limit=1)
payment_term, = PaymentTerm.search([()], limit=1)
address = user.party.addresses[0]
new_subscription = Subscription.create([{
'party':
user.party.id,
'start_date':
today,
'invoice_start_date':
today,
'invoice_recurrence':
service.consumption_recurrence,
'enrolment':
enrolment.id,
'unit_price_enrolment':
0,
'invoice_address':
address,
'payment_term':
payment_term.id,
'is_online':
True,
}])
new_subscription_line, = SubscriptionLine.create([{
'subscription':
new_subscription[0].id,
'service':
service.id,
'quantity':
1,
'start_date':
today,
'consumption_recurrence':
service.consumption_recurrence,
'unit':
1,
'unit_price':
service.product.list_price,
}])
Subscription.quote(new_subscription)
Subscription.run(new_subscription)
SaleSubscriptionLine.generate_consumption(date=today,
party=user.party)
Subscription.generate_invoice(date=today, party=user.party)
invoices = Invoice.search([('party', '=', user.party)],
order=[('number', 'DESC')])
if len(invoices) >= 1:
for invoice in invoices:
if invoice.state == 'draft':
Invoice.post([invoice])
current_invoice = None
for invoice in invoices:
if invoice.state not in ['cancel', 'paid']:
current_invoice = invoice
break
credentials = current_app.config['QPAYPRO_CREDENTIALS']
cc_form = CreditCardForm()
defaults = {}
defaults['sessionid'] = uniqid()
defaults['orgid'] = 'k8vif92e' #'1snn5n9w' TEST OR PRODUCTION
defaults['merchantid'] = credentials[
'merchantid'] #'visanetgt_qpay'
defaults['user'] = user
defaults['cc_form'] = cc_form
url_test = 'https://sandbox.qpaypro.com/payment/api_v1'
url_production = 'https://payments.qpaypro.com/checkout/api_v1'
credit_card = str(cc_form.card_number.data)
credit_card.replace(' ', '')
success = True
params = {}
params['x_login'] = credentials['x_login'] #'visanetgt_qpay'
params['x_private_key'] = credentials[
'x_private_key'] # '88888888888'
params['x_api_secret'] = credentials[
'x_api_secret'] #'99999999999'
params['x_product_id'] = current_invoice.lines[0].product.id #6
params['x_audit_number'] = random.randint(1, 999999)
params[
'x_fp_sequence'] = current_invoice.number #1988679099 #INVOICE SEQUENCE NUMBER
params[
'x_invoice_num'] = current_invoice.id #random.randint(1,999999) #INVOICE SEQUENCE NUMBER
params['x_fp_timestamp'] = time()
params['x_currency_code'] = 'GTQ'
params[
'x_amount'] = current_invoice.total_amount #1.00 #invoice.total_amount
params['x_line_item'] = current_invoice.lines[
0].product.name #'T-shirt Live Dreams<|>w01<|><|>1<|>1000.00<|>N'
params['x_freight'] = 0.00
params['x_email'] = '*****@*****.**'
params['cc_name'] = cc_form.name.data #'john doe'
params['cc_number'] = credit_card #'4111111111111111'
params['cc_exp'] = str(cc_form.expiration_date.data) #'01/21'
params['cc_cvv2'] = cc_form.code.data #'4567'
params['cc_type'] = 'visa'
params['x_first_name'] = user.party.name #'john'
params['x_last_name'] = user.party.name #'doe'
params['x_company'] = 'API CENTRO' #'Company'
params['x_address'] = user.party.city #'711-2880 Nulla'
params['x_city'] = user.party.city #'Guatemala'
params['x_state'] = user.party.city #'Guatemala'
params['x_country'] = user.party.country #'Guatemala'
params['x_zip'] = '09001'
params['x_relay_response'] = 'none'
params['x_relay_url'] = 'none'
params['x_type'] = 'AUTH_ONLY'
params['x_method'] = 'CC'
params[
'http_origin'] = 'https://www.apixela.net' #'http://local.test.com'
params['visaencuotas'] = 0
params['device_fingerprint_id'] = defaults['sessionid']
params['bank_form'] = bank_form
params['cc_form'] = cc_form
response = requests.post(url=url_production, params=params)
res = response.raise_for_status()
response_content = response.json()
#response_content = {'responseCode':"100",
# 'idTransaction':"102030"}
response_code = response_content['responseCode']
message = get_code(response_code)
if response_code == "00":
transaction_id = response_content['idTransaction']
Invoice.card_payment_succeed([current_invoice],
reference=transaction_id)
else:
success = False
Subscription.draft(new_subscription)
Subscription.cancel(new_subscription)
Invoice.cancel([current_invoice])
if success:
return render_template('bienvenido.html',
flash_message=message,
user=user)
else:
return render_template(
'bienvenido.html',
user=user,
flash_message=message,
)
return render_template('enroll.html', cc_form=cc_form, bank_form=bank_form)
def yearly_enroll():
course_id = request.args.get('course')
if course_id == None:
return redirect(url_for('course.index'))
course_id = int(course_id)
user = User(current_user)
courses = []
courses.append(course_id)
with Transaction().set_context(courses=courses):
user = User(current_user)
if user.active_membership:
return redirect(url_for('course.index'))
courses = Course.search([('id', '=', course_id)], limit=1)
if len(courses) == 1:
course, = courses
service_id = course.yearly_service.id
service = Service(service_id)
party = user.party
today = date.today()
subscriptions = Subscription.search([
('party', '=', party.id),
('state', '=', 'running'),
('lines.service', '=', service_id),
])
if len(subscriptions) >= 1:
return redirect(url_for('course.payment'))
else:
enrolment, = Product.search([('is_enrolment', '=', True)], limit=1)
payment_term, = PaymentTerm.search([()], limit=1)
address = user.party.addresses[0]
new_subscription = Subscription.create([{
'party':
user.party.id,
'start_date':
today,
'invoice_start_date':
today,
'invoice_recurrence':
service.consumption_recurrence,
'enrolment':
enrolment.id,
'unit_price_enrolment':
0,
'invoice_address':
address,
'is_online':
True,
'payment_term':
payment_term.id,
}])
new_subscription_line, = SubscriptionLine.create([{
'subscription':
new_subscription[0].id,
'service':
service.id,
'quantity':
1,
'start_date':
today,
'consumption_recurrence':
service.consumption_recurrence,
'unit':
1,
'unit_price':
service.product.list_price,
}])
Subscription.quote(new_subscription)
Subscription.run(new_subscription)
SaleSubscriptionLine.generate_consumption(date=today, party=user.party)
Subscription.generate_invoice(date=today, party=user.party)
invoices = Invoice.search([('party', '=', user.party)])
if len(invoices) >= 1:
for invoice in invoices:
if invoice.state == 'draft':
Invoice.post([invoice])
return redirect(url_for('course.payment'))
