SQL examples for SQL Server

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM Drive';

EXEC (@MyQuery) AT [LS_TO_GOOGLE_DRIVE_IN_GATEWAY];

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM SharedDrives --WITH(Query=''name = "HR"'')';

EXEC (@MyQuery) AT [LS_TO_GOOGLE_DRIVE_IN_GATEWAY];

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM SharedDrives WITH(Query=''name = "HR"'')';

EXEC (@MyQuery) AT [LS_TO_GOOGLE_DRIVE_IN_GATEWAY];

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM Files
WITH(
	--Query=''name  contains "ZappySys*.*"'', --includes files where name contains "zappysys" word
)';

EXEC (@MyQuery) AT [LS_TO_GOOGLE_DRIVE_IN_GATEWAY];

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM Files
WITH(
	--Query=''name  contains "ZappySys*.*"'', --includes files where name contains "zappysys" word
	DriveId=''0AFWIggplk2z6Uk9PVA'', 
	DriveType=''drive'',
	SupportsAllDrives=''true'',
	IncludeItemsFromAllDrives=''true''
)';

EXEC (@MyQuery) AT [LS_TO_GOOGLE_DRIVE_IN_GATEWAY];

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM Files
WITH(
	--Query=''name  contains "ZappySys*.*"'', --includes files where name contains "zappysys" word
	DriveType=''allDrives'',
	SupportsAllDrives=''true'',
	IncludeItemsFromAllDrives=''true''
)';

EXEC (@MyQuery) AT [LS_TO_GOOGLE_DRIVE_IN_GATEWAY];

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM list_parent_items
WITH(
	--Parent folder id (Keep it blank to scan all files in all folders - recursive
	  FolderId=''1VK5NBhuOTaLEy1pBMsQtG672vrJNgxai''
	
	--List only from Trash (deleted files)
	, IncludeFromTrash=''false''
	
	--Extra search criteria
	--, Query=''or (name contains ''''blog'''') or (name contains ''''test'''') '' --extra query
	
	--Item type to return (default is all)
	--, ItemType=''files''	-- (default=all) all, files, folders, sheets, documents, files_native, files_exclude_native
	--, ItemType=''folders''
	--, ItemType=''sheets''
	--, ItemType=''files_native''
)';

EXEC (@MyQuery) AT [LS_TO_GOOGLE_DRIVE_IN_GATEWAY];

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM download_file
  WITH(Id=''1PpE2eSi5faAnMwiSolwr34zA5MwOdR3D''	
      ,ResponseDataFile=''C:\MyFiles\myfile.ext''
  )
  --You can get file Id by selecting from ''list_files'' endpoint';

EXEC (@MyQuery) AT [LS_TO_GOOGLE_DRIVE_IN_GATEWAY];

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM download_file
WITH(
	  DriveType=''drive'' --or set ''user'' for mydrive 
	, DriveId=''0AFWIggplk2z6Uk9PVA''
	, Id=''1hk7odj2Y2--yxN9DY0zW88hSnxqiyHq0'' --file id
	, ResponseDataFile=''c:\temp\dump.zip''
	--You can get file Id by selecting from ''list_files'' endpoint
)';

EXEC (@MyQuery) AT [LS_TO_GOOGLE_DRIVE_IN_GATEWAY];

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT *
FROM upload_file_overwrite
WITH(
	  DriveId='''' --for my drive keep blank
	--DriveId=''0AC00HWQH144cUk9PVA'' --team drive id (keep blank for uploading to my drive)
	
	, DiskFilePath=''C:\temp\dump.csv'' --source file path
	, FileName=''dump.csv'' --target file name
	, ParentFolderId=''root''
	--OR--
	--, ParentFolderId=''1PRySfNNjWIp9ZAnhPh-u9tKRj3QOETSq''

	--, FileOverwriteMode=''AlwaysOverwrite''
	--OR--
	--, FileOverwriteMode=''FailIfExists'' 
	
	--, KeepRevisionForever=''false''	
)';

EXEC (@MyQuery) AT [LS_TO_GOOGLE_DRIVE_IN_GATEWAY];

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM Files';

EXEC (@MyQuery) AT [LS_TO_GOOGLE_DRIVE_IN_GATEWAY];

DECLARE @MyQuery NVARCHAR(MAX) = 'UPDATE Files
  WITH (Id=''1EVzXFVBQIh3LcJvfcLhI1UWhW3qUxFkM''
  ,DiskFilePath=''C:\MyFiles\myfile.ext'')
  --You can get file Id by selecting from ''list_files'' endpoint';

EXEC (@MyQuery) AT [LS_TO_GOOGLE_DRIVE_IN_GATEWAY];

DECLARE @MyQuery NVARCHAR(MAX) = 'DELETE FROM Files
  WITH (Id=''1gcu0hV34OTfgvcu9CFhr7Go4b35j5Mop'')
  --You can get file Id by selecting from ''list_files'' endpoint';

EXEC (@MyQuery) AT [LS_TO_GOOGLE_DRIVE_IN_GATEWAY];

DECLARE @MyQuery NVARCHAR(MAX) = 'DELETE FROM Files where Name=''dump.csv'' and Trashed=0 WITH(DriveId=''0AC00HWQH144cUk9PVA'', DriveType=''drive'')
  --You can get file Id by selecting from ''list_files'' endpoint';

EXEC (@MyQuery) AT [LS_TO_GOOGLE_DRIVE_IN_GATEWAY];

DECLARE @MyQuery NVARCHAR(MAX) = 'INSERT INTO Files
  WITH (FileName=''My filename''
      ,DiskFilePath=''C:\MyFolder\Mymyfile.ext''
      ,ParentFolderId=''root''
	  )
  --You can get ParentFolderId by selecting from ''list_folders'' endpoint or just use ''root''';

EXEC (@MyQuery) AT [LS_TO_GOOGLE_DRIVE_IN_GATEWAY];

DECLARE @MyQuery NVARCHAR(MAX) = 'DELETE FROM Folders
  WITH (Id=''1yDO11prsLH9DUrBTCadV6GGMJrITjF9I'')
  --You can get folder Id by selecting from ''list_folders'' endpoint';

EXEC (@MyQuery) AT [LS_TO_GOOGLE_DRIVE_IN_GATEWAY];

DECLARE @MyQuery NVARCHAR(MAX) = 'INSERT INTO Folders
  WITH (Name=''My folder name''
      ,ParentFolderId=''root'')
  --You can get ParentFolderId by selecting from ''list_folders'' endpoint or just use ''root''';

EXEC (@MyQuery) AT [LS_TO_GOOGLE_DRIVE_IN_GATEWAY];

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM FileInfo
  WITH (Id=''1EVzXFVBQIh3LcJvfcLhI1UWhW3qUxFkM'')
  --You can get file Id by selecting from ''list_files'' endpoint';

EXEC (@MyQuery) AT [LS_TO_GOOGLE_DRIVE_IN_GATEWAY];

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM ItemsList';

EXEC (@MyQuery) AT [LS_TO_GOOGLE_DRIVE_IN_GATEWAY];

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT Id, Kind, Name, MimeType
  FROM list_items
  WITH (Query = ''name contains ''''.txt'''''')';

EXEC (@MyQuery) AT [LS_TO_GOOGLE_DRIVE_IN_GATEWAY];

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM FilesList';

EXEC (@MyQuery) AT [LS_TO_GOOGLE_DRIVE_IN_GATEWAY];

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM FoldersList';

EXEC (@MyQuery) AT [LS_TO_GOOGLE_DRIVE_IN_GATEWAY];

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM Trash';

EXEC (@MyQuery) AT [LS_TO_GOOGLE_DRIVE_IN_GATEWAY];

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM Trash
				WITH(
				    DriveType=''drive''
				   ,DriveId=''1j0HFOP4gsoExxxxxx'' 	--get id from select * from SharedDrives			   
				 )';

EXEC (@MyQuery) AT [LS_TO_GOOGLE_DRIVE_IN_GATEWAY];

DECLARE @MyQuery NVARCHAR(MAX) = 'DELETE FROM Trash';

EXEC (@MyQuery) AT [LS_TO_GOOGLE_DRIVE_IN_GATEWAY];

DECLARE @MyQuery NVARCHAR(MAX) = 'DELETE FROM Trash
				WITH(
				    DriveType=''drive''
				   ,DriveId=''1j0HFOP4gsoExxxxxx'' --get id from select * from SharedDrives
				 )';

EXEC (@MyQuery) AT [LS_TO_GOOGLE_DRIVE_IN_GATEWAY];

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT "Status" FROM export_file
				WITH(
                      Id=''1j0HFOP4gsoE-Zbf2xN3IsPSj8wgwNtIfyyvM1_BWkW4'' --//google sheet id or document ID
					  
				   --,DriveId=''xx your shared drive id''  --get id from select * from SharedDrives
				   --,DriveType=''drive''
					   
					 , ExportAs=''application/vnd.openxmlformats-officedocument.spreadsheetml.sheet''
				   --, ExportAs=''application/pdf''
					 , ResponseDataFile=''c:\temp\sheet1.xlsx''		
					 , FileOverwriteMode=''AlwaysOverwrite'' -- or try ''FailIfExists'' or ''SkipIfExists''					 
				))
			 --You can export files from ''export_file'' endpoint';

EXEC (@MyQuery) AT [LS_TO_GOOGLE_DRIVE_IN_GATEWAY];