Add(DS_SQLite,5980612,1218,595)
{
 Name="working"
 link(onOpen,4346609:doQuery,[])
 link(FileName,9965442:Var2,[])
}
Add(LineBreak,15950049,84,196)
{
 Type=1
 Primary=[6335097,1134,329]
}
Add(DS_SQLite,7350899,1218,679)
{
 Name="archive"
 link(onOpen,7511876:doQuery,[])
 link(FileName,1563383:Var,[])
}
Add(DSC_Query,12791067,1820,644)
{
 SQL="SELECT F, C FROM table1"
 DSManager="export"
 link(onQuery,1283899:doStr,[(1941,650)(1941,608)])
}
Add(FileTools,6184941,1470,602)
{
 link(onEnd,3669303:doEvent1,[])
 link(FileName,16421952:FString,[(1476,548)(1406,548)])
 link(NewFileName,5307685:Var2,[])
}
Add(DS_SQLite,1385547,1610,658)
{
 Name="export"
 link(FileName,6566066:Var2,[])
}
Add(GetDataEx,5307685,1477,567)
{
 link(Data,13894209:FString,[(1483,548)(1532,548)])
}
Add(FormatStr,16297205,1631,609)
{
 DataCount=4
 Mask="attach database "%1" as export;\r\nINSERT INTO table1 %2;\r\nINSERT INTO User SELECT * FROM export.User;\r\nCREATE TABLE number (num int, work char, archive char);\r\nINSERT INTO number VALUES (1, '%3', '%4');\r\nDETACH DATABASE export;"
 link(onFString,4765571:doExec,[])
 link(Str1,9965442:Var3,[(1637,558)])
 link(Str2,13034599:Value,[])
 link(Str3,5554987:Var,[(1651,583)(1700,583)])
 link(Str4,2658117:Var,[(1658,593)(1714,593)])
}
Add(GetDataEx,9965442,1218,553)
{
 link(Data,6335097:Var,[])
}
Add(GetDataEx,6566066,1610,567)
{
 Angle=3
 link(Data,5307685:Var3,[])
}
Add(LineBreak,2377153,1526,665)
{
 link(Out,1385547:doClose,[])
 Primary=[12991325,952,-210]
}
Add(GetDataEx,11114007,1492,519)
{
 Angle=3
 link(Data,8454155:Part,[(1455,524)])
}
Add(DSC_Query,4346609,1267,595)
{
 SQL="Select MAX(C) From table1"
 DSManager="working"
 link(onQuery,16333012:doValue,[])
}
Add(DSC_Query,7511876,1267,679)
{
 SQL="Select MAX(C) From table1"
 DSManager="archive"
 link(onQuery,2341802:doValue,[])
}
Add(Memory,16333012,1316,595)
{
 link(onData,7350899:doOpen,[(1362,601)(1362,640)(1206,640)(1206,685)])
}
Add(LineBreak,11578850,1316,651)
{
 Caption="кол записей"
 Type=1
 link(Data,16333012:Value,[])
 Primary=[5554987,378,-126]
}
Add(Memory,2341802,1316,679)
{
 link(onData,16421952:doString,[(1374,685)(1374,482)])
}
Add(LineBreak,1419937,1316,735)
{
 Caption="кол записей в архиве"
 Type=1
 link(Data,2341802:Value,[])
 Primary=[2658117,392,-189]
}
Add(DSC_Exec,4765571,1680,609)
{
 DSManager="export"
 link(onExec,9917359:doEvent1,[])
}
Add(LineBreak,1710721,441,210)
{
 Type=1
 Primary=[1563383,777,441]
}
Add(MT_String,1283899,1960,602)
{
 Delimeter="; "
 link(onResult,324804:doSplit,[])
}
Add(StrPart,324804,2016,602)
{
 Char=";"
 Point(Left)
 Point(Right)
 link(onSplit,1667564:doStrCat,[(2059,608)(2059,643)(2004,643)(2004,664)])
}
Add(StrCat,1667564,2016,658)
{
 link(onStrCat,10866889:doString,[])
 link(Str1,324804:Left,[])
 link(Str2,324804:Right,[])
}
Add(DSC_Query,16042555,2163,658)
{
 DSManager="working"
 link(onQuery,11119259:doData,[])
}
Add(FormatStr,10866889,2072,658)
{
 Mask="SELECT B FROM %1 WHERE B=1"
 link(onFString,5701976:doEvent1,[])
 link(Str1,16365977:Var1,[(2078,650)(2064,650)])
}
Add(DSC_Exec,13690203,2443,721)
{
 DSManager="export"
 link(onExec,14519742:doWork1,[(2505,727)])
 link(onError,14519742:doWork2,[])
 link(SQL,13975434:Text,[])
}
Add(DSC_Query,395695,1820,609)
{
 SQL="Select COUNT(C>0) From table1"
 DSManager="export"
 link(onQuery,5094291:doOperation,[])
}
Add(Hub,9917359,1785,609)
{
 link(onEvent1,395695:doQuery,[])
 link(onEvent2,12791067:doQuery,[(1809,622)(1809,650)])
}
Add(Math,5094291,1876,609)
{
 OpType=1
 Op2=1
 link(onResult,2617716:doMax,[(1925,615)(1925,720)])
}
Add(Hub,3669303,1512,602)
{
 link(onEvent1,1385547:doOpen,[(1560,608)(1560,664)])
 link(onEvent2,16297205:doString,[])
}
Add(Message,58000,2527,728)
{
}
Add(StrList,4821496,2310,588)
{
}
Add(CounterEx,2617716,2275,707)
{
 Point(doMax)
 Point(onThroughMax)
 link(onThroughMax,2285179:doEnum,[])
}
Add(ArrayEnum,2285179,2324,714)
{
 link(onItem,5554688:doString,[])
 link(onEndEnum,13690203:doExec,[])
 link(Array,4821496:Array,[])
}
Add(DoData,11119259,2219,658)
{
 link(onEventData,4821496:doAdd,[(2282,664)(2282,594)])
 link(Data,16365977:Var3,[(2225,646)(2208,646)(2208,706)])
}
Add(GetDataEx,16365977,2058,701)
{
 Angle=3
 link(Data,1667564:Result,[(2022,706)])
}
Add(Hub,5701976,2114,658)
{
 link(onEvent1,16042555:doQuery,[])
 link(onEvent2,2617716:doNext,[(2142,671)(2142,713)])
}
Add(FormatStr,5554688,2380,714)
{
 DataCount=1
 Mask="CREATE TABLE %1 (A int, B int, C int, D char, E char, F char, G char, H char, I char, J char, K char, L char, M char, N char, O char, P char, Q char, R char, S char, T char, U char, V char, W char, X char, Y char, Z char);"
 link(onFString,13975434:doAdd,[(2428,720)(2428,657)])
 link(Str1,2285179:Item,[(2386,702)(2368,702)(2368,760)(2330,760)])
}
Add(HubEx,14519742,2501,728)
{
 Angle=1
 link(onEvent,58000:doMessage,[(2505,734)])
}
Add(StrList,13975434,2443,651)
{
}
Add(FormatStr,16421952,1400,476)
{
 Mask="%1clear DB\clear.db"
 Point(FString)
 link(onFString,8454155:doPart,[])
}
Add(FilePartElm,8454155,1449,476)
{
 Mode=2
 Point(Part)
 link(onPart,13894209:doString,[])
 link(FileName,5886260:Var,[])
}
Add(Dir,8685002,1400,420)
{
}
Add(LineBreak,9077005,1176,455)
{
 Type=1
 Primary=[5886260,273,-14]
}
Add(FormatStr,13894209,1526,476)
{
 Mask="%1%2.db"
 Point(FString)
 link(onFString,2707037:doReplace,[])
 link(Str2,11114007:Var1,[(1539,456)(1498,456)])
}
Add(Replace,2707037,1589,476)
{
 SubStr="table1"
 DestStr="export.table1"
 link(onReplace,13034599:doValue,[])
 link(Str,10636982:Var,[])
}
Add(LineBreak,15202877,980,616)
{
 Caption="запрос"
 Type=1
 Primary=[10636982,609,-182]
}
Add(Memory,13034599,1638,476)
{
 link(onData,6184941:doCopy,[(1681,482)(1681,563)(1453,563)(1453,615)])
}