Log inSign up
stevekrouse avatar
Public
Script
Fork
0 Likes
Readme

Poll Twitter & Populate SQlite database

The twitter API (or in this case someone else's wrapper over the twitter API) is finicky, so we just try to get one handle per minute, and shove whatever we get into our database, which could be an error message (this is why handles don't have a unique index).

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
import { lookupTwitterIdFree } from "https://esm.town/v/stevekrouse/lookupTwitterIdFree";
import process from "node:process";
import { turso } from "https://esm.town/v/stevekrouse/turso";
export const populateTwitterDB = async () => {
let client = await turso({
url: process.env.tursoURL,
authToken: process.env.tursoToken,
});
let data = await client.execute(
"select twitter_id from twitter_users where twitter_handle is null limit 1",
);
console.log(data);
let id = data.rows[0].twitter_id;
let handle = await lookupTwitterIdFree(id);
console.log(handle);
return client.execute({
sql:
"update twitter_users set twitter_handle = :handle where twitter_id = :id",
args: { id, handle },
});
};
Val Town is a social website to write and deploy JavaScript.
Build APIs and schedule functions from your browser.
Sign up with GitHub
Comments
Nobody has commented on this val yet: be the first!
October 23, 2023