static void SqliteWriterDemo(Dictionary <string, Type> settings, List <Record> records) { // https://sqlitebrowser.org/ var now = DateTime.Now; SqliteWriter writer = new SqliteWriter( String.Format("./{0}-{1}-{2}-{3}{4}{5}.db", now.Year, now.Month, now.Day, now.Hour, now.Minute, now.Second), "会社と部署", settings, UTF8Encoding.UTF8 ); writer.Write(records); }
static void Main(string[] args) { var builder = new ConfigurationBuilder().AddJsonFile("appsettings.json"); var configuration = builder.Build(); SpiderConfig config = new SpiderConfig(); configuration.GetSection("SpiderConfig").Bind(config); using (SqliteWriter writer = new SqliteWriter("movgg")) { new DriectSpider() .SetConfig(config.Config) .SetConfig(config.NextPageConfig) .SetLogger(new LogHelper()) .StartWithUrlAsync(config.MainUrl) .Wait(); } }
public ShellViewModel() { DisplayName = "MeVersusMany"; SetThreadExecutionState(ES_CONTINUOUS | ES_DISPLAY_REQUIRED | ES_SYSTEM_REQUIRED); //init the EventAggregator eventAggregator = new EventAggregator(); eventAggregator.Subscribe(this); //get a connection to the C2 ergometer if (dryRun) { c2erg = new SqliteErg("recordings/session_21-1-19_11-52-27.Kickstarter.db"); //NOTE: use a ghost as primary erg for testing purposes c2erg.IsPlayer = true; } else { c2erg = new C2Erg(); c2erg.IsPlayer = true; } storage = new SqliteWriter(dryRun); //get all recorded sessions string[] databaseFiles = Directory.GetFiles(".", "recordings/*.db"); foreach (var file in databaseFiles) { var sqliteErg = new SqliteErg(file); recordedErgs.Add(sqliteErg); } //init the UI components playerStats = new PlayerStatsViewModel(); overallStats = new OverallStatsViewModel(recordedErgs); ranking = new RankingViewModel(recordedErgs); //subscribe to the WPF Rendering event to get some sort of GameLoop CompositionTarget.Rendering += PerformUpdate; }