Skip to content

--since feature can be confused by retweets #39

@simonw

Description

@simonw

If you run twitter-to-sqlite user-timeline ... --since it's supposed to fetch Tweets those specific users tweeted since last time the command was run.

It does this by seeking out the max ID of their previous tweets:

if since and db["tweets"].exists:
try:
since_id = db.conn.execute(
"select max(id) from tweets where user = ?", [profile["id"]]
).fetchall()[0][0]
except IndexError:
pass

BUT... this has a nasty flaw: if another account had retweeted one of their recent tweets the retweeted-tweet will have been loaded into the database - so we may treat that as the most recent since ID and miss a bunch of their tweets!

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't working

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions