javascript - JS SQLITE, read one database and write to another -


i have following function reads approx 15,000 rows 1 database, formats data , writes another. taking 6 seconds execute. there way without using javascript format data, , using sqlite query? or way speed up?

thanks

      var events = db.open(events.sqlite3);       function updatetimetable() {         var rows = users.execute("select id, complete, strftime('%s000',time) realtime, strftime('%h:%m',time) time exerciselists patientid = ? order time asc", alloy.globals.currentuser);           events.execute("delete events");           events.execute('begin');           while (rows.isvalidrow()) {               var colortype;               var active;               var time = rows.fieldbyname('time');               var realtime = rows.fieldbyname('realtime');               var = new date().gettime();               if (realtime < now) {                   colortype = 'red';                   active = 'no';               } else {                   colortype = 'blue';                   active = 'no';               };               if (rows.fieldbyname('complete')) {                   colortype = 'yellow';               }               if (alloy.globals.sessionbutton.button.sessionid === rows.fieldbyname('id')) {                   colortype = 'green';                   active = 'yes';               }               function pad(n) {                   return n < 10 ? '0' + n : n               }                var d = new date(parseint(realtime));               var dyear = d.getfullyear();               var dday = pad(d.getdate());               var dmonth = pad(d.getmonth()+1);               var dhour = pad(d.gethours()+1);               var dminute = pad(d.getminutes()+1);                var dfinal = dyear + "-" + dmonth + "-" + dday + " " + dhour + ":" + dminute;                events.execute("insert events (title, date_start, date_end, note, location, identifier, type, attendees, organizer) values (?, ?, ?, ?, ?, ?, ?, ?, ?)", time, dfinal, '(null)', rows.fieldbyname('id').tostring(), colortype, rows.fieldbyname('id').tostring(), active, '(null)', '(null)');                rows.next();           }           rows.close();           events.execute('commit');           alloy.globals.refreshtimetable();       };

attach 1 database other, use insert ... select ...:

attach 'users.sqlite' users_db;  insert events (title, date_start, date_end,                     note, location, identifier,                     type, attendees, organizer) select strftime('%h:%m', time),        strftime('%y-%m-%d %h:%m', time),        '(null)',  -- why not null?        id,        case when id = ? /* sessionid */   'green'             when complete                 'yellow'             when time < current_timestamp 'red'             else                               'blue'        end,        id,        case when id = ? /* sessionid */ 'yes'             else                             'no'        end,        '(null)',        '(null)' users_db.exerciselists patientid = ? order time;

Comments

Post a Comment

Popular posts from this blog

monitor web browser programmatically in Android? -

i've got tricky question here. need users make payment bank (namely barclaycard) in uk. so, have https url , add parameters (such amount pay, order reference, etc) url, start http connection intent.actionview, redirect user browser can enter credit card details on bank's webpage , make payment our account successfully. far ? the code use below (i changed values privacy reasons) problem is, need app when user has completed/failed/cancelled payment. barclaycardautomatically redirects particular url when payment has succeeded, 1 if failed. there no way of knowing when barclaycard payment has succeeded go android app somehow ? button cardbutton = (button) findviewbyid(r.id.card_button); cardbutton.setonclicklistener(new view.onclicklistener() { @override public void onclick(view arg0) { string prehashstring = new string(); string prohashstring = new string(); string shapassphrase = new string(); shapassphrase = "gsvth£h70zkh...
Read more

Shrink a YouTube video to responsive width -

i have youtube video embedded on our website , when shrink screen tablet or phone sizes stops shrinking @ around 560px in width. standard youtube videos or there can add code make go smaller? you can make youtube videos responsive css. wrap iframe in div class of "videowrapper" , apply following styles: .videowrapper { float: none; clear: both; width: 100%; position: relative; padding-bottom: 56.25%; padding-top: 25px; height: 0; } .videowrapper iframe { position: absolute; top: 0; left: 0; width: 100%; height: 100%; } the .videowrapper div should inside responsive element. padding on .videowrapper necessary keep video collapsing. may have tweak numbers depending upon layout.
Read more

wpf - PdfWriter.GetInstance throws System.NullReferenceException -

i'm trying create pdf document using itextsharp 5.3.4 using following document document = new document(); filestream stm = new filestream(filename, filemode.create); pdfwriter writer = pdfwriter.getinstance(document, stm); i'm getting system.nullreferenceexception following stack trace: system.nullreferenceexception occurred hresult=-2147467261 message=la référence d'objet n'est pas définie à une instance d'un objet. source=itextsharp stacktrace: à itextsharp.text.version.getinstance() innerexception: i've verified neither document nor stm null, , if select "continue" in vs12 document created - exception thrown. updated itextsharp 5.4.0 , it's still occurring. can't find information on anywhere - got ideas? make sure not catching exceptions. nullreferenceexception can 1 caught , handled inside itextsharp, don't care it. fact can continue supports theory. change following setting verify: debug -> exceptions ...
Read more