Java Code Examples for android.database.sqlite.SQLiteStatement#bindDouble()

The following examples show how to use android.database.sqlite.SQLiteStatement#bindDouble() . These examples are extracted from open source projects. You can vote up the ones you like or vote down the ones you don't like, and go to the original project or source file by following the links above each example. You may want to check out the right sidebar which shows the related API usage.
Example 1
Source Project: FimiX8-RE   File: X8AiLinePointInfoDao.java    License: MIT License 6 votes vote down vote up
public final void bindValues(SQLiteStatement stmt, X8AiLinePointInfo entity) {
    stmt.clearBindings();
    Long id = entity.getId();
    if (id != null) {
        stmt.bindLong(1, id.longValue());
    }
    stmt.bindLong(2, entity.getTime());
    String name = entity.getName();
    if (name != null) {
        stmt.bindString(3, name);
    }
    stmt.bindLong(4, (long) entity.getType());
    stmt.bindLong(5, (long) entity.getSpeed());
    stmt.bindLong(6, (long) entity.getSaveFlag());
    stmt.bindDouble(7, (double) entity.getDistance());
    stmt.bindLong(8, (long) entity.getIsCurve());
    stmt.bindLong(9, (long) entity.getMapType());
    stmt.bindLong(10, (long) entity.getRunByMapOrVedio());
    stmt.bindLong(11, (long) entity.getDisconnectType());
    stmt.bindLong(12, (long) entity.getExcuteEnd());
    stmt.bindLong(13, (long) entity.getAutoRecord());
    String locality = entity.getLocality();
    if (locality != null) {
        stmt.bindString(14, locality);
    }
}
 
Example 2
Source Project: FimiX8-RE   File: X8AiLinePointLatlngInfoDao.java    License: MIT License 6 votes vote down vote up
public final void bindValues(SQLiteStatement stmt, X8AiLinePointLatlngInfo entity) {
    stmt.clearBindings();
    Long id = entity.getId();
    if (id != null) {
        stmt.bindLong(1, id.longValue());
    }
    stmt.bindLong(2, (long) entity.getNumber());
    stmt.bindLong(3, (long) entity.getTotalnumber());
    stmt.bindDouble(4, entity.getLongitude());
    stmt.bindDouble(5, entity.getLatitude());
    stmt.bindLong(6, (long) entity.getAltitude());
    stmt.bindDouble(7, (double) entity.getYaw());
    stmt.bindLong(8, (long) entity.getGimbalPitch());
    stmt.bindLong(9, (long) entity.getSpeed());
    stmt.bindLong(10, (long) entity.getYawMode());
    stmt.bindLong(11, (long) entity.getGimbalMode());
    stmt.bindLong(12, (long) entity.getTrajectoryMode());
    stmt.bindLong(13, (long) entity.getMissionFinishAction());
    stmt.bindLong(14, (long) entity.getRCLostAction());
    stmt.bindDouble(15, entity.getLongitudePOI());
    stmt.bindDouble(16, entity.getLatitudePOI());
    stmt.bindLong(17, (long) entity.getAltitudePOI());
    stmt.bindLong(18, entity.getLineId());
    stmt.bindLong(19, (long) entity.getPointActionCmd());
    stmt.bindLong(20, (long) entity.getRoration());
}
 
Example 3
Source Project: FimiX8-RE   File: GH2DataStaticInfoDao.java    License: MIT License 6 votes vote down vote up
public final void bindValues(SQLiteStatement stmt, GH2DataStaticInfo entity) {
    stmt.clearBindings();
    Long id = entity.getId();
    if (id != null) {
        stmt.bindLong(1, id.longValue());
    }
    String productModel = entity.getProductModel();
    if (productModel != null) {
        stmt.bindString(2, productModel);
    }
    stmt.bindLong(3, (long) entity.getHandleVersion());
    stmt.bindLong(4, (long) entity.getGimbalVersion());
    stmt.bindDouble(5, entity.getUseTime());
    stmt.bindDouble(6, entity.getLongitude());
    stmt.bindDouble(7, entity.getLatitude());
    String createTime = entity.getCreateTime();
    if (createTime != null) {
        stmt.bindString(8, createTime);
    }
}
 
Example 4
Source Project: sqlite-android   File: Benchmark.java    License: Apache License 2.0 6 votes vote down vote up
private void testAndroidSQLiteWrite(Statistics statistics) {
    Trace trace = new Trace("Android Write");
    SQLiteDatabase db = platformSQLite.getReadableDatabase();
    SQLiteStatement statement = db.compileStatement(
        String.format("insert into %s (%s, %s) values (?,?)",
            Record.TABLE_NAME,
            Record.COLUMN_CONTENT,
            Record.COLUMN_CREATED_TIME));
    try {
        db.beginTransaction();
        for (int i = 0; i < COUNT; i++) {
            Record record = Record.create(i);
            statement.bindString(1, record.getContent());
            statement.bindDouble(2, record.getCreatedTime());
            long id = statement.executeInsert();
            record.setId(id);
        }
        db.setTransactionSuccessful();
    } finally {
        db.endTransaction();
    }
    statistics.write( trace.exit() );
}
 
Example 5
@Override
protected final void bindValues(SQLiteStatement stmt, Message entity) {
    stmt.clearBindings();
 
    Long id = entity.getId();
    if (id != null) {
        stmt.bindLong(1, id);
    }
 
    String content = entity.getContent();
    if (content != null) {
        stmt.bindString(2, content);
    }
    stmt.bindLong(3, entity.getClient_id());
    stmt.bindLong(4, entity.getCreated_at());
    stmt.bindDouble(5, entity.getSorted_by());
    stmt.bindLong(6, entity.getCommand_id());
    stmt.bindLong(7, entity.getSender_id());
    stmt.bindLong(8, entity.getChannel_id());
}
 
Example 6
private void bindArgsToStatement(SQLiteStatement myStatement, ReadableArray sqlArgs) {
    if (sqlArgs == null)
        return;

    for (int i = 0; i < sqlArgs.size(); i++) {
        ReadableType type = sqlArgs.getType(i);
        if (type == ReadableType.Number) {
            double tmp = sqlArgs.getDouble(i);
            if (tmp == (long) tmp) {
                myStatement.bindLong(i + 1, (long) tmp);
            } else {
                myStatement.bindDouble(i + 1, tmp);
            }
        } else if (sqlArgs.isNull(i)) {
            myStatement.bindNull(i + 1);
        } else {
            myStatement.bindString(i + 1, sqlArgs.getString(i));
        }
    }
}
 
Example 7
private void bindArgsToStatement(SQLiteStatement myStatement, ReadableArray sqlArgs) {
    for (int i = 0; i < sqlArgs.size(); i++) {
        ReadableType type = sqlArgs.getType(i);
        if (type == ReadableType.Number){
            double tmp = sqlArgs.getDouble(i);
            if (tmp == (long) tmp) {
                myStatement.bindLong(i + 1, (long) tmp);
            } else {
                myStatement.bindDouble(i + 1, tmp);
            }
        } else if (sqlArgs.isNull(i)) {
            myStatement.bindNull(i + 1);
        } else {
            myStatement.bindString(i + 1, SQLitePluginConverter.getString(sqlArgs,i,""));
        }
    }
}
 
Example 8
Source Project: AvI   File: SQLiteAndroidDatabase.java    License: MIT License 5 votes vote down vote up
private void bindArgsToStatement(SQLiteStatement myStatement, JSONArray sqlArgs) throws JSONException {
    for (int i = 0; i < sqlArgs.length(); i++) {
        if (sqlArgs.get(i) instanceof Float || sqlArgs.get(i) instanceof Double) {
            myStatement.bindDouble(i + 1, sqlArgs.getDouble(i));
        } else if (sqlArgs.get(i) instanceof Number) {
            myStatement.bindLong(i + 1, sqlArgs.getLong(i));
        } else if (sqlArgs.isNull(i)) {
            myStatement.bindNull(i + 1);
        } else {
            myStatement.bindString(i + 1, sqlArgs.getString(i));
        }
    }
}
 
Example 9
public void prepareForInsert(final SQLiteStatement insertMessage) {
    insertMessage.bindString(1, mContent);
    insertMessage.bindDouble(2, mSortedBy);
    insertMessage.bindLong(3, mClientId);
    insertMessage.bindLong(4, mSenderId);
    insertMessage.bindLong(5, mChannelId);
    insertMessage.bindLong(6, mCommandId);
    insertMessage.bindLong(7, mCreatedAt);
}
 
Example 10
Source Project: Maps   File: BJCameraDao.java    License: GNU General Public License v2.0 5 votes vote down vote up
/** @inheritdoc */
@Override
protected void bindValues(SQLiteStatement stmt, BJCamera entity) {
    stmt.clearBindings();
 
    Long id = entity.getId();
    if (id != null) {
        stmt.bindLong(1, id);
    }
    stmt.bindString(2, entity.getName());
 
    String address = entity.getAddress();
    if (address != null) {
        stmt.bindString(3, address);
    }
 
    Double latitude = entity.getLatitude();
    if (latitude != null) {
        stmt.bindDouble(4, latitude);
    }
 
    Double longtitude = entity.getLongtitude();
    if (longtitude != null) {
        stmt.bindDouble(5, longtitude);
    }
 
    String direction = entity.getDirection();
    if (direction != null) {
        stmt.bindString(6, direction);
    }
}
 
Example 11
@Override
public void execute(String sql, Object... params) throws IOException {
    try {
        SQLiteStatement s = db.compileStatement(sql);
        for (int i = 0; i < params.length; i++) {
            Object p = params[i];
            if(p == null){
                s.bindNull(i + 1);
            }else{
                if(p instanceof String){
                    s.bindString(i + 1, (String)p);                    
                }else if(p instanceof byte[]){
                    s.bindBlob(i + 1, (byte [])p);
                }else if(p instanceof Double){
                    s.bindDouble(i + 1, ((Double)p).doubleValue());
                } else if(p instanceof Long){
                    s.bindLong(i + 1, ((Long)p).longValue());
                } else if(p instanceof Integer){
                    s.bindLong(i + 1, ((Integer)p).intValue());
                } else {
                    if(p != null) {
                        s.bindString(i + 1, p.toString());
                    }
                }
            }
        }
        s.execute();
        s.close();
    } catch (Exception e) {
        e.printStackTrace();
        throw new IOException(e.getMessage());
    }
    
}
 
Example 12
Source Project: android-skeleton-project   File: SampleModel.java    License: MIT License 5 votes vote down vote up
@Override
public void bindStatement(SQLiteStatement statement) throws SQLException {
    statement.bindLong(SQLITE.table.indexOf(ID), _id);
    statement.bindString(SQLITE.table.indexOf(SQLITE.COL_NAME), name);
    statement.bindDouble(SQLITE.table.indexOf(SQLITE.COL_1), field1);
    statement.bindDouble(SQLITE.table.indexOf(SQLITE.COL_2), field2);
}
 
Example 13
Source Project: Android-ORM   File: Session.java    License: Apache License 2.0 5 votes vote down vote up
static void bindStatement(SQLiteStatement stmt, int index,
        Object colValue) {
    Class<?> colClass = colValue.getClass();
    int i = index + 1;
    if (int.class == colClass || Integer.class == colClass) {
        stmt.bindLong(i, (Long) colValue);
    }
    else if (short.class == colClass || Short.class == colClass) {
        stmt.bindLong(i, (Long) colValue);
    }
    else if (long.class == colClass || Long.class == colClass) {
        stmt.bindLong(i, (Long) colValue);
    }
    else if (byte.class == colClass || Byte.class == colClass) {
        stmt.bindLong(i, (Long) colValue);
    }
    else if (float.class == colClass || Float.class == colClass) {
        stmt.bindDouble(i, (Double) colValue);
    }
    else if (double.class == colClass || Double.class == colClass) {
        stmt.bindDouble(i, (Double) colValue);
    }
    else if (byte[].class == colClass || Byte[].class == colClass) {
        stmt.bindBlob(i, (byte[]) colValue);
    }
    else if (boolean.class == colClass || Boolean.class == colClass) {
        stmt.bindLong(i, ((Boolean) colValue) ? 1 : 0);
    }
    else if (String.class == colClass) {
        stmt.bindString(i, (String) colValue);
    }
    else {
        stmt.bindString(i, (String) colValue);
    }
}
 
Example 14
/** @inheritdoc */
@Override
protected void bindValues(SQLiteStatement stmt, Message entity) {
    stmt.clearBindings();
 
    Long id = entity.getId();
    if (id != null) {
        stmt.bindLong(1, id);
    }
 
    String content = entity.getContent();
    if (content != null) {
        stmt.bindString(2, content);
    }
 
    Long client_id = entity.getClient_id();
    if (client_id != null) {
        stmt.bindLong(3, client_id);
    }
 
    Integer created_at = entity.getCreated_at();
    if (created_at != null) {
        stmt.bindLong(4, created_at);
    }
 
    Double sorted_by = entity.getSorted_by();
    if (sorted_by != null) {
        stmt.bindDouble(5, sorted_by);
    }
 
    Long command_id = entity.getCommand_id();
    if (command_id != null) {
        stmt.bindLong(6, command_id);
    }
    stmt.bindLong(7, entity.getSender_id());
    stmt.bindLong(8, entity.getChannel_id());
}
 
Example 15
@Override
public Metrics runCase() {
    mDbHelper = new DbHelper(App.getInstance(), getClass().getName());
    Metrics result = new Metrics(getClass().getSimpleName()+" ("+mInsertions+" insertions)", mTestSizeIndex);
    SQLiteDatabase db = mDbHelper.getWritableDatabase();

    Charset ascii = Charset.forName("US-ASCII");

    byte[] titleByteArry = new byte[50];
    byte[] urlByteArray = new byte[100];
    byte[] lyricsByteArray = new byte[2000];
    byte[] aboutByteArray = new byte[2000];

    result.started();
    db.beginTransaction();
    SQLiteStatement stmt = db.compileStatement("INSERT INTO tracks (id, title, band_id, duration, url, lyrics, about, release_date, mod_date) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)");
    for (int i = 0; i < mInsertions; i++) {
        mRandom.nextBytes(titleByteArry);
        mRandom.nextBytes(urlByteArray);
        mRandom.nextBytes(lyricsByteArray);
        mRandom.nextBytes(aboutByteArray);

        stmt.bindLong(1, i);
        stmt.bindString(2, new String(titleByteArry, ascii));
        stmt.bindLong(3, mRandom.nextInt());
        stmt.bindDouble(4, mRandom.nextDouble());
        stmt.bindString(5, new String(urlByteArray, ascii));
        stmt.bindString(6, new String(lyricsByteArray, ascii));
        stmt.bindString(7, new String(aboutByteArray, ascii));
        stmt.bindLong(8, mRandom.nextLong());
        stmt.bindLong(9, mRandom.nextLong());

        stmt.executeInsert();
        stmt.clearBindings();
    }
    db.setTransactionSuccessful();
    db.endTransaction();
    result.finished();

    return result;
}
 
Example 16
private void bindArgs(SQLiteStatement stmt, Object[] args, FieldType[] argFieldTypes) throws SQLException {
	if (args == null) {
		return;
	}
	for (int i = 0; i < args.length; i++) {
		Object arg = args[i];
		if (arg == null) {
			stmt.bindNull(i + 1);
		} else {
			SqlType sqlType = argFieldTypes[i].getSqlType();
			switch (sqlType) {
				case STRING:
				case LONG_STRING:
				case CHAR:
					stmt.bindString(i + 1, arg.toString());
					break;
				case BOOLEAN:
				case BYTE:
				case SHORT:
				case INTEGER:
				case LONG:
					stmt.bindLong(i + 1, ((Number) arg).longValue());
					break;
				case FLOAT:
				case DOUBLE:
					stmt.bindDouble(i + 1, ((Number) arg).doubleValue());
					break;
				case BYTE_ARRAY:
				case SERIALIZABLE:
					stmt.bindBlob(i + 1, (byte[]) arg);
					break;
				case DATE:
					// this is mapped to a STRING under Android
				case BLOB:
					// this is only for derby serializable
				case BIG_DECIMAL:
					// this should be handled as a STRING
					throw new SQLException("Invalid Android type: " + sqlType);
				case UNKNOWN:
				default:
					throw new SQLException("Unknown sql argument type: " + sqlType);
			}
		}
	}
}
 
Example 17
/**
 * Add multiple leq records
 * @param leqBatches List of Leq to add
 */
public void addLeqBatches(List<LeqBatch> leqBatches) {
    SQLiteDatabase database = storage.getWritableDatabase();
    try {
        database.beginTransaction();
        SQLiteStatement leqStatement = database.compileStatement(
                "INSERT INTO " + Storage.Leq.TABLE_NAME + "(" +
                        Storage.Leq.COLUMN_RECORD_ID + "," +
                        Storage.Leq.COLUMN_LEQ_UTC + "," +
                        Storage.Leq.COLUMN_LATITUDE  + "," +
                        Storage.Leq.COLUMN_LONGITUDE  + "," +
                        Storage.Leq.COLUMN_ALTITUDE  + "," +
                        Storage.Leq.COLUMN_ACCURACY  + "," +
                        Storage.Leq.COLUMN_LOCATION_UTC + "," +
                        Storage.Leq.COLUMN_SPEED + "," +
                        Storage.Leq.COLUMN_BEARING +
                        ") VALUES (?, ?,?,?,?,?,?,?,?)");
        SQLiteStatement leqValueStatement = database.compileStatement("INSERT INTO " +
                Storage.LeqValue.TABLE_NAME + " VALUES (?,?,?)");
        for(LeqBatch leqBatch : leqBatches) {
            Storage.Leq leq = leqBatch.getLeq();
            leqStatement.clearBindings();
            leqStatement.bindLong(1, leq.getRecordId());
            leqStatement.bindLong(2, leq.getLeqUtc());
            leqStatement.bindDouble(3, leq.getLatitude());
            leqStatement.bindDouble(4, leq.getLongitude());
            if(leq.getAltitude() != null) {
                leqStatement.bindDouble(5, leq.getAltitude());
            } else {
                leqStatement.bindNull(5);
            }
            leqStatement.bindDouble(6, leq.getAccuracy());
            leqStatement.bindDouble(7, leq.getLocationUTC());
            if(leq.getSpeed() != null) {
                leqStatement.bindDouble(8, leq.getSpeed());
            } else {
                leqStatement.bindNull(8);
            }
            if(leq.getBearing() != null) {
                leqStatement.bindDouble(9, leq.getBearing());
            } else {
                leqStatement.bindNull(9);
            }
            long leqId = leqStatement.executeInsert();
            for(Storage.LeqValue leqValue : leqBatch.getLeqValues()) {
                leqValueStatement.clearBindings();
                leqValueStatement.bindLong(1, leqId);
                leqValueStatement.bindLong(2, leqValue.getFrequency());
                leqValueStatement.bindDouble(3, leqValue.getSpl());
                leqValueStatement.execute();
            }
        }
        database.setTransactionSuccessful();
        database.endTransaction();
    } finally {
        database.close();
    }
}
 
Example 18
Source Project: PressureNet   File: PnDb.java    License: GNU General Public License v3.0 4 votes vote down vote up
public boolean addTemperatureForecastArrayList(ArrayList<TemperatureForecast> tempForecasts) {
	
	try {
		mDB.beginTransaction();
	} catch(SQLiteDatabaseLockedException sqldble) {
		// This try/catch block is a bad hack. Refactor db usaage to use only one lock
		// regardless of the thread
		
	}
	
	String insertSQL = "INSERT INTO "
			+ TEMPERATURES
			+ " ("
			+ KEY_FORECAST_LOCATION_ID
			+ ", "
			+ KEY_TEMP_FORECAST_START_TIME
			+ ", "
			+ KEY_TEMP_FORECAST_HOUR
			+ ", "
			+ KEY_TEMP_FORECAST_SCALE
			+ ", "
			+ KEY_TEMP_FORECAST_VALUE
			+ ") values (?, ?, ?, ?, ?)";

	try {
		SQLiteStatement insert = mDB.compileStatement(insertSQL);
		for (TemperatureForecast temp : tempForecasts) {
			insert.bindString(1, temp.getLocationID());
			insert.bindString(2, temp.getStartTime());
			insert.bindLong(3, temp.getForecastHour());
			insert.bindLong(4, temp.getScale());
			insert.bindDouble(5, temp.getTemperatureValue());
			insert.executeInsert();
		}

		mDB.setTransactionSuccessful();
	} catch (SQLException sqle) {
		sqle.printStackTrace();
	} finally {
		mDB.endTransaction();
	}

	return true;
}
 
Example 19
Source Project: PressureNet-SDK   File: CbDb.java    License: MIT License 4 votes vote down vote up
public boolean addCurrentConditionArrayList(ArrayList<CbWeather> weather) {

		
		try {
			mDB.beginTransaction();
		} catch(SQLiteDatabaseLockedException sqldble) {
			// This try/catch block is a bad hack. Refactor db usaage to use only one lock
			// regardless of the thread
			
		}
		
		String insertSQL = "INSERT INTO "
				+ CURRENT_CONDITIONS_TABLE
				+ " ("
				+ KEY_LATITUDE
				+ ", "
				+ KEY_LONGITUDE
				+ ", "
				+ KEY_ALTITUDE
				+ ", "
				+ KEY_ACCURACY
				+ ", "
				+ KEY_PROVIDER
				+ ", "
				+ KEY_SHARING
				+ ", "
				+ KEY_TIME
				+ ", "
				+ KEY_TIMEZONE
				+ ", "
				+ KEY_USERID
				+ ", "
				+ KEY_GENERAL_CONDITION
				+ ", "
				+ KEY_WINDY
				+ ", "
				+ KEY_FOGGY
				+ ", "
				+ KEY_CLOUD_TYPE
				+ ", "
				+ KEY_PRECIPITATION_TYPE
				+ ", "
				+ KEY_PRECIPITATION_AMOUNT
				+ ", "
				+ KEY_PRECIPITATION_UNIT
				+ ", "
				+ KEY_THUNDERSTORM_INTENSITY
				+ ", "
				+ KEY_USER_COMMENT
				+ ") values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";

		try {
			SQLiteStatement insert = mDB.compileStatement(insertSQL);
			for (CbWeather weatherItem : weather) {
				CbCurrentCondition condition = (CbCurrentCondition) weatherItem;
				insert.bindDouble(1, condition.getLocation().getLatitude());
				insert.bindDouble(2, condition.getLocation().getLongitude());
				insert.bindDouble(3, condition.getLocation().getAltitude());
				insert.bindDouble(4, condition.getLocation().getAccuracy());
				insert.bindString(5, condition.getLocation().getProvider());
				insert.bindString(6, condition.getSharing_policy());
				insert.bindLong(7, condition.getTime());
				insert.bindLong(8, condition.getTzoffset());
				insert.bindString(9, condition.getUser_id());
				insert.bindString(10, condition.getGeneral_condition());
				insert.bindString(11, condition.getWindy());
				insert.bindString(12, condition.getFog_thickness());
				insert.bindString(13, condition.getCloud_type());
				insert.bindString(14, condition.getPrecipitation_type());
				insert.bindDouble(15, condition.getPrecipitation_amount());
				insert.bindString(16, condition.getPrecipitation_unit());
				insert.bindString(17, condition.getThunderstorm_intensity());
				insert.bindString(18, condition.getUser_comment());
				insert.executeInsert();
			}

			mDB.setTransactionSuccessful();
		} catch (SQLException sqle) {
			sqle.printStackTrace();
		} finally {
			mDB.endTransaction();
		}

		return true;
	}
 
Example 20
Source Project: PressureNet-SDK   File: CbDb.java    License: MIT License 4 votes vote down vote up
/**
 * Add a new Observations in an ArrayList
 * 
 * @return
 */
public boolean addObservationArrayList(ArrayList<CbWeather> weather, CbApiCall api) {
	mDB.beginTransaction();

	String insertSQL = "INSERT INTO "
			+ API_LIST_TABLE
			+ " ("
			+ KEY_LATITUDE
			+ ", "
			+ KEY_LONGITUDE
			+ ", "
			+ KEY_ALTITUDE
			+ ", "
			+ KEY_TIME
			+ ", " 
			+ KEY_OBSERVATION_VALUE
			+ " "
			+ ") values (?, ?, ?, ?, ?)";
	try {
		SQLiteStatement insert = mDB.compileStatement(insertSQL);
		
		for (CbWeather weatherItem : weather) {
			
			CbObservation ob = (CbObservation) weatherItem;
			double latitude = ob.getLocation().getLatitude(); 
			double longitude = ob.getLocation().getLongitude();
			double altitude = ob.getLocation().getAltitude();
			insert.bindDouble(1, latitude);
			insert.bindDouble(2, longitude); 
			insert.bindDouble(3, altitude);
			insert.bindLong(4, ob.getTime());
			insert.bindDouble(5, ob.getObservationValue());
			insert.executeInsert();
		}

		mDB.setTransactionSuccessful();
		
	} catch (SQLException sqle) {
		sqle.printStackTrace();
	} finally {
		mDB.endTransaction();
	}
	return true;
}