-
check_circle_outlineMódulo 1 | 6 clases
Introducción
expand_more -
check_circle_outlineMódulo 2 | 12 clases
ORM
expand_more -
check_circle_outlineMódulo 3 | 4 clases
MongoDB
expand_more
2 comentario(s)
Tengo una pregunta respecto al código, al ejecutar me sale error en la linea 43, en esta esta query = SELECT_USER.format(id=1), el error es
inconsistent use of tabs and spaces in indentation (<unknown>, line 42)
import pymysql as MySQLdb # importamos MySQLdb en python
HOST = 'localhost'
USER = 'root'
PASSWORD = 'nates'
DATABASE = 'minicurso_python'
USER_TABLE = """ CREATE TABLE users(
id Int(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
username VARCHAR(50) NOT NULL,
password VARCHAR(50) NOT NULL
)"""
DROP_USER = "DROP TABLE IF EXISTS `users`"
SHOW_TABLES = "SHOW TABLES"
INSERT_USER = "INSERT INTO users (username, password) VALUES( '{username}', '{password}' )" # Comando que permite el Almacenamiento del usuario ingresado
SELECT_USER = "SELECT * FROM users WHERE id = {id}"
if __name__ == '__main__':
try:
connection = MySQLdb.connect(HOST, USER, PASSWORD, DATABASE)
cursor = connection.cursor()
cursor.execute(DROP_USER)
cursor.execute(USER_TABLE)
username = input("ingrese su username \n")
password = input("ingrese su password \n")
query = INSERT_USER.format(username=username, password=password) # ALMACENA LOS DATOS IMPRESOS DE username & password
print(query)
try:
cursor.execute(query)
connection.commit() #Permite guardar los datos almacenados por el usuario
except:
connection.rollback()
query = SELECT_USER.format(id=1)
print(query)
cursor.execute(query)
users = cursor.fetchall()
for user in users:
print(user)
connection.close()
except MySQLdb.Error as error:
print(error)
inconsistent use of tabs and spaces in indentation (<unknown>, line 42)
import pymysql as MySQLdb # importamos MySQLdb en python
HOST = 'localhost'
USER = 'root'
PASSWORD = 'nates'
DATABASE = 'minicurso_python'
USER_TABLE = """ CREATE TABLE users(
id Int(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
username VARCHAR(50) NOT NULL,
password VARCHAR(50) NOT NULL
)"""
DROP_USER = "DROP TABLE IF EXISTS `users`"
SHOW_TABLES = "SHOW TABLES"
INSERT_USER = "INSERT INTO users (username, password) VALUES( '{username}', '{password}' )" # Comando que permite el Almacenamiento del usuario ingresado
SELECT_USER = "SELECT * FROM users WHERE id = {id}"
if __name__ == '__main__':
try:
connection = MySQLdb.connect(HOST, USER, PASSWORD, DATABASE)
cursor = connection.cursor()
cursor.execute(DROP_USER)
cursor.execute(USER_TABLE)
username = input("ingrese su username \n")
password = input("ingrese su password \n")
query = INSERT_USER.format(username=username, password=password) # ALMACENA LOS DATOS IMPRESOS DE username & password
print(query)
try:
cursor.execute(query)
connection.commit() #Permite guardar los datos almacenados por el usuario
except:
connection.rollback()
query = SELECT_USER.format(id=1)
print(query)
cursor.execute(query)
users = cursor.fetchall()
for user in users:
print(user)
connection.close()
except MySQLdb.Error as error:
print(error)
Clase 5