private static Record SqliteStmtToRecord(ISQLiteStatement stmt)
{
return(new Record(stmt.GetText(RecordColumns.KEY),
stmt.DataType(RecordColumns.VALUE) == SQLiteType.NULL ? null : stmt.GetText(RecordColumns.VALUE),
stmt.GetInteger(RecordColumns.SYNC_COUNT),
new DateTime(long.Parse(stmt.GetText(RecordColumns.LAST_MODIFIED_TIMESTAMP), CultureInfo.InvariantCulture.NumberFormat), DateTimeKind.Utc),
stmt.DataType(RecordColumns.LAST_MODIFIED_BY) == SQLiteType.NULL ? string.Empty : stmt.GetText(RecordColumns.LAST_MODIFIED_BY),
new DateTime(long.Parse(stmt.GetText(RecordColumns.DEVICE_LAST_MODIFIED_TIMESTAMP), CultureInfo.InvariantCulture.NumberFormat), DateTimeKind.Utc),
stmt.GetInteger(RecordColumns.MODIFIED) == 1));
}
private static DatasetMetadata SqliteStmtToDatasetMetadata(ISQLiteStatement stmt)
{
return(new DatasetMetadata(
stmt.DataType(RecordColumns.DATASET_NAME) == SQLiteType.NULL ? string.Empty : stmt.GetText(DatasetColumns.DATASET_NAME),
new DateTime(long.Parse(stmt.GetText(DatasetColumns.CREATION_TIMESTAMP))),
new DateTime(long.Parse(stmt.GetText(DatasetColumns.LAST_MODIFIED_TIMESTAMP))),
stmt.DataType(DatasetColumns.LAST_MODIFIED_BY) == SQLiteType.NULL ? string.Empty : stmt.GetText(DatasetColumns.LAST_MODIFIED_BY),
stmt.GetInteger(DatasetColumns.STORAGE_SIZE_BYTES),
stmt.GetInteger(DatasetColumns.RECORD_COUNT)
));
}
public List <GV.DATA_INFO_STRING> GetDataRecord(SQLiteConnection conn, string sql)
{
List <GV.DATA_INFO_STRING> entries = new List <GV.DATA_INFO_STRING>();
using (ISQLiteStatement dbState = GV.connection.Prepare(sql))
{
while (dbState.Step() == SQLiteResult.ROW)
{
entries.Add(
new GV.DATA_INFO_STRING
{
Key = dbState.GetInteger(0),
ID = dbState.GetText(1),
EventType = dbState.GetText(2),
EventTime = dbState.GetText(3),
Cadence = dbState.GetText(4),
Power = dbState.GetText(5),
Resistance = dbState.GetText(6),
HandleP = dbState.GetText(7),
SaddleP = dbState.GetText(8),
PedalLeftP = dbState.GetText(9),
PedalLeftAcc = dbState.GetText(10),
PeadlLeftGyro = dbState.GetText(11),
PeadlRightP = dbState.GetText(12),
PedalRightAcc = dbState.GetText(13),
PeadlRightGyro = dbState.GetText(14),
CrankAcc = dbState.GetText(15),
CrankGyro = dbState.GetText(16)
});
}
}
return(entries.ToList <GV.DATA_INFO_STRING>());
}
public long LookupSoupEntryId(string soupName, string fieldPath, string fieldValue)
{
lock (smartlock)
{
DBHelper db = Database;
string soupTableName = db.GetSoupTableName(soupName);
if (String.IsNullOrWhiteSpace(soupTableName))
{
throw new SmartStoreException("Soup: " + soupName + " does not exist");
}
string columnName = db.GetColumnNameForPath(soupName, fieldPath);
using (ISQLiteStatement statement = db.Query(soupTableName, new[] { IdCol }, String.Empty, String.Empty,
columnName + " = ?", fieldValue))
{
if (statement.DataCount > 1)
{
throw new SmartStoreException(String.Format(
"There are more than one soup elements where {0} is {1}", fieldPath, fieldValue));
}
if (statement.DataCount == 1)
{
return(statement.GetInteger(0));
}
}
return(-1); // not found
}
}
/// <summary>
/// 조회된 한 로우에 대한 데이터를 생성한다.
/// </summary>
/// <param name="stmt">DB 구문 객체</param>
/// <returns>파일 정보</returns>
private StorageItemInfo GetRowData(ISQLiteStatement stmt)
{
return(new StorageItemInfo()
{
Path = stmt.GetText("PATH"),
SubType = (SubType)stmt.GetInteger("FOLDER_TYPE"),
Name = stmt.GetText("NAME"),
RootPath = stmt.GetText("ROOT_PATH"),
FalToken = stmt.GetText2("FAL_TOKEN")
});
}
/// <summary>
/// 조회된 한 로우에 대한 데이터를 생성한다.
/// </summary>
/// <param name="stmt">DB 구문 객체</param>
/// <returns>파일 정보</returns>
private FolderInfo GetRowData(ISQLiteStatement stmt)
{
return(new FolderInfo()
{
Type = (FolderType)stmt.GetInteger("FOLDER_TYPE"),
Level = stmt.GetInteger2("LEVEL"),
Name = stmt.GetText("NAME"),
Path = stmt.GetText("PATH"),
FalToken = stmt.GetText2("FAL_TOKEN"),
Passcode = stmt.GetText2("PASSCODE")
});
}
private string GetSoupTableNameFromDb(string soupName)
{
using (
ISQLiteStatement stmt = Query(SmartStore.SoupNamesTable, new[] { SmartStore.IdCol }, String.Empty,
String.Empty,
SmartStore.SoupNamePredicate, soupName))
{
if (stmt.DataCount == 0)
{
return(null);
}
return(SmartStore.GetSoupTableName(stmt.GetInteger(SmartStore.IdCol)));
}
}
public long GetNextId(string tableName)
{
using (ISQLiteStatement prog = _sqlConnection.Prepare((SeqSelect)))
{
prog.Bind(1, tableName);
SQLiteResult result = prog.Step();
long data = 0;
if (prog.DataCount > 0)
{
data = prog.GetInteger(0);
}
return(data + 1);
}
}
public long CountRawCountQuery(string countSql, params string[] args)
{
using (ISQLiteStatement prog = _sqlConnection.Prepare((countSql)))
{
if (args != null)
{
for (int i = 0; i < args.Length; i++)
{
prog.Bind(i + 1, args[i]);
}
}
SQLiteResult result = prog.Step();
if (result == SQLiteResult.ROW)
{
return(prog.GetInteger(0));
}
}
return(0);
}
/// <summary>
/// Helper to retrieve data.
/// </summary>
/// <param name="statement"></param>
/// <param name="position"></param>
/// <returns></returns>
private object GetObject(ISQLiteStatement statement, int position)
{
try
{
return(statement.GetText(position));
}
catch (Exception) { }
try
{
return(statement.GetInteger(position));
}
catch (Exception) { }
try
{
return(statement.GetFloat(position));
}
catch (Exception) { }
return(null);
}
/// <summary>
/// Helper to retrieve data.
/// </summary>
/// <param name="statement"></param>
/// <param name="position"></param>
/// <returns></returns>
private object GetObject(ISQLiteStatement statement, int position)
{
try
{
return statement.GetText(position);
}
catch (Exception) { }
try
{
return statement.GetInteger(position);
}
catch (Exception) { }
try
{
return statement.GetFloat(position);
}
catch (Exception) { }
return null;
}
private static Record SqliteStmtToRecord(ISQLiteStatement stmt)
{
return new Record(stmt.GetText(RecordColumns.KEY),
stmt.GetText(RecordColumns.VALUE),
stmt.GetInteger(RecordColumns.SYNC_COUNT),
new DateTime(long.Parse(stmt.GetText(RecordColumns.LAST_MODIFIED_TIMESTAMP))),
stmt.DataType(RecordColumns.LAST_MODIFIED_BY) == SQLiteType.NULL ? string.Empty : stmt.GetText(RecordColumns.LAST_MODIFIED_BY),
new DateTime(long.Parse(stmt.GetText(RecordColumns.DEVICE_LAST_MODIFIED_TIMESTAMP))),
stmt.GetInteger(RecordColumns.MODIFIED) == 1);
}
private static DatasetMetadata SqliteStmtToDatasetMetadata(ISQLiteStatement stmt)
{
return new DatasetMetadata(
stmt.DataType(RecordColumns.DATASET_NAME) == SQLiteType.NULL ?string.Empty:stmt.GetText(DatasetColumns.DATASET_NAME),
new DateTime(long.Parse(stmt.GetText(DatasetColumns.CREATION_TIMESTAMP))),
new DateTime(long.Parse(stmt.GetText(DatasetColumns.LAST_MODIFIED_TIMESTAMP))),
stmt.DataType(DatasetColumns.LAST_MODIFIED_BY) == SQLiteType.NULL ? string.Empty : stmt.GetText(DatasetColumns.LAST_MODIFIED_BY),
stmt.GetInteger(DatasetColumns.STORAGE_SIZE_BYTES),
stmt.GetInteger(DatasetColumns.RECORD_COUNT)
);
}
