taylor4484 / cs327e-wcdb Goto Github PK
View Code? Open in Web Editor NEWcs327e-wcdb
Home Page: http://www.cs.utexas.edu/users/downing/cs327e/drupal/wcdb1
cs327e-wcdb
Home Page: http://www.cs.utexas.edu/users/downing/cs327e/drupal/wcdb1
Online Collaboration for XSD:
http://collabedit.com/35vqe
#15
World Health Organization, NATO
Human Trafficking, Holocaust
Nelson Mandela, Adolf Hitler
Dictionary unpacking issue.
https://piazza.com/class#spring2013/cs327e/174
Here are my thoughts about tables. You can't just have 3 tables. You have to have extra tables to deal with the multiplicity of certain data values (locations, crisis/people/org types, etc)
Downing suggests using joining tables, which is essentially the same thing.
Review and correct Unit Tests
Is it too early to be annoyed by other group's data/IDs?
Cause I am.
It is not okay for them to only include pictures and a person's name and call that "research"
Reach a consensus on their results. The results will not match perfectly between groups, because the merging import design will differ somewhat between groups.
Create a log of the commits. Push frequently.
WCDB1.log
(already in makefile, just need to run "make log")
The import facility must import into the MySQL DB. The export facility must export from the MySQL DB.
The import facility must be modified to handle the merging of data. This is where it's crucial to have arrived at a consensus on the IDs of the crises, people, and organizations. There is no right or wrong way to do this. Come up with the best design that you can and be sure to documnent it. Import/export the data of all of the other groups.
Create a critique of your final project by answering the following questions:
What did we do well?
What did we learn?
What can we do better?
What puzzles us?
Give a 20 min presentation in class.
Everyone must participate.
Each member must get equal time.
Walk through the Prezi presentation and include the critique above.
Could we put all of our ID's into one Issue for quick reference? It's time consuming to look up every event that is associated with my data and enter it into my XML
Here are mine:
American Red Cross AR1881
Mexican Government MG1810
Mexican Drug War MD2006
Vietnam War VW1975
File: hjh558Run.in.xml
Invalid XML
Do not include "" around content in elements
VALID: <element attribute="value">Data</element>
INVALID: <element attribute="value> "Data" </element>
American Red Cross
Mexican Government
Vietnam War
Mexican Drug War
Please review your contact information below:
REDACTED
Comment corrections or "OK"
I'll be creating an email distro list such that we can email 1 address and it go to everyone
File: PeopleXML
Invalid XML
Do not include "" around content in elements
VALID: <element attribute="value">Data</element>
INVALID: <element attribute="value> "Data" </element>
Worth 5pts.
Set up a private Git repository at GitHub, named cs327e-wcb.
Invite the grader to your repository. Commit at least 5 times. Commit once for each bug or feature.
We have a room with a monitor booked 330-530 next Thursday (4/25)
room: PCL 4.106
Chosen schema :
https://piazza.com/class#spring2013/cs327e/150
Save it to your computer, do your new instances, validate it, and then push to the team repo (same as last time).
Change ONLY YOUR assigned items (in this file, keeping the structure it already has) and then push the updated file back into the repo.
Validation command on the command line, validate this temporary file using xmllint:
xmllint --noout -schema NewSchema.xsd tempInstance.xml
Once your instances are valid, copy and paste them into the taylor-WCDB1.xml file, make sure you overwrite the old instances - your only!
Commit your changes to the taylor-WCDB.xml file and push to the repo.
Worth 15 pts.
XML Schema/Instance
Create a MySQL schema.
Push and pull the schema and instance to and from the grader's repository.
.Prepend - to the file names at GitHub (i.e. foo-WCDB2.xml and foo-WCDB2.xsd.xml).
File names:
WCDB2.xml
WCDB2.xsd.xml
Please fill out this doodle scheduler:
http://doodle.com/5tg58s9d2tfkkks2
Fill out the form agnostic of date (ignore specific dates, and fill out your general weekly schedule)
OPTIONS ARE:
Yes = You are free
(Yes) = If Need Be, not optimal, but could meet
(No) = Not free (class or other obligation)
@geosmon
@Davoletows
@Malloryfarr
@hjh558
@ajl2265
@Taylor4484
@danielehrlich
COMMENT "DONE" when you have filled it out!
Need to script insert statement from xml as strings. Need to parse and index the xml.
After submission, fill out your own GoogleForm about how well you think individual group members did.
https://docs.google.com/forms/d/1uexcFLysJ6LGe8SImxE8jc_SW4B_6frlPmTwlRJHSK8/viewform?pli=1
Worth 15pts.
Write at least 3 unit tests for each function. Tests corner cases and failure cases. Name tests logically. Push and pull the unit tests to and from the grader's repository.
Reach consensus on the unit tests.
foo-TestWCDB1.py
foo-TestWCDB1.py.out
Everyone choose two of each.
My suggestion is to choose your 2 crisis, with a person and an organization from each. It will make creating a relational database easier.
Take a look at this Piazza page and try to stay away from duplicates of other's teams: https://piazza.com/class#spring2013/cs327e/119
Comment them here and I'll add them to our Piazza note.
@geosmon
@Davoletows
@hjh558
@ajl2265
@Malloryfarr
@danielehrlich
Worth 20pts.
Use assert to check pre-conditions, post-conditions, argument validity, return-value validity, and invariants.
Worry about this last, but program should run as fast as possible and use as little memory as possible.
ORGS:
Africare
Human Trafficking Awareness Partnerships
CRISIS:
Syrian Crisis
AIDS in Africa,
Worth 15pts.
Create at least 10 acceptance tests. Tests corner cases and failure cases. Push and pull the acceptance tests to and from the grader's repository.
RunWCDB1.py
RunWCDB1.in.xml
RunWCDB1.out.xml
email: [email protected]
password: cs327e
FILE:CrisesXML
Kind doesn't have ikeyident attributes anymore
<Kind keyIdent = "PC"> "Political Confrontation" </Kind>
Remove "" and extra spaces from xml
Should look like this:
<First>Hurricane Katrina</First>
Check to make sure you have all required elements, I think you are missing things.
Link to google doc:
https://docs.google.com/spreadsheet/ccc?key=0AnWPQPchhOIAdHp2MVd3aWFqdEh2VHRzX1ZneEpyUXc&usp=sharing
Post if you think of any
sys.stdin is being used to give the XML file name, so when ask() prompts for the keyboard it reads the first line of the file given instead.
Currently this produces an error, one possible fix: hard coding in the ask() values :'(
I'm taking the lead from some posts on Piazza,
I'm re-writing the entire schema. I finally understand how this works and will share an instance and the XSD shortly. From what I have seen thus far groups have certain parts right here and there, I am summing up the best parts from each into a "superschema"
@geosmon @Davoletows @hjh558 @ajl2265 @danielehrlich @Malloryfarr
You will have to adapt your instances, but I'll provide a template instance.
Alright, so it's come to my attention that we probably won't finish this phase in time at the rate we're going currently.
Still left to do:
Also, we still need a comprehensive list of every group's xml instances. I haven't managed to track them down and don't think I should be spending time searching for those when the merge function takes priority for me, so someone else needs to find them and commit them to the repo.
WE ARE NOT DONE WITH THIS PROJECT.
If you haven't done anything for this part, or feel that you can still contribute more, then get started on something above. Making our project deadline is a serious concern right now and everyone needs to contribute.
Don't pick something and say you'll do it like people have been. Start something and publish to the repo to let everyone know you're contributing by actually doing so. We need results at this point, not intentions.
-Holly
Cuban Missile Crisis, Hurricane Katrina, World Bank Group, Doctors without Borders
Worth zero points, but mandatory.
Create zip file and submit to Turnin.
FILE: AlexXML.xml
If there are unused elements, you must delete them or put them in a comment. You can't leave them blank, it won't validate properly.
Fidel Castro, Sergei Lavrov,
Bono, Barack Obama
I can't log into the MySQL server for some reason, so if someone can log in and make some unit tests for our query function it would be appreciated. Need one that is valid, one that isn't, and one other.
Worth 5pts.
Use pydoc to document the interfaces.
Documentation only needs to be generated for WCDB1.py
Comment each function meaningfully.
Worth 15 pts.
Create an XML schema and instance and validate it.
Push and pull the schema and instance to and from the grader's repository.
WCDB1.xml
WCDB1.xsd.xml
Mike Huckabee
JFK
George W. Bush
Bill Gates
Worth 5pts
Create an issue for each of the requirements in this table. Create an issue for each bug or feature, both open and close
Create at least 10 more issues in addition to the requirements.
Worth 5 pts.
Design a UML diagram of the MySQL DB design.
Use any UML editor that you like.
The diagram must only show the associations and multiplicity between the classes.
File:
WCDB2.pdf
Need to get file name from the writer and then feed it into a string-query directed at the MySQL database.
FILE wdb539Run.in.xml
Example of correct. Use attributes for IDs instead of the element.
```<Crises>
<!-- Repeate Crisis up to 10 times -->
<Crisis cID="CID" />
</Crises>
<People>
<!-- Repeate Person up to 10 times -->
<Person pID="PID" />
</People>```
(From Mallory)
In class today we discussed meeting to discuss/plan for the project either Sunday or sometime next week. Taylor and Wilson, what are y'all's thoughts on this?
Also we will have to present the project to the class either the Friday after its due or the following Monday or Wednesday. We decided going Friday seemed like the best idea, does that work for y'all?
Also if we decide Sunday works for everyone what time, 4ish? I'm free after 1 so if anyone has issues concerning the time let me know!
Happy Friday!
Mallory
A declarative, efficient, and flexible JavaScript library for building user interfaces.
๐ Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. ๐๐๐
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google โค๏ธ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.