public static void ClearTimetable(FileInfo sqlDB) { List<string> network_tables = new List<string>(); network_tables.Add(SQLFieldNames.TIMETABLES); network_tables.Add(SQLFieldNames.SERVICES); network_tables.Add(SQLFieldNames.ROUTES); network_tables.Add(SQLFieldNames.STOPS); SQLiteDatabase db = new SQLiteDatabase(sqlDB); db.ClearTable(network_tables); }
public static void ClearNetwork(FileInfo sqlDB) { List<string> network_tables = new List<string>(); network_tables.Add(SQLFieldNames.LOCATION_ALIASES); network_tables.Add(SQLFieldNames.LOCATIONS); network_tables.Add(SQLFieldNames.NETWORKS); network_tables.Add(SQLFieldNames.TOUCHING_LOCATIONS); network_tables.Add(SQLFieldNames.SWAP_LOCATIONS); SQLiteDatabase db = new SQLiteDatabase(sqlDB); db.ClearTable(network_tables); }
public void ClearTable(string tablename, System.Data.SQLite.SQLiteDatabase db = null) { if (db == null) { db = this.db; } if (db == null) { db = this.db; } if (db == null) { return; } db.ClearTable(tablename); }
public void ClearTable(string tableName) { db.ClearTable(tableName); }
public void ConfigureTVGuide(bool useUPnPStreamUrl = false) { Log("Checking for the source.db and settings.xml files"); if (!System.IO.File.Exists(settings.TVGuidePath)) { Log(" source.db file not found at: " + settings.TVGuidePath); Log("Failed TVGuide configuration"); return; } else { Log(" source.db found at: " + settings.TVGuidePath); } if (!System.IO.File.Exists(settings.TVGuidePath)) { Log(" settings.xml file not found at: " + new FileInfo(settings.TVGuidePath).Directory + @"\settings.xml"); Log("Failed TVGuide configuration"); return; } else { Log(" settings.xml file found at: " + new FileInfo(settings.TVGuidePath).Directory + @"\settings.xml"); } Log("Rewriting TVGuide channels from favorites (including strm file references)"); Log(" Clearing any existing channel configurations"); SQLiteDatabase db = new SQLiteDatabase(settings.TVGuidePath); try { db.ClearTable("CUSTOM_STREAM_URL"); db.ClearTable("CHANNELS"); } catch (Exception crap) { Log(crap.Message); return; } int i = 0; foreach (Channel channel in channels) { if (channel.Checked) { db = new SQLiteDatabase(settings.TVGuidePath); //Channel insert data Dictionary<String, String> channelData = new Dictionary<String, String>(); channelData.Add("ID", channel.Id); channelData.Add("TITLE", channel.VirtualNumber + " " + channel.Callsign); channelData.Add("SOURCE", "xmltv"); channelData.Add("VISIBLE", "1"); channelData.Add("WEIGHT", i.ToString()); //Custom streams insert data Dictionary<String, String> streamData = new Dictionary<String, String>(); streamData.Add("CHANNEL", channel.Id); if (!useUPnPStreamUrl) { streamData.Add("STREAM_URL", StrmDirectory + channel.Filename); } else { string uuid = "missing-uuid-configuration"; try { uuid = settings.HDHRDMS.Split('|')[1]; } catch (Exception){} streamData.Add("STREAM_URL", "upnp://" + uuid + "/CableTV%2fv" + channel.VirtualNumber); } //Sources update Dictionary<String, String> xmltvSourceUpdate = new Dictionary<String, String> { { "CHANNELS_UPDATED", "current_timestamp" } }; db.Update("SOURCES", xmltvSourceUpdate, "ID=\"xmltv\""); try { db.Insert("CHANNELS", channelData); db.Insert("CUSTOM_STREAM_URL", streamData); Log(" Wrote channel: " + channel.VirtualNumber + " - " + channel.Callsign + " With stream path: " + streamData["STREAM_URL"]); } catch (Exception crap) { Log(crap.Message); } i++; } } Log("Updating settings and last updated timestamps"); UpdateTVGuideSettingXML(); //Custom streams insert data DataTable updateMax; String query = "select max(id) + 1 as next_id from UPDATES;"; updateMax = db.GetDataTable(query); string nextId = ""; foreach (DataRow dRow in updateMax.Rows) { nextId = dRow["next_id"].ToString(); } Dictionary<String, String> updatesData = new Dictionary<String, String>(); updatesData.Add("ID", nextId); updatesData.Add("SOURCE", "xmltv"); updatesData.Add("DATE", DateTime.UtcNow.ToString("yyyy-MM-dd")); updatesData.Add("PROGRAMS_UPDATED", "current_timestamp"); db.Insert("UPDATES", updatesData); //Settings update data Dictionary<String, String> sourceSetting = new Dictionary<String, String> { { "VALUE", "XMLTV" } }; db.Update("SETTINGS", sourceSetting, String.Format("KEY = {0}", "\"source\"")); Dictionary<String, String> xmltvFileSetting = new Dictionary<String, String> { { "VALUE", new FileInfo(settings.MC2XMLPath).Directory + @"\xmltv.xml" } }; db.Update("SETTINGS", xmltvFileSetting, String.Format("KEY = {0}", "\"xmltv.file\"")); Log("Done updating TVGuide!"); }