Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>the problem that I had, is how to create folders path in google drive without ending up with duplicates folders in the dirve!</p> <p>the first function used to check where the folder is exist from its title, pass your drive instance and the folder's title and it's parents Id (not the title):</p> <p><pre><code> /** * * @param service google drive instance * @param title the title (name) of the folder (the one you search for) * @param parentId the parent Id of this folder (use root) if the folder is in the main directory of google drive * @return google drive file object * @throws IOException */ private File getExistsFolder(Drive service,String title,String parentId) throws IOException { Drive.Files.List request; request = service.files().list(); String query = "mimeType='application/vnd.google-apps.folder' AND trashed=false AND title='" + title + "' AND '" + parentId + "' in parents"; Logger.info(TAG + ": isFolderExists(): Query= " + query); request = request.setQ(query); FileList files = request.execute(); Logger.info(TAG + ": isFolderExists(): List Size =" + files.getItems().size()); if (files.getItems().size() == 0) //if the size is zero, then the folder doesn't exist return null; else //since google drive allows to have multiple folders with the same title (name) //we select the first file in the list to return return files.getItems().get(0); } </code></pre></p> <p>the function used to create a folder inside the givien parents references, if the list is empty, then the folder will be created in google drive's root directory.</p> <pre><code>/** * * @param service google drive instance * @param title the folder's title * @param listParentReference the list of parents references where you want the folder to be created, * if you have more than one parent references, then a folder will be created in each one of them * @return google drive file object * @throws IOException */ private File createFolder(Drive service,String title,List&lt;ParentReference&gt; listParentReference) throws IOException { File body = new File(); body.setTitle(title); body.setParents(listParentReference); body.setMimeType("application/vnd.google-apps.folder"); File file = service.files().insert(body).execute(); return file; } </code></pre> <p>the third function used to create a directory path of the folders without duplicates in google drive. in order to prevent duplicate folders in google drive, the function will check whether the folder is exist or not before creating it.</p> <pre><code>/** * * @param service google drive instance * @param titles list of folders titles * i.e. if your path like this folder1/folder2/folder3 then pass them in this order createFoldersPath(service, folder1, folder2, folder3) * @return parent reference of the last added folder in case you want to use it to create a file inside this folder. * @throws IOException */ private List&lt;ParentReference&gt; createFoldersPath(Drive service,String...titles) throws IOException { List&lt;ParentReference&gt; listParentReference = new ArrayList&lt;ParentReference&gt;(); File file = null; for(int i=0;i&lt;titles.length;i++) { file = getExistsFolder(service, titles[i], (file==null)?"root":file.getId()); if (file == null) { file = createFolder(service, titles[i], listParentReference); } listParentReference.clear(); listParentReference.add(new ParentReference().setId(file.getId())); } return listParentReference; } </code></pre>
    singulars
    1. This table or related slice is empty.
    1. POHow to create folders in google drive without duplicate?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USmoh.sukhni
    1. USmoh.sukhni
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POHow to create folders in google drive without duplicate?
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    1. This table or related slice is empty.
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload