trouble with sqlite (indentation in sql commands)

[cimerio]

hello, everybody. can someone tell me what's wrong? even trying to correct with AI doesn't work.

import sqlite3
from tkinter.constants import INSERT

conn = sqlite3.connect('test_sqlite.db')

c = conn.cursor()

 tabela3 = ('''CREATE TABLE cedido 
 (matricula INTEGER PRIMARY KEY, nome TEXT, FOREIGN KEY(cessionario_cnpj) REFERENCES cessionario(cessionario_cnpj), processo TEXT, cpf TEXT, esfera TEXT, 
 FOREIGN KEY (cessionario_nome) REFERENCES cessionario(cessionario_nome))''')

c.execute(tabela3)

the error:

File "C:\Users\vitor\Documents\pythonFiles\testing_sqlite.py", line 14
tabela3 = ('''CREATE TABLE cedido
IndentationError: unexpected indent

[buran]

import sqlite3
from tkinter.constants import INSERT
 
conn = sqlite3.connect('test_sqlite.db')
 
c = conn.cursor()

# next line has an extra space at the start of the line
 tabela3 = ('''CREATE TABLE cedido 
 (matricula INTEGER PRIMARY KEY, nome TEXT, FOREIGN KEY(cessionario_cnpj) REFERENCES cessionario(cessionario_cnpj), processo TEXT, cpf TEXT, esfera TEXT, 
 FOREIGN KEY (cessionario_nome) REFERENCES cessionario(cessionario_nome))''')
 
c.execute(tabela3)

This is fixed code

import sqlite3
from tkinter.constants import INSERT
 
conn = sqlite3.connect('test_sqlite.db')
 
c = conn.cursor()

tabela3 = ('''CREATE TABLE cedido 
 (matricula INTEGER PRIMARY KEY, nome TEXT, FOREIGN KEY(cessionario_cnpj) REFERENCES cessionario(cessionario_cnpj), processo TEXT, cpf TEXT, esfera TEXT, 
 FOREIGN KEY (cessionario_nome) REFERENCES cessionario(cessionario_nome))''')
 
c.execute(tabela3)

[rofi223]

Looks like there's an indentation issue in your code. Check for extra spaces or tabs before tabela3 = ('''CREATE TABLE cedido. should be aligned properly with the rest of the code.

buran write Feb-27-2025, 04:06 AM:
Spam link removed

[cimerio]

thank you, friends