Ejemplo n.º 1
0
 public static int getIndexColumnPerName(String name, Table table) 
 {
     for(int i = 0; i < table.Columns.Count;i++)
     {
         if(table.Columns[i].ColumnName.Equals(name))
             return i;
     }
     return -1;
 }
Ejemplo n.º 2
0
 public static Table getTableFromFile(String filePath)
 {
     int counter = 0;
     String line = "";
     Table table = new Table();
     table.Columns = new List<Column>();
     table.Rows = new List<Row>();
     try
     {
         StreamReader reader = new StreamReader(new FileStream(filePath, FileMode.Open, FileAccess.Read, FileShare.ReadWrite), Encoding.Default);
         while ((line = reader.ReadLine()) != null)// && counter < 50)
         {
             String[] fields = line.Split(';');
             if (counter == 0)
             {
                 int i = 1;
                 foreach (String s in fields)
                 {
                     table.Columns.Add(new Column("column" + i));
                     i++;
                 }
             }
             Row row = new Row();
             row.Values = new List<KeyValue>();
             int index = 1;
             foreach (String s in fields)
             {
                 row.Values.Add(new KeyValue("column" + index, cleanValue(s).Replace("\"", "")));
                 index++;
             }
             table.Rows.Add(row);
             counter++;
         }
     }
     catch (Exception e)
     {
         Console.Out.Write(e);
     }
     table.TableName = "Table1";
     table.OriginalTableName = "Table1";
     return table;
 }
Ejemplo n.º 3
0
 public static String getInsertStart(Table t)
 {
     StringBuilder sql = new StringBuilder();
     List<String> columnNames = t.columnNames();
     if ((columnNames != null && columnNames.Count > 0)
         && (t.Rows != null && t.Rows.Count > 0))
     {
         sql.Append("INSERT INTO " + t.TableName);
         sql.Append("(");
         sql.Append(t.columnNames()[0]);
         for (int i = 1; i < t.columnNames().Count(); i++)
             sql.Append("," + t.columnNames()[i]);
         sql.Append(") ");
         sql.Append(Environment.NewLine);
         sql.Append("VALUES ");
         sql.Append(Environment.NewLine);
     }
     return sql.ToString();
 }
        public Template getTemplateFile(String templateFilePath)
        {
            this.templateFilePath = templateFilePath;
            List<String> file = openFile(this.templateFilePath);
            DBConfig dbConfig = new DBConfig();
            TableList tablelist = new TableList(new List<Table>());
            Table table = null;
            foreach (String s in file)
            {
                if (!s.Equals(""))
                {
                    if ("//".Equals(s))
                        tablelist.Tables.Add(table);
                    else
                    {
                        String key = s.Split('=')[0];
                        String value = s.Split('=')[1];

                        if ("Db".Equals(key))
                            dbConfig.Db = value;
                        if ("Server".Equals(key))
                            dbConfig.Server = value;
                        if ("Port".Equals(key))
                            dbConfig.Port = value;
                        if ("User".Equals(key))
                            dbConfig.User = value;
                        if ("Password".Equals(key))
                            dbConfig.Password = value;
                        if("DbName".Equals(key))
                            dbConfig.DbName = value;

                        if ("Table".Equals(key))
                        {
                            table = new Table();
                            table.OriginalTableName = value.Split(':')[0];
                            table.TableName = value.Split(':')[1];
                            table.Columns = new List<Column>();
                        }
                        if ("Column".Equals(key))
                        {
                            String columnNames = value.Split(';')[0];
                            String sqlType = value.Split(';')[1];
                            String pk = value.Split(';')[2];
                            String fk = value.Split(';')[3];
                            String nullabe = value.Split(';')[4];
                            String unique = value.Split(';')[5];
                            String defValue = value.Split(';')[6];
                            String defValueOnError = value.Split(';')[7];
                            String referenceDB = value.Split(';')[8];
                            String referenceTableColum = value.Split(';')[9];
                            String skip = value.Split(';')[10];

                            Column column = new Column(columnNames.Split(':')[0]);
                            column.ColumnName = columnNames.Split(':')[1] == null || columnNames.Split(':')[1].Equals("") ? column.ColumnName : columnNames.Split(':')[1];
                            column.sqlType = sqlType.Split(':')[1] == null || sqlType.Split(':')[1].Equals("") ? column.sqlType : sqlType.Split(':')[1];
                            column.IsPK = pk.Split(':')[1] != null && pk.Split(':')[1].ToLower().Equals("true");
                            column.IsFK = fk.Split(':')[1] != null && fk.Split(':')[1].ToLower().Equals("true");
                            column.IsNullable = nullabe.Split(':')[1] != null && nullabe.Split(':')[1].ToLower().Equals("true");
                            column.IsUnique = unique.Split(':')[1] != null && unique.Split(':')[1].ToLower().Equals("true");
                            column.defaulValue = defValue.Split(':')[1] != null ? defValue.Split(':')[1] : "";
                            column.defaulValueOnError = defValueOnError.Split(':')[1] != null ? defValueOnError.Split(':')[1] : "";
                            column.SKIP = skip.Split(':')[1] != null && skip.Split(':')[1].ToLower().Equals("true");

                            if (column.IsFK)
                                column.Reference = new VO.KeyValue(referenceDB.Split(':')[1], referenceTableColum.Split(':')[1]);
                            table.Columns.Add(column);
                        }
                    }
                }
            }
            return new Template(tablelist, dbConfig);
        }