Karen Chan 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

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.

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/

(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]

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:

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>

	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

	#!/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

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

	import psycopg2
	import sqlalchemy

	#!/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