Qt 4.8
Classes | Public Types | Public Functions | Static Public Functions | Public Variables | List of all members
QSqlTableModelPrivate Class Reference

#include <qsqltablemodel_p.h>

Inheritance diagram for QSqlTableModelPrivate:
QSqlQueryModelPrivate QAbstractItemModelPrivate QObjectPrivate QObjectData QSqlRelationalTableModelPrivate

Classes

struct  ModifiedRow
 

Public Types

typedef QMap< int, ModifiedRow > CacheMap
 
enum  Op { None, Insert, Update, Delete }
 
- Public Types inherited from QObjectPrivate
typedef void(* StaticMetaCallFunction) (QObject *, QMetaObject::Call, int, void **)
 

Public Functions

void clear ()
 
virtual void clearCache ()
 
virtual void clearEditBuffer ()
 
bool exec (const QString &stmt, bool prepStatement, const QSqlRecord &rec, const QSqlRecord &whereValues)
 
void initRecordAndPrimaryIndex ()
 
virtual int nameToIndex (const QString &name) const
 
QSqlRecord primaryValues (int index)
 
 QSqlTableModelPrivate ()
 
QSqlRecord record (const QVector< QVariant > &values) const
 Populates our record with values. More...
 
virtual void revertCachedRow (int row)
 
void revertInsertedRow ()
 
bool setRecord (int row, const QSqlRecord &record)
 Set a record for OnFieldChange and OnRowChange. More...
 
- Public Functions inherited from QSqlQueryModelPrivate
void initColOffsets (int size)
 
void prefetch (int)
 
 QSqlQueryModelPrivate ()
 
 ~QSqlQueryModelPrivate ()
 
- Public Functions inherited from QAbstractItemModelPrivate
bool allowMove (const QModelIndex &srcParent, int srcFirst, int srcLast, const QModelIndex &destinationParent, int destinationChild, Qt::Orientation orientation)
 Returns whether a move operation is valid. More...
 
void columnsAboutToBeInserted (const QModelIndex &parent, int first, int last)
 
void columnsAboutToBeRemoved (const QModelIndex &parent, int first, int last)
 
void columnsInserted (const QModelIndex &parent, int first, int last)
 
void columnsRemoved (const QModelIndex &parent, int first, int last)
 
QModelIndex createIndex (int row, int column, void *data=0) const
 
QModelIndex createIndex (int row, int column, int id) const
 
bool indexValid (const QModelIndex &index) const
 
void invalidatePersistentIndex (const QModelIndex &index)
 
void invalidatePersistentIndexes ()
 
void itemsAboutToBeMoved (const QModelIndex &srcParent, int srcFirst, int srcLast, const QModelIndex &destinationParent, int destinationChild, Qt::Orientation)
 
void itemsMoved (const QModelIndex &srcParent, int srcFirst, int srcLast, const QModelIndex &destinationParent, int destinationChild, Qt::Orientation orientation)
 
void movePersistentIndexes (QVector< QPersistentModelIndexData *> indexes, int change, const QModelIndex &parent, Qt::Orientation orientation)
 Moves persistent indexes indexes by amount change. More...
 
 QAbstractItemModelPrivate ()
 
void removePersistentIndexData (QPersistentModelIndexData *data)
 
void rowsAboutToBeInserted (const QModelIndex &parent, int first, int last)
 
void rowsAboutToBeRemoved (const QModelIndex &parent, int first, int last)
 
void rowsInserted (const QModelIndex &parent, int first, int last)
 
void rowsRemoved (const QModelIndex &parent, int first, int last)
 
- Public Functions inherited from QObjectPrivate
void _q_reregisterTimers (void *pointer)
 
void addConnection (int signal, Connection *c)
 
void cleanConnectionLists ()
 
void connectNotify (const char *signal)
 
void deleteChildren ()
 
void disconnectNotify (const char *signal)
 
bool isSender (const QObject *receiver, const char *signal) const
 
bool isSignalConnected (uint signalIdx) const
 Returns true if the signal with index signal_index from object sender is connected. More...
 
void moveToThread_helper ()
 
 QObjectPrivate (int version=QObjectPrivateVersion)
 
QObjectList receiverList (const char *signal) const
 
QObjectList senderList () const
 
void setParent_helper (QObject *)
 
void setThreadData_helper (QThreadData *currentData, QThreadData *targetData)
 
int signalIndex (const char *signalName) const
 Returns the signal index used in the internal connectionLists vector. More...
 
virtual ~QObjectPrivate ()
 
- Public Functions inherited from QObjectData
virtual ~QObjectData ()=0
 

Static Public Functions

static void clearGenerated (QSqlRecord &rec)
 
static void setGeneratedValue (QSqlRecord &rec, int c, QVariant v)
 
- Static Public Functions inherited from QAbstractItemModelPrivate
static const QHash< int, QByteArray > & defaultRoleNames ()
 
static QAbstractItemModel * staticEmptyModel ()
 
static bool variantLessThan (const QVariant &v1, const QVariant &v2)
 This function is used by our Q{Tree,Widget,Table}WidgetModel classes to sort. More...
 
- Static Public Functions inherited from QObjectPrivate
static void clearGuards (QObject *)
 
static QObjectPrivate * get (QObject *o)
 
static void resetCurrentSender (QObject *receiver, Sender *currentSender, Sender *previousSender)
 
static Sender * setCurrentSender (QObject *receiver, Sender *sender)
 
static void signalSignature (const QMetaMethod &signal, QVarLengthArray< char > *result)
 

Public Variables

CacheMap cache
 
QSqlDatabase db
 
QSqlRecord editBuffer
 
int editIndex
 
QSqlQuery editQuery
 
QString filter
 
int insertIndex
 
QSqlIndex primaryIndex
 
int sortColumn
 
Qt::SortOrder sortOrder
 
QSqlTableModel::EditStrategy strategy
 
QString tableName
 
- Public Variables inherited from QSqlQueryModelPrivate
uint atEnd: 1
 
QModelIndex bottom
 
QVarLengthArray< int, 56 > colOffsets
 
QSqlError error
 
QVector< QHash< int, QVariant > > headers
 
QSqlQuery query
 
QSqlRecord rec
 
- Public Variables inherited from QAbstractItemModelPrivate
QStack< Change > changes
 
struct QAbstractItemModelPrivate::Persistent persistent
 
QHash< int, QByteArray > roleNames
 
Qt::DropActions supportedDragActions
 
- Public Variables inherited from QObjectPrivate
union {
   QObject *   currentChildBeingDeleted
 
   QAbstractDeclarativeData *   declarativeData
 
}; 
 
quint32 connectedSignals [2]
 
QObjectConnectionListVector * connectionLists
 
Sender * currentSender
 
QList< QPointer< QObject > > eventFilters
 
ExtraData * extraData
 
QString objectName
 
Connection * senders
 
QAtomicPointer< QtSharedPointer::ExternalRefCountData > sharedRefcount
 
QThreadData * threadData
 
void * unused
 
- Public Variables inherited from QObjectData
uint blockSig: 1
 
QObjectList children
 
uint hasGuards: 1
 
uint inEventHandler: 1
 
uint inThreadChangeEvent: 1
 
uint isWidget: 1
 
QMetaObject * metaObject
 
uint ownObjectName: 1
 
QObject * parent
 
uint pendTimer: 1
 
int postedEvents
 
QObject * q_ptr
 
uint receiveChildEvents: 1
 
uint sendChildEvents: 1
 
uint unused: 22
 
uint wasDeleted: 1
 

Detailed Description

Definition at line 61 of file qsqltablemodel_p.h.

Typedefs

◆ CacheMap

typedef QMap<int, ModifiedRow> QSqlTableModelPrivate::CacheMap

Definition at line 114 of file qsqltablemodel_p.h.

Enumerations

◆ Op

enum QSqlTableModelPrivate::Op
Enumerator
None 
Insert 
Update 
Delete 

Definition at line 101 of file qsqltablemodel_p.h.

101 { None, Insert, Update, Delete };

Constructors and Destructors

◆ QSqlTableModelPrivate()

QSqlTableModelPrivate::QSqlTableModelPrivate ( )
inline

Definition at line 66 of file qsqltablemodel_p.h.

67  : editIndex(-1), insertIndex(-1), sortColumn(-1),
68  sortOrder(Qt::AscendingOrder),
69  strategy(QSqlTableModel::OnRowChange)
70  {}
QSqlTableModelPrivate::strategy
QSqlTableModel::EditStrategy strategy
Definition: qsqltablemodel_p.h:94

Functions

◆ clear()

void QSqlTableModelPrivate::clear ( void  )

Definition at line 121 of file qsqltablemodel.cpp.

Referenced by QSqlTableModelPrivate().

122 {
123  editIndex = -1;
124  sortColumn = -1;
125  sortOrder = Qt::AscendingOrder;
126  tableName.clear();
127  editQuery.clear();
128  editBuffer.clear();
129  cache.clear();
130  primaryIndex.clear();
131  rec.clear();
132  filter.clear();
133 }
QSqlQuery::clear
void clear()
Clears the result set and releases any resources held by the query.
Definition: qsqlquery.cpp:874
QString::clear
void clear()
Clears the contents of the string and makes it empty.
Definition: qstring.h:723
QSqlRecord::clear
void clear()
Removes all the record&#39;s fields.
Definition: qsqlrecord.cpp:367
QMap::clear
void clear()
Removes all items from the map.
Definition: qmap.h:444

◆ clearCache()

void QSqlTableModelPrivate::clearCache ( )
virtual

Reimplemented in QSqlRelationalTableModelPrivate.

Definition at line 152 of file qsqltablemodel.cpp.

Referenced by QSqlRelationalTableModelPrivate::clearCache(), and QSqlTableModelPrivate().

153 {
154  cache.clear();
155 }
QMap::clear
void clear()
Removes all items from the map.
Definition: qmap.h:444

◆ clearEditBuffer()

void QSqlTableModelPrivate::clearEditBuffer ( )
virtual

Reimplemented in QSqlRelationalTableModelPrivate.

Definition at line 146 of file qsqltablemodel.cpp.

Referenced by QSqlTableModelPrivate().

147 {
148  editBuffer = rec;
149  clearGenerated(editBuffer);
150 }
QSqlTableModelPrivate::clearGenerated
static void clearGenerated(QSqlRecord &rec)
Definition: qsqltablemodel.cpp:157

◆ clearGenerated()

void QSqlTableModelPrivate::clearGenerated ( QSqlRecord &  rec)
static

Definition at line 157 of file qsqltablemodel.cpp.

Referenced by clearEditBuffer(), QSqlTableModelPrivate::ModifiedRow::ModifiedRow(), QSqlTableModelPrivate(), QSqlTableModel::setData(), and QSqlTableModel::setRecord().

158 {
159  for (int i = rec.count() - 1; i >= 0; i--)
160  rec.setGenerated(i, false);
161 }
QSqlRecord::count
int count() const
Returns the number of fields in the record.
Definition: qsqlrecord.cpp:573
QSqlRecord::setGenerated
void setGenerated(const QString &name, bool generated)
Sets the generated flag for the field called name to generated.
Definition: qsqlrecord.cpp:420

◆ exec()

bool QSqlTableModelPrivate::exec ( const QString &  stmt,
bool  prepStatement,
const QSqlRecord &  rec,
const QSqlRecord &  whereValues 
)

Definition at line 201 of file qsqltablemodel.cpp.

Referenced by QSqlTableModelPrivate().

203 {
204  if (stmt.isEmpty())
205  return false;
206 
207  // lazy initialization of editQuery
208  if (editQuery.driver() != db.driver())
209  editQuery = QSqlQuery(db);
210 
211  // workaround for In-Process databases - remove all read locks
212  // from the table to make sure the editQuery succeeds
213  if (db.driver()->hasFeature(QSqlDriver::SimpleLocking))
214  const_cast<QSqlResult *>(query.result())->detachFromResultSet();
215 
216  if (prepStatement) {
217  if (editQuery.lastQuery() != stmt) {
218  if (!editQuery.prepare(stmt)) {
219  error = editQuery.lastError();
220  return false;
221  }
222  }
223  int i;
224  for (i = 0; i < rec.count(); ++i) {
225  if (rec.isGenerated(i))
226  editQuery.addBindValue(rec.value(i));
227  }
228  for (i = 0; i < whereValues.count(); ++i) {
229  if (whereValues.isGenerated(i) && !whereValues.isNull(i))
230  editQuery.addBindValue(whereValues.value(i));
231  }
232 
233  if (!editQuery.exec()) {
234  error = editQuery.lastError();
235  return false;
236  }
237  } else {
238  if (!editQuery.exec(stmt)) {
239  error = editQuery.lastError();
240  return false;
241  }
242  }
243  return true;
244 }
QSqlQuery::driver
const QSqlDriver * driver() const
Returns the database driver associated with the query.
Definition: qsqlquery.cpp:441
QSqlQuery::prepare
bool prepare(const QString &query)
Prepares the SQL query query for execution.
Definition: qsqlquery.cpp:903
QSqlDriver::hasFeature
virtual bool hasFeature(DriverFeature f) const =0
Returns true if the driver supports feature feature; otherwise returns false.
QSqlQuery
The QSqlQuery class provides a means of executing and manipulating SQL statements.
Definition: qsqlquery.h:63
QSqlRecord::isNull
bool isNull(int i) const
Returns true if the field index is null or if there is no field at position index; otherwise returns ...
Definition: qsqlrecord.cpp:453
QSqlQuery::result
const QSqlResult * result() const
Returns the result associated with the query.
Definition: qsqlquery.cpp:450
QSqlDatabase::driver
QSqlDriver * driver() const
Returns the database driver used to access the database connection.
Definition: qsqldatabase.cpp:1170
QSqlQuery::lastQuery
QString lastQuery() const
Returns the text of the current query being used, or an empty string if there is no current query tex...
Definition: qsqlquery.cpp:432
QSqlRecord::isGenerated
bool isGenerated(int i) const
Returns true if the record has a field at position index and this field is to be generated (the defau...
Definition: qsqlrecord.cpp:519
QString::isEmpty
bool isEmpty() const
Returns true if the string has no characters; otherwise returns false.
Definition: qstring.h:704
QSqlRecord::count
int count() const
Returns the number of fields in the record.
Definition: qsqlrecord.cpp:573
QSqlQuery::addBindValue
void addBindValue(const QVariant &val, QSql::ParamType type=QSql::In)
Adds the value val to the list of values when using positional value binding.
Definition: qsqlquery.cpp:1060
QSqlQuery::lastError
QSqlError lastError() const
Returns error information about the last error (if any) that occurred with this query.
Definition: qsqlquery.cpp:754
QSqlQuery::exec
bool exec(const QString &query)
Executes the SQL in query.
Definition: qsqlquery.cpp:355
QSqlRecord::value
QVariant value(int i) const
Returns the value of the field located at position index in the record.
Definition: qsqlrecord.cpp:203

◆ initRecordAndPrimaryIndex()

void QSqlTableModelPrivate::initRecordAndPrimaryIndex ( )

Definition at line 115 of file qsqltablemodel.cpp.

Referenced by QSqlTableModelPrivate().

116 {
117  rec = db.record(tableName);
118  primaryIndex = db.primaryIndex(tableName);
119 }
QSqlDatabase::primaryIndex
QSqlIndex primaryIndex(const QString &tablename) const
Returns the primary index for table tablename.
Definition: qsqldatabase.cpp:1210
QSqlDatabase::record
QSqlRecord record(const QString &tablename) const
Returns a QSqlRecord populated with the names of all the fields in the table (or view) called tablena...
Definition: qsqldatabase.cpp:1223

◆ nameToIndex()

int QSqlTableModelPrivate::nameToIndex ( const QString &  name) const
virtual

Reimplemented in QSqlRelationalTableModelPrivate.

Definition at line 107 of file qsqltablemodel.cpp.

Referenced by QSqlTableModelPrivate(), and setRecord().

108 {
109  QString fieldname = name;
110  if (db.driver()->isIdentifierEscaped(fieldname, QSqlDriver::FieldName))
111  fieldname = db.driver()->stripDelimiters(fieldname, QSqlDriver::FieldName);
112  return rec.indexOf(fieldname);
113 }
QString
The QString class provides a Unicode character string.
Definition: qstring.h:83
QSqlDatabase::driver
QSqlDriver * driver() const
Returns the database driver used to access the database connection.
Definition: qsqldatabase.cpp:1170
QSqlDriver::isIdentifierEscaped
bool isIdentifierEscaped(const QString &identifier, IdentifierType type) const
Returns whether identifier is escaped according to the database rules.
Definition: qsqldriver.cpp:429
name
const char * name
Definition: qkeysequence.cpp:396
QSqlDriver::stripDelimiters
QString stripDelimiters(const QString &identifier, IdentifierType type) const
Returns the identifier with the leading and trailing delimiters removed, identifier can either be a t...
Definition: qsqldriver.cpp:455
QSqlRecord::indexOf
int indexOf(const QString &name) const
Returns the position of the field called name within the record, or -1 if it cannot be found...
Definition: qsqlrecord.cpp:246

◆ primaryValues()

QSqlRecord QSqlTableModelPrivate::primaryValues ( int  index)

Definition at line 246 of file qsqltablemodel.cpp.

Referenced by QSqlTableModelPrivate().

247 {
248  QSqlRecord record;
249  if (!query.seek(row)) {
250  error = query.lastError();
251  return record;
252  }
253  if (primaryIndex.isEmpty()) {
254  record = rec;
255  for (int i = 0; i < record.count(); ++i)
256  record.setValue(i, query.value(i));
257  } else {
258  record = primaryIndex;
259  for (int i = 0; i < record.count(); ++i)
260  record.setValue(i, query.value(rec.indexOf(record.fieldName(i))));
261  }
262  return record;
263 }
QSqlRecord::isEmpty
bool isEmpty() const
Returns true if there are no fields in the record; otherwise returns false.
Definition: qsqlrecord.cpp:380
QSqlRecord
The QSqlRecord class encapsulates a database record.
Definition: qsqlrecord.h:58
QSqlRecord::count
int count() const
Returns the number of fields in the record.
Definition: qsqlrecord.cpp:573
QSqlQuery::lastError
QSqlError lastError() const
Returns error information about the last error (if any) that occurred with this query.
Definition: qsqlquery.cpp:754
QSqlTableModelPrivate::record
QSqlRecord record(const QVector< QVariant > &values) const
Populates our record with values.
Definition: qsqltablemodel.cpp:64
QSqlQuery::seek
bool seek(int i, bool relative=false)
Retrieves the record at position index, if available, and positions the query on the retrieved record...
Definition: qsqlquery.cpp:502
QSqlRecord::setValue
void setValue(int i, const QVariant &val)
Sets the value of the field at position index to val.
Definition: qsqlrecord.cpp:585
QSqlRecord::fieldName
QString fieldName(int i) const
Returns the name of the field at position index.
Definition: qsqlrecord.cpp:232
QSqlQuery::value
QVariant value(int i) const
Returns the value of field index in the current record.
Definition: qsqlquery.cpp:403
QSqlRecord::indexOf
int indexOf(const QString &name) const
Returns the position of the field called name within the record, or -1 if it cannot be found...
Definition: qsqlrecord.cpp:246

◆ record()

QSqlRecord QSqlTableModelPrivate::record ( const QVector< QVariant > &  values) const

Populates our record with values.

Warning
This function is not part of the public interface.

Definition at line 64 of file qsqltablemodel.cpp.

Referenced by primaryValues(), and QSqlTableModelPrivate().

65 {
66  QSqlRecord r = rec;
67  for (int i = 0; i < r.count() && i < values.count(); ++i)
68  r.setValue(i, values.at(i));
69  return r;
70 }
QVector::count
int count(const T &t) const
Returns the number of occurrences of value in the vector.
Definition: qvector.h:742
QSqlRecord
The QSqlRecord class encapsulates a database record.
Definition: qsqlrecord.h:58
QVector::at
const T & at(int i) const
Returns the item at index position i in the vector.
Definition: qvector.h:350
QSqlRecord::count
int count() const
Returns the number of fields in the record.
Definition: qsqlrecord.cpp:573
QSqlRecord::setValue
void setValue(int i, const QVariant &val)
Sets the value of the field at position index to val.
Definition: qsqlrecord.cpp:585

◆ revertCachedRow()

void QSqlTableModelPrivate::revertCachedRow ( int  row)
virtual

Reimplemented in QSqlRelationalTableModelPrivate.

Definition at line 169 of file qsqltablemodel.cpp.

Referenced by QSqlTableModelPrivate(), and QSqlRelationalTableModelPrivate::revertCachedRow().

170 {
171  Q_Q(QSqlTableModel);
172  ModifiedRow r = cache.value(row);
173  switch (r.op) {
174  case QSqlTableModelPrivate::None:
175  Q_ASSERT_X(false, "QSqlTableModelPrivate::revertCachedRow()", "Invalid entry in cache map");
176  return;
177  case QSqlTableModelPrivate::Update:
178  case QSqlTableModelPrivate::Delete:
179  cache.remove(row);
180  emit q->dataChanged(q->createIndex(row, 0),
181  q->createIndex(row, q->columnCount() - 1));
182  break;
183  case QSqlTableModelPrivate::Insert: {
184  QMap<int, QSqlTableModelPrivate::ModifiedRow>::Iterator it = cache.find(row);
185  if (it == cache.end())
186  return;
187  q->beginRemoveRows(QModelIndex(), row, row);
188  it = cache.erase(it);
189  while (it != cache.end()) {
190  int oldKey = it.key();
191  const QSqlTableModelPrivate::ModifiedRow oldValue = it.value();
192  cache.erase(it);
193  it = cache.insert(oldKey - 1, oldValue);
194  ++it;
195  }
196  q->endRemoveRows();
197  break; }
198  }
199 }
QMap::iterator::key
const Key & key() const
Returns the current item&#39;s key as a const reference.
Definition: qmap.h:250
it
#define it(className, varName)
Definition: qbuiltintypes.cpp:95
QMap::find
iterator find(const Key &key)
Returns an iterator pointing to the item with key key in the map.
Definition: qmap.h:618
Q_Q
#define Q_Q(Class)
Definition: qglobal.h:2483
QMap::iterator::value
T & value() const
Returns a modifiable reference to the current item&#39;s value.
Definition: qmap.h:251
QMap::value
const T value(const Key &key) const
Returns the value associated with the key key.
Definition: qmap.h:499
emit
#define emit
Definition: qobjectdefs.h:76
QMap::remove
int remove(const Key &key)
Removes all the items that have the key key from the map.
Definition: qmap.h:662
Q_ASSERT_X
#define Q_ASSERT_X(cond, where, what)
Definition: qglobal.h:1837
QMap::iterator
The QMap::iterator class provides an STL-style non-const iterator for QMap and QMultiMap.
Definition: qmap.h:233
QMap::end
iterator end()
Returns an STL-style iterator pointing to the imaginary item after the last item in the map...
Definition: qmap.h:375
QMap::insert
iterator insert(const Key &key, const T &value)
Inserts a new item with the key key and a value of value.
Definition: qmap.h:559
QModelIndex
The QModelIndex class is used to locate data in a data model.
Definition: qabstractitemmodel.h:58
QSqlTableModel
The QSqlTableModel class provides an editable data model for a single database table.
Definition: qsqltablemodel.h:59
QMap::erase
iterator erase(iterator it)
Removes the (key, value) pair pointed to by the iterator pos from the map, and returns an iterator to...
Definition: qmap.h:717

◆ revertInsertedRow()

void QSqlTableModelPrivate::revertInsertedRow ( )

Definition at line 135 of file qsqltablemodel.cpp.

Referenced by QSqlTableModelPrivate().

136 {
137  Q_Q(QSqlTableModel);
138  if (insertIndex == -1)
139  return;
140 
141  q->beginRemoveRows(QModelIndex(), insertIndex, insertIndex);
142  insertIndex = -1;
143  q->endRemoveRows();
144 }
Q_Q
#define Q_Q(Class)
Definition: qglobal.h:2483
QModelIndex
The QModelIndex class is used to locate data in a data model.
Definition: qabstractitemmodel.h:58
QSqlTableModel
The QSqlTableModel class provides an editable data model for a single database table.
Definition: qsqltablemodel.h:59

◆ setGeneratedValue()

void QSqlTableModelPrivate::setGeneratedValue ( QSqlRecord &  rec,
int  c,
QVariant  v 
)
static

Definition at line 163 of file qsqltablemodel.cpp.

Referenced by QSqlTableModelPrivate(), and QSqlTableModel::setData().

164 {
165  rec.setValue(c, v);
166  rec.setGenerated(c, true);
167 }
c
unsigned char c[8]
Definition: qnumeric_p.h:62
QSqlRecord::setValue
void setValue(int i, const QVariant &val)
Sets the value of the field at position index to val.
Definition: qsqlrecord.cpp:585
QSqlRecord::setGenerated
void setGenerated(const QString &name, bool generated)
Sets the generated flag for the field called name to generated.
Definition: qsqlrecord.cpp:420

◆ setRecord()

bool QSqlTableModelPrivate::setRecord ( int  row,
const QSqlRecord &  record 
)

Set a record for OnFieldChange and OnRowChange.

Warning
This function is not part of the public interface.

Definition at line 78 of file qsqltablemodel.cpp.

Referenced by QSqlTableModelPrivate().

79 {
80  Q_Q(QSqlTableModel);
81  bool isOk = true;
82 
83  QSqlTableModel::EditStrategy oldStrategy = strategy;
84 
85  // FieldChange strategy makes no sense when setting an entire row
86  if (strategy == QSqlTableModel::OnFieldChange)
87  strategy = QSqlTableModel::OnRowChange;
88  for (int i = 0; i < record.count(); ++i) {
89  if (!record.isGenerated(i))
90  continue;
91  int idx = nameToIndex(record.fieldName(i));
92  if (idx == -1)
93  continue;
94  QModelIndex cIndex = q->createIndex(row, idx);
95  QVariant value = record.value(i);
96  QVariant oldValue = q->data(cIndex);
97  if (oldValue.isNull() || oldValue != value)
98  isOk &= q->setData(cIndex, value, Qt::EditRole);
99  }
100  if (isOk && oldStrategy == QSqlTableModel::OnFieldChange)
101  q->submitAll();
102  strategy = oldStrategy;
103 
104  return isOk;
105 }
QVariant
The QVariant class acts like a union for the most common Qt data types.
Definition: qvariant.h:92
QSqlTableModel::EditStrategy
EditStrategy
This enum type describes which strategy to choose when editing values in the database.
Definition: qsqltablemodel.h:65
QSqlTableModelPrivate::nameToIndex
virtual int nameToIndex(const QString &name) const
Definition: qsqltablemodel.cpp:107
QVariant::isNull
bool isNull() const
Returns true if this is a NULL variant, false otherwise.
Definition: qvariant.cpp:3102
Q_Q
#define Q_Q(Class)
Definition: qglobal.h:2483
QSqlRecord::isGenerated
bool isGenerated(int i) const
Returns true if the record has a field at position index and this field is to be generated (the defau...
Definition: qsqlrecord.cpp:519
QVariant::data
void * data()
Definition: qvariant.cpp:3077
QSqlTableModelPrivate::strategy
QSqlTableModel::EditStrategy strategy
Definition: qsqltablemodel_p.h:94
QSqlRecord::count
int count() const
Returns the number of fields in the record.
Definition: qsqlrecord.cpp:573
QModelIndex
The QModelIndex class is used to locate data in a data model.
Definition: qabstractitemmodel.h:58
QSqlTableModel
The QSqlTableModel class provides an editable data model for a single database table.
Definition: qsqltablemodel.h:59
QSqlRecord::fieldName
QString fieldName(int i) const
Returns the name of the field at position index.
Definition: qsqlrecord.cpp:232
QSqlRecord::value
QVariant value(int i) const
Returns the value of the field located at position index in the record.
Definition: qsqlrecord.cpp:203

Properties

◆ cache

CacheMap QSqlTableModelPrivate::cache

Definition at line 115 of file qsqltablemodel_p.h.

Referenced by clear(), clearCache(), and revertCachedRow().

◆ db

QSqlDatabase QSqlTableModelPrivate::db

Definition at line 87 of file qsqltablemodel_p.h.

Referenced by exec(), initRecordAndPrimaryIndex(), and nameToIndex().

◆ editBuffer

QSqlRecord QSqlTableModelPrivate::editBuffer

Definition at line 112 of file qsqltablemodel_p.h.

Referenced by clear(), and clearEditBuffer().

◆ editIndex

int QSqlTableModelPrivate::editIndex

Definition at line 88 of file qsqltablemodel_p.h.

Referenced by clear().

◆ editQuery

QSqlQuery QSqlTableModelPrivate::editQuery

Definition at line 96 of file qsqltablemodel_p.h.

Referenced by clear(), and exec().

◆ filter

QString QSqlTableModelPrivate::filter

Definition at line 99 of file qsqltablemodel_p.h.

Referenced by clear().

◆ insertIndex

int QSqlTableModelPrivate::insertIndex

Definition at line 89 of file qsqltablemodel_p.h.

Referenced by revertInsertedRow().

◆ primaryIndex

QSqlIndex QSqlTableModelPrivate::primaryIndex

Definition at line 97 of file qsqltablemodel_p.h.

Referenced by clear(), initRecordAndPrimaryIndex(), and primaryValues().

◆ sortColumn

int QSqlTableModelPrivate::sortColumn

Definition at line 91 of file qsqltablemodel_p.h.

Referenced by clear().

◆ sortOrder

Qt::SortOrder QSqlTableModelPrivate::sortOrder

Definition at line 92 of file qsqltablemodel_p.h.

Referenced by clear().

◆ strategy

QSqlTableModel::EditStrategy QSqlTableModelPrivate::strategy

Definition at line 94 of file qsqltablemodel_p.h.

Referenced by setRecord().

◆ tableName

QString QSqlTableModelPrivate::tableName

Definition at line 98 of file qsqltablemodel_p.h.

Referenced by clear(), and initRecordAndPrimaryIndex().

The documentation for this class was generated from the following files:
Qt 4.8 Source Code Browser