DVD Rental Database#

 1################################################################################
 2# For help, see https://rics.readthedocs.io                                    #
 3################################################################################
 4[translator]
 5fmt = "{id}:{name}[ {last_name}]"
 6
 7# ------------------------------------------------------------------------------
 8# Name-to-source mapping configuration. Binds names to source, eg 'cute_animals'
 9# -> 'my_database.animals'. Overrides take precedence over scoring logic.
10[translator.mapping]
11unmapped_values_action = "raise"
12score_function = "modified_hamming"
13
14[[translator.mapping.score_function_heuristics]]
15function = "like_database_table"
16
17[[translator.mapping.filter_functions]]
18function = "require_regex_match"
19regex = ".*_id$"
20where = "name"
21
22################################################################################
23# Fetching configuration.
24################################################################################
25[fetching.MemoryFetcher.data.category]
26id = [1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16]
27name = [
28    "Action", "Animation",
29    "Children", "Classics", "Comedy",
30    "Documentary", "Drama",
31    "Family", "Foreign",
32    "Games", "Horror", "Music", "New",
33    "Sci-Fi", "Sports", "Travel"
34]

 1[fetching.SqlFetcher]
 2connection_string = "@DVDRENTAL_CONNECTION_STRING"
 3password = "@DVDRENTAL_PASSWORD"
 4blacklist_tables = ["category"]  # Let's pretend this table is off-limits
 5
 6[fetching.SqlFetcher.engine_kwargs]
 7# fast_executemany = true  # Not supported by the driver
 8
 9# ------------------------------------------------------------------------------
10# Placeholder mapping configuration. Binds actual names in sources (such as
11# column names in an SQL table) to wanted names, eg id = 'animal_id'.
12[fetching.mapping]
13unmapped_values_action = "ignore"
14
15[[fetching.mapping.filter_functions]]
16function = "banned_substring"
17substrings = ["p2007"]
18where = "context"
19
20[[fetching.mapping.score_function_heuristics]]
21function = "value_fstring_alias"
22fstring = "first_{value}"
23[[fetching.mapping.score_function_heuristics]]
24function = "value_fstring_alias"
25fstring = "{context}_{value}"
26
27[fetching.mapping.overrides.address]
28code = "postal_code"
29[fetching.mapping.overrides.film]
30name = "title"