- Pastikan sudah mengintal package libmysqlclient-dev dengan:
apt-get install libmysqlclient-dev - DOwnload modul MySQLdb. DOwnload dari sini
- Instal modul tersebut dengan cara (Pastikan login sebagai root ya):
$ gunzip MySQL-python-1.2.2.tar.gz $ tar -xvf MySQL-python-1.2.2.tar $ cd MySQL-python-1.2.2 $ python setup.py build $ python setup.py install
- Coba deh buat satu script seperti berikut (contoh: test.py):
import MySQLdb # Open database connection db = MySQLdb.connect("localhost","root","password","nama_database" ) # prepare a cursor object using cursor() method cursor = db.cursor() # execute SQL query using execute() method. cursor.execute("SELECT VERSION()") # Fetch a single row using fetchone() method. data = cursor.fetchone() print "Database version : %s " % data # disconnect from server db.close()
- Terus test deh...
python test.py
Hasilnyaaaaaaaaa
root@mawaddah-Aspire-4750:/home/mawaddah# python test.py
Database version : 5.1.66-0ubuntu0.11.10.3
Selesai dehhhh
referensi: http://www.tutorialspoint.com/python/python_database_access.htm
assalam alaikum bu jika Odoo menggunakan database sql server bisa ndak ya? maturnuwun
BalasHapus