/// <summary> /// Обновляет полный текст новости в БД. Новость отмечается как обработанная. /// </summary> /// <param name="id"></param> /// <param name="fullText"></param> public static void UpdateNewspaperFullText(Int32 id, String fullText) { SQLiteConnection connection = DatabaseConnectionHandler.InvokeMultiple(); String sql = $"update {TableNames.NewspaperFullText} set " + $"s_text='{fullText}', i_is_parsed=1 where id={id}"; connection.Execute(sql); //DatabaseConnectionHandler.SafeExecute(sql, connection); }
public static void SaveImage(ImageDB image) { SQLiteConnection connection = DatabaseConnectionHandler.InvokeMultiple(); string sql = $"insert into {TableNames.NetworkAddress} (s_url) values ('{image.s_url}')"; connection.Execute(sql); int networkId = connection.QueryFirst <int>( $"select id from {TableNames.NetworkAddress} where s_url='{image.s_url}'"); connection.Execute($"insert into {TableNames.LocalFileAddress} " + $"(s_path) values ('{image.s_path}')"); int localId = connection.QueryFirst <int>( $"select id from {TableNames.LocalFileAddress} where s_path='{image.s_path}'"); connection.Execute($"insert into {TableNames.Images} (i_newspaper_id, " + $"i_local_address_id, i_network_address_id) values " + $"({image.i_newspaper_id}, {localId}, {networkId})"); }