private static void updateDoc()
{
Console.WriteLine("开始更新");
Console.WriteLine("----------------------------------");
//Console.ReadKey();
try
{
string markdownPath = ConfigurationManager.AppSettings["markdownPath"];
string dbSource = ConfigurationManager.AppSettings["dbSource"];
ContentProvider contentPrvd = new ContentProvider();
List <UpdateMeta> contentUpdateMetaSet = contentPrvd.Acquire(markdownPath);
using (SQLiteConnection conn = new SQLiteConnection(dbSource))
{
using (SQLiteCommand cmd = new SQLiteCommand())
{
cmd.Connection = conn;
conn.Open();
_sqliteHelper = new SQLiteHelper(cmd);
int count = 0;
foreach (var updateMeta in contentUpdateMetaSet)
{
_sqliteHelper.Update("BODY", updateMeta.updates, updateMeta.limits);
count++;
if (count % 10 == 0)
{
Console.WriteLine("----------------------------------");
Console.WriteLine(string.Format("已更新 {0} 条记录", count));
}
}
conn.Close();
}
}
Console.WriteLine("----------------------------------");
Console.WriteLine("结束更新");
Console.ReadKey();
}
catch (Exception ex)
{
Console.WriteLine(string.Format("error: {0}", ex));
Console.ReadKey();
//throw;
}
}