Susanna Codes

A Problem-Solving To-Do List For Myself (Yet Once More) I have a lot of problem solving stuff to do. Here is my to-do list: Listen back to the problem solving call I had with my boss on 1/11/2024 for 45 minutes - I have been putting off this one for a month as it is so long I also have some follow-along code Re-listen back to my testing problem solving call with my boss from 8/11/2024 - I have already listened back to it once - but I just really need to listen one more time Listen back to my call on - oh gosh I'm getting lost now - 29/11/2024 I believe It's part 2 of a problem-solving activity we did together Latest point: Listen back to our impromptu 10 minutes or so of call from 2/12/2024 Only the first 10 minutes On how to debug smth Forthcoming step: We have agreed to do a call on how my boss would've solved a problem I struggled with yesterday We changed a path but I didn't realise it My boss has very, very kindly indeed offered to show me how he would've appro...

Everything I Cannot See I should be able to I should be able to: Run the debugger (which I can now do obviously) Identify what the problem is Look at where my code does something unexpected I don't care. I don't care how many times. As long as it takes. I will write this out as many times as I need to until I get it. I will write this out as many times as I need to before I get it. I should be able to: I should be able to: Run the debugger Identify what the problem is Look at where my code does something unexpected. I should be able to: Run the debugger  Identify what the problem is Look at where my code is doing something unexpected Look at where my code does something unexpected This is a part of problem solving. I will write it in my other post. It is about defining my path. Once I know what my path is. And once I stick to it: I will know. I expect output Y to be Z. If output Y is X then something is wrong and we clearly have a problem. I will stick to my guns. A photo from ...

Python on the Train because "I shall not be there; I shall rise and pass." (Database Operations) One of the nice things about having had 15 years of intense seizures is that nobody can say quite like me that when they fall, they pick themselves up again. Someone said it to me about 7 years ago, when they were at their worst (how was that already 7 years ago? How?). I thought they were so annoying. But like many people who were right at the time I have come to learn and recognise the value of their words later. So it's always worth listening to people who are older and wiser. They know a thing or two. I can pretty much say that I am a world expert at picking myself up now. An absolute, worldwide, world-class expert. This is really useful. It's good for picking yourself up in all kinds of situations. Quadruple rainbow it was 10x brighter Committing Changes and Closing the Database Connection I have learned how to create, insert, edit, and pull da...

All I have, I carry with me: Continuing Database Operations Just doing a few minutes here and there, because I need this to be done. I am so happy that my intermediate Python course is done. I am also so happy that the advanced modules are so easy. Where have you been all my life. Maybe something has finally clicked. These are so much easier than the intermediate ones! I can feel my love for the windfarms. It is stronger than ever. Everything is beating so much stronger in my heart. And all I have, I carry with me. All I have, I carry with me. Retrieving Data When combined with cursor.execute() ,  .fetchone() will fetch one row of data. It will pull the first row of the data table.  .fetchmany() will fetch many data rows - it will return the first set of specified rows.  It will return a list of tuples.  Finally, .fetchall() will fetch every row of data from the data table. I wrote a big piece of code about this. Here we are now: import...

Doing My Advanced Python Database Operations Module Because I Want All Courses To Be Over I would be happy to never look at another course again in my life after these last two modules. But I am loving them! They are awesome. I am learning how to execute SQL commands using a cursor object. I slept in the day so I am awake now anyway. I still have to finish making my current batch of Christmas cards. I have about 12 more to go. Then I will get some card and make a couple more when my new stickers arrive later this week. I LOVE making cards for people. I am practising using Python commands to inject data into tables Here is some code that I have written: from start import helper helper() import sqlite3 con = sqlite3.connect("titanic.db") curs = con.cursor() # Create table named new_table curs.execute("""CREATE TABLE new_table ( name TEXT, age INTEGER, username TEXT, pay_rate REAL )""") # Insert row of values into n...

Why You Should Always Read The Error Message First  Okay so, error messages are scary. Maybe not for a dev who's been at it for years but I started recently enough to remember the newness of it all. The bright red text with loads of numbers and characters that mean nothing. Well actually it's so easy. I just wish that it had been described better to me in the beginning. For example, take the word "Traceback". A traceback is literally the helpful text that gets returned when there is an error. But not knowing that my autistic brain just panicked and zoned it out and got thrown by it and ignored it and then struggled to read the rest of the message. EPIC ERROR and mistake No. #1. Mistake number 2 is thinking that the error message is scary. Or indeed that you have done something wrong - but as Codecademy told me back in the day. Error messages are a good thing. They are helpful. They are a sign that you are getting something done. If you were getting nothing done, then ...

What It Means To Me To Have Finished The Intermediate Python Course I can't believe it. I am done. I am finally done. Of course there will still be more to do; we have agreed that I will do two modules from the Advanced Python course as we feel that they are relevant to my work and will be helpful. But I cannot - I CANNOT - even tell you what it means to me to be finally done with this course. It's not that I don't enjoy it - I love it. But I don't like working under pressure and there was a need to get this done as fast as possible. I am very grateful to work for supporting me. Grateful to the director who agreed that the company would pay for the course, grateful to him and my manager for giving me the time to do it in works hours too, and also extremely grateful to my manager who gave me so much time and energy and patience and such a listening ear, on top of everything he already does, to help me to finish this course. I just hope that I can take what I have learned...