Project-Insanity

Site Tools

Trace: • outlook • lilapy
Writing /var/lib/dokuwiki/wiki.project-insanity.org/data/meta/arch-upstream.meta failed
arch-upstream

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
arch-upstream [2017/03/23 12:01] – 46.223.128.124arch-upstream [2021/10/31 10:42] (current) – external edit 127.0.0.1
Line 1: Line 1:
 +<code>https://github.com/reuben/pgdump2sql</code>
 +<code>CREATE TABLE projects (
 +    id integer NOT NULL,
 +    name character varying(200) NOT NULL,
 +    homepage character varying(200) NOT NULL,
 +    backend character varying(20),
 +    version_url character varying(200),
 +    regex character varying(200),
 +    latest_version character varying(50),
 +    logs text,
 +    updated_on timestamp,
 +    created_on timestamp,
 +    insecure boolean DEFAULT false NOT NULL,
 +    version_prefix character varying(200),
 +    ecosystem_name character varying(200)
 +);
  
 +CREATE TABLE packages (
 +    id integer NOT NULL,
 +    distro character varying(200),
 +    project_id integer,
 +    package_name character varying(200)
 +);</code>
 +
 +<code>select project_id,package_name from packages where package_name="0ad" and distro="Arch Linux";
 +select latest_version from projects where id="5830";</code>