Hello, I need assistance with an assignmnt in Python. I have attache the instructions below as well as the worksheet that should be used at the very bottom!

Thanks in advance!!!

_____________________________________________________________________________________________

Instructions

General Description

In this assignment, you will warm up your coding skills with one python project example. This example is very important because all the following assignments and final project are based on this project. Next, I will lead you to download this project and run it. You need to repeat all the steps and submit your work by using the attached Assignment 1 template.

Computer Requirements

Before we start, you have to make sure you have successfully installed Python, Python IDE (I recommend PyCharm), and PostgreSQL Database.

I believe you have learned how to set up Python, here is the link for PostgreSQL Database: https://www.postgresql.org/download/

If you never used a Python IDE, you need to see the tutorial: https://www.jetbrains.com/pycharm/learn/

You can choose any Python IDE if you are a Python Developer.

Now Let’s start

Setting Up a Database

To get started, you’re going to set up a fresh PostgreSQL database and populate it with data. Throughout the tutorial, you’ll use this database for witnessing firsthand how Python SQL injection works.

Step 1. Install PostgreSQL

You can download the installer from https://www.postgresql.org/download/

In the installation process, you will create a database “postgres” for user “postgres” by default if you didn’t change the names.

Step 2. Open the SQL Shell Tool

Step 3. Check your user and password

Input nothing for Server, Database, and Port. Just press Enter.

Input “postgres” in Username Enter

Input your password in Password for user postgresEnter

Then you will see the following in your window

Step 4. Add a User Table

Input the following command then you will see the following picture

psycopgtest=# CREATE TABLE users (

username varchar(30),

admin boolean);

Step 5. Add two users

Input the following command then you will see the following picture

Change one of the users to your name and set false (non-admin user)

psycopgtest=# INSERT INTO users

(username, admin)

VALUES

(‘ran’, true),

(‘YourName‘, false);

Step 6. Check all the users in Database

Input the following command then you will see the following picture

psycopgtest=# SELECT * FROM users;

Setting Up Python Environment

Step 7. Make sure you have installed Python

Check your python version with the command: python –version

If you have python set up on your computer, you will see a version number. If not, you need to install Python first. I believe you have learned how to do it in programming class.

Step 8. Install psycopg2

Use the command: sudo pip install psycopg2-binary

If you have error like the following picture, you need to update your pip by using the command: pip install –upgrade pip

After the upgrade, re-try: sudo pip install psycopg2-binary

If you still failed, you may need to re-install your python.

Run Python Code

Step 9. Download and run the python file “DatabaseInjectionExample.py”

• Open the downloaded file in any IDE or editor.
• [Only if you changed default database name and username] Change the database name and username to your database name and username
• Change the password to your password.
• Change the name “yan” in line 30 to your name used in Step. 5

Then, you will see the printout:

Step 10. Check an un-defined user

Change the name in line 30 to “foo”, then, you will see the error because there is no user “foo” in the database.

Step 11. Try database Injection attack

Change the name in line 30 to “‘; select true; –“

The code of line 30 will become to

print(is_admin(“‘; select true; –“))

Then run to see the output:

True? What happened? You hacked your Database!!

Step 12. Change your “username” to admin user illegally.

Add the following code after line 30. Don’t forget to change “Yan” to your username.

True? What happened? You hacked your Database!!

print(is_admin(“‘; update users set admin = ‘true’ where username = ‘yan’; select true; –“))
print(is_admin(“yan”))

Then you will see the output shows you are the admin user now!!

__________________________________________________________________________

https://kennesaw.view.usg.edu/d2l/le/dropbox/23998…

(worksheet that should be used)

Upload 2 files: the program as a “.py” file. A copy of its execution as a notepad or word file

Write and execute a Python program for the following problem where a few simple statistics for a soccer league week will be computed.

Each team plays one match. Each match has a winner and a loser. In a match, one team is the home team, and one team is the visiting team. At least one goal is scored in any match.

Data will be read in the following order, one match after the other:

Name of home team

Score of the home team

Name of the visiting team

Score of the visiting team

…………

Enter “done” when there is no more matches.

Calculate and display the following results.

Number of games

Number of wins by the home teams, number of wins by the visiting teams.

Total number of goals and average scored by the home teams, by the visiting teams

Total number of goals and average conceded by the home teams, by the visiting teams

Total and average goal differential for the home teams

Total and average goal differential for the winning teams

Team with the largest number of goals scored, team with the largest goal differential (if several teams have the same value, pick any one). Indicate if home team or visiting team.

Execute the program on the following data (each data must be on separate line, not like here). Do not use advance features such as lists, tuples, arrays. Data must be inputted by execution of the program, they must not be “hard-coded” in the program)

AA 4 Bb 0

Cix 2 Doe 6

Elo 1 PSG 7

OM 3 As 0

MU 10 Mc 3

Rm 1 Bar 8

Losc 5 Br 14

done

PLEASE USE SCRIPT COMMAND TO RECORD ALL STEPS. PLEASE SEND SCREEN SHOTS OF ALL SCRIPTED COMMANDS.

1.Download the file “make_samples” attached

2. Run the script command on your Unix/Linux command line terminal to start capturing, name the typescript file as ‘Makefiles_codeproject.typescript’.

3. Follow the tutorial, run the commands as shown in the tutorial to capture the transactions

4. Download “Programming assignment 1” file.

5. On a command line terminal run the script command to start capturing into a file name PA_makefile.typescrip

6. Display the content of the makefile for PA1.

7. Compile your programs for PA1to make the executable using make command

8. Make some changes to the program (e.g. add comments, etc…)

9. Run make again

10. Add a module named version (e.g. version.c or version.cpp) that has a single function: displayVersion() that simply displays “Current version is 1.2” where 1.2 is the value of a static global variable named version declared in the main module when gets called. Change you main module to add the version variable and modify the main function to call displayVerison() at the beginning.

11. Rebuild your executable for PA1using make, Run the program to confirm that version is displayed.

12. Register with github to create your own free account. Create repositories for your programming assignment 1

13. On a command line terminal run the script command to start capturing into a file name PA_GitHub.typescript

14. Create repositories for your programming assignment 1(PA1)

15. Show status of your local repository

16. Push your repositoryfor PA1 to your GitHub repositories

17. Show status of your remote repositories

18. Make some changes to your PA1program, show status of your local repositories

19. Push the changes to your remote repositories

20. Show status of your remote repositories

Please Submit files containing your makefiles, and your typescript files.

undefinedPython CRASH COURSE, Project 1: Alien Invasion (Chapter 12: A Ship that Fires Bullets、Chapter 13: Aliens!、Chapter 14: Scoring）, Please read these three chapters to answer the following questions.

0.Software and Libraries required for this project implementation.

1. What Python files, classes, and functions were used in Project 1: Alien Invasion?

2.Write the purpose and roles of each of the Python files, classes, and functions used in Project 1: Alien Invasion. (This part is very important, please analyze in detail.)

3. Explaining the Logic of each classes/functions?

4.What import modules were used in Project 1: Alien Invasion?

5. What is the purpose, function, and role of each module used in Project 1: Alien Invasion?

6. High level activities or Major functional implementation of this project.