Ejemplo n.º 1
0
        public override void UpdateObject(Dictionary <string, object> propertiesAndValues, long primaryKey)
        {
            StringBuilder commandText = new StringBuilder();

            try
            {
                if (propertiesAndValues.Count > 0)
                {
                    var parameters = CreateParameters(propertiesAndValues);
                    var propertiesAndParameters = propertiesAndValues.Keys.Zip(parameters.Keys, (k, v) => new { k, v }).ToDictionary(x => x.k, x => x.v);

                    string md5Hash = Utilities.MD5HashFromList(propertiesAndValues.Values.ToList());

                    commandText.Append(string.Format("{0} {1} {2} ", "UPDATE", QueryTableName, "SET"));
                    commandText.Append(string.Format("{0} = '{1}', ", UbjectMetadata.UBJECT_HASH, md5Hash));
                    commandText.Append(string.Format("{0} = '{1}', ", UbjectMetadata.UBJECT_TIMESTAMP, DateTime.UtcNow.Ticks.ToString()));
                    commandText.Append(string.Join(", ", propertiesAndParameters.Select(x => x.Key + " = " + x.Value).ToList()));
                    commandText.Append(string.Format(" {0} {1} = '{2}';", "WHERE", UbjectMetadata.PRIMARY_KEY, primaryKey));

                    var dbQueryExecutor = new DbQueryExecutor(dbManager);
                    dbQueryExecutor.ExecuteNonQuery(commandText, parameters);
                }
            }
            catch (Exception ex)
            {
            }
        }
Ejemplo n.º 2
0
        public override long AddObject(Dictionary <string, object> propertiesAndValues)
        {
            long primaryKey = 0;

            if (propertiesAndValues.Count > 0)
            {
                var parameters = CreateParameters(propertiesAndValues);
                var propertiesAndParameters = propertiesAndValues.Keys.Zip(parameters.Keys, (k, v) => new { k, v }).ToDictionary(x => x.k, x => x.v);

                string md5Hash = Utilities.MD5HashFromList(propertiesAndValues.Values.ToList());

                StringBuilder commandText = new StringBuilder();
                commandText.Append(string.Format("{0} {1}", "INSERT INTO", QueryTableName));
                commandText.Append("(");
                commandText.Append(string.Format("`{0}`, ", UbjectMetadata.UBJECT_HASH));
                commandText.Append(string.Format("`{0}`, ", UbjectMetadata.UBJECT_TIMESTAMP));
                commandText.Append(string.Join(", ", propertiesAndValues.Keys.ToList().ConvertAll(x => "`" + x + "`").ToList()));
                commandText.Append(") VALUES (");
                commandText.Append(string.Format("'{0}', ", md5Hash));
                commandText.Append(string.Format("'{0}', ", DateTime.UtcNow.Ticks.ToString()));
                commandText.Append(string.Join(", ", propertiesAndParameters.Values.ToList()));
                commandText.Append(");");
                commandText.Append(string.Format("{0} {1};", "SELECT", "LAST_INSERT_ID()"));

                var    dbQueryExecutor = new DbQueryExecutor(dbManager);
                object data            = dbQueryExecutor.ExecuteScalar(commandText, parameters);

                if (data != null)
                {
                    primaryKey = Convert.ToInt64(data);
                }
            }

            return(primaryKey);
        }
Ejemplo n.º 3
0
        public override void DeleteTable()
        {
            StringBuilder commandText = new StringBuilder();

            commandText.Append(string.Format("DROP TABLE IF EXISTS {0};", TableName));

            var dbQueryExecutor = new DbQueryExecutor(dbManager);

            dbQueryExecutor.ExecuteNonQuery(commandText);
        }
Ejemplo n.º 4
0
        public virtual void DeleteAllObjects()
        {
            StringBuilder commandText = new StringBuilder();

            commandText.Append(string.Format("{0} {1};", "DELETE FROM", QueryTableName));

            var dbQueryExecutor = new DbQueryExecutor(dbManager);

            dbQueryExecutor.ExecuteNonQuery(commandText);
        }
Ejemplo n.º 5
0
        public virtual void DeleteObjectFromTable(string whereClause)
        {
            StringBuilder commandText = new StringBuilder();

            commandText.Append(string.Format("{0} {1} ", "DELETE FROM", QueryTableName));
            commandText.Append(string.Format("{0} {1} {2}", "WHERE", whereClause, "LIMIT 1"));
            commandText.Append(";");

            var dbQueryExecutor = new DbQueryExecutor(dbManager);

            dbQueryExecutor.ExecuteNonQuery(commandText);
        }
Ejemplo n.º 6
0
        public override void AddTrustMode()
        {
            StringBuilder commandText = new StringBuilder();

            commandText.Append(string.Format("ALTER TABLE `{0}` ", TableName));
            commandText.Append(string.Format("ADD COLUMN `TRUSTMODE` INT NOT NULL DEFAULT 0;"));

            var dbQueryExecutor = new DbQueryExecutor(dbManager);

            dbQueryExecutor.ExecuteNonQuery(commandText);

            commandText.Clear();
            commandText.Append(string.Format("ALTER TABLE `{0}` ", TableName));
            commandText.Append("ADD INDEX `TRUSTMODE` (`TRUSTMODE` ASC);");

            dbQueryExecutor.ExecuteNonQuery(commandText);
        }
Ejemplo n.º 7
0
        public override void CloneTable(string newTableName = null)
        {
            if (string.IsNullOrEmpty(newTableName))
            {
                newTableName = string.Format("{0}_backup", TableName);
            }

            StringBuilder commandText = new StringBuilder();

            commandText.Append(string.Format("DROP TABLE IF EXISTS {0};", newTableName));
            commandText.Append(string.Format("CREATE TABLE {0} LIKE {1};", newTableName, TableName));
            commandText.Append(string.Format("INSERT {0} SELECT * FROM {1};", newTableName, TableName));

            var dbQueryExecutor = new DbQueryExecutor(dbManager);

            dbQueryExecutor.ExecuteNonQuery(commandText);
        }
Ejemplo n.º 8
0
        public override void RestoreBackup(string newTableName = null)
        {
            if (!TableName.Contains(backupSuffix))
            {
                throw new Exception("Table is not backup table!");
            }

            string originalTableName = TableName.Substring(0, TableName.Length - backupSuffix.Length);

            StringBuilder commandText = new StringBuilder();

            commandText.Append(string.Format("DROP TABLE IF EXISTS {0};", originalTableName));
            commandText.Append(string.Format("CREATE TABLE {0} LIKE {1};", originalTableName, TableName));
            commandText.Append(string.Format("INSERT {0} SELECT * FROM {1};", originalTableName, TableName));

            var dbQueryExecutor = new DbQueryExecutor(dbManager);

            dbQueryExecutor.ExecuteNonQuery(commandText);
        }
Ejemplo n.º 9
0
 public BaseDbManager()
 {
     dbQueryExecutor = new DbQueryExecutor(this);
 }