private static void CreateVideoData(string name)
{
if (!name.EndsWith(".sqlite"))
{
name += ".sqlite";
}
string path = Path.Combine(GlobalVariable.VideoDataPath, name);
MySqlite db = new MySqlite(path);
db.CreateTable(DataBase.SQLITETABLE_MOVIE);
db.CreateTable(DataBase.SQLITETABLE_ACTRESS);
db.CreateTable(DataBase.SQLITETABLE_LIBRARY);
db.CreateTable(DataBase.SQLITETABLE_JAVDB);
db.CloseDB();
}
public void Create()
{
int max = number;
string savepath = System.IO.Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "database", $"sample_{max}.sqlite");
MySqlite db = new MySqlite(savepath, true);
db.CreateTable(DataBase.SQLITETABLE_MOVIE);
db.CreateTable(DataBase.SQLITETABLE_ACTRESS);
db.CreateTable(DataBase.SQLITETABLE_LIBRARY);
db.CreateTable(DataBase.SQLITETABLE_JAVDB);
db.CloseDB();
List <string> ID = GetID(max);
using (MySqlite mySqlite = new MySqlite(savepath, true))
{
for (int i = 0; i < max; i++)
{
Movie movie = new Movie()
{
id = ID[i],
favorites = new Random(Guid.NewGuid().GetHashCode()).Next(0, 6),
visits = new Random(Guid.NewGuid().GetHashCode()).Next(0, 100),
title = GetSomeText(30, i),
runtime = new Random(Guid.NewGuid().GetHashCode()).Next(0, 300),
rating = (float)(new Random(Guid.NewGuid().GetHashCode()).Next(0, 100)) / 10,
filesize = Math.Abs(5 * 1024 * new Random(Guid.NewGuid().GetHashCode()).Next(0, 1024 * 1024)),
subsection = i % 100 == 0 ? "path1;path2" : "",
scandate = DateTime.Now.AddDays(-new Random(Guid.NewGuid().GetHashCode()).Next(-500, 500)).ToString("yyyy-MM-dd HH:mm:ss"),
otherinfo = DateTime.Now.AddDays(-new Random(Guid.NewGuid().GetHashCode()).Next(-500, 500)).ToString("yyyy-MM-dd HH:mm:ss"),
releasedate = DateTime.Now.AddDays(-new Random(Guid.NewGuid().GetHashCode()).Next(-500, 500)).ToString("yyyy-MM-dd"),
vediotype = new Random(Guid.NewGuid().GetHashCode()).Next(1, 4),
tag = "系列" + new Random(Guid.NewGuid().GetHashCode()).Next(defaultmax),
director = "导演" + new Random(Guid.NewGuid().GetHashCode()).Next(defaultmax),
studio = "发行商" + new Random(Guid.NewGuid().GetHashCode()).Next(defaultmax)
};
movie.genre = GetGenre(movie);
movie.actor = GetActor(max);
movie.label = GetLabel(max);
mySqlite.InsertFullMovie(movie, "movie");
Console.WriteLine(i);
}
}
}
private void InitDataBase()
{
if (!File.Exists(TranslateDataBasePath))
{
MySqlite db = new MySqlite("Translate");
db.CreateTable(DataBase.SQLITETABLE_YOUDAO);
db.CreateTable(DataBase.SQLITETABLE_BAIDUTRANSLATE);
db.CloseDB();
}
else
{
//是否具有表结构
MySqlite db = new MySqlite("Translate");
if (!db.IsTableExist("youdao"))
{
db.CreateTable(DataBase.SQLITETABLE_YOUDAO);
}
if (!db.IsTableExist("baidu"))
{
db.CreateTable(DataBase.SQLITETABLE_BAIDUTRANSLATE);
}
db.CloseDB();
}
}
private void Rename(TextBox textBox)
{
string name = textBox.Text;
//不修改
if (name == beforeRename)
{
textBox.IsReadOnly = true;
textBox.Cursor = Cursors.Hand;
beforeRename = "";
return;
}
//新建一个数据库
if (beforeRename == "")
{
if (!string.IsNullOrWhiteSpace(name) && !string.IsNullOrEmpty(name) && !IsItemInList(name, DataBases) && name.IndexOfAny(Path.GetInvalidFileNameChars()) == -1)
{
//新建
MySqlite db = new MySqlite("DataBase\\Comics\\" + name);
db.CreateTable(SqliteHelper.SQLITETABLE_COMICS);
db.CloseDB();
if (DataBases.Contains(Jvedio.Language.Resources.NewLibrary))
{
DataBases.Remove(Jvedio.Language.Resources.NewLibrary);
}
textBox.IsReadOnly = true;
textBox.Cursor = Cursors.Hand;
DataBases.Add(name);
DataBases.Add(Jvedio.Language.Resources.NewLibrary);
RefreshItemsControl();
}
else
{
textBox.Text = Jvedio.Language.Resources.NewLibrary;
}
}
else
{
//重命名
if (IsItemInList(name, DataBases))
{
textBox.Text = beforeRename; //重复的
}
else
{
//重命名
if (name.IndexOfAny(System.IO.Path.GetInvalidFileNameChars()) == -1)
{
try
{
File.Move(AppDomain.CurrentDomain.BaseDirectory + $"DataBase\\Comics\\{beforeRename}.sqlite",
AppDomain.CurrentDomain.BaseDirectory + $"DataBase\\Comics\\{name}.sqlite");
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
Logger.LogE(ex);
}
}
else
{
textBox.Text = beforeRename;
}
}
beforeRename = "";
}
textBox.IsReadOnly = true;
textBox.Cursor = Cursors.Hand;
textBox.TextAlignment = TextAlignment.Left;
}
