Choose Your Branch!

This repo contains different versions of the starter code for aa11-sql-query-improvement, with each version stored in a program-specific branch. To download or clone the correct branch, choose a method (tiged, zip, or clone) and follow the instructions for your specific program.

• tiged
• Zip
• Clone

tiged the branch

This is the most straightforward way to clone the project into a folder named aa11-sql-query-improvement. In the directory where you want the project to appear, simply run the following command for your program and preferred authentication method:

Online Full-Time

To authenticate with a Personal Access Token over HTTPS, run

npx tiged https://github.com/appacademy/aa11-sql-query-improvement#full-time aa11-sql-query-improvement

To authenticate with SSH, run

npx tiged appacademy/aa11-sql-query-improvement#full-time aa11-sql-query-improvement

Online Part-Time

To authenticate with a Personal Access Token over HTTPS, run

npx tiged https://github.com/appacademy/aa11-sql-query-improvement#part-time aa11-sql-query-improvement

To authenticate with SSH, run

npx tiged appacademy/aa11-sql-query-improvement#part-time aa11-sql-query-improvement

---

Note: The first time you run npx tiged, you will likely be asked if you want to install tiged. Go ahead and install it.

Unless you cloned the project into an already existing local git repo, run

cd aa11-sql-query-improvement && git init

to initialize the project as a git repository that you can connect to a remote repo in your personal GitHub account.

Download the branch as a .zip

READ THESE INSTRUCTIONS FULLY BEFORE IMPLEMENTING THEM AS YOU WILL LOSE ACCESS TO THIS PAGE ONCE YOU SWITCH TO YOUR PROGRAM BRANCH.

If you want to download your branch as a .zip file, click on the branch button to the upper-left of the file list above--the button should currently read "main"--and select your program from the resulting dropdown menu. This will take you to your program's branch. Once there, click the green "Code" button and select "Download ZIP" from the bottom of the menu. Move the .zip to your desired location and unzip!

Unless you unzipped the project in an already existing local git repo, run

cd aa11-sql-query-improvement && git init

to initialize the project as a git repository that you can connect to a remote repo in your personal GitHub account.

(To return to this page in your browser, simply select the "main" branch again.)

Clone the branch

To clone the branch, open a terminal and cd into the directory where you want the repo to go. Then run the command specified below for your program and preferred authentication method:

Online Full-Time

To authenticate with a Personal Access Token over HTTPS, run

git clone --branch full-time --single-branch https://github.com/appacademy/aa11-sql-query-improvement.git

To authenticate with SSH, run

git clone --branch full-time --single-branch [email protected]:appacademy/aa11-sql-query-improvement.git

Online Part-Time

To authenticate with a Personal Access Token over HTTPS, run

git clone --branch part-time --single-branch https://github.com/appacademy/aa11-sql-query-improvement.git

To authenticate with SSH, run

git clone --branch part-time --single-branch [email protected]:appacademy/aa11-sql-query-improvement.git

When you clone a repo, the cloned repo's remote origin will still point to the original repo.

To reassign the clone to your personal GitHub account (so you can push and pull changes), create a remote aa11-sql-query-improvement repo at https://github.com. Then, back in your local terminal, cd into the cloned repo and run the following commands to link the cloned repo to your newly created remote and push up the current code (replace with your actual GitHub username):

git remote set-url origin https://github.com/<YOUR-GH-USERNAME>/aa11-sql-query-improvement
git push -u origin

Note: The first command differs from the command GitHub tells you to use to connect an existing repo: you should run git remote set-url (as above) rather than git remote add (as GitHub recommends).

If you instead clone the project into a folder already initialized as a local git repo, you just need to remove the clone's remote connection to the original repo. cd into the cloned repo and run

rm -rf .git

WARNING: rm -rf is a dangerous command that will delete the specified directory--here, .git--and all of the directory's subfolders without any verification. Make sure you are in the cloned repo when you run this command.