public SqlCeFunctionRegistry()
{
// SqlFunctions.Add(FunctionType.ToString, FunctionViews.VarArgs("CONVERT(NVARCHAR,", ",", ")"));
SqlFunctions.Add(FunctionType.Compare, FunctionView.Compare);
SqlFunctions.Add(FunctionType.NewGuid, FunctionView.Standard("NewID"));
SqlFunctions.Add(FunctionType.Length, FunctionView.Standard("DataLength"));
}
public MySqlFunctionRegistry()
{
SqlFunctions.Add(FunctionType.Case, FunctionView.Case);
//SqlFunctions.Add(FunctionType.ToString, FunctionViews.VarArgs("CAST(", ",", " AS CHAR)"));
SqlFunctions.Add(FunctionType.Compare, FunctionView.Compare);
SqlFunctions.Add(FunctionType.NewGuid, FunctionView.Standard("Uuid"));
SqlFunctions.Add(FunctionType.Length, FunctionView.Standard("Length"));
}
public SQLiteFunctionManager()
{
SqlFunctions.Add(FunctionType.Case, FunctionView.Case);
//SqlFunctions.Add(FunctionType.ToString, FunctionViews.Proxy((v, args) => v.Visit(args[0])));
SqlFunctions.Add(FunctionType.Compare, FunctionView.Compare);
SqlFunctions.Add(FunctionType.NewGuid, FunctionView.Standard("NewID"));
SqlFunctions.Add(FunctionType.Length, FunctionView.Standard("Length"));
}
public AccessFunctionRegistry()
{
SqlFunctions.Add(FunctionType.Case, new IFFunctionView());
// SqlFunctions.Add(FunctionType.ToString, FunctionViews.StandardSafe("cstr", 1));
SqlFunctions.Add(FunctionType.Compare, CompareFunctionView.Instance);
SqlFunctions.Add(FunctionType.NewGuid, FunctionView.Standard("newID"));
SqlFunctions.Add(FunctionType.Length, FunctionView.Standard("len"));
}
public OracleFunctionRegistry()
{
SqlFunctions.Add(FunctionType.Case, FunctionView.Case);
//SqlFunctions.Add(FunctionType.ToString, FunctionViews.VarArgs("CONVERT(NVARCHAR,", ",", ")"));
SqlFunctions.Add(FunctionType.Compare, FunctionView.Compare);
SqlFunctions.Add(FunctionType.ToChar, FunctionView.Standard("to_char"));
SqlFunctions.Add(FunctionType.NewGuid, FunctionView.Standard("Sys_Guid"));
SqlFunctions.Add(FunctionType.Length, FunctionView.Standard("Length"));
}
void Awake()
{
instance = this;
inputFiled.gameObject.SetActive(true);
noticeText.gameObject.SetActive(true);
introduceText.gameObject.SetActive(true);
AddButtonEvent(mConfirmObj, OnClickConfirm);
gameObject.SetActive(false);
}
static AccessSqlBuilder()
{
CastFunctions[DBType.Boolean] = FunctionView.StandardSafe("CBool", 1);
CastFunctions[DBType.Byte] = FunctionView.StandardSafe("CByte", 1);
CastFunctions[DBType.Int16] = FunctionView.StandardSafe("CInt", 1);
CastFunctions[DBType.Int32] = FunctionView.StandardSafe("CInt", 1);
CastFunctions[DBType.Int64] = FunctionView.StandardSafe("CLng", 1);
CastFunctions[DBType.Decimal] = FunctionView.StandardSafe("CCur", 1);//
CastFunctions[DBType.Currency] = FunctionView.StandardSafe("CCur ", 1);
CastFunctions[DBType.Single] = FunctionView.StandardSafe("CSng ", 1);
CastFunctions[DBType.Double] = FunctionView.StandardSafe("CDbl", 1);
CastFunctions[DBType.DateTime] = FunctionView.StandardSafe("CDate", 1);
CastFunctions[DBType.Guid] = FunctionView.StandardSafe("CStr", 1);
CastFunctions[DBType.VarChar] = FunctionView.StandardSafe("CStr ", 1);
CastFunctions[DBType.Char] = FunctionView.StandardSafe("CStr ", 1);
CastFunctions[DBType.NVarChar] = FunctionView.StandardSafe("CStr ", 1);
CastFunctions[DBType.NChar] = FunctionView.StandardSafe("CStr ", 1);
}
public FirebirdFunctionRegistry()
{
SqlFunctions.Add(FunctionType.NewGuid, FunctionView.Standard("Gen_Uuid"));
SqlFunctions.Add(FunctionType.Length, FunctionView.Standard("Octet_Length"));
}
public override void OnInspectorGUI()
{
base.OnInspectorGUI();
FunctionView view = (FunctionView)target;
Function function = view.GetFunction();
string fullFunctionText = view.functionText;
object result = null;
for (int i = 0; i < cachedFunctionResults.Count; i++)
{
if (cachedFunctionResults[i].Key == fullFunctionText)
{
result = cachedFunctionResults[i].Value;
break;
}
}
if (result == null)
{
if (function != null)
{
System.Diagnostics.Stopwatch sw = System.Diagnostics.Stopwatch.StartNew();
sw.Start();
result = function.Evaluate();
sw.Stop();
Debug.Log("FunctionViewEditor -> " + fullFunctionText + " execution took " + sw.Elapsed);
}
else
{
result = "ERROR!!";
}
cachedFunctionResults.Add(new KeyValuePair <string, object>(fullFunctionText, result));
if (cachedFunctionResults.Count > MAX_CACHED_RESULTS)
{
cachedFunctionResults.RemoveAt(0);
}
}
if (result is Matrix)
{
Matrix matrix = (Matrix)result;
if (colors == null || colors.Length != matrix.size * matrix.size)
{
colors = new Color32[matrix.size * matrix.size];
}
if (texture == null || texture.width != matrix.size || texture.height != matrix.size)
{
if (texture)
{
Component.DestroyImmediate(texture);
}
texture = new Texture2D(matrix.size, matrix.size, TextureFormat.RGB24, false);
}
for (int i = 0; i < matrix.size * matrix.size; i++)
{
colors[i] = new Color32(matrix.values[i], matrix.values[i], matrix.values[i], 0);
}
if (colors.Length > 0)
{
texture.SetPixels32(colors);
texture.Apply();
}
//EditorGUILayout.LabelField("Result", "See in preview");
if (texture)
{
EditorGUILayout.LabelField(new GUIContent("Result"), new GUIContent(texture), GUILayout.MaxHeight(texture.height));
//Rect rect = EditorGUILayout.GetControlRect(true, texture.height);
//EditorGUI.DrawTextureTransparent(rect, texture, ScaleMode.ScaleToFit);
}
}
else
{
EditorGUILayout.LabelField("Result", result.ToString());
}
if (GUILayout.Button("Recalculate"))
{
cachedFunctionResults.RemoveAll(x => x.Key == fullFunctionText);
}
}
private void UpdateList()
{
GenerateFilteredList();
FunctionView.VirtualListSize = _filteredList.Count;
FunctionView.Refresh();
}
