School of Computer Science and Software Engineering

CITS3403 Agile Web Development — Lab07

Unit Coordinator

Dr Tim French

Phone: 64882794

Lab Facilitator

Mr Tom Smoker, Mr Haolin Wu

 

Consultation Time

Where: CSSE rm 2.14
Time: Wednesday 12-2pm
No appointment needed.

 

News:

  • [14 Feb 2020] This unit currently has 190 CITS3403 students and 40 CITS5505 students enrolled. Almost twice as many as last year!
  • [14 Feb 2020] Labs, lectures and workshops all start in week 1.
  • [24 Feb 2020] Update: Labs will be starting in week 2.
  • [24 Feb 2020] Welcome to the first day of semester. The first class will be the lecture on Wednesday at 2.

Exercise 7: Linking in a Database

In this lab we will link a database into our flask application. We will install SQLite and then build some basic models, linked into views.

Project work

By now you should have formed a project group, and begun discussing your ideas for the project. Your project should be register using this application. If you haven't found a group partner yet, please see your lab demonstrator.

This week, you should have your project concept worked out and be thinking about the models and views you will need to implement. Develop some wireframe mocks of what you would like to the interface to look like, and see your lab demonstrator for feedback. Consider how it will be displayed on different sized devices, and how (and why) you would expect a user to interact with it. Also consider what routes you expect your application to serve. Make some mock web requests. You can use Apiary or Postman so you can use these requests for testing later on.

Getting started with SQLite

Install SQLite on your system. Follow the instructions here and then work through this tutorial. Make sure that you understand the basics of relational databases and SQL.

Link your database into Flask

Continue with chapter 4 and 5 of Miguel Grinberg's mega tutorial. This will link in databases, and provide some basic authentication for users.


This Page

Last Edited on:
Tuesday 16th of April 2019 04:08:22 PM

Website Feedback:
[email protected]