Bonjour,

Je souhaite avoir tous les lignes de la base mais avec mon code il m'affiche que les titres de ma table et la première ligne.

voici mon code et Merci d'avance :).

from PyQt5 import QtSql from PyQt5.QtSql import *

class Database_prix:

is_instantiated = False

def __init__(self):
    if not Database_prix.is_instantiated:
     #  print ("Database has been instantiated:")
        self.db = QSqlDatabase.addDatabase("QSQLITE")
        self.db.setDatabaseName("C:/Users/yatamant/Documents/Mes fichiers reçus/Dev_Env/database_prix.db")
        self.db.open()
        Database_prix.is_instantiated =True
    
    else:
        print("Has already been created")

def get_prix_reference_full_info(self):
    
    query=QSqlQuery()

    query_string = """ SELECT PU.id_pu as "ID", PU.ref_pu as "Reference", PU.desig_pu as "Designation", PU.unite as "Unite", PU.quantite as "Quantite", PU.prix as "Prix", PU.TVA as "TVA", PU.id_domaine as "Domaine", PU._id_s_domaine1 as "S_domaine1", PU.id_s_domaine2 as "S_domaine2", PU.id_s_domaine3 as "S_domaine3", PU.id_devis as "Devis"
                       FROM PU """
        
    res = query.exec(query_string)

    record = query.record()
    column_number = record.count()
    
    header_list = []

    for i in range(column_number):
        header_list.append(record.field(i).name())
    
    result_list = []

    while query.next():
        sublist =[]

        for i in range(column_number):
            sublist.append(query.value(i))
        result_list.append(sublist)

        return [header_list,result_list]

-
Edité par Natis 1 décembre 2020 à 12:55:29

Merci pour ta reponse, ca fonctionne toujours pas