(★ Dяea Tutorials ★ )-==-[ DataBases in Python ]-==-(★Tutorial no.1★)

Intro

Well boys and girls, i searched python forum to see what if someone post a Tut about databases in python and i got 0, all i got are questions, so i though of making a Tutorial about making databases in python.

What is the Database?

Spoiler (Click to View)

Database is a collection of well formed and organized data that u can use and make good things.

For more Info: Wiki

[Image: Line_2.png]

Databases in Python:

There are many ways to use Databases in python, like using it through Oracle, MySQL ... etc. But in this tutorial I'll use MySQL to make Databases.

Installing MySQL:

Check this website it's for Python 2.7 Download Link

Make Your First Python Database:

First we must import the sqlite module

Code:
import sqlite3

To create a database insert the next line

Code:
CreateDB = sqlite3.connect('Py_Database.db')

At the above code you can replace the name of the database with this :memory: to make this DB in the memory and delete itself after finishing the program.
it's like a temporary DB.

Code:
CreateDB = sqlite3.connect(':memory:')

By this step you have created a database check the working folder and you will find it Thumbsup

.

Creating a Table

Now after creating the database it's the time to add info to the database, first we must create table to save data

To execute commands or to talk with the database we have to set the cursor so we can do this

Code:
curs = CreateDB.cursor()

After defining the curs variable at previous step we enter the following

Code:
curs.execute(''' CREATE TABLE accounts (id INTEGER PRIMARY KEY, account TEXT, pass TEXT, info TEXT) ''')

well, in this step we created table with the name 'accounts' then we defined the information we will add to the table in the DB, first we define something like a serial for the data in the table then we define the other information which is in this case, the account then the password for the account and info, and we followed each definition with the type of it whether it's TEXT or INTEGER or REAL ..etc - in this tutorial i make some basic program to save passwords for my accounts as example Confused

mile:.

Add Info to Table

Now we created the database and the table to add data to it, now we add the data, to add data to the database we should choose what table to add data to, then we add the data.

Code:
curs.execute('''INSERT INTO accounts (account, pass, info) VALUES (?,?,?)''',('email@mailengine.com', 'password', 'other info about the account')

Note: the (?,?,?) like using the parameters in function the ? is the parameter and the followed () with values inside i hope u got it Rolleyes

.

The next command is to make the database apply all changes we made here

Code:
createDB.commit()

By this step we are done with creating the database and adding data to it Thumbsup