workflows

Table actions

11 rows where name = "Test"

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: on, on (array)

id ▼ filename name on repo env permissions
20957 test.yml Test 
[
    "push",
    "pull_request"
]
 apple-notes-to-sqlite 611552758   
{
    "contents": "read"
}
20959 test.yml Test 
[
    "push"
]
 dogsheep-beta 197431109    
20962 test.yml Test 
[
    "push"
]
 evernote-to-sqlite 303218369    
20966 test.yml Test 
[
    "push"
]
 github-to-sqlite 207052882    
20968 test.yml Test 
[
    "push"
]
 hacker-news-to-sqlite 248903544    
20970 test.yml Test 
[
    "push"
]
 healthkit-to-sqlite 197882382    
20972 test.yml Test 
[
    "push",
    "pull_request"
]
 pocket-to-sqlite 213286752   
{
    "contents": "read"
}
20974 test.yml Test 
[
    "push"
]
 swarm-to-sqlite 205429375    
20977 test.yml Test 
[
    "push"
]
 twitter-to-sqlite 206156866    
20987 test.yml Test 
[
    "push",
    "pull_request"
]
 datasette 107914493   
{
    "contents": "read"
}
20995 test.yml Test 
[
    "push",
    "pull_request"
]
 sqlite-utils 140912432 
{
    "FORCE_COLOR": 1
}
  

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE [workflows] (
   [id] INTEGER PRIMARY KEY,
   [filename] TEXT,
   [name] TEXT,
   [on] TEXT,
   [repo] INTEGER REFERENCES [repos]([id])
, [env] TEXT, [permissions] TEXT);
CREATE INDEX [idx_workflows_repo]
    ON [workflows] ([repo]);
CREATE UNIQUE INDEX [idx_workflows_repo_filename]
    ON [workflows] ([repo], [filename]);