import MySQLdb
import MySQLdb.cursors
from hakoblog.config import CONFIG


class DB():
    def __init__(self):
        self.conn = MySQLdb.connect(
            db=CONFIG.DATABASE,
            host=CONFIG.DATABASE_HOST,
            user=CONFIG.DATABASE_USER,
            password=CONFIG.DATABASE_PASS,
            cursorclass=MySQLdb.cursors.DictCursor,
        )
        self.conn.autocommit(True)

    def cursor(self):
        return self.conn.cursor()

    def close(self):
        self.conn.close()

    def uuid_short(self):
        with self.conn.cursor() as cursor:
            cursor.execute('SELECT UUID_SHORT() as uuid')
            return cursor.fetchone().get('uuid')

import MySQLdb
import MySQLdb.cursors
from hakoblog.config import CONFIG


class DB():
    def __init__(self):
        self.conn = MySQLdb.connect(
            db=CONFIG.DATABASE,
            host=CONFIG.DATABASE_HOST,
            user=CONFIG.DATABASE_USER,
            password=CONFIG.DATABASE_PASS,
            cursorclass=MySQLdb.cursors.DictCursor,
            charset='utf-8',
        )
        self.conn.autocommit(True)

    def cursor(self):
        return self.conn.cursor()

    def close(self):
        self.conn.close()

    def uuid_short(self):
        with self.conn.cursor() as cursor:
            cursor.execute('SELECT UUID_SHORT() as uuid')
            return cursor.fetchone().get('uuid')

Add charset to connect mysql
Add charset to connect mysql

  import MySQLdb
  import MySQLdb.cursors
  from hakoblog.config import CONFIG
  
  
  class DB():
      def __init__(self):
          self.conn = MySQLdb.connect(
              db=CONFIG.DATABASE,
              host=CONFIG.DATABASE_HOST,
              user=CONFIG.DATABASE_USER,
              password=CONFIG.DATABASE_PASS,
              cursorclass=MySQLdb.cursors.DictCursor,
+             charset='utf-8',
          )
          self.conn.autocommit(True)
  
      def cursor(self):
          return self.conn.cursor()
  
      def close(self):
          self.conn.close()
  
      def uuid_short(self):
          with self.conn.cursor() as cursor:
              cursor.execute('SELECT UUID_SHORT() as uuid')
              return cursor.fetchone().get('uuid')
  
Add charset to connect mysql
## Code Before:
import MySQLdb
import MySQLdb.cursors
from hakoblog.config import CONFIG


class DB():
    def __init__(self):
        self.conn = MySQLdb.connect(
            db=CONFIG.DATABASE,
            host=CONFIG.DATABASE_HOST,
            user=CONFIG.DATABASE_USER,
            password=CONFIG.DATABASE_PASS,
            cursorclass=MySQLdb.cursors.DictCursor,
        )
        self.conn.autocommit(True)

    def cursor(self):
        return self.conn.cursor()

    def close(self):
        self.conn.close()

    def uuid_short(self):
        with self.conn.cursor() as cursor:
            cursor.execute('SELECT UUID_SHORT() as uuid')
            return cursor.fetchone().get('uuid')

## Instruction:
Add charset to connect mysql
## Code After:
import MySQLdb
import MySQLdb.cursors
from hakoblog.config import CONFIG


class DB():
    def __init__(self):
        self.conn = MySQLdb.connect(
            db=CONFIG.DATABASE,
            host=CONFIG.DATABASE_HOST,
            user=CONFIG.DATABASE_USER,
            password=CONFIG.DATABASE_PASS,
            cursorclass=MySQLdb.cursors.DictCursor,
            charset='utf-8',
        )
        self.conn.autocommit(True)

    def cursor(self):
        return self.conn.cursor()

    def close(self):
        self.conn.close()

    def uuid_short(self):
        with self.conn.cursor() as cursor:
            cursor.execute('SELECT UUID_SHORT() as uuid')
            return cursor.fetchone().get('uuid')
