2020-05-03 03:01:21 +00:00
<!DOCTYPE html>
< html >
< head >
< title > Datasette: Pattern Portfolio< / title >
< link rel = "stylesheet" href = "{{ base_url }}-/static/app.css?{{ app_css_hash }}" >
< meta name = "viewport" content = "width=device-width, initial-scale=1, shrink-to-fit=no" >
< meta name = "robots" content = "noindex" >
2020-08-27 21:59:34 +00:00
< style > < / style >
2020-05-03 03:01:21 +00:00
< / head >
< body >
2020-08-27 21:59:34 +00:00
2020-11-01 17:22:13 +00:00
< header > < nav >
< p class = "crumbs" >
< a href = "/" > home< / a >
< / p >
2022-11-13 21:06:58 +00:00
< details class = "nav-menu details-menu" >
2020-11-01 17:22:13 +00:00
< summary > < svg aria-labelledby = "nav-menu-svg-title" role = "img"
fill="currentColor" stroke="currentColor" xmlns="http://www.w3.org/2000/svg"
viewBox="0 0 16 16" width="16" height="16">
< title id = "nav-menu-svg-title" > Menu< / title >
< path fill-rule = "evenodd" d = "M1 2.75A.75.75 0 011.75 2h12.5a.75.75 0 110 1.5H1.75A.75.75 0 011 2.75zm0 5A.75.75 0 011.75 7h12.5a.75.75 0 110 1.5H1.75A.75.75 0 011 7.75zM1.75 12a.75.75 0 100 1.5h12.5a.75.75 0 100-1.5H1.75z" > < / path >
< / svg > < / summary >
< div class = "nav-menu-inner" >
< ul >
< li > < a href = "/-/databases" > Databases< / a > < / li >
< li > < a href = "/-/plugins" > Installed plugins< / a > < / li >
< li > < a href = "/-/versions" > Version info< / a > < / li >
< / ul >
< form action = "/-/logout" method = "post" >
< button class = "button-as-link" > Log out< / button >
< / form >
< / div >
< / details >
< div class = "actor" >
< strong > root< / strong >
< / div >
< / nav > < / header >
2020-08-27 21:59:34 +00:00
< section class = "content" >
2020-05-03 03:01:21 +00:00
< h1 > Pattern Portfolio< / h1 >
2020-08-27 21:59:34 +00:00
< / section >
< h2 class = "pattern-heading" > Header for /database/table/row and Messages< / h2 >
< header >
< nav >
< p class = "crumbs" >
< a href = "/" > home< / a > /
< a href = "/fixtures" > fixtures< / a > /
< a href = "/fixtures/attraction_characteristic" > attraction_characteristic< / a >
< / p >
2020-10-30 20:12:01 +00:00
< div class = "actor" >
< strong > testuser< / strong >
2020-08-27 21:59:34 +00:00
< / div >
< / nav >
< / header >
< p class = "message-info" > Example message< / p >
< p class = "message-warning" > Example message< / p >
< p class = "message-error" > Example message< / p >
2020-05-03 03:01:21 +00:00
< h2 class = "pattern-heading" > .bd for /< / h2 >
2020-08-27 21:59:34 +00:00
< section class = "content" >
2020-05-03 03:01:21 +00:00
< h1 > Datasette Fixtures< / h1 >
< div class = "metadata-description" >
An example SQLite database demonstrating Datasette
< / div >
< p >
Data license:
2021-03-23 16:19:41 +00:00
< a href = "https://github.com/simonw/datasette/blob/main/LICENSE" > Apache License 2.0< / a >
2020-05-03 03:01:21 +00:00
·
Data source:
2021-03-23 16:19:41 +00:00
< a href = "https://github.com/simonw/datasette/blob/main/tests/fixtures.py" >
2020-05-03 03:01:21 +00:00
tests/fixtures.py< / a >
·
About:
< a href = "https://github.com/simonw/datasette" >
About Datasette< / a >
< / p >
< h2 style = "padding-left: 10px; border-left: 10px solid #9403e5" > < a href = "/fixtures" > fixtures< / a > < / h2 >
< p >
1,258 rows in 24 tables, 206 rows in 5 hidden tables, 4 views
< / p >
< p > < a href = "/fixtures/compound_three_primary_keys" title = "1001 rows" > compound_three_primary_keys< / a > , < a href = "/fixtures/sortable" title = "201 rows" > sortable< / a > , < a href = "/fixtures/facetable" title = "15 rows" > facetable< / a > , < a href = "/fixtures/roadside_attraction_characteristics" title = "5 rows" > roadside_attraction_characteristics< / a > , < a href = "/fixtures/simple_primary_key" title = "4 rows" > simple_primary_key< / a > , < a href = "/fixtures" > ...< / a > < / p >
< h2 style = "padding-left: 10px; border-left: 10px solid #8d777f" > < a href = "/data" > data< / a > < / h2 >
< p >
6 rows in 2 tables
< / p >
< p > < a href = "/data/names" title = "6 rows" > names< / a > , < a href = "/data/foo" > foo< / a > < / p >
2020-08-27 21:59:34 +00:00
< / section >
2020-05-03 03:01:21 +00:00
< h2 class = "pattern-heading" > .bd for /database< / h2 >
2020-08-27 21:59:34 +00:00
< section class = "content" >
2020-11-02 18:53:52 +00:00
< div class = "page-header" style = "border-color: #ff0000" >
< h1 > fixtures< / h1 >
2022-11-13 21:06:58 +00:00
< details class = "actions-menu-links details-menu" >
2020-11-02 18:53:52 +00:00
< summary > < svg aria-labelledby = "actions-menu-links-title" role = "img"
style="color: #666" xmlns="http://www.w3.org/2000/svg"
width="28" height="28" viewBox="0 0 24 24" fill="none"
stroke="currentColor" stroke-width="2" stroke-linecap="round" stroke-linejoin="round">
< title id = "actions-menu-links-title" > Table actions< / title >
< circle cx = "12" cy = "12" r = "3" > < / circle >
< path d = "M19.4 15a1.65 1.65 0 0 0 .33 1.82l.06.06a2 2 0 0 1 0 2.83 2 2 0 0 1-2.83 0l-.06-.06a1.65 1.65 0 0 0-1.82-.33 1.65 1.65 0 0 0-1 1.51V21a2 2 0 0 1-2 2 2 2 0 0 1-2-2v-.09A1.65 1.65 0 0 0 9 19.4a1.65 1.65 0 0 0-1.82.33l-.06.06a2 2 0 0 1-2.83 0 2 2 0 0 1 0-2.83l.06-.06a1.65 1.65 0 0 0 .33-1.82 1.65 1.65 0 0 0-1.51-1H3a2 2 0 0 1-2-2 2 2 0 0 1 2-2h.09A1.65 1.65 0 0 0 4.6 9a1.65 1.65 0 0 0-.33-1.82l-.06-.06a2 2 0 0 1 0-2.83 2 2 0 0 1 2.83 0l.06.06a1.65 1.65 0 0 0 1.82.33H9a1.65 1.65 0 0 0 1-1.51V3a2 2 0 0 1 2-2 2 2 0 0 1 2 2v.09a1.65 1.65 0 0 0 1 1.51 1.65 1.65 0 0 0 1.82-.33l.06-.06a2 2 0 0 1 2.83 0 2 2 0 0 1 0 2.83l-.06.06a1.65 1.65 0 0 0-.33 1.82V9a1.65 1.65 0 0 0 1.51 1H21a2 2 0 0 1 2 2 2 2 0 0 1-2 2h-.09a1.65 1.65 0 0 0-1.51 1z" > < / path >
< / svg > < / summary >
< div class = "dropdown-menu" >
< ul >
< li > < a href = "#" > Database action< / a > < / li >
< / ul >
< / div >
< / details >
< / div >
2020-05-03 03:01:21 +00:00
< div class = "metadata-description" >
Test tables description
< / div >
< p >
Data license:
2021-03-23 16:19:41 +00:00
< a href = "https://github.com/simonw/datasette/blob/main/LICENSE" > Apache License 2.0< / a >
2020-05-03 03:01:21 +00:00
·
Data source:
2021-03-23 16:19:41 +00:00
< a href = "https://github.com/simonw/datasette/blob/main/tests/fixtures.py" >
2020-05-03 03:01:21 +00:00
tests/fixtures.py< / a >
·
About:
< a href = "https://github.com/simonw/datasette" >
About Datasette< / a >
< / p >
< form class = "sql" action = "/fixtures" method = "get" >
< h3 > Custom SQL query< / h3 >
< p > < textarea id = "sql-editor" name = "sql" > select * from [123_starts_with_digits]< / textarea > < / p >
< p >
< button id = "sql-format" type = "button" hidden > Format SQL< / button >
< input type = "submit" value = "Run SQL" >
< / p >
< / form >
< div class = "db-table" >
< h2 > < a href = "/fixtures/123_starts_with_digits" > 123_starts_with_digits< / a > < / h2 >
< p > < em > content< / em > < / p >
< p > 0 rows< / p >
< / div >
< div class = "db-table" >
< h2 > < a href = "/fixtures/Table+With+Space+In+Name" > Table With Space In Name< / a > < / h2 >
< p > < em > pk, content< / em > < / p >
< p > 0 rows< / p >
< / div >
< div class = "db-table" >
< h2 > < a href = "/fixtures/attraction_characteristic" > attraction_characteristic< / a > < / h2 >
< p > < em > pk, name< / em > < / p >
< p > 2 rows< / p >
< / div >
2020-08-27 21:59:34 +00:00
< / section >
2020-05-03 03:01:21 +00:00
< h2 class = "pattern-heading" > .bd for /database/table< / h2 >
2020-11-02 18:53:52 +00:00
2020-08-27 21:59:34 +00:00
< section class = "content" >
2020-11-02 18:53:52 +00:00
< div class = "page-header" style = "border-color: #ff0000" >
< h1 > roadside_attraction_characteristics< / h1 >
2022-11-13 21:06:58 +00:00
< details class = "actions-menu-links details-menu" >
2020-11-02 18:53:52 +00:00
< summary > < svg aria-labelledby = "actions-menu-links-title" role = "img"
style="color: #666" xmlns="http://www.w3.org/2000/svg"
width="28" height="28" viewBox="0 0 24 24" fill="none"
stroke="currentColor" stroke-width="2" stroke-linecap="round" stroke-linejoin="round">
< title id = "actions-menu-links-title" > Table actions< / title >
< circle cx = "12" cy = "12" r = "3" > < / circle >
< path d = "M19.4 15a1.65 1.65 0 0 0 .33 1.82l.06.06a2 2 0 0 1 0 2.83 2 2 0 0 1-2.83 0l-.06-.06a1.65 1.65 0 0 0-1.82-.33 1.65 1.65 0 0 0-1 1.51V21a2 2 0 0 1-2 2 2 2 0 0 1-2-2v-.09A1.65 1.65 0 0 0 9 19.4a1.65 1.65 0 0 0-1.82.33l-.06.06a2 2 0 0 1-2.83 0 2 2 0 0 1 0-2.83l.06-.06a1.65 1.65 0 0 0 .33-1.82 1.65 1.65 0 0 0-1.51-1H3a2 2 0 0 1-2-2 2 2 0 0 1 2-2h.09A1.65 1.65 0 0 0 4.6 9a1.65 1.65 0 0 0-.33-1.82l-.06-.06a2 2 0 0 1 0-2.83 2 2 0 0 1 2.83 0l.06.06a1.65 1.65 0 0 0 1.82.33H9a1.65 1.65 0 0 0 1-1.51V3a2 2 0 0 1 2-2 2 2 0 0 1 2 2v.09a1.65 1.65 0 0 0 1 1.51 1.65 1.65 0 0 0 1.82-.33l.06-.06a2 2 0 0 1 2.83 0 2 2 0 0 1 0 2.83l-.06.06a1.65 1.65 0 0 0-.33 1.82V9a1.65 1.65 0 0 0 1.51 1H21a2 2 0 0 1 2 2 2 2 0 0 1-2 2h-.09a1.65 1.65 0 0 0-1.51 1z" > < / path >
< / svg > < / summary >
< div class = "dropdown-menu" >
< ul >
< li > < a href = "#" > Table action< / a > < / li >
< / ul >
< / div >
< / details >
< / div >
2020-05-03 03:01:21 +00:00
< p >
Data license:
2021-03-23 16:19:41 +00:00
< a href = "https://github.com/simonw/datasette/blob/main/LICENSE" > Apache License 2.0< / a >
2020-05-03 03:01:21 +00:00
·
Data source:
2021-03-23 16:19:41 +00:00
< a href = "https://github.com/simonw/datasette/blob/main/tests/fixtures.py" >
2020-05-03 03:01:21 +00:00
tests/fixtures.py< / a >
·
About:
< a href = "https://github.com/simonw/datasette" >
About Datasette< / a >
< / p >
< h3 > 3 rows
where characteristic_id = 2
< / h3 >
< form class = "filters" action = "/fixtures/roadside_attraction_characteristics" method = "get" >
< div class = "search-row" > < label for = "_search" > Search:< / label > < input id = "_search" type = "search" name = "_search" value = "" > < / div >
< div class = "filter-row" >
< div class = "select-wrapper" >
< select name = "_filter_column_1" >
< option value = "" > - remove filter -< / option >
< option > rowid< / option >
< option > attraction_id< / option >
< option selected > characteristic_id< / option >
< / select >
< / div >
< div class = "select-wrapper filter-op" >
< select name = "_filter_op_1" >
< option value = "exact" selected > =< / option >
< option value = "not" > !=< / option >
< option value = "contains" > contains< / option >
< option value = "endswith" > ends with< / option >
< option value = "startswith" > starts with< / option >
< option value = "gt" > > < / option >
< option value = "gte" > ≥< / option >
< option value = "lt" > < < / option >
< option value = "lte" > ≤< / option >
< option value = "like" > like< / option >
< option value = "notlike" > not like< / option >
< option value = "glob" > glob< / option >
< option value = "in" > in< / option >
< option value = "notin" > not in< / option >
< option value = "arraycontains" > array contains< / option >
< option value = "date" > date< / option >
< option value = "isnull__1" > is null< / option >
< option value = "notnull__1" > is not null< / option >
< option value = "isblank__1" > is blank< / option >
< option value = "notblank__1" > is not blank< / option >
< / select >
< / div > < input type = "text" name = "_filter_value_1" class = "filter-value" value = "2" >
< / div >
< div class = "filter-row" >
< div class = "select-wrapper" >
< select name = "_filter_column" >
< option value = "" > - column -< / option >
< option > rowid< / option >
< option > attraction_id< / option >
< option > characteristic_id< / option >
< / select >
< / div >
< div class = "select-wrapper filter-op" >
< select name = "_filter_op" >
< option value = "exact" > =< / option >
< option value = "not" > !=< / option >
< option value = "contains" > contains< / option >
< option value = "endswith" > ends with< / option >
< option value = "startswith" > starts with< / option >
< option value = "gt" > > < / option >
< option value = "gte" > ≥< / option >
< option value = "lt" > < < / option >
< option value = "lte" > ≤< / option >
< option value = "like" > like< / option >
< option value = "notlike" > not like< / option >
< option value = "glob" > glob< / option >
< option value = "in" > in< / option >
< option value = "notin" > not in< / option >
< option value = "arraycontains" > array contains< / option >
< option value = "date" > date< / option >
< option value = "isnull__1" > is null< / option >
< option value = "notnull__1" > is not null< / option >
< option value = "isblank__1" > is blank< / option >
< option value = "notblank__1" > is not blank< / option >
< / select >
< / div > < input type = "text" name = "_filter_value" class = "filter-value" >
< / div >
< div class = "filter-row" >
< div class = "select-wrapper small-screen-only" >
< select name = "_sort" id = "sort_by" >
< option value = "" > Sort...< / option >
< option value = "rowid" selected > Sort by rowid< / option >
< option value = "attraction_id" > Sort by attraction_id< / option >
< option value = "characteristic_id" > Sort by characteristic_id< / option >
< / select >
< / div >
< label class = "sort_by_desc small-screen-only" > < input type = "checkbox" name = "_sort_by_desc" > descending< / label >
< input type = "submit" value = "Apply" >
< / div >
2020-08-27 21:59:34 +00:00
< / form >
< div class = "extra-wheres" >
< h3 > 2 extra where clauses< / h3 >
< ul >
< li > < code > planet_int=1< / code > [< a href = "/fixtures/facetable?_where=state%3D%27CA%27" > remove< / a > ]< / li >
< li > < code > state='CA'< / code > [< a href = "/fixtures/facetable?_where=planet_int%3D1" > remove< / a > ]< / li >
< / ul >
< / div >
< p > < a class = "not-underlined" title = "select rowid, attraction_id, characteristic_id from roadside_attraction_characteristics where "characteristic_id" = :p0 order by rowid limit 101" href = "/fixtures?sql=select+rowid%2C+attraction_id%2C+characteristic_id+from+roadside_attraction_characteristics+where+%22characteristic_id%22+%3D+%3Ap0+order+by+rowid+limit+101&p0=2" > ✎ < span class = "underlined" > View and edit SQL< / span > < / a > < / p >
< p class = "export-links" > This data as < a href = "/fixtures/roadside_attraction_characteristics.json?characteristic_id=2&_labels=on" > json< / a > , < a href = "/fixtures/roadside_attraction_characteristics.csv?characteristic_id=2&_labels=on&_size=max" > CSV< / a > (< a href = "#export" > advanced< / a > )< / p >
< p class = "suggested-facets" >
Suggested facets: < a href = "http://latest.datasette.io/fixtures/facetable?_where=planet_int%3D1&_where=state%3D%27CA%27&_facet=city_id&_facet=created&_facet=complex_array&_facet=tags#facet-tags" > tags< / a > , < a href = "http://latest.datasette.io/fixtures/facetable?_where=planet_int%3D1&_where=state%3D%27CA%27&_facet=city_id&_facet=created&_facet=complex_array&_facet_date=created#facet-created" > created< / a > (date), < a href = "http://latest.datasette.io/fixtures/facetable?_where=planet_int%3D1&_where=state%3D%27CA%27&_facet=city_id&_facet=created&_facet=complex_array&_facet_array=tags#facet-tags" > tags< / a > (array)
< / p >
< div class = "facet-results" >
< div class = "facet-info facet-fixtures-facetable-tags" id = "facet-tags" >
< p class = "facet-info-name" >
< strong > tags (array)< / strong >
< a href = "/fixtures/facetable?_where=planet_int%3D1&_where=state%3D%27CA%27&_facet=city_id&_facet=created" class = "cross" > ✖< / a >
< / p >
< ul >
< li > < a href = "http://latest.datasette.io/fixtures/facetable?_where=planet_int%3D1&_where=state%3D%27CA%27&_facet=city_id&_facet=created&_facet_array=tags&tags__arraycontains=tag1" > tag1< / a > 2< / li >
< li > < a href = "http://latest.datasette.io/fixtures/facetable?_where=planet_int%3D1&_where=state%3D%27CA%27&_facet=city_id&_facet=created&_facet_array=tags&tags__arraycontains=tag2" > tag2< / a > 1< / li >
< li > < a href = "http://latest.datasette.io/fixtures/facetable?_where=planet_int%3D1&_where=state%3D%27CA%27&_facet=city_id&_facet=created&_facet_array=tags&tags__arraycontains=tag3" > tag3< / a > 1< / li >
< / ul >
< / div >
< div class = "facet-info facet-fixtures-facetable-created" id = "facet-created" >
< p class = "facet-info-name" >
< strong > created< / strong >
< a href = "/fixtures/facetable?_where=planet_int%3D1&_where=state%3D%27CA%27&_facet=city_id&_facet_array=tags" class = "cross" > ✖< / a >
< / p >
< ul >
< li > < a href = "http://latest.datasette.io/fixtures/facetable?_where=planet_int%3D1&_where=state%3D%27CA%27&_facet=city_id&_facet=created&_facet_array=tags&created=2019-01-14+08%3A00%3A00" > 2019-01-14 08:00:00< / a > 4< / li >
< li > < a href = "http://latest.datasette.io/fixtures/facetable?_where=planet_int%3D1&_where=state%3D%27CA%27&_facet=city_id&_facet=created&_facet_array=tags&created=2019-01-15+08%3A00%3A00" > 2019-01-15 08:00:00< / a > 4< / li >
< li > < a href = "http://latest.datasette.io/fixtures/facetable?_where=planet_int%3D1&_where=state%3D%27CA%27&_facet=city_id&_facet=created&_facet_array=tags&created=2019-01-16+08%3A00%3A00" > 2019-01-16 08:00:00< / a > 2< / li >
< / ul >
< / div >
< div class = "facet-info facet-fixtures-facetable-city_id" id = "facet-city_id" >
< p class = "facet-info-name" >
< strong > city_id< / strong >
< a href = "/fixtures/facetable?_where=planet_int%3D1&_where=state%3D%27CA%27&_facet=created&_facet_array=tags" class = "cross" > ✖< / a >
< / p >
< ul >
< li > < a href = "http://latest.datasette.io/fixtures/facetable?_where=planet_int%3D1&_where=state%3D%27CA%27&_facet=city_id&_facet=created&_facet_array=tags&city_id=1" > San Francisco< / a > 6< / li >
< li > < a href = "http://latest.datasette.io/fixtures/facetable?_where=planet_int%3D1&_where=state%3D%27CA%27&_facet=city_id&_facet=created&_facet_array=tags&city_id=2" > Los Angeles< / a > 4< / li >
< / ul >
< / div >
< / div >
2020-05-03 03:01:21 +00:00
< table class = "rows-and-columns" >
< thead >
< tr >
< th class = "col-Link" scope = "col" >
Link
< / th >
< th class = "col-rowid" scope = "col" >
< a href = "/fixtures/roadside_attraction_characteristics?characteristic_id=2&_sort_desc=rowid" rel = "nofollow" > rowid ▼< / a >
< / th >
< th class = "col-attraction_id" scope = "col" >
< a href = "/fixtures/roadside_attraction_characteristics?characteristic_id=2&_sort=attraction_id" rel = "nofollow" > attraction_id< / a >
< / th >
< th class = "col-characteristic_id" scope = "col" >
< a href = "/fixtures/roadside_attraction_characteristics?characteristic_id=2&_sort=characteristic_id" rel = "nofollow" > characteristic_id< / a >
< / th >
< / tr >
< / thead >
< tbody >
< tr >
< td class = "col-Link" > < a href = "/fixtures/roadside_attraction_characteristics/1" > 1< / a > < / td >
< td class = "col-rowid" > 1< / td >
< td class = "col-attraction_id" > < a href = "/fixtures/roadside_attractions/1" > The Mystery Spot< / a > < em > 1< / em > < / td >
< td class = "col-characteristic_id" > < a href = "/fixtures/attraction_characteristic/2" > Paranormal< / a > < em > 2< / em > < / td >
< / tr >
< tr >
< td class = "col-Link" > < a href = "/fixtures/roadside_attraction_characteristics/2" > 2< / a > < / td >
< td class = "col-rowid" > 2< / td >
< td class = "col-attraction_id" > < a href = "/fixtures/roadside_attractions/2" > Winchester Mystery House< / a > < em > 2< / em > < / td >
< td class = "col-characteristic_id" > < a href = "/fixtures/attraction_characteristic/2" > Paranormal< / a > < em > 2< / em > < / td >
< / tr >
< tr >
< td class = "col-Link" > < a href = "/fixtures/roadside_attraction_characteristics/3" > 3< / a > < / td >
< td class = "col-rowid" > 3< / td >
< td class = "col-attraction_id" > < a href = "/fixtures/roadside_attractions/4" > Bigfoot Discovery Museum< / a > < em > 4< / em > < / td >
< td class = "col-characteristic_id" > < a href = "/fixtures/attraction_characteristic/2" > Paranormal< / a > < em > 2< / em > < / td >
< / tr >
< / tbody >
< / table >
< div id = "export" class = "advanced-export" >
< h3 > Advanced export< / h3 >
< p > JSON shape:
< a href = "/fixtures/roadside_attraction_characteristics.json?characteristic_id=2&_labels=on" > default< / a > ,
< a href = "/fixtures/roadside_attraction_characteristics.json?characteristic_id=2&_labels=on&_shape=array" > array< / a > ,
< a href = "/fixtures/roadside_attraction_characteristics.json?characteristic_id=2&_labels=on&_shape=array&_nl=on" > newline-delimited< / a >
< / p >
< form action = "/fixtures/roadside_attraction_characteristics.csv" method = "get" >
< p >
CSV options:
< label > < input type = "checkbox" name = "_dl" > download file< / label >
< label > < input type = "checkbox" name = "_labels" checked > expand labels< / label >
< input type = "submit" value = "Export CSV" >
< input type = "hidden" name = "characteristic_id" value = "2" >
< input type = "hidden" name = "_size" value = "max" >
< / p >
< / form >
< / div >
< pre class = "wrapped-sql" > CREATE TABLE roadside_attraction_characteristics (
attraction_id INTEGER REFERENCES roadside_attractions(pk),
characteristic_id INTEGER REFERENCES attraction_characteristic(pk)
);< / pre >
2020-08-27 21:59:34 +00:00
< / section >
2020-05-03 03:01:21 +00:00
< h2 class = "pattern-heading" > .bd for /database/table/row< / h2 >
2020-08-27 21:59:34 +00:00
< section class = "content" >
2020-09-07 15:43:37 +00:00
< h1 style = "padding-left: 10px; border-left: 10px solid #ff0000" > roadside_attractions: 2< / h1 >
2020-05-03 03:01:21 +00:00
< p > This data as < a href = "/fixtures/roadside_attractions/2.json" > json< / a > < / p >
< table class = "rows-and-columns" >
< thead >
< tr >
< th class = "col-pk" scope = "col" >
pk
< / th >
< th class = "col-name" scope = "col" >
name
< / th >
< th class = "col-address" scope = "col" >
address
< / th >
< th class = "col-latitude" scope = "col" >
latitude
< / th >
< th class = "col-longitude" scope = "col" >
longitude
< / th >
< / tr >
< / thead >
< tbody >
< tr >
< td class = "col-pk" > 2< / td >
< td class = "col-name" > Winchester Mystery House< / td >
< td class = "col-address" > 525 South Winchester Boulevard, San Jose, CA 95128< / td >
< td class = "col-latitude" > 37.3184< / td >
< td class = "col-longitude" > -121.9511< / td >
< / tr >
< / tbody >
< / table >
< h2 > Links from other tables< / h2 >
< ul >
< li >
< a href = "/fixtures/roadside_attraction_characteristics?attraction_id=2" >
1 row< / a >
from attraction_id in roadside_attraction_characteristics
< / li >
< / ul >
2020-08-27 21:59:34 +00:00
< / section >
2020-05-03 03:01:21 +00:00
< h2 class = "pattern-heading" > .ft< / h2 >
2020-08-27 21:59:34 +00:00
2020-12-10 23:37:08 +00:00
< footer class = "ft" > Powered by < a href = "https://datasette.io/" title = "Datasette v0+unknown" > Datasette< / a >
2020-05-03 03:01:21 +00:00
· Data license:
2021-03-23 16:19:41 +00:00
< a href = "https://github.com/simonw/datasette/blob/main/LICENSE" > Apache License 2.0< / a >
2020-05-03 03:01:21 +00:00
·
Data source:
2021-03-23 16:19:41 +00:00
< a href = "https://github.com/simonw/datasette/blob/main/tests/fixtures.py" >
2020-05-03 03:01:21 +00:00
tests/fixtures.py< / a >
·
About:
< a href = "https://github.com/simonw/datasette" >
About Datasette< / a >
2020-08-27 21:59:34 +00:00
< / footer >
2020-11-02 18:53:52 +00:00
{% include "_close_open_menus.html" %}
2020-05-03 03:01:21 +00:00
< / body >
< / html >