using System; using System.Collections.Generic; using System.Linq; using System.Text; using Google.GData.Client; using Google.GData.Extensions; using Google.GData.Spreadsheets; using LoggingTool.interfaces; using LoggingTool.models; using System.IO; namespace LoggingTool { class TestSpreadsheetOutput { static void Main(string[] args) { new SpreadsheetLogicTest(); Console.ReadKey(); } } class SpreadsheetOutputTest { private ILoggerOutput output; public SpreadsheetOutputTest() { output = new TeamUpSpeadsheetOutput("kaidencez@gmail.com", "verboden", "GDataTest"); LoggerMessage questionnaireMessage = new TeamUpSpreadsheetMessage(TeamUpSpreadsheetMessage.QUESTIONNAIRE, new List() {"1", "11.8940", "1", "20", "0", "1", "2", "3", "4", "5", "6", "7", "8"}); LoggerMessage eventMessage = new TeamUpSpreadsheetMessage(TeamUpSpreadsheetMessage.EVENT, new List() {"1", "11.8940", "1337"}); output.send(questionnaireMessage); output.send(eventMessage); } } class SpreadsheetLogicTest { private ILoggerLogic logic; private ILoggerOutput output; public SpreadsheetLogicTest() { logic = new TeamUpLogic(); output = new TeamUpSpeadsheetOutput("kaidencez@gmail.com", "verboden", "GDataTest"); //Create some filestreams for testing purposes FileStream fQ = new FileStream("D:\\jkraaijeveld\\Desktop\\questionnaires.log", FileMode.Open); FileStream fE = new FileStream("D:\\jkraaijeveld\\Desktop\\events.log", FileMode.Open); StreamReader sQ = new StreamReader(fQ); StreamReader sE = new StreamReader(fE); //Read everything in both of the files while (!sQ.EndOfStream) { logic.addInput(sQ.ReadLine()); } while (!sE.EndOfStream) { logic.addInput(sE.ReadLine()); } //Create all the models logic.createModels(); //Write them List messages = logic.formatModels(); foreach (LoggerMessage message in messages) { output.send(message); } } } /*static void Main(string[] args) { //Login to google docs SpreadsheetsService service = new SpreadsheetsService("testLogger"); //Retrieve all spreadsheets in the account SpreadsheetQuery query = new SpreadsheetQuery(); SpreadsheetFeed feed = service.Query(query); Console.WriteLine("All spreadsheets:"); SpreadsheetEntry testEntry = new SpreadsheetEntry(); foreach (SpreadsheetEntry entry in feed.Entries) { Console.WriteLine(entry.Title.Text); if(entry.Title.Text.Equals("GDataTest")) { testEntry = entry; } } //Get the first worksheet AtomLink link = testEntry.Links.FindService(GDataSpreadsheetsNameTable.WorksheetRel, null); WorksheetQuery workSheetQuery = new WorksheetQuery(link.HRef.ToString()); WorksheetFeed workSheetFeed = service.Query(workSheetQuery); WorksheetEntry worksheet = (WorksheetEntry)workSheetFeed.Entries.First(); writeRow(service, worksheet); //Prompt user for cell to update Console.Write("Row of cell to update? "); string row = Console.ReadLine(); Console.Write("Column of cell to update? "); string col = Console.ReadLine(); //Get the proper cell AtomLink cellFeedLink = worksheet.Links.FindService(GDataSpreadsheetsNameTable.CellRel, null); CellQuery cellQuery = new CellQuery(cellFeedLink.HRef.ToString()); cellQuery.MinimumRow = cellQuery.MaximumRow = uint.Parse(row); cellQuery.MinimumColumn = cellQuery.MaximumColumn = uint.Parse(col); CellFeed cellFeed = service.Query(cellQuery); CellEntry cell = (CellEntry)cellFeed.Entries.First(); Console.Write("Enter a new Value: "); cell.Cell.InputValue = Console.ReadLine(); AtomEntry updatedCell = cell.Update(); Console.ReadKey(); } public static void writeRow(SpreadsheetsService service, WorksheetEntry worksheet) { String[] testArray = new String[] { "Testing", "inserting", "row", "into", "spreadsheet" }; AtomLink listFeedLink = worksheet.Links.FindService(GDataSpreadsheetsNameTable.ListRel, null); ListQuery query = new ListQuery(listFeedLink.HRef.ToString()); ListFeed feed = service.Query(query); ListEntry firstRow = feed.Entries[0] as ListEntry; ListEntry newRow = new ListEntry(); for (int i = 0; i < testArray.Length; i++) { ListEntry.Custom element = firstRow.Elements[i]; ListEntry.Custom curElement = new ListEntry.Custom(); curElement.LocalName = element.LocalName; curElement.Value = testArray[i]; newRow.Elements.Add(curElement); } Console.WriteLine("Row is inserted when you press a key."); Console.ReadKey(); ListEntry insertedRow = feed.Insert(newRow) as ListEntry; } }*/ }