Hopeinen Omena

Koodi: Valitse kaikki

arttu@Tlazolteotl ~ % pip install mysql
DEPRECATION: Python 2.7 reached the end of its life on January 1st, 2020. Please upgrade your Python as Python 2.7 is no longer maintained. pip 21.0 will drop support for Python 2.7 in January 2021. More details about Python 2 support in pip, can be found at https://pip.pypa.io/en/latest/development/release-process/#python-2-support
Defaulting to user installation because normal site-packages is not writeable
Collecting mysql
  Downloading mysql-0.0.2.tar.gz (1.9 kB)
Collecting MySQL-python
  Downloading MySQL-python-1.2.5.zip (108 kB)
     |████████████████████████████████| 108 kB 346 kB/s
    ERROR: Command errored out with exit status 1:
     command: /System/Library/Frameworks/Python.framework/Versions/2.7/Resources/Python.app/Contents/MacOS/Python -c 'import sys, setuptools, tokenize; sys.argv[0] = '"'"'/private/var/folders/v0/1xnctqb11hz6qff8qt937yn40000gn/T/pip-install-VEaTjG/MySQL-python/setup.py'"'"'; __file__='"'"'/private/var/folders/v0/1xnctqb11hz6qff8qt937yn40000gn/T/pip-install-VEaTjG/MySQL-python/setup.py'"'"';f=getattr(tokenize, '"'"'open'"'"', open)(__file__);code=f.read().replace('"'"'\r\n'"'"', '"'"'\n'"'"');f.close();exec(compile(code, __file__, '"'"'exec'"'"'))' egg_info --egg-base /private/var/folders/v0/1xnctqb11hz6qff8qt937yn40000gn/T/pip-pip-egg-info-EOXPDN
         cwd: /private/var/folders/v0/1xnctqb11hz6qff8qt937yn40000gn/T/pip-install-VEaTjG/MySQL-python/
    Complete output (10 lines):
    sh: mysql_config: command not found
    Traceback (most recent call last):
      File "<string>", line 1, in <module>
      File "/private/var/folders/v0/1xnctqb11hz6qff8qt937yn40000gn/T/pip-install-VEaTjG/MySQL-python/setup.py", line 17, in <module>
        metadata, options = get_config()
      File "setup_posix.py", line 43, in get_config
        libs = mysql_config("libs_r")
      File "setup_posix.py", line 25, in mysql_config
        raise EnvironmentError("%s not found" % (mysql_config.path,))
    EnvironmentError: mysql_config not found
    ----------------------------------------
ERROR: Command errored out with exit status 1: python setup.py egg_info Check the logs for full command output.

Koodi: Valitse kaikki

# Luo ja avaa tietokantayhteyden

import mysql.connector
import xlrd

# Open connection
excelfile = xlrd.open_workbook("/Users/arttu/Downloads/tyovuorot.xls")
sheet = book.sheet_by_index(0)

database = MySQLdb.connect(host="localhost", user="xxxxxx", passwd="yyyyyy", db="sqlexcel" )

# Cursor
cursor = database.cursor()

# Create INSERT INTO
query = """INSERT INTO vuorot(rotweek, positio, tunnit, ma, ti, ke, to, pe, la, su) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s)"""
for r in range(1, sheet.nrows):
    rotweek = sheet.cell(r,0).value
    positio = sheet.cell(r,1).value
    tunnit = sheet.cell(r,2).value
    ma = sheet.call(r,3).value
    ti = sheet.call(r,4).value
    ke = sheet.call(r,5).value
    to = sheet.call(r,6).value
    pe = sheet.call(r,7).value
    la = sheet.call(r,8).value
    su = sheet.call(r,9).value

    #Assign values from each row in Excel
    values = (rotweek, positio, tunnit, ma, ti, ke, to, pe, la, su)

    #Execute SQL query
    cursor.execute(query, values)

# Close cursor
cursor.close()

# Commit the transaction
database.commit()

# Close the database
database.close()

Koodi: Valitse kaikki

    import xlrd
ModuleNotFoundError: No module named 'xlrd'

Koodi: Valitse kaikki

pip install xlrd