iPythonn Notebook code

Learning python to interact with mysql database

{
 "metadata": {
  "name": "Playing with MySql"
 },
 "nbformat": 3,
 "nbformat_minor": 0,
 "worksheets": [
  {
   "cells": [
    {
     "cell_type": "markdown",
     "metadata": {},
     "source": "Using library mysql-python (MySQLdb)\n------------------------------------"
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": "import MySQLdb",
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 25
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": "db = MySQLdb.connect('localhost', 'user', 'password', 'text', charset='utf8', use_unicode=False)",
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 26
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": "# db.set_character_set('utf8')",
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 27
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": "cursor = db.cursor()",
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 28
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": "# cursor.execute('SET NAMES utf8')",
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 29
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": "cursor.execute('SET CHARACTER SET utf8')",
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "output_type": "pyout",
       "prompt_number": 30,
       "text": "0L"
      }
     ],
     "prompt_number": 30
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": "cursor.execute('SET CHARACTER_SET_CONNECTION=utf8')",
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "output_type": "pyout",
       "prompt_number": 31,
       "text": "0L"
      }
     ],
     "prompt_number": 31
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": "cursor.execute('SELECT title, body FROM text LIMIT 5') ",
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "output_type": "pyout",
       "prompt_number": 32,
       "text": "2L"
      }
     ],
     "prompt_number": 32
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": "result=cursor.fetchall()",
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 33
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": "i = 0\nfor element in result:\n    for item in element:\n        print \"item: [\",i,\"]\", item.format(*item)\n        i += 1\n          ",
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "output_type": "stream",
       "stream": "stdout",
       "text": "item: [ 0 ] F\u00f6rsta rubriken\nitem: [ 1 ] H\u00e4r \u00e4r lite text p\u00e5 svenska\nitem: [ 2 ] Andra rubriken\nitem: [ 3 ] Ytterligare lite text p\u00e5 ett annat spr\u00e5k\n"
      }
     ],
     "prompt_number": 60
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": "",
     "language": "python",
     "metadata": {},
     "outputs": []
    }
   ],
   "metadata": {}
  }
 ]
}