Build Real Software with Python, PyQt5 and QT Designer | Abdelmoula Khdoudi | Skillshare

Build Real Software with Python, PyQt5 and QT Designer

Abdelmoula Khdoudi, Engineer & Phd

Build Real Software with Python, PyQt5 and QT Designer

Abdelmoula Khdoudi, Engineer & Phd

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
17 Lessons (1h 57m)
    • 1. 00/ About This Course

      3:00
    • 2. 01/ Python - PyQt5: Introduction and Project Description

      3:42
    • 3. 02/ Python - PyQt5: Preview of the Final Result (GUI software ad Database)

      3:18
    • 4. 03/ Python - PyQt5: Download and Install the Working Tools (Python 3.6 | PyQt5 | Sqlite )

      3:38
    • 5. 04/ Python - PyQt5: Create the Sqlite Database and fill it with Data

      5:28
    • 6. 05/ Python - PyQt5: Design of the GUI in QT Designer - Part1

      11:11
    • 7. 06/ Python - PyQt5: Design of the GUI in QT Designer - Part2

      18:05
    • 8. 07/ Python - PyQt5: Create PyQt GUI loading and displaying Class

      10:04
    • 9. 08/ Python - PyQt5: Load Data from Database and display in GUI Table

      5:25
    • 10. 09/ Python - PyQt5: Create Search Filter for Parts Inventory Count

      4:12
    • 11. 10/ Python - PyQt5: Display Parts Inventory Statistics in QLabels

      10:17
    • 12. 11/ Python - PyQt5: Display Top 3 Parts in QTable and Navigation Rows in GUI

      11:10
    • 13. 12/ Python - PyQt5: Update the Database Table from the GUI button

      4:18
    • 14. 13/ Python - PyQt5: Delete a Row from our Database Table using GUI commands

      3:32
    • 15. 14/ Python - PyQt5: Add new Rows and Data to our Database from the GUI

      4:18
    • 16. 15/ Python - PyQt5: Add CSS Style to the GUI form in QT Designer

      6:47
    • 17. 16/ Python - PyQt5: Compile the Software as (.exe) file using PyInstaller and AUTO-PY-TO-EXE

      8:15
  • --
  • Beginner level
  • Intermediate level
  • Advanced level
  • All levels
  • Beg/Int level
  • Int/Adv level

Community Generated

The level is determined by a majority opinion of students who have reviewed this class. The teacher's recommendation is shown until at least 5 student responses are collected.

177

Students

--

Projects

About This Class

Are you thinking to master PyQt5 for Graphical User Interface Development ? Do you write some codes in Python and you wonder how you can convert everything to a nice interactive user interface that can be used by huge number of people ?

I can grantee to you that you are taking the best decision  in today World. After doing this course, you will meet your goal.

7a55ab5b

I designed this course in a way to cover all the mandatory aspects of Python-PyQt development, starting from Downloading the working tools until the final deployment of our software to other users. The learning method i chooses is particular because we will work on a real case study "nothing better than doing real things" =>  we will create a software to respond to a customer demand (a Spare Parts Management Software for Manufacturing Company)

Meet Your Teacher

Teacher Profile Image

Abdelmoula Khdoudi

Engineer & Phd

Teacher

Hello, I'm Abdelmoula.

Industrial Engineer with 7 years experience in different companies and fields.

Phd degree in Artificial Intelligence and Data Science

Lead of Smart Manufacturing in actual working company

Co-founder of an AI startup that deliver industrial based AI solution for performance improvement

Solid knowledge in: Industrial Technical fields, Business Management and Strategy, computer Science and Electronics, Artificial Intelligence and Advanced Analytics.

See full profile

Class Ratings

Expectations Met?
  • Exceeded!
    0%
  • Yes
    0%
  • Somewhat
    0%
  • Not really
    0%
Reviews Archive

In October 2018, we updated our review system to improve the way we collect feedback. Below are the reviews written before that update.

Your creative journey starts here.

  • Unlimited access to every class
  • Supportive online creative community
  • Learn offline with Skillshare’s app

Why Join Skillshare?

Take award-winning Skillshare Original Classes

Each class has short lessons, hands-on projects

Your membership supports Skillshare teachers

Learn From Anywhere

Take classes on the go with the Skillshare app. Stream or download to watch on the plane, the subway, or wherever you learn best.

phone

Transcripts

1. 00/ About This Course: are you thinking to master Pai que t five for graphical user interface development view rights of interesting code or algorithms in python And you wonder how you can convert everything to a nice interactive user interface, something that can be distributed and used by a large number of people. Perfect. You are taking the best decision in today's world. Python is the future of computer programming. And if you can present your program in a nice graphical interface that you hold one of the top wanted skills in the market after taking this course, you will simply meet this goal. We designed this course in a way to cover all the mandatory aspects of python and hike UT development, starting from downloading the working tools until the final deployment of our software to other users. The learning method we choose is particular because we will work on a real case study. Nothing better than doing real things. We will create a software to respond to a customer, demand a spare parts management software for manufacturing company. The first thing we're gonna do is, of course, to show you how to prepare and install the working tools. By that, we Mean Anaconda, I q t five Q T designer and sq Light three. After that, we will learn how to design a professional graphical user interface using the amazing Q T designer and also some great methods for style. Improvement Way will create, configure and fill out our database from scratch. Then we will jump the programming of our software under Python three. During the programming, we will learn to aspects. The 1st 1 is the interaction with the Pike UT interface, and the second aspect is how to interact with the database. That means you will learn two very important things in the same course. One important point that you will learn also is how to include some Resource is in your interface. For example, to put a picture of your interface requires some tricks that you will learn in one of the course videos. The last part of the course is very important because if we invest all the effort in developing our software and we cannot send it to our customer, then we will never get paid. So we will teach you how to compile and deploy the full project in order to be executed outside your computer. This course will be compact and straightforward. By this we mean no time lost on general discussion and theories because we believe that you don't have infinity of free time to stay watching tens of hours of videos. Don't worry, we took this aspect into consideration. In the next videos, you will be guided by your instructor, Abdel Eula, who is a brilliant python and Advanced analytics researcher. He is also an industrial engineer and taking a PhD in artificial intelligence and machine learning. If you feel that your investment in this course was not a good idea, no problem, a full refund is guaranteed. No more excuse enroll now and start learning. 2. 01/ Python - PyQt5: Introduction and Project Description: Hello and welcome to this course. In this course, I will teach you how to build a real life software from scratch using fightin and pay. 35. We will achieve this by working on a real customer request for graphical software development. We have a demand from our customers to build a system for machinery. Spare parts invented the manager our customer is called saying Sikhs, and he require from us to develop inefficient and elegance software for him to follow and manage easy his machinery Spare parts. You have a warehouse that contains all the mechanical parts with their reference names and specifications. And he wished to be able to track all changed in consumptions show statistics and also highlight any issue related to critical inventory level. It proposed as a budget off 608,000 euro, and we think that it's over for us. So we're doing the job of the project should be done by us, including design off a database and feeling the data develop of program using fightin and, of course, the most important part for you, which is how to create and direct with a bike beauty. Five. A graphical user interface Don't worry. We will do our listing step by step and you will understand everything. I recommend you to follow the course till the end. I have also some important things to teach you in the last videos of the course. If you do all this and you feel that something not clear don't worry, just let me a message and I would be happy to help you. If you are interested in developing graphical user interface for other type of projects. Are other than that Abby's management. Be happy because I will be releasing some other new courses to cover other Piketty five projects. Type. For example, in some chemicals. I will teach my students how to develop data science and artificial intelligence software using like 35 fight on for this. Just stay tuned. At the end of this course, you will be able to develop with confidence of very similar products. So what you see actually in the screen are Sorkin Tools, who will use Anaconda and Spider T as idea editor for fightin. The graphical user interface will be created using Piketty five scripting and beauty designer for the design. We will deal also with skill that obeys. And for that I will show you are very easy and robust choice for database design and, of course, main programming language. We will also be able to create different style for our software user interface. It will make our customer more happy because he will feel good to have a choice either to use this dark style or a white style. As we can see in this light, the first thing we're gonna do is off course to show you how to prepare a stall door controlled. Still, by this I mean on a conduct by 35 beauty designer and SQL like three. After that, we will learn how to design a professional user interface using the amazing QC designer and absolute some great metal for side improvements. We would create, configure and feel our database from scratch. Then we will jump to the programming off our software using fighting dude into programming . We will learn to aspect the 1st 1 is the interaction with Piketty interface and second aspect is how to interact with the database. That's mean they will earn two very important things in the same course. One important point that you will learn also is out to include some resources in your interface. For example, to put a picture on your interface, acquire some tricks that I will show you in some of the course videos. The last part of the course is very important because if we do all these efforts in developing our software, we cannot send it to our customer. Then we will never get paid. So every teach you how to compile and deploy the full products in order to be executed outside our computer. Thank you for joining this course. See you in the next video. 3. 02/ Python - PyQt5: Preview of the Final Result (GUI software ad Database): our final software will have in the centre face and we love to re page 1st 1 is inventory details. The 2nd 1 is inventory statistics, and the 3rd 1 is idiot Inventory invented. The sales will have a table with different cologne names and refreshing bottom that if we click, it will display all the data from the batteries. And we can see different colors with reference parts names. There's some properties of the parts and also on the amount off parts in the warehouse. So, for example, if you want to see how many parts we have in the warehouse that have a number, for example, lowered entry, we will just type three and make search the same example. If you want to see parts that have lower quantity than five, just type five and click search. If you want to go back and see if they think we have to click on the fish in the second tub , we would have some 36 the 1st 1 We will see how many unique reverence we have in our warehouse. Also, we see how many parts family we have our type. Also, we see which reference have the minimum number of holes and which evidence have the maximum number of holes and harmony. Also, we will have small tables here to show the top three reference with lower inventively level . To do this, we will be doing only a click on this button. Who will say that this difference have only two or three quantity in the warehouse? And for sure, we have to pass orders turned out to be out of stock, and it is invented it up. We will have some functionality to navigate its euro separately and of course, toe operate it or to delete it or to other neuro such update. We will just write in the new value and click on update, and this will write the new values in the movies. If you want to delete, we will just click on delete. It will delete the complete row with all the data. If you want to other neuro, we just need toe, cancel everything and write a new values and click on add new insecurity designer parts. We will see how to draw these screens. How to put this Commons this bottoms Exeter. We will be using these comments in the left side. We say that we have a lot off comments like textbooks, label books, bottoms, slider bar Exeter. Each one can be just drugged and put on the screen in the right side. We will have property manager that you can sit some properties for each commons. These Commons are called widget and you will see how to set probabilities for each type off we get. For example, the table widgets have some properties that we have to define during the design. So don't worry. You will see out of this step by step. In the database side, you will see how to use that. A vase, a browser for rescue light. How to create any of that? Always, how to eat it. The type off Collins type of data, ex cetera. You will see how to feel this later. In our case, we will use only one table called part stable. Thank you for watching See you in the next video. 4. 03/ Python - PyQt5: Download and Install the Working Tools (Python 3.6 | PyQt5 | Sqlite ): In this video, I will show you how to download and install door controls. The 1st 1 is Anaconda Tree. This will help us to a style automatically fight on 3.6. So for this project, we will need bite on 3.6 point three and it will be installed automatically using on a contra version 2018 12. We will go to this website. This is archive for Anaconda insulation and it was such for this vision. After this, we will don't load it and I started. One important thing is that during the installation we will try to remember the installation holder because we needed to install also Piketty five in the same folder for like 35. We would go to source forced dot nets and who will search for this reverence? We will not download the latest reverence to avoid any issues related toe vision off. Good, because sometimes some students use different versions of the software and they have some troubles for the good. So please be sure to download and install same visions as I show in this presentation. And finally you will download and install that a visible Hauser for a scary light. To download Anaconda Tree version 2018 12. Go to these websites, so it's a report dot anaconda dot com slash archive. Do control if to make such and deep this vision Anaconda Tree 2018 12. When those x 86 that's easy and quick search. It will show you the variant just to download this software. The installation process is very simple, and just one note is that you have to remember the installation folder for Anaconda Tree because we use the same installation for their for Piketty five. So just parted to compete and put it in notes. But to download bike 35 go to Google and type Bike 35. Now load and click search in the search results and go toe search for this one. Click on it. It will lead you to this pitch the load diversion related to your operating system. For my case, it's a 64 operating system. After the download is complete, just run the set up motor as normal, and during the selection off, the installation folder puts the same folder us on a conduct. Very. This is very important for our database management. We will use sq light brother. For this, go to rescue lights browser dot or GTA and after this photo, download or click on download, go and download the standard and stutter for your operating system. Form a case. It's 64 operating system. After you don't know it, just double click and click on next until you finish the installation. So for making its already installed and to be sure that the installation off vacuity five was done successfully. So go to start menu types by the So open it it will open this window. This is the idea for bite on programming and type in port bike 85 and then on this line off court. So on the bottom, if it does not show any error, that's mean it Waas and style it successfully conversation by this are the tool was installed and now we are ready to start our product. Thank you for watching. See you in the next video 5. 04/ Python - PyQt5: Create the Sqlite Database and fill it with Data: Hello. In this video we'll see how to create a database is and how to create a table inside this database and fill it with our data. So is the Excel files. Continue our data. So I will give you this The data. Then you can practice yourself so it will be attached intercourse To do this, just kowtow that obeys browser or sq lights and click open after you get the screen. Goto knew that obeys It will ask you toe save the batteries for our case. We will just delete this so our that the baby will call it parts just like this and click on save. So after you kick and save it would create a new database with extension parts, not db it creates. We will have this screen so it will require us toe define and name for our table. So our table will be called butts Taper. Okay. And here on the bottom, we will just click on add field. So these are the columns off our table. So for our case, we have nine Collins. So just we click on add nine times. So 123456789 okay. And now we will define the names and the type off variables. 1st 1 will be I d. Okay, it's you'll be integer. So here we have a different type of data. It's only is interested, and we will just click on this one because this is ah, primary key. So we selected us Primerica, and you will select this on US auto agreements. That's mean. If we increase the number off feels if we are a neuro, it will automatically agreement to the number off Heidi. The 2nd 1 is a reference. So this is the reverence off our mechanical parts. So this will be text. And for this we just keep it like this. The 3rd 1 is pardoning, and it's also a fixed volume. The next one is minimal area. So I mean a video. It's a medical column. So we can just, uh, make the size bigger. After this, we need maximum area. It's Ansonia Medical number of whole. Sorry. So remember holes with us and it put it also, as an American, I've said this we have minimum diameter we set. It also has many American, um, marks, volume, meter cmune, um, and finally count. So this is the column that will hold the number off parts in hours in our warehouse can sit it us integral or as numerical. No issue. So it's finished. This is the design off our table is the arch detector. We just click on. OK, so after you kicked on Okay, we can see here what we did and to access this table and feel the data. Since we are dealing only with few days, I will do it manually. So to do it manually, we just goto is so second tub. So in my case, it's in French for you. It can be in just the second up. So this is for database structure and this is for the data. So as you can see here, we haven't columns that we just created, and we would just started in the data for the I d. No need to write the idea because it would be auto implemented. We will just open again the X if I so we'll just make this smaller on like this. Okay. And then we opened the X on fire. I would put it down. So before to start, just insert. Some arose And then it will start feeling out there. So after putting all our data, it would look something like this. This is our table called bar stable. Just one thing don't forget to click on Save cannot lose your modification. So by this we finished creation off our database and feeling our later. And now our social data is ready for the project's Thank you for watching See you in the next video. 6. 05/ Python - PyQt5: Design of the GUI in QT Designer - Part1: Hello. We will organize on or or you know, a specific folder. So we create a fallen on the desktop. I would call it my first 35 you would put all files in this folder. So we started by putting out of Is that we just created in the previous video. It's Can't parts That's Levy. And now we will open Q t designer and start building our first graphical user interface. To do this, we will need to go to the installation folder off Piketty. If you remember during the installation, in my case, it's located somewhere in Lisk E and we go toe on a quantity so absolutely in anaconda Tree . So a quick I double click on packages and then I type design that not eggs e. So it was search for the designer It is it likely car right click and I create a shortcut in the desktop. I cannot close. You can see this. I have to. I will just remove this number Click. You will see this window and here we have different type off the elements that we can use for our case. We use main window. Just click on the main window And did God create This is the empty window will start bay saving this in the same order in food. And I recorded to me with small characters and safe. So the first thing we will drug top budget on our screen. Let's put it in here. Will resize like it to make his bigger we click right click and er the new top So this will give us treat up First stop was slipped and go toe Ah, couldn't top text. Yes, and it would call it on identity. This airs need is Okay, so I just put in it would select the second tub and they will call it in eventually. Study sticks just like this. And finally we select the last stop and we call it its inventory. Okay, Now we make the text bigger. Who say night like goto on text. We six this state and we were sitting with the size and take Okay, then apply. Okay, so now we'll go And drug label books. This is a Q level just like it is. Make it a little bit bigger and you're right Parts inventory manager would make the alignment horizontal alignment us center, and we'll just pull it from the two sites like this. And we will define a style by right like style at the front or and front century aquatic and decline size, bold and click. OK, then apply so we can increase the little bits. So from 20 to just make to received wisdom and click Apply Then go to the next line and a text color. It's choose Discovery. Click apply. It's okay. Are the new line and background color. It's shoes. Great. And apply. Okay, we are helping like this. No, x IV next one. He's okay. Uh, you table widgets from here. We'll just drag and drop on just size. Okay, Now we can eat it. Now I can edit the elements. These are the Collins names. Just click on plus plastic. Add nine columns like this and we can start putting the names. So 1st 1 is I d. 2nd 1 is the reference, if you remember, arteries. So after this, that is part name and ah, meaning area Minimum area. After these maximum area. Okay. And number off holes. Okay. Sorry. This is remember. Or just member holes. Ah, minimum diameter on the mark. Simone diameter and finally Kahlan count. And it's OK, so the text is a little bit bigger. We will just make it smaller. So and make, for example. So just select centric Otik on Make 12 for example. Okay, maybe it's acceptable Can click OK, and the same. Now we can drug another level just here. He would adjust the size because it will be a long sentence and there will asked operator the users to search for some reverence. Okay, so we'll go to properties off this label and text and just right search off difference. We okay with difference with count level lower or equal toe lower. More to okay, say the good, uh, you can just put, hear, hear Oh, instead of okay, just precise a little bit and it's OK, so we put it in a detainment tree. But in fact, it should be in inventory details. We just cut and past. It's just such easy, Okay? And say next to drug spin books, this is a very good to to write numbers by just taking every size a little bit. Let's leave some space way. Put this known your salute in order to make this a little bit larger. So it want to make this change aside, Just click on any widgets and I needed to the site. Okay, so now we'll go and look. Putin sees a push button target. Make the size of it. Okay. Hope. I think this is much light. We were just intensely it on. Now we just changed text and make for example research. Okay, that's looks not bad. Another one in the bottom. This is the revelation bottom. So I think that is most piece We just means the window bigger. And I just decided on the bottom. So the text on the button is very fresh and receive that It's small, so we'll just eat it this time. So I did this time, Onda uh, shoes were visible. Can centric aquatic Andi declined the size 16 apply Looks OK then. Okay. Okay. No save. Okay. And I will define the names, the names of the widgets. This one should be table Okay. The names are important because because we use them in the program. In this pin books we call it count filter txt. I can't live in peace or count inter txt. So when we call this, Uh, we just from the program. It will be called by this name for the bottom. We will call it search button at the finish button We called the refresh button. Just remember these names because we'll need them save. Ah, just make the texts off this one little bit lower. Okay? Now looks better. Okay? Save. And we can Ah. Okay, this one. We can put this little talk distance and up and precise like this we can visualize by clicking control air, and we can just make a visualization off the the window. Okay, Can close. So we can change also the title of the window Medio bottom, Middle of properties, window title and we call it part Invented the manager. That's like this save We can make control again and received that the name Waas changed us . We like. Okay, disclose. We can change Also the beacon, if you want you have taken can just goto windows aecom and click on choose file off. Choose cultural resource. You can select a comb and click on open. It will change automatically Corn off your window. Okay. Save 7. 06/ Python - PyQt5: Design of the GUI in QT Designer - Part2: So now we will go to the invented is 36 and you will aren't some labels. So it's drug 68 hours. It is the 1st 1 It's just in short position and we go to text Joe writes. So this is the number off reverence just like these. Ah can resize a little bit. Okay, Got it. Little between this center just to compete, control and copy. And the 2nd 1 is number but type. So this is a number off part types of his member off parts family and the top one is a number off repentance, unique reverence. So it's copy control and track. Sorry. Just control on drug. Very the most to copy Onda we put here. So this is a minimal member off whole. It's right minimum. Remember holes And the 2nd 1? Well, right. The maximum number of balls. Number or falls. Okay, then it's OK. Just like this. The suit. I'm older. Another copy. So is it Can label will hold the valuable. So this is a This label will be changed according to our a frightened program. So for the moment we put just zero and we can go to change the style change of style. You can show the front some century Kotick. This is my best. And make the size there and then click. Ok, a polite go to a new line and color mysteries this one or maybe this little purple and look ok, then apply so we can make it even bigger. Just like these. Well, maybe, maybe more. Okay, apply now. We can just put four times second warm. This is for months. Remember holes and for minimal member off us and to help the riv illegible. Two additional to display which difference have the minimum number of poles and which parents have the maximum number of holes? Well, just right. Just to remember that this is for evidence. Okay, What's next? No, we drug table widgets looks like here and we can make it wider. Okay, then we can eat it elements and you will add three columns. So the 1st 1 would be okay. Let's say the reverence on the 2nd 1 is part name. And finally, the accounts of the stable will display the top three reverence with minimum count level. It's changed a style on by making a text a little bit lower it. Oversize. Okay, Not exude. Likely. Okay. And you need a label to indicate the reason off this table. And you're right that this is to display the top three reference with minimum count level. So factory residence would be an imam. Entity level Intel's ladies. It's known out it's clear. And now we can push a button to the left side of the stable. And this is a check button that I show you in the first video. So if clicked on this button will show the doctor a difference, I think slavers we can make a little bit Sawyer. So this is to display the difference. Perseverance. And this is for the second reference. That's like this click save. So it looks okay. Now we can start to give names our commence. So remember that names are used for the program, so we have to remember. So this is lbl label. If number I just think it is on the 2nd 1 is label parts number. Okay, the turtle on is should be minimum Lunder holes or label minimum balls On this is Mark's Mom label maxim holes. And for evidence, we can just go pedis and put Ah, like lbl Max number mock salto and 1st 1 copy in the past. Name A most. Okay, this can give table two because for table in the first stop was named table. So this weekend Name, table, toe. And we know that we have only to tables in our up. So it's easy to remember And this is in the same, uh, camp chick bottom and the definition button. We already put the name so click save 3rd 1 is 18 century. So here, Okay, some textbooks Or maybe better to, uh, case on leaving first. So he pill will display the nine fields off our database services in order to navigate. It shows apparently shall just compete this four times. And after this, we just could be again make it in the center, you know, and the let's do it. And now we're just start writing. So this is to be a reverence like the first column off our team. Second on his part name. So part with normal. A but name on the 3rd 1 is minimum area. Okay. And it is a marketing area on this is the so I should bto number of balls So these are just labels, and in front, it's one we would put it. It it it line just a small textbooks to display. The variable thirties is minimal diameter on this one is maximal diameter. And finally, Cohn's. This is the event City, living okay and on the top will display the I D. They're also it's This will be not change it now it's drug it. I like it. Let's put this style the line it It is a textbooks which allow only one line. So this is what we need in our case. So let's let's write text to display just to display this tale. And to be sure that we selected the good style Onda. After this, we can just copy Ah, seven times 4th 1 on the select everything and we copy control on drug. Excellent. Yeah, Now it's negatives. It's morning and more in the center. Ah, this is just copy it and I will change the background of this one because I was displayed in the label books and not in Texas. So it reaches a background to make it resemble And is it empty? Okay, now it's just it is these fixed and let it in. Okay, Minimum damage much in diameter and count. Okay. No, Everything smoothed. What's next? Ah, no. Maybe we can remove these and we'll play it by spin box. It's better. It will be good, because this is counter can just click on increase the number of victories number If you can see I just applied distance in the same style. That's the idiot line. And then we can start Just making the my name's or putting the names. So this is rebalance. Remember, this is only small characters. Okay, this is part name. We underscore this is minimal area with small characters and with underscore. This is the muck single area number of holes. Hmm. There are many more in diameter. So you have to remember these names very well because way use them in the program. And don't worry if you don't remember everything, it's not needed to remember all because we can just keep open the designer and you want to go toe control. We can just go and check the name. Some outlets add some medication buttons, so this would be form allegation balance to go to the next row to produce row and to the last or the first row. Let's put this to mean that is the last row. Jesus style. So if you have a cone, it really better. But for my case and to go toe to go first, we just make some characters, okay, color some kind of purple. Okay, apply. And now we'll just could be we just days and all you want character and again control the drug. And this is the opposite character to mean serious. So let's todo is checking it fixed and put opposes character. And the year two characters. Okay, Marissa looked and finally will add the buttons to operate the hobbies or toe in euro or to delete completely. So this is the 1st 1 This is operates Button. Okay, we just control on drug to copy and two times. Okay. And we call this one deal it okay? It's always we did it, but, um, on this is odd to Arden. Euro. Okay, now we've names, So this is simply a date in the score button on this is delete and the score bottom on the last one. You guess it's odd. Underscore button. Okay. It's giving names to the navigation buttons on. So this is last in the school button on this We give next on the score button on. You guessed this one is his previews. And this poor button So OK with this and someone is first and risk our button. Just perfect. It's safe. Okay. And, uh, we can even change the style, make it cool or make it a little bit darker. 150. No, make it smaller. You 100. Looks like er again. This one. So these are the RGB colors Red, green, green and blue. We can access each one separately and change. So it is OK that we just copy and paste. So you are free to change the style us you want. So this is the editor of the style. This is a type off say says CSS editor. And using this, you can make some great styles receive. So now we finished stub his head into the top. Maybe we can change the front this on. Okay, Aunt. So my favorite is centrally chaotic on 11 review check. Okay, that's put this only can change to the blue style and the same court. All that is okay. Is how this honor make it a little bit low. Some kind of that blow. I will just delete this line and a new line on we choose some type of dark willow like trees. Okay. Looks what bed can even make his bitter. Okay, this is controlled toe visualize. Okay, These are textbooks is our spin costs were confined This other navigation buttons so I can just write a check in the style of good repute. That's fine. So almost done. Maybe before, but to give a name to this one. This is small I d small characters. It's chick if didn't forgot to give object name because this is very important. At least we have is a boot. Someone is on our food and also fish. And it's done so finished. 8. 07/ Python - PyQt5: Create PyQt GUI loading and displaying Class: hello and welcome to the next section of this course and in which we will focus on the fight on problem in aspects off our projects. In this very first video, we will focus on writing some code that you are really not obliged to understand 100% because it is common toe any pocketed five projects that you will place in the future. You can just copy and paste the same line of good in any off your future. Do we projects? So this code is simply a template that contains important off the Piketty five libraries, then to connect to the program and beauty designer file and make a lot then to define a class and the constructs are told all the remaining put. So these are common steps that I do in each new project by just copying and pasting the same template was a change is only the body Ah over the close. By adding my new functions to interact, we do, it just takes it up. So first thing first, let's create a new Brighton empty file and save it in our project folder. So let's go toe save us and selects our project holder it was my first bike. 35 and give it a name. Poor ism. Eventually and okay on the team are on click save. So no, it saved become six hour working directory here and at the lifts on the right side, you can see help body Will Explorer and file Explorer, in which you will see our database and our design window. Okay, so, no. Well, just toe. Is it the Colonel? Okay. Ah, because I was trying some call before just to clean the vital council. So here you can see in the e bite on the I bite on council. So let's start importing. So from packet E five not beauty widgets import everything and from bike 85 not beauty. Do we import everything? And from my kitty five import. Ah, duty widgets. Okay. And we're right from Pakistan. Five. That beauty core imported visiting from yakety five a boat. So here, right. Not, uh beauty Regent's import. The you mean window. So it's and killing window on us open by crucifying That's you here which it's importante que application. So in any of your future projects in, just import the same things, so just copy paste. Don't waste your time to think each time. Which things I have to important us. Import all this line, of course, So we'll add from Piketty five. It works by Q T for beauty course. Ari and Will Importantes will import. It was in both parts on her back. 85 million. Not you. See, we import large white types of dysfunction will allow us to load the graphical user interface that you were designed in. Q t designer and we affected toe form. Class equal Loaned me. Why type? So let's get to the parts off our projects but that their name and will search for a file. That's it. Cult means dirty. Why so remember we called our design main does your I Q t designer and we will import. It's your light since we are dealing with the database product so it's compile this control enter and we see that there is no error pursued. Its continue and compile, uh, other lions. This is a good let's executes else. This line of code, it's or lonely. Why type is good. And now let's load our window So it's called it and because if you were to this line also not good. Okay, Now we finish with important parts. Let's create my main class. And we we designed cumin. We don't remember so human. We know because we said exit acumen. We don't Orc Utd lineup. So we have to write it here. And second variable is the form class. This is This is the design so and let's define our constructor. Ah, on the right, I guarantee equal none because no parent and we call super function. Um so you make main self not is paint and later que mainly no, not hes says okay and self, but set up the rise so self so this week, all in every products and handle bottles. So this is a function that will handle the click events off off off our bottles. So that's it. So this is a definition off our construction. So this is common on the projects are just copy and paste the same the same complete. And here right we will define our function two for the welcome clicks and it will keep its empty by just writing past services. There took just my partner to bypass For the moment this function we will write the court later. Okay? And after you finish. So we have to go charity to the bottom to complete our template. This is a Piketty templates. So here is our code. So this is the specific code for our wallets. Andi, Completely at the bottom. Just define main function and right up equal your application. Asi is not arcs. Onda uh, we know Define a window, which is because it told Maine can us. Okay, that's it. On a window that shows that this is to display are no and up, not execute. Okay, so that's it. So this template if you execute it should show our window. And lastly, if name eagle equal domain Ah, what's real? Ooh, so well on May. That's it. So we finished the templates for Piketty products. Andi, if we execute everything, we should our code Our program should load the designer window. So hero writes article so it's safe and execute. So there is some error here. Handle weapons. Take one position argument. Okay, so we are maybe toe check our handle, But the definition in the constructs Or maybe in his bus? Yes. This should be just empty. Just like this its executive Gana chick. Main object has no attribute. Handle bottom is another error on it seems that wouldn't be with us. Yes, it's like this does it? And no is cute again. So you know it's loaded. It's in the bottom. So it is it. So this is our window. It's Ah, it is executed and loaded by our fight on program can just close it on tick again. But on script pick on here is it So it's connected Moto our support to our script correctly and it's doing nothing because the Commons and the widgets are not programmed yet. On this, we will start doing its in the next videos. Que check? Putin's are there. Okay, so I said a cup. So for each package it protects, just started by important celebrities us. I did import parts and import, do I and then define a class and write the constructor exactly as the same. And define a function at the bottom. And that's our off the list. You in just need to start writing your coat. Thank you for watching. See you in the next video 9. 08/ Python - PyQt5: Load Data from Database and display in GUI Table: Hello. In this video we'll see how we pulled later on displayed or user interface. So you remember this bus sound now will rise here, some court to handle some bottom events. Okay, so we are talking about the refresh button. So remember, it was called a fresh be 10 definition, but okay. And you will use this name in our code off course. So what we will do is, as we will write a self, that definition button. Okay, that clicked. So this is the clicked event that connect. We will connect it to a self get data. This is a function that we were right. It will be called to get data so well defined this function, get data, my case, and they will say, Ah, firstly. So this is to connect to a secure lights these surveys and feel our in graphical user interface table with data. It's divine. A database connection, Eskil lightly that connect the name our the Tubby's part Devi because it's located in the road folder For our case and its defining cursor, it's DVD. Ask yourself and ah, this comment. This is a common that will hold the SQL statement for the data. So this is selective editing from part table. OK, Andi results. Which is the execution off our killer, sir cares about execute Cummings. Okay, that's a good after this. It's called self Doubt Table. So this is the name off our table? Us? Ah, a Swiss. As we defined in the graphical user interface. Okay. And what's but you will say who say ah, table not sit at our count. So this is the count off. Rosa will define it. Zero it is us initialization off the number of rows and later we'll say for row count raw data in in emirate results. Data pulled on. We say self. The table. That's insert troll. Ah, number. Okay. And for Cullen. Number and data in enemy rate result. Sorry. Row data. Uh, self. The table that sit items. So this is the items off the table. So we will set the phone number The colon, the colon number and had cute he table widget items. So this is the type at the type of days, I will convert it Toe beauty. Really? Widgets item that would have some issues a year. Okay. Say that Ah Oh. Number not defined. Colon coun. So this is this Should be Maybe hello, Color maybe. OK is on. That's it. So that would So this is the line. Of course. We were used to feel the data in our table. This is just a four line of goods. So least I know it's execute. This is our ah, I mean, window. And with click on the definition bottom hopes it's nothing display, maybe do some energy. Is he say that name? Ah, phone number is not defined. So it's gonna be this error. Okay, lets close First this one and you can see that it's and aligned with orange color. Ah is sorry. So this should be not broken, but our own them there. That should be okay now this is the loop immolation. Look to feel all the data from the database in our table. Let's exit use again and click. Refresh. It seems that there is a second air. It's close and see OK name a certainty is not defined. Okay, this should be mysterious String. This is a data types of waste year. Just should we could No, it's just again and you click on the fish and boom. So this is the data are displayed here can see the different colon's mark's day and meter. We can resize manually also Okay, against cool down. This is the count cologne. We can see a difference value and such a lot on. Of course, it's still not working because we didn't define Cody it. Okay, this is it for this video. Take you from marching to you in the next video. 10. 09/ Python - PyQt5: Create Search Filter for Parts Inventory Count: I low. So now we were right on your function. So always under the 100 buttons, we will define function for the new button search Wooden. So we say self, that search button clicked Samos previous That's connect. Andi was connected to a new function that we can call Ah search so you can call it whatever he wants. Okay. On dysfunction. Ah, If we click on the search button, this one, it will go and take the value here and make it as a filter. It's a condition to pull the data from our the surveys. Okay, so now we need to define this sexual so seeming automated and if ah, since okay, and for here is will be similar to the previous function. So we can just copy everything from here. For example, toe to toe, go faster, will copy air intake because because we will be also reading from that obeys and feeling the table so they beat approximately the same functions. The only thing is that you had some condition is the filter. It's filter for the count number for the inventory count level the's value. We will get it from the graphical user interface or will define variable. This is an integer and it will be taken the value from self but count filter take c So this is the spin books that text So we say that take the text off this widget and converted to int and then put it into the number of variable. Okay. And for select statement I will not sit if everything but will only select the values when the count colon off our table. So is it the count's color lower then certain rodeo. So this is a question mark. It's likely so puts question are and it it will present the number. So if we open outer to these and we go to our table So we are talking about this color does it count column This is the car industry will be filtering on so lower or equal to ah certain value to find value that it's called number. So we're not all right number. But you will go to the comment and he would put a comma. And here we will put number so automatically the common The skilled statements will go and read the cursor and we'll replace number ah in the question mark Okay, so that it So now it's almost ready. It's execute no and chick. Okay, We got to get into the details. A refresh to show on the data. OK, it's showed quickly. Now it's set, for example, in the council in for values Lord entry. Okay, so we have three rows which respect to this condition can search for two. We have only one part on for seven. We are here parts with lower, eventually level, then sit on. So it's Horgan correctly. So thank you for watching See you in the next video. 11. 10/ Python - PyQt5: Display Parts Inventory Statistics in QLabels: hello and welcome in this video in which we will see how to displace some statistics about our spare parts. So we will display the number off reverence, number off parts, the minimum and maximum number of roles and for which evidence and for this will use the six labors with the object names that we just saw in red color. So remember this objects name, so we'll use this in our Britain over me. So now it's jumped into could. So everything will be under this get data function and who write the first part just here and second, the part for whole statistics in this section. Okay, So as you can see, this one is called Israel a different number and the 2nd 1 is level parts number. So it starts by this two levels. So what we'll do is that we create additional cursors so cursor to it's equal to DP That care, sir, and kids have three to devi. That's gives her just like it is. And we will define variable or ah comment called parts number equal to select and with count ah distinct values off part names. So the spending unique values from the parts table just like it is. And another one called the Venice number I would should be equal to the same select selected account. That's mean the number off elements that are unique. The stents from our reverence this time and from parts table 1st 1 is for part names and 2nd 1 is for evidence and will define a result off reference number, which is the cures are true. That execution off the comment if it was number and with the same method result part number equal toe cures her tree that execute the parts number. Okay, after this with affect this toe level So self Ah, real riff number. That's a text. The string off result Ref, remember that fish on a sale? So this one that's me will all right the first value if the return off the return the result This is why we right zero. And for the 2nd 1 we just been placed and sick and we were right parts. Okay, so that's it. How we do things in SQL lightly. So it's save and execute Goto elementary details on click on the flesh because they are in gets the function and we see that he gets 12 reverence and three parts type, which is correct. So that's moved. The function is a working Now we will add more 36 in the other levels for the minimum number of all maximum, the whole exit. So it's they find additional cancer. So kisser for which is equal to Devi that kisser. And here's five, which is five equal to a DB. That's care, Sir Onda. We will define our Commons. So this one, it was, say, minimum hold. I would call it Mill Whole equal tool Our Israel common is equity so we could select the minimum. This is the minimum also we say minimum off number before so disease colon literally lose from our little bees. Okay. And her defense. We will pull to information at the same time from past stable. So the 1st 1 will be displayed in the first label and the 2nd 1 in the second lib. This is for the minimum and for the maximum will do the same. Just a place here, the maximum and it will be also a number of whole and reference from are stable. Okay, now that's what it's no create a result for minimum hole and will be the execution off the minimum hole. Ah, come on, because afford us, execute me more and cook panned based and we changed the minimum by Marx and use it for my cursor five and your minimum by maxing. That's good. Now it's timeto display these things in the user interface. But before this will create no more able, everyone should go to result me more that if each one so we'll just grab first results and are to it a results off maximum hole, not for each one. Okay, and after he's so let's write a comment So printer results in Q labels. So now we will use some indexing off R two and R R one R two to display the results so it's right self minimal. That said, text uh, self taught label maximum whole lot text out. These are the names off our Q labels. It's so writes everything and minimal too not text and label maximal too not set text. And now we're right. Which of our use they will display. So 1st 1 is will be the results off on a one, so it's copy and paste on and the same think here is when we just This is way were converted to string because it's a label for your label. We call that the results to sing and it would take the index zero, which is a number of holes and same thing year. The thing off, our one are so sorry. And the number zero, which is the number off holes, are so for the maximum more. This is for the Muslim world. Come on. And copy and paste on the same here. And it would change here only the index number from 0 to 1 because for the to last tables will use the We display the difference instead off the number of holes. Okay, so it's just one woman's. Yes. So everyone writes one and here is on. So I hope this is clear. If it's not clear, just leave me a comment. Uh, it is some medal here. What is wrong? So maybe some penalties? Yes. Here, one IHS another one here. Okay, look, Suit, let's save And okay, this is our main minto. Andi was click reckless. Okay, on you can see the values. There is some issues because it's say one and one This is wrong is for maximum, which should be more than one. Okay, so maybe you have some issues in North Korea Will go back. Check on and yes, this is true. Sorry. This should be maximum number off holes. This is the scale. Comment on Let's now save and execute again. Okay, so before this will just make this one beer can save. Now I can go back and executes again. The auto eventually. Details. Click the fresh on and check. So now it's a six on dissidents. This evidence. And here you have one reference with minimum number or force. So this is correct. Our commands are correct. Uh, this is how we do it. I hope it's clear. Thank you for watching and see you in the next video. 12. 11/ Python - PyQt5: Display Top 3 Parts in QTable and Navigation Rows in GUI: Hello, Burke in this video in which we will see how we will displayed Top three reference with the minimum inventory level. So the idea is to click on this bottom and which is called chick bottom on to display the results in this table, which is called Table Toe. So that's it. Let's go back to the good and you will for sure. Start's always by connecting this button in dysfunction handle buttons So in the same logic will right itself not, Ah, tick button that clicked that connect and we will connect it to herself that, ah, level we call this function level okay. And now we will need to create this function us usual. So let's go to the bottom and it's defined dysfunction. Okay, let's say nous 11 self. Ah, two points and we go back to the line. Now since we are dealing with a function to feel table, we can just could be the first function that you used in table one and we will changed, called a little bit. So let's go back to this. Get the data and we could be this lines of code. Ah, which we used to reiterate over the the lines and columns to feel their table. We would just paste it here. Okay, it is not. And now let's change a little bit. So for our common, we will not select everything. But who will select only three ah columns which are the reference on and passed name and the count. Of course, because we are dealing now with elementary level, this is most important information here. That's it from particles. Okay. And we will all right, order by counts because, well, try to make ascendance. Ah, under because we are looking for the lowest values and you're right limit tree to just limit ourselves in three values the three lowest values in the table. Now this will still still the same and there will keep the same. We'll just change table by table two go because it will write these things in table two The same things here table, toe and lastly, a rusty metal. And this should be enough. Let's save on execute. There is some it'll and just we have to go back a little bit. It's execute. It's try from the beginning. Let's pull the data. Then we go back to elementary statistics and we click on our water That sort confined. We can see that we displayed the top three difference with minimum invented the level just This is fine. Our code is working very well, so that's good things. So now we will try toe display on a vacation data in this text Books. This is que it it line. We'll just pull the data and display each. It's item one idiot line. This will help us to do navigation later. So by this we will define on your function. We will call it Marie. It just like these Murray eight and safe. And here with connect again toe arteries. Just copy and paste. Yes, sir. So sorry we have to. Could be also the Devi equally skylights that connect exactly like this. It's a line. Go back a little bit Sometimes I have some troubles with Meet with my emails. So it's defined Calmund So coming equal. So with the same metal us I showed you before it's ah select. I was said it's everything, friend, not table. And that's it for the comment. Now the idea here is to dispatch each results in a separate textbooks on I will show you how to do this Now it's quite a cursor. Results it called gives all that execute come and just simple of this. And we define a variable called well equal to results. Ah, not if you Joan. Okay, so this world will hold all the values from its Stephen. And now it is defined our sewage. It's on the textbooks widget that we have in our H m I or in our graphical user interface. 1st 1 is I D, which is a label books Next. Tony's reference Not set text. This is textbooks, but name that said text. So just like this, we define now the textbooks that we will use to display the values from our table. So number of holes to set text self that minimum the meter self that marks name, meter on itself, that count set value. So here we were, right set value because it's spin books, not textbooks. Okay, on what you will do is that we will use the vault result. So we converted to drink. So is there and we use the index. So zero, That means we will, right and the value from the database from the table colon index zero. Same thing will just opened based. And we will change later. The indexes. So the index mean the number off the table from our database number off. Sorry. It's all right to well right today for five with you do minimal damage. Terror six Kahlan and seven. Ah, normally it should be eight way Missed. Something says minimum. It's chick. Maybe we missed some colon or way. Ah, OK, so we just missed the Islay. So we should start from the i d and they will just increase. Their four is five is a six. This is seven and eight. Okay, so now should be okay. Let's execute. So we don't see any things. Do we have any error? Or maybe we missed something. Maybe you guess it. So we define navigate function. But we didn't link it toe something to some bottom. So since we are not, we will not link it to a button. Ah, well, not write it here. We can write it here, but just to show you that we can call it from the beginning in the in its function. So, just after the execution off our ah program, the data will be displayed automatically. So under the in its function, we will write self, not navigate just like this, and receive and is huge on it is some air I think Caroline is did so Let's go back and inspect our good. So here says value. So since we are okay, since we are dealing with the value that this should not be a stink, this is a mirror. The value is should be. Ain't so this we can see it's on the properties. This is not a textbook. This is a spin books and there will just remove the stair. We will just get the value from the table and post it directly to the spin books because the value originally it's ah, it's not a text, its integrity. So let's execute on and we go 1st 1 always noticed everything. It is working, and as you can see, we have the values displayed in the different textbooks. So it's textbooks all the one value from the comment from SQL Commander to be just It is cute. So this is good as we expected. Thank you for watching see you in the next video 13. 12/ Python - PyQt5: Update the Database Table from the GUI button: Hello. Now we will write some code for our ad bottom so self that button not clicked that connect self that and so this is the name of the function. That's well right. Let's ago completely on the bottom and to define this new function. So if on since and so you can imagine that toe add in euros, we will use approximately the same logic as the update. Ah, function. But we will change a little bit in this code, so don't do not write everything will. I hope it is part of the code. And we were based it in this on the button on and we will see what you will need to change here. So I would not need the idea because the i d. We will not add it because it was configured Toby Auto implemented as you remember, when we find our the table redefined the idea US auto agreement. So no need to define it and update will be replaced by insert into okay and part table would keep it and no need toe use this set. We will only open the parties and people right directly the names off our colons. So Let's remove this question mark, because we will use it later. Just remove everything. And here we were right. Values open. A parent is And here we would put the question marks. So just we can't the same number of question marks. S O R. Colon counts. So that's it. They are almost okay, So it's execute. And before this, let's check what is the last row in our table because it was compared it after execute to check if we will add some euro so you can see here to last row is number 15 and but logically who execute our court and received that the number of rows increased This man, our code is working fine. So let's execute or go toe. It is an elementary. So let's simulated that We will write some new values. But in your difference your last name with some pollinators like this and we click on hud. Okay, I can see that there is some error. Okay, it's talking about into and we we didn't write it correct. Should be in tow. Just ladies. Now should we find that it's execute again and again? We're rights to new values. Let's define this us our new values and thats click on the button. Okay, No enter. Let's no open our Toby's and go to our table on. That's great. We can see that there is a neuro number 16 and continue exactly the data that we entered in our graphical user interface. So that's mean our code is working very well. Ah, that's just easy is in the middle toe. Other neuro Thank you for watching and see you in the next video. 14. 13/ Python - PyQt5: Delete a Row from our Database Table using GUI commands: Hello. So in this video, we were on the delete function. So we will use this button Indonesia button. If you click on it, it will deal. It's in the actual and we will use the I. D us identifier off the road that we want to delete. So us always will goto handle buttons. And but we made it a new line on and, of course, self not in delete button, not click. So here will link our button toe the delete function. So this is a self not millet. Okay, on. And just author, this will go down and create our intel. Its function. Okay, so let's put it just right there on the metal is tried this in the lead self. So two point and here with chronic to our database again, he was in the same method. So I'm sure it is, uh, more proper away toe to connect the ways to not repeat it in each function. But this is not the goal of this course. We are in a by pretty Corso. For short is some way to define connection once and not to call it each time so he and we would define about able D that will hold on the text that is inside the idea label. So and we define our column or Calmund, it would be this time delete from our table. It's ah, part Stephen. When I nd I did a I did column off our table Equal toe ah, defined the value of this is a question marks as always so in India indirectly defined the volume. Okay. And we execute our common using the cure, sir, that execute in the Calmund on and come on day Okay, Just like this and to apply exchange with rights DBT commit So it's such easy. So this is the lines off God that we need to delete Literal. So it's now execute on the voter. It is an inventory. So now we are located at idea number two. So its own Ah, this information, as you can see, a reference Exeter. So let's get on it. Idea number three OK, it's none. Let's close and open again to see if we are always in the road to So now it's showing idea under street because idea number two waas till it That's mean our function is working very well. Ah, so that's it. Thank you for watching and see you in the next video 15. 14/ Python - PyQt5: Add new Rows and Data to our Database from the GUI: Hello. Now we will write some code for our ad bottom so self that button not clicked that connect self that and so this is the name of the function. That's well right. Let's ago completely on the bottom and to define this new function. So if on since and so you can imagine that toe add in euros, we will use approximately the same logic as the update. Ah, function. But we will change a little bit in this code, so don't do not write everything will. I hope it is part of the code. And we were based it in this on the button on and we will see what you will need to change here. So I would not need the idea because the i d. We will not add it because it was configured Toby Auto implemented as you remember, when we find our the table redefined the idea US auto agreement. So no need to define it and update will be replaced by insert into okay and part table would keep it and no need toe use this set. We will only open the parties and people right directly the names off our colons. So Let's remove this question mark, because we will use it later. Just remove everything. And here we were right. Values open. A parent is And here we would put the question marks. So just we can't the same number of question marks. S O R. Colon counts. So that's it. They are almost okay, So it's execute. And before this, let's check what is the last row in our table because it was compared it after execute to check if we will add some euro so you can see here to last row is number 15 and but logically who execute our court and received that the number of rows increased This man, our code is working fine. So let's execute or go toe. It is an elementary. So let's simulated that We will write some new values. But in your difference your last name with some pollinators like this and we click on hud. Okay, I can see that there is some error. Okay, it's talking about into and we we didn't write it correct. Should be in tow. Just ladies. Now should we find that it's execute again and again? We're rights to new values. Let's define this us our new values and thats click on the button. Okay, No enter. Let's no open our Toby's and go to our table on. That's great. We can see that there is a neuro number 16 and continue exactly the data that we entered in our graphical user interface. So that's mean our code is working very well. Ah, that's just easy is in the middle toe. Other neuro Thank you for watching and see you in the next video. 16. 15/ Python - PyQt5: Add CSS Style to the GUI form in QT Designer: hello back to this video. So now we see how we can apply some major style to our product. So it's type bike beauty five cases style sheet in ah, Google. Forget it. If he shows, for example, the first link will be directed to some projects. So it's quick to go to the road folder and the year we cancel can find some files shared on the net. Ah, click on source and we can see here that does. We have three types classic dark blue and dark orange can just click and go inside and search for a cure sys file. So this one, it's called style that cases. So this is just one example off money that you can found for free Internet. And if we open will find a huge file that contained ah CSS divination for almost all the widgets that can be found on the on the main window off off the beauty designer. So generally what we do, it just selects everything and who have compete on Goto beauty designer on past it into Maine style editor off our window. So it's quicker and make me and we go back to our beauty designer, and you make sure that we are selecting the main window. So let's click somewhere in the main window. Be sure that you are there. Andi Click for the style editor on past everyting So after it passed everything. So just to make sure that there is no mistake by chicken, if it is the green, so that's mean its volleyed and think apply on the while. This is a very good style, so this is a dark style. One of my favorite can see that's on twinge it change style with the same style, and colors are very good. So this is blue button on. We can see some animation when we go over the the Buttons on and it's changed style us when we clicked. Exeter. So let's save this. And now we can execute our project and we see how it will look when we pull the data and we display waiting on the table. It will for sure look better. So let's go to the different tops the 1st 1 and we take on the refresh okay, and what else? We can see different values with some over color, some click color and some background color okay and can search. Everything's looks fine. Say so. This is Oh, are Ah, stuffed where? Within You look. Okay, Andi, here we can see the textbook. So this is this is being color because we change it so we can just on the year. This is the label works. We can change because it's still white because we change it in the QC designer. So that's it. So now we can go and try other style. Let's try, for example, the orange style Rio and the select cases. Or click on. We go inside the code, so let's select everything we click on the beginning on we hold shift button and we click at the end. It will selects everything on to be a copy with the same metal on your back years to the main window it's again on Let's make control A to select everything and deal. It just did it and passed. Then your style, and we check that days. No error on the click apply, So this have also a dark background, but it have a very good ah effect. When we go over on the bottoms, we will see. So it's execute so This is an orange bar that we can see on the top is even a very good looking. So this is in the top, which it's and you can see it also in the buttons. This is Ah, all stream And also in a when data that is orange and red background for the sales. And when we select that's really nice. You can see our style. Okay, so this Oreste ID, we can also customize if you want, so it's make some search. Okay, Everything working as expected. This is the values for our top state difference, Andi. It cannot see correctly because we fix it this color so we can just go back to our qc designer and change color manually because we are, you fix it. So for the remaining things, it's ah good looking up. So now we are not civilized to keep these colors so we can just closed this one, okay. And go back to the cruelty designer. And if you want by, for example, to change this color, not orange, we want to make it. I don't know, yellow or green on real. So we will just go and this code and try to find que button. So when we hear when we put Cuba, time doesn't mean it will apply the same style for all the bottles in our window. So this is the cue push button. And here is the definition of the style so we can change the monetary south site. So this is pressed. So when we say President, I mean, this is the style that we will see when the button will be pressed and if we scroll down, we will find out. So ah, you push button over. That's mean. What is the style that we see when we move with the mouse on the bottom? And this is similar for other other que widgets so that that's it. You can go here and check and change. Manolito, adopt style to your own need. So this is the curious s style for Piketty. Let's go to the top. So this is or one we don't apply one style toe all the widgets and these other metals that is so in the beginning to pick right, click on each widgets and define the specific style. Okay. Thank you for watching and see you in the next video. 17. 16/ Python - PyQt5: Compile the Software as (.exe) file using PyInstaller and AUTO-PY-TO-EXE: hello and welcome in this video in which we see how we will convert our product toe executable file that we can run outside our computer. So we need by installer. So this is a fighter module that we can install. It will help us to convert our project. So it's click on the pipe I got or websites Onda. We go a little bit now to see how we we didn't start this. So we will use bypassed on pipe installer. So just simple like any other package. Let's write it pipe install by installer and we use a cute So for me it's already installed . So I am just showing you how to do This is the first on and the 2nd 1 We will need another package called auto pie. Too easy. We click on the first link by pilots dog on and we go inside and we see So this is packaged . This is a nice software that will help us toe compile our software. It will be installed also using pipe install autopilot to exit, um, this tool of a graphical user interface. So it's very easy to use, but there's some things to say we show you. So it's right by Pakistan Auto By too easy and presenter. So it's ah, already installed. So that's it, Andi. Now we really need to go on search for the installation for look. So let's select the Anaconda Tree installation folder and we open it and we go to the folder called Scripts Inside with Search for the Auto by too easy. Ah, software. So it is it so No, we can either send a shortcut to our this clip like these, or simply toe open it. So this is how we open it directly. We see this nice graphical user interface and we see that is some buttons, etcetera, first on his brows. So this is where we select the by trial of our projects. So our project by file is called inventing Manager. So this one with selected Onda, we will need to click open. After this, we can select either we want one file or one directory. So one directory will put all the necessary If I was inside and the one file is one single executable file s so we can shows if you want to show the and the window Andi here we can just select on economy who want So let's me choose this one. And here we are all the external. Why is that? We have, for example, in our project we have that base. It's an external file and we are also the main window which is Ah ah que t designer window called me and don't you I, which is also extended fi So we can really hear that It say that we have to adopt our code to be able to use or to load this external fight. So I will show you now to adopt your code. It's very simple. We can go back to our good and we will add one special function. They were just busted here, so just posed the video and complete dysfunction inside your good. It's called very sore spot. So dysfunction role is to define the route parts off any files that we used any external file that he was in our product and now we can start by the main window file which is extended high and instead off right in this line, we will replace it by resource part. So we were loaded this file using the function that was spots. So how to do it? All right, resource, But on between guarantees we write main you I So this function is responsible to define the route parts off our file. So that's it. Now we can do the same for any external oil that we call in our problem. And by this I mean the parts that Devi, which is our batteries. So instead off connect part of TV, I will write at the source. But Andi Personal Navy discloses Valenti's and no, we are okay because these are the two fires. As we are police execute. I see that it is some inner. He told me that name always is not defined for sure. It's caused by the new function that we just had because it's used the the U. S. So it's important for us and executes again just to see if there is no error. So it was executed correctly. Let's click on Refresh. You can see that the data on here that's mean there is no error. It's also check the other functions because this is the last step. And just after we will compile and send the project. So our customer so We have to be sure that everything is working. Fine. So this sir, she is. Okay, So let's close. And now I can go back to our software, not a fighter. Easy. So we selected mean file and we can start by one directory. Okay. And we go directly to advise is up. So we need to add the main, don't you? I in the us that db we can add this week on also. And if you are using the resource, we have toe also the resource. Fine. So that's it. Ah, this is the fights. And here we put just one dot If all the files are located in the root directory Ah, which is the main that actually. And if they are located in some supporters, we can just all right. Name of the sub folder like this, for example, if what? He was in data and we click on, Call it by too easy. So now he is compiling. Okay, that's good. Can open the output folder and we would see that there is a new folder called Invented a monitor that Waas just created by the the software. You can open it and you will see that all the fires that are needed to execute our projects are just put inside. Andi is our executable. We can this now. So all right, click and click open. Andi, is it? It's working very well. That's mean. All the necessary files are there. Because if it gives some Errol, that's mean there is something missing. And, ah, according to my experience, sometimes it gives some error. So if it gives you some error, just let me a message and we will check what is wrong with your with your projects. So now it's ready so we can just complicit. And then it will be ready toe communicated to any customer to any friend ex cetera, even if they don't have Peyton installed Exeter. So this is really a standalone executable. Thank you very much. So this is the last point in our projects. Thank you for following this parts or discourse. And I hope to see you very soon. Thank you. Bye bye.