home / code

definitions

197 rows sorted by name

View and edit SQL

Suggested facets: file_id, type

Link rowid file_id line_id type name ▼ params id
196 datasette/views/base.py 33 class BaseView(RenderMixin):  8975 class BaseView ["datasette"] 196
146 datasette/cli.py 21 class Config(click.ParamType):  5805 class Config ["args", "kwargs"] 146
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
177 datasette/utils.py 22 class CustomRow(OrderedDict):  6985 class CustomRow ["columns", "values"] 177
189 datasette/views/database.py 29 class DatabaseDownload(BaseView):  7939 class DatabaseDownload ["datasette"] 189
188 datasette/views/database.py 29 class DatabaseView(BaseView):  7908 class DatabaseView ["datasette"] 188
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
194 datasette/views/base.py 33 class DatasetteError(Exception):  8943 class DatasetteError ["message", "title", "error_dict", "status", "template", "messagge_is_html"] 194
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
187 datasette/views/index.py 28 class IndexView(RenderMixin):  7853 class IndexView ["datasette"] 187
147 datasette/utils.py 22 class InterruptedError(Exception):  6205 class InterruptedError ["args", "kwargs"] 147
153 datasette/utils.py 22 class InvalidSql(Exception):  6313 class InvalidSql ["args", "kwargs"] 153
193 datasette/views/special.py 32 class JsonDataView(RenderMixin):  8883 class JsonDataView ["datasette", "filename", "data_callback"] 193
181 datasette/utils.py 22 class LimitedWriter:  7018 class LimitedWriter ["writer", "limit_mb"] 181
7 versioneer.py 3 class NotThisMethod(Exception):  463 class NotThisMethod ["args", "kwargs"] 7
195 datasette/views/base.py 33 class RenderMixin(HTTPMethodView):  8953 class RenderMixin ["args", "kwargs"] 195
148 datasette/utils.py 22 class Results:  6209 class Results ["rows", "truncated", "description"] 148
190 datasette/views/table.py 31 class RowTableShared(BaseView):  7981 class RowTableShared ["datasette"] 190
192 datasette/views/table.py 31 class RowView(RowTableShared):  8758 class RowView ["datasette"] 192
183 datasette/utils.py 22 class StaticMount(click.ParamType):  7045 class StaticMount ["args", "kwargs"] 183
191 datasette/views/table.py 31 class TableView(RowTableShared):  8177 class TableView ["datasette"] 191
138 tests/fixtures.py 14 class TestClient:  4928 class TestClient ["sanic_test_client"] 138
179 datasette/utils.py 22 class ValueAsBooleanError(ValueError):  7010 class ValueAsBooleanError ["args", "kwargs"] 179
22 versioneer.py 3 class VersioneerBadRootError(Exception):  1497 class VersioneerBadRootError ["args", "kwargs"] 22
4 versioneer.py 3 class VersioneerConfig:  391 class VersioneerConfig ["args", "kwargs"] 4
180 datasette/utils.py 22 class WriteLimitExceeded(Exception):  7014 class WriteLimitExceeded ["args", "kwargs"] 180
185 datasette/publish/common.py 27 def add_common_publish_arguments_and_options(subcommand):  7781 function add_common_publish_arguments_and_options ["subcommand"] 185
155 datasette/utils.py 22 def append_querystring(url, querystring):  6337 function append_querystring ["url", "querystring"] 155
76 tests/test_html.py 10 def assert_footer_links(soup):  3323 function assert_footer_links ["soup"] 76
75 tests/test_html.py 10 def assert_querystring_equal(expected, actual):  3319 function assert_querystring_equal ["expected", "actual"] 75
151 datasette/utils.py 22 def compound_keys_after_sql(pks, start_index=0):  6247 function compound_keys_after_sql ["pks", "start_index"] 151
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
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
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
163 datasette/utils.py 22 def detect_spatialite(conn):  6659 function detect_spatialite ["conn"] 163
26 versioneer.py 3 def do_setup():  1796 function do_setup [] 26
10 versioneer.py 3 def do_vcs_install(manifest_in, versionfile_source, ipy):  1219 function do_vcs_install ["manifest_in", "versionfile_source", "ipy"] 10
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
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
168 datasette/utils.py 22 def filters_should_redirect(special_args):  6820 function filters_should_redirect ["special_args"] 168
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
162 datasette/utils.py 22 def get_all_foreign_keys(conn):  6626 function get_all_foreign_keys ["conn"] 162
25 versioneer.py 3 def get_cmdclass():  1582 function get_cmdclass [] 25
6 versioneer.py 3 def get_config_from_root(root):  434 function get_config_from_root ["root"] 6
37 tests/test_docs.py 8 def get_headings(filename, underline="-"):  2523 function get_headings ["filename", "underline"] 37
38 tests/test_docs.py 8 def get_labels(filename):  2529 function get_labels ["filename"] 38
2 setup.py 2 def get_long_description():  36 function get_long_description [] 2
174 datasette/utils.py 22 def get_plugins(pm):  6923 function get_plugins ["pm"] 174
5 versioneer.py 3 def get_root():  395 function get_root [] 5
3 setup.py 2 def get_version():  43 function get_version [] 3
24 versioneer.py 3 def get_version():  1577 function get_version [] 24
23 versioneer.py 3 def get_versions(verbose=False):  1501 function get_versions ["verbose"] 23
77 tests/test_html.py 10 def inner_html(soup):  3335 function inner_html ["soup"] 77
141 datasette/inspect.py 20 def inspect_hash(path):  5659 function inspect_hash ["path"] 141
145 datasette/inspect.py 20 def inspect_tables(conn, database_metadata):  5701 function inspect_tables ["conn", "database_metadata"] 145
142 datasette/inspect.py 20 def inspect_views(conn):  5672 function inspect_views ["conn"] 142
169 datasette/utils.py 22 def is_url(value):  6857 function is_url ["value"] 169
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
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
173 datasette/utils.py 22 def module_from_path(path, name):  6913 function module_from_path ["path", "name"] 173
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
156 datasette/utils.py 22 def path_with_added_args(request, args, path=None):  6344 function path_with_added_args ["request", "args", "path"] 156
176 datasette/utils.py 22 def path_with_format(request, format, extra_qs=None):  6965 function path_with_format ["request", "format", "extra_qs"] 176
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
14 versioneer.py 3 def plus_or_dot(pieces):  1328 function plus_or_dot ["pieces"] 14
8 versioneer.py 3 def register_vcs_handler(vcs, method): # decorator  472 function register_vcs_handler ["vcs", "method"] 8
182 datasette/utils.py 22 def remove_infinites(row):  7036 function remove_infinites ["row"] 182
21 versioneer.py 3 def render(pieces, style):  1465 function render ["pieces", "style"] 21
19 versioneer.py 3 def render_git_describe(pieces):  1425 function render_git_describe ["pieces"] 19
20 versioneer.py 3 def render_git_describe_long(pieces):  1445 function render_git_describe_long ["pieces"] 20
15 versioneer.py 3 def render_pep440(pieces):  1335 function render_pep440 ["pieces"] 15
18 versioneer.py 3 def render_pep440_old(pieces):  1403 function render_pep440_old ["pieces"] 18
17 versioneer.py 3 def render_pep440_post(pieces):  1376 function render_pep440_post ["pieces"] 17
16 versioneer.py 3 def render_pep440_pre(pieces):  1360 function render_pep440_pre ["pieces"] 16
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
9 versioneer.py 3 def run_command(commands, args, cwd=None, verbose=False, hide_stderr=False,  483 function run_command ["commands", "args", "cwd", "verbose", "hide_stderr", "env"] 9
27 versioneer.py 3 def scan_setup_py():  1878 function scan_setup_py [] 27
31 tests/test_utils.py 4 def table_exists(table):  2250 function table_exists ["table"] 31
47 tests/test_html.py 10 def test_add_filter_redirects(app_client):  2682 function test_add_filter_redirects ["app_client"] 47
72 tests/test_html.py 10 def test_allow_download_off():  3273 function test_allow_download_off [] 72
71 tests/test_html.py 10 def test_allow_download_on(app_client):  3265 function test_allow_download_on ["app_client"] 71
123 tests/test_api.py 12 def test_allow_facet_off():  4666 function test_allow_facet_off [] 123
74 tests/test_html.py 10 def test_allow_sql_off():  3303 function test_allow_sql_off [] 74
90 tests/test_api.py 12 def test_allow_sql_off():  3941 function test_allow_sql_off [] 90
73 tests/test_html.py 10 def test_allow_sql_on(app_client):  3291 function test_allow_sql_on ["app_client"] 73
78 tests/test_html.py 10 def test_canned_query_with_custom_metadata(app_client):  3352 function test_canned_query_with_custom_metadata ["app_client"] 78
86 tests/test_api.py 12 def test_canned_query_with_named_parameter(app_client):  3898 function test_canned_query_with_named_parameter ["app_client"] 86
30 tests/test_utils.py 4 def test_compound_keys_after_sql():  2234 function test_compound_keys_after_sql [] 30
66 tests/test_html.py 10 def test_compound_primary_key_with_foreign_key_references(app_client):  3176 function test_compound_primary_key_with_foreign_key_references ["app_client"] 66
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
120 tests/test_api.py 12 def test_config_json(app_client):  4472 function test_config_json ["app_client"] 120
56 tests/test_html.py 10 def test_csv_json_export_links_include_labels_if_foreign_keys(app_client):  3018 function test_csv_json_export_links_include_labels_if_foreign_keys ["app_client"] 56

Next page

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 12.451ms