Example #1
0
        static public string GetQuery(MonoSQLiteManager dbManager, ref T table)
        {
            Dictionary <string, ColumnInfo> columns = dbManager.GetTableColumnsInfo(table.GetType());

            System.Type type    = table.GetType();
            FieldInfo[] members = type.GetFields(BindingFlags.Public | BindingFlags.NonPublic | BindingFlags.Instance | BindingFlags.SetField | BindingFlags.GetField);
            FieldInfo   key     = dbManager.GetPrimaryKey(members);

            if (key == null)
            {
                Debug.Log("not Update None PrimaryKey table. name = " + type.Name);
                return(null);
            }

            int keyindex = 0;

            for (int i = 0; i < members.Length; ++i)
            {
                if (key == members[i])
                {
                    keyindex = i;
                    break;
                }
            }
            return("DELETE FROM " + type.Name + " WHERE " + members[keyindex].Name + " = " + members[keyindex].GetValue(table).ToString());
        }
Example #2
0
        static public string GetQuery(MonoSQLiteManager dbManager, string tableName)
        {
            string q = "PRAGMA foreign_keys\n";

            q += "PRAGMA foreign_keys = \"0\";";
            q  = "DROP TABLE " + "`" + tableName + "`";
            return(q);
        }
Example #3
0
        static public string GetQuery(MonoSQLiteManager dbManager, ref T table)
        {
            Dictionary <string, ColumnInfo> columns = dbManager.GetTableColumnsInfo(table.GetType());

            System.Type type    = table.GetType();
            FieldInfo[] members = type.GetFields(BindingFlags.Public | BindingFlags.NonPublic | BindingFlags.Instance | BindingFlags.SetField | BindingFlags.GetField);
            FieldInfo   key     = dbManager.GetPrimaryKey(members);

            if (key == null)
            {
                Debug.Log("not Update None PrimaryKey table. name = " + type.Name);
                return(null);
            }

            int keyindex = 0;

            for (int i = 0; i < members.Length; ++i)
            {
                if (key == members[i])
                {
                    keyindex = i;
                    break;
                }
            }


            string q         = "UPDATE " + type.Name + " SET ";
            string columns_q = "";

            for (int i = 0; i < members.Length; ++i)
            {
                if (keyindex == i)
                {
                    continue;
                }
                if (columns_q.Length > 0)
                {
                    columns_q += ",";
                }

                columns_q += members[i].Name;
                columns_q += "=";
                if (members[i].FieldType == typeof(string) || members[i].FieldType == typeof(char))
                {
                    columns_q += "\"";
                }
                columns_q += members[i].GetValue(table).ToString();
                if (members[i].FieldType == typeof(string) || members[i].FieldType == typeof(char))
                {
                    columns_q += "\"";
                }
            }


            q += columns_q + " where " + members[keyindex].Name + "= " + members[keyindex].GetValue(table).ToString();
            return(q);
        }
Example #4
0
        static public string GetQuery(MonoSQLiteManager dbManager, string originName, string toCopyTable)
        {
            HashSet <string> SameDataType = new HashSet <string>();
            Dictionary <string, ColumnInfo> copyColumns   = dbManager.GetDBTableColumnsInfo(toCopyTable);
            Dictionary <string, ColumnInfo> selectColumns = dbManager.GetDBTableColumnsInfo(originName);

            foreach (KeyValuePair <string, ColumnInfo> c in copyColumns)
            {
                if (selectColumns.ContainsKey(c.Key))
                {
                    if (selectColumns [c.Key]._dataType == c.Value._dataType)
                    {
                        SameDataType.Add(c.Key);
                    }
                }

                /*
                 * if(c.Value._attribute.IndexOf(AUTOINCREMENT.Key) > 0 ||
                 *  c.Value._attribute.IndexOf(PRIMARY_KEY.Key) > 0)
                 *  notSameDataType.Add(c.Key);
                 * */
            }

            string insertQ        = "INSERT INTO " + toCopyTable + " ";
            string selectQ        = " SELECT ";
            string selectColumnsQ = "";
            string insertColumnsQ = "(";

            foreach (KeyValuePair <string, ColumnInfo> column in copyColumns)
            {
                if (SameDataType.Contains(column.Key))
                {
                    if (selectColumnsQ.Length > 0)
                    {
                        selectColumnsQ += ",";
                        insertColumnsQ += ",";
                    }

                    selectColumnsQ += "`";
                    selectColumnsQ += column.Key;
                    selectColumnsQ += "`";

                    insertColumnsQ += column.Key;
                }
            }
            insertColumnsQ += ") ";
            insertQ        += insertColumnsQ;
            selectQ        += selectColumnsQ;
            selectQ        += " FROM " + "`" + originName + "`";
            return(insertQ + selectQ);
        }
Example #5
0
        static public string GetQuery(MonoSQLiteManager dbManager, System.Type table)
        {
            Dictionary <string, ColumnInfo> columns = new Dictionary <string, ColumnInfo>();

            FieldInfo[] fields = table.GetFields();
            for (int i = 0; i < fields.Length; ++i)
            {
                string     attributes = DBFieldAttribute.GetDBAttributes(fields[i]);
                ColumnInfo c          = new ColumnInfo(fields[i].Name, dbManager.GetCTypeToSqlType(fields[i].FieldType), attributes);
                columns.Add(c._name, c);
            }

            return(GetQuery(dbManager, table.Name, columns));
        }
Example #6
0
        static public string GetQuery(MonoSQLiteManager dbManager, ref T table)
        {
            Dictionary <string, ColumnInfo> columns = dbManager.GetTableColumnsInfo(table.GetType());

            System.Type type    = table.GetType();
            FieldInfo[] members = type.GetFields(BindingFlags.Public | BindingFlags.NonPublic | BindingFlags.Instance | BindingFlags.SetField | BindingFlags.GetField);
            FieldInfo   key     = dbManager.GetPrimaryKey(members);

            string q         = "INSERT INTO " + table.GetType().Name + " (";
            string columns_q = "";
            string value_q   = " values(";

            for (int i = 0; i < members.Length; ++i)
            {
                if (members[i] == key)
                {
                    continue;
                }

                if (columns_q.Length > 0)
                {
                    columns_q += ",";
                    value_q   += ",";
                }

                columns_q += members[i].Name;
                if (members[i].FieldType == typeof(string) || members[i].FieldType == typeof(char))
                {
                    value_q += "'";
                    value_q += members[i].GetValue(table);
                    value_q += "'";
                }
                else
                {
                    value_q += members[i].GetValue(table).ToString();
                }
            }

            q += columns_q + ")";
            q += value_q + ")";
            return(q);
        }
Example #7
0
        static public string GetQuery(MonoSQLiteManager dbManager, string tableName, Dictionary <string, ColumnInfo> columns)
        {
            string q        = "CREATE TABLE " + tableName + " (";
            string q_fields = "";

            foreach (KeyValuePair <string, ColumnInfo> c in columns)
            {
                if (q_fields.Length > 0)
                {
                    q_fields += ",";
                }

                q_fields += "`";
                q_fields += c.Key;
                q_fields += "`";
                q_fields += " ";
                q_fields += c.Value._dataType;
                q_fields += " ";
                q_fields += c.Value._attribute;
            }
            q += q_fields;
            q += " )";
            return(q);
        }
Example #8
0
 internal CreateTable(MonoSQLiteManager dbManager, string tableName, Dictionary <string, ColumnInfo> columns, bool isBackup = true) : base(dbManager)
 {
     _tableName = tableName;
     _columns   = columns;
     _isBackup  = isBackup;
 }
Example #9
0
 internal CloneTable(MonoSQLiteManager dbManager, string originName, string cloneName) : base(dbManager)
 {
     _originName = originName;
     _cloneName  = cloneName;
 }
Example #10
0
 internal UpdateTable(MonoSQLiteManager dbManager, ref T table) : base(dbManager)
 {
     _table = table;
 }
Example #11
0
 internal CreateTable(MonoSQLiteManager dbManager, System.Type table, bool isBackup = true) : base(dbManager)
 {
     _table     = table;
     _tableName = table.Name;
     _isBackup  = isBackup;
 }
Example #12
0
 internal DropTable(MonoSQLiteManager dbManager, string tableName) : base(dbManager)
 {
     _tableName = tableName;
 }
Example #13
0
 internal InsertTable(MonoSQLiteManager dbManager, ref T table)
     : base(dbManager)
 {
     _table = table;
 }
Example #14
0
 internal CopyTable(MonoSQLiteManager dbManager, string originName, string toCopyTable) : base(dbManager)
 {
     _originName  = originName;
     _toCopyTable = toCopyTable;
 }
Example #15
0
 protected QueryContainer(MonoSQLiteManager dbManager)
 {
     _dbManager = dbManager;
 }
Example #16
0
        static public string GetQuery(MonoSQLiteManager dbManager, string tableName, string columnName, System.Type type)
        {
            string fieldType = dbManager.GetCTypeToSqlType(type);

            return("ALTER TABLE " + tableName + " ADD COLUMN " + columnName + " " + fieldType);
        }
Example #17
0
 internal AddColumn(MonoSQLiteManager dbManager, string tableName, string columnName, System.Type type) : base(dbManager)
 {
     _tableName  = tableName;
     _type       = type;
     _columnName = columnName;
 }
Example #18
0
 static public string GetQuery(MonoSQLiteManager dbManager, string originName, string cloneName)
 {
     return("CREATE TABLE " + cloneName + " AS SELECT * FROM " + originName);
 }