- String name = n.getProperty(NodeProperty.NAME),\r
- path = n.getProperty(NodeProperty.PATH);\r
- Cursor c = this.getContentProvider().query(ProviderTableMeta.CONTENT_URI_FILE,\r
- null,\r
- ProviderTableMeta.FILE_NAME+"=? AND " + ProviderTableMeta.FILE_PATH + "=? AND " + ProviderTableMeta.FILE_ACCOUNT_OWNER + "=?",\r
- new String[]{name, path, this.getAccount().name},\r
- null);\r
- if (c.moveToFirst()) {\r
- this.getContentProvider().update(ProviderTableMeta.CONTENT_URI,\r
- cv,\r
- ProviderTableMeta._ID+"=?",\r
- new String[]{c.getString(c.getColumnIndex(ProviderTableMeta._ID))});\r
- Log.d(TAG, "ID of: "+name+":"+c.getString(c.getColumnIndex(ProviderTableMeta._ID)));\r
- } else {\r
- cv.put(ProviderTableMeta.FILE_NAME, n.getProperty(NodeProperty.NAME));\r
- cv.put(ProviderTableMeta.FILE_PATH, n.getProperty(NodeProperty.PATH));\r
- cv.put(ProviderTableMeta.FILE_ACCOUNT_OWNER, this.getAccount().name);\r
- Uri entry = this.getContentProvider().insert(ProviderTableMeta.CONTENT_URI_FILE, cv);\r
- Log.d(TAG, "Inserting new entry " + path + name);\r
- c = this.getContentProvider().query(entry, null, null, null, null);\r
- c.moveToFirst();\r
- }\r
- if (n.getProperty(NodeProperty.RESOURCE_TYPE).equals("DIR")) {\r
- commitToDatabase(n, c.getString(c.getColumnIndex(ProviderTableMeta._ID)));\r
- }\r
- }\r
- // clean removed files\r
- String[] selection = new String[root.getChildList().size()+2];\r
- selection[0] = this.getAccount().name;\r
- selection[1] = parentId;\r
- String qm = "";\r
- for (int i = 2; i < selection.length-1; ++i) {\r
- qm += "?,";\r
- selection[i] = root.getChildList().get(i-2).getProperty(NodeProperty.NAME);\r
- }\r
- if (selection.length >= 3) {\r
- selection[selection.length-1] = root.getChildrenNames()[selection.length-3];\r
- qm += "?";\r
- }\r
- for (int i = 0; i < selection.length; ++i) {\r
- Log.d(TAG,selection[i]+"");\r
- }\r
- Log.d(TAG,"Removing files "+ parentId);\r
- this.getContentProvider().delete(ProviderTableMeta.CONTENT_URI,\r
- ProviderTableMeta.FILE_ACCOUNT_OWNER+"=? AND " + ProviderTableMeta.FILE_PARENT + (parentId==null?" IS ":"=")+"? AND " + ProviderTableMeta.FILE_NAME + " NOT IN ("+qm+")",\r
- selection);\r
- }\r