home / code

definitions

197 rows

View and edit SQL

Link rowid file_id line_id type name params id
101 tests/test_api.py 12 def test_table_with_slashes_in_name(app_client):  4088 function test_table_with_slashes_in_name ["app_client"] 101
102 tests/test_api.py 12 def test_table_with_reserved_word_name(app_client):  4098 function test_table_with_reserved_word_name ["app_client"] 102
103 tests/test_api.py 12 def test_page_size_zero(app_client):  4152 function test_page_size_zero ["app_client"] 103
104 tests/test_api.py 12 def test_paginate_compound_keys(app_client):  4163 function test_paginate_compound_keys ["app_client"] 104
105 tests/test_api.py 12 def test_paginate_compound_keys_with_extra_filters(app_client):  4181 function test_paginate_compound_keys_with_extra_filters ["app_client"] 105
106 tests/test_api.py 12 def test_sortable_and_filtered(app_client):  4243 function test_sortable_and_filtered ["app_client"] 106
107 tests/test_api.py 12 def test_sortable_argument_errors(app_client):  4266 function test_sortable_argument_errors ["app_client"] 107
108 tests/test_api.py 12 def test_sortable_columns_metadata(app_client):  4281 function test_sortable_columns_metadata ["app_client"] 108
109 tests/test_api.py 12 def test_searchable_invalid_column(app_client):  4314 function test_searchable_invalid_column ["app_client"] 109
110 tests/test_api.py 12 def test_max_returned_rows(app_client):  4348 function test_max_returned_rows ["app_client"] 110
111 tests/test_api.py 12 def test_view(app_client):  4361 function test_view ["app_client"] 111
112 tests/test_api.py 12 def test_row(app_client):  4377 function test_row ["app_client"] 112
113 tests/test_api.py 12 def test_row_strange_table_name(app_client):  4383 function test_row_strange_table_name ["app_client"] 113
114 tests/test_api.py 12 def test_row_foreign_key_tables(app_client):  4389 function test_row_foreign_key_tables ["app_client"] 114
115 tests/test_api.py 12 def test_unit_filters(app_client):  4415 function test_unit_filters ["app_client"] 115
116 tests/test_api.py 12 def test_metadata_json(app_client):  4429 function test_metadata_json ["app_client"] 116
117 tests/test_api.py 12 def test_inspect_json(app_client):  4436 function test_inspect_json ["app_client"] 117
118 tests/test_api.py 12 def test_plugins_json(app_client):  4443 function test_plugins_json ["app_client"] 118
119 tests/test_api.py 12 def test_versions_json(app_client):  4458 function test_versions_json ["app_client"] 119
120 tests/test_api.py 12 def test_config_json(app_client):  4472 function test_config_json ["app_client"] 120
121 tests/test_api.py 12 def test_page_size_matching_max_returned_rows(app_client_returned_rows_matches_page_size):  4497 function test_page_size_matching_max_returned_rows ["app_client_returned_rows_matches_page_size"] 121
122 tests/test_api.py 12 def test_suggested_facets(app_client):  4660 function test_suggested_facets ["app_client"] 122
123 tests/test_api.py 12 def test_allow_facet_off():  4666 function test_allow_facet_off [] 123
124 tests/test_api.py 12 def test_suggest_facets_off():  4679 function test_suggest_facets_off [] 124
125 tests/test_api.py 12 def test_expand_labels(app_client):  4689 function test_expand_labels ["app_client"] 125
126 tests/test_api.py 12 def test_expand_label(app_client):  4720 function test_expand_label ["app_client"] 126
127 tests/test_api.py 12 def test_config_cache_size(app_client_larger_cache_size):  4784 function test_config_cache_size ["app_client_larger_cache_size"] 127
128 tests/test_api.py 12 def test_config_force_https_urls():  4791 function test_config_force_https_urls [] 128
129 tests/test_api.py 12 def test_infinity_returned_as_null(app_client):  4801 function test_infinity_returned_as_null ["app_client"] 129
130 tests/test_api.py 12 def test_infinity_returned_as_invalid_json_if_requested(app_client):  4810 function test_infinity_returned_as_invalid_json_if_requested ["app_client"] 130
131 tests/test_csv.py 13 def test_table_csv(app_client):  4854 function test_table_csv ["app_client"] 131
132 tests/test_csv.py 13 def test_table_csv_cors_headers(app_client_with_cors):  4862 function test_table_csv_cors_headers ["app_client_with_cors"] 132
133 tests/test_csv.py 13 def test_table_csv_with_labels(app_client):  4868 function test_table_csv_with_labels ["app_client"] 133
134 tests/test_csv.py 13 def test_custom_sql_csv(app_client):  4875 function test_custom_sql_csv ["app_client"] 134
135 tests/test_csv.py 13 def test_table_csv_download(app_client):  4884 function test_table_csv_download ["app_client"] 135
136 tests/test_csv.py 13 def test_max_csv_mb(app_client_csv_max_mb_one):  4892 function test_max_csv_mb ["app_client_csv_max_mb_one"] 136
137 tests/test_csv.py 13 def test_table_csv_stream(app_client):  4904 function test_table_csv_stream ["app_client"] 137
138 tests/fixtures.py 14 class TestClient:  4928 class TestClient ["sanic_test_client"] 138
139 tests/fixtures.py 14 def generate_compound_rows(num):  5012 function generate_compound_rows ["num"] 139
140 tests/fixtures.py 14 def generate_sortable_rows(num):  5019 function generate_sortable_rows ["num"] 140
141 datasette/inspect.py 20 def inspect_hash(path):  5659 function inspect_hash ["path"] 141
142 datasette/inspect.py 20 def inspect_views(conn):  5672 function inspect_views ["conn"] 142
143 datasette/inspect.py 20 def detect_label_column(column_names):  5677 function detect_label_column ["column_names"] 143
144 datasette/inspect.py 20 def detect_primary_keys(conn, table):  5688 function detect_primary_keys ["conn", "table"] 144
145 datasette/inspect.py 20 def inspect_tables(conn, database_metadata):  5701 function inspect_tables ["conn", "database_metadata"] 145
146 datasette/cli.py 21 class Config(click.ParamType):  5805 class Config ["args", "kwargs"] 146
147 datasette/utils.py 22 class InterruptedError(Exception):  6205 class InterruptedError ["args", "kwargs"] 147
148 datasette/utils.py 22 class Results:  6209 class Results ["rows", "truncated", "description"] 148
149 datasette/utils.py 22 def urlsafe_components(token):  6222 function urlsafe_components ["token"] 149
150 datasette/utils.py 22 def path_from_row_pks(row, pks, use_rowid, quote=True):  6229 function path_from_row_pks ["row", "pks", "use_rowid", "quote"] 150
151 datasette/utils.py 22 def compound_keys_after_sql(pks, start_index=0):  6247 function compound_keys_after_sql ["pks", "start_index"] 151
152 datasette/utils.py 22 class CustomJSONEncoder(json.JSONEncoder):  6275 class CustomJSONEncoder ["skipkeys", "ensure_ascii", "check_circular", "allow_nan", "sort_keys", "indent", "separators", "default"] 152
153 datasette/utils.py 22 class InvalidSql(Exception):  6313 class InvalidSql ["args", "kwargs"] 153
154 datasette/utils.py 22 def validate_sql_select(sql):  6328 function validate_sql_select ["sql"] 154
155 datasette/utils.py 22 def append_querystring(url, querystring):  6337 function append_querystring ["url", "querystring"] 155
156 datasette/utils.py 22 def path_with_added_args(request, args, path=None):  6344 function path_with_added_args ["request", "args", "path"] 156
157 datasette/utils.py 22 def path_with_removed_args(request, args, path=None):  6364 function path_with_removed_args ["request", "args", "path"] 157
158 datasette/utils.py 22 def path_with_replaced_args(request, args, path=None):  6384 function path_with_replaced_args ["request", "args", "path"] 158
159 datasette/utils.py 22 def escape_css_string(s):  6404 function escape_css_string ["s"] 159
160 datasette/utils.py 22 def escape_sqlite(s):  6408 function escape_sqlite ["s"] 160
161 datasette/utils.py 22 def make_dockerfile(files, metadata_file, extra_options, branch, template_dir, plugins_dir, static, install, spatialite, version_note):  6415 function make_dockerfile ["files", "metadata_file", "extra_options", "branch", "template_dir", "plugins_dir", "static", "install", "spatialite", "version_note"] 161
162 datasette/utils.py 22 def get_all_foreign_keys(conn):  6626 function get_all_foreign_keys ["conn"] 162
163 datasette/utils.py 22 def detect_spatialite(conn):  6659 function detect_spatialite ["conn"] 163
164 datasette/utils.py 22 def detect_fts(conn, table):  6664 function detect_fts ["conn", "table"] 164
165 datasette/utils.py 22 def detect_fts_sql(table):  6673 function detect_fts_sql ["table"] 165
166 datasette/utils.py 22 class Filter:  6687 class Filter ["key", "display", "sql_template", "human_template", "format", "numeric", "no_argument"] 166
167 datasette/utils.py 22 class Filters:  6724 class Filters ["pairs", "units", "ureg"] 167
168 datasette/utils.py 22 def filters_should_redirect(special_args):  6820 function filters_should_redirect ["special_args"] 168
169 datasette/utils.py 22 def is_url(value):  6857 function is_url ["value"] 169
170 datasette/utils.py 22 def to_css_class(s):  6873 function to_css_class ["s"] 170
171 datasette/utils.py 22 def link_or_copy(src, dst):  6896 function link_or_copy ["src", "dst"] 171
172 datasette/utils.py 22 def link_or_copy_directory(src, dst):  6906 function link_or_copy_directory ["src", "dst"] 172
173 datasette/utils.py 22 def module_from_path(path, name):  6913 function module_from_path ["path", "name"] 173
174 datasette/utils.py 22 def get_plugins(pm):  6923 function get_plugins ["pm"] 174
175 datasette/utils.py 22 def resolve_table_and_format(table_and_format, table_exists):  6952 function resolve_table_and_format ["table_and_format", "table_exists"] 175
176 datasette/utils.py 22 def path_with_format(request, format, extra_qs=None):  6965 function path_with_format ["request", "format", "extra_qs"] 176
177 datasette/utils.py 22 class CustomRow(OrderedDict):  6985 class CustomRow ["columns", "values"] 177
178 datasette/utils.py 22 def value_as_boolean(value):  7004 function value_as_boolean ["value"] 178
179 datasette/utils.py 22 class ValueAsBooleanError(ValueError):  7010 class ValueAsBooleanError ["args", "kwargs"] 179
180 datasette/utils.py 22 class WriteLimitExceeded(Exception):  7014 class WriteLimitExceeded ["args", "kwargs"] 180
181 datasette/utils.py 22 class LimitedWriter:  7018 class LimitedWriter ["writer", "limit_mb"] 181
182 datasette/utils.py 22 def remove_infinites(row):  7036 function remove_infinites ["row"] 182
183 datasette/utils.py 22 class StaticMount(click.ParamType):  7045 class StaticMount ["args", "kwargs"] 183
184 datasette/app.py 23 class Datasette:  7171 class Datasette ["files", "cache_headers", "cors", "inspect_data", "metadata", "sqlite_extensions", "template_dir", "plugins_dir", "static_mounts", "config", "version_note"] 184
185 datasette/publish/common.py 27 def add_common_publish_arguments_and_options(subcommand):  7781 function add_common_publish_arguments_and_options ["subcommand"] 185
186 datasette/publish/common.py 27 def fail_if_publish_binary_not_installed(binary, publish_target, install_link):  7824 function fail_if_publish_binary_not_installed ["binary", "publish_target", "install_link"] 186
187 datasette/views/index.py 28 class IndexView(RenderMixin):  7853 class IndexView ["datasette"] 187
188 datasette/views/database.py 29 class DatabaseView(BaseView):  7908 class DatabaseView ["datasette"] 188
189 datasette/views/database.py 29 class DatabaseDownload(BaseView):  7939 class DatabaseDownload ["datasette"] 189
190 datasette/views/table.py 31 class RowTableShared(BaseView):  7981 class RowTableShared ["datasette"] 190
191 datasette/views/table.py 31 class TableView(RowTableShared):  8177 class TableView ["datasette"] 191
192 datasette/views/table.py 31 class RowView(RowTableShared):  8758 class RowView ["datasette"] 192
193 datasette/views/special.py 32 class JsonDataView(RenderMixin):  8883 class JsonDataView ["datasette", "filename", "data_callback"] 193
194 datasette/views/base.py 33 class DatasetteError(Exception):  8943 class DatasetteError ["message", "title", "error_dict", "status", "template", "messagge_is_html"] 194
195 datasette/views/base.py 33 class RenderMixin(HTTPMethodView):  8953 class RenderMixin ["args", "kwargs"] 195
196 datasette/views/base.py 33 class BaseView(RenderMixin):  8975 class BaseView ["datasette"] 196
197 datasette/views/base.py 33 def convert_specific_columns_to_json(rows, columns, json_cols):  9438 function convert_specific_columns_to_json ["rows", "columns", "json_cols"] 197

Advanced export

JSON shape: default, array

CSV options:

CREATE TABLE [definitions] (
               [file_id] INTEGER   REFERENCES [files]([id]),
   [line_id] INTEGER   REFERENCES [lines]([id]),
   [type] TEXT  ,
   [name] TEXT  ,
   [params] TEXT  ,
   [id] INTEGER  
        )
Powered by Datasette · Query took 4.533ms