Giter VIP home page Giter VIP logo

semiphemeral's People

Stargazers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar

Watchers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar

semiphemeral's Issues

group-DMs seem to be ignored

I have a few group DMs that even "delete_dms" seems to ignore when looking for old DMs to delete. I suspect fixing this means needing to parse some of the other DM data-dump files.

UnboundLocalError

Hi, thank you for your work!

Having decided to try semiphemeral on just the likes for now, I didn't tick the 'Delete old tweets' option in the configuration. This resulted in an internal error that looks like this:

  File "/home/lourkeur/tmp/semiphemeral/semiphemeral/twitter.py", line 115, in fetch
    like_since_id = since_id
UnboundLocalError: local variable 'since_id' referenced before assignment

It seems to me that it's because since_id isn't assigned if the self.common.settings.get('delete_tweets') branch isn't taken. This branch seems to be caused by precisely the fact that I didn't tick the checkbox.

I have a PR with a fix incoming in the next few minutes. #14

Internal Server Error

Receiving this error when attempting to save API keys and a twitter username to configure semiphemeral.

I have attempted completely uninstalling semiphemeral (executables and configuration files) and re-installing, but I continue to receive this error.

500 Internal Server Error

The server encountered an internal error and was unable to complete your request. Either the server is overloaded or there is an error in the application.

Error with deleting retweets

Right now, the app seems to have issue getting rid of six retweets. Five of them show: Sorry, that page does not exist. One show Sorry, you are not authorized to see this status. App does not seem to ignore/delete these from the saved database so the same error is repeated every time the script is run.

Should I delete the tweets.db file and start fresh?

sqlite3.OperationalError: no such column: tweets.user_id

When running app.py fetch I get the following error:

konrad@konrad-pc [semiphemeral (master)]: pipenv run python ./app.py fetch
semiphemeral 0.1
Fetching all tweets, this first run may take a long time
Traceback (most recent call last):
  File "/home/konrad/.local/share/virtualenvs/semiphemeral-iqxB5Xmf/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1244, in _execute_context
    cursor, statement, parameters, context
  File "/home/konrad/.local/share/virtualenvs/semiphemeral-iqxB5Xmf/lib/python3.7/site-packages/sqlalchemy/engine/default.py", line 550, in do_execute
    cursor.execute(statement, parameters)
sqlite3.OperationalError: no such column: tweets.user_id

The above exception was the direct cause of the following exception:

Happens on both pipenv run python ./app.py fetch and semiphemeral fetch

Semiphemeral frontend not working due to jQuery missing

None of the JavaScript features work for me, including the statistics sidebar and any/all tweet interactions. The browser console says:

The script from “http://127.0.0.1:8080/static/js/lib/jquery-3.4.1.min.js” was loaded even though its MIME type (“text/html”) is not a valid JavaScript MIME type.
Loading failed for the <script> with source “http://127.0.0.1:8080/static/js/lib/jquery-3.4.1.min.js”.
ReferenceError: $ is not defined
ReferenceError: $ is not defined

I installed semipheremal via pip (in a virtualenv). Not sure at which point it failed to download the jquery bundle, but it did. Adding it manually works.

unexpected keyword argument 'wait_on_rate_limit_notify'

My system -

 lsb_release -a
No LSB modules are available.
Distributor ID: Ubuntu
Description:    Ubuntu 20.04.3 LTS
Release:        20.04
Codename:       focal

When running -

$ semiphemeral fetch
semiphemeral 0.6
Traceback (most recent call last):
  File "/home/rollingherenow/.local/bin/semiphemeral", line 8, in <module>
    sys.exit(main())
  File "/usr/lib/python3/dist-packages/click/core.py", line 764, in __call__
    return self.main(*args, **kwargs)
  File "/usr/lib/python3/dist-packages/click/core.py", line 717, in main
    rv = self.invoke(ctx)
  File "/usr/lib/python3/dist-packages/click/core.py", line 1137, in invoke
    return _process_result(sub_ctx.command.invoke(sub_ctx))
  File "/usr/lib/python3/dist-packages/click/core.py", line 956, in invoke
    return ctx.invoke(self.callback, **ctx.params)
  File "/usr/lib/python3/dist-packages/click/core.py", line 555, in invoke
    return callback(*args, **kwargs)
  File "/home/rollingherenow/.local/lib/python3.8/site-packages/semiphemeral/__init__.py", line 57, in fetch
    t = Twitter(common)
  File "/home/rollingherenow/.local/lib/python3.8/site-packages/semiphemeral/twitter.py", line 31, in __init__
    self.api = tweepy.API(
TypeError: __init__() got an unexpected keyword argument 'wait_on_rate_limit_notify'

I checked these suggested fixes -

https://stackoverflow.com/questions/37248958/tweepy-wait-on-rate-limit-not-working

https://stackoverflow.com/questions/54846073/unexpected-error-argument-wait-limit-on-a-tweepy-python-script

$ pip show tweepy
Name: tweepy
Version: 4.0.0
Summary: Twitter library for Python
Home-page: https://www.tweepy.org/
Author: Joshua Roesslein
Author-email: [email protected]
License: MIT
Location: /home/[MYUSER]/.local/lib/python3.8/site-packages
Requires: requests-oauthlib, requests
Required-by: semiphemeral

Neither of which seem to be the issue.

Please advise, thank you!

Not deleting all old tweets — and I am not sure why!

I have been using semiphemeral for a while, and while it is amazing at deleting recent old tweets, it seems that all tweets older than 265 days are left untouched. semiphemeral is set to delete tweets after 7 days.

For example: https://twitter.com/neil_neilzone/status/1101005301376057345 (this is the newest of the old, should-be-deleted, tweets).

It's possible that I've been running semiphemeral for about 265 days, and so perhaps this, and older, tweets were missed from the initial deletion run.

Is there any way I can force semiphemeral to delete my legacy tweets? Perhaps a config option I'm missing?

Support deleting old DMs

The bug in tweepy that prevented DM support has been fixed (tweepy/tweepy#1081) and tweepy 3.8.0 has been released, so now there's no excuse to not make semiphemeral automatically delete old DMs too.

Semiphemeral fetch only getting about 3 months of tweets

Hi, I don't know if this is a Twitter limitation or something from tweepy, but running fetch after some time stops at 2019-03-27 for some reason, prints "Calculating which threads should be excluded" and then exits.

Version is 0.3

When Proxy is not defined the default is a "None" string that throws an exception

This prevents semiphemeral from working at all and throws an exception.

To reproduce create a new install and run configure. Fill out the configuration but leave the default value for Proxy. Upon saving an exception will be thrown. Any attempt to run fetch at this point will throw a similar exception.

To fix the issue run configure again but delete the default "None" value for Proxy and save with a blank value.

Fails to pip install from github.

Installing from bleeding-edge fails due to the package being imported in the setup.py

import semiphemeral

Reproduce bug

pip install https://github.com/micahflee/semiphemeral/archive/master.zip
# or
# pip install git+https://github.com/micahflee/semiphemeral@master

Screenshot

image

AttributeError: 'API' object has no attribute 'list_direct_messages'

$ semiphemeral delete
[...]
Fetching direct message metadata for the last 30 days
Traceback (most recent call last):
  File "/usr/bin/semiphemeral", line 11, in <module>
    load_entry_point('semiphemeral==0.6', 'console_scripts', 'semiphemeral')()
  File "/usr/lib/python3/dist-packages/click/core.py", line 764, in __call__
    return self.main(*args, **kwargs)
  File "/usr/lib/python3/dist-packages/click/core.py", line 717, in main
    rv = self.invoke(ctx)
  File "/usr/lib/python3/dist-packages/click/core.py", line 1137, in invoke
    return _process_result(sub_ctx.command.invoke(sub_ctx))
  File "/usr/lib/python3/dist-packages/click/core.py", line 956, in invoke
    return ctx.invoke(self.callback, **ctx.params)
  File "/usr/lib/python3/dist-packages/click/core.py", line 555, in invoke
    return callback(*args, **kwargs)
  File "/usr/lib/python3/dist-packages/semiphemeral/__init__.py", line 70, in delete
    t.delete()
  File "/usr/lib/python3/dist-packages/semiphemeral/twitter.py", line 430, in delete
    for page in tweepy.Cursor(self.api.list_direct_messages).pages():
AttributeError: 'API' object has no attribute 'list_direct_messages'

command not found

After installing the package, and everything went to the right location, I'm getting "semiphemeral: command not found" Is there a solution to this that isn't apparent? Or do I have to add the .local/bin directory to PATH to allow this?

Semiphemeral.com 500 Internal Server Error

Hi there,

I've been experiencing several issues with semiphemeral.com. Currently I cannot add new tweets to the exception list neither delete my account and start over. In both cases, the browser console throws a 500 Internal Server Error.

After confirming the account deletion, I get redirected to semiphemeral.com landing page, the following is logged on the console, and the account is not deleted:

Error fetching user TypeError: NetworkError when attempting to fetch resource. Settings.vue:302:19
XHRPOSThttps://semiphemeral.com/api/settings/delete_account
[HTTP/1.1 500 Internal Server Error 190ms]

If I go to the tweets tab, several messages are logged on the console, including:

Content Security Policy: The page’s settings blocked the loading of a resource at inline (“script-src”). 3 utils.js:35:9

Download the Vue Devtools extension for a better development experience:
https://github.com/vuejs/vue-devtools vue.runtime.esm.js:8418:47

You are running Vue in development mode.
Make sure to turn on production mode when deploying for production.
See more tips at https://vuejs.org/guide/deployment.html vue.runtime.esm.js:8428:45

Error: FeatureSwitchContext was not correctly initialized
    u https://platform.twitter.com/embed/embed.vendors~loaders.video.VideoPlayerDefaultUI.984b17e08ee65ce1addb.js:1
    value https://platform.twitter.com/embed/embed.vendors~loaders.video.VideoPlayerDefaultUI.984b17e08ee65ce1addb.js:1
    n https://platform.twitter.com/embed/embed.vendors~loaders.video.VideoPlayerDefaultUI.984b17e08ee65ce1addb.js:1
    mu https://platform.twitter.com/embed/embed.modules.abd697ba7053cef5bdb1.js:51
    cs https://platform.twitter.com/embed/embed.modules.abd697ba7053cef5bdb1.js:51
    us https://platform.twitter.com/embed/embed.modules.abd697ba7053cef5bdb1.js:51
    Ju https://platform.twitter.com/embed/embed.modules.abd697ba7053cef5bdb1.js:51
    Gi https://platform.twitter.com/embed/embed.modules.abd697ba7053cef5bdb1.js:51
    unstable_runWithPriority https://platform.twitter.com/embed/embed.modules.abd697ba7053cef5bdb1.js:59
    Hi https://platform.twitter.com/embed/embed.modules.abd697ba7053cef5bdb1.js:51
    Gi https://platform.twitter.com/embed/embed.modules.abd697ba7053cef5bdb1.js:51
    F https://platform.twitter.com/embed/embed.modules.abd697ba7053cef5bdb1.js:59
    onmessage https://platform.twitter.com/embed/embed.modules.abd697ba7053cef5bdb1.js:59
    EventHandlerNonNull* https://platform.twitter.com/embed/embed.modules.abd697ba7053cef5bdb1.js:59
    s https://platform.twitter.com/embed/embed.runtime.ebbf169906077e22e5f1.js:1
    <anonymous> https://platform.twitter.com/embed/embed.modules.abd697ba7053cef5bdb1.js:51
    s https://platform.twitter.com/embed/embed.runtime.ebbf169906077e22e5f1.js:1
    <anonymous> https://platform.twitter.com/embed/embed.modules.abd697ba7053cef5bdb1.js:51
    s https://platform.twitter.com/embed/embed.runtime.ebbf169906077e22e5f1.js:1
    <anonymous> https://platform.twitter.com/embed/embed.modules.abd697ba7053cef5bdb1.js:10
    s https://platform.twitter.com/embed/embed.runtime.ebbf169906077e22e5f1.js:1
    99 https://platform.twitter.com/embed/embed.Tweet.efb4bb7234b7cc7ce8c1.js:1
    s https://platform.twitter.com/embed/embed.runtime.ebbf169906077e22e5f1.js:1
    266 https://platform.twitter.com/embed/embed.Tweet.efb4bb7234b7cc7ce8c1.js:1
    s https://platform.twitter.com/embed/embed.runtime.ebbf169906077e22e5f1.js:1
    d https://platform.twitter.com/embed/embed.runtime.ebbf169906077e22e5f1.js:1
    n https://platform.twitter.com/embed/embed.runtime.ebbf169906077e22e5f1.js:1
    <anonymous> https://platform.twitter.com/embed/embed.Tweet.efb4bb7234b7cc7ce8c1.js:1
 undefined embed.modules.abd697ba7053cef5bdb1.js:10:59403

At least two other Error: FeatureSwitchContext was not correctly initialized also appear with the same URL for the first three lines (u, value, n).

Finally, if I click on any checkbox to add a tweet to the exclusion list, the following is logged to the console and I find the checkbox is unchecked after reloading the page:

XHRPOSThttps://semiphemeral.com/api/tweets
[HTTP/1.1 500 Internal Server Error 152ms]

The only settings that are currently being saved in my account upon change are those for defining the conditions for tweets, retweets, and likes deletion. This has been going on like this since around the first week of February. I hope those console logs are helpful to sort this out.

Thank you in advance.

Twitter Sign-In functionality on a self-hosted instance

I noticed that the only way to use a self-hosted instance of Semiphemeral is to have a developer account associated with the Twitter account that you want to delete information from.

In my case, however, my developer account application got rejected and currently there's no way to appeal the decision. Which means that if you get rejected once, you're left with no developer access forever, unless you create a new account.

It would be nice for the self-hosted version to have a possibility to sign in with a Twitter account that isn't associated with the API tokens, just like on https://semiphemeral.com/

Tweets don't show up in the UI

I have a grid of downloaded tweets and checkboxes, but not the tweet content itself. Is this supposed to look like this? I can't tell what I'm deleting or excluding:

Screenshot_2019-07-01 Semiphemeral Tweets

I'm on MacOSX. I've tried this in numerous browsers (Firefox, Chrome, Safari), all do the same thing. I've tried turning off tracker/cookie blocking in case that was doing it, no luck. I tried incognito mode, no luck. I can see in the console that there's a log of a JS object, if I drill in, I can see the tweet text. But why won't it display in the UI?

Semiphemeral can't resume after it has reached the rate limit

When running semiphemeral fetch, after it has reached the rate limit, it will pause. But after the pause, my tool can't resume and I get the error below.
Can anyone help me to troubleshoot this?
I'm running Windows 10 Home 64-bit, Python 3.6.4

Rate limit reached. Sleeping for: 867
Traceback (most recent call last):
  File "c:\program files\python36\lib\site-packages\urllib3\connectionpool.py", line 603, in urlopen
    chunked=chunked)
  File "c:\program files\python36\lib\site-packages\urllib3\connectionpool.py", line 387, in _make_request
    six.raise_from(e, None)
  File "<string>", line 2, in raise_from
  File "c:\program files\python36\lib\site-packages\urllib3\connectionpool.py", line 383, in _make_request
    httplib_response = conn.getresponse()
  File "c:\program files\python36\lib\http\client.py", line 1331, in getresponse
    response.begin()
  File "c:\program files\python36\lib\http\client.py", line 297, in begin
    version, status, reason = self._read_status()
  File "c:\program files\python36\lib\http\client.py", line 258, in _read_status
    line = str(self.fp.readline(_MAXLINE + 1), "iso-8859-1")
  File "c:\program files\python36\lib\socket.py", line 586, in readinto
    return self._sock.recv_into(b)
  File "c:\program files\python36\lib\ssl.py", line 1009, in recv_into
    return self.read(nbytes, buffer)
  File "c:\program files\python36\lib\ssl.py", line 871, in read
    return self._sslobj.read(len, buffer)
  File "c:\program files\python36\lib\ssl.py", line 631, in read
    v = self._sslobj.read(len, buffer)
ConnectionResetError: [WinError 10054] An existing connection was forcibly closed by the remote host

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "c:\program files\python36\lib\site-packages\requests\adapters.py", line 449, in send
    timeout=timeout
  File "c:\program files\python36\lib\site-packages\urllib3\connectionpool.py", line 641, in urlopen
    _stacktrace=sys.exc_info()[2])
  File "c:\program files\python36\lib\site-packages\urllib3\util\retry.py", line 368, in increment
    raise six.reraise(type(error), error, _stacktrace)
  File "c:\program files\python36\lib\site-packages\urllib3\packages\six.py", line 685, in reraise
    raise value.with_traceback(tb)
  File "c:\program files\python36\lib\site-packages\urllib3\connectionpool.py", line 603, in urlopen
    chunked=chunked)
  File "c:\program files\python36\lib\site-packages\urllib3\connectionpool.py", line 387, in _make_request
    six.raise_from(e, None)
  File "<string>", line 2, in raise_from
  File "c:\program files\python36\lib\site-packages\urllib3\connectionpool.py", line 383, in _make_request
    httplib_response = conn.getresponse()
  File "c:\program files\python36\lib\http\client.py", line 1331, in getresponse
    response.begin()
  File "c:\program files\python36\lib\http\client.py", line 297, in begin
    version, status, reason = self._read_status()
  File "c:\program files\python36\lib\http\client.py", line 258, in _read_status
    line = str(self.fp.readline(_MAXLINE + 1), "iso-8859-1")
  File "c:\program files\python36\lib\socket.py", line 586, in readinto
    return self._sock.recv_into(b)
  File "c:\program files\python36\lib\ssl.py", line 1009, in recv_into
    return self.read(nbytes, buffer)
  File "c:\program files\python36\lib\ssl.py", line 871, in read
    return self._sslobj.read(len, buffer)
  File "c:\program files\python36\lib\ssl.py", line 631, in read
    v = self._sslobj.read(len, buffer)
urllib3.exceptions.ProtocolError: ('Connection aborted.', ConnectionResetError(10054, 'An existing connection was forcibly closed by the remote host', None, 10054, None))

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "c:\program files\python36\lib\site-packages\tweepy\binder.py", line 190, in execute
    proxies=self.api.proxy)
  File "c:\program files\python36\lib\site-packages\requests\sessions.py", line 533, in request
    resp = self.send(prep, **send_kwargs)
  File "c:\program files\python36\lib\site-packages\requests\sessions.py", line 646, in send
    r = adapter.send(request, **kwargs)
  File "c:\program files\python36\lib\site-packages\requests\adapters.py", line 498, in send
    raise ConnectionError(err, request=request)
requests.exceptions.ConnectionError: ('Connection aborted.', ConnectionResetError(10054, 'An existing connection was forcibly closed by the remote host', None, 10054, None))

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "c:\program files\python36\lib\runpy.py", line 193, in _run_module_as_main
    "__main__", mod_spec)
  File "c:\program files\python36\lib\runpy.py", line 85, in _run_code
    exec(code, run_globals)
  File "C:\Program Files\Python36\Scripts\semiphemeral.exe\__main__.py", line 9, in <module>
  File "c:\program files\python36\lib\site-packages\click\core.py", line 764, in __call__
    return self.main(*args, **kwargs)
  File "c:\program files\python36\lib\site-packages\click\core.py", line 717, in main
    rv = self.invoke(ctx)
  File "c:\program files\python36\lib\site-packages\click\core.py", line 1137, in invoke
    return _process_result(sub_ctx.command.invoke(sub_ctx))
  File "c:\program files\python36\lib\site-packages\click\core.py", line 956, in invoke
    return ctx.invoke(self.callback, **ctx.params)
  File "c:\program files\python36\lib\site-packages\click\core.py", line 555, in invoke
    return callback(*args, **kwargs)
  File "c:\program files\python36\lib\site-packages\semiphemeral\__init__.py", line 52, in fetch
    t.fetch()
  File "c:\program files\python36\lib\site-packages\semiphemeral\twitter.py", line 131, in fetch
    since_id=like_since_id
  File "c:\program files\python36\lib\site-packages\tweepy\cursor.py", line 49, in __next__
    return self.next()
  File "c:\program files\python36\lib\site-packages\tweepy\cursor.py", line 108, in next
    data = self.method(max_id=self.max_id, parser=RawParser(), *self.args, **self.kargs)
  File "c:\program files\python36\lib\site-packages\tweepy\binder.py", line 250, in _call
    return method.execute()
  File "c:\program files\python36\lib\site-packages\tweepy\binder.py", line 192, in execute
    six.reraise(TweepError, TweepError('Failed to send request: %s' % e), sys.exc_info()[2])
  File "C:\Users\****\AppData\Roaming\Python\Python36\site-packages\six.py", line 692, in reraise
    raise value.with_traceback(tb)
  File "c:\program files\python36\lib\site-packages\tweepy\binder.py", line 190, in execute
    proxies=self.api.proxy)
  File "c:\program files\python36\lib\site-packages\requests\sessions.py", line 533, in request
    resp = self.send(prep, **send_kwargs)
  File "c:\program files\python36\lib\site-packages\requests\sessions.py", line 646, in send
    r = adapter.send(request, **kwargs)
  File "c:\program files\python36\lib\site-packages\requests\adapters.py", line 498, in send
    raise ConnectionError(err, request=request)
tweepy.error.TweepError: Failed to send request: ('Connection aborted.', ConnectionResetError(10054, 'An existing connection was forcibly closed by the remote host', None, 10054, None))

Only Retrieving New Tweets

When I first ran the fetch command, it went out and downloaded my tweets until it ran into the rate limit, after which it paused. Watching the datetimes, tweets clear back to 2007 were being referenced (I had 31.4k when attempting to run it).

However, the localhost browser interface says I only have 1,754 tweets and 1,280 retweets.

When I ran the delete, it appeared to only delete ~ 210 that were older than my criteria (older than a year, x number of my likes, etc) but everything listed was from the first part of 2018, and nothing older.

I thought, with those 210 cleared, maybe I needed to re-run fetch as I maybe had some 'headroom' in my rate limit. However, fetch is now only retrieving "most recent" tweets.

Why are the ancient (and, arguably, the most problematic) tweets not appearing? And how do I get fetch to pull them in so that I can subsequently delete them?

Several errors after i run semiphemeral unlike --filename ~/twitter/like.js

I installed semiphemeral onto a ubuntu 18.04 virtualbox vm.
then
semiphemeral configure
semiphemeral fresh
semiphemeral delete

It did unliked 1661 from the 21.000

It did not find any tweets but i deleted already 12000 of the 13000 tweets with a other python script few days ago that might have something to do with it.

since i want to try to remove all my tweet and unlike all tweets i ever liked i downloaded my data and run:

root@Ubuntu-VirtualBox:~# semiphemeral unlike --filename ~/twitter/like.js
semiphemeral 0.4
WARNING: One does not simply unlike old tweets. According to the Twitter API, you didn't like these old tweets, so you can't unlike them -- even though they're listed in your like history. The only way to remove them from your like history is to LIKE THEM AGAIN, and then you can unlike them. This is very noisy. Every time you re-like a tweet, the user will get a notification.
Do you want to continue? [y/N]: y
Making a list of liked tweet status_ids
Like history has 21012 tweets
Loading tweets from database
Loaded 1662 tweets from database
Calculating tweets to fetch from the API
Fetching remaining 17902 tweets from API
Traceback (most recent call last):
  File "/usr/local/bin/semiphemeral", line 11, in <module>
    sys.exit(main())
  File "/usr/local/lib/python3.6/dist-packages/click/core.py", line 764, in __call__
    return self.main(*args, **kwargs)
  File "/usr/local/lib/python3.6/dist-packages/click/core.py", line 717, in main
    rv = self.invoke(ctx)
  File "/usr/local/lib/python3.6/dist-packages/click/core.py", line 1137, in invoke
    return _process_result(sub_ctx.command.invoke(sub_ctx))
  File "/usr/local/lib/python3.6/dist-packages/click/core.py", line 956, in invoke
    return ctx.invoke(self.callback, **ctx.params)
  File "/usr/local/lib/python3.6/dist-packages/click/core.py", line 555, in invoke
    return callback(*args, **kwargs)
  File "/usr/local/lib/python3.6/dist-packages/semiphemeral/__init__.py", line 75, in unlike
    t.unlike(filename)
  File "/usr/local/lib/python3.6/dist-packages/semiphemeral/twitter.py", line 404, in unlike
    tweet = Tweet(status)
  File "<string>", line 4, in __init__
  File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/orm/state.py", line 441, in _initialize_instance
    manager.dispatch.init_failure(self, args, kwargs)
  File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/util/langhelpers.py", line 68, in __exit__
    compat.reraise(exc_type, exc_value, exc_tb)
  File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/util/compat.py", line 153, in reraise
    raise value
  File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/orm/state.py", line 438, in _initialize_instance
    return manager.original_init(*mixed[1:], **kwargs)
  File "/usr/local/lib/python3.6/dist-packages/semiphemeral/db.py", line 59, in __init__
    self.text = status.full_text
AttributeError: 'Status' object has no attribute 'full_text'
root@Ubuntu-VirtualBox:~#

By googling i found somebody who solved a similar error by installing
pip install SQLAlchemy==1.2.5 SQLAlchemy-Utils==0.33.1

After that still the same errors.
What is going wrong?

Feature Request: Filter before fetching

Hello, thanks for making this!

Is it possible to filter words, users, hashtags, list, or blocked accounts in the configuration window before semiphemeral fetch?

An exception to handle

Upon submitting settings.

raise TweepError(error_msg, resp, api_code=api_error_code)
tweepy.error.TweepError: [{'code': 89, 'message': 'Invalid or expired token.'}]

Templates aren't included in pip package

Oops. From a comment on my blog post:

When running "semiphemeral configure", I get the following error: >jinja2.exceptions.TemplateNotFound: settings.html

I installed it with "pip3 semiphemeral", and for some reason, the template files are not included in the directory .local/lib/python3.5/site-packages/semiphemeral/.

I'm using Debian 9.

RecursionError: maximum recursion depth exceeded while getting the str of an object

Traceback (most recent call last): File "c:\program files (x86)\python37-32\lib\runpy.py", line 193, in _run_module_as_main "__main__", mod_spec) File "c:\program files (x86)\python37-32\lib\runpy.py", line 85, in _run_code exec(code, run_globals) File "C:\Program Files (x86)\Python37-32\Scripts\semiphemeral.exe\__main__.py", line 9, in <module> File "c:\program files (x86)\python37-32\lib\site-packages\click\core.py", line 764, in __call__ return self.main(*args, **kwargs) File "c:\program files (x86)\python37-32\lib\site-packages\click\core.py", line 717, in main rv = self.invoke(ctx) File "c:\program files (x86)\python37-32\lib\site-packages\click\core.py", line 1137, in invoke return _process_result(sub_ctx.command.invoke(sub_ctx)) File "c:\program files (x86)\python37-32\lib\site-packages\click\core.py", line 956, in invoke return ctx.invoke(self.callback, **ctx.params) File "c:\program files (x86)\python37-32\lib\site-packages\click\core.py", line 555, in invoke return callback(*args, **kwargs) File "c:\program files (x86)\python37-32\lib\site-packages\semiphemeral\__init__.py", line 53, in fetch t.fetch() File "c:\program files (x86)\python37-32\lib\site-packages\semiphemeral\twitter.py", line 64, in fetch fetched_count += self.import_tweet(Tweet(status)) File "c:\program files (x86)\python37-32\lib\site-packages\semiphemeral\twitter.py", line 184, in import_tweet fetched_count += self.import_tweet(Tweet(status)) File "c:\program files (x86)\python37-32\lib\site-packages\semiphemeral\twitter.py", line 184, in import_tweet fetched_count += self.import_tweet(Tweet(status)) File "c:\program files (x86)\python37-32\lib\site-packages\semiphemeral\twitter.py", line 184, in import_tweet fetched_count += self.import_tweet(Tweet(status)) [Previous line repeated 941 more times] File "c:\program files (x86)\python37-32\lib\site-packages\semiphemeral\twitter.py", line 171, in import_tweet if not tweet.already_saved(self.common.session): File "c:\program files (x86)\python37-32\lib\site-packages\semiphemeral\db.py", line 76, in already_saved tweet = session.query(Tweet).filter_by(status_id=self.status_id).first() File "c:\program files (x86)\python37-32\lib\site-packages\sqlalchemy\orm\query.py", line 3221, in first ret = list(self[0:1]) File "c:\program files (x86)\python37-32\lib\site-packages\sqlalchemy\orm\query.py", line 3011, in __getitem__ return list(res) File "c:\program files (x86)\python37-32\lib\site-packages\sqlalchemy\orm\query.py", line 3323, in __iter__ return self._execute_and_instances(context) File "c:\program files (x86)\python37-32\lib\site-packages\sqlalchemy\orm\query.py", line 3348, in _execute_and_instances result = conn.execute(querycontext.statement, self._params) File "c:\program files (x86)\python37-32\lib\site-packages\sqlalchemy\engine\base.py", line 988, in execute return meth(self, multiparams, params) File "c:\program files (x86)\python37-32\lib\site-packages\sqlalchemy\sql\elements.py", line 287, in _execute_on_connection return connection._execute_clauseelement(self, multiparams, params) File "c:\program files (x86)\python37-32\lib\site-packages\sqlalchemy\engine\base.py", line 1098, in _execute_clauseelement else None, File "<string>", line 1, in <lambda> File "c:\program files (x86)\python37-32\lib\site-packages\sqlalchemy\sql\elements.py", line 462, in compile return self._compiler(dialect, bind=bind, **kw) File "c:\program files (x86)\python37-32\lib\site-packages\sqlalchemy\sql\elements.py", line 468, in _compiler return dialect.statement_compiler(dialect, self, **kw) File "c:\program files (x86)\python37-32\lib\site-packages\sqlalchemy\sql\compiler.py", line 562, in __init__ Compiled.__init__(self, dialect, statement, **kwargs) File "c:\program files (x86)\python37-32\lib\site-packages\sqlalchemy\sql\compiler.py", line 319, in __init__ self.string = self.process(self.statement, **compile_kwargs) File "c:\program files (x86)\python37-32\lib\site-packages\sqlalchemy\sql\compiler.py", line 350, in process return obj._compiler_dispatch(self, **kwargs) File "c:\program files (x86)\python37-32\lib\site-packages\sqlalchemy\sql\visitors.py", line 91, in _compiler_dispatch return meth(self, **kw) File "c:\program files (x86)\python37-32\lib\site-packages\sqlalchemy\sql\compiler.py", line 2115, in visit_select text, select, inner_columns, froms, byfrom, kwargs File "c:\program files (x86)\python37-32\lib\site-packages\sqlalchemy\sql\compiler.py", line 2214, in _compose_select_body t = select._whereclause._compiler_dispatch(self, **kwargs) File "c:\program files (x86)\python37-32\lib\site-packages\sqlalchemy\sql\visitors.py", line 91, in _compiler_dispatch return meth(self, **kw) File "c:\program files (x86)\python37-32\lib\site-packages\sqlalchemy\sql\compiler.py", line 1283, in visit_binary return self._generate_generic_binary(binary, opstring, **kw) File "c:\program files (x86)\python37-32\lib\site-packages\sqlalchemy\sql\compiler.py", line 1331, in _generate_generic_binary self, eager_grouping=eager_grouping, **kw File "c:\program files (x86)\python37-32\lib\site-packages\sqlalchemy\sql\visitors.py", line 91, in _compiler_dispatch return meth(self, **kw) File "c:\program files (x86)\python37-32\lib\site-packages\sqlalchemy\sql\compiler.py", line 1476, in visit_bindparam name = self._truncate_bindparam(bindparam) File "c:\program files (x86)\python37-32\lib\site-packages\sqlalchemy\sql\compiler.py", line 1535, in _truncate_bindparam bind_name = self._truncated_identifier("bindparam", bind_name) File "c:\program files (x86)\python37-32\lib\site-packages\sqlalchemy\sql\compiler.py", line 1546, in _truncated_identifier anonname = name.apply_map(self.anon_map) File "c:\program files (x86)\python37-32\lib\site-packages\sqlalchemy\sql\elements.py", line 4302, in apply_map return self % map_ File "c:\program files (x86)\python37-32\lib\site-packages\sqlalchemy\util\_collections.py", line 734, in __missing__ self[key] = val = self.creator(key) File "c:\program files (x86)\python37-32\lib\site-packages\sqlalchemy\sql\compiler.py", line 1568, in _process_anon return derived + "_" + str(anonymous_counter) RecursionError: maximum recursion depth exceeded while getting the str of an object

fetch operation failed in process due to a RecursionLimit

semiphemeral on Linux terminal error

After running pip3 install semiphemeral, I try to run it but get the following error. Not sure what is going on. Tweepy is already installed also for if that was going to be a question.
Running on manjaro.

[thejoker@gibson ~]$ semiphemeral configure
Traceback (most recent call last):
File "/home/thejoker/.local/bin/semiphemeral", line 5, in
from semiphemeral import main
File "/home/thejoker/.local/lib/python3.8/site-packages/semiphemeral/init.py", line 8, in
from .web import create_app
File "/home/thejoker/.local/lib/python3.8/site-packages/semiphemeral/web.py", line 6, in
from .twitter import Twitter
File "/home/thejoker/.local/lib/python3.8/site-packages/semiphemeral/twitter.py", line 1, in
import tweepy
File "/home/thejoker/.local/lib/python3.8/site-packages/tweepy/init.py", line 17, in
from tweepy.streaming import Stream, StreamListener
File "/home/thejoker/.local/lib/python3.8/site-packages/tweepy/streaming.py", line 358
def _start(self, async):
^
SyntaxError: invalid syntax
[thejoker@gibson ~]$

Unable to get 'unlike' function working

Been having some trouble running Semiphemeral to remove old likes, when running as per instructions here I just get 'invalid file' even though the instructions are followed to the letter, and the data was pulled from today.

Unsure if this is related, but when following [these steps] (#31 (comment)) I get an error:

File "C:\Users\Caro.virtualenvs\semiphemeral-0gm4sUC6\lib\site-packages\sqlalchemy\util\compat.py", line 331, in
time_func = time.clock
AttributeError: module 'time' has no attribute 'clock'

Server gets exception ERROR in app: Exception on /settings

I checked and double-checked my API settings. I don't know if this is the normal message if it can't authenticate, or if there's supposed to be something else happening.

Traceback (most recent call last):
  File "c:\users\rober\appdata\local\programs\python\python37\lib\site-packages\flask\app.py", line 2446, in wsgi_app
    response = self.full_dispatch_request()
  File "c:\users\rober\appdata\local\programs\python\python37\lib\site-packages\flask\app.py", line 1951, in full_dispatch_request

    rv = self.handle_user_exception(e)
  File "c:\users\rober\appdata\local\programs\python\python37\lib\site-packages\flask\app.py", line 1820, in handle_user_exception

    reraise(exc_type, exc_value, tb)
  File "c:\users\rober\appdata\local\programs\python\python37\lib\site-packages\flask\_compat.py", line 39, in reraise
    raise value
  File "c:\users\rober\appdata\local\programs\python\python37\lib\site-packages\flask\app.py", line 1949, in full_dispatch_request

    rv = self.dispatch_request()
  File "c:\users\rober\appdata\local\programs\python\python37\lib\site-packages\flask\app.py", line 1935, in dispatch_request
    return self.view_functions[rule.endpoint](**req.view_args)
  File "c:\users\rober\appdata\local\programs\python\python37\lib\site-packages\semiphemeral\web.py", line 65, in edit_settings
    twitter = Twitter(common)
  File "c:\users\rober\appdata\local\programs\python\python37\lib\site-packages\semiphemeral\twitter.py", line 32, in __init__
    user = self.api.get_user(self.common.settings.get('username'))
  File "c:\users\rober\appdata\local\programs\python\python37\lib\site-packages\tweepy\binder.py", line 250, in _call
    return method.execute()
  File "c:\users\rober\appdata\local\programs\python\python37\lib\site-packages\tweepy\binder.py", line 233, in execute
    raise TweepError(error_msg, resp, api_code=api_error_code)
tweepy.error.TweepError: [{'code': 32, 'message': 'Could not authenticate you.'}]

I selected unlike old tweets but I still have 47k likes

I've been running semiphemeral for a long while now. I like it. Thank you.

I'm just curious about how I still have 47k likes. In fact, I can scroll through all my old likes from today until the beginning of time. It's not unliking them even though I have deleted old tweets and unlike tweets selected in the configuration panel.

Screenshot from 2020-02-04 12-05-50

Screenshot from 2020-02-04 12-03-45

"too many SQL variables" error when using the unlike function

$ semiphemeral unlike --filename Downloads/twitter-2019-09-20-08cb1307005a3fd61fb9ab1adac8e97683b9ef55fff52f85a7f2913c71a9f56d/like.js
semiphemeral 0.5
WARNING: One does not simply unlike old tweets. According to the Twitter API, you didn't like these old tweets, so you can't unlike them -- even though they're listed in your like history. The only way to remove them from your like history is to LIKE THEM AGAIN, and then you can unlike them. This is very noisy. Every time you re-like a tweet, the user will get a notification.
Do you want to continue? [y/N]: Y
Making a list of liked tweet status_ids
Like history has 2032 tweets
Loading tweets from database
Traceback (most recent call last):
  File "/Users/jleroy/.pyvenv/Semiphemeral/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1249, in _execute_context
    cursor, statement, parameters, context
  File "/Users/jleroy/.pyvenv/Semiphemeral/lib/python3.7/site-packages/sqlalchemy/engine/default.py", line 552, in do_execute
    cursor.execute(statement, parameters)
sqlite3.OperationalError: too many SQL variables

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
  File "/Users/jleroy/.pyvenv/Semiphemeral/bin/semiphemeral", line 10, in <module>
    sys.exit(main())
  File "/Users/jleroy/.pyvenv/Semiphemeral/lib/python3.7/site-packages/click/core.py", line 764, in __call__
    return self.main(*args, **kwargs)
  File "/Users/jleroy/.pyvenv/Semiphemeral/lib/python3.7/site-packages/click/core.py", line 717, in main
    rv = self.invoke(ctx)
  File "/Users/jleroy/.pyvenv/Semiphemeral/lib/python3.7/site-packages/click/core.py", line 1137, in invoke
    return _process_result(sub_ctx.command.invoke(sub_ctx))
  File "/Users/jleroy/.pyvenv/Semiphemeral/lib/python3.7/site-packages/click/core.py", line 956, in invoke
    return ctx.invoke(self.callback, **ctx.params)
  File "/Users/jleroy/.pyvenv/Semiphemeral/lib/python3.7/site-packages/click/core.py", line 555, in invoke
    return callback(*args, **kwargs)
  File "/Users/jleroy/.pyvenv/Semiphemeral/lib/python3.7/site-packages/semiphemeral/__init__.py", line 75, in unlike
    t.unlike(filename)
  File "/Users/jleroy/.pyvenv/Semiphemeral/lib/python3.7/site-packages/semiphemeral/twitter.py", line 385, in unlike
    for tweet in self.common.session.query(Tweet).filter(Tweet.status_id.in_(like_status_ids)).order_by(Tweet.created_at.desc()).all():
  File "/Users/jleroy/.pyvenv/Semiphemeral/lib/python3.7/site-packages/sqlalchemy/orm/query.py", line 3178, in all
    return list(self)
  File "/Users/jleroy/.pyvenv/Semiphemeral/lib/python3.7/site-packages/sqlalchemy/orm/query.py", line 3334, in __iter__
    return self._execute_and_instances(context)
  File "/Users/jleroy/.pyvenv/Semiphemeral/lib/python3.7/site-packages/sqlalchemy/orm/query.py", line 3359, in _execute_and_instances
    result = conn.execute(querycontext.statement, self._params)
  File "/Users/jleroy/.pyvenv/Semiphemeral/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 988, in execute
    return meth(self, multiparams, params)
  File "/Users/jleroy/.pyvenv/Semiphemeral/lib/python3.7/site-packages/sqlalchemy/sql/elements.py", line 287, in _execute_on_connection
    return connection._execute_clauseelement(self, multiparams, params)
  File "/Users/jleroy/.pyvenv/Semiphemeral/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1107, in _execute_clauseelement
    distilled_params,
  File "/Users/jleroy/.pyvenv/Semiphemeral/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1253, in _execute_context
    e, statement, parameters, cursor, context
  File "/Users/jleroy/.pyvenv/Semiphemeral/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1473, in _handle_dbapi_exception
    util.raise_from_cause(sqlalchemy_exception, exc_info)
  File "/Users/jleroy/.pyvenv/Semiphemeral/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 398, in raise_from_cause
    reraise(type(exception), exception, tb=exc_tb, cause=cause)
  File "/Users/jleroy/.pyvenv/Semiphemeral/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 152, in reraise
    raise value.with_traceback(tb)
  File "/Users/jleroy/.pyvenv/Semiphemeral/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1249, in _execute_context
    cursor, statement, parameters, context
  File "/Users/jleroy/.pyvenv/Semiphemeral/lib/python3.7/site-packages/sqlalchemy/engine/default.py", line 552, in do_execute
    cursor.execute(statement, parameters)
sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) too many SQL variables
[SQL: SELECT tweets.id AS tweets_id, tweets.created_at AS tweets_created_at, tweets.user_id AS tweets_user_id, tweets.user_screen_name AS tweets_user_screen_name, tweets.status_id AS tweets_status_id, tweets.lang AS tweets_lang, tweets.source AS tweets_source, tweets.source_url AS tweets_source_url, tweets.text AS tweets_text, tweets.in_reply_to_screen_name AS tweets_in_reply_to_screen_name, tweets.in_reply_to_status_id AS tweets_in_reply_to_status_id, tweets.in_reply_to_user_id AS tweets_in_reply_to_user_id, tweets.retweet_count AS tweets_retweet_count, tweets.favorite_count AS tweets_favorite_count, tweets.retweeted AS tweets_retweeted, tweets.favorited AS tweets_favorited, tweets.is_retweet AS tweets_is_retweet, tweets.is_deleted AS tweets_is_deleted, tweets.is_unliked AS tweets_is_unliked, tweets.exclude_from_delete AS tweets_exclude_from_delete, tweets.thread_id AS tweets_thread_id
FROM tweets
WHERE tweets.status_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY tweets.created_at DESC]
[parameters: (1166414617695928327, 1167447392557457408, 1166385155763789830, 1166151432543903744, 1166033612489314306, 1167405867668574208, 1166254016940138502, 1114253313971589120, 1114209903256715265, 1165760903809130496, 1166707917833363457, 1167087999630434304, 1165924317789642752, 1114238897020710919, 1165707463703826434, 1166408347345666053, 1114212454710611973, 1167589076653887489, 1167482836150050818, 1167533965152010242, 1167356783251349504, 1166103060881518597, 1166998802957516802, 1165990406737338369, 1167436971255500800, 1165023198855016448, 1164552820957294592, 1163559319087923200, 1163712413621002240, 1079359711227580416, 1163036559974817793, 1162388603969912832, 1164494500506591232, 1165081616030388225, 1164254189062483968, 1164785161990356993, 1164131613917138945, 1161872352499699712, 1162749536374263809, 1165390810298421248, 1162453096733257728, 1164952138545602560, 1162339695277346817, 1162558721219801088, 1165466169962311680, 1164756054887919616, 1163535602798776321, 1162345542615257088, 1162650153309765632, 1165308685775556613, 882703250184699909, 893928448330260480, 893520075436818432, 893572338641494016, 891005534375161856, 894177481883889664, 893409829859065856, 883732967071391744, 892344196203524096, 893800217383927809, 893913643682643968, 893419397494255616, 893449454430429184, 887120066021425152, 888079972916539392, 888728181515190273, 882699557234200576, 884476143491067906, 884416390870048768, 882831404962369536, 884421467227795458, 893351960455270400, 880487235866554368, 893779426953093120, 880484729799274496, 875614000364404737, 876070030127099904, 875862924253814784, 876152097724669953, 876663201118793729, 875807430168522754, 875796998955438080, 875155083377430528, 876157601377136641, 876480828414603266, 875456385231794177, 878168045683912704, 875641422237491203, 876103078566649856, 875859569389559810, 818478622520569857, 875747154521882624, 876516303300853763, 875775592146366466, 875749479374344193, 876407887115018240, 876682431750967297, 875615345091911681, 707539744918478848, 875567305320579072, 874257235031068672, 875131702619889669, 874292128851136518, 874987926685458434, 875284847824183296, 874381160683589632, 874454133700427777, 874367835484688386, 874984545698947072, 874733630739726336, 875074679198949376, 874945557999104000, 874308043189633024, 874952252661911552, 874024634114551809, 874677837910900743, 768349823753945088, 874628643330416640, 875381006722793472, 874600249972666368, 875326581698428932, 874562585269612544, 875021787792371712, 875056319618834437, 873997816166854656, 872626786827472896, 872340169596207104, 862269379995742214, 873183132085870593, 874023636243492865, 873186390539988993, 872523643783401473, 872387506821632001, 872512184663670785, 872669561623003136, 872511778415976448, 873694856614481920, 872881177023139842, 873288845890117632, 873190123487113216, 873103359124750337, 872718082434838528, 872467686357434369, 872135361220235268, 873319228199358466, 872486366013161472, 872908306200895488, 873981124011229184, 873922558487392256, 871987839168372736, 870695804201074690, 871262943350050816, 870670258796863490, 869931563995287552, 871473619578310657, 871772970242502656, 870961780104810496, 871186317542957056, 871973451510296576, 870912082191011842, 870322157888450560, 872038328534577152, 871769768063377408, 871455204096528384, 872044045056569344, 870400062240772096, 871043195039252484, 871399961866510336, 785875998516531200, 869901583089381377, 870678163281518592, 871020090837356544, 870208857431298049, 871098149804310528, 871382012371902464, 868867963633401856, 868533517336141824, 869288698067791878, 870027424645435392, 869286517012926464, 869971562551750660, 869471671362760704, 869157987373461504, 870207640781115392, 868514457336651778, 869180223077658624, 869548532847583232, 869175384817926144, 868406625928916992, 869128970326986752, 869284271114113024, 869644985020403713, 869438021900390401, 868852046853754880, 869084783401414656, 869267006914211842, 868836331400691712, 869532150760165377, 868559834320392195, 869299116509196288, 867673990009151488, 867697393806049282, 866943715037900800, 865680141229412352, 866525701909790720, 866784956110041088, 867021695625961473, 866530361324429312, 866529502662463488, 866668725243568129, 866578331029909504, 866726219416580096, 845807163113193472, 866226163924049920, 866746952263905281, 867410700863516674, 867483745108021248, 867821084279787525, 867361019764637696, 868424781091287040, 868441061890371584, 866721206673694720, 866529765246816256, 866963675877449729, 867054842832986112, 865172848507269120, 864427589691211776, 865688636196519938, 864426249103572992, 864403712692899841, 864397221755838464, 864788048638357504, 865493803897044992, 864459557166338048, 865347608017022976, 865727889681113089, 864720773092524032, 864665943129108481, 864926538478780416, 865672177055674368, 864753169649336322, 864426740428533761, 866141198737707009, 865200060354527233, 866233021057445890, 865176766268264448, 865353232222109696, 864516142366429184, 865113337461342208, 864401939651547136, 863728652772573188, 864064438047047680, 863624965781938176, 864076101236248576, 863629191627112448, 864024839761178624, 863424363810271233, 863743850757619713, 864038621078323200, 863754226413031424, 864378506012241920, 863432100342583297, 858431434683535360, 863415877831729152, 864378217066627072, 864128583924686848, 862786851072909312, 863692891738169345, 863406474881622016, 863797957732298756, 863727299635679232, 863627350055030784, 864166521580421125, 859891943349800965, 863524074496065537, 863148401529114624, 862379216930652160, 862923752174235648, 862918309121056768, 862661011882561537, 863068766816612352, 862700083485257730, 862284752803561473, 862956401567703040, 862918809258217472, 862667140758896642, 862382164905787394, 862933427930234881, 862950555114754049, 862241330826760192, 863055587440984064, 862380841321758720, 862743350184685568, 862939945635393536, 862923566454648832, 862790324325933056, 863323752406413316, 862174427689123840, 862783659002269703, 863105770199670785, 1160297600031088641, 1161098997458722817, 1160733784750403584, 1160107901819805697, 1160166351920611328, 1162064260718944256, 1161656224141762561, 1160842138961289216, 1161351971242221569, 1161294814761148416, 1162170365541605377, 1161899294007447554, 1160176207834558465, 1161416438877478916, 1162017977023303680, 1161863887957966849, 1159403706690998273, 1159855939689652226, 1159695527145070592, 1161952833777700864, 1159972563398754304, 1160928427689594881, 1159952528034934784, 1161007237109653504, 1161350265473290240, 861647407699955712, 861636521547505664, 861299365260009473, 862209078487023617, 861692875033194498, 862051404386643969, 861955633636978688, 861940088833536000, 861982478311075841, 861528540914864128, 861929342221271040, 862254570482937856, 861526727159414784, 861566289415995392, 861585214161776640, 861615189229264897, 848537899595218945, 862016228243714048, 861501545405444096, 862275993746243584, 861670833751822339, 862239103999520768, 861573070825426944, 861642078920593410, 861988473204391936, 860898197153120258, 860480029234475008, 861300451475685382, 860563672837607425, 860464580446875650, 860435649861746689, 860522751320358914, 860374349404143617, 860832604836294656, 860470377855713280, 860019017238446080, 860569384401735681, 860807884719968256, 859685266591756288, 861147194233171968, 860454548678291460, 861186229215395840, 860837732389715969, 860564632351780864, 860538749431685120, 860217880545284096, 860564926242357248, 860840840327041024, 860202130736656385, 860785369150836737, 860135496013537280, 859761412649955328, 859872835518464005, 859851257237909509, 859958929484337152, 859866551817777153, 860052844891717632, 859884212480090113, 860198261813985280, 859839424405938178, 859879752550809607, 859874340694872064, 860250903751909376, 859874401524875264, 859858700651167744, 859847350138929152, 859893529723756545, 860024244406820865, 859869168216268800, 860197723760361480, 859502294282506240, 859880480191238144, 859841312257974272, 859734770598764544, 859845388286787584, 859807588828958720, 859680570544181249, 859457319763148800, 859753606354022401, 859084459127316480, 836221694264102914, 858775640354455555, 857879122646896640, 859380568215220224, 859494580588339203, 857560977562365952, 859737777654702080, 858230173283614720, 857607062972506112, 859811033476730880, 859465008144449536, 858260209545904130, 859149288781234177, 858288629034221568, 858114585437646848, 859820208713867264, 859451877834018816, 858668555767869441, 858961668109250560, 858971264282701824, 856248032316338176, 856504389917450240, 856591089322426369, 856506369683456000, 856216842268008448, 856801763286020096, 856759976257368064, 856263733924044801, 857323817345183744, 857620487123369986, 856428721233960961, 857475347796905984, 856605656769548288, 856498283090513920, 856246573067628544, 857339381031485440, 857518889093263360, 854869346425884672, 848192457049329665, 839160317242445824, 857389434756505600, 856520980792868865, 856805287151489024, 856270465253474304, 857529133198438401, 855429831202402304, 854201539505803264, 854742946419265536, 855212664229941248, 856206812206571520, 855258002496073732, 855478040306044932, 854338632131510272, 856212489234788353, 855522008028725249, 855271559786672128, 855052490307284992, 856011174978048002, 854345845709451268, 854548025825304577, 856083800878612481, 856200650190991364, 854413982224048134, 854674109233594368, 854754524896034816, 856043038799536128, 855416684903116803, 854592424127188992, 855344346098532353, 855262116659564544, 850078090848083968, 851687705280905216, 854344746336235525, 852226086759018497, 851297328124358658, 852959537086820356, 854410578693107712, 850640878683267072, 851389920417636352, 854432980948922370, 852436864325869568, 852910053346750464, 849852257214451712, 849725767109951488, 850766832390750209, 850281791646834688, 854286986894606336, 852167084817752064, 854272919354126336, 850687419607388160, 851764400696561664, 851837357963825152, 852120781463191552, 851404816647639042, 853578029335011329, 849889442361991169, 849358532197658624, 849370540016115714, 849119891164508161, 849233443984691200, 849307595177439234, 849348931943358465, 848490438839480320, 849130978475986948, 849263943109488640, 849082760098709506, 849538029605842945, 849376893992304644, 849107914954493953, 848796422237552640, 849552882043060224, 848774184536854528, 848873628997472257, 847882731371495424, 848230785920401408, 849558354917765120, 849569099655065600, 849633445731082240, 849348049101090816, 849583337031307265, 846245048354160640, 846755109434523648, 846395408893034503, 847453875510562816, 847360426534871040, 847441164454174720, 846442895129358340, 846858076800077824, 824376900785160193, 847848414876499968, 847174441931018240, 847863093539549189, 847493888348573696, 847033881106812930, 846488781595332610, 848208000284274688, 847058497720274946, 846836131597598720, 847282655385141250, 846403740043128832, 841392475080134661, 847506637287858176, 847070008249405440, 847028889151049729, 846446052853137408, 846291019972923392, 846392967996686336, 843892962425815042, 846106767763243008, 846393759654924288, 845756553194061824, 845149084130275329, 846394407255465985, 845414888692428801, 845928391765377025, 844803484150984705, 845020039745077250, 844946737865408512, 846394817156395010, 845009424813113346, 845015788222214144, 844956837602476033, 845718640381046784, 844983856776269829, 846393375205011456, 845666784787116032, 846043131107835905, 845034204144549890, 845033282219724800, 846392533492154368, 1159625872774537216, 1157479330332762112, 1158804981128073216, 1157387209743523841, 1159419705637126146, 1159409669657583622, 1158913199627878400, 1158487024426528768, 1158864782369415169, 1159008667963809793, 1159232724563038208, 1159510005005131777, 1159037269782802433, 1155514310308896768, 1159232937461714944, 1159532023805030400, 1158534574139248640, 1159116636990738432, 1157018050962567168, 1153396383648374784, 1157968555998154752, 1156971907415232512, 1159169030416207875, 1159254509719134208, 1157652567914139648, 844297426722865152, 844628469329907712, 843957061524295681, 844079683700494337, 843939454284939264, 844506324117413888, 843942677888614401, 844916941664014337, 844828435075645440, 843663432939266048, 843934324311429120, 844636175000317952, 843945608872427525, 844660160522006529, 844824702199595009, 843935242989715456, 844128571283181568, 843367276623675392, 844628677547753472, 844275003059322880, 844387277979631616, 843951509184372737, 843949755986313216, 844096832213016578, 843875280888434690, 843389230722224128, 843936574794612741, 842839088285802497, 842392969005031424, 843716890635788288, 842772821159919618, 842086948835532800, 842898051429675008, 843121595589844996, 843933264565981184, 843507646468685824, 842688054842347521, 842750296522723330, 843936404908445696, 843081420818055168, 842931061772308481, 843728255249268737, 842495663388737538, 842873033727598593, 842463198234214404, 842475683808960514, 843924641035042816, 843869022752067584, 843875714181054466, 843930769055727616, 841198025863229440, 842483424732610564, 842061050140868609, 842489573926039552, 841492359313514496, 842535590457499648, 841381793437736961, 841719476534009857, 842537358796898305, 842413808857579520, 840698928202936320, 842093481174695938, 842217383364186112, 841041278284529664, 841939169450557441, 841173824091652096, 841818473063829504, 841798594965458948, 840124605297639424, 841325654444511232, 840166397502193664, 842134963289968641, 840181418718318592, 841608620785696768, 841314665196081154, 838832230667538432, 839847481592655874, 839140058053627904, 840117361197834241, 837513624612552706, 839141804054298625, 839200199503380480, 839602136514236416, 839774761244852224, 839201664674340865, 839562884308860928, 839411690814988289, 838907654751797250, 839151776968372225, 783839966405230592, 838473725976657920, 837605847257792512, 837726787211825152, 837764759445471232, 839757890525233152, 838839013918322688, 839193489028055040, 839775158088921088, 839418241185374209, 839169213247926272, 836167953552982016, 835343419388067841, 835256980830834689, 835945377962606592, 836943966767575041, 835934454245900289, 834702259791486976, 834404684861366272, 836903020059320320, 835147205845581824, 834862752468500480, 836795000801222656, 812771686915444736, 835853093682229248, 834872207130165248, 834755755081351169, 834449528950497280, 834808975556239360, 834407043519897601, 834435129346977793, 834067851640193024, 699995143747825664, 837133959146455040, 836866918850125824, 836980008262369280, 831248379099353088, 829602019719643137, 833725207357583363, 831530112369586177, 833575028394491904, 829983151011278850, 829344627949961217, 831923451627704321, 831892288175534084, 829594585504452608, 832766382198566913, 829588364051542020, 831919032009969670, 830317663096336384, 832309157416071168, 832757467226402819, 828332257605726214, 830169852086190080, 733710266576293892, 831986841347878912, 828514842726182913, 833335838180204544, 832308624173256705, 829033233677430785, 833722901757046785, 825086968623046656, 827182771789524992, 825319878835961856, 782790440667975680, 824586145426264064, 827622355732201473, 784796179238445056, 825717683270344705, 828259083375484928, 824261649657896961, 828328360430428162, 824602485419565058, 826281899266019328, 825264698304106496, 824583755046199297, 827111365856882688, 825659533796184065, 826758211743121408, 826830403000483840, 826759240916271104, 782994475937333248, 824678253872898048, 824436489161314304, 826216446569086977, 827254678006009856, 823950090922561538, 822558339343220737, 823323642981482502, 823841206501330945, 821926738859069441, 821070925432963075, 823418988311052288, 817301700604207104, 824288609998163970, 823993908749275137, 818221826685812736, 823323588094816257, 822557389970870272, 789010785003417600, 823254170018922496, 821301218890891265, 824184792635867140, 822172051607785472, 822766792372260864, 821994743089549314, 822796898314633216, 822429266520473600, 822552288287920132, 822216346608005120, 823598840947310592, 819578993670324224, 257905419765305344, 819066613538373632, 819650018370011138, 820366566550335489, 819256684010819584, 820286088392704001, 819245486280503296, 819600937786478593, 819974435318956032, 821079389374939136, 821080793535619072, 820076754769444864, 819860659244515329, 820940399820832768, 813116057120600064, 817338392543428613, 818176170315366401, 819256464573427712, 820006165425819648, 821020272836878338, 818549039021064194, 818212269096050688, 819265732844331008, 821111559585984512, 814037339144155136, 813131204853661700, 817555232452276224, 813795306982797312, 815114428970635265, 813065079402983424, 813740638051168256, 813086744233070592, 816382197158408193, 813693722357534720, 814778818984603648, 816173450243018752, 813802160492163073, 814953210486067200, 814160096074735616, 816079915137335297, 814952826564648960, 813514046435688448, 814738966926807040, 816272993383043077, 815566097009311745, 816404808080982017, 816489368617709568, 817838693171994624, 814085068775915520, 1156755401406328832, 1155810485008326656, 1156326326388707328, 1155535996886364162, 1154821414425260035, 1156478951788896256, 1156976004398604293, 1155460564879073281, 1155762449120976898, 1155202562821197824, 1156325505957654528, 1156312775808999424, 1155563140970475520, 1156451370419007490, 1155830681764655109, 1156451928349372417, 1154856610453475328, 1156977802417037312, 1155918863676166146, 1155858401504780288, 1156297494827081733, 1156646688884498432, 1156969927468814343, 1155098953899229184, 1157289968336867335, 811188090492637184, 813017435196559360, 810604760629788672, 809778694063583232, 809671756839579648, 811613750310608900, 812060675426029572, 802065993010921472, 810911643936968704, 810937613842546688, 811920602412052480, 809030938227195904, 810826637050843136, 811603322683719680, 811871517994840064, 810739464947560448, 809520693977042944, 811664459336941572, 810901400846761984, 811596893147037696, 811663314270949377, 811613123060891648, 812931237975183360, 811691380334415872, 812960615438413824, 807626755641147393, 807280184898580480, 806775770748055552, 808947160515547136, 807955941199060992, 803684359165378560, 807656837847928832, 807627433042186240, 677856649919537152, 808247273704587264, 808584645495422976, 807190545542037505, 805855480337825793, 807901112544227328, 804614536456208388, 804464039199903746, 806930147161112577, 807732075931586560, 808987450848714753, 807280861762748416, 806499773717037062, 806216408593993730, 807630246086397952, 807627058486673408, 807279818551296004, 802129072423923712, 800160964985253890, 799660885652492288, 799221903688876032, 799229564954312704, 804053180569047041, 803688126409568257, 803955377452843008, 800423498434965504, 801776467613011968, 799332304778891264, 800309487626289152, 799710425608753152, 800430223581908993, 801871909189222403, 800739632606416896, 804402468356521984, 800283554840125440, 801137377955684352, 799682243744526336, 800093549265981440, 799222256702394368, 783656576594870276, 798897474148700160, 802873844319088640, 796144885548122112, 796215739564728320, 794924142244020224, 797823814218448896, 792772916777660416, 661943905852727300, 793231488628068352, 795983626190069760, 796392497626882048, 795638832523837440, 794606746534838272, 794670438903267328, 794607373260361728, 793429090082643968, 736981147691962368, 793065293576802304, 797720418475974656, 791758457351335937, 797196694089764864, 797950865168441344, 794636305577705473, 793066215719768068, 794191736142753792, 798191948934823937, 797786287289745408, 789454323612876800, 787265203897528322, 787584777188704257, 787064453187661824, 790916544431874048, 786664643121057792, 787882360255680512, 786928845798641664, 787269544427474946, 791283200580608000, 789203468477169664, 787673910837903360, 787407703144484868, 789437268230537216, 789581729812078592, 781253886359273472, 785872331608653825, 786910526404263936, 786737766843478016, 791245040999866368, 791169291571851265, 788373661812133888, 789951797762854916, 789462832035291136, 790808011480727552, 779331203656712193, 781584594634178560, 781155977903169536, 779055316411437056, 785974232614211585, 780749155673202688, 786183785393983488, 783794769478594560, 784516571293155328, 785852785271209984, 779388646252175361, 779591688717266944, 784070948597198848, 785370814870806528, 778250290256642048, 785257005602582529, 783019966941503488, 778505211631599616, 782630085383696384, 779180488405585920, 784463713344552964, 785303667305963523, 782600485760929793, 782882286362656768, 782253242835099648, 761205458245918720, 770825134538010624, 774895778817073152, 777485385437818881, 770515377075916800, 771539080827932672, 777915124459929600, 772863339781382144, 772800078520123393, 771964534017892353, 775593534665752576, 772002388140036096, 777173396153049088, 775970608484155393, 775296974845345793, 771767113048584193, 773586425342222337, 774053678575607808, 777902964790800384, 771036986647994368, 771101691919863808, 775258675183251456, 776877204609331204, 778179406154129409, 775297015915905024, 768784919636144128, 764915774603431937, 762756321494102017, 766679284450668546, 763593200930029568, 767671167918505984, 765557261737594881, 762287077056798720, 764944960852406272, 763342010413641729, 768877430350110720, 768756952528723969, 767788697408327682, 762005541388378112, 769628185231253504, 767963710170300416, 763389419659358208, 762321233543254020, 770375207219449858, 770332056689582080, 767627889953083392, 765498850253606912, 765634646189027328, 767466986758692865, 765649948557836288, 762117061136965632, 736001669058551808, 738133070339969024, 754506843179872256, 761348946870448128, 761596978597859328, 757764101896409088, 760849671430414336, 756999788642435072, 760935718927556608, 759519281713405957, 761779592445190144, 758477226123886593, 755541651767066624, 758328072324145152, 757976362703581184, 759537711329910785, 758759480276332546, 754983888192147456, 755328206387998720, 761542586335006720, 756353004601761792, 761586447388401664, 761331096051064833, 760876985790767104, 753386031089496064, 753597477962518533, 747762105282138112, 748620353044381696, 748248206971113472, 750906123876610052, 749707222414925824, 748452572005023744, 747928622107889664, 751640344232497157, 754068952624627714, 746743415069618176, 747748762412539904, 747730654385811458, 752624338415734784, 747000584226607104, 748173538671067136, 747838330394578944, 747864901973061632, 748689044846940160, 751186782843133952, 750819374391369728, 753385605816385536, 749327478360010752, 750758194851540992, 1152825659858870272, 1154450183729668096, 1153468121069412352, 1154918674182168576, 1153581863681835009, 1145890618805297153, 1153323797069611009, 1154786258654306305, 1152666639143510017, 1154322176763473920, 1153998809686523904, 1153155354336931841, 1152602169780183041, 1152198409975029760, 1154443501813346304, 1152959161455566857, 1151856688779145216, 1154638479055130624, 1097068721846321152, 1153580261528997893, 1154850227188199424, 1152657330430992384, 1155112952091029506, 1154800228798742528, 1155132515780374529, 747090091160518656, 437668894916890624, 746168309956042752, 714004476831469568, 746234803779842048, 742704580488777729, 743840732499283968, 743595762408357888, 744825394658938880, 746590650661888000, 743090104126738433, 725645207799209984, 666395434169049089, 744183817892659200, 742488120499785728, 745809145568190465, 741058948145381377, 661701656451551232, 742763834411122688, 743265724467187713, 708342511228600321, 737342980378525696, 741009132174483458, 709364990881472512, 745898254294990848, 731198978633519104, 735851511331356672, 737703963252793345, 726743090913005569, 739766770488246272, 732974768983412736, 730820811288891393, 732307827604246529, 731157031630049281, 733327711607873536, 738192739167244292, 734902575959412736, 733635687921000448, 738050643236126720, 738652490665693184, 735433157261045760, 740598159047569408, 736313796017328128, 731753985103777792, 738865749167480833, 737577193543340036, 734794879834959872, 731215975836585984, 823006247, 738977219226243072, 729604996128505857, 726024896791384069, 730828917943193605, 723228598187003908, 726024968396480512, 722053007689523200, 724302674426998784, 727653866389557248, 730483871670665216, 730410305268764677, 722380200571314177, 725053889381281795, 727210004365885442, 726023378583314433, 725138343315410944, 725239395297714176, 726024413708226560, 725652378851102720, 723881907247824896, 722175622655709185, 724547918330511361, 727537396791795713, 712401023722127361, 722053012399734784, 728034033494417408, 717781238019461121, 718037701891657728, 715998247232356352, 716902758079660032, 719554837545922560, 715895203085881344, 718786620380602368, 718277193827225601, 715877861815685121, 716065248550068224, 716292938267906048, 714813281748271104, 718175220637392897, 714364680391753729, 715569504835788801, 715846669716336640, 718823462513422336, 717441081131065344, 715623065078644738, 714364012490846208, 681541049823567877, 674193248257110016, 718790980317679616, 715156510054211585, 718861324801978369, 706638162035134464, 714394754600058880, 714394924628750339, 709533845851283457, 707223929014779904, 712628717290446848, 711586866311655428, 707850814505787392, 707197010714214400, 711955991722594304, 706448931429949440, 661966563600273408, 713859726912667650, 707861925934268416, 707122028973789184, 712682790031134722, 709384751581433857, 709130362606243841, 706110635948576769, 706822454354841600, 710826714314776576, 1886453406, 712907038834171905, 706918068019191809, 707188517458284545, 701707305780383744, 706284313529217024, 702196187424804869, 674264875259052032, 706176058404503553, 705319448790638592, 705413304282435584, 703332812439621632, 702376697514074112, 703130666121101313, 700275566268829697, 702528659698159616, 704187716808867840, 702638177471873024, 701075709452652544, 702532064554442753, 703920337705111554, 700034735507046400, 703632580730552321, 701107064857210880, 594168269759623168, 703073905527955456, 705714902057533440, 700658628907237376, 699432086965366784, 692762579983269888, 696322801070907393, 692582723471323136, 690186496956047360, 697340677366157312, 693127227807043588, 695249588899414017, 699488343147552768, 694317112228057089, 689828062855299072, 699771104618024962, 699916802382557184, 694204062695342080, 697074456569765888, 691967507612241920, 694576614798180352, 694376457473097734, 690977566207918080, 699048721380720640, 696972335522455552, 696061453007241216, 696763607544111105, 700067710818975745, 691998550138490880, 695976199009468416, 686871865638404097, 688815159494733824, 689648647756054528, 683710508202094592, 687202758605291520, 688983202027991040, 685172296789561344, 687718605212020737, 687289217576230916, 685583172969611264, 689738306603651072, 687385380820250624, 597053118317273089, 684693149445427200, 684433879160221696, 687042863679410176, 685080553876504577, 686834677907238912, 684672630503424000, 688015103334182912, 685957808047665152, 686911775955103744, 686883367154003969, 685543669827518464, 689763957779906560, 680717584040341504, 679726607754473472, 679419672735973376, 684313206299455488, 684316443710717952, 683026600003289088, 682139290088960001, 679325657655025664, 682202141080088576, 679045081937018880, 679270671365615616, 682142154576244736, 678878257303986176, 683994611405189120, 683160596607537152, 681993393921118209, 683613067167543296, 683094377221210112, 681453225669738496, 679443075484250114, 684256590447427584, 684020629897621508, 681396579916447744, 679697947626438656, 683342914643214336, 677464977192669184, 676318922833068033, 675256104008445952, 678629627527589888, 669126254982012929, 669796737960161281, 669880378254053376, 675323125052125184, 468302135457636352, 675237109687558144, 670341487222198273, 676502909022945280, 674716743235969025, 672404713275551744, 669481784787234817, 670992535083458561, 676517138983727105, 669655571042201600, 673422661767196672, 670381439582642176, 675367125276622848, 674633403241730048, 595667665907261441, 673599658380410880, 677775874956107776, 1106679304426000384, 1137072520585187328, 1151590620063916032, 1149828392189120512, 1116751913607766017, 1113767883526541312, 1149593378050301952, 1110873979349286913, 1100612918264115201, 1149446799133990912, 1146057239238549504, 1111954741012119552, 1096064094011052032, 1151984282367385601, 1150722215572365313, 1089562364331126785, 1150092483629649922, 1151538067024601089, 1151149725871149057, 1152157457038360581, 1098758271995830273, 1151590400706207744, 1150065292409802753, 1096618004509413377, 1150850658360266752, 662337804316332032, 665469421406846980, 669121489963192320, 665868549404143616, 667872980580483072, 661692463585824768, 663870880448012288, 663317254965223424, 663471557617065984, 668774520694644736, 664215016506327040, 663432708664766468, 666361855837782016, 665796286067642368, 661947711285915648, 668135760055267328, 634480704328495105, 664215694087704576, 665795365451505664, 668486143080579072, 666106045396328448, 668545366627864576, 668910972782772224, 667092029520875520, 193396715779395584, 644762141929549824, 173505226257608707, 656776679403163648, 647842593066360832, 659841259259998209, 654578262216196098, 652108041752588289, 645184772034162689, 644899230654574592, 644515688242016256, 650021871652614144, 657303932658692096, 654284782088658944, 653185583632793600, 659176944458670080, 647369225380724736, 658323438524846080, 644575337859432448, 658630170081906688, 598406648751857664, 653814492648841217, 647152057397477376, 657079482856157184, 644905443987431424, 643399698301222912, 643353745909252096, 635014502908588032, 622493501188485120, 637225711120609280, 640124945985634304, 640968101148905472, 623104046879129600, 621358391626235904, 635517255590129665, 627019153866661888, 633568621801963520, 612883284771536898, 621244721902583808, 630685538391973888, 629982443030884352, 637719407796572160, 636776466844393472, 631599372766191617, 623091414340141056, 641338755660427264, 642584238294851584, 638035192523923456, 624240622644404224, 624880218801618944, 631469558256242689, 352842253133283328, 614919287497715712, 615977919685525504, 609053735529103361, 616126614838071296, 609053047092834305, 604203758155866112, 616535931525459968, 610331217423134720, 610719688016961536, 619430911478730752, 616641464714559488, 615924554452574208, 604234601352028160, 614429791752712192, 603565794853855232, 608920986281472000, 605713704143998976, 615979773119041536, 608381227482103808, 607660175407734784, 611807687060418560, 609053627890675712, 603093474523664384, 605870562062143493, 595868054053085184, 594085792663871488, 598697612804493312, 593719742151688192, 596036703309135872, 599540490271338496, 600576936641986561, 596825651241324544, 464045477840044032, 484984399373799424, 591922204436226048, 593825748424601600, 597814602890616832, 602746823296589824, 598049895858237440, 596919679010131968, 601359837491023872, 596059835227054080, 598940192888791040, 595617204273618944, 595310950372093953, 597673612930379776, 597767159192883200, 598231026092081152, 593140094825078784, 588101121220161537, 585794185980207104, 578908946032799744, 589785701945868288, 584356789778538496, 580695377894047744, 585521397033738240, 579190263698063360, 586003840358420480, 579231627265642496, 588272164287160320, 587875445707776000, 580786340779941888, 583923364290527232, 584357686025805824, 578688394823237632, 584459847850192897, 587410637069746176, 585415413162500096, 590534928846172160, 585127255879344130, 585796837346521089, 587643377736425472, 589898694985654272, 41587168870797312, 576919055841394689, 577616108439621632, 573151285140189184, 575685914615095297, 426006675032522753, 577956278611390464, 576861137930727424, 572896113822470146, 576419146910580737, 576432203560685568, 577044122730508288, 577479871800168448, 573426015109816320, 572161251557687297, 576722182367227904, 572537596036956160, 573236675700133888, 572854585120833538, 578242069354930176, 572790214256566274, 572731844359266304, 573115674001854464, 572859385275293700, 578241245853569024, 573284156827942914, 566918842325413888, 569772879300202496, 567801652519116800, 563249579853099008, 571675916335747072, 570689902943346688, 569797681029234688, 568763762171355136, 569618409547288576, 569602880543567872, 565545160332046336, 569603287642730497, 561115115383443456, 569603674894409729, 562969945014034433, 568568034060849153, 567991364027334656, 568002795137142786, 570345384909762560, 569603899943841792, 561307729998778368, 570227722561069059, 569602567803707393, 564745021682122752, 569782401766957057, 559348707595141121, 558317721025544193, 558560055424208898, 557791530417913857, 558061448396824579, 555463122308571138, 556854584833232896, 556719363622195200, 562905411846963200, 558246072263643137, 557792227817435137, 560351164911194112, 557242700823822336, 557577751348408320, 559425225453215745, 557154351995969536, 560414992642875392, 558312611520204800, 558946999673061376, 556740556970553344, 556740594132062209, 558556562479149056, 555796720152743938, 558039784153968640, 555357778135756801, 553845759213584386, 553109560479993856, 554374653721198592, 552865575777869824, 555042807640236032, 554909922593619968, 554304472202362881, 554417621203189760, 553187584525221888, 553483665859432448, 553189729244811266, 555118533953458177, 553404094958694400, 554909683660914688, 554533242079309826, 552807296162869248, 553633967803744258, 527250251561066497, 552941159795142657, 554855017845256192, 553552353409138689, 552931277012467712, 555150116748021764, 554274763267649536, 553185979021164545, 1009115874182205440, 1022576408994963458, 1018546720391778304, 1089186073211744257, 1009084671878021120, 1089123085855453184, 1016857384571023360, 1007742104645316610, 969813402486038529, 969837184227274752, 1015016428028809216, 971051414872055808, 1017822346084868096, 1054054704777478149, 1019816078300545025, 989579668184592384, 982595672087162887, 1019395022259662849, 1085352506169933827, 1008382007745933312, 996802175207690241, 1013781070741999617, 1056500728502587392, 1071072590658195462, 989295035303608320, 548151198164221952, 550211354129600512, 551902362877829120, 542312284690071552, 552487444269252608, 551894820600696832, 546188340534321152, 552193859506405376, 548246547386105857, 546313800920866816, 549252463472021505, 546342549116715008, 543383520245448704, 551702099286061056, 544801845609529344, 542410111923146752, 543110069953765377, 545126596655742977, 540437976103550976, 551431883440271362, 539624406843006977, 542262943778607104, 545543818645622785, 545542209559621632, 551146438168940544, 523499973686886400, 537933477090312192, 531950827779665920, 539796273843666944, 535151289727221762, 533280019507056640, 539122262813974528, 539708778665738240, 535403347323650048, 535031824763080704, 536916950023438336, 534853114155638784, 539507517181935618, 539420776265699328, 535085277023600640, 532154117310144512, 524110901776220160, 538668536525512705, 536602107835854848, 531136618695258112, 535247825786126337, 537316943175643136, 530674949976248320, 537591733253840896, 535470816935563264, 529941202318393344, 523454495486136320, 523057875690995712, 530309048496041984, 523459027683250176, 528983983485648897, 527593393883709440, 524231098008879105, 529253507757801472, 522226030493200384, 529558759514046464, 527592876914782209, 525415702380158977, 526043450958151680, 528293912474316800, 521774960604610563, 502878691740090369, 527417205559164928, 527374268720775169, 522443866092617728, 525833418064416770, 523520828605222913, 524108060877684737, 524246717978648576, 526660116905750528, 516910790449061889, 518257254014136320, 514106839995539458, 515236467363557376, 512496478120865793, 511453497821528064, 516238031410708480, 510831962253049856, 516648260400721921, 517358472715710465, 516600616181698561, 521646493221265408, 509624263960453120, 519048456552591361, 520110423836995584, 518425622583201792, 511548354158149632, 510409997520343040, 520989996850085888, 509685673734180864, 517745986903736321, 511878568788643840, 512840394376110081, 519594152388874241, 519418721530810368, 497697549613277185, 502284709687492608, 507253430386458624, 508895734083497984, 496792051556421632, 505274849997369344, 500243671376478208, 503101774417637376, 497012730449391616, 496396099943677952, 503588689474510849, 499559946636111872, 497634433852534784, 502544522715623424, 504636149420544000, 496038887345905664, 508892919953358848, 504580460090253312, 506757806540587008, 499072013622083584, 496446831359193088, 497455855856803840, 496647163259408384, 507438402590244865, 506781101634097152, 494746795839614977, 494769406841749504, 492381007832948736, 314861959373799424, 495253115760041984, 492199108623732736, 496213087868174336, 494118321110142976, 492380606228344832, 495929920829534208, 456743324498403328, 496219127632363521, 489824207455678466, 491170290983264256, 495929125388185600, 490022570414964738, 490063068375056384, 494084386212827138, 489291012024856576, 496315351794454528, 491104915293356032, 494027364297617408, 490910794994184192, 494437179754831872, 491563020112642048, 474286776274944001, 479246310110146561, 458518201060851712, 468406262871621633, 481235195597979648, 486840716640149504, 480648507721015296, 461239790705582080, 471514511451901952, 471200860920619008, 461876186688536576, 469043209185013761, 463611651636621312, 486785893349728257, 480791030544228352, 486919114070302720, 487574035409432578, 469758501393547264, 487574444370841600, 472454210756575232, 458305417437642752, 482064618215731200, 457554778072313856, 486853439830626305, 480341497842110465, 434755570600378368, 436872964034678787, 450643987016056832, 435819149973925888, 454217890221543424, 449328511548137472, 438595471528189952, 433634257152774144, 453066434277416960, 454287982527520768, 456408576295464961, 433727642395635712, 432103682621337600, 432540906307067904, 453470021780787200, 448953821083869184, 437966194277363712, 440511571778105344, 435911092959580161, 450654210929860609, 438338217742331904, 454345035203354624, 433957401851473920, 433957180618731521, 435048825762611201, 430382757030551553, 430677875818123268, 419379588699926529, 431366846432804864, 432871518947659776, 431421840259416064, 425593044939718656, 433242053586067456, 427774363413127168, 421736257228918784, 421359082764005376, 433269996609761280, 430716964030644226, 428494742192533505, 425622443253055488, 419865907067105280, 432141408623804419, 428495445954789376, 433333529921871872, 432892122434650112, 432241545858011136, 433494168090861568, 431073961900658689, 430639799695724544, 433239267070849024, 379160070006640640, 357882722670215168, 370514925397213185, 402492434053357568, 380270166158110720, 408139919128010752, 417455592316231681, 370847233203535872, 398306728263315456, 380245094634225664, 407528526191919104, 383318049194901504, 402064474481643520, 383307953375158272, 401771803917307904, 360145258413166592, 406463168953606145, 418022724930641920, 402063463683743744, 393001783754510336, 362497298871246848, 359576568101732352, 365736118609641472, 376574110731489280, 413223886093033472, 931861139763466240, 943610882155835392, 967328478130593792, 941045974088192002, 942522738668863488, 954020555593863168, 932872211114987520, 942803216126922753, 942508034122764290, 946818707606487041, 932219173404594176, 935836119924723713, 942719398279876608, 949056729580482560, 936947647495262208, 940661984185520128, 919232648068911104, 922194565272080384, 934516687117877249, 964786616509362176, 942695011161919488, 934922280676798464, 954232766668865537, 930374602521538560, 949741667451637761, 290747723970383872, 280756003476213761, 289855642188013568, 269785942326398976, 292022993478119424, 309381840618287105, 266498201803182080, 320528087118913537, 271897346483298304, 258595233284116480, 256785088501661696, 291165340388438017, 285395968097148928, 291879498775949312, 331104248597192704, 342569520587759616, 304621904961085440, 321442094411554816, 299620570268585984, 268056424725229569, 291778553190690816, 330337644821241856, 301744965514575872, 271896161055543296, 356027819555426304, 235832721744752640, 239409791619964928, 152513895175692288, 217231887666647042, 226832049892364288, 255955872965083137, 249168449610330112, 894559744366714880, 918326115810365440, 905761483090522112, 905179532541485057, 894184179554033664, 894126572327907328, 905489832625012737, 902196550155345921, 905837988189437953, 894426408700850176, 894604765765804033, 912262374756937728, 894261694360199169, 894915042977751041, 893848261030666240, 902687000544911362, 902621969232916480, 894860932979056640, 908908645110489088, 894554869704654848, 913446427728203782, 916305843007746048, 894274236025638912, 899076829855830016, 902848212498829312)]
(Background on this error at: http://sqlalche.me/e/e3q8)
 13:14:31  jleroy@iMac-de-Jonathan  ~  🐍 Semiphemeral  $
 13:17:11  jleroy@iMac-de-Jonathan  ~  🐍 Semiphemeral  $
 13:17:11  jleroy@iMac-de-Jonathan  ~  🐍 Semiphemeral  $
 13:17:11  jleroy@iMac-de-Jonathan  ~  🐍 Semiphemeral  $ pip freeze
certifi==2019.9.11
chardet==3.0.4
Click==7.0
colorama==0.4.1
Flask==1.1.1
idna==2.8
itsdangerous==1.1.0
Jinja2==2.10.1
MarkupSafe==1.1.1
oauthlib==3.1.0
PySocks==1.7.1
requests==2.22.0
requests-oauthlib==1.2.0
semiphemeral==0.5
six==1.12.0
SQLAlchemy==1.3.8
tweepy==3.8.0
urllib3==1.25.5
Werkzeug==0.16.0
 13:17:14  jleroy@iMac-de-Jonathan  ~  🐍 Semiphemeral  $ semiphemeral unlike --filename Downloads/twitter-2019-09-20-08cb1307005a3fd61fb9ab1adac8e97683b9ef55fff52f85a7f2913c71a9f56d/like.js
semiphemeral 0.5
WARNING: One does not simply unlike old tweets. According to the Twitter API, you didn't like these old tweets, so you can't unlike them -- even though they're listed in your like history. The only way to remove them from your like history is to LIKE THEM AGAIN, and then you can unlike them. This is very noisy. Every time you re-like a tweet, the user will get a notification.
Do you want to continue? [y/N]: y
Making a list of liked tweet status_ids
Like history has 2032 tweets
Loading tweets from database
Traceback (most recent call last):
  File "/Users/jleroy/.pyvenv/Semiphemeral/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1249, in _execute_context
    cursor, statement, parameters, context
  File "/Users/jleroy/.pyvenv/Semiphemeral/lib/python3.7/site-packages/sqlalchemy/engine/default.py", line 552, in do_execute
    cursor.execute(statement, parameters)
sqlite3.OperationalError: too many SQL variables

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
  File "/Users/jleroy/.pyvenv/Semiphemeral/bin/semiphemeral", line 10, in <module>
    sys.exit(main())
  File "/Users/jleroy/.pyvenv/Semiphemeral/lib/python3.7/site-packages/click/core.py", line 764, in __call__
    return self.main(*args, **kwargs)
  File "/Users/jleroy/.pyvenv/Semiphemeral/lib/python3.7/site-packages/click/core.py", line 717, in main
    rv = self.invoke(ctx)
  File "/Users/jleroy/.pyvenv/Semiphemeral/lib/python3.7/site-packages/click/core.py", line 1137, in invoke
    return _process_result(sub_ctx.command.invoke(sub_ctx))
  File "/Users/jleroy/.pyvenv/Semiphemeral/lib/python3.7/site-packages/click/core.py", line 956, in invoke
    return ctx.invoke(self.callback, **ctx.params)
  File "/Users/jleroy/.pyvenv/Semiphemeral/lib/python3.7/site-packages/click/core.py", line 555, in invoke
    return callback(*args, **kwargs)
  File "/Users/jleroy/.pyvenv/Semiphemeral/lib/python3.7/site-packages/semiphemeral/__init__.py", line 75, in unlike
    t.unlike(filename)
  File "/Users/jleroy/.pyvenv/Semiphemeral/lib/python3.7/site-packages/semiphemeral/twitter.py", line 385, in unlike
    for tweet in self.common.session.query(Tweet).filter(Tweet.status_id.in_(like_status_ids)).order_by(Tweet.created_at.desc()).all():
  File "/Users/jleroy/.pyvenv/Semiphemeral/lib/python3.7/site-packages/sqlalchemy/orm/query.py", line 3178, in all
    return list(self)
  File "/Users/jleroy/.pyvenv/Semiphemeral/lib/python3.7/site-packages/sqlalchemy/orm/query.py", line 3334, in __iter__
    return self._execute_and_instances(context)
  File "/Users/jleroy/.pyvenv/Semiphemeral/lib/python3.7/site-packages/sqlalchemy/orm/query.py", line 3359, in _execute_and_instances
    result = conn.execute(querycontext.statement, self._params)
  File "/Users/jleroy/.pyvenv/Semiphemeral/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 988, in execute
    return meth(self, multiparams, params)
  File "/Users/jleroy/.pyvenv/Semiphemeral/lib/python3.7/site-packages/sqlalchemy/sql/elements.py", line 287, in _execute_on_connection
    return connection._execute_clauseelement(self, multiparams, params)
  File "/Users/jleroy/.pyvenv/Semiphemeral/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1107, in _execute_clauseelement
    distilled_params,
  File "/Users/jleroy/.pyvenv/Semiphemeral/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1253, in _execute_context
    e, statement, parameters, cursor, context
  File "/Users/jleroy/.pyvenv/Semiphemeral/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1473, in _handle_dbapi_exception
    util.raise_from_cause(sqlalchemy_exception, exc_info)
  File "/Users/jleroy/.pyvenv/Semiphemeral/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 398, in raise_from_cause
    reraise(type(exception), exception, tb=exc_tb, cause=cause)
  File "/Users/jleroy/.pyvenv/Semiphemeral/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 152, in reraise
    raise value.with_traceback(tb)
  File "/Users/jleroy/.pyvenv/Semiphemeral/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1249, in _execute_context
    cursor, statement, parameters, context
  File "/Users/jleroy/.pyvenv/Semiphemeral/lib/python3.7/site-packages/sqlalchemy/engine/default.py", line 552, in do_execute
    cursor.execute(statement, parameters)
sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) too many SQL variables
[SQL: SELECT tweets.id AS tweets_id, tweets.created_at AS tweets_created_at, tweets.user_id AS tweets_user_id, tweets.user_screen_name AS tweets_user_screen_name, tweets.status_id AS tweets_status_id, tweets.lang AS tweets_lang, tweets.source AS tweets_source, tweets.source_url AS tweets_source_url, tweets.text AS tweets_text, tweets.in_reply_to_screen_name AS tweets_in_reply_to_screen_name, tweets.in_reply_to_status_id AS tweets_in_reply_to_status_id, tweets.in_reply_to_user_id AS tweets_in_reply_to_user_id, tweets.retweet_count AS tweets_retweet_count, tweets.favorite_count AS tweets_favorite_count, tweets.retweeted AS tweets_retweeted, tweets.favorited AS tweets_favorited, tweets.is_retweet AS tweets_is_retweet, tweets.is_deleted AS tweets_is_deleted, tweets.is_unliked AS tweets_is_unliked, tweets.exclude_from_delete AS tweets_exclude_from_delete, tweets.thread_id AS tweets_thread_id
FROM tweets
WHERE tweets.status_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY tweets.created_at DESC]
[parameters: (1166414617695928327, 1167447392557457408, 1166385155763789830, 1166151432543903744, 1166033612489314306, 1167405867668574208, 1166254016940138502, 1114253313971589120, 1114209903256715265, 1165760903809130496, 1166707917833363457, 1167087999630434304, 1165924317789642752, 1114238897020710919, 1165707463703826434, 1166408347345666053, 1114212454710611973, 1167589076653887489, 1167482836150050818, 1167533965152010242, 1167356783251349504, 1166103060881518597, 1166998802957516802, 1165990406737338369, 1167436971255500800, 1165023198855016448, 1164552820957294592, 1163559319087923200, 1163712413621002240, 1079359711227580416, 1163036559974817793, 1162388603969912832, 1164494500506591232, 1165081616030388225, 1164254189062483968, 1164785161990356993, 1164131613917138945, 1161872352499699712, 1162749536374263809, 1165390810298421248, 1162453096733257728, 1164952138545602560, 1162339695277346817, 1162558721219801088, 1165466169962311680, 1164756054887919616, 1163535602798776321, 1162345542615257088, 1162650153309765632, 1165308685775556613, 882703250184699909, 893928448330260480, 893520075436818432, 893572338641494016, 891005534375161856, 894177481883889664, 893409829859065856, 883732967071391744, 892344196203524096, 893800217383927809, 893913643682643968, 893419397494255616, 893449454430429184, 887120066021425152, 888079972916539392, 888728181515190273, 882699557234200576, 884476143491067906, 884416390870048768, 882831404962369536, 884421467227795458, 893351960455270400, 880487235866554368, 893779426953093120, 880484729799274496, 875614000364404737, 876070030127099904, 875862924253814784, 876152097724669953, 876663201118793729, 875807430168522754, 875796998955438080, 875155083377430528, 876157601377136641, 876480828414603266, 875456385231794177, 878168045683912704, 875641422237491203, 876103078566649856, 875859569389559810, 818478622520569857, 875747154521882624, 876516303300853763, 875775592146366466, 875749479374344193, 876407887115018240, 876682431750967297, 875615345091911681, 707539744918478848, 875567305320579072, 874257235031068672, 875131702619889669, 874292128851136518, 874987926685458434, 875284847824183296, 874381160683589632, 874454133700427777, 874367835484688386, 874984545698947072, 874733630739726336, 875074679198949376, 874945557999104000, 874308043189633024, 874952252661911552, 874024634114551809, 874677837910900743, 768349823753945088, 874628643330416640, 875381006722793472, 874600249972666368, 875326581698428932, 874562585269612544, 875021787792371712, 875056319618834437, 873997816166854656, 872626786827472896, 872340169596207104, 862269379995742214, 873183132085870593, 874023636243492865, 873186390539988993, 872523643783401473, 872387506821632001, 872512184663670785, 872669561623003136, 872511778415976448, 873694856614481920, 872881177023139842, 873288845890117632, 873190123487113216, 873103359124750337, 872718082434838528, 872467686357434369, 872135361220235268, 873319228199358466, 872486366013161472, 872908306200895488, 873981124011229184, 873922558487392256, 871987839168372736, 870695804201074690, 871262943350050816, 870670258796863490, 869931563995287552, 871473619578310657, 871772970242502656, 870961780104810496, 871186317542957056, 871973451510296576, 870912082191011842, 870322157888450560, 872038328534577152, 871769768063377408, 871455204096528384, 872044045056569344, 870400062240772096, 871043195039252484, 871399961866510336, 785875998516531200, 869901583089381377, 870678163281518592, 871020090837356544, 870208857431298049, 871098149804310528, 871382012371902464, 868867963633401856, 868533517336141824, 869288698067791878, 870027424645435392, 869286517012926464, 869971562551750660, 869471671362760704, 869157987373461504, 870207640781115392, 868514457336651778, 869180223077658624, 869548532847583232, 869175384817926144, 868406625928916992, 869128970326986752, 869284271114113024, 869644985020403713, 869438021900390401, 868852046853754880, 869084783401414656, 869267006914211842, 868836331400691712, 869532150760165377, 868559834320392195, 869299116509196288, 867673990009151488, 867697393806049282, 866943715037900800, 865680141229412352, 866525701909790720, 866784956110041088, 867021695625961473, 866530361324429312, 866529502662463488, 866668725243568129, 866578331029909504, 866726219416580096, 845807163113193472, 866226163924049920, 866746952263905281, 867410700863516674, 867483745108021248, 867821084279787525, 867361019764637696, 868424781091287040, 868441061890371584, 866721206673694720, 866529765246816256, 866963675877449729, 867054842832986112, 865172848507269120, 864427589691211776, 865688636196519938, 864426249103572992, 864403712692899841, 864397221755838464, 864788048638357504, 865493803897044992, 864459557166338048, 865347608017022976, 865727889681113089, 864720773092524032, 864665943129108481, 864926538478780416, 865672177055674368, 864753169649336322, 864426740428533761, 866141198737707009, 865200060354527233, 866233021057445890, 865176766268264448, 865353232222109696, 864516142366429184, 865113337461342208, 864401939651547136, 863728652772573188, 864064438047047680, 863624965781938176, 864076101236248576, 863629191627112448, 864024839761178624, 863424363810271233, 863743850757619713, 864038621078323200, 863754226413031424, 864378506012241920, 863432100342583297, 858431434683535360, 863415877831729152, 864378217066627072, 864128583924686848, 862786851072909312, 863692891738169345, 863406474881622016, 863797957732298756, 863727299635679232, 863627350055030784, 864166521580421125, 859891943349800965, 863524074496065537, 863148401529114624, 862379216930652160, 862923752174235648, 862918309121056768, 862661011882561537, 863068766816612352, 862700083485257730, 862284752803561473, 862956401567703040, 862918809258217472, 862667140758896642, 862382164905787394, 862933427930234881, 862950555114754049, 862241330826760192, 863055587440984064, 862380841321758720, 862743350184685568, 862939945635393536, 862923566454648832, 862790324325933056, 863323752406413316, 862174427689123840, 862783659002269703, 863105770199670785, 1160297600031088641, 1161098997458722817, 1160733784750403584, 1160107901819805697, 1160166351920611328, 1162064260718944256, 1161656224141762561, 1160842138961289216, 1161351971242221569, 1161294814761148416, 1162170365541605377, 1161899294007447554, 1160176207834558465, 1161416438877478916, 1162017977023303680, 1161863887957966849, 1159403706690998273, 1159855939689652226, 1159695527145070592, 1161952833777700864, 1159972563398754304, 1160928427689594881, 1159952528034934784, 1161007237109653504, 1161350265473290240, 861647407699955712, 861636521547505664, 861299365260009473, 862209078487023617, 861692875033194498, 862051404386643969, 861955633636978688, 861940088833536000, 861982478311075841, 861528540914864128, 861929342221271040, 862254570482937856, 861526727159414784, 861566289415995392, 861585214161776640, 861615189229264897, 848537899595218945, 862016228243714048, 861501545405444096, 862275993746243584, 861670833751822339, 862239103999520768, 861573070825426944, 861642078920593410, 861988473204391936, 860898197153120258, 860480029234475008, 861300451475685382, 860563672837607425, 860464580446875650, 860435649861746689, 860522751320358914, 860374349404143617, 860832604836294656, 860470377855713280, 860019017238446080, 860569384401735681, 860807884719968256, 859685266591756288, 861147194233171968, 860454548678291460, 861186229215395840, 860837732389715969, 860564632351780864, 860538749431685120, 860217880545284096, 860564926242357248, 860840840327041024, 860202130736656385, 860785369150836737, 860135496013537280, 859761412649955328, 859872835518464005, 859851257237909509, 859958929484337152, 859866551817777153, 860052844891717632, 859884212480090113, 860198261813985280, 859839424405938178, 859879752550809607, 859874340694872064, 860250903751909376, 859874401524875264, 859858700651167744, 859847350138929152, 859893529723756545, 860024244406820865, 859869168216268800, 860197723760361480, 859502294282506240, 859880480191238144, 859841312257974272, 859734770598764544, 859845388286787584, 859807588828958720, 859680570544181249, 859457319763148800, 859753606354022401, 859084459127316480, 836221694264102914, 858775640354455555, 857879122646896640, 859380568215220224, 859494580588339203, 857560977562365952, 859737777654702080, 858230173283614720, 857607062972506112, 859811033476730880, 859465008144449536, 858260209545904130, 859149288781234177, 858288629034221568, 858114585437646848, 859820208713867264, 859451877834018816, 858668555767869441, 858961668109250560, 858971264282701824, 856248032316338176, 856504389917450240, 856591089322426369, 856506369683456000, 856216842268008448, 856801763286020096, 856759976257368064, 856263733924044801, 857323817345183744, 857620487123369986, 856428721233960961, 857475347796905984, 856605656769548288, 856498283090513920, 856246573067628544, 857339381031485440, 857518889093263360, 854869346425884672, 848192457049329665, 839160317242445824, 857389434756505600, 856520980792868865, 856805287151489024, 856270465253474304, 857529133198438401, 855429831202402304, 854201539505803264, 854742946419265536, 855212664229941248, 856206812206571520, 855258002496073732, 855478040306044932, 854338632131510272, 856212489234788353, 855522008028725249, 855271559786672128, 855052490307284992, 856011174978048002, 854345845709451268, 854548025825304577, 856083800878612481, 856200650190991364, 854413982224048134, 854674109233594368, 854754524896034816, 856043038799536128, 855416684903116803, 854592424127188992, 855344346098532353, 855262116659564544, 850078090848083968, 851687705280905216, 854344746336235525, 852226086759018497, 851297328124358658, 852959537086820356, 854410578693107712, 850640878683267072, 851389920417636352, 854432980948922370, 852436864325869568, 852910053346750464, 849852257214451712, 849725767109951488, 850766832390750209, 850281791646834688, 854286986894606336, 852167084817752064, 854272919354126336, 850687419607388160, 851764400696561664, 851837357963825152, 852120781463191552, 851404816647639042, 853578029335011329, 849889442361991169, 849358532197658624, 849370540016115714, 849119891164508161, 849233443984691200, 849307595177439234, 849348931943358465, 848490438839480320, 849130978475986948, 849263943109488640, 849082760098709506, 849538029605842945, 849376893992304644, 849107914954493953, 848796422237552640, 849552882043060224, 848774184536854528, 848873628997472257, 847882731371495424, 848230785920401408, 849558354917765120, 849569099655065600, 849633445731082240, 849348049101090816, 849583337031307265, 846245048354160640, 846755109434523648, 846395408893034503, 847453875510562816, 847360426534871040, 847441164454174720, 846442895129358340, 846858076800077824, 824376900785160193, 847848414876499968, 847174441931018240, 847863093539549189, 847493888348573696, 847033881106812930, 846488781595332610, 848208000284274688, 847058497720274946, 846836131597598720, 847282655385141250, 846403740043128832, 841392475080134661, 847506637287858176, 847070008249405440, 847028889151049729, 846446052853137408, 846291019972923392, 846392967996686336, 843892962425815042, 846106767763243008, 846393759654924288, 845756553194061824, 845149084130275329, 846394407255465985, 845414888692428801, 845928391765377025, 844803484150984705, 845020039745077250, 844946737865408512, 846394817156395010, 845009424813113346, 845015788222214144, 844956837602476033, 845718640381046784, 844983856776269829, 846393375205011456, 845666784787116032, 846043131107835905, 845034204144549890, 845033282219724800, 846392533492154368, 1159625872774537216, 1157479330332762112, 1158804981128073216, 1157387209743523841, 1159419705637126146, 1159409669657583622, 1158913199627878400, 1158487024426528768, 1158864782369415169, 1159008667963809793, 1159232724563038208, 1159510005005131777, 1159037269782802433, 1155514310308896768, 1159232937461714944, 1159532023805030400, 1158534574139248640, 1159116636990738432, 1157018050962567168, 1153396383648374784, 1157968555998154752, 1156971907415232512, 1159169030416207875, 1159254509719134208, 1157652567914139648, 844297426722865152, 844628469329907712, 843957061524295681, 844079683700494337, 843939454284939264, 844506324117413888, 843942677888614401, 844916941664014337, 844828435075645440, 843663432939266048, 843934324311429120, 844636175000317952, 843945608872427525, 844660160522006529, 844824702199595009, 843935242989715456, 844128571283181568, 843367276623675392, 844628677547753472, 844275003059322880, 844387277979631616, 843951509184372737, 843949755986313216, 844096832213016578, 843875280888434690, 843389230722224128, 843936574794612741, 842839088285802497, 842392969005031424, 843716890635788288, 842772821159919618, 842086948835532800, 842898051429675008, 843121595589844996, 843933264565981184, 843507646468685824, 842688054842347521, 842750296522723330, 843936404908445696, 843081420818055168, 842931061772308481, 843728255249268737, 842495663388737538, 842873033727598593, 842463198234214404, 842475683808960514, 843924641035042816, 843869022752067584, 843875714181054466, 843930769055727616, 841198025863229440, 842483424732610564, 842061050140868609, 842489573926039552, 841492359313514496, 842535590457499648, 841381793437736961, 841719476534009857, 842537358796898305, 842413808857579520, 840698928202936320, 842093481174695938, 842217383364186112, 841041278284529664, 841939169450557441, 841173824091652096, 841818473063829504, 841798594965458948, 840124605297639424, 841325654444511232, 840166397502193664, 842134963289968641, 840181418718318592, 841608620785696768, 841314665196081154, 838832230667538432, 839847481592655874, 839140058053627904, 840117361197834241, 837513624612552706, 839141804054298625, 839200199503380480, 839602136514236416, 839774761244852224, 839201664674340865, 839562884308860928, 839411690814988289, 838907654751797250, 839151776968372225, 783839966405230592, 838473725976657920, 837605847257792512, 837726787211825152, 837764759445471232, 839757890525233152, 838839013918322688, 839193489028055040, 839775158088921088, 839418241185374209, 839169213247926272, 836167953552982016, 835343419388067841, 835256980830834689, 835945377962606592, 836943966767575041, 835934454245900289, 834702259791486976, 834404684861366272, 836903020059320320, 835147205845581824, 834862752468500480, 836795000801222656, 812771686915444736, 835853093682229248, 834872207130165248, 834755755081351169, 834449528950497280, 834808975556239360, 834407043519897601, 834435129346977793, 834067851640193024, 699995143747825664, 837133959146455040, 836866918850125824, 836980008262369280, 831248379099353088, 829602019719643137, 833725207357583363, 831530112369586177, 833575028394491904, 829983151011278850, 829344627949961217, 831923451627704321, 831892288175534084, 829594585504452608, 832766382198566913, 829588364051542020, 831919032009969670, 830317663096336384, 832309157416071168, 832757467226402819, 828332257605726214, 830169852086190080, 733710266576293892, 831986841347878912, 828514842726182913, 833335838180204544, 832308624173256705, 829033233677430785, 833722901757046785, 825086968623046656, 827182771789524992, 825319878835961856, 782790440667975680, 824586145426264064, 827622355732201473, 784796179238445056, 825717683270344705, 828259083375484928, 824261649657896961, 828328360430428162, 824602485419565058, 826281899266019328, 825264698304106496, 824583755046199297, 827111365856882688, 825659533796184065, 826758211743121408, 826830403000483840, 826759240916271104, 782994475937333248, 824678253872898048, 824436489161314304, 826216446569086977, 827254678006009856, 823950090922561538, 822558339343220737, 823323642981482502, 823841206501330945, 821926738859069441, 821070925432963075, 823418988311052288, 817301700604207104, 824288609998163970, 823993908749275137, 818221826685812736, 823323588094816257, 822557389970870272, 789010785003417600, 823254170018922496, 821301218890891265, 824184792635867140, 822172051607785472, 822766792372260864, 821994743089549314, 822796898314633216, 822429266520473600, 822552288287920132, 822216346608005120, 823598840947310592, 819578993670324224, 257905419765305344, 819066613538373632, 819650018370011138, 820366566550335489, 819256684010819584, 820286088392704001, 819245486280503296, 819600937786478593, 819974435318956032, 821079389374939136, 821080793535619072, 820076754769444864, 819860659244515329, 820940399820832768, 813116057120600064, 817338392543428613, 818176170315366401, 819256464573427712, 820006165425819648, 821020272836878338, 818549039021064194, 818212269096050688, 819265732844331008, 821111559585984512, 814037339144155136, 813131204853661700, 817555232452276224, 813795306982797312, 815114428970635265, 813065079402983424, 813740638051168256, 813086744233070592, 816382197158408193, 813693722357534720, 814778818984603648, 816173450243018752, 813802160492163073, 814953210486067200, 814160096074735616, 816079915137335297, 814952826564648960, 813514046435688448, 814738966926807040, 816272993383043077, 815566097009311745, 816404808080982017, 816489368617709568, 817838693171994624, 814085068775915520, 1156755401406328832, 1155810485008326656, 1156326326388707328, 1155535996886364162, 1154821414425260035, 1156478951788896256, 1156976004398604293, 1155460564879073281, 1155762449120976898, 1155202562821197824, 1156325505957654528, 1156312775808999424, 1155563140970475520, 1156451370419007490, 1155830681764655109, 1156451928349372417, 1154856610453475328, 1156977802417037312, 1155918863676166146, 1155858401504780288, 1156297494827081733, 1156646688884498432, 1156969927468814343, 1155098953899229184, 1157289968336867335, 811188090492637184, 813017435196559360, 810604760629788672, 809778694063583232, 809671756839579648, 811613750310608900, 812060675426029572, 802065993010921472, 810911643936968704, 810937613842546688, 811920602412052480, 809030938227195904, 810826637050843136, 811603322683719680, 811871517994840064, 810739464947560448, 809520693977042944, 811664459336941572, 810901400846761984, 811596893147037696, 811663314270949377, 811613123060891648, 812931237975183360, 811691380334415872, 812960615438413824, 807626755641147393, 807280184898580480, 806775770748055552, 808947160515547136, 807955941199060992, 803684359165378560, 807656837847928832, 807627433042186240, 677856649919537152, 808247273704587264, 808584645495422976, 807190545542037505, 805855480337825793, 807901112544227328, 804614536456208388, 804464039199903746, 806930147161112577, 807732075931586560, 808987450848714753, 807280861762748416, 806499773717037062, 806216408593993730, 807630246086397952, 807627058486673408, 807279818551296004, 802129072423923712, 800160964985253890, 799660885652492288, 799221903688876032, 799229564954312704, 804053180569047041, 803688126409568257, 803955377452843008, 800423498434965504, 801776467613011968, 799332304778891264, 800309487626289152, 799710425608753152, 800430223581908993, 801871909189222403, 800739632606416896, 804402468356521984, 800283554840125440, 801137377955684352, 799682243744526336, 800093549265981440, 799222256702394368, 783656576594870276, 798897474148700160, 802873844319088640, 796144885548122112, 796215739564728320, 794924142244020224, 797823814218448896, 792772916777660416, 661943905852727300, 793231488628068352, 795983626190069760, 796392497626882048, 795638832523837440, 794606746534838272, 794670438903267328, 794607373260361728, 793429090082643968, 736981147691962368, 793065293576802304, 797720418475974656, 791758457351335937, 797196694089764864, 797950865168441344, 794636305577705473, 793066215719768068, 794191736142753792, 798191948934823937, 797786287289745408, 789454323612876800, 787265203897528322, 787584777188704257, 787064453187661824, 790916544431874048, 786664643121057792, 787882360255680512, 786928845798641664, 787269544427474946, 791283200580608000, 789203468477169664, 787673910837903360, 787407703144484868, 789437268230537216, 789581729812078592, 781253886359273472, 785872331608653825, 786910526404263936, 786737766843478016, 791245040999866368, 791169291571851265, 788373661812133888, 789951797762854916, 789462832035291136, 790808011480727552, 779331203656712193, 781584594634178560, 781155977903169536, 779055316411437056, 785974232614211585, 780749155673202688, 786183785393983488, 783794769478594560, 784516571293155328, 785852785271209984, 779388646252175361, 779591688717266944, 784070948597198848, 785370814870806528, 778250290256642048, 785257005602582529, 783019966941503488, 778505211631599616, 782630085383696384, 779180488405585920, 784463713344552964, 785303667305963523, 782600485760929793, 782882286362656768, 782253242835099648, 761205458245918720, 770825134538010624, 774895778817073152, 777485385437818881, 770515377075916800, 771539080827932672, 777915124459929600, 772863339781382144, 772800078520123393, 771964534017892353, 775593534665752576, 772002388140036096, 777173396153049088, 775970608484155393, 775296974845345793, 771767113048584193, 773586425342222337, 774053678575607808, 777902964790800384, 771036986647994368, 771101691919863808, 775258675183251456, 776877204609331204, 778179406154129409, 775297015915905024, 768784919636144128, 764915774603431937, 762756321494102017, 766679284450668546, 763593200930029568, 767671167918505984, 765557261737594881, 762287077056798720, 764944960852406272, 763342010413641729, 768877430350110720, 768756952528723969, 767788697408327682, 762005541388378112, 769628185231253504, 767963710170300416, 763389419659358208, 762321233543254020, 770375207219449858, 770332056689582080, 767627889953083392, 765498850253606912, 765634646189027328, 767466986758692865, 765649948557836288, 762117061136965632, 736001669058551808, 738133070339969024, 754506843179872256, 761348946870448128, 761596978597859328, 757764101896409088, 760849671430414336, 756999788642435072, 760935718927556608, 759519281713405957, 761779592445190144, 758477226123886593, 755541651767066624, 758328072324145152, 757976362703581184, 759537711329910785, 758759480276332546, 754983888192147456, 755328206387998720, 761542586335006720, 756353004601761792, 761586447388401664, 761331096051064833, 760876985790767104, 753386031089496064, 753597477962518533, 747762105282138112, 748620353044381696, 748248206971113472, 750906123876610052, 749707222414925824, 748452572005023744, 747928622107889664, 751640344232497157, 754068952624627714, 746743415069618176, 747748762412539904, 747730654385811458, 752624338415734784, 747000584226607104, 748173538671067136, 747838330394578944, 747864901973061632, 748689044846940160, 751186782843133952, 750819374391369728, 753385605816385536, 749327478360010752, 750758194851540992, 1152825659858870272, 1154450183729668096, 1153468121069412352, 1154918674182168576, 1153581863681835009, 1145890618805297153, 1153323797069611009, 1154786258654306305, 1152666639143510017, 1154322176763473920, 1153998809686523904, 1153155354336931841, 1152602169780183041, 1152198409975029760, 1154443501813346304, 1152959161455566857, 1151856688779145216, 1154638479055130624, 1097068721846321152, 1153580261528997893, 1154850227188199424, 1152657330430992384, 1155112952091029506, 1154800228798742528, 1155132515780374529, 747090091160518656, 437668894916890624, 746168309956042752, 714004476831469568, 746234803779842048, 742704580488777729, 743840732499283968, 743595762408357888, 744825394658938880, 746590650661888000, 743090104126738433, 725645207799209984, 666395434169049089, 744183817892659200, 742488120499785728, 745809145568190465, 741058948145381377, 661701656451551232, 742763834411122688, 743265724467187713, 708342511228600321, 737342980378525696, 741009132174483458, 709364990881472512, 745898254294990848, 731198978633519104, 735851511331356672, 737703963252793345, 726743090913005569, 739766770488246272, 732974768983412736, 730820811288891393, 732307827604246529, 731157031630049281, 733327711607873536, 738192739167244292, 734902575959412736, 733635687921000448, 738050643236126720, 738652490665693184, 735433157261045760, 740598159047569408, 736313796017328128, 731753985103777792, 738865749167480833, 737577193543340036, 734794879834959872, 731215975836585984, 823006247, 738977219226243072, 729604996128505857, 726024896791384069, 730828917943193605, 723228598187003908, 726024968396480512, 722053007689523200, 724302674426998784, 727653866389557248, 730483871670665216, 730410305268764677, 722380200571314177, 725053889381281795, 727210004365885442, 726023378583314433, 725138343315410944, 725239395297714176, 726024413708226560, 725652378851102720, 723881907247824896, 722175622655709185, 724547918330511361, 727537396791795713, 712401023722127361, 722053012399734784, 728034033494417408, 717781238019461121, 718037701891657728, 715998247232356352, 716902758079660032, 719554837545922560, 715895203085881344, 718786620380602368, 718277193827225601, 715877861815685121, 716065248550068224, 716292938267906048, 714813281748271104, 718175220637392897, 714364680391753729, 715569504835788801, 715846669716336640, 718823462513422336, 717441081131065344, 715623065078644738, 714364012490846208, 681541049823567877, 674193248257110016, 718790980317679616, 715156510054211585, 718861324801978369, 706638162035134464, 714394754600058880, 714394924628750339, 709533845851283457, 707223929014779904, 712628717290446848, 711586866311655428, 707850814505787392, 707197010714214400, 711955991722594304, 706448931429949440, 661966563600273408, 713859726912667650, 707861925934268416, 707122028973789184, 712682790031134722, 709384751581433857, 709130362606243841, 706110635948576769, 706822454354841600, 710826714314776576, 1886453406, 712907038834171905, 706918068019191809, 707188517458284545, 701707305780383744, 706284313529217024, 702196187424804869, 674264875259052032, 706176058404503553, 705319448790638592, 705413304282435584, 703332812439621632, 702376697514074112, 703130666121101313, 700275566268829697, 702528659698159616, 704187716808867840, 702638177471873024, 701075709452652544, 702532064554442753, 703920337705111554, 700034735507046400, 703632580730552321, 701107064857210880, 594168269759623168, 703073905527955456, 705714902057533440, 700658628907237376, 699432086965366784, 692762579983269888, 696322801070907393, 692582723471323136, 690186496956047360, 697340677366157312, 693127227807043588, 695249588899414017, 699488343147552768, 694317112228057089, 689828062855299072, 699771104618024962, 699916802382557184, 694204062695342080, 697074456569765888, 691967507612241920, 694576614798180352, 694376457473097734, 690977566207918080, 699048721380720640, 696972335522455552, 696061453007241216, 696763607544111105, 700067710818975745, 691998550138490880, 695976199009468416, 686871865638404097, 688815159494733824, 689648647756054528, 683710508202094592, 687202758605291520, 688983202027991040, 685172296789561344, 687718605212020737, 687289217576230916, 685583172969611264, 689738306603651072, 687385380820250624, 597053118317273089, 684693149445427200, 684433879160221696, 687042863679410176, 685080553876504577, 686834677907238912, 684672630503424000, 688015103334182912, 685957808047665152, 686911775955103744, 686883367154003969, 685543669827518464, 689763957779906560, 680717584040341504, 679726607754473472, 679419672735973376, 684313206299455488, 684316443710717952, 683026600003289088, 682139290088960001, 679325657655025664, 682202141080088576, 679045081937018880, 679270671365615616, 682142154576244736, 678878257303986176, 683994611405189120, 683160596607537152, 681993393921118209, 683613067167543296, 683094377221210112, 681453225669738496, 679443075484250114, 684256590447427584, 684020629897621508, 681396579916447744, 679697947626438656, 683342914643214336, 677464977192669184, 676318922833068033, 675256104008445952, 678629627527589888, 669126254982012929, 669796737960161281, 669880378254053376, 675323125052125184, 468302135457636352, 675237109687558144, 670341487222198273, 676502909022945280, 674716743235969025, 672404713275551744, 669481784787234817, 670992535083458561, 676517138983727105, 669655571042201600, 673422661767196672, 670381439582642176, 675367125276622848, 674633403241730048, 595667665907261441, 673599658380410880, 677775874956107776, 1106679304426000384, 1137072520585187328, 1151590620063916032, 1149828392189120512, 1116751913607766017, 1113767883526541312, 1149593378050301952, 1110873979349286913, 1100612918264115201, 1149446799133990912, 1146057239238549504, 1111954741012119552, 1096064094011052032, 1151984282367385601, 1150722215572365313, 1089562364331126785, 1150092483629649922, 1151538067024601089, 1151149725871149057, 1152157457038360581, 1098758271995830273, 1151590400706207744, 1150065292409802753, 1096618004509413377, 1150850658360266752, 662337804316332032, 665469421406846980, 669121489963192320, 665868549404143616, 667872980580483072, 661692463585824768, 663870880448012288, 663317254965223424, 663471557617065984, 668774520694644736, 664215016506327040, 663432708664766468, 666361855837782016, 665796286067642368, 661947711285915648, 668135760055267328, 634480704328495105, 664215694087704576, 665795365451505664, 668486143080579072, 666106045396328448, 668545366627864576, 668910972782772224, 667092029520875520, 193396715779395584, 644762141929549824, 173505226257608707, 656776679403163648, 647842593066360832, 659841259259998209, 654578262216196098, 652108041752588289, 645184772034162689, 644899230654574592, 644515688242016256, 650021871652614144, 657303932658692096, 654284782088658944, 653185583632793600, 659176944458670080, 647369225380724736, 658323438524846080, 644575337859432448, 658630170081906688, 598406648751857664, 653814492648841217, 647152057397477376, 657079482856157184, 644905443987431424, 643399698301222912, 643353745909252096, 635014502908588032, 622493501188485120, 637225711120609280, 640124945985634304, 640968101148905472, 623104046879129600, 621358391626235904, 635517255590129665, 627019153866661888, 633568621801963520, 612883284771536898, 621244721902583808, 630685538391973888, 629982443030884352, 637719407796572160, 636776466844393472, 631599372766191617, 623091414340141056, 641338755660427264, 642584238294851584, 638035192523923456, 624240622644404224, 624880218801618944, 631469558256242689, 352842253133283328, 614919287497715712, 615977919685525504, 609053735529103361, 616126614838071296, 609053047092834305, 604203758155866112, 616535931525459968, 610331217423134720, 610719688016961536, 619430911478730752, 616641464714559488, 615924554452574208, 604234601352028160, 614429791752712192, 603565794853855232, 608920986281472000, 605713704143998976, 615979773119041536, 608381227482103808, 607660175407734784, 611807687060418560, 609053627890675712, 603093474523664384, 605870562062143493, 595868054053085184, 594085792663871488, 598697612804493312, 593719742151688192, 596036703309135872, 599540490271338496, 600576936641986561, 596825651241324544, 464045477840044032, 484984399373799424, 591922204436226048, 593825748424601600, 597814602890616832, 602746823296589824, 598049895858237440, 596919679010131968, 601359837491023872, 596059835227054080, 598940192888791040, 595617204273618944, 595310950372093953, 597673612930379776, 597767159192883200, 598231026092081152, 593140094825078784, 588101121220161537, 585794185980207104, 578908946032799744, 589785701945868288, 584356789778538496, 580695377894047744, 585521397033738240, 579190263698063360, 586003840358420480, 579231627265642496, 588272164287160320, 587875445707776000, 580786340779941888, 583923364290527232, 584357686025805824, 578688394823237632, 584459847850192897, 587410637069746176, 585415413162500096, 590534928846172160, 585127255879344130, 585796837346521089, 587643377736425472, 589898694985654272, 41587168870797312, 576919055841394689, 577616108439621632, 573151285140189184, 575685914615095297, 426006675032522753, 577956278611390464, 576861137930727424, 572896113822470146, 576419146910580737, 576432203560685568, 577044122730508288, 577479871800168448, 573426015109816320, 572161251557687297, 576722182367227904, 572537596036956160, 573236675700133888, 572854585120833538, 578242069354930176, 572790214256566274, 572731844359266304, 573115674001854464, 572859385275293700, 578241245853569024, 573284156827942914, 566918842325413888, 569772879300202496, 567801652519116800, 563249579853099008, 571675916335747072, 570689902943346688, 569797681029234688, 568763762171355136, 569618409547288576, 569602880543567872, 565545160332046336, 569603287642730497, 561115115383443456, 569603674894409729, 562969945014034433, 568568034060849153, 567991364027334656, 568002795137142786, 570345384909762560, 569603899943841792, 561307729998778368, 570227722561069059, 569602567803707393, 564745021682122752, 569782401766957057, 559348707595141121, 558317721025544193, 558560055424208898, 557791530417913857, 558061448396824579, 555463122308571138, 556854584833232896, 556719363622195200, 562905411846963200, 558246072263643137, 557792227817435137, 560351164911194112, 557242700823822336, 557577751348408320, 559425225453215745, 557154351995969536, 560414992642875392, 558312611520204800, 558946999673061376, 556740556970553344, 556740594132062209, 558556562479149056, 555796720152743938, 558039784153968640, 555357778135756801, 553845759213584386, 553109560479993856, 554374653721198592, 552865575777869824, 555042807640236032, 554909922593619968, 554304472202362881, 554417621203189760, 553187584525221888, 553483665859432448, 553189729244811266, 555118533953458177, 553404094958694400, 554909683660914688, 554533242079309826, 552807296162869248, 553633967803744258, 527250251561066497, 552941159795142657, 554855017845256192, 553552353409138689, 552931277012467712, 555150116748021764, 554274763267649536, 553185979021164545, 1009115874182205440, 1022576408994963458, 1018546720391778304, 1089186073211744257, 1009084671878021120, 1089123085855453184, 1016857384571023360, 1007742104645316610, 969813402486038529, 969837184227274752, 1015016428028809216, 971051414872055808, 1017822346084868096, 1054054704777478149, 1019816078300545025, 989579668184592384, 982595672087162887, 1019395022259662849, 1085352506169933827, 1008382007745933312, 996802175207690241, 1013781070741999617, 1056500728502587392, 1071072590658195462, 989295035303608320, 548151198164221952, 550211354129600512, 551902362877829120, 542312284690071552, 552487444269252608, 551894820600696832, 546188340534321152, 552193859506405376, 548246547386105857, 546313800920866816, 549252463472021505, 546342549116715008, 543383520245448704, 551702099286061056, 544801845609529344, 542410111923146752, 543110069953765377, 545126596655742977, 540437976103550976, 551431883440271362, 539624406843006977, 542262943778607104, 545543818645622785, 545542209559621632, 551146438168940544, 523499973686886400, 537933477090312192, 531950827779665920, 539796273843666944, 535151289727221762, 533280019507056640, 539122262813974528, 539708778665738240, 535403347323650048, 535031824763080704, 536916950023438336, 534853114155638784, 539507517181935618, 539420776265699328, 535085277023600640, 532154117310144512, 524110901776220160, 538668536525512705, 536602107835854848, 531136618695258112, 535247825786126337, 537316943175643136, 530674949976248320, 537591733253840896, 535470816935563264, 529941202318393344, 523454495486136320, 523057875690995712, 530309048496041984, 523459027683250176, 528983983485648897, 527593393883709440, 524231098008879105, 529253507757801472, 522226030493200384, 529558759514046464, 527592876914782209, 525415702380158977, 526043450958151680, 528293912474316800, 521774960604610563, 502878691740090369, 527417205559164928, 527374268720775169, 522443866092617728, 525833418064416770, 523520828605222913, 524108060877684737, 524246717978648576, 526660116905750528, 516910790449061889, 518257254014136320, 514106839995539458, 515236467363557376, 512496478120865793, 511453497821528064, 516238031410708480, 510831962253049856, 516648260400721921, 517358472715710465, 516600616181698561, 521646493221265408, 509624263960453120, 519048456552591361, 520110423836995584, 518425622583201792, 511548354158149632, 510409997520343040, 520989996850085888, 509685673734180864, 517745986903736321, 511878568788643840, 512840394376110081, 519594152388874241, 519418721530810368, 497697549613277185, 502284709687492608, 507253430386458624, 508895734083497984, 496792051556421632, 505274849997369344, 500243671376478208, 503101774417637376, 497012730449391616, 496396099943677952, 503588689474510849, 499559946636111872, 497634433852534784, 502544522715623424, 504636149420544000, 496038887345905664, 508892919953358848, 504580460090253312, 506757806540587008, 499072013622083584, 496446831359193088, 497455855856803840, 496647163259408384, 507438402590244865, 506781101634097152, 494746795839614977, 494769406841749504, 492381007832948736, 314861959373799424, 495253115760041984, 492199108623732736, 496213087868174336, 494118321110142976, 492380606228344832, 495929920829534208, 456743324498403328, 496219127632363521, 489824207455678466, 491170290983264256, 495929125388185600, 490022570414964738, 490063068375056384, 494084386212827138, 489291012024856576, 496315351794454528, 491104915293356032, 494027364297617408, 490910794994184192, 494437179754831872, 491563020112642048, 474286776274944001, 479246310110146561, 458518201060851712, 468406262871621633, 481235195597979648, 486840716640149504, 480648507721015296, 461239790705582080, 471514511451901952, 471200860920619008, 461876186688536576, 469043209185013761, 463611651636621312, 486785893349728257, 480791030544228352, 486919114070302720, 487574035409432578, 469758501393547264, 487574444370841600, 472454210756575232, 458305417437642752, 482064618215731200, 457554778072313856, 486853439830626305, 480341497842110465, 434755570600378368, 436872964034678787, 450643987016056832, 435819149973925888, 454217890221543424, 449328511548137472, 438595471528189952, 433634257152774144, 453066434277416960, 454287982527520768, 456408576295464961, 433727642395635712, 432103682621337600, 432540906307067904, 453470021780787200, 448953821083869184, 437966194277363712, 440511571778105344, 435911092959580161, 450654210929860609, 438338217742331904, 454345035203354624, 433957401851473920, 433957180618731521, 435048825762611201, 430382757030551553, 430677875818123268, 419379588699926529, 431366846432804864, 432871518947659776, 431421840259416064, 425593044939718656, 433242053586067456, 427774363413127168, 421736257228918784, 421359082764005376, 433269996609761280, 430716964030644226, 428494742192533505, 425622443253055488, 419865907067105280, 432141408623804419, 428495445954789376, 433333529921871872, 432892122434650112, 432241545858011136, 433494168090861568, 431073961900658689, 430639799695724544, 433239267070849024, 379160070006640640, 357882722670215168, 370514925397213185, 402492434053357568, 380270166158110720, 408139919128010752, 417455592316231681, 370847233203535872, 398306728263315456, 380245094634225664, 407528526191919104, 383318049194901504, 402064474481643520, 383307953375158272, 401771803917307904, 360145258413166592, 406463168953606145, 418022724930641920, 402063463683743744, 393001783754510336, 362497298871246848, 359576568101732352, 365736118609641472, 376574110731489280, 413223886093033472, 931861139763466240, 943610882155835392, 967328478130593792, 941045974088192002, 942522738668863488, 954020555593863168, 932872211114987520, 942803216126922753, 942508034122764290, 946818707606487041, 932219173404594176, 935836119924723713, 942719398279876608, 949056729580482560, 936947647495262208, 940661984185520128, 919232648068911104, 922194565272080384, 934516687117877249, 964786616509362176, 942695011161919488, 934922280676798464, 954232766668865537, 930374602521538560, 949741667451637761, 290747723970383872, 280756003476213761, 289855642188013568, 269785942326398976, 292022993478119424, 309381840618287105, 266498201803182080, 320528087118913537, 271897346483298304, 258595233284116480, 256785088501661696, 291165340388438017, 285395968097148928, 291879498775949312, 331104248597192704, 342569520587759616, 304621904961085440, 321442094411554816, 299620570268585984, 268056424725229569, 291778553190690816, 330337644821241856, 301744965514575872, 271896161055543296, 356027819555426304, 235832721744752640, 239409791619964928, 152513895175692288, 217231887666647042, 226832049892364288, 255955872965083137, 249168449610330112, 894559744366714880, 918326115810365440, 905761483090522112, 905179532541485057, 894184179554033664, 894126572327907328, 905489832625012737, 902196550155345921, 905837988189437953, 894426408700850176, 894604765765804033, 912262374756937728, 894261694360199169, 894915042977751041, 893848261030666240, 902687000544911362, 902621969232916480, 894860932979056640, 908908645110489088, 894554869704654848, 913446427728203782, 916305843007746048, 894274236025638912, 899076829855830016, 902848212498829312)]
(Background on this error at: http://sqlalche.me/e/e3q8)

unliking doesn't work

semiphemeral reports the following for all liked tweets:
Error, tweet [...] is already unliked, updating database
but the Twitter Web UI doesn't indicate any unliking and the Favorites List still shows them.

Edit: ok, I tested (by reducing the 'keep likes $x days' value), that unliking more recent tweets mostly works, but it seems like some tweets will still show up in the Twitter UI and won't be unliked...

Edit2: probably, it fails to download older likes and 'archive-import' currently doesn't support importing them...

"unretweet" doesn't effect unless "delete old tweets" is ticked

When I first run semiphemeral delete, my old likes were removed, but not my old retweets. I noticed that only my likes had been fetched, so there was no way for delete to delete anything. I had to both tick "delete old tweets" and reset since_id in the configuration file to have my retweets fetched. After doing that, I unticked "delete old tweets", and delete deleted my retweets as expected.

This is strictly a UX issue, the core functionality worked as expected.

command to add additional tweet IDs for consideration

There is no way to add tweet IDs to delete into semiphemeral other than being IDs that come back from the twitter API (which only gives the last n tweets).

I have a decade of tweets, and deletion within the API-restrictions is going to take forever, but I can post-process the zip file twitter make available, but I can't then run those tweet IDs against t semiphemeral... I'd end up reimplementing semiphemeral in my analysis script.

Could a command be added to take a list of tweet IDs/URLs on STDIN, and run them against the tests for deletion or not?

Unable to delete old tweets

Hi
I sucesfully installed semiphemeral. I configured it to delete tweets older than 90 days but nothing happened. I was able to delete some tweets by setting the limit to 10 days (but its too short) but the oldest tweets remained...

I have around 30k tweets to delete and really don't understant what I'm doing wrong.

Thanks

Not sure what I have done wrong when trying to unlike

I have got the like.js as required, it isn't the SQL error that was reported in another thread and using a shorter file doesn't seem to work either

Am I missing some files? Thanks

error:

semiphemeral 0.6
Traceback (most recent call last):
File "c:\users\antho\appdata\local\programs\python\python39\lib\runpy.py", line 197, in _run_module_as_main
return _run_code(code, main_globals, None,
File "c:\users\antho\appdata\local\programs\python\python39\lib\runpy.py", line 87, in run_code
exec(code, run_globals)
File "C:\Users\antho\AppData\Local\Programs\Python\Python39\Scripts\semiphemeral.exe_main
.py", line 7, in
File "c:\users\antho\appdata\local\programs\python\python39\lib\site-packages\click\core.py", line 829, in call
return self.main(*args, **kwargs)
File "c:\users\antho\appdata\local\programs\python\python39\lib\site-packages\click\core.py", line 782, in main
rv = self.invoke(ctx)
File "c:\users\antho\appdata\local\programs\python\python39\lib\site-packages\click\core.py", line 1259, in invoke
return process_result(sub_ctx.command.invoke(sub_ctx))
File "c:\users\antho\appdata\local\programs\python\python39\lib\site-packages\click\core.py", line 1066, in invoke
return ctx.invoke(self.callback, **ctx.params)
File "c:\users\antho\appdata\local\programs\python\python39\lib\site-packages\click\core.py", line 610, in invoke
return callback(*args, **kwargs)
File "c:\users\antho\appdata\local\programs\python\python39\lib\site-packages\semiphemeral_init
.py", line 87, in unlike
t.unlike(filename)
File "c:\users\antho\appdata\local\programs\python\python39\lib\site-packages\semiphemeral\twitter.py", line 466, in unlike
js_string = f.read()
File "c:\users\antho\appdata\local\programs\python\python39\lib\encodings\cp1252.py", line 23, in decode
return codecs.charmap_decode(input,self.errors,decoding_table)[0]
UnicodeDecodeError: 'charmap' codec can't decode byte 0x9d in position 2931: character maps to

Fetch won't retrieve older tweets

Fetch only returns tweets going back to November 2017 for me. Tried to manually enter a few different since_ids before and after that date, but makes no difference.

delete_dms is broken because Twitter archive lacks direct-message.js and file format changed

The Twitter archive I downloaded doesn't have a direct-message.js file. It does have a direct-messages.js file (notice the plural: "messages").

I tried passing such file anyway:

$ semiphemeral delete_dms --filename direct-messages.js 
semiphemeral 0.6
File should be called direct-message.js

Then I tried renaming the file:

$ semiphemeral delete_dms --filename direct-message.js
semiphemeral 0.6
File expected to start with: `window.YTD.direct_message.part0 = `

The format of the file seems to be similar, just again with the plural "messages":

$ head direct-message.js --lines=1
window.YTD.direct_messages.part0 = [ {

It seems semiphemeral is trying to work with an old format of the Twitter archive.

not enough info for creating the twitter app

You must supply Twitter API credentials here, which you can get by following this guide (basically, you need to login to https://developer.twitter.com/ and create a new "Twitter app" that only you will be using).

At the moment of creating a twitter app it's required to include a Website URL and a Callback URLs. I'm assuming the latter is something like 127.0.0.1:8080, but no clue about the Website URL, assuming this is meant to be used in a local machine.

Delete DMs not working

I downloaded my data from twitter and did the following:

image

As you can see in the image, I ran the command and get an error that should NOT happen.

Feature request: keep selected tweets even if they are unliked

First, let me thank you for this useful software. I am grateful. I would like to ask for a small feature to be implemented in the future.

"As a KeyBase user, I would like to verify myself via a Twitter tweet. I want the tweet to stay forever, even if it isn't liked by anyone."

Possibly a place in the configuration UI for listing specific IDs not to be deleted even if they match criteria for deletion?

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.