Python Forum
Help please - indentation error
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Help please - indentation error
#1
Hello,
I am a beginner in programming with python, my problem I can not execute this code, I would like to create a database with sqlite to manage my tables but I can not do it I need your help please .
https://www.cjoint.com/c/ICyltiwauDg


#########################################################Code#################################
import sqlite3
sqlite_DB='my_basedonnee.sqlite' # le nom de la base
table1='T_Etudiant' # le nom de la table1
table2='T_filiere' # le nom de la table2
attr1='id' #le nom de l'attribut1
type_attribut1='INTEGER' #le type de l'attribut INTERGER, TEXT, NULL, REAL, BLOB
attr2='libelle' #le nom de l'attribut2
type_attribut2='TEXT'
attr3='Faculté' #le nom de l'attribut3
type_attribut3='TEXT'
#connexion à la BD
conn=sqlite3.connect(sqlite_DB)
c=conn.cursor()
#Création de la table1 avec un seul attribut
def create():
 #Création de la table2 avec un attribut PRIMARY KEY
 c.execute('CREATE TABLE if not exists {t} ({a} {ty} PRIMARY KEY)'\
 .format(t=table2, a=attr1,ty=type_attribut1))
 c.execute('CREATE TABLE if not exists {t} ({a} {ty} PRIMARY KEY)'\
 .format(t=table1, a=attr1,ty=type_attribut1))
#create()
#**********************************************************
#Suppression des tables:
def supp_T_Etudiant():
 c.execute('drop table T_Etudiant')
def supp_T_filiere():
 c.execute('drop table T_filiere')
# Ajouter une conne2 et une colonne 3 à la table2
def maj_table():
 c.execute("ALTER TABLE {t} ADD COLUMN '{aj1}' {ty1}"\
 .format(t=table2, aj1=attr2, ty1=type_attribut2))
# Ajouter une colonne 3 à la table2
 c.execute("ALTER TABLE {t} ADD COLUMN '{aj1}' {ty1}"\
 .format(t=table2, aj1=attr3, ty1=type_attribut3))
#maj_table()
def delete():
 c.execute("delete from {T}".format(T=table2))
#delete()
#*********************************************************
#insertion des valeurs:
def insertion():
 try:
 c.execute("insert into {t}({V0},{V1},{V2}) values (1,'Bigdata','ESSAI')".\
 format(t=table2,V0=attr1, V1=attr2, V2=attr3))
 #c.execute("insert OR IGNORE INTO {t}({V0},{V1},{V2}) values
(1,'Bigdata','Dauphine')".\
 #format(t=table2,V0=attr1, V1=attr2, V2=attr3))
 c.execute("insert into {t}({V0},{V1},{V2}) values (2,'BD','ESSAI')".\
 format(t=table2,V0=attr1, V1=attr2, V2=attr3))
 c.execute("insert into {t}({V0},{V1},{V2}) values (3,'Anglais','ESSAI')".\
 format(t=table2,V0=attr1, V1=attr2, V2=attr3))
 c.execute("insert into {t}({V0},{V1},{V2}) values (4,'Maths','ESSAI')".\
 format(t=table2,V0=attr1, V1=attr2, V2=attr3))
 except sqlite3.IntegrityError:
 print("ERROR/ ID already exists in PRIMARY KEY column {0}".format(attr1))
#remplacer Essai du premier tuple par Insat
def maj_donnee():
 c.execute("update {t} set {V2}=('insat') where
{V0}=(1)".format(t=table2,V2=attr3,V0=attr1))
#*******************************************************
#insertion()
#maj_donnee()
#*******************************************************
#sélectionner seulement deux tuples dont l'école='ESSAI'
def selection1():
 c.execute('SELECT * FROM {t} WHERE {a2}="ESSAI" LIMIT 2'.\
 format(t=table2, a2=attr3))
 lignes=c.fetchall()
 print('1):', lignes)
 #afficher le tuple dont la clé est égale à 3, sinon écrire 'il n'existe pas':
def selection2():
 constante=5
 c.execute('SELECT * FROM {t} WHERE {a1}={a2}'.format(a1=attr1,a2=constante,
t=table2))
 ligne=c.fetchone()
 if ligne:
 print('2):{}'.format(ligne))
 else:
 print('{} n\'existe pas '.format(constante))
#selection1()
#selection2()
#*************************************************
def info():
 c.execute('PRAGMA TABLE_INFO({})'.format(table2))
#collect names in a list
 names=[tup for tup in c.fetchall()]
 print(names)
#info()
#**************************************************
#mettre la base de données dans un fichier CSV
import pandas as pd
def to_csv():
 c.execute("SELECT name FROM sqlite_master WHERE type='table'")

 tables=c.fetchall()
 print (tables)
 for table_name in tables:
 table_name=table_name[0]
 table=pd.read_sql_query("SELECT * from %s" %table_name,conn)
 print(table)
 table.to_csv(table_name+'1.csv',index_label='index')
#to_csv()
#**************************************************
conn.commit()
c.close()
conn.close()
[Image: ICyltiwauDg]
Reply


Messages In This Thread
Help please - indentation error - by bil007 - Mar-24-2019, 11:21 AM
RE: Help please - indentation error - by Yoriz - Mar-24-2019, 11:41 AM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Indentation Error With If Else Statement JoeDainton123 3 1,880 Aug-02-2020, 08:29 PM
Last Post: deanhystad
  Indentation error... lol ironfelix717 8 3,892 Apr-02-2020, 02:31 PM
Last Post: buran
  Getting error message for indentation Shafla 5 2,926 May-07-2019, 08:56 PM
Last Post: Yoriz
  Very strange error of indentation samsonite 12 5,394 Mar-22-2019, 10:45 AM
Last Post: samsonite
  Indentation error in Python code ErnestTBass 5 3,653 Feb-28-2019, 04:26 PM
Last Post: samsonite
  Class - Error Message (Indentation) tkj80 3 4,560 Jan-20-2017, 07:48 AM
Last Post: wavic

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020