marcusmotill

Teachable Bug Report

Below is documentation and a reproduction script showcasing a bug in the teach pricing_plans api (have not confirmed if the same issue exists in other public APIs).

Issue: Inconsistent results in the '/v1/pricing_plans' list API.

During a project to upload our teachable data to a SQL database for reporting purposes I noticed that some data was missing. Upon further inspection it appears that the list API returns inconsistent results. In the below code, I loop over all pages of the list api multiple times and compare their results. As you will see there is not only missing data between full loops but occasionally duplicate data gets returned within the same loop. Interestingly, the number of results is always the same. I would suspect there may be a missing default sort param yeilding the inconsistent results.

Python Script to reproduce

marcusmotill

Note: This is the first export from production of the pipeline notification emails (just the table data) for each company and then each user in the company.

Generating notifications for 58 companies

Company: Vive RPM (2)

To email: [email protected]

user_id	user_email	user_first_name	user_last_name	created	regressed	progressed
165	[email protected]	Aaron	Gaunt	0	0	0
166	[email protected]	Austin	Herzer	0	0	0
173	[email protected]	Dani	Catena	0	0	0

marcusmotill

// input is two ascending sorted arrays
// output is the product of the two arrays sorted ascending

// inputs
const input1 = [1, 2, 3, 4, 99];
const input2 = [8, 10, 99, 101, 102];

// define variables needed in loop
let output = [];
let pointer1 = 0;

marcusmotill

--- a/forecast_api/storage/postgres_connection.py
+++ b/forecast_api/storage/postgres_connection.py
@@ -1,7 +1,7 @@
 import contextlib
 import logging
 
-import psycopg2
+import pg8000.dbapi
 
 logger = logging.getLogger(__name__)

marcusmotill

{
    "query": {
        "bool": {
            "must": [
                {
                    "has_parent": {
                        "parent_type": "globalDefinition",
                        "score": true,
                        "query": {
                            "term": {

marcusmotill

OpportunityLineItem	ContractLineItem	WorkOrderLineItem
ConnectionReceivedId	AssetId	Address
ConnectionSentId	Description	AssetId
CurrencyIsoCode	Discount	City
Description	EndDate	Country
Discount	LastReferencedDate	CurrencyIsoCode
HasQuantitySchedule	LastViewedDate	Description
HasRevenueSchedule	LineItemNumber	Discount
HasSchedule	ListPrice	Duration

marcusmotill

Opportunity Close Date

{"##RANGE##":{"opportunity.closeDate":{"lte":"now-15M/d"}}}

marcusmotill

Actions

Action Life Cycle

Action Create, then...

• User (click) Dismiss → Action state = dismiss, user will never see that action again
  • Dismiss event created
• User (click) Complete → Action state = complete, user will never see that action again
  • Complete event created
• Action definition indicates action is deprecated -> Action state = deprecate, user will never see that action again unless un-deprecated
• Action definition indicates action is disabled -> Action state = deprecate, user will never see that action again unless enabled

marcusmotill

//settings

marcusmotill

Hello!