public void FixtureSetup() { Console.WriteLine("Connecting"); var client = new DatabaseClient("*****@*****.**", "password"); const string dbName = "IntegrationTests"; Console.WriteLine("Opening or creating database"); db = client.GetDatabase(dbName) ?? client.CreateDatabase(dbName); const string tableName = "IntegrationTests"; Console.WriteLine("Opening or creating table"); table = db.GetTable<IntegrationEntity>(tableName) ?? db.CreateTable<IntegrationEntity>(tableName); }
private static void Main(string[] args) { Console.WriteLine("Connecting"); var client = new DatabaseClient("*****@*****.**", "password"); const string dbName = "testing"; Console.WriteLine("Opening or creating database"); var db = client.GetDatabase(dbName) ?? client.CreateDatabase(dbName); const string tableName = "testtable"; Console.WriteLine("Opening or creating table"); var t = db.GetTable <Entity>(tableName) ?? db.CreateTable <Entity>(tableName); Console.WriteLine("Feed url for this table is '{0}'", t.GetFeedUrl()); var all = t.FindAll(); Console.WriteLine("{0} elements", all.Count); var r = all.Count > 0 ? all[0] : t.Add(new Entity { Conteudo = "some content", Amount = 5 }); Console.WriteLine("conteudo: {0}", r.Element.Conteudo); r.Element.Conteudo = "nothing at all"; Console.WriteLine("updating row"); r.Update(); Console.WriteLine("Now there are {0} elements", t.FindAll().Count); { Console.WriteLine("executing a few queries"); foreach (var q in new[] { "amount=5", "amount<6", "amount>0", "amount!=6", "amount<>6", "conteudo=\"nothing at all\"" }) { Console.Write("querying '{0}': ", q); var rows = t.FindStructured(q); Console.WriteLine("{0} elements found", rows.Count); } } { Console.WriteLine("Linq queries"); var rows = from e in t.AsQueryable() where e.Conteudo == r.Element.Conteudo orderby e.Amount select e; Console.WriteLine("{0} elements found", rows.ToList().Count()); } Console.WriteLine("deleting row"); r.Delete(); Console.WriteLine("deleting table"); t.Delete(); Console.WriteLine("deleting database"); db.Delete(); Console.WriteLine("Press any key..."); Console.ReadKey(); }
/// <summary> /// Gets the table. /// </summary> /// <returns>The table.</returns> protected virtual ITable <TEntity> GetTable() { if (m_table == null) { var client = new DatabaseClient(m_clientEmail, m_privateKey); var db = client.GetDatabase(m_databaseName) ?? client.CreateDatabase(m_databaseName); m_table = db.GetTable <TEntity>(m_tableName) ?? db.CreateTable <TEntity>(m_tableName); } return(m_table); }
public void FixtureSetup() { Console.WriteLine("Connecting"); var client = new DatabaseClient( clientEmail: "*****@*****.**", privateKey: File.ReadAllBytes(@"xxx.p12")); const string dbName = "IntegrationTests"; Console.WriteLine("Opening or creating database"); db = client.GetDatabase(dbName) ?? client.CreateDatabase(dbName); const string tableName = "IntegrationTests"; Console.WriteLine("Opening or creating table"); table = db.GetTable<IntegrationEntity>(tableName) ?? db.CreateTable<IntegrationEntity>(tableName); }
public void FixtureSetup() { Console.WriteLine("Connecting"); var client = new DatabaseClient("*****@*****.**", "password"); const string dbName = "IntegrationTests"; Console.WriteLine("Opening or creating database"); db = client.GetDatabase(dbName) ?? client.CreateDatabase(dbName); const string tableName = "IntegrationTests"; Console.WriteLine("Opening or creating table"); table = db.GetTable <IntegrationEntity>(tableName) ?? db.CreateTable <IntegrationEntity>(tableName); }
public void FixtureSetup() { Console.WriteLine("Connecting"); var client = new DatabaseClient( clientEmail: "*****@*****.**", privateKey: File.ReadAllBytes(@"xxx.p12")); const string dbName = "IntegrationTests"; Console.WriteLine("Opening or creating database"); db = client.GetDatabase(dbName) ?? client.CreateDatabase(dbName); const string tableName = "IntegrationTests"; Console.WriteLine("Opening or creating table"); table = db.GetTable <IntegrationEntity>(tableName) ?? db.CreateTable <IntegrationEntity>(tableName); }
public override bool Load() { if (!base.Load()) { return(false); } MySpreadSheet targetData = target as MySpreadSheet; var client = new DatabaseClient(username, password); var db = client.GetDatabase(targetData.SheetName) ?? client.CreateDatabase(targetData.SheetName); var table = db.GetTable <MyData>(targetData.WorksheetName) ?? db.CreateTable <MyData>(targetData.WorksheetName); List <MyData> myDataList = new List <MyData>(); var all = table.FindAll(); foreach (var elem in all) { MyData data = new MyData(); data = Cloner.DeepCopy <MyData>(elem.Element); myDataList.Add(data); } #if UNITY_EDITOR Debug.Log("=== MyData ==="); foreach (var e in myDataList) { Debug.Log("Key: " + e.Key); Debug.Log("Text: " + e.Text); } #endif targetData.dataArray = myDataList.ToArray(); EditorUtility.SetDirty(targetData); AssetDatabase.SaveAssets(); return(true); }