Not logged in.  Login/Logout/Register | List snippets | | Create snippet | Upload image | Upload data

160
LINES

< > BotCompany Repo | #1016871 // Local Snippets DB v2 [with text on disk, OK]

JavaX source code (desktop) [tags: use-pretranspiled] - run with: x30.jar

Download Jar. Transpiled version (21096L) is out of date.

!7

static double updateInterval = 60;
sbool infoBoxes, fullUpdateAtStart = true;
sbool snippetsDB_inited;
sbool autoDownloadText = true;

!include once #1020401 // CSnippet

static Thread downloadThread;

p {
  //restartWith384MBHeap(); // for xfullgrab
  autoRestart10Mins();
  snippetsDB_init();
}

svoid snippetsDB_init() {
  lock programLock();
  if (snippetsDB_inited) ret;
  set snippetsDB_inited;
  db_mainConcepts().autoSaveInterval = 1000*60; // every minute
  db_mainConcepts().noXFullGrab = true;
  dbIndexing(CSnippet, 'snippetID);
  botWithCommandList("Snippets.");
  int n = countConcepts(CSnippet);
  print("Have " + n + " snippet concepts");
  int nUnique = countUnique(collect snippetID(list(CSnippet)));
  print("Have " + nUnique + " snippet IDs");
  
  if (fullUpdateAtStart || countConcepts(CSnippet) == 0) fullDownload();
  doEvery(0, updateInterval, r update);
}

svoid fullDownload { fullDownload(autoDownloadText); }

svoid fullDownload(bool withText) {
  L<Snippet> l = listAllSnippets_fromHourlyCache();
  printWithTime(n(l, "snippet") + " on server");
  slurp(l);
  if (withText) downloadSomeText();
}

static int slurp(L<Snippet> l) {
  lock dbLock();
  int changedSnippets = 0;
  for (Snippet s : l) {
    CSnippet cs = uniq(CSnippet, snippetID := parseSnippetID(s.id));
    int changes = 0;
    changes += cset(cs, title := s.title, type := s.type, isPublic := s.isPublic);
    if (neq(cs.md5, s.md5)) {
      changes += cset(cs, md5 := s.md5);
      if (cs.hasText()) { cs.setText(null); ++changes; }
    }
    if (changes > 0) ++changedSnippets;
  }
  S text = n2(changedSnippets, "changed snippet");
  
  if (infoBoxes && changedSnippets != 0) infoBox(text);
  printWithTime(text);
  ret changedSnippets;
}

// with text if autoDownloadText is true
svoid update {
  L<Snippet> l = listRecentlyChangedSnippets();
  printWithTime(n(l, "snippet") + " on server");
  int changedSnippets = slurp(l);
  if (changedSnippets >= l(l))
    fullDownload(autoDownloadText);
  else if (autoDownloadText)
    downloadSomeText();
}

answer {
  lock dbLock();
  if "full download" {
    fullDownload();
    ret "OK, have " + n(countConcepts(CSnippet), "snippet");
  }
  
  if "update" {
    update();
    ret "OK";
  }
  
  if "download some text" {
    if (downloadThread != null) ret "Already downloading";
    downloadSomeText();
    ret "Yo";
  }
  
  if "stop downloading" {
    cancelThread(downloadThread);
    downloadThread = null;
    ret "OK";
  }
  
  if "get snippet text *" {
    CSnippet c = findConcept(CSnippet, snippetID := parseSnippetID($1));
    if (c == null) ret "not found";
    downloadText(c);
    ret "OK " + quote(c.text());
  }
  
  if "count" ret n2(countConcepts(CSnippet), "snippet");
  
  if "all snippet ids"
    ret struct(map fsI(sorted(collectStrings snippetID(list(CSnippet)))));

  if "kill" { cleanKillIn1(); ret "OK"; }
}

svoid downloadText(CSnippet s) {
  if (s.hasText()) ret;
  if (eq(s.md5, emptyMD5())) ret with s.setText("");
  S text;
  try {
    text = loadSnippet(s.snippetID);
  } catch e {
    if (cic(e.getMessage(), "not found"))
      text = "";
    else
      throw rethrow(e);
  }
  s.setText(text);
}

svoid downloadSomeText {
  lock dbLock();
  if (downloadThread != null) ret;
  downloadThread = startThread(r {
    try {
      int n = 0; for (CSnippet s) if (s.hasText()) ++n;
      printWithTime("Have text for " + n + "/" + n(countConcepts(CSnippet), "concept");
      new ConcurrentEvaluator e;
      e.coresToUse = 10;
      for (final CSnippet s) {
        ping();
        if (!s.hasText()) e.add(r {
          ping();
          downloadText(s);
          /*++n;
          if ((n % 100) == 0)
            printWithTime("Have text for " + n + "/" + n(countConcepts(CSnippet), "concept");*/
        });
      }
      e.startWaitCleanUp();
    } finally {
      downloadThread = null;
    }
  });
}

sS getSnippetText(S snippetID) {
  CSnippet c = findConcept(CSnippet, snippetID := parseSnippetID(snippetID));
  if (c == null) null;
  downloadText(c);
  ret c.text();
}

Author comment

Began life as a copy of #1009918

download  show line numbers  debug dex  old transpilations   

Travelled to 16 computer(s): aoiabmzegqzx, bhatertpkbcr, cbybwowwnfue, cfunsshuasjs, gwrvuhgaqvyk, hpgrupgrauku, irmadwmeruwu, ishqpsrjomds, lpdgvwnxivlt, mqqgnosmbjvj, pyentgdyhuwx, pzhvpgtvlbxg, tslmcundralx, tvejysmllsmz, vouqrxazstgt, xrpafgyirdlv

No comments. add comment

Snippet ID: #1016871
Snippet name: Local Snippets DB v2 [with text on disk, OK]
Eternal ID of this version: #1016871/23
Text MD5: 704a758c13a1034109bacf93c39b9d9d
Author: stefan
Category: javax
Type: JavaX source code (desktop)
Public (visible to everyone): Yes
Archived (hidden from active list): No
Created/modified: 2022-03-12 23:44:19
Source code size: 4211 bytes / 160 lines
Pitched / IR pitched: No / No
Views / Downloads: 581 / 2035
Version history: 22 change(s)
Referenced in: #1014750 - CSnippet (local snippets DB concept - don't confuse with CSnippet from #1016871)
#1016872 - Snippets DB v2 [Dyn Module]
#1017074 - dm_dynModulesOnServer - returns L<virtual #1016871/CSnippet>
#1020401 - CSnippet for #1016871
#1020403 - allSnippetTitlesFromLocalSnippetsDB
#1020535 - dm_allSnippets - returns L<virtual #1016871/CSnippet>