/// <summary>
/// 生成sqlite
/// 默认导出到当前平台目录下
/// </summary>
/// <param name="ouptputPath">自定义路径</param>
public static void AllExcel2SQLite(string ouptputPath, RuntimePlatform platform, DBType dbType = DBType.Local)
{
//触发bd环境周期
BDFrameworkPipelineHelper.OnBeginBuildSqlite();
var xlslFiles = ExcelEditorTools.GetAllExcelFiles();
switch (dbType)
{
case DBType.Local:
SqliteLoder.LoadLocalDBOnEditor(ouptputPath, platform);
break;
case DBType.Server:
SqliteLoder.LoadServerDBOnEditor(ouptputPath, platform);
break;
}
//清空表
SqliteHelper.DB.Connection.DropTable <ImportExcelLog>();
{
foreach (var f in xlslFiles)
{
try
{
Excel2SQLite(f, dbType);
}
catch (Exception e)
{
Debug.LogError(e);
Debug.LogError("导表失败:" + f);
EditorUtility.ClearProgressBar();
}
}
}
SqliteLoder.Close();
//
EditorUtility.ClearProgressBar();
//触发bd环境周期
BDFrameworkPipelineHelper.OnEndBuildSqlite(ouptputPath);
GlobalAssetsHelper.GenBasePackageAssetBuildInfo(ouptputPath, platform);
Debug.Log("导出Sqlite完成!");
}
/// <summary>
/// 生成sqlite
/// 默认导出到当前平台目录下
/// </summary>
/// <param name="ouptputPath">自定义路径</param>
public static void AllExcel2SQLite(string ouptputPath, RuntimePlatform platform, DBType dbType = DBType.Local)
{
//触发bd环境周期
BDEditorBehaviorHelper.OnBeginBuildSqlite();
var xlslFiles = GetAllConfigFiles();
switch (dbType)
{
case DBType.Local:
SqliteLoder.LoadLocalDBOnEditor(ouptputPath, platform);
break;
case DBType.Server:
SqliteLoder.LoadServerDBOnEditor(ouptputPath, platform);
break;
}
{
foreach (var f in xlslFiles)
{
try
{
Excel2SQLite(f, dbType);
}
catch (Exception e)
{
Debug.LogError("导表失败:" + f);
EditorUtility.ClearProgressBar();
}
}
}
SqliteLoder.Close();
//
EditorUtility.ClearProgressBar();
//触发bd环境周期
BDEditorBehaviorHelper.OnEndBuildSqlite(ouptputPath);
AssetHelper.AssetHelper.GenPackageBuildInfo(ouptputPath, platform);
Debug.Log("导出Sqlite完成!");
}