[rcmarcus@tiara ~]$ mkdir rmarcus_127b_pa1 # make a new directory for our work [rcmarcus@tiara ~]$ cd rmarcus_127b_pa1 [rcmarcus@tiara rmarcus_127b_pa1]$ wget cs.brandeis.edu/~rcmarcus/PA1.tar.xz --2019-02-09 13:24:14-- http://cs.brandeis.edu/~rcmarcus/PA1.tar.xz Resolving cs.brandeis.edu... 129.64.46.211 Connecting to cs.brandeis.edu|129.64.46.211|:80... connected. HTTP request sent, awaiting response... 301 Moved Permanently Location: http://www.cs.brandeis.edu//~rcmarcus/PA1.tar.xz [following] --2019-02-09 13:24:15-- http://www.cs.brandeis.edu//~rcmarcus/PA1.tar.xz Resolving www.cs.brandeis.edu... 129.64.46.211 Reusing existing connection to cs.brandeis.edu:80. HTTP request sent, awaiting response... 200 OK Length: 10758516 (10M) [application/x-xz] Saving to: `PA1.tar.xz' 100%[===================================================================>] 10,758,516 15.6M/s in 0.7s 2019-02-09 13:24:15 (15.6 MB/s) - `PA1.tar.xz' saved [10758516/10758516] [rcmarcus@tiara rmarcus_127b_pa1]$ tar xJvf PA1.tar.xz # extract the assignment dist/ dist/pa1.pdf dist/schema.sql dist/grade.py dist/pa1.db [rcmarcus@tiara rmarcus_127b_pa1]$ mv dist/* . # move things into our folder [rcmarcus@tiara rmarcus_127b_pa1]$ ls -lh total 50M -rw-r--r--. 1 rcmarcus grad 11M Feb 9 13:16 PA1.tar.xz drwxr-xr-x. 2 rcmarcus grad 4.0K Feb 9 13:21 dist -rwxr-xr-x. 1 rcmarcus grad 2.0K Dec 24 20:05 grade.py -rw-r--r--. 1 rcmarcus grad 39M Dec 24 19:43 pa1.db -rw-r--r--. 1 rcmarcus grad 136K Feb 2 01:20 pa1.pdf -rw-r--r--. 1 rcmarcus grad 893 Dec 24 19:53 schema.sql [rcmarcus@tiara rmarcus_127b_pa1]$ sqlite3 pa1.db SQLite version 3.6.20 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> .tables customer purchase store product purchase_product supplier sqlite>
Comments