07-02-2022
Today's Foci
Focus 1
- Effectively deliver HTML/CSS workshop with group
- Ask for feedback?
Focus 2
- Begin using Databases
- implelment some in SQL
Code Review
Pair today had fantastic code - their TDD was thorough, and clear.
learned the
expect(something).to satisfy { LOGIC }
They also used their class instance to activate its own methods on initialisation - which I thought was a great way to simply call and run a complex process!
great way to use capybara to look for options
Fantastic! a few adjustments perhaps, but great work overall!
I need to look into using RDoc, whilst trying to use TDD more - I was weaker in the last task
Topic
Databases
- Diagram flow of information
- Explain Database basics
- what tables are
- what is SQL used for
- entity relationship diagrams
- 1 - 1
- 1 - many
- many - many
- debugging process for databases in the backend
- build a webapp that uses a database
Think about structuring the data, and look out for replication
Rules for databases
HTML workshop
Today our morning group ran an html/css wokrshop - it was a little short, but I think we managed to get some information across. We all gave significant input, and it was something of a success. Could do with refining in the future, if done again.
I wish I'd had, or made more time over the weekend to plan the HTML workshop; but I was knackered. Somehow, I'm still knackered now, actually.
Databases
From SQLZoo
SELECT population FROM world
WHERE name = 'France'
which means
SELECT column FROM table
WHERE row-in-column = 'France'
Multiple Rows for condition
SELECT name, population FROM world
WHERE name IN ('Sweden', 'Norway', 'Denmark');
Pairing
Pairing was great today! Again, steady, but deep progress. Looking at planning, some of the interactions between Ruby, Sinatra, and Capybara.
Useful Tactics
Produce a line break && line in HTML
<hr>
make multiple nested directories in unix (-p stands for parent)
mkdir -p some/number/of/child/directories