Built something? We create video reels & spotlights for GitHub projects.Promote your project →
Home / Developers / philip-ward-prepass
Developer Profile

philip-ward-prepass

Discovered public repositories for philip-ward-prepass in the GitHub catalog.

↗

philip-ward-prepass/ClassSearch

Searches through a list of classes and class data. Creates a user interface that allows a user to search for classes by type and where they are offered. It reads the classes at the start from an input file and then verifies that all information in the input file is valid. It reports if all info is in the valid format or not in the invalidInput.txt file. This was a school project from 2 years ago, as such it's slightly rough especially on the User Interface front since we were just learning how to build UI's, and the UI had to be fully built by hand coding. To run this it takes an argument of the input and output log files "input.txt invalidInput.txt"

↗

philip-ward-prepass/SQLServerLinqXML

For this I took a database defined in SQL Server and used LINQ inside of LinqPad to take all of the database data and transfer it into XML format. I then took the XML data that I had and created a DTD and XSD to define the entire database with all constraints. This was a school project. I did forget one of the constraints, being that supply quantities cannot be negative.

↗

philip-ward-prepass/SQLServerLinqToXML

For this I took a database defined in SQL Server and used LINQ inside of LinqPad to take all of the database data and transfer it into XML format. I then took the XML data that I had and created a DTD and XSD to define the entire database with all constraints. This was a school project. I did forget one of the constraints, being that supply quantities cannot be negative.

↗

philip-ward-prepass/OracleJdbcTpch

This is a java file that connects to an Oracle database. This database is based on a smaller version of the TPC-H benchmark database. I use JDBC to connect to the database then I query and print the table and view metadata. Finally I run some queries against the database and print the results. This shows my understanding of SQL, JDBC, Oracle, and databases. To run this you need Oracle installed. To run this run the run.sql file inside of oracle to automatically create all the tables, views, and insert all of the table data. Then simply compile and run both the .java files. It will ask you for your Oracle username and password when running. I also included a JDBCExampleResults.txt file if you just want to see what the results of the file print without going through the compile and run process.

↗

philip-ward-prepass/WebMonitor

Monitors n number of websites, each website for a user defined s number of seconds for availability. In the event of a website failure it will log the failure alert to a monitoring.log file. To run this file you must supply the arguments of the configuration file which is "monitoring.conf". I will supply the file I used. This config file is just a list of websites, and then the time in seconds that you want that website to be checked. This was a school project for me. Looking back I would have made a couple changes. First I would have nested the WebTimer class into the WebMonitor class instead of giving it it’s own discreet file. Secondly I would have used a HashMap instead of an Array for the keyArray in the WebMonitor class.

FOR MAINTAINERS

Built something? Put it in front of millions of developers.

We make a short reel about your project and post it across YouTube, Instagram, Threads, and X. Send a link, we do the rest.