Lines Matching refs:statement

161     SQLiteStatement statement(database, "SELECT * FROM CachedPosition");
162 if (statement.prepare() != SQLResultOk)
165 if (statement.step() != SQLResultRow)
168 bool providesAltitude = statement.getColumnValue(2).type() != SQLValue::NullValue;
169 bool providesAltitudeAccuracy = statement.getColumnValue(4).type() != SQLValue::NullValue;
170 bool providesHeading = statement.getColumnValue(5).type() != SQLValue::NullValue;
171 bool providesSpeed = statement.getColumnValue(6).type() != SQLValue::NullValue;
172 RefPtr<Coordinates> coordinates = Coordinates::create(statement.getColumnDouble(0), // latitude
173 statement.getColumnDouble(1), // longitude
174 providesAltitude, statement.getColumnDouble(2), // altitude
175 statement.getColumnDouble(3), // accuracy
176 providesAltitudeAccuracy, statement.getColumnDouble(4), // altitudeAccuracy
177 providesHeading, statement.getColumnDouble(5), // heading
178 providesSpeed, statement.getColumnDouble(6)); // speed
179 DOMTimeStamp timestamp = statement.getColumnInt64(7); // timestamp
219 SQLiteStatement statement(database, "INSERT INTO CachedPosition ("
229 if (statement.prepare() != SQLResultOk)
232 statement.bindDouble(1, cachedPosition->coords()->latitude());
233 statement.bindDouble(2, cachedPosition->coords()->longitude());
235 statement.bindDouble(3, cachedPosition->coords()->altitude());
237 statement.bindNull(3);
238 statement.bindDouble(4, cachedPosition->coords()->accuracy());
240 statement.bindDouble(5, cachedPosition->coords()->altitudeAccuracy());
242 statement.bindNull(5);
244 statement.bindDouble(6, cachedPosition->coords()->heading());
246 statement.bindNull(6);
248 statement.bindDouble(7, cachedPosition->coords()->speed());
250 statement.bindNull(7);
251 statement.bindInt64(8, cachedPosition->timestamp());
253 if (!statement.executeCommand())