[chronojump] Removed name from encoder sql
- From: Xavier de Blas <xaviblas src gnome org>
- To: commits-list gnome org
- Cc:
- Subject: [chronojump] Removed name from encoder sql
- Date: Tue, 10 Apr 2012 16:18:20 +0000 (UTC)
commit 68b0bc4d18e41249f0f23aca329bff5975efee60
Author: Xavier de Blas <xaviblas gmail com>
Date: Tue Apr 10 18:17:48 2012 +0200
Removed name from encoder sql
diagrams/sqlite/chronojump_sqlite.dia | Bin 12855 -> 12849 bytes
diagrams/sqlite/chronojump_sqlite.png | Bin 157843 -> 157555 bytes
src/sqlite/encoder.cs | 7 +++----
3 files changed, 3 insertions(+), 4 deletions(-)
---
diff --git a/diagrams/sqlite/chronojump_sqlite.dia b/diagrams/sqlite/chronojump_sqlite.dia
index 554b1ac..7603870 100644
Binary files a/diagrams/sqlite/chronojump_sqlite.dia and b/diagrams/sqlite/chronojump_sqlite.dia differ
diff --git a/diagrams/sqlite/chronojump_sqlite.png b/diagrams/sqlite/chronojump_sqlite.png
index 475d98f..051de5e 100644
Binary files a/diagrams/sqlite/chronojump_sqlite.png and b/diagrams/sqlite/chronojump_sqlite.png differ
diff --git a/src/sqlite/encoder.cs b/src/sqlite/encoder.cs
index e14bb05..91cce3c 100644
--- a/src/sqlite/encoder.cs
+++ b/src/sqlite/encoder.cs
@@ -43,7 +43,6 @@ class SqliteEncoder : Sqlite
"uniqueID INTEGER PRIMARY KEY, " +
"personID INT, " +
"sessionID INT, " +
- "name TEXT, " +
"url TEXT, " +
"type TEXT, " + //"bar" or "jump"
"extraWeight TEXT, " + //string because can contain "33%" or "50Kg"
@@ -60,7 +59,7 @@ class SqliteEncoder : Sqlite
* Encoder class methods
*/
- public static int Insert(bool dbconOpened, string tableName, string uniqueID, int personID, int sessionID, string name, string url, string type, string extraWeight, string eccon, int time, int minHeight, float smooth, string description)
+ public static int Insert(bool dbconOpened, string tableName, string uniqueID, int personID, int sessionID, string url, string type, string extraWeight, string eccon, int time, int minHeight, float smooth, string description)
{
if(! dbconOpened)
dbcon.Open();
@@ -69,9 +68,9 @@ class SqliteEncoder : Sqlite
uniqueID = "NULL";
dbcmd.CommandText = "INSERT INTO " + tableName +
- " (uniqueID, personID, sessionID, name, url, type, extraWeight, econ, time, minHeight, smooth, description)" +
+ " (uniqueID, personID, sessionID, url, type, extraWeight, econ, time, minHeight, smooth, description)" +
" VALUES (" + uniqueID + ", "
- + personID + ", " + sessionID + ", '" + name + "', '" + url + "', '" + type + "', '"
+ + personID + ", " + sessionID + ", '" + url + "', '" + type + "', '"
+ extraWeight + "', '" + eccon + "', " + time + ", " + minHeight + ", "
+ Util.ConvertToPoint(smooth) + ", '" + description + "')" ;
Log.WriteLine(dbcmd.CommandText.ToString());
[
Date Prev][
Date Next] [
Thread Prev][
Thread Next]
[
Thread Index]
[
Date Index]
[
Author Index]