// Update is called once per frame
private void Update()
{
if (Instance == null)
{
Init();
}
var notification = PopNotification();
if (!string.IsNullOrEmpty(notification))
{
Debug.Log(notification);
ShowNotification(new GUIContent(notification));
}
if (!string.IsNullOrEmpty(UpdateMessage))
{
Debug.Log(UpdateMessage);
UpdateMessage = string.Empty;
}
if ((DateTime.Now - LastEllipses).Milliseconds > 500)
{
LastEllipses = DateTime.Now;
EllipsesCount += 1;
if (EllipsesCount > 5)
{
EllipsesCount = 2;
}
Ellipses = string.Empty;
for (var i = 0; i < EllipsesCount; ++i)
{
Ellipses += ".";
}
Repaint();
}
// Detect Skin Changes
var oldUseDarkSkin = UseDarkSkin;
if (EditorGUIUtility.isProSkin)
{
UseDarkSkin = true;
if (oldUseDarkSkin != UseDarkSkin)
{
LoadStyles();
}
}
if (IsDirty)
{
Google2uGUIUtil.Save();
IsDirty = false;
}
// Prevent Google2u from doing anything while in play mode
if (EditorApplication.isPlayingOrWillChangePlaymode || EditorApplication.isCompiling)
{
return;
}
if ((DateTime.Now - LastCheckedRSS).Hours > 0)
{
LastCheckedRSS = DateTime.Now;
var t = new Thread(CheckForService);
t.Start();
}
if (InstanceData.Commands.Contains(GFCommand.DoLogout))
{
InstanceData.Commands.Remove(GFCommand.DoLogout);
var t = new Thread(DoLogout)
{
Name = "DoLogout"
};
t.Start(InstanceData);
}
if (InstanceData.Commands.Contains(GFCommand.RetrieveWorkbooks))
{
InstanceData.Commands.Remove(GFCommand.RetrieveWorkbooks);
InstanceData.Commands.Add(GFCommand.WaitForRetrievingWorkbooks);
InstanceData.AccountWorkbooks.Clear();
var t = new Thread(DoWorkbookQuery)
{
Name = "RetrieveWorkbooks"
};
t.Start(InstanceData);
}
if (InstanceData.Commands.Contains(GFCommand.RetrieveManualWorkbooks))
{
InstanceData.Commands.Remove(GFCommand.RetrieveManualWorkbooks);
InstanceData.Commands.Add(GFCommand.WaitForRetrievingManualWorkbooks);
var t = new Thread(DoManualWorkbookRetrieval)
{
Name = "ManualWorkbookRetrieval"
};
t.Start(InstanceData);
}
if (InstanceData.Commands.Contains(GFCommand.ManualWorkbooksRetrievalComplete))
{
InstanceData.Commands.Remove(GFCommand.ManualWorkbooksRetrievalComplete);
var manualWorkbooksString = InstanceData.ManualWorkbooks.Aggregate(string.Empty,
(in_current, in_wb) => in_current + (in_wb.WorkbookUrl + "|"));
Google2uGUIUtil.SetString(InstanceData.ProjectPath + "_ManualWorkbookCache", manualWorkbooksString);
}
if (InstanceData.Commands.Contains(GFCommand.DoUpload))
{
InstanceData.Commands.Remove(GFCommand.DoUpload);
InstanceData.Commands.Add(GFCommand.WaitingForUpload);
var t = new Thread(DoWorkbookUpload)
{
Name = "WorkbookUpload"
};
t.Start(InstanceData);
}
if (InstanceData.Commands.Contains(GFCommand.UploadComplete))
{
InstanceData.Commands.Remove(GFCommand.UploadComplete);
InstanceData.WorkbookUploadProgress = 0;
InstanceData.AccountWorkbooks.Clear();
InstanceData.Commands.Add(GFCommand.RetrieveWorkbooks);
}
foreach (var Google2uSpreadsheet in InstanceData.AccountWorkbooksDisplay)
{
Google2uSpreadsheet.Update();
}
foreach (var Google2uSpreadsheet in InstanceData.ManualWorkbooksDisplay)
{
Google2uSpreadsheet.Update();
}
if (ObjDbExport != null && ObjDbExport.Count > 0)
{
var dbInfo = ObjDbExport[0];
if (dbInfo == null)
{
ObjDbExport.RemoveAt(0);
return;
}
if ((DateTime.Now - dbInfo.LastAttempt).TotalSeconds < 2)
{
return;
}
if (dbInfo.ReloadedAssets == false)
{
AssetDatabase.Refresh(ImportAssetOptions.ForceUpdate);
dbInfo.ReloadedAssets = true;
return;
}
dbInfo.LastAttempt = DateTime.Now;
Component comp = null;
var myAssetPath = string.Empty;
Debug.Log("Looking for Database Script: " + dbInfo.ScriptName);
var findAssetArray = AssetDatabase.FindAssets(dbInfo.ScriptName);
if (findAssetArray.Length > 0)
{
foreach (var s in findAssetArray)
{
var mypath = AssetDatabase.GUIDToAssetPath(s);
if (mypath.EndsWith(".cs"))
{
myAssetPath = mypath;
Debug.Log("Found Database Script at: " + mypath);
}
}
var myType = GetAssemblyType("Google2u." + dbInfo.ScriptName);
Debug.Log(dbInfo.ScriptName + ": GetAssemblyType returns " + myType);
if (myType != null)
{
var go = GameObject.Find(dbInfo.ObjectName) ?? new GameObject(dbInfo.ObjectName);
var toDestroy = go.GetComponent(dbInfo.ScriptName);
if (toDestroy != null)
{
DestroyImmediate(toDestroy);
}
#if UNITY_5
comp = go.AddComponent(myType);
#else
comp = go.AddComponent(dbInfo.ScriptName);
#endif
}
}
if (comp == null)
{
if (!string.IsNullOrEmpty(myAssetPath))
{
Debug.Log("Attempting to compile: " + myAssetPath);
AssetDatabase.ImportAsset(myAssetPath,
ImportAssetOptions.ForceSynchronousImport |
ImportAssetOptions.ForceUpdate);
}
if (_ImportTryCount < 5)
{
_ImportTryCount++;
return;
}
Debug.LogError("Could not add Google2u component base " + dbInfo.ScriptName);
ObjDbExport.Clear();
_ImportTryCount = 0;
return;
}
_ImportTryCount = 0;
Debug.Log("Database Script Attached!");
ObjDbExport.Remove(dbInfo);
var rowInputs = new List <string>();
List <Google2uCell> colHeaders = null;
var currow = 0;
foreach (var row in dbInfo.Data.Rows)
{
if (currow == 0)
{
colHeaders = row.Cells;
currow++;
continue;
}
// if types in first row
if (dbInfo.Data.UseTypeRow && currow == 1)
{
currow++;
continue;
}
var rowType = row[0].GetTypeFromValue();
var rowHeader = row[0].CellValueString;
if (string.IsNullOrEmpty(rowHeader))
// if this header is empty
{
if (dbInfo.CullEmptyRows)
{
break;
}
currow++;
continue;
}
if (rowType == SupportedType.Void ||
rowHeader.Equals("void", StringComparison.InvariantCultureIgnoreCase))
// if this cell is void, then skip the row completely
{
currow++;
continue;
}
var curCol = 0;
foreach (var cell in row.Cells)
{
if (cell.MyType == SupportedType.Void ||
dbInfo.Data.Rows[0][curCol].CellValueString.Equals("void", StringComparison.InvariantCultureIgnoreCase) ||
dbInfo.Data.Rows[0][curCol].CellValueString.Equals("ignore", StringComparison.InvariantCultureIgnoreCase))
{
curCol++;
continue;
}
if (dbInfo.CullEmptyCols && colHeaders[curCol].MyType == SupportedType.Void)
{
break;
}
rowInputs.Add(cell.CellValueString);
curCol++;
}
(comp as Google2uComponentBase).AddRowGeneric(rowInputs);
rowInputs.Clear();
currow++;
}
}
}
// Update is called once per frame
private void Update()
{
if (Instance == null)
{
Init();
}
var notification = PopNotification();
if (!string.IsNullOrEmpty(notification))
{
Debug.Log(notification);
ShowNotification(new GUIContent(notification));
}
if (!string.IsNullOrEmpty(UpdateMessage))
{
Debug.Log(UpdateMessage);
UpdateMessage = string.Empty;
}
if ((DateTime.Now - LastEllipses).Milliseconds > 500)
{
LastEllipses = DateTime.Now;
EllipsesCount += 1;
if (EllipsesCount > 5)
{
EllipsesCount = 2;
}
Ellipses = string.Empty;
for (var i = 0; i < EllipsesCount; ++i)
{
Ellipses += ".";
}
Repaint();
}
// Detect Skin Changes
var oldUseDarkSkin = UseDarkSkin;
if (EditorGUIUtility.isProSkin)
{
UseDarkSkin = true;
if (oldUseDarkSkin != UseDarkSkin)
{
LoadStyles();
}
}
if (IsDirty)
{
Google2uGUIUtil.Save();
IsDirty = false;
}
// Prevent Google2u from doing anything while in play mode
if (EditorApplication.isPlayingOrWillChangePlaymode || EditorApplication.isCompiling)
{
return;
}
if ((DateTime.Now - LastCheckedRSS).Hours > 0)
{
LastCheckedRSS = DateTime.Now;
var t = new Thread(CheckForService);
t.Start();
}
if (InstanceData.Commands.Contains(GFCommand.AssetDatabaseRefresh))
{
InstanceData.Commands.Remove(GFCommand.AssetDatabaseRefresh);
AssetDatabase.Refresh();
}
if (InstanceData.Commands.Contains(GFCommand.DoLogout))
{
InstanceData.Commands.Remove(GFCommand.DoLogout);
var t = new Thread(DoLogout)
{
Name = "DoLogout"
};
t.Start(InstanceData);
}
if (InstanceData.Commands.Contains(GFCommand.RetrieveWorkbooks))
{
InstanceData.Commands.Remove(GFCommand.RetrieveWorkbooks);
InstanceData.Commands.Add(GFCommand.WaitForRetrievingWorkbooks);
InstanceData.AccountWorkbooks.Clear();
var t = new Thread(DoWorkbookQuery)
{
Name = "RetrieveWorkbooks"
};
t.Start(InstanceData);
}
if (InstanceData.Commands.Contains(GFCommand.RetrieveManualWorkbooks))
{
InstanceData.Commands.Remove(GFCommand.RetrieveManualWorkbooks);
InstanceData.Commands.Add(GFCommand.WaitForRetrievingManualWorkbooks);
var t = new Thread(DoManualWorkbookRetrieval)
{
Name = "ManualWorkbookRetrieval"
};
t.Start(InstanceData);
}
if (InstanceData.Commands.Contains(GFCommand.ManualWorkbooksRetrievalComplete))
{
InstanceData.Commands.Remove(GFCommand.ManualWorkbooksRetrievalComplete);
var manualWorkbooksString = InstanceData.ManualWorkbooks.Aggregate(string.Empty,
(in_current, in_wb) => in_current + (in_wb.WorkbookUrl + "|"));
Google2uGUIUtil.SetString(InstanceData.ProjectPath + "_ManualWorkbookCache", manualWorkbooksString);
}
if (InstanceData.Commands.Contains(GFCommand.DoUpload))
{
InstanceData.Commands.Remove(GFCommand.DoUpload);
InstanceData.Commands.Add(GFCommand.WaitingForUpload);
var t = new Thread(DoWorkbookUpload)
{
Name = "WorkbookUpload"
};
t.Start(InstanceData);
}
if (InstanceData.Commands.Contains(GFCommand.UploadComplete))
{
InstanceData.Commands.Remove(GFCommand.UploadComplete);
InstanceData.WorkbookUploadProgress = 0;
InstanceData.AccountWorkbooks.Clear();
InstanceData.Commands.Add(GFCommand.RetrieveWorkbooks);
}
foreach (var Google2uSpreadsheet in InstanceData.AccountWorkbooksDisplay)
{
Google2uSpreadsheet.Update();
}
foreach (var Google2uSpreadsheet in InstanceData.ManualWorkbooksDisplay)
{
Google2uSpreadsheet.Update();
}
if (ObjDbExport != null && ObjDbExport.Count > 0)
{
var dbInfo = ObjDbExport[0];
if (dbInfo == null)
{
ObjDbExport.RemoveAt(0);
return;
}
if ((DateTime.Now - dbInfo.LastAttempt).TotalSeconds < 5)
{
return;
}
if (dbInfo.ReloadedAssets == false)
{
AssetDatabase.Refresh(ImportAssetOptions.ForceUpdate);
dbInfo.ReloadedAssets = true;
return;
}
dbInfo.LastAttempt = DateTime.Now;
Component comp = null;
var myAssetPath = string.Empty;
Debug.Log("Looking for Database Script: " + dbInfo.ScriptName);
var findAssetArray = AssetDatabase.FindAssets(dbInfo.ScriptName);
if (findAssetArray.Length > 0)
{
foreach (var s in findAssetArray)
{
var mypath = AssetDatabase.GUIDToAssetPath(s);
if (mypath.EndsWith(".cs"))
{
myAssetPath = mypath;
Debug.Log("Found Database Script at: " + mypath);
}
}
var myType = GetAssemblyType("Google2u." + dbInfo.ScriptName);
Debug.Log(dbInfo.ScriptName + ": GetAssemblyType returns " + myType);
if (myType != null)
{
var go = GameObject.Find(dbInfo.ObjectName) ?? new GameObject(dbInfo.ObjectName);
var toDestroy = go.GetComponent(dbInfo.ScriptName);
if (toDestroy != null)
{
DestroyImmediate(toDestroy);
}
#if UNITY_5_6_OR_NEWER
comp = go.AddComponent(myType);
#else
comp = go.AddComponent(dbInfo.ScriptName);
#endif
}
}
if (comp == null)
{
if (!string.IsNullOrEmpty(myAssetPath))
{
Debug.Log("Attempting to compile: " + myAssetPath);
AssetDatabase.ImportAsset(myAssetPath,
ImportAssetOptions.ForceSynchronousImport |
ImportAssetOptions.ForceUpdate);
}
if (_ImportTryCount < 5)
{
_ImportTryCount++;
return;
}
Debug.LogError("Could not add Google2u component base " + dbInfo.ScriptName);
ObjDbExport.Clear();
_ImportTryCount = 0;
return;
}
_ImportTryCount = 0;
Debug.Log("Database Script Attached!");
ObjDbExport.Remove(dbInfo);
var tmpFilePath = dbInfo.DataLocation;
using (var fs = File.Open(tmpFilePath, FileMode.Open, FileAccess.Read))
{
var bin = new BinaryFormatter();
var binData = (List <List <string> >)bin.Deserialize(fs);
foreach (var binDataRow in binData)
{
(comp as Google2uComponentBase).AddRowGeneric(binDataRow);
}
}
try
{
File.Delete(tmpFilePath);
}
catch (Exception ex)
{
Debug.Log("G2U is unable to delete the temporary file: " + tmpFilePath + " - " + ex.Message);
}
}
}
