Skip to content

Instantly share code, notes, and snippets.

View marcusmotill's full-sized avatar
👋

Marcus Motill marcusmotill

👋
4 followers · 2 following
  • Austin, TX
View GitHub Profile
@marcusmotill
marcusmotill / teachable_bug.md
Last active September 12, 2024 19:10

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
marcusmotill / init_output.md
Last active February 23, 2023 14:33
init output pipeline noti data
@marcusmotill
marcusmotill / sortem.js
Created November 17, 2022 19:09
sort two arrays
// 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
marcusmotill / diethon.diff
Created August 17, 2022 20:04
--- 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
marcusmotill / sourceContentTypeByTeam.es
Created July 14, 2022 16:26
Query for seeing how many activity defs exist on a team for a given sourceContent type
{
"query": {
"bool": {
"must": [
{
"has_parent": {
"parent_type": "globalDefinition",
"score": true,
"query": {
"term": {
@marcusmotill
marcusmotill / lineItem.md
Created August 13, 2018 17:15
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
marcusmotill / content-filters.md
Created January 31, 2018 15:47

Opportunity Close Date

{"##RANGE##":{"opportunity.closeDate":{"lte":"now-15M/d"}}}
@marcusmotill
marcusmotill / actions.md
Created April 27, 2017 21:12

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
marcusmotill / atom-settings
Last active November 1, 2016 21:05
automatic update by http://atom.io/packages/sync-settings
//settings
@marcusmotill
marcusmotill / fasdf.md
Created April 25, 2016 18:39

Hello!