Soar - Failed to update - www.asciinema.org

Soar - Failed to update

by mohamadsupangat 5 months ago

GNU/Linux • • fish 119 views

SQLite database error: no such column: is_installed in WITH results AS (SELECT

                    p.id,disabled,json(disabled_reason) AS disabled_reason,rank,pkg,pkg_id,pkg_name,pkg_family,pkg_type,pkg_webpage,app_id,description,version,version_upstream,json(licenses) AS licenses,download_url,size,ghcr_pkg,ghcr_size,json(ghcr_files) AS ghcr_files,ghcr_blob,ghcr_url,bsum,shasum,icon,desktop,appstream,json(homepages) AS homepages,json(notes) AS notes,json(source_urls) AS source_urls,json(tags) AS tags,json(categories) AS categories,build_id,build_date,build_action,build_script,build_log,json(provides) AS provides,json(snapshots) AS snapshots,json(repology) AS repology,json(replaces) AS replaces,download_count,download_count_week,download_count_month,bundle,bundle_type,soar_syms,deprecated,desktop_integration,external,installable,portable,trusted,version_latest,version_outdated, r.name AS repo_name,
                    json_group_array(
                        json_object(
                            'name', m.name,
                            'contact', m.contact
                        )
                    ) FILTER (WHERE m.id IS NOT NULL) as maintainers
                 FROM
                     main.packages p
                     JOIN main.repository r
                     LEFT JOIN main.package_maintainers pm ON p.id = pm.package_id
                     LEFT JOIN main.maintainers m ON m.id = pm.maintainer_id
                 WHERE pkg_name = ? AND is_installed = ? AND repo_name = ? AND version > ? AND (version > 'nightly' OR version LIKE 'HEAD-%' AND substr(version, 14) > '') GROUP BY p.id, repo_name

UNION ALL SELECT

                    p.id,disabled,json(disabled_reason) AS disabled_reason,rank,pkg,pkg_id,pkg_name,pkg_family,pkg_type,pkg_webpage,app_id,description,version,version_upstream,json(licenses) AS licenses,download_url,size,ghcr_pkg,ghcr_size,json(ghcr_files) AS ghcr_files,ghcr_blob,ghcr_url,bsum,shasum,icon,desktop,appstream,json(homepages) AS homepages,json(notes) AS notes,json(source_urls) AS source_urls,json(tags) AS tags,json(categories) AS categories,build_id,build_date,build_action,build_script,build_log,json(provides) AS provides,json(snapshots) AS snapshots,json(repology) AS repology,json(replaces) AS replaces,download_count,download_count_week,download_count_month,bundle,bundle_type,soar_syms,deprecated,desktop_integration,external,installable,portable,trusted,version_latest,version_outdated, r.name AS repo_name,
                    json_group_array(
                        json_object(
                            'name', m.name,
                            'contact', m.contact
                        )
                    ) FILTER (WHERE m.id IS NOT NULL) as maintainers
                 FROM
                     shard1.packages p
                     JOIN shard1.repository r
                     LEFT JOIN shard1.package_maintainers pm ON p.id = pm.package_id
                     LEFT JOIN shard1.maintainers m ON m.id = pm.maintainer_id
                 WHERE pkg_name = ? AND is_installed = ? AND repo_name = ? AND version > ? AND (version > 'nightly' OR version LIKE 'HEAD-%' AND substr(version, 14) > '') GROUP BY p.id, repo_name

UNION ALL SELECT

                    p.id,disabled,json(disabled_reason) AS disabled_reason,rank,pkg,pkg_id,pkg_name,pkg_family,pkg_type,pkg_webpage,app_id,description,version,version_upstream,json(licenses) AS licenses,download_url,size,ghcr_pkg,ghcr_size,json(ghcr_files) AS ghcr_files,ghcr_blob,ghcr_url,bsum,shasum,icon,desktop,appstream,json(homepages) AS homepages,json(notes) AS notes,json(source_urls) AS source_urls,json(tags) AS tags,json(categories) AS categories,build_id,build_date,build_action,build_script,build_log,json(provides) AS provides,json(snapshots) AS snapshots,json(repology) AS repology,json(replaces) AS replaces,download_count,download_count_week,download_count_month,bundle,bundle_type,soar_syms,deprecated,desktop_integration,external,installable,portable,trusted,version_latest,version_outdated, r.name AS repo_name,
                    json_group_array(
                        json_object(
                            'name', m.name,
                            'contact', m.contact
                        )
                    ) FILTER (WHERE m.id IS NOT NULL) as maintainers
                 FROM
                     shard2.packages p
                     JOIN shard2.repository r
                     LEFT JOIN shard2.package_maintainers pm ON p.id = pm.package_id
                     LEFT JOIN shard2.maintainers m ON m.id = pm.maintainer_id
                 WHERE pkg_name = ? AND is_installed = ? AND repo_name = ? AND version > ? AND (version > 'nightly' OR version LIKE 'HEAD-%' AND substr(version, 14) > '') GROUP BY p.id, repo_name

UNION ALL SELECT

                    p.id,disabled,json(disabled_reason) AS disabled_reason,rank,pkg,pkg_id,pkg_name,pkg_family,pkg_type,pkg_webpage,app_id,description,version,version_upstream,json(licenses) AS licenses,download_url,size,ghcr_pkg,ghcr_size,json(ghcr_files) AS ghcr_files,ghcr_blob,ghcr_url,bsum,shasum,icon,desktop,appstream,json(homepages) AS homepages,json(notes) AS notes,json(source_urls) AS source_urls,json(tags) AS tags,json(categories) AS categories,build_id,build_date,build_action,build_script,build_log,json(provides) AS provides,json(snapshots) AS snapshots,json(repology) AS repology,json(replaces) AS replaces,download_count,download_count_week,download_count_month,bundle,bundle_type,soar_syms,deprecated,desktop_integration,external,installable,portable,trusted,version_latest,version_outdated, r.name AS repo_name,
                    json_group_array(
                        json_object(
                            'name', m.name,
                            'contact', m.contact
                        )
                    ) FILTER (WHERE m.id IS NOT NULL) as maintainers
                 FROM
                     shard3.packages p
                     JOIN shard3.repository r
                     LEFT JOIN shard3.package_maintainers pm ON p.id = pm.package_id
                     LEFT JOIN shard3.maintainers m ON m.id = pm.maintainer_id
                 WHERE pkg_name = ? AND is_installed = ? AND repo_name = ? AND version > ? AND (version > 'nightly' OR version LIKE 'HEAD-%' AND substr(version, 14) > '') GROUP BY p.id, repo_name

UNION ALL SELECT

                    p.id,disabled,json(disabled_reason) AS disabled_reason,rank,pkg,pkg_id,pkg_name,pkg_family,pkg_type,pkg_webpage,app_id,description,version,version_upstream,json(licenses) AS licenses,download_url,size,ghcr_pkg,ghcr_size,json(ghcr_files) AS ghcr_files,ghcr_blob,ghcr_url,bsum,shasum,icon,desktop,appstream,json(homepages) AS homepages,json(notes) AS notes,json(source_urls) AS source_urls,json(tags) AS tags,json(categories) AS categories,build_id,build_date,build_action,build_script,build_log,json(provides) AS provides,json(snapshots) AS snapshots,json(repology) AS repology,json(replaces) AS replaces,download_count,download_count_week,download_count_month,bundle,bundle_type,soar_syms,deprecated,desktop_integration,external,installable,portable,trusted,version_latest,version_outdated, r.name AS repo_name,
                    json_group_array(
                        json_object(
                            'name', m.name,
                            'contact', m.contact
                        )
                    ) FILTER (WHERE m.id IS NOT NULL) as maintainers
                 FROM
                     shard4.packages p
                     JOIN shard4.repository r
                     LEFT JOIN shard4.package_maintainers pm ON p.id = pm.package_id
                     LEFT JOIN shard4.maintainers m ON m.id = pm.maintainer_id
                 WHERE pkg_name = ? AND is_installed = ? AND repo_name = ? AND version > ? AND (version > 'nightly' OR version LIKE 'HEAD-%' AND substr(version, 14) > '') GROUP BY p.id, repo_name) SELECT * FROM results LIMIT ? OFFSET ? at offset 7998

https://asciinema.org/a/734836

Copied!

Append ?t=30 to start the playback at 30s, ?t=3:20 to start the playback at 3m 20s.

See sharing docs for more link customization options.

Embed as image link

Use snippets below to display a preview image linking to this recording.
Ideal for places where scripts are not allowed, such as project README files.

HTML:

<a href="https://asciinema.org/a/734836" target="_blank"><img src="https://asciinema.org/a/734836.svg" /></a>

Copied!

Markdown:

[![asciicast](https://asciinema.org/a/734836.svg)](https://asciinema.org/a/734836)

Copied!

Embed the player

If you're embedding on your own page or on a site which permits script tags, you can use the full player widget:

<script src="https://asciinema.org/a/734836.js" id="asciicast-734836" async="true"></script>

Copied!

Paste the above script tag where you want the player to be displayed on your page.

See embedding docs for more player customization options.

You can download this recording in asciicast v3 format, as a .cast file.

Download

Replay in terminal

You can replay the downloaded recording in your terminal using the asciinema play command:

asciinema play 734836.cast

Copied!

If you don't have asciinema CLI installed then see installation instructions.

Use with stand-alone player on your website

Download asciinema player from the releases page (you only need .js and .css file), then use it like this:

<!DOCTYPE html>
<html>
<head>
  <link rel="stylesheet" type="text/css" href="/assets/asciinema-player.css" />
</head>
<body>
  <div id="player"></div>
  <script src="/assets/asciinema-player.min.js"></script>
  <script>
    AsciinemaPlayer.create(
      '/assets/734836.cast',
      document.getElementById('player'),
      { cols: 84, rows: 40 }
    );
  </script>
</body>
</html>

See asciinema player quick-start guide for full usage instructions.

While this site doesn't provide GIF conversion at the moment, you can still do it yourself with the help of asciinema GIF generator utility - agg.

Once you have it installed, generate a GIF with the following command:

agg https://asciinema.org/a/734836 demo.gif

Copied!

Or, if you already downloaded the recording file:

agg demo.cast demo.gif

Copied!

Check agg --help for all available options. You can change font family and size, select color theme, adjust speed and more.

See agg manual for full usage instructions.