1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
| public class DataBaseCore extends SQLiteOpenHelper {
private static final int DATABASE_VERSION = 1;
private static final String DATABASE_NAME = "TestDB";
public SQLiteDatabase DataBase;
public DataBaseCore(Context context) {
super(context, DATABASE_NAME, null, DATABASE_VERSION);
try {
DataBase = this.getWritableDatabase();
} catch (SQLiteException ex){
DataBase = this.getReadableDatabase();
}
}
@Override
public void onCreate(SQLiteDatabase db) {
String CREATE_DB = "CREATE TABLE `Desired` (`id` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL , `goodid` INTEGER NOT NULL );" +
"CREATE TABLE `Goods` (`id` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL , `VKGoodID` INTEGER NOT NULL , `CategoryID` INTEGER NOT NULL , `Title` VARCHAR(56) NOT NULL , `Description` TEXT, `Date` TimeStamp NOT NULL , `OwnerID` INTEGER NOT NULL , `Price` FLOAT NOT NULL DEFAULT 0, `Currency` VARCHAR(5) NOT NULL , `Thumb` TEXT);" +
"CREATE TABLE `Sections` (`id` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL , `SectionVKID` INTEGER NOT NULL , `Name` VARCHAR(24) NOT NULL );" +
"CREATE TABLE `categories` (`id` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL , `VKCatID` INTEGER NOT NULL , `SectionID` INTEGER NOT NULL , `Name` VARCHAR(24) NOT NULL );" +
"CREATE TABLE `sellers` (`id` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL UNIQUE , `Name` VARCHAR(56) NOT NULL , `SellerVKID` INTEGER NOT NULL );";
db.execSQL(CREATE_DB);
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
db.execSQL("DROP TABLE IF EXISTS `Desired`;" +
"DROP TABLE IF EXISTS `Goods`;" +
"DROP TABLE IF EXISTS `Sections`;" +
"DROP TABLE IF EXISTS `categories`;" +
"DROP TABLE IF EXISTS `sellers`");
onCreate(db);
}
public void categoriesUpdate() {
//onUpgrade(DataBase, 1, 2);
VKRequest request = new VKRequest("market.getCategories", VKParameters.from("count", 200));
request.executeWithListener(new VKRequest.VKRequestListener() {
@Override
public void onComplete(VKResponse response) {
try{
//парсим список категорий
JSONObject jsonObject = new JSONObject(response.responseString);
JSONObject resp = jsonObject.getJSONObject("response");
Category[] CatList = new Category[resp.getInt("count")];
ArrayList<Category> Section = new ArrayList<Category>();
JSONArray parray = resp.getJSONArray("items");
int LastSectionID = -1;
//Очищаем список категорий и подкатегорий
DataBase.execSQL("DELETE FROM `categories`"); // вообще крашится уже на этой строке с аналогичной ошибкой, но если эти две строки закомментировать, на инсерты не ругается вообще
DataBase.execSQL("DELETE FROM `Sections`");
Cursor cur = DataBase.rawQuery("select * from sqlite_master where type = 'table'", null);
cur.moveToFirst();
while (cur.isAfterLast()){
Log.w("TABLE NAME", cur.getString(0));
cur.moveToNext();
}
cur.close();
for (int i = 0; i < parray.length(); i++) { //Заносим новые данные в таблицы
JSONObject tmp = parray.getJSONObject(i);
JSONObject tmp2 = tmp.getJSONObject("Section");
ContentValues newCatLine = new ContentValues();
newCatLine.put("VKCatID", tmp.getInt("id"));
newCatLine.put("SectionID", tmp2.getInt("id"));
newCatLine.put("Name", tmp.getString("name"));
DataBase.insert("categories", null, newCatLine);
if (LastSectionID!=tmp2.getInt("id")) {
ContentValues newValues = new ContentValues();
newValues.put("SectionVKID", tmp2.getInt("id"));
newValues.put("Name", tmp2.getString("name"));
DataBase.insert("Sections", null, newValues);
LastSectionID = tmp2.getInt("id");
}
}
//draw (ProductList);
} catch (JSONException e){
Log.e("ERROR_VK_JSON", e.toString());
}
}
@Override
public void onError(VKError error) {
Log.e("ERROR_VK", error.toString());
}
@Override
public void attemptFailed(VKRequest request, int attemptNumber, int totalAttempts) {
Log.e("ERROR_VK", "Request is Failed");
}
});
}
} |
(
