Learn SQLite with Python: Building Database-Driven Desktop Projects

Vivian Siahaan, Rismon Hasiholan Sianipar

Beschreibung

This book is SQLite-based python programming for database-driven desktop projects. Deliberately designed for various levels of programming skill, this book is suitable for students, engineers, and even researchers in various disciplines. There is no need for advanced programming experience, and school-level programming skills are needed.
In the first chapter, you will learn to use several widgets in PyQt5: Display a welcome message; Use the Radio Button widget; Grouping radio buttons; Displays options in the form of a check box; and Display two groups of check boxes.
In chapter two, you will learn to use the following topics: Using Signal / Slot Editor; Copy and place text from one Line Edit widget to another; Convert data types and make a simple calculator; Use the Spin Box widget; Use scrollbars and sliders; Using the Widget List; Select a number of list items from one Widget List and display them on another Widget List widget; Add items to the Widget List; Perform operations on the Widget List; Use the Combo Box widget; Displays data selected by the user from the Calendar Widget; Creating a hotel reservation application; and Display tabular data using Table Widgets.
In chapter three, you will learn: How to create the initial three tables project in the School database: Teacher, Class, and Subject tables; How to create database configuration files; How to create a Python GUI for inserting and editing tables; How to create a Python GUI to join and query the three tables.
In chapter four, you will learn how to: Create a main form to connect all forms; Create a project will add three more tables to the school database: Student, Parent, and Tuition tables; Create a Python GUI for inserting and editing tables; Create a Python GUI to join and query over the three tables.
In chapter five, you will join the six classes, Teacher, TClass, Subject, Student, Parent, and Tuition and make queries over those tables.
In chapter six, you will create dan configure database. In this chapter, you will create Suspect table in crime database. This table has eleven columns: suspect_id (primary key), suspect_name, birth_date, case_date, report_date, suspect_ status, arrest_date, mother_name, address, telephone, and photo. You will also create GUI to display, edit, insert, and delete for this table.
In chapter seven, you will create a table with the name Feature_Extraction, which has eight columns: feature_id (primary key), suspect_id (foreign key), feature1, feature2, feature3, feature4, feature5, and feature6. The six fields (except keys) will have VARBINARY(MAX) data type. You will also create GUI to display, edit, insert, and delete for this table.

Verfügbar seit: 19.11.2019.

Wissenschaft & Technologie

Weitere Bücher, die Sie mögen werden

Seaforth World Naval Review 2018

Conrad Waters

The yearly military reference that’s “a well written, easy to read and well illustrated discussion of current naval power world-wide”—Thomo’s Hole.   Now firmly established as an authoritative but affordable summary of all that has happened in the naval world in the previous twelve months, this annual combines regional surveys with one-off major articles on noteworthy new ships and other important developments. Besides the latest warship projects, it also looks at wider issues of importance to navies, such as aviation and weaponry, and calls on expertise from around the globe to give a balanced picture of what is going on and to interpret its significance.   Features of this edition include an analysis of the Republic of Korea Navy and the response to its aggressive northern neighbor. Significant Ships will cover the USN’s revamped Arleigh Burke class destroyer design, German F125 class frigates, and the RNZN’s Otago class offshore patrol vessels. There are also technological reviews dealing with naval aviation by David Hobbs, RN missile programs by Richard Scott, while Norman Friedman turns his attention to new generation weapons technology.  The World Naval Review is intended to make interesting reading as well as providing authoritative reference, so there is a strong visual emphasis, including specially commissioned drawings and the most up-to-date photographs and artists’ impressions. For anyone with an interest in contemporary naval affairs, whether an enthusiast or a defense professional, this annual has become required reading.

Zum Buch

The Immune Mystery - A Doctor's...

Dr. Anita Kåss, Jørgen Jelstad

The Immune Mystery follows doctor and researcher Anita Kåss's quest to solve the autoimmune puzzle, beginning with the premature death of her mother, who developed rheumatoid arthritis shortly after giving birth to Anita. As a child, Anita vowed to study the illness and one day find a cure.Becoming a respected doctor and researcher, Anita devoted herself to studying auto-immune disorders like rheumatoid arthritis, lupus, and multiple sclerosis. Why do so many autoimmune diseases start to show symptoms during and after childbirth, perimenopause, and menopause? Could autoimmune diseases be linked to our changing hormones?Despite the groundbreaking nature of her research, Anita had to fight for her ideas against the conventional wisdom and casual sexism of the medical industry—even as she made a discovery that earned her a record-breaking US$95 million pharmaceutical deal.A compelling blend of incredible determination and cutting-edge science, The Immune Mystery changes the way we think about autoimmune diseases. Anita offers solace to patients struggling with questions about their health, and introduces a powerful new voice in medical storytelling.

Zum Buch

Engage Connect Protect -...

Angelou Ezeilo, Nick Chiles

Building environmental strength through a diversity of youth  
Engage, Connect, Protect explodes the myth that environmental issues are primarily of interest to wealthy white communities.     
Revealing the deep and abiding interest that African American, Latino, and Native American communities—many of whom live in degraded and polluted parts of the country—have in our collective environment, Engage, Connect, Protect is part eye-opening critique of the cultural divide in environmentalism, part biography of a leading social entrepreneur, and part practical toolkit for engaging diverse youth. It covers:   Why communities of color are largely unrecognized in the environmental movement   How to bridge the cultural divide and activate a new generation of environmental stewards   A curriculum for engaging diverse youth and young adults through culturally appropriate methods and activities   Resources for connecting mainstream America to organizations working with diverse youth within environmental projects, training, and employment.  
Engage, Connect, Protect is a wake-up call for businesses, activists, educators, and policymakers to recognize the work of grassroots activists in diverse communities and create opportunities for engaging with diverse youth as the next generation of environmental stewards, while the concern about the state of our land, air, and water continues to grow.

Zum Buch

NFT for Beginners: An Essential...

Donn Newman

If you’re confused about the recent surge of Crypto art and want to learn more about NFTs and their market, look no further! 
Have you ever wondered what the deal is with crypto art? 
Ever heard the term NFT and wondered what that could possibly mean? 
Do you feel intimidated by this new technology, more so because you’re barely struggling to understand Bitcoin and Ethereum? 
Are you a creative person looking to get into the crypto art scene? 
Then this audiobook is just what you need. 
Within this audiobook, you will:Learn what an NFT isDiscover the implications of non-fungibility and how you can take advantage of itLearn how the blockchain works and why it makes NFTs possibleUnderstand the importance of Ethereum to all things NFT relatedLearn how to create your very own NFTsUnderstand the dos and don’ts when it comes to making smart investment decisionsDiscover the best sites to list, buy, and sell your NFTSLearn all about these tokens’ real-world applications and how they’re revolutionizing industriesDiscover how smart contracts work to keep you safeLearn about the very real risks of trading NFTs and how to be safe with themDiscover the most successful Crypto artworks to inspire your next one or next investment 
Using this audiobook as a launching pad, you can understand everything you need to know to take advantage of the next big thing – possibly bigger than Bitcoin – and that’s saying something! 
So, click the “add to cart” button now and get ready to ride the wave of NFTs into the future.

Zum Buch

The Invention of Surgery - A...

David Schneider M.D.

Written by an author with plenty of experience holding a scalpel, Dr. David Schneider’s in-depth biography is an encompassing history of the practice that has leapt forward over the centuries from the dangerous guesswork of ancient Greek physicians through the world-changing “implant revolution” of the twentieth century. The Invention of Surgery explains this dramatic progress and highlights the personalities of the discipline's most dynamic historical figures. It links together the lives of the pioneering scientists who first understood what causes disease, how organs become infected or cancerous, and how surgery could powerfully intercede in people’s lives, and then shows how the rise of surgery intersected with many of the greatest medical breakthroughs of the last century, including the evolution of medical education, the transformation of the hospital from a place of dying to a habitation of healing, the development of antibiotics, and the rise of transistors and polymer science. And as Schneider argues, surgery has not finished transforming; new technologies are constantly reinventing both the practice of surgery and the nature of the objects we are permanently implanting in our bodies. Schneider considers these latest developments, asking “What’s next?” and analyzing how our conception of surgery has changed alongside our evolving ideas of medicine, technology, and our bodies.

Zum Buch

The Big Book of Nature...

Drew Monkman, Jacob Rodenburg

“A wealth of ideas for adults to engage children and themselves in the wonders of the natural world with suggested activities for all seasons.”―Robert Bateman, artist and author of Life Sketches: A Memoir  The Big Book of Nature Activities is a comprehensive guide for parents and educators to help youth of all ages explore, appreciate, and connect with the natural world. This rich, fully illustrated compendium is packed with crafts, stories, information, and inspiration to make outdoor learning fun!  The Big Book of Nature Activities features: ·       Nature-based skills and activities such as species identification, photography, journaling, and the judicious use of digital technology ·       Ideas, games, and activities grounded in what’s happening in nature each season ·       Core concepts that promote environmental literacy, such as climate change and the mechanisms and wonder of evolution, explained using a child-friendly, engaging approach ·       Lists of key species and happenings to observe throughout the year across most of North America

Zum Buch