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:
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:
Other than that, the lists of data warehouse database systems are:
There are other non-relational categories of databases. These are:
Native Python databases are:
What Database API Includes
Using Python structure, DB-API provides standard and support for working with databases. The API consists of:
Benefits Of Python Database Programming
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.
Environment Variables | Description |
---|---|
INSERT | It is an SQL statement used to create a record into table. |
READ | Fetches useful information from database. |
UPDATE | It is used update those available or already existing record(s). |
DELETE | It is used to delete records from database. |
ROLLBACK | It works like “un do”, which reverts back all the changes that you have made. |
Comments
Post a Comment