[{"_1":2,"_245":-5,"_246":-5},"loaderData",{"_3":4,"_91":92,"_198":199},"root",{"_5":6,"_34":35,"_64":65},"ctx",{"_7":8,"_23":-5,"_24":25,"_26":27,"_28":22,"_29":22,"_30":22,"_31":32,"_33":22},"auth",{"_9":10,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5,"_18":-5,"_19":-5,"_20":-5,"_21":22},"tokenType","session_token","sessionClaims","sessionId","sessionStatus","userId","actor","orgId","orgRole","orgSlug","orgPermissions","factorVerificationAge","isAuthenticated",false,"user","preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","notificationCount",0,"flagDenols","ENV",{"_36":37,"_38":39,"_40":41,"_42":43,"_44":45,"_46":47,"_48":49,"_50":51,"_52":53,"_54":55,"_56":57,"_58":59,"_60":61,"_62":63},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","VAL_RUNTIME_NAME","prod","RENDER_GIT_COMMIT","cb8a548cff96feeeeb30b528c9619e76cb377f13","RENDER_GIT_BRANCH","main","CLERK_PUBLISHABLE_KEY","pk_live_Y2xlcmsudmFsLnRvd24k","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","API_URL","https://api.val.town","clerkState",{"_66":67},"__internal_clerk_state",{"_68":69,"_70":45,"_71":72,"_73":72,"_74":22,"_75":72,"_76":72,"_77":72,"_78":72,"_79":80,"_89":22,"_90":22},"__clerk_ssr_state",{"_9":10,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5,"_18":-5,"_19":-5,"_20":-5,"_21":22},"__publishableKey","__proxyUrl","","__domain","__isSatellite","__signInUrl","__signUpUrl","__afterSignInUrl","__afterSignUpUrl","__clerk_debug",{"_81":22,"_21":22,"_82":72,"_83":84,"_85":72,"_86":45,"_87":22,"_88":72},"isSignedIn","proxyUrl","reason","session-token-and-uat-missing","message","publishableKey","isSatellite","domain","__telemetryDisabled","__telemetryDebug","routes/_app.x.$handle.$name",{"_93":94,"_95":96,"_97":43,"_98":99,"_100":-7,"_101":102,"_148":149,"_179":180,"_181":182,"_187":188,"_162":189,"_192":-5,"_193":-5,"_194":22,"_195":22,"_196":197},"handle","rozek","name","InvocationTracker","branchName","path","main.tsx","version","project",{"_103":104,"_95":96,"_105":106,"_107":-5,"_108":109,"_110":111,"_112":-5,"_113":-5,"_14":114,"_115":-5,"_116":109,"_117":-5,"_118":32,"_16":119,"_120":121,"_122":121,"_123":124,"_125":124,"_126":124,"_127":121,"_128":121,"_23":129,"_132":133,"_135":136,"_147":22},"id","94dc2328-26d5-11f0-a5b3-569c3dd06744","createdAt",["D",1746135921580],"deletedAt","legacyEnvVars",true,"privacy","public","description","imageUrl","1678d123-c574-4afe-8768-fb0515c072b3","pinnedFileId","pinPreview","screenshotVersion","likeCount","868ff51d-0dea-4fa9-9266-d3e632613c42","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm",{"_93":94,"_130":131},"profileImageUrl","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18ybjB5SWh3N1NZbElndXIzcnRoT2tlVGFQMFoifQ","org",{"_93":94,"_134":131},"avatar","branch",{"_100":137,"_95":43,"_103":138,"_139":104,"_140":-5,"_141":-5,"_142":-5,"_143":-5,"_144":-5,"_145":96,"_146":94},6,"94dc7102-26d5-11f0-a5b3-569c3dd06744","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","isOwned","tree",[150,170],{"_103":151,"_95":152,"_153":154,"_155":-5,"_156":138,"_157":158,"_159":109,"_105":160,"_100":32,"_161":162,"_163":164,"_165":22,"_166":-5,"_167":168,"_98":169},"94ded708-26d5-11f0-a5b3-569c3dd06744","README.md","fileId","94ded79e-26d5-11f0-a5b3-569c3dd06744","parentId","branchId","branchVersion",1,"latest",["D",1738124624397],"fileType","file","content","If you make a val public, you may probably also want to see how often that val is used - perhaps even including some statistics which show how often that val was called in a given time span. This is exactly what the \"InvocationTracker\" was written for.\n\nSimply include a call to the \"InvocationTracker\" in your val, and from then on any invocations will be tracked in an sqlite table allowing you to easily calculate how often the val was used in total or get the time course of calls.\n\n\n## Usage Example ##\n\nUsing an `InvocationTracker` (within the val that should be monitored) is quite simple:\n\n```javascript\nimport { InvocationTracker } from 'https://esm.town/v/rozek/InvocationTracker'\n\nconst TrackingTable = 'xxx' // enter name of sqlite table that can be used\nconst Granularity = 15*60*1000 // how precisely should be logged?\n\n;(async () => {\n const Tracker = await InvocationTracker.new(TrackingTable,Granularity)\n await Tracker.increment() // logs this invocation\n \n ... now continue as usual\n})()\n```\n\nLater, you may then use the \"InvocationTracker\" to provide you with some statistics:\n\n```javascript\nimport { InvocationTracker } from 'https://esm.town/v/rozek/InvocationTracker'\n\nconst TrackingTable = 'xxx' // enter name of sqlite table that can be used\n\n;(async () => {\n const Tracker = await InvocationTracker.new(TrackingTable,Granularity)\n\n/**** define the time span that interests you ****/\n\n const from = new Date('xxx').getTime() // enter start date of your time span\n const to = Date.now() // here we are interested in all invocations until now\n\n/**** get the total number of invocations in the given time span ****/\n\n const totalInvocations = await Tracker.totalInvocationsInSpan(from,to)\n\n/**** get more information about when your val was called over time ****/\n\n const Invocations = await Tracker.InvocationsInSpan(from,to)\n// format: [{ Time,Invocations },...] with the given granularity\n// only times with actual invocations are listed, idle times are skipped\n})()\n```\n\n**The \"InvocationTracker\" is designed to be accessed simultaneously from multiple concurrently running vals without interfering with each other.**\n\n## API Reference ##\n\n- `static async new (Name:string, Granularity:number = 15*60*1000):Promise`
\ncreates a new \"InvocationTracker\" instance. `Name` must match `/^[a-z_][0-9a-z_]+$/i`, `Granularity` is the time resolution in milliseconds\n- `async Granularity ():Promise`
\nreturns the current time resolution in milliseconds\n- `async setGranularity (newGranularity:number):Promise`
\nsets a new time resolution (in milliseconds). `newGranularity` must be an integer >= 1\n- `async reset ():Promise`
\nclears all recorded invocations\n- `async increment ():Promise`
\nincrements the invocation count for the current time period\n- `async InvocationsInSpan (from:number, to:number):Promise<{ Time:number, Invocations:number }[]>`
\nreturns a list of invocation counts within the specified time span. `from` and `to` are Unix timestamps in milliseconds\n- `async totalInvocationsInSpan (from:number, to:number):Promise`
\nreturns the total number of invocations within the specified time span. `from` and `to` are Unix timestamps in milliseconds\n\n## Tests ##\n\nSome tests can be found in val [InvocationTracker_Test](https://www.val.town/v/rozek/InvocationTracker_Test)","deleted","label","children",[],[152],{"_103":171,"_95":99,"_153":172,"_155":-5,"_156":138,"_157":137,"_159":109,"_105":173,"_100":174,"_161":175,"_163":176,"_165":22,"_166":-5,"_167":177,"_98":178},"94fe2400-26d5-11f0-a5b3-569c3dd06744","94ded172-26d5-11f0-a5b3-569c3dd06744",["D",1738165195492],5,"script","import { sqlite } from 'https://esm.town/v/stevekrouse/sqlite'\nimport {\n expectStringMatching, expectOrdinal, expectCardinal,expectedCardinal, throwError\n} from 'https://rozek.github.io/javascript-interface-library/dist/javascript-interface-library.esm.js'\n\nexport class InvocationTracker {\n private _Name:string\n\n/**** private constructor ****/\n\n private constructor(Name: string) {\n this._Name = Name\n }\n\n/**** async factory method InvocationTracker.new ****/\n\n static async new(\n Name:string, Granularity:number=15*60*1000\n ):Promise {\n expectStringMatching ('name',Name, /^[a-z_][0-9a-z_]+$/i)\n expectCardinal('granularity',Granularity)\n\n const Tracker = new InvocationTracker(Name)\n\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${Name}_Info (\n Granularity INTEGER NOT NULL\n )\n `)\n\n await sqlite.execute(`\n INSERT INTO ${Name}_Info (Granularity)\n SELECT ${Granularity}\n WHERE NOT EXISTS (SELECT 1 FROM ${Name}_Info)\n `)\n\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${Name}_Log (\n Time INTEGER NOT NULL PRIMARY KEY,\n Invocations INTEGER NOT NULL DEFAULT 0\n )\n `)\n\n return Tracker\n }\n\n/**** async Granularity ****/\n\n async Granularity ():Promise {\n const QueryResult = await sqlite.execute(\n `SELECT Granularity FROM ${this._Name}_Info LIMIT 1`\n )\n return QueryResult.rows[0].Granularity\n }\n\n/**** async setGranularity ****/\n\n async setGranularity (newGranularity:number):Promise {\n const Granularity = expectedCardinal('Granularity', newGranularity)\n await sqlite.execute(\n `UPDATE ${this._Name}_Info SET Granularity = ?`, [Granularity]\n )\n }\n\n/**** async reset ****/\n\n async reset ():Promise {\n await sqlite.execute(`DELETE FROM ${this._Name}_Log`)\n }\n\n/**** async increment ****/\n\n async increment ():Promise {\n const currentTime = Date.now()\n const Granularity = await this.Granularity()\n\n const roundedTime = Math.floor(currentTime / Granularity) * Granularity\n\n await sqlite.execute(`\n INSERT INTO ${this._Name}_Log (Time, Invocations)\n VALUES (?, 1)\n ON CONFLICT (Time) DO UPDATE SET Invocations = Invocations + 1\n `, [roundedTime])\n }\n\n/**** async InvocationsInSpan ****/\n\n async InvocationsInSpan (\n from:number, to:number\n ):Promise<{ Time:number, Invocations:number }[]> {\n expectOrdinal('start time',from)\n expectCardinal ('end time',to)\n\n if (from > to) throwError('invalid time span')\n\n const Granularity = await this.Granularity()\n const roundedFrom = Math.floor(from / Granularity) * Granularity\n\n const QueryResult = await sqlite.execute(`\n SELECT Time, Invocations\n FROM ${this._Name}_Log\n WHERE Time >= ? AND Time <= ?\n ORDER BY Time ASC\n `, [roundedFrom, to])\n\n return QueryResult.rows.map(\n (Row:any) => ({ Time:Row.Time, Invocations:Row.Invocations })\n )\n }\n\n/**** async totalInvocationsInSpan ****/\n\n async totalInvocationsInSpan (from:number, to:number):Promise {\n expectOrdinal('start time',from)\n expectCardinal ('end time',to)\n\n if (from > to) throwError('invalid time span')\n\n const Granularity = await this.Granularity()\n const roundedFrom = Math.floor(from / Granularity) * Granularity\n\n const QueryResult = await sqlite.execute(`\n SELECT SUM(Invocations) as TotalInvocations\n FROM ${this._Name}_Log\n WHERE Time >= ? AND Time <= ?\n `, [roundedFrom, to])\n\n return QueryResult.rows[0].TotalInvocations || 0\n }\n}\n",[],[99],"files",[150,170],"counts",{"_183":32,"_184":158,"_185":32,"_186":32},"pulls","branches","forks","envVars","contents",[],{"_103":171,"_95":99,"_153":172,"_155":-5,"_156":138,"_157":137,"_159":109,"_105":190,"_100":174,"_161":175,"_163":176,"_165":22,"_166":-5,"_98":191},["D",1738165195492],[99],"upstreamProject","upstreamBranch","emptyEnvVars","isNew","flags",[],"routes/_app.x.$handle.$name.branch.$branch.history_.$",{"_93":94,"_95":96,"_97":43,"_98":99,"_101":200,"_162":205,"_208":209,"_233":234,"_242":-7,"_243":32,"_244":22},{"_103":104,"_95":96,"_105":201,"_107":-5,"_108":109,"_110":111,"_112":-5,"_113":-5,"_14":114,"_115":-5,"_116":109,"_117":-5,"_118":32,"_16":119,"_120":121,"_122":121,"_123":124,"_125":124,"_126":124,"_127":121,"_128":121,"_23":202,"_132":203,"_135":204,"_147":22},["D",1746135921580],{"_93":94,"_130":131},{"_93":94,"_134":131},{"_100":137,"_95":43,"_103":138,"_139":104,"_140":-5,"_141":-5,"_142":-5,"_143":-5,"_144":-5,"_145":96,"_146":94},{"_103":171,"_95":99,"_153":172,"_155":-5,"_156":138,"_157":137,"_159":109,"_105":206,"_100":174,"_161":175,"_163":176,"_165":22,"_166":-5,"_98":207},["D",1738165195492],[99],"history",[210,212,217,222,226,230],{"_103":171,"_156":138,"_153":172,"_95":99,"_163":176,"_161":175,"_100":174,"_155":-5,"_105":211,"_157":137,"_166":-5},["D",1738165195492],{"_103":213,"_156":138,"_153":172,"_95":99,"_163":214,"_161":175,"_100":215,"_155":-5,"_105":216,"_157":174,"_166":-5},"94f84eae-26d5-11f0-a5b3-569c3dd06744","import { sqlite } from 'https://esm.town/v/stevekrouse/sqlite'\nimport {\n expectStringMatching, expectOrdinal, expectCardinal,expectedCardinal, throwError\n} from 'https://rozek.github.io/javascript-interface-library/dist/javascript-interface-library.esm.js'\n\nexport class InvocationTracker {\n private _Name:string\n\n/**** private constructor ****/\n\n private constructor(Name: string) {\n this._Name = Name\n }\n\n/**** async factory method InvocationTracker.new ****/\n\n static async new(\n Name:string, Granularity:number=15*60*1000\n ):Promise {\n expectStringMatching ('name',Name, /^[a-z_]+$/i)\n expectCardinal('granularity',Granularity)\n\n const Tracker = new InvocationTracker(Name)\n\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${Name}_Info (\n Granularity INTEGER NOT NULL\n )\n `)\n\n await sqlite.execute(`\n INSERT INTO ${Name}_Info (Granularity)\n SELECT ${Granularity}\n WHERE NOT EXISTS (SELECT 1 FROM ${Name}_Info)\n `)\n\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${Name}_Log (\n Time INTEGER NOT NULL PRIMARY KEY,\n Invocations INTEGER NOT NULL DEFAULT 0\n )\n `)\n\n return Tracker\n }\n\n/**** async Granularity ****/\n\n async Granularity ():Promise {\n const QueryResult = await sqlite.execute(\n `SELECT Granularity FROM ${this._Name}_Info LIMIT 1`\n )\n return QueryResult.rows[0].Granularity\n }\n\n/**** async setGranularity ****/\n\n async setGranularity (newGranularity:number):Promise {\n const Granularity = expectedCardinal('Granularity', newGranularity)\n await sqlite.execute(\n `UPDATE ${this._Name}_Info SET Granularity = ?`, [Granularity]\n )\n }\n\n/**** async reset ****/\n\n async reset ():Promise {\n await sqlite.execute(`DELETE FROM ${this._Name}_Log`)\n }\n\n/**** async increment ****/\n\n async increment ():Promise {\n const currentTime = Date.now()\n const Granularity = await this.Granularity()\n\n const roundedTime = Math.floor(currentTime / Granularity) * Granularity\n\n await sqlite.execute(`\n INSERT INTO ${this._Name}_Log (Time, Invocations)\n VALUES (?, 1)\n ON CONFLICT (Time) DO UPDATE SET Invocations = Invocations + 1\n `, [roundedTime])\n }\n\n/**** async InvocationsInSpan ****/\n\n async InvocationsInSpan (\n from:number, to:number\n ):Promise<{ Time:number, Invocations:number }[]> {\n expectOrdinal('start time',from)\n expectCardinal ('end time',to)\n\n if (from > to) throwError('invalid time span')\n\n const Granularity = await this.Granularity()\n const roundedFrom = Math.floor(from / Granularity) * Granularity\n\n const QueryResult = await sqlite.execute(`\n SELECT Time, Invocations\n FROM ${this._Name}_Log\n WHERE Time >= ? AND Time <= ?\n ORDER BY Time ASC\n `, [roundedFrom, to])\n\n return QueryResult.rows.map(\n (Row:any) => ({ Time:Row.Time, Invocations:Row.Invocations })\n )\n }\n\n/**** async totalInvocationsInSpan ****/\n\n async totalInvocationsInSpan (from:number, to:number):Promise {\n expectOrdinal('start time',from)\n expectCardinal ('end time',to)\n\n if (from > to) throwError('invalid time span')\n\n const Granularity = await this.Granularity()\n const roundedFrom = Math.floor(from / Granularity) * Granularity\n\n const QueryResult = await sqlite.execute(`\n SELECT SUM(Invocations) as TotalInvocations\n FROM ${this._Name}_Log\n WHERE Time >= ? AND Time <= ?\n `, [roundedFrom, to])\n\n return QueryResult.rows[0].TotalInvocations || 0\n }\n}\n",4,["D",1738164828488],{"_103":218,"_156":138,"_153":172,"_95":99,"_163":219,"_161":175,"_100":220,"_155":-5,"_105":221,"_157":215,"_166":-5},"94f0fb86-26d5-11f0-a5b3-569c3dd06744","import { sqlite } from 'https://esm.town/v/stevekrouse/sqlite'\nimport {\n expectStringMatching, expectOrdinal, expectCardinal,expectedCardinal, throwError\n} from 'https://rozek.github.io/javascript-interface-library/dist/javascript-interface-library.esm.js'\n\nexport class InvocationTracker {\n private _Name:string\n\n/**** private constructor ****/\n\n private constructor(Name: string) {\n this._Name = Name\n }\n\n/**** async factory method InvocationTracker.new ****/\n\n static async new(\n Name:string, Granularity:number=15*60*1000\n ):Promise {\n expectStringMatching ('name',Name, /^[a-zA-Z_]+$/i)\n expectCardinal('granularity',Granularity)\n\n const Tracker = new InvocationTracker(Name)\n\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${Name}_Info (\n Granularity INTEGER NOT NULL\n )\n `)\n\n await sqlite.execute(`\n INSERT INTO ${Name}_Info (Granularity)\n SELECT ${Granularity}\n WHERE NOT EXISTS (SELECT 1 FROM ${Name}_Info)\n `)\n\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${Name}_Log (\n Time INTEGER NOT NULL PRIMARY KEY,\n Invocations INTEGER NOT NULL DEFAULT 0\n )\n `)\n\n return Tracker\n }\n\n/**** async Granularity ****/\n\n async Granularity ():Promise {\n const QueryResult = await sqlite.execute(\n `SELECT Granularity FROM ${this._Name}_Info LIMIT 1`\n )\n return QueryResult.rows[0].Granularity\n }\n\n/**** async setGranularity ****/\n\n async setGranularity (newGranularity:number):Promise {\n const Granularity = expectedCardinal('Granularity', newGranularity)\n await sqlite.execute(\n `UPDATE ${this._Name}_Info SET Granularity = ?`, [Granularity]\n )\n }\n\n/**** async reset ****/\n\n async reset ():Promise {\n await sqlite.execute(`DELETE FROM ${this._Name}_Log`)\n }\n\n/**** async increment ****/\n\n async increment ():Promise {\n const currentTime = Date.now()\n const Granularity = await this.Granularity()\n\n const roundedTime = Math.floor(currentTime / Granularity) * Granularity\n\n await sqlite.execute(`\n INSERT INTO ${this._Name}_Log (Time, Invocations)\n VALUES (?, 1)\n ON CONFLICT (Time) DO UPDATE SET Invocations = Invocations + 1\n `, [roundedTime])\n }\n\n/**** async InvocationsInSpan ****/\n\n async InvocationsInSpan (\n from:number, to:number\n ):Promise<{ Time:number, Invocations:number }[]> {\n expectOrdinal('start time',from)\n expectCardinal ('end time',to)\n\n if (from > to) throwError('invalid time span')\n\n const Granularity = await this.Granularity()\n const roundedFrom = Math.floor(from / Granularity) * Granularity\n\n const QueryResult = await sqlite.execute(`\n SELECT Time, Invocations\n FROM ${this._Name}_Log\n WHERE Time >= ? AND Time <= ?\n ORDER BY Time ASC\n `, [roundedFrom, to])\n\n return QueryResult.rows.map(\n (Row:any) => ({ Time:Row.Time, Invocations:Row.Invocations })\n )\n }\n\n/**** async totalInvocationsInSpan ****/\n\n async totalInvocationsInSpan (from:number, to:number):Promise {\n expectOrdinal('start time',from)\n expectCardinal ('end time',to)\n\n if (from > to) throwError('invalid time span')\n\n const Granularity = await this.Granularity()\n const roundedFrom = Math.floor(from / Granularity) * Granularity\n\n const QueryResult = await sqlite.execute(`\n SELECT SUM(Invocations) as TotalInvocations\n FROM ${this._Name}_Log\n WHERE Time >= ? AND Time <= ?\n `, [roundedFrom, to])\n\n return QueryResult.rows[0].TotalInvocations || 0\n }\n}\n",3,["D",1738164502217],{"_103":223,"_156":138,"_153":172,"_95":99,"_163":214,"_161":175,"_100":224,"_155":-5,"_105":225,"_157":220,"_166":-5},"94eb5492-26d5-11f0-a5b3-569c3dd06744",2,["D",1738135706500],{"_103":227,"_156":138,"_153":172,"_95":99,"_163":228,"_161":175,"_100":158,"_155":-5,"_105":229,"_157":224,"_166":-5},"94e5962e-26d5-11f0-a5b3-569c3dd06744","import { sqlite } from 'https://esm.town/v/stevekrouse/sqlite'\nimport {\n expectStringMatching, expectOrdinal, expectCardinal,expectedCardinal, throwError\n} from 'https://rozek.github.io/javascript-interface-library/dist/javascript-interface-library.esm.js'\n\nexport class InvocationTracker {\n private _Name:string\n\n/**** private constructor ****/\n\n private constructor(Name: string) {\n this._Name = Name\n }\n\n/**** async factory method InvocationTracker.new ****/\n\n static async new(\n Name:string, Granularity:number\n ):Promise {\n expectStringMatching ('name',Name, /^[a-z_]+$/i)\n expectCardinal('granularity',Granularity)\n\n const Tracker = new InvocationTracker(Name)\n\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${Name}_Info (\n Granularity INTEGER NOT NULL\n )\n `)\n\n await sqlite.execute(`\n INSERT INTO ${Name}_Info (Granularity)\n SELECT ${Granularity}\n WHERE NOT EXISTS (SELECT 1 FROM ${Name}_Info)\n `)\n\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${Name}_Log (\n Time INTEGER NOT NULL PRIMARY KEY,\n Invocations INTEGER NOT NULL DEFAULT 0\n )\n `)\n\n return Tracker\n }\n\n/**** async Granularity ****/\n\n async Granularity ():Promise {\n const QueryResult = await sqlite.execute(\n `SELECT Granularity FROM ${this._Name}_Info LIMIT 1`\n )\n return QueryResult.rows[0].Granularity\n }\n\n/**** async setGranularity ****/\n\n async setGranularity (newGranularity:number):Promise {\n const Granularity = expectedCardinal('Granularity', newGranularity)\n await sqlite.execute(\n `UPDATE ${this._Name}_Info SET Granularity = ?`, [Granularity]\n )\n }\n\n/**** async reset ****/\n\n async reset ():Promise {\n await sqlite.execute(`DELETE FROM ${this._Name}_Log`)\n }\n\n/**** async increment ****/\n\n async increment ():Promise {\n const currentTime = Date.now()\n const Granularity = await this.Granularity()\n\n const roundedTime = Math.floor(currentTime / Granularity) * Granularity\n\n await sqlite.execute(`\n INSERT INTO ${this._Name}_Log (Time, Invocations)\n VALUES (?, 1)\n ON CONFLICT (Time) DO UPDATE SET Invocations = Invocations + 1\n `, [roundedTime])\n }\n\n/**** async InvocationsInSpan ****/\n\n async InvocationsInSpan (\n from:number, to:number\n ):Promise<{ Time:number, Invocations:number }[]> {\n expectOrdinal('start time',from)\n expectCardinal ('end time',to)\n\n if (from > to) throwError('invalid time span')\n\n const Granularity = await this.Granularity()\n const roundedFrom = Math.floor(from / Granularity) * Granularity\n\n const QueryResult = await sqlite.execute(`\n SELECT Time, Invocations\n FROM ${this._Name}_Log\n WHERE Time >= ? AND Time <= ?\n ORDER BY Time ASC\n `, [roundedFrom, to])\n\n return QueryResult.rows.map(\n (Row:any) => ({ Time:Row.Time, Invocations:Row.Invocations })\n )\n }\n\n/**** async totalInvocationsInSpan ****/\n\n async totalInvocationsInSpan (from:number, to:number):Promise {\n expectOrdinal('start time',from)\n expectCardinal ('end time',to)\n\n if (from > to) throwError('invalid time span')\n\n const Granularity = await this.Granularity()\n const roundedFrom = Math.floor(from / Granularity) * Granularity\n\n const QueryResult = await sqlite.execute(`\n SELECT SUM(Invocations) as TotalInvocations\n FROM ${this._Name}_Log\n WHERE Time >= ? AND Time <= ?\n `, [roundedFrom, to])\n\n return QueryResult.rows[0].TotalInvocations || 0\n }\n}\n",["D",1738124674987],{"_103":231,"_156":138,"_153":172,"_95":99,"_163":72,"_161":175,"_100":32,"_155":-5,"_105":232,"_157":158,"_166":-5},"94ded0b4-26d5-11f0-a5b3-569c3dd06744",["D",1738124624397],"versions",[235,237,238,239,240,241],{"_162":210,"_236":212},"previous",{"_162":212,"_236":217},{"_162":217,"_236":222},{"_162":222,"_236":226},{"_162":226,"_236":230},{"_162":230,"_236":-5},"versionNumber","page","hasNext","actionData","errors"]

History for main.tsx