GitHub - jfreeze13/URpedia

Branches Tags

Name		Name	Last commit message	Last commit date
Latest commit History 102 Commits
www		www
MainScreen1.html		MainScreen1.html
Maketables.py		Maketables.py
Project 4 Charlie.ipynb		Project 4 Charlie.ipynb
ReadMe.txt		ReadMe.txt
admin.txt		admin.txt
article.txt		article.txt
create.sql		create.sql
field.txt		field.txt
fileToDataFrame-Mark.ipynb		fileToDataFrame-Mark.ipynb
has_experience.txt		has_experience.txt
load.sql		load.sql
milestone3.tar		milestone3.tar
pro4_Jiang.ipynb		pro4_Jiang.ipynb
proj3.tar		proj3.tar
proj4task2.ipynb		proj4task2.ipynb
show_admin.php		show_admin.php
show_article.php		show_article.php
show_field.php		show_field.php
show_has_experience.php		show_has_experience.php
show_relations.html		show_relations.html
show_user.php		show_user.php
spark problems charlie.rtf		spark problems charlie.rtf
user.txt		user.txt
wordlist.txt		wordlist.txt

Repository files navigation

Project 1 Part 3 ReadMe.

We created a python script to generate random user, article and field data to populate our URpedia database. The script generated 5 txt files with table data. We put these files into the Article, Field, Has_Experience, User, and Admin tables. Each table's structure is specified in the create.sql file. 

Article carries information for each article on the website. Field has information of possible topics like chemistry or math. Has_Experience holds info on user experience. User holds the information on the users. Admin holds information on the subset of users who are admins. 

The tables are almost identical to what we specified in project 1 parts 1 and 2. The only minor differences are changing the lengths of some varchar elements and changing a few identifications from varchars or chars into ints.