Пример #1
0
        public static void Main(string[] args)
        {
            Lib.Init ();

            // Create midgard config connection
            Config cfg = new Config ();
            cfg.DatabaseType = "SQLite";
            cfg.DatabaseName = "midgard_mono_sample";

            Connection mgd = new Connection ();
            if (!mgd.OpenConfig (cfg)) {
                Console.WriteLine ("Connection failed!");
                return;
            }

            /* Create base storage if it doesn't exist */
            if (Midgard.Storage.CreateBaseStorage(mgd))
                Console.WriteLine ("Base Midgard storage created");

            /* Create midgard_person storage if it doesn't exist */
            if (Midgard.Storage.Exists (mgd, "midgard_person")) {
                Console.WriteLine ("Storage for midgard_person class exists");
            }
            else {
                if (Midgard.Storage.Create (mgd, "midgard_person"))
                    Console.WriteLine ("Created new storage for midgard_person class");
                else
                    Console.WriteLine ("Failed to create storage for midgard_person class");
            }
        }
Пример #2
0
        public static void Main(string[] args)
        {
            Midgard.Lib.Init ();

            // Create midgard config connection
            Config cfg = new Config ();
            cfg.DatabaseType = "SQLite";
            cfg.DatabaseName = "midgard";

            Connection conn = new Connection ();
            if (!conn.OpenConfig (cfg)) {
                Console.WriteLine ("Connection failed!");
                return;
            }

            Console.WriteLine ("Connection established!");
        }
Пример #3
0
        public static void Main(string[] args)
        {
            Midgard.Lib.Init ();

            // Create midgard config connection
            Config cfg = new Config ();
            cfg.DatabaseType = "SQLite";
            cfg.DatabaseName = "midgard_mono_sample";

            Connection mgd = new Connection ();
            if (!mgd.OpenConfig (cfg)) {
                Console.WriteLine ("Connection failed!");
                return;
            }

            GLib.Value val = new GLib.Value("");
            Midgard.Object john = new Midgard.Object (mgd, "midgard_person", val);
            GLib.Value name = new GLib.Value ("John");
            john.SetSchemaProperty ("username", name);

            if (!john.Create()) {
                Console.WriteLine ("Couldn't create person object. %s", mgd.ErrorString);
            }
            else {
                GLib.Value gval = john.GetSchemaProperty ("guid");
                Console.Write ("Created new person object." + (string)gval.Val.ToString() + "\n");
            }

            val = new GLib.Value("");
            Midgard.Object alice = new Midgard.Object (mgd, "midgard_person", val);
            name = new GLib.Value ("Alice");
            alice.SetSchemaProperty ("username", name);

            if (!alice.Create()) {
                Console.WriteLine ("Couldn't create person object. %s", mgd.ErrorString);
            }
            else {
                GLib.Value gval = alice.GetSchemaProperty ("guid");
                Console.Write ("Created new person object." + (string)gval.Val + "\n");
            }

            Console.WriteLine (john);
        }
Пример #4
0
        public static void Main(string[] args)
        {
            Midgard.Lib.Init ();

            // Create midgard config connection
            Config cfg = new Config ();
            cfg.DatabaseType = "SQLite";
            cfg.DatabaseName = "midgard_mono_sample";

            Connection mgd = new Connection ();
            if (!mgd.OpenConfig (cfg)) {
                Console.WriteLine ("Connection failed!");
                return;
            }

            Midgard.QueryStorage storage = new Midgard.QueryStorage ("midgard_person");
            Midgard.QuerySelect select = new Midgard.QuerySelect (mgd, storage);

            Midgard.QueryProperty prop = new Midgard.QueryProperty ("name", null);
            GLib.Value value = new GLib.Value ("John");
            Midgard.QueryValue val = new Midgard.QueryValue (value);
            Midgard.QueryConstraint cnstr = new Midgard.QueryConstraint (prop, "=", val, storage);

            Midgard.QueryProperty prop2 = new Midgard.QueryProperty ("name", null);
            value = new GLib.Value ("Alice");
            Midgard.QueryValue val2 = new Midgard.QueryValue (value);
            Midgard.QueryConstraint cnstr2 = new Midgard.QueryConstraint (prop2, "=", val, null);

            //Midgard.QueryGroupConstraint group_constraint = new Midgard.QueryGroupConstraint ("OR", cnstr, cnstr2);

            //select.SetConstraint (cnstr);
            select.Execute();

            uint nobjects = 0;
            Midgard.DBObject[] objects = select.ListObjects(out nobjects);
        }