Join us on a literary world trip!
Add this book to bookshelf
Grey
Write a new comment Default profile 50px
Grey
Subscribe to read the full book or read the first pages for free!
All characters reduced
Learn SQLite with Python: Building Database-Driven Desktop Projects - cover

We are sorry! The publisher (or author) gave us the instruction to take down this book from our catalog. But please don't worry, you still have more than 500,000 other books you can enjoy!

Learn SQLite with Python: Building Database-Driven Desktop Projects

Vivian Siahaan, Rismon Hasiholan Sianipar

Publisher: SPARTA PUBLISHING

  • 0
  • 0
  • 0

Summary

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.
Available since: 11/19/2019.

Other books that might interest you

  • Sundaland: The History of the Asian Landmass that Started Sinking After the Ice Age - cover

    Sundaland: The History of the...

    Charles River Editors

    • 0
    • 0
    • 0
    By the time the Pleistocene Epoch ended around 12,000 years ago, Homo sapiens had become one of the most significant species on the planet. 	It was also near the end of that period of time that modern humans began to gradually populate what would become Europe, Asia, and the Americas, eventually becoming the inheritors of the Paleolithic era and the only human species to make it into the Neolithic era. The process was long and difficult, and the survival of the species only happened through a combination of human tenacity and a fair amount of luck. As much as humans evolved during the Pleistocene, the topography, geography, and environment changed even more. 
    The cold Pleistocene temperatures lowered water levels across the planet, exposing land that was not there before or after the period. At the same time, significant regions of the planet were very different during the Pleistocene, including Southeast Asia, particularly the modern islands of Bali, Borneo, Sumatra, and the Malay Peninsula, roughly equivalent to parts of Indonesia, Malaysia, Myanmar, and Thailand. This region, which modern scholars refer to as Sunda or Sundaland, was unique because all of it was connected by land, meaning today’s islands were once part of a contiguous subcontinent, and in terms of the people, flora, and fauna, it was very different than it is today. If a modern traveler could somehow transport back to the Pleistocene, Sundaland would look nothing like modern Southeast Asia and would resemble as much of a lost world as something out of a science fiction novel.  
    Although much is still unknown about Sundaland, researchers have uncovered plenty of evidence bringing this lost world to life. As anthropologists and archaeologists developed new models and discovered ancient material culture, they learned that Sundaland played a significant role in the development of Neolithic Southeast Asia in many ways. 
    Show book
  • Hypnosis - Stress Relief Weight Loss Deep Sleep and More - cover

    Hypnosis - Stress Relief Weight...

    Devon Hales

    • 0
    • 0
    • 0
    The following topics are included in this 2-book combo: 
      
      
    Book 1: Hypnosis and self-hypnosis have benefitted many people. Seeing that you have taken the initiative to look at this book, it’s safe to assume that you are intrigued by the possibilities it may offer. 
      
    Well, fear no longer, my friend, because a lot of ideas and techniques will be discussed in this brief book. You will learn, among others, about psychedelic dreams, the effects of hypnosis on fibromyalgia, what self-hypnosis can do, how you can stop procrastinating, reduce pain, or relieve stress. 
      
    Some of those subjects will be highlighted more than others, but I can promise you that you will most likely learn something new. 
      
      
      
      
    Book 2: How does hypnosis work? What is good for? And how can you be more effective at it? 
    These are questions that might come to mind when you study the topic of hypnosis. In this brief guide, we will address the ins and outs of what it is and how it is used. Additionally, we will look into how it can reduce labor pain, help children with their language skills or adults with forgotten languages, boost self-confidence, help with weight loss, and much more! 
    Learn more now, so you, too, can enter the realm of endless possibilities that pertain to hypnosis secrets of the universe.
    Show book
  • The Horse of My Heart - Stories of the Horses We Love - cover

    The Horse of My Heart - Stories...

    Callie Smith Grant

    • 0
    • 0
    • 0
    Few of God's creatures are as noble and soul-stirring as the horse. Even those of us who don't have horses of our own love to read inspiring stories of these beautiful, regal beasts.With contributions from well-known authors such as Lauraine Snelling, Susy Flory, Rebecca E. Ondov, Wanda Dyson, and Sarah Parshall Perry, these true stories of horses and the people who love them are sometimes touching, sometimes humorous, and sometimes miraculous. As she did in her dog and cat story collections, Callie Grant Smith has compiled another perfect read for animal lovers--time with horses as the subject.
    Show book
  • Nature - cover

    Nature

    Ralph Waldo Emerson

    • 0
    • 0
    • 0
    Nature is a short essay by Ralph Waldo Emerson published anonymously in 1836. It is in this essay that the foundation of transcendentalism is put forth, a belief system that espouses a non-traditional appreciation of nature. Recent advances in zoology, botany, and geology confirmed Emerson's intuitions about the intricate relationships of Nature at large. The publication of Nature is usually taken to be the watershed moment at which transcendentalism became a major cultural movement. Henry David Thoreau had read "Nature" as a senior at Harvard College and took it to heart. It eventually became an essential influence for Thoreau's later writings, including his seminal Walden. (Summary excerpted from Wikipedia by Neeru Iyer)
    Show book
  • The Nature of Plants - An Introduction to How Plants Work - cover

    The Nature of Plants - An...

    Craig N. Huegel

    • 0
    • 0
    • 0
    Plants play a critical role in how we experience our environment. They create calming green spaces, provide oxygen for us to breathe, and nourish our senses. In The Nature of Plants, ecologist and nursery owner Craig Huegel demystifies the complex lives of plants and provides listeners with an extensive tour into their workings.Beginning with the importance of light, water, and soil, Huegel describes the process of photosynthesis and how best to position plants to receive optimal sunlight. He explains why plants suffer from overwatering, what essential elements plants need to flourish, and what important soil organisms reside with them. Listeners will understand the difference between friendly and hostile bacteria, fungi, and insects.Sections on plant structure and reproduction focus in detail on major plant organs—roots, stems, and leaves—and cover flowering, pollination, fruit development, and seed germination. Huegel even delves into the mysterious world of plant communication, exploring the messages conveyed to animals or other plants through chemical scents and hormones.
    Show book
  • Diabetes - A History of Race & Disease - cover

    Diabetes - A History of Race &...

    Arleen Marcia Tuchman

    • 0
    • 0
    • 0
    Who is considered most at risk for diabetes, and why? In this thorough, engaging book, historian Arleen Tuchman examines and critiques how these questions have been answered by both the public and medical communities for over a century in the United States.Beginning in the late nineteenth century, Tuchman describes how at different times Jews, middle class whites, American Indians, African Americans, and Hispanic Americans have been labeled most at risk for developing diabetes, and that such claims have reflected and perpetuated troubling assumptions about race, ethnicity, and class. She describes how diabetes underwent a mid-century transformation in the public's eye from being a disease of wealth and "civilization" to one of poverty and "primitive" populations.In tracing this cultural history, Tuchman argues that shifting understandings of diabetes reveal just as much about scientific and medical beliefs as they do about the cultural, racial, and economic milieus of their time.
    Show book