文件列表:

.DS_Store (6148, 2019-01-14)
Assets (0, 2019-01-14)
Assets\placeholder.png (0, 2019-01-14)
Automated-SQL-Checker (0, 2019-01-14)
Gemfile (114, 2019-01-14)
Gemfile.lock (595, 2019-01-14)
app.rb (44, 2019-01-14)
config.ru (391, 2019-01-14)
controller (0, 2019-01-14)
controller\sql_controller.rb (3039, 2019-01-14)
main.css (799, 2019-01-14)
models (0, 2019-01-14)
models\answer.rb (1254, 2019-01-14)
models\answercheck.rb (1999, 2019-01-14)
models\login.rb (632, 2019-01-14)
models\post.rb (1421, 2019-01-14)
models\question.rb (1199, 2019-01-14)
models\test.rb (1615, 2019-01-14)
sparta_sql_app_seed.sql (12640, 2019-01-14)
views (0, 2019-01-14)
views\.DS_Store (6148, 2019-01-14)
views\pages (0, 2019-01-14)
views\pages\.DS_Store (6148, 2019-01-14)
views\pages\Index.erb (1508, 2019-01-14)
views\pages\admin_create_course.erb (3970, 2019-01-14)
views\pages\admin_create_student.erb (4211, 2019-01-14)
views\pages\admin_login.erb (1685, 2019-01-14)
views\pages\admin_search.erb (5280, 2019-01-14)
views\pages\admin_student_review.erb (2921, 2019-01-14)
views\pages\info_page.erb (2470, 2019-01-14)
views\pages\question_one_page.erb (3341, 2019-01-14)
views\pages\question_three_page.erb (3070, 2019-01-14)
views\pages\question_two_page.erb (5586, 2019-01-14)
views\pages\review_questions.erb (9217, 2019-01-14)
views\pages\score_page.erb (4537, 2019-01-14)
views\pages\student_login.erb (1761, 2019-01-14)

# Sparta-Project-2 / SQL-Automation-Checker-App ### Description For this project, we have created an automated SQL checker application which automatically compares the answers written by trainees during their SQL assessment against the expected answers stored in a created database. Once trainees have completed their assessments, test results are produced for the trainers in Sparta Global which avoids the chance of human error or ambiguities when marking the assessments manually. The automated application provides an efficient way for trainers to evaluate their streams as a collective as well as individual trainee performance. ### Technologies used * Ruby * JavaScript * HTML * CSS * Jira * GitHub * Microsoft Teams * VS Code * Google Chrome Dev Tools ## Frameworks * Sinatra * Bootstrap ### Prerequisites/Installation * Install a text editor such as Visual Studio Code * Install the latest version of Ruby ### Configuration 1. Copy/Clone the URL on GitHub into your own terminal 2. Unzip the file into a selected directory on own local device 3. Open the local folder in a selected text editor e.g. Visual Studio Code 4. Run "rackup" inside the terminal of the text editor 5. Open a selected web browser and type "localhost:[port-number]" shown in your terminal in the web browser URL e.g. localhost:9292 #### You can view the page [https://github.com/ianhawe/Automated-SQL-Checker/.](https://github.com/ianhawe/Automated-SQL-Checker/blob/master/) ### Challenges (you can include images and code block here) 1. Connecting with the TAR file 2. Normalisation of the database tables 3. Translating the SQL queries from the student selected SQL language (datatypes) 4. Calling from the API 5. Sessions and cookies 6. Time constraints ### Learning points 1. Better understanding of Ruby/Sinatra and how to apply gems in a full stack application 2. Understanding the importance of normalisation within database schemas ### To do 1. Make it look according to the wireframes 2. Hosted on Heroku 3. Refine query check 4. Cookies and sessions working correctly ### Created by: Eng-21

近期下载者：

相关文件：

评论：[我要评论] [举报此文件]

收藏者：