 Куда уходит время. Add(MainForm,14842589,217,196) { Left=20 Top=105 Width=782 Height=496 Caption="SQLite_with_SQLiteDataSource" Position=1 link(onCreate,10857796:doOpen,[]) } Add(DS_SQLite,10857796,259,210) { Name="db" link(onOpen,12881291:doExec,[]) } Add(DSC_Query,11075216,686,259) { SQL="SELECT color,mid ,loc ,obj ,x ,y ,z FROM "db";" DSManager="db" link(onQuery,15928964:doAddRow,[]) link(onColumns,15928964:doClear,[(726,272)(726,279)]) } Add(MST_DB,15928964,735,259) { MSTControl="mtst" Point(doClear) } Add(DSC_Exec,12881291,301,210) { @Hint=#19:Создание таблицы БД| @Color=5636010 SQL="PRAGMA page_size=8192;\r\nPRAGMA synchronous=0;\r\nCREATE TABLE IF NOT EXISTS db (\r\n color int NULL,\r\n id TEXT NULL,\r\n mid int(3) NULL,\r\n loc TEXT NULL,\r\n obj TEXT NULL,\r\n x TEXT NULL,\r\n y TEXT NULL,\r\n z TEXT NULL);" DSManager="db" link(onExec,13766098:doExec,[]) AddHint(-106,47,129,13,@Hint) } Add(HTTPClient,6804313,238,133) { URL="ff.zzz.com.ua/load2.php" Method=1 FileName="aaaaaaa.txt" EncType=1 PostData="k=1000\r\nrealm=WoW Circle x1 PvE Virgin " Point(PostData) link(onFinish,6556858:doEvent1,[]) } Add(Charset,2930276,511,147) { Type=7 link(onCharset,7999790:doReplace,[]) } Add(FormatStr,2243243,735,147) { DataCount=1 Mask="INSERT INTO "db" VALUES("%1");" link(onFString,2915680:doWork2,[]) } Add(Str_Enum,3200969,469,147) { Delimiter="_" From=0 link(onEnum,2930276:doCharset,[]) link(onEndEnum,5840020:doEvent1,[(505,160)(505,188)]) } Add(DSC_Exec,9164852,805,189) { DSManager="db" link(SQL,15589579:Text,[]) } Add(Hub,14968106,651,217) { OutCount=4 link(onEvent1,1601606:doStop,[(673,223)(673,202)(324,202)(324,160)]) link(onEvent2,15160768:doQuery,[]) link(onEvent3,11075216:doQuery,[(678,237)(678,265)]) link(onEvent4,13741915:doColAction,[(671,244)(671,300)]) } Add(TimeCounter,9796737,168,126) { link(onStart,3721012:doEvent1,[]) link(onStop,8113430:doText,[(208,139)(208,398)]) } Add(MTStrTbl,3870454,735,294) { Width=766 Height=428 Align=2 Font=[Courier New,8,0,0,204] Name="mtst" Layout="vert_1" HeightScale=100 Columns=#5:MapID|7:Локация|6:Объект|1:X|1:Y|1:Z| NColorRow=0 FlatScroll=1 ColDelimiter="_" ColumnClick=1 ColorItems=0 } Add(Hub,3721012,217,126) { link(onEvent1,13219569:doData,[(375,132)(375,111)]) link(onEvent2,6804313:doLoadString,[]) } Add(DoData,13219569,735,105) { @Color=5636010 Data=String(BEGIN TRANSACTION;) link(onEventData,2915680:doWork1,[(788,111)]) } Add(DoData,9402840,707,182) { @Color=5636010 Data=String(COMMIT;) link(onEventData,16773688:doEvent1,[]) } Add(HubEx,2915680,784,147) { link(onEvent,15589579:doAdd,[]) } Add(Replace,7999790,560,147) { SubStr="','" DestStr="","" link(onReplace,13643654:doDelete,[]) } Add(Delete,13643654,602,147) { Count=1 link(onDelete,16242171:doDelete,[]) } Add(Delete,16242171,644,147) { Count=1 Direction=1 link(onDelete,1045028:doCompare,[]) } Add(MST_ColAction,13741915,686,294) { Action=9 MinColWidth=30 MaxColWidth=200 Index=-1 MSTControl="mtst" Point(doMaxColWidth) } Add(Hub,5840020,560,182) { link(onEvent1,9402840:doData,[]) link(onEvent2,14968106:doEvent1,[(612,195)(612,223)]) } Add(DSC_Query,15160768,686,224) { SQL="SELECT "Добавлено строк: "||count() FROM "db";" DSManager="db" link(onQuery,10980088:doText,[]) } Add(Label,10980088,735,224) { Left=105 Top=436 Width=235 Font=[Courier New,10,1,0,204] Caption="" AutoSize=1 } Add(Button,11711076,98,126) { Left=5 Top=434 link(onClick,9796737:doStart,[]) } Add(DSC_Exec,13766098,343,210) { SQL="VACUUM;" DSManager="db" } Add(If_else,1045028,686,147) { Type=2 Op2=String("") link(onTrue,2243243:doString,[]) } Add(StrList,15589579,805,147) { } Add(Hub,16773688,749,182) { link(onEvent1,2915680:doWork3,[(788,188)]) link(onEvent2,9164852:doExec,[]) } Add(Hub,6556858,273,140) { link(onEvent1,9796737:doStop,[(299,146)(299,170)(157,170)(157,139)]) link(onEvent2,1601606:doStart,[]) } Add(TimeCounter,1601606,336,147) { link(onStart,3200969:doEnum,[]) link(onStop,9831566:doText,[(389,160)(389,377)]) } Add(Label,8113430,504,392) { Left=475 Top=436 } Add(Label,9831566,623,371) { Left=660 Top=436 } Add(Label,5746392,441,406) { Left=405 Top=436 Caption="Закачка" } Add(Label,13024014,581,385) { Left=580 Top=436 Width=70 Caption="Запись БД" }
|