#100DaysOfCode - chraem

[Tine-Calumbiran]

Share your progress and tweet link:

• Day 1 tweet
  • https://twitter.com/chraem2/status/1421802287849115660?s=20
• Description
  • Started exploring a python library called pygame.
• Resources I used:
  • [Tools] Sublime Text + Terminal, and Piskel (used to create sprites)
  • [Library] pygame

[Tine-Calumbiran]

Day 2 tweet

• https://twitter.com/chraem2/status/1422220013654601729?s=20

Description

• Did some pop-ups for the inventory system that I'm currently working on.

Resources I used (that I remember):

• [Tools] Sublime Text + Terminal, and QT Designer
• [Library] PyQt5, and PySide2

[Tine-Calumbiran]

Day 3
https://twitter.com/chraem2/status/1422595010222977024?s=20

What I did today?

• Learned some pygame and SQL (MySQL and SQLite) practices.
• Code cleanup
• Added some functionalities on the Inventory System I'm working on.

Resources I used (that I remember)

• [Tools] Sublime Text + Terminal, QT Designer, and popSQL
• [Library] PyQt5, PySide2, sqlite3, pygame, webbrowser, and icecream

[Tine-Calumbiran]

Day 4

Tweet link: https://twitter.com/chraem2/status/1422939226652299271?s=20

What I did today:

• SQL programming
• GUI designing and programming

Resources

• [Tools] Sublime Text + Terminal, QT Designer, and DB Browser
• [Library] PyQt5, PySide2, and sqlite3

[Tine-Calumbiran]

Day 5

Took a break

[Tine-Calumbiran]

Day 6

Tweet link: https://twitter.com/chraem2/status/1423599837233127424?s=20

What I did today?

• Been busy revising the initial inventory system we're tasked to do. Definitely learned a lot from my co-intern.

Resources

• [Tools] Visual Studio Code + Live Share extension, QT Designer

[Tine-Calumbiran]

Day 7

Tweet Link: https://twitter.com/chraem2/status/1424052120823599106?s=20

What I did today?

• Revision of the system's gui I am working with.

Resources

• [Tools] Sublime Text + Terminal, and QT Designer + Pichon

[Tine-Calumbiran]

Day 8

Tweet Link: https://twitter.com/chraem2/status/1424370724643303429?s=20

What I did today?

• I enjoy my Sunday by doing some lightweight tasks.

Resources

• https://classroom.github.com/a/RcQ6oH6Q, Github, and Github Learning Lab

[Tine-Calumbiran]

Day 9

Tweet Link: https://twitter.com/chraem2/status/1424735181773053953?s=20

What I did today?

• Just some stuff related to tables (UI and DB tables)

Resources

• DB Browser, Sublime Text + Terminal, and QT Designer

[Tine-Calumbiran]

Day 10

Tweet Link: https://twitter.com/chraem2/status/1425428503655116811?s=20

Description

• Rest day <3

[Tine-Calumbiran]

Day 11

Tweet Link: https://twitter.com/chraem2/status/1425428503655116811?s=20

Description

• Rest day but version 2

[Tine-Calumbiran]

Day 12

Tweet Link: https://twitter.com/chraem2/status/1426154254058754053?s=20

Description

• Review some SQL commands from an e-book I saw.

Resources

• PopSQL, tutorialspoint.com's SQL Tutorial e-book.

[Tine-Calumbiran]

Day 13

Tweet Link: https://twitter.com/chraem2/status/1426156716043821058?s=20

Description

• Did some UI cleanup

Resources

• QT Designer

[Tine-Calumbiran]

Day 14

Tweet Link: https://twitter.com/chraem2/status/1426539380517203968?s=20

Description

• Did some front-end stuff with Python.

Resources

• QT Designer

[Tine-Calumbiran]

Day 15

Tweet Link: https://twitter.com/chraem2/status/1426938332571848704?s=20

Description

• Continuation of my 14th-day task.

Resources

• QT Designer, and Sublime + Command Line

[Tine-Calumbiran]

Day 16

Tweet Link: https://twitter.com/chraem2/status/1427322720933453861?s=20

Description

• Rest day

[Tine-Calumbiran]

Day 17

Tweet Link: https://twitter.com/chraem2/status/1427644255196090370?s=20

Description

• Tried openpyxl, a python library that helps users to deal with Excel files.

Resources

• [Tools] MS Excel, Sublime + Command Prompt
• [Library] openpyxl

[Tine-Calumbiran]

Day 18

Tweet Link: https://twitter.com/chraem2/status/1428008595363274755?s=20

Description

• Continuation of my openpyxl exploration.

Resources

• [Tools] MS Excel, Sublime + Command Prompt
• [Library] openpyxl

[Tine-Calumbiran]

Day 19

Tweet Link: https://twitter.com/chraem2/status/1428374658181570562?s=20

Description:

• Finished my first errand on openpyxl. Might apply my learning to the UI I just created.

Resources:

• [Tools] MS Excel, Sublime + Command Prompt
• [Library] openpyxl

[Tine-Calumbiran]

Day 20

Tweet Link: https://twitter.com/chraem2/status/1428756278591979523?s=20

Description:

• Tried implementing my learnings on openpyxl with a simple payroll stub maker program.
  • Did the ff:
    • Get inputs from line edits and table widget.
    • Put validators on line edits.
    • Creation of db tables and connection with db.

Resources

• [Tools] Qt Designer, Sublime + Command Prompt
• [Imports] PyQt5, sqlite3, sys

[Tine-Calumbiran]

Day 21

Tweet Link: https://twitter.com/chraem2/status/1429109654391386113?s=20

Description:

• Can't do much for today but was able to do the ff:
  • Automatically update the values for totals and gross pay each time that rate or "worked" line edits are changed
  • Explore QAbstractTableModel (here's my repo for this https://github.com/chraem/A_Run-Through_of_QT5_QTableView.git)

Resources

• [Tools] Qt Designer, Sublime + Command Prompt
• [Imports] PyQt5, sqlite3, sys

[Tine-Calumbiran]

Day 22

Tweet Link: https://twitter.com/chraem2/status/1429482628990705670?s=20

Description:

• Can't do much for today (again) but was able to do the ff:
  • Compute the total deductions each time an "item" in the table changed
  • Create the summary report-related stuff

Resources

• [Tools] Qt Designer, Sublime + Command Prompt
• [Imports] PyQt5, sqlite3

[Tine-Calumbiran]

Day 23

Tweet Link: https://twitter.com/chraem2/status/1429822090186690570?s=20

Description

• Able to:
  • Show/Hide the calculator frame
  • Open the File Explorer when the export button is clicked.
  • Create a blank excel file when the export button is clicked.

Resources

• [Tools] Qt Designer, Sublime + Command Prompt
• [Imports] PyQt5, sqlite3, openpyxl, os

[Tine-Calumbiran]

Day 24

Tweet Link: https://twitter.com/chraem2/status/1430189550232506370?s=20

Description

• Break timeee~ 💖

[Tine-Calumbiran]

Day 25

Tweet Link: https://twitter.com/chraem2/status/1430566793970536457?s=20

Description:

• Break timeee~ 👁👄👁 (I need to do something hehe)

[Tine-Calumbiran]

Day 26

Tweet Link: https://twitter.com/chraem2/status/1430933847244345346?s=20

Description

• Learned a lot today, from dependency management and packaging tool to libraries.
  • Someone introduced me to Poetry (https://python-poetry.org/docs/). Ngl, this is a good one (might use it with my future projects).

Resources

• Poetry, discord.py

[Tine-Calumbiran]

Day 27

Tweet Link: https://twitter.com/chraem2/status/1431259654600880130?s=20

Description:

• Had a hard time dealing with discord(.py) but am still glad that I can explore such a library. Also, learning always brings hardships; otherwise, it's just repetition.

[Tine-Calumbiran]

Day 28

Tweet Link: https://twitter.com/chraem2/status/1431638596067360770?s=20

Description:

• Done with bot feature that welcomes new members of a channel. Also, I added an "end" command that terminates the bot from running since it takes some time to stop it from running using the console.
  • Check the repo here: https://github.com/SurPathHub/Dayong

[Tine-Calumbiran]

Day 29

Tweet Link: https://twitter.com/chraem2/status/1432003232893583363?s=20

Description:

• Today, I reformat some code and read some documentation. (since it's SUNDAY Partying face). Ngl got a lot of warnings about "Line too long". Can't help it, I like compressing statements in Python Confused face.

[Tine-Calumbiran]

Day 30

Tweet Link: https://twitter.com/chraem2/status/1432355327677124609?s=20

Description:

• It took me almost a day to finish my GitHub README (https://github.com/chraem/chraem.git).

[Tine-Calumbiran]

Day 31

Tweet Link: https://twitter.com/chraem2/status/1432752421030170624?s=20

Description:

• Continued coding Mugna (https://github.com/chraem/Mugna.git). I hope I can create its installer within this week.

[Tine-Calumbiran]

Day 32

Tweet Link: https://twitter.com/chraem2/status/1433094476151459847?s=20

Description:

• Continued coding Mugna (https://github.com/chraem/Mugna.git).
  • Separated my export class from the main file.
  • Modified my excel file basis.
  • Added computation for the stub offsets
  • Updated the README

[Tine-Calumbiran]

Day 33

Tweet Link: https://twitter.com/chraem2/status/1433416254853763078?s=20

Description:

• Break timeee 💉

[Tine-Calumbiran]

Day 34

Tweet Link: https://twitter.com/chraem2/status/1434151221602840587?s=20

Description:

• Break time

[Tine-Calumbiran]

Day 35

Tweet Link; https://twitter.com/chraem2/status/1434179503840845829?s=20

Description:

• Continued Mugna (https://github.com/chraem/Mugna.git). Here's my current generated excel, and my expected output. Just a bit more and they'll be identical. I Will rest for now since there are still some side effects of co*** vax.

[Tine-Calumbiran]

Day 36

Tweet Link: https://twitter.com/chraem2/status/1434531224219881472?s=20

Description:

• Currently, Mugna works by allowing users to input data and saving those to db when ADD is clicked.
  Exportation of those data happens when EXPORT is clicked.

Still lacking but, hey, progress is progress.

[Tine-Calumbiran]

Day 37

Tweet Link: https://twitter.com/chraem2/status/1434883041357303813?s=20

Description:

• Unable to do too much for today since it's the 1st day of class. But I did some code cleaning on Mugna (https://github.com/chraem/Mugna).

[Tine-Calumbiran]

Day 38

Tweet Link: https://twitter.com/chraem2/status/1435269179435720707?s=20

Description:

• Just did a minimal change on https://github.com/chraem/Mugna, one of which is setting the text alignment on certain cells.

[Tine-Calumbiran]

Day 39

Tweet Link: https://twitter.com/chraem2/status/1435604461758541826?s=20

Description:

• Continuation of https://github.com/chraem/Mugna.
  • I locked my basis.xlsx and had to use another library (msoffcrypto-tool) to access it.
  • Enable user to delete records.
  • Fixed the row height for each stub.

[Tine-Calumbiran]

Day 40

Tweet Link: https://twitter.com/chraem2/status/1436365437193707527?s=20

Description:

• Continuation of https://github.com/chraem/Mugna.
  • Reconstruct my validators for users' inputs with the data type of float. (This fixed the ValueError when the users' first input is a period).

[Tine-Calumbiran]

Day 41

Tweet Link: https://twitter.com/chraem2/status/1436366342014128130?s=20

Description:

• Continuation of https://github.com/chraem/Mugna.
  • Quantized all float values to have consistency

[Tine-Calumbiran]

Day 42

Tweet Link: https://twitter.com/chraem2/status/1437071886802849800?s=20

Description:

• Continuation of https://github.com/chraem/Mugna.
  • Fixed bugs

[Tine-Calumbiran]

Day 43

Tweet Link: https://twitter.com/chraem2/status/1437071886802849800?s=20

Description:

• Done coding https://github.com/chraem/Mugna. Will add README soon.
  • Though, Mugna is a simple program I learned a lot and just glad that I tried doing this. I wonder what would I do next.. (maybe I'll restudy Java)