ianfitzpatrick

import csv
from django.contrib.auth.models import User

fields = ['username', 'first_name', 'last_name', 'is_active', 'email', 'id', 'last_login', 'date_joined']
users = User.objects.filter(is_active=True, facebookprofile__isnull=False, child_of__isnull=True)
users = users.values_list(*fields)
user_count = users.count()

with open('users.csv', 'w', newline='') as csvfile:
    writer = csv.writer(csvfile)

ianfitzpatrick

Nordstrom URLs that return no product data

https://www.nordstrom.com/s/florsheim-midtown-zip-boot-men/4426406

request:

curl  -X GET \
  "https://api.impact.com/Mediapartners/IRN6QgzwA28B1813001GRTYxxecDodJqn1/Catalogs/ItemSearch?Query=CatalogItemId='4426406'" \
  --header 'Accept: application/json' \
  --header 'IR-Version: 13' \

ianfitzpatrick

# Find orphaned group invite/request notifications
from django.core.paginator import Paginator
from notifications.constants import NOTIFY_INVITE, NOTIFY_REQUEST
from notifications.models import Notification

problem_objs = []
objs = Notification.objects.filter(sub_type__in=[NOTIFY_INVITE, NOTIFY_REQUEST])
len_objs = objs.count()
chunk_size = 25000
i = 0

ianfitzpatrick

from django.db.models import Q
from profiles.models import UserProfile

# First remove all empty birthdays
# profiles = UserProfile.objects.exclude(
#     Q(birthday_month__isnull=True) & Q(birthday_day__isnull=True) & Q(birthday_year__isnull=True)
# )

yo = UserProfile.objects.filter(
    birthday_month__isnull=True, birthday_day__isnull=True, 

ianfitzpatrick

docker buildx build --target base --platform linux/amd64 -t giftster-app-base-x86 .
docker image save giftster-app-base-x86 -o ~/Downloads/giftster-app-base-x86.tar
sftp -i ~/.ssh/id_ed25519_ianatgiftsterdotcom uploader@ec2-3-231-108-58.compute-1.amazonaws.com
put /Users/ianfitzpatrick/Downloads/giftster-app-base-x86.tarls

ianfitzpatrick

import sys
from django.core.paginator import Paginator
from notifications.constants import NOTIFY_UPDATE
from lists.models import List
from lists.permissions.permissions import can_read_wishlist_via_shared_group
from notifications.models import Notification

list_ids = List.objects.filter(privacy_level=List.PUBLIC).values_list('id', flat=True)
objs = Notification.objects.filter(sub_type=NOTIFY_UPDATE, object_id__in=list_ids)

ianfitzpatrick

As a reminder:

> git remote -v
eyk-stag        ssh://git@eyk-builder.giftster-us-east-2.giftster.ey.io:2222/giftster-app-staging.git (fetch)
eyk-stag        ssh://git@eyk-builder.giftster-us-east-2.giftster.ey.io:2222/giftster-app-staging.git (push)

----

❯ git push eyk-stag dev

ianfitzpatrick

INSERT INTO `fetch_matchdomain` (`id`, `currency_symbol`, `domain_name`, `priority`, `region`, `description`, `notes`, `provider_id`, `exact_match`)
VALUES
	(1, X'24', X'616D617A6F6E2E636F6D', 1, X'5553', X'416D617A6F6E2E636F6D205553', X'', 2, NULL),
	(5, X'24', X'616D617A6F6E2E6361', 1, X'4341', X'416D617A6F6E2043616E616461', X'', 2, NULL),
	(6, X'C2A3', X'616D617A6F6E2E636F2E756B', 1, X'554B', X'416D617A6F6E20556E69746564204B696E67646F6D', X'', 2, NULL),
	(7, X'E282AC', X'616D617A6F6E2E6465', 1, X'4445', X'416D617A6F6E204765726D616E79', X'', 2, NULL),
	(8, X'24', X'7777772E746F79737275732E636F6D', 1, X'', X'546F79732052205573', X'546F7973205220557320697320626C6F636B696E672064696666626F742C20736F20747279696E67207769746820456D6265642E6C7920666F722061207768696C65202031312F3230206261636B20746F2064696666626F742063616E20676574207072696365', 3, NULL),
	(11, X'24', X'666F6F746C6F636B65722E636F2E756B', 1, X'', X'', X'', 3, NULL),
	(12, X'24', X'7777772E6C65626F7264656C646567656F7267657474652E636F6D', 1, X'', X'', X'

ianfitzpatrick

# Find orphaned group invite/request notifications
from django.core.paginator import Paginator
from notifications.constants import NOTIFY_INVITE, NOTIFY_REQUEST
from notifications.models import Notification

problem_objs = []
objs = Notification.objects.filter(sub_type__in=[NOTIFY_INVITE, NOTIFY_REQUEST])
len_objs = objs.count()
chunk_size = 25000
i = 0

ianfitzpatrick

EYK_PROFILE=/.eyk/admin.json eyk apps EYK_PROFILE=/.eyk/admin.json eyk register https://eyk.giftster-us-east-2.giftster.ey.io --username=ianfitzpatrick --password= --email=ian@giftster.com --login=true --ssl-verify=true EYK_PROFILE=~/.eyk/admin.json eyk perms:create ianfitzpatrick -a giftster-static-staging

eyk login https://eyk.giftster-us-east-2.giftster.ey.io