Cannot get field default value from the database

[embabi2005]

Cannot get columns default values from the database either through QSqlTableModel.record() nor QDatabase().record(), always None. Also setDefaultValue() does nothing. all field datatypes. Working with sqlite database.

I use Windows 11 x64, PyQt6 v6.6.2 and MySql Community server v8.0.32. I tried also with PyQt5 and other versions of PyQt6

[thecodemonkey86]

please show your code

[embabi2005]

First, thanks for your attention.
my code as below
`import sys

from PySide6.QtWidgets import QApplication, QWidget, QTableView, QVBoxLayout
from PySide6.QtSql import QSqlDatabase, QSqlTableModel, QSqlRecord

app = QApplication(sys.argv)
db = QSqlDatabase.addDatabase("QMYSQL")
db.setHostName("localhost")
db.setDatabaseName("WeighBridge")
db.setUserName("root")
db.setPassword("password")
db.setPort(3306)
db.open()

window = QWidget()
layout = QVBoxLayout(window)

model = QSqlTableModel()
model.setEditStrategy(QSqlTableModel.EditStrategy.OnManualSubmit)
model.setTable("tickets")
model.select()

tblView = QTableView()
tblView.setModel(model)
layout.addWidget(tblView)

dbRecord = db.record("tickets")
for i in range(dbRecord.count()):
print(dbRecord.field(i).name(), dbRecord.field(i).defaultValue())

dbRecord.field(1).setDefaultValue("someValue")
print(dbRecord.field(1).defaultValue())

modelRecord = model.record()
for i in range(modelRecord.count()):
print(modelRecord.field(i).name(), modelRecord.field(i).defaultValue())

modelRecord.field(1).setDefaultValue("someValue")
print(modelRecord.field(1).defaultValue())

window.show()
sys.exit(app.exec())
`

All results None

[thecodemonkey86]

apparently this already has been reported 12 years ago in Qt's bug tracker, but didn't get a fix: https://bugreports.qt.io/browse/QTBUG-19487

[embabi2005]

Thank you

Really appreciated