Skip to main content

Python Database Connection

Python Database Connection

Programmers might expect that Python may make database programming simpler and a painless job, the Python database API supply with database-neutral programming interface for different databases.
These are:
  • MySQL
  • SQLite
  • MS SQL
  • PostgreSQL
  • Informix
  • Sybase
  • Inter-base
  • Oracle etc….
The DB-API is the standard for Python’s database interface.

What Is Database?

Database in a collection of organized information that can easily be used, managed, update and they are classified according to their organizational approach.
The Python Database interfaces are categorized into two. These are:

Generic Database Interface

Most Python’s database interface remains to Python’s DB-API standardand most of the databases have ODBC support. Other than that Java database usually support JDBC and programmers can work with that from Jython.

Relational Database system Interface

This employs relational model with support of SQL.  Lists of general-purpose database systems are:
  1. Firebird
  2. Informix
  3. SAP db
  4. MS SQL server
  5. Access
  6. Ingres
  7. MySQL etc….
Other than that, the lists of data warehouse database systems are:
  1. Teradata
  2. IBM Netezza
There are other non-relational categories of databases. These are:
  • Record-based databases
  • XML databases
  • Graph databases
Native Python databases are:
  • SnakeSQL
  • Buzhug

What Database API Includes

Using Python structure, DB-API provides standard and support for working with databases. The API consists of:
  • Bring in the API module
  • Obtain database connection
  • Issue SQL statements and then store procedures
  • Close the connection

Benefits Of Python Database Programming

  • Programming in Python is considerably simple and efficient with compared to other language, so as the database programming
  • Python database are portable and the program is also portable so both can give advantage in case of portability
  • Python supports SQL cursors
  • It also supports Relational Database systems
  • The API of Python for database is compatible with other databases also
  • It is platform independent

Defining MySQL Database

It is an interface for associating SQL database server from Python and uses the DB-API of Python to work.

How To Implement MySQL Database

To use MySQL database using Python, you need to first install it on your machine; then just type the script given below to implement MySQL within your program.
import MySQLdb
If any error occurs then it means that the MySQL module is not installed and programmers can download it from –  https://sourceforge.net/projects/mysql-python/

Database Program Using Python

#!/usr/bin/python

# importing the module
import MySQLdb

# opening a database connection
db
= MySQLdb.connect ("localhost","testprog","stud","PYDB")

# define a cursor object
cursor
= conn.cursor

# drop table if exists
Cursor.execute("IF STUDENT TABLE EXISTS DROP IT")

# query
sql
= "CREATE TABLE STUDENT (
NAME CHAR(30) NOT NULL,
CLASS CHAR(5),
AGE INT,
GENDER CHAR(8),

MARKS INT"


# execute query
cursor
.execute(sql)

# close object
cursor
.close()

# close connection
conn
.close()

Database Operations

There are various operations that programmers can perform within Python program. To deal with these statements you must have a good knowledge of Database programming and SQL.
Database Operations
Environment VariablesDescription
INSERTIt is an SQL statement used to create a record into table.
READFetches useful information from database.
UPDATEIt is used update those available or already existing record(s).
DELETEIt is used to delete records from database.
ROLLBACKIt works like “un do”, which reverts back all the changes that you have made.

Comments

For Programs Click Here

Popular posts from this blog

Python Lists

Python Lists Dealing with data in a structured format is quiet generous, and this is possible if those data are set accordingly in a specific manner. So, Python provides these data structures named ‘lists’ and ‘tuples’ that are used to organize data in  single set. Python has 6 built-in sequences and among them the most famous are “lists and tuples”. The lists are containers that hold a number of other objects in a given order. It usually puts into practice the sequence protocol and allows programmers to add or remove objects from that sequence. Each element of the sequence is assigned a number i.e. he index and the first index is 0 (zero). This versatile data-type of Python is written in a sequence of list separated by commas between expressions. Creating Lists To build a list, just put a number of expressions in square brackets. The syntax is: Syntax: lst1 = [ ] # lst1 is the name of the list lst2 = [ expression1 , …. , expression_N ] Example: #!/usr/bin/python ls...

Syllabus

Syllabus  C Programming Tutorials C Tutorial C Introduction History of C Programming Language C Installation C Program Structure C Input and Output (I/O) C Format Specifiers Declaration & Assignments C Tokens C Identifiers C Keywords C Constants C Operators C Data Types C Variables C Preprocessors C Type Casting C Custom Header File Flow Control C Decision Making C if Statements C if-else Statements C Nested if-else Statements C else-if Statements C goto Statement C switch Statements C Loops C while loops C do while loops C for loops Functions C Functions C Function Arguments C Library Functions C Variable Scope Arrays & Strings C Arrays C Strings Pointers C Pointers C Dynamic Memory Allocation Structure & Union C Structures C Unions File I/O C File Handling C fopen C fclose C getc C putc C getw C putw C fprintf C fscanf C fgets C fputs C feof                                     ...

C++ Overloading

C++ Overloading C++ language allows programmers to specify more than one definition for a function name or an operator. This is one of the many exciting features that Object Oriented Language offers programmers. It is one of the important techniques that has extended the power and flexibility of C++. In this chapter you will learn about the types of overloading and how they are used within a C++ program. What is Overloading? Overloading is the technique to use a single identifier to define various methods or techniques of a class that differ in their input and output parameters. The concept of overloading is generally used when a program block conceptually execute the same task but with a slight distinctness in set of parameters. Overloading is a concept used to avoid redundant code where the same method name or operator is used multiple times but with a different set of parameters or number of operands. The actual method that gets called during runtime is resolved at compile time, thu...