issue_comments: 859895540

This data as json

html_url issue_url id node_id user created_at updated_at author_association body reactions issue performed_via_github_app
https://github.com/simonw/sqlite-utils/issues/268#issuecomment-859895540 https://api.github.com/repos/simonw/sqlite-utils/issues/268 859895540 MDEyOklzc3VlQ29tbWVudDg1OTg5NTU0MA== 9599 2021-06-11T20:30:34Z 2021-06-11T20:30:34Z OWNER

You can currently see the sql on the CLI using:

% sqlite-utils rows fixtures.db sqlite_master -c name -c sql
name                                                            sql
--------------------------------------------------------------  ----------------------------------------------------------------------------------------------------------------------------------------------------------------
simple_primary_key                                              CREATE TABLE simple_primary_key (
                                                                  id varchar(30) primary key,
                                                                  content text
                                                                )
sqlite_autoindex_simple_primary_key_1
primary_key_multiple_columns                                    CREATE TABLE primary_key_multiple_columns (
                                                                  id varchar(30) primary key,
                                                                  content text,
                                                                  content2 text
                                                                )
sqlite_autoindex_primary_key_multiple_columns_1
primary_key_multiple_columns_explicit_label                     CREATE TABLE primary_key_multiple_columns_explicit_label (
                                                                  id varchar(30) primary key,
                                                                  content text,
                                                                  content2 text
                                                                )
sqlite_autoindex_primary_key_multiple_columns_explicit_label_1
compound_primary_key                                            CREATE TABLE compound_primary_key (
                                                                  pk1 varchar(30),
                                                                  pk2 varchar(30),
                                                                  content text,
                                                                  PRIMARY KEY (pk1, pk2)
                                                                )
sqlite_autoindex_compound_primary_key_1
compound_three_primary_keys                                     CREATE TABLE compound_three_primary_keys (
                                                                  pk1 varchar(30),
                                                                  pk2 varchar(30),
                                                                  pk3 varchar(30),
                                                                  content text,
                                                                  PRIMARY KEY (pk1, pk2, pk3)
                                                                )
sqlite_autoindex_compound_three_primary_keys_1
foreign_key_references                                          CREATE TABLE foreign_key_references (
                                                                  pk varchar(30) primary key,
                                                                  foreign_key_with_label varchar(30),
                                                                  foreign_key_with_no_label varchar(30),
                                                                  FOREIGN KEY (foreign_key_with_label) REFERENCES simple_primary_key(id),
                                                                  FOREIGN KEY (foreign_key_with_no_label) REFERENCES primary_key_multiple_columns(id)
                                                                )
sqlite_autoindex_foreign_key_references_1
sortable                                                        CREATE TABLE sortable (
                                                                  pk1 varchar(30),
                                                                  pk2 varchar(30),
                                                                  content text,
                                                                  sortable integer,
                                                                  sortable_with_nulls real,
                                                                  sortable_with_nulls_2 real,
                                                                  text text,
                                                                  PRIMARY KEY (pk1, pk2)
                                                                )
sqlite_autoindex_sortable_1
no_primary_key                                                  CREATE TABLE no_primary_key (
                                                                  content text,
                                                                  a text,
                                                                  b text,
                                                                  c text
                                                                )
123_starts_with_digits                                          CREATE TABLE [123_starts_with_digits] (
                                                                  content text
                                                                )
paginated_view                                                  CREATE VIEW paginated_view AS
                                                                    SELECT
                                                                        content,
                                                                        '- ' || content || ' -' AS content_extra
                                                                    FROM no_primary_key
Table With Space In Name                                        CREATE TABLE "Table With Space In Name" (
                                                                  pk varchar(30) primary key,
                                                                  content text
                                                                )
sqlite_autoindex_Table With Space In Name_1
table/with/slashes.csv                                          CREATE TABLE "table/with/slashes.csv" (
                                                                  pk varchar(30) primary key,
                                                                  content text
                                                                )
sqlite_autoindex_table/with/slashes.csv_1
complex_foreign_keys                                            CREATE TABLE "complex_foreign_keys" (
                                                                  pk varchar(30) primary key,
                                                                  f1 text,
                                                                  f2 text,
                                                                  f3 text,
                                                                  FOREIGN KEY ("f1") REFERENCES [simple_primary_key](id),
                                                                  FOREIGN KEY ("f2") REFERENCES [simple_primary_key](id),
                                                                  FOREIGN KEY ("f3") REFERENCES [simple_primary_key](id)
                                                                )
sqlite_autoindex_complex_foreign_keys_1
custom_foreign_key_label                                        CREATE TABLE "custom_foreign_key_label" (
                                                                  pk varchar(30) primary key,
                                                                  foreign_key_with_custom_label text,
                                                                  FOREIGN KEY ("foreign_key_with_custom_label") REFERENCES [primary_key_multiple_columns_explicit_label](id)
                                                                )
sqlite_autoindex_custom_foreign_key_label_1
units                                                           CREATE TABLE units (
                                                                  pk integer primary key,
                                                                  distance int,
                                                                  frequency int
                                                                )
searchable                                                      CREATE TABLE searchable (
                                                                  pk integer primary key,
                                                                  text1 text,
                                                                  text2 text,
                                                                  [name with . and spaces] text
                                                                )
searchable_fts                                                  CREATE VIRTUAL TABLE "searchable_fts"
                                                                    USING FTS3 (text1, text2, [name with . and spaces], content="searchable")
searchable_fts_content                                          CREATE TABLE 'searchable_fts_content'(docid INTEGER PRIMARY KEY, 'c0text1', 'c1text2', 'c2name with . and spaces', 'c3content')
searchable_fts_segments                                         CREATE TABLE 'searchable_fts_segments'(blockid INTEGER PRIMARY KEY, block BLOB)
searchable_fts_segdir                                           CREATE TABLE 'searchable_fts_segdir'(level INTEGER,idx INTEGER,start_block INTEGER,leaves_end_block INTEGER,end_block INTEGER,root BLOB,PRIMARY KEY(level, idx))
sqlite_autoindex_searchable_fts_segdir_1
select                                                          CREATE TABLE [select] (
                                                                  [group] text,
                                                                  [having] text,
                                                                  [and] text
                                                                )
facet_cities                                                    CREATE TABLE facet_cities (
                                                                    id integer primary key,
                                                                    name text
                                                                )
simple_view                                                     CREATE VIEW simple_view AS
                                                                    SELECT content, upper(content) AS upper_content FROM simple_primary_key

{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
 919181559