Exemple #1
0
        public static IEnumerable <int> InserDataCollection(this IDataBaseConnector connector, DataCollection collection,
                                                            string tableName = null, int batchMount = 1000)
        {
            if (tableName == null)
            {
                tableName = collection.Name;
            }
            if (connector.RefreshTableNames().FirstOrDefault(d => d.Name == tableName) == null)
            {
                connector.CreateTable(collection.ComputeData.First(), tableName);
            }
            var i    = 0;
            var list = new List <IFreeDocument>();

            while (i < collection.Count)
            {
                list.Add(collection.ComputeData[i]);
                if (list.Count == batchMount)
                {
                    connector.BatchInsert(list, tableName);
                    list = new List <IFreeDocument>();
                    yield return(i);
                }
                i++;
            }
            connector.BatchInsert(list, collection.Name);
        }
Exemple #2
0
 public static IEnumerable <IFreeDocument> InserDataCollection(this IDataBaseConnector connector, DataCollection collection,
                                                               string tableName = null, int batchMount = 1000)
 {
     return(collection.ComputeData.BatchDo(data =>
     {
         if (tableName == null)
         {
             tableName = collection.Name;
         }
         List <string> columns = new List <string>();
         var sample = data.MergeToDocument();
         columns = data.GetKeys().ToList();
         if (connector.RefreshTableNames().FirstOrDefault(d => d.Name == tableName) == null)
         {
             var result = connector.CreateTable(sample, tableName);
             if (result == false)
             {
                 throw new Exception(String.Format(GlobalHelper.Get("key_349"), tableName));
             }
             // connector.RefreshTableNames();
         }
         return columns;
     }, (list, columns) =>
     {
         connector.BatchInsert(list, (List <string>)columns, collection.Name);
     }));
 }
Exemple #3
0
 public static IEnumerable <IFreeDocument> InserDataCollection(this IDataBaseConnector connector, DataCollection collection,
                                                               string tableName = null, int batchMount = 1000)
 {
     return(collection.ComputeData.BatchDo(data =>
     {
         if (tableName == null)
         {
             tableName = collection.Name;
         }
         if (connector.RefreshTableNames().FirstOrDefault(d => d.Name == tableName) == null)
         {
             connector.CreateTable(data, tableName);
         }
         return true;
     }, list =>
     {
         connector.BatchInsert(list, collection.Name);
     }));
 }