LEADER 05055nam 22005773u 450 001 9910458094203321 005 20210108022705.0 010 $a1-84951-019-9 035 $a(CKB)2560000000054792 035 $a(EBL)1336390 035 $a(CaSebORM)9781849510189 035 $a(MiAaPQ)EBC1336390 035 $a(EXLCZ)992560000000054792 100 $a20130819d2010|||| u|| | 101 0 $aeng 135 $aur|n|---||||| 181 $ctxt$2rdacontent 182 $cc$2rdamedia 183 $acr$2rdacarrier 200 10$aMySQL for Python$b[electronic resource] $eDatabase Access Made Easy 205 $a1st edition 210 $aBirmingham $cPackt Publishing$d2010 215 $a1 online resource (440 p.) 225 1 $aCommunity experience distilled 300 $aDescription based upon print version of record. 311 $a1-84951-018-0 327 $aCover; Copyright; Credits; About the Author; About the Reviewers; Table of Contents; Preface; Chapter 1: Getting Up and Running with MySQL for Python; Getting MySQL for Python; Using a package manager (only on Linux); Using RPMs and yum; Using RPMs and urpm; Using apt tools on Debian-like systems; Using an installer for Windows; Using an egg file; Using a tarball (tar.gz file); Importing MySQL for Python; Accessing online help when you need it; MySQLdb; _mysql; Connecting with a database; Creating a connection object; Creating a cursor object; Interacting with the database 327 $aClosing the connectionMultiple database connections; Summary; Chapter 2: Simple Querying; A brief introduction to CRUD; Forming a query in MySQL; SELECT; * (asterisk); FROM; staff; ; (semicolon); Other helpful quantifiers; WHERE; GROUP BY; HAVING; ORDER BY; LIMIT; INTO OUTFILE; Passing a query to MySQL; A simple SELECT statement; Modifying the results; Using user-defined variables; Determining characteristics of a database and its tables; Determining what tables exist; Assigning each table a number; Offering the options to the user; Allowing the user to detail a search query 327 $aChanging queries dynamicallyPattern matching in MySQL queries; Putting it into practice; Project: a command-line search utility; Preparing a database for searching; Planning your work, then working your plan; Develop a well-abstracted search functionality.; Specifying the search term from the command-line; Implementing and incorporating the other functions: -t, -f, and -o; Including an option for an output file; Room to grow; Summary; Chapter 3: Simple Insertion; Forming a MySQL insertion statement; INSERT; INTO; Table name; Column names; VALUES; ; ; (semicolon) 327 $aHelpful ways to nuance an INSERT statementINSERT...SELECT...; INSERT DELAYED...; INSERT...ON DUPLICATE KEY UPDATE...; Passing an insertion through MySQL for Python; Setting up the preliminaries; A simple INSERT statement; More complex INSERT commands; Using user-defined variables; Using metadata; Querying the database for its structure; Retrieving the table structure; Changing insertion values dynamically; Validating the value of name; Validating the value of price; Querying the user for a correction; Passing fish and price for validation; Essentials: close and commit; In need of some closure 327 $aWhat happened to commit?Why are these essentials non-essential?; Project: a command-line insertion utility; The necessary modules; The main() thing; Coding the flag system; Testing the values passed by the user; Try to establish a database connection; Showing the tables; Showing the table structure, if desired; Accepting user input for the INSERT statement; Building the INSERT statement from the user input and execute it; Committing changes and closing the connection; Coding the other functions; valid_digit() and valid_string(); valid_table(); query(); Calling main(); Room to grow; Summary 327 $aChapter 4: Exception Handling 330 $aThis is a practical, tutorial-style book that includes many examples to demonstrate the full potential of MySQL for Python. Every chapter starts with an explanation of the various areas for using MySQL for Python and ends with work on a sample application using the programming calls just learned. All complicated concepts are broken down to be very easy to understand. Everything in the book is designed to help you learn and use MySQL for Python to address your programming needs in the fastest way possible. This book is meant for intermediate users of Python who want hassle-free access to their 606 $aInternet programming 606 $aWeb sites -- Design 606 $aWeb sites 608 $aElectronic books. 615 4$aInternet programming. 615 4$aWeb sites -- Design. 615 4$aWeb sites. 676 $a005.2 676 $a005.2/76 676 $a005.7585 700 $aLukaszewski$b Albert$0927094 801 0$bAU-PeEL 801 1$bAU-PeEL 801 2$bAU-PeEL 906 $aBOOK 912 $a9910458094203321 996 $aMySQL for Python$92082934 997 $aUNINA LEADER 03170nam1 22004813i 450 001 RML0467193 005 20231121125803.0 100 $a20210209g19551971||||0itac50 ba 101 | $aita 102 $ait 181 1$6z01$ai $bxxxe 182 1$6z01$an 200 1 $a˜[œOpuscola$evol. 1.$fEmilio Gabba$ga cura di Luigi Moretti] 210 $a[S.l.$csn.$d1955-1971] 215 $a1 volume ( paginazione varia)$d28 cm 300 $aEstratti raccolti e rilegati a cura del professor Luigi Moretti. 464 0$1001RML0467194$12001 $aNote appiane$fEmilio Gabba$v1$1700 1$aGabba$b, Emilio$3CFIV021967$4070 464 0$1001RML0467195$12001 $aSulla Storia romana di Cassio Dione$fEmilio Gabba$v2$1700 1$aGabba$b, Emilio$3CFIV021967$4070 464 0$1001RML0467199$12001 $a˜Il œceto equestre e il senato di Silla$fEmilio Gabba$v3$1700 1$aGabba$b, Emilio$3CFIV021967$4070 464 0$1001RML0467200$12001 $aEpigrafe di un console del 3. secolo d.C.$fEmilio Gabba$v4$1700 1$aGabba$b, Emilio$3CFIV021967$4070 464 0$1001RML0467207$12001 $aProspero Mérimée storico di Roma$fEmilio Gabba $v5$1700 1$aGabba$b, Emilio$3CFIV021967$4070 464 0$1001RML0467246$12001 $aStudi su Filarco$ele biografie plutarchee di Agide e di Cleomene$fEmilio Gabba$v6$1700 1$aGabba$b, Emilio$3CFIV021967$4070 464 0$1001RML0467247$12001 $aStudi su Dionigi da Alicarnasso$fEmilio Gabba$v7$1700 1$aGabba$b, Emilio$3CFIV021967$4070 464 0$1001RML0467248$12001 $aSenati in esilio$fEmilio Gabba$v8$1700 1$aGabba$b, Emilio$3CFIV021967$4070 464 0$1001RML0467250$12001 $a˜Il œlatino come dialetto greco$fEmilio Gabba$v9$1700 1$aGabba$b, Emilio$3CFIV021967$4070 464 0$1001RML0467252$12001 $aM. Livio Druso e le riforme di Silla$fEmilio Gabba$v10$1700 1$aGabba$b, Emilio$3CFIV021967$4070 464 0$1001RML0467253$12001 $a˜I œfalsi stati del De Re publica di Cicerone$fEmilio Gabba$v11$1700 1$aGabba$b, Emilio$3CFIV021967$4070 464 0$1001RML0467256$12001 $a˜Lo œsvolgimento militare della guerra di Perugia$fEmilio Gabba$v12$1700 1$aGabba$b, Emilio$3CFIV021967$4070 464 0$1001RML0467259$12001 $aAspetti della lotta in Spagna di Sesto Pompeo$fEmilio Gabba$v13$1700 1$aGabba$b, Emilio$3CFIV021967$4070 464 0$1001RML0467261$12001 $aCommento a Floro, 2., 9,27-28$fEmilio Gabba$v14$1700 1$aGabba$b, Emilio$3CFIV021967$4070 464 0$1001RML0467262$12001 $a˜The œperusine war and triumviral Italy$fEmilio Gabba$v15$1700 1$aGabba$b, Emilio$3CFIV021967$4070 464 0$1001RML0467263$12001 $aAppiano traduttore in B.C., 5. 191$fEmilio Gabba$v16$1700 1$aGabba$b, Emilio$3CFIV021967$4070 700 1$aGabba$b, Emilio$3CFIV021967$4070$0135312 702 1$aMoretti$b, Luigi$f <1922-1991>$3CFIV029124$4340 801 3$aIT$bIT-01$c20210209 850 $aIT-FR0017 899 $aBiblioteca umanistica Giorgio Aprea$bFR0017 $eN 912 $aRML0467193 950 1$aBiblioteca umanistica Giorgio Aprea$d 52DLM OPU /GAB /1$e 52DUP0009050105 VMB RS $fC $h20210211$i20210211 967 $n16 977 $a 52 996 $aOpuscola$93634198 997 $aUNICAS