IT 117: Intermediate Scripting

IT 117: Intermediate Scripting
Quiz 6 Answers

Write the regular expression that is equivalent to * on the Unix command line.
```
.*
```
Write a regular expression that will match one or more whitespace characters.
```
\s+
```
Write a regular expression that can be used to find all lines in a file that contain "GET" somewhere in the line.
```
.*GET
```
Write a regular expression that will match one of the octets in an IPv4 address.
```
\d{1,3}
```
Write a regular expression that will match an IPv4 address.
```
\d{1,3}\.\d{1,3}\.\d{1,3}\.\d{1,3}
```
What is the name of the module that allows Python to work with a SQLite database?
```
sqlite3
```
What would you enter at the command line if you wanted a SQLite command line that let you work with the database contained in the file work.db?
```
sqlite3 work.db
```
If you were writing a Python script that needed to work with a SQLite database what is the first thing you would have to create?
```
a connection object to the database
```
Write the Python statement that would create the thing mentioned above on the SQLite file work.db.
```
con = sqlite3.connect("work.db")
```
Once you have the thing mentioned above, what is the next thing you have to create?
```
a cursor object
```