karenc

About SQLAlchemy database persistence

Problem

User deactivation didn't include code to persist to the database (e.g. db.session.merge(user)). Why did the user deactivation test pass?

Links to code (before fix)

• User deactivation code (resources): https://github.com/WildMeOrg/houston/blob/c35500bec2d324775935009fe5451aef683023fb/app/modules/users/resources.py#L195-L210

karenc

Obtaining file:///tmp/houston
  Installing build dependencies: started
  Installing build dependencies: finished with status 'done'
  Getting requirements to build wheel: started
  Getting requirements to build wheel: finished with status 'done'
    Preparing wheel metadata: started
    Preparing wheel metadata: finished with status 'done'
Collecting pygeocoder
  Downloading pygeocoder-1.2.5.tar.gz (8.1 kB)
Collecting Flask<2,>=1.1

karenc

Git rebase Example

You have a branch based on origin/develop (commit 300). It has 2 commits My commit 1 and My commit 2. origin/develop has a new commit commit 301. Now you need to rebase your branch so your commits are on top of the current origin/develop.

karenc

#!/usr/bin/env python3
from datetime import datetime
import glob
import os
import pathlib
import re
import subprocess
import sys
import tempfile
from urllib.parse import urlparse, urljoin

karenc

#!/usr/bin/env python
import functools
import os
import sqlite3
import time

import psycopg2
import sqlalchemy

karenc

#!/usr/bin/env python3
# 1. Generate testdb1 using origin/develop
#    `wbia-init-testdbs -r`
# 2. Back up the directory
#    `mv var/data/testdb1 var/data/testdb1.orig`
# 3. Generate testdb1 using origin/mmulich/sqlalchemy-queries
#    `wbia-init-testdbs -r`
# 4. Run this script to find the differences in the sqlite databases:
#    `./compare_databases.py var/data/testdb1.orig/ var/data/testdb1/`
import difflib

karenc

About

This repo ce-test-recipes is a test repo for uploading to test pypi using concourse so we can prepare for the move from Jenkins to concourse for deployment when we are ready.

Using test pypi

https://packaging.python.org/guides/using-testpypi/

karenc

(taken from https://github.com/openstax/cnx/issues/757)

Investigation

The servers running legacy are prod04 and prod05. This can be found on cnx-deploy:

[zclient:children]

karenc

CNX Legacy Tips and Tricks

What is (cnx) legacy?

You can go to the legacy site by clicking on the link "CNX Author | Legacy Site" on the top right corner of a page on cnx.

You can also add legacy to the url, for example:

karenc

The Problem

When downloading a new collection on katalyst01 col30381 using neb get, Ryan got this error:

karen@yachiyo:~/src/nebuchadnezzar$ neb get katalyst01 col30381 latest
Traceback (most recent call last):
  File "./venv/bin/neb", line 11, in <module>