private void FormMain_Load(object sender, EventArgs e)
{
if (false == File.Exists(DB.SqliteFileName))
{
var map = new Dictionary <string, bool>();
DB.Open();
DB.RunQuery(
"CREATE TABLE Me (" +
"Id INTEGER PRIMARY KEY," +
"EOS INTEGER NOT NULL," +
"VTIME DATETIME NOT NULL" +
")");
DB.RunQuery($"INSERT INTO Me (EOS, VTIME) VALUES ({Define.InitEOS * Define.SosuConvertValue}, '{DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")}')");
DB.RunQuery(
"CREATE TABLE User (" +
"Id INTEGER PRIMARY KEY," +
"Name TEXT NOT NULL," +
"VEOS INTEGER NOT NULL" +
")");
DB.RunQuery($"INSERT INTO User (Id, Name, VEOS) VALUES ({Define.MyUserId}, '나자신', 0)");
map.Clear();
for (int i = 0; i < Define.AIUserCount;)
{
string name = Define.GetRandomName();
if (map.ContainsKey(name))
{
continue;
}
map.Add(name, true);
i++;
DB.RunQuery($"INSERT INTO User (Id, Name, VEOS) VALUES ({100 + i}, '{name}', {Rn.Next(15000, 150000) * Define.SosuConvertValue})");
}
DB.RunQuery(
"CREATE TABLE Node (" +
"Id INTEGER PRIMARY KEY," +
"BP INTEGER NOT NULL," +
"Name TEXT NOT NULL," +
"Intro TEXT NOT NULL" +
")");
map.Clear();
for (int i = 0; i < Define.NodeCount;)
{
string name = Define.GetRandomName();
if (map.ContainsKey(name))
{
continue;
}
map.Add(name, true);
i++;
DB.RunQuery($"INSERT INTO Node (Id, BP, Name, Intro) VALUES ({2000 + i}, 0, '{name}', '{name} 노드입니다. 잘 부탁드립니다.')");
}
DB.RunQuery(
"CREATE TABLE Vote (" +
"UserId INTEGER NOT NULL," +
"NodeId INTEGER NOT NULL," +
"VEOS INTEGER NOT NULL" +
")");
DB.Close();
}
RefreshTabPage(0);
timer1.Start();
timer2.Start();
}
