Shifting to SQlite

So today I have worked on the database creation for the 'Admin' and 'Users' tables - both within the database. It is a simple program only designed for creating the database in the first place, later-on I will be working on the adding and removal of users.

This first image shows the program accessing the database and creating the new table within the database as the program calls it. (shown below)

The second image calls the create_table function , adding a new table to the database and then proceeding to add all the relevant data columns, such as email address, username and user ID.

The user ID is a new addition from the previous excel method - which may be useful in streamlining search methods for calling data from the db later in the program.

*Edit*

This is what the table structure looks like in the database itself. (viewed using the SQlite Inspector program, as recommended by Python Schools)

Another Update

I forgot to mention this in the last post, but I've decided to make a change to my "database" system. It has up to been now done in MS Excel, which is a spreadsheet. While it is allowed within the marking bounds of my project, I have been advised to change it in for a proper database software/ system such as SQL or Access.

Once I have a SQL viewer/ reader installed I will be re-working parts of my program to use a SQlite database rather than a spreadsheet.

CSS Colour Picker - in Tkinter

So today I started working on the 'drop-down' menu system which will allow users to choose a 'primary' and 'secondary' colour for their websites colour scheme which the program will export into a CSS file.

I wanted to try and work in a little bit of the Tkinter module on this one so I don't have to re-work the entire program at a later date once it's complete and I want to add a neat U.I

 This last image shows me testing to see if Tkinter is compatible with all the HTML Hex Colour codes I saved (shown in the last post) and it is, which is good news. :D

Working on Stylesheet Creation

So after coming back from a week's residential I can now get back to work on the project. This week I am hoping to complete the CSS file creation part of the software.

As part of this I am creating txt files which contain a html compatible colour, the hex value for that colour (which will be used to display the colour in the option menu) as well as a list of alternatives in the case that a browser doesn't support the colour.

E.g.
navy, darkblue, blue

I have currently written up files for Reds, Blues and am currently working on a grey-scale list (I have to constantly remind myself to use the American-English spellings of everything :^ )

I am using this w3schools page to get all the correct names and hex values:

http://www.w3schools.com/colors/colors_names.asp

Once I have completed all of the files I will upload them to either my Onedrive or Google Drive and link them.