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

The following examples show how to use android.database.sqlite.SQLiteStatement#bindDouble() . 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 check out the related API usage on the sidebar.
Example 1
Source File: X8AiLinePointLatlngInfoDao.java    From FimiX8-RE with 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 2
Source File: SQLitePlugin.java    From react-native-sqlite-storage with MIT License 6 votes vote down vote up
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 3
Source File: SQLiteAndroidDatabase.java    From react-native-sqlite-storage with MIT License 6 votes vote down vote up
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 4
Source File: MessageDao.java    From android-orm-benchmark-updated with Apache License 2.0 6 votes vote down vote up
@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 5
Source File: Benchmark.java    From sqlite-android with 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 6
Source File: GH2DataStaticInfoDao.java    From FimiX8-RE with 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 7
Source File: X8AiLinePointInfoDao.java    From FimiX8-RE with 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 8
Source File: SQLiteAndroidDatabase.java    From AvI with 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
Source File: OptimizedMessage.java    From android-orm-benchmark-updated with Apache License 2.0 5 votes vote down vote up
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 File: BJCameraDao.java    From Maps with 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
Source File: AndroidDB.java    From CodenameOne with GNU General Public License v2.0 5 votes vote down vote up
@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 File: SampleModel.java    From android-skeleton-project with 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 File: Session.java    From Android-ORM with 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
Source File: MessageDao.java    From android-orm-benchmark with Apache License 2.0 5 votes vote down vote up
/** @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
Source File: AndroidDatabaseConnection.java    From ormlite-android with ISC License 4 votes vote down vote up
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 16
Source File: SQLiteStatementTestCase.java    From SQLite-Performance with The Unlicense 4 votes vote down vote up
@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 17
Source File: MeasurementManager.java    From NoiseCapture with GNU General Public License v3.0 4 votes vote down vote up
/**
 * 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 File: PnDb.java    From PressureNet with 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 File: CbDb.java    From PressureNet-SDK with 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 File: CbDb.java    From PressureNet-SDK with 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;
}