Example #1
0
        public bool Load(string filename)
        {
            if (!File.Exists(filename))
            {
                return(false);
            }

            lastError        = string.Empty;
            databaseLocation = filename;

            try
            {
                if (database != null)
                {
                    database.CloseDatabase();
                }

                database = new SQLiteWrapper.SQLiteBase(databaseLocation);
            }
            catch (Exception exc)
            {
                lastError = exc.Message;
                return(false);
            }

            return(CheckRequiredTables());
        }
Example #2
0
        public bool Create(bool use_memory = true)
        {
            lastError = string.Empty;

            if (string.IsNullOrEmpty(databaseLocation))
            {
                return(false);
            }

            try
            {
                if (database != null)
                {
                    database.CloseDatabase();
                }

                database = new SQLiteWrapper.SQLiteBase(((use_memory) ? ":memory:" : databaseLocation));
            }
            catch (Exception exc)
            {
                lastError = exc.Message;
                return(false);
            }

            bool rv = Prepare();

            if (!rv)
            {
                return(false);
            }

            return(CheckRequiredTables());
        }
Example #3
0
        public bool Create(string filename, bool override_file = false)
        {
            lastError        = string.Empty;
            databaseLocation = filename;

            if (string.IsNullOrEmpty(databaseLocation))
            {
                return(false);
            }

            if (File.Exists(databaseLocation) && override_file)
            {
                try
                {
                    File.Delete(databaseLocation);
                }
                catch (Exception xc)
                {
                    lastError = xc.Message;
                    return(false);
                }
            }

            try
            {
                if (database != null)
                {
                    database.CloseDatabase();
                }

                database = new SQLiteWrapper.SQLiteBase(databaseLocation);
            }
            catch (Exception exc)
            {
                lastError = exc.Message;
                return(false);
            }

            bool rv = CheckRequiredTables();

            if (!rv)
            {
                Prepare();
            }

            return(CheckRequiredTables());
        }