'''
$ mysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 211
Server version: 5.6.15 Homebrew

Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> create database luigi;
Query OK, 1 row affected (0.00 sec)
'''

import mysql.connector
from luigi.contrib.mysqldb import MySqlTarget
import unittest

host = 'localhost'
port = 3306
database = 'luigi_test'
username = None
password = None
table_updates = 'table_updates'


def _create_test_database():
    con = mysql.connector.connect(user=username,
                                  password=password,
                                  host=host,
                                  port=port,
                                  autocommit=True)
    con.cursor().execute('CREATE DATABASE IF NOT EXISTS %s' % database)


_create_test_database()
target = MySqlTarget(host, database, username, password, '', 'update_id')


class MySqlTargetTest(unittest.TestCase):
    def test_touch_and_exists(self):
        drop()
        self.assertFalse(target.exists(),
                         'Target should not exist before touching it')
        target.touch()
        self.assertTrue(target.exists(),
                        'Target should exist after touching it')


def drop():
    con = target.connect(autocommit=True)
    con.cursor().execute('DROP TABLE IF EXISTS %s' % table_updates)

import mysql.connector
from luigi.contrib.mysqldb import MySqlTarget
import unittest

host = 'localhost'
port = 3306
database = 'luigi_test'
username = None
password = None
table_updates = 'table_updates'


def _create_test_database():
    con = mysql.connector.connect(user=username,
                                  password=password,
                                  host=host,
                                  port=port,
                                  autocommit=True)
    con.cursor().execute('CREATE DATABASE IF NOT EXISTS %s' % database)


_create_test_database()
target = MySqlTarget(host, database, username, password, '', 'update_id')


class MySqlTargetTest(unittest.TestCase):
    def test_touch_and_exists(self):
        drop()
        self.assertFalse(target.exists(),
                         'Target should not exist before touching it')
        target.touch()
        self.assertTrue(target.exists(),
                        'Target should exist after touching it')


def drop():
    con = target.connect(autocommit=True)
    con.cursor().execute('DROP TABLE IF EXISTS %s' % table_updates)

Remove the doc that describes the setup. Setup is automated now
Remove the doc that describes the setup. Setup is automated now

- '''
- $ mysql
- Welcome to the MySQL monitor.  Commands end with ; or \g.
- Your MySQL connection id is 211
- Server version: 5.6.15 Homebrew
- 
- Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.
- 
- Oracle is a registered trademark of Oracle Corporation and/or its
- affiliates. Other names may be trademarks of their respective
- owners.
- 
- Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
- 
- mysql> create database luigi;
- Query OK, 1 row affected (0.00 sec)
- '''
- 
  import mysql.connector
  from luigi.contrib.mysqldb import MySqlTarget
  import unittest
  
  host = 'localhost'
  port = 3306
  database = 'luigi_test'
  username = None
  password = None
  table_updates = 'table_updates'
  
  
  def _create_test_database():
      con = mysql.connector.connect(user=username,
                                    password=password,
                                    host=host,
                                    port=port,
                                    autocommit=True)
      con.cursor().execute('CREATE DATABASE IF NOT EXISTS %s' % database)
  
  
  _create_test_database()
  target = MySqlTarget(host, database, username, password, '', 'update_id')
  
  
  class MySqlTargetTest(unittest.TestCase):
      def test_touch_and_exists(self):
          drop()
          self.assertFalse(target.exists(),
                           'Target should not exist before touching it')
          target.touch()
          self.assertTrue(target.exists(),
                          'Target should exist after touching it')
  
  
  def drop():
      con = target.connect(autocommit=True)
      con.cursor().execute('DROP TABLE IF EXISTS %s' % table_updates)
  
Remove the doc that describes the setup. Setup is automated now
## Code Before:
'''
$ mysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 211
Server version: 5.6.15 Homebrew

Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> create database luigi;
Query OK, 1 row affected (0.00 sec)
'''

import mysql.connector
from luigi.contrib.mysqldb import MySqlTarget
import unittest

host = 'localhost'
port = 3306
database = 'luigi_test'
username = None
password = None
table_updates = 'table_updates'


def _create_test_database():
    con = mysql.connector.connect(user=username,
                                  password=password,
                                  host=host,
                                  port=port,
                                  autocommit=True)
    con.cursor().execute('CREATE DATABASE IF NOT EXISTS %s' % database)


_create_test_database()
target = MySqlTarget(host, database, username, password, '', 'update_id')


class MySqlTargetTest(unittest.TestCase):
    def test_touch_and_exists(self):
        drop()
        self.assertFalse(target.exists(),
                         'Target should not exist before touching it')
        target.touch()
        self.assertTrue(target.exists(),
                        'Target should exist after touching it')


def drop():
    con = target.connect(autocommit=True)
    con.cursor().execute('DROP TABLE IF EXISTS %s' % table_updates)

## Instruction:
Remove the doc that describes the setup. Setup is automated now
## Code After:
import mysql.connector
from luigi.contrib.mysqldb import MySqlTarget
import unittest

host = 'localhost'
port = 3306
database = 'luigi_test'
username = None
password = None
table_updates = 'table_updates'


def _create_test_database():
    con = mysql.connector.connect(user=username,
                                  password=password,
                                  host=host,
                                  port=port,
                                  autocommit=True)
    con.cursor().execute('CREATE DATABASE IF NOT EXISTS %s' % database)


_create_test_database()
target = MySqlTarget(host, database, username, password, '', 'update_id')


class MySqlTargetTest(unittest.TestCase):
    def test_touch_and_exists(self):
        drop()
        self.assertFalse(target.exists(),
                         'Target should not exist before touching it')
        target.touch()
        self.assertTrue(target.exists(),
                        'Target should exist after touching it')


def drop():
    con = target.connect(autocommit=True)
    con.cursor().execute('DROP TABLE IF EXISTS %s' % table_updates)
