Post by Uncle Buddy on Nov 25, 2022 17:58:38 GMT -8
<drive>:\treebard_gps\app\python\query_strings.py Last Changed 2022-12-07
# query_strings.py
import dev_tools as dt
from dev_tools import looky, seeline
'''
Since Sqlite queries are inserted as string in Python code,
the queries can be stored here to save space in the modules
where they are used.
'''
delete_assertion = '''
DELETE FROM assertion
WHERE assertion_id = ?
'''
delete_assertions_findings = '''
DELETE FROM links_links
WHERE finding_id = ?
'''
delete_assertion_person = '''
DELETE FROM assertion
WHERE person_id = ?
'''
delete_citation = '''
DELETE FROM citation
WHERE citation_id = ?
'''
delete_source = '''
DELETE FROM source
WHERE source_id = ?
'''
delete_color_scheme = '''
DELETE FROM color_scheme
WHERE color_scheme_id = ?
'''
delete_date_format_all = '''DELETE FROM date_format'''
delete_finding = '''
DELETE FROM finding
WHERE finding_id = ?
'''
delete_do_list_item = '''
DELETE FROM to_do
WHERE to_do_id = ?
'''
delete_finding_person = '''
DELETE FROM finding
WHERE person_id = ?
'''
delete_findings_notes_finding = '''
DELETE FROM links_links
WHERE finding_id = ?
AND note_id is not null
'''
delete_findings_role = '''
DELETE FROM links_links
WHERE links_links_id = ?
'''
delete_findings_roles_finding = '''
DELETE FROM links_links
WHERE finding_id = ?
AND role_type_id is not null
'''
delete_image = '''
DELETE FROM image
WHERE image_id = ?
'''
delete_links_links_name = '''
DELETE FROM links_links
WHERE name_id = ?
'''
delete_links_links_person = '''
DELETE FROM links_links
WHERE person_id = ?
'''
delete_links_links_image = '''
DELETE FROM links_links
WHERE image_id = ?
'''
delete_links_links_image_person = '''
DELETE FROM links_links
WHERE person_id = ?
AND image_id = ?
'''
delete_links_links_image_nested_place = '''
DELETE FROM links_links
WHERE nested_place_id = ?
AND image_id = ?
'''
delete_links_links_image_source = '''
DELETE FROM links_links
WHERE source_id = ?
AND image_id = ?
'''
delete_links_links_unlink_note = '''
DELETE FROM links_links
WHERE links_links_id = ?
'''
delete_name = '''
DELETE FROM name
WHERE name_id = ?
'''
delete_name_person = '''
DELETE FROM name
WHERE person_id = ?
'''
delete_person = '''
DELETE FROM person
WHERE person_id = ?
'''
delete_place = '''
DELETE FROM place
WHERE place_id = ?
'''
delete_place_name = '''
DELETE FROM place_name
WHERE place_id = ?
'''
insert_assertion_new_age = '''
INSERT INTO assertion (
finding_id, citation_id, event_type_id, ages)
VALUES (?, ?, ?, ?)
'''
insert_assertion_new_date = '''
INSERT INTO assertion (
finding_id, citation_id, event_type_id, dates)
VALUES (?, ?, ?, ?)
'''
insert_assertion_new_name = '''
INSERT INTO assertion (
finding_id, citation_id, event_type_id, names)
VALUES (?, ?, ?, ?)
'''
insert_assertion_new_place = '''
INSERT INTO assertion (
finding_id, citation_id, event_type_id, places)
VALUES (?, ?, ?, ?)
'''
insert_assertion_new_particulars = '''
INSERT INTO assertion (
finding_id, citation_id, event_type_id, particulars)
VALUES (?, ?, ?, ?)
'''
insert_assertion_new_role = '''
INSERT INTO assertion (
finding_id, citation_id, event_type_id, roles)
VALUES (?, ?, ?, ?)
'''
insert_citation_new = '''
INSERT INTO citation (citations, source_id)
VALUES (?, ?)
'''
insert_color_scheme = '''
INSERT INTO color_scheme
VALUES (null, ?, ?, ?, ?, 0, 0)
'''
insert_date_format_default = '''
INSERT INTO date_format
VALUES (
1, 'dmy', 'abt', 'est', 'cal', 'bef/aft', 'BCE/CE',
'OS/NS', 'from_to', 'btwn_&')
'''
insert_event_type = '''
INSERT INTO event_type (event_types, couple, marital, after_death)
VALUES (?, ?, ?, ?)
'''
insert_event_type_new = '''
INSERT INTO event_type (event_types, couple, after_death)
VALUES (?, ?, ?)
'''
insert_finding_birth = '''
INSERT INTO finding (age, event_type_id, person_id, nested_place_id)
VALUES (0, 1, ?, 1)
'''
insert_finding_new = '''
INSERT INTO finding (event_type_id, person_id)
VALUES (?, ?)
'''
insert_finding_birth_new_person = '''
INSERT INTO finding (date, age, person_id, event_type_id, date_sorter, nested_place_id)
VALUES ('-0000-00-00-------', '0', ?, 1, '0,0,0', 1)
'''
insert_finding_death = '''
INSERT INTO finding (date, person_id, event_type_id, date_sorter, nested_place_id)
VALUES (?, ?, 4, ?, 1)
'''
insert_finding_new_couple = '''
INSERT INTO finding (
event_type_id, person_id1, person_id2, kin_type_id1, kin_type_id2)
VALUES (?, ?, null, 128, 129)
'''
insert_finding_new_couple_alt = '''
INSERT INTO finding (
person_id, event_type_id, person_id1, person_id2, kin_type_id1, kin_type_id2)
VALUES (?, ?, null, null, ?, ?)
'''
# null event_type_id not allowed
insert_finding_new_couple_details = '''
INSERT INTO finding (
finding_id, person_id1, age1, kin_type_id1,
person_id2, age2, kin_type_id2, event_type_id)
VALUES (?, ?, ?, 128, ?, ?, 129, ?)
'''
insert_finding_null_couple = '''
INSERT INTO finding ('', null, '', null)
'''
insert_findings_roles = '''
INSERT INTO links_links (finding_id, role_type_id, person_id)
VALUES (?, ?, ?)
'''
insert_image_new = '''
INSERT INTO image
VALUES (null, ?, ?)
'''
insert_kin_type_new = '''
INSERT INTO kin_type (kin_types, kin_code)
VALUES (?, ?)
'''
insert_links_links_image_person = '''
INSERT INTO links_links (image_id, person_id, main_image)
VALUES (?, ?, ?)
'''
insert_links_links_image_nested_place = '''
INSERT INTO links_links (image_id, nested_place_id, main_image)
VALUES (?, ?, ?)
'''''
insert_links_links_image_source = '''
INSERT INTO links_links (image_id, source_id, main_image)
VALUES (?, ?, ?)
'''
insert_links_links_new_assertion_note = '''
INSERT INTO links_links (assertion_id, note_id, note_topic_order)
VALUES (?, ?, ?)
'''
insert_links_links_new_finding_note = '''
INSERT INTO links_links (finding_id, note_id, note_topic_order)
VALUES (?, ?, ?)
'''
insert_links_links_source_and_repository = '''
INSERT INTO links_links (source_id, repository_id)
VALUES (?, ?)
'''
insert_locator = '''
INSERT INTO locator (locators, citation_id, repository_id)
VALUES (?, ?, ?)
'''
insert_name = '''
INSERT INTO name
VALUES (null, ?, ?, ?, ?, '')
'''
insert_name_and_type = '''
INSERT INTO name (names, name_type_id, person_id, sort_order)
VALUES (?, ?, ?, ?)
'''
insert_name_placeholder = '''
INSERT INTO name
VALUES (null, ?, '_____ _____', 25, '_____, _____', '')
'''
insert_name_type_new = '''
INSERT INTO name_type (name_types)
VALUES (?)
'''
insert_nested_place = '''
INSERT INTO nested_place (nest0, nest1, nest2, nest3, nest4, nest5, nest6, nest7, nest8)
VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
'''
insert_note = '''
INSERT INTO note
VALUES (null, ?, 0, ?)
'''
insert_person_new = '''
INSERT INTO person (gender)
VALUES (?)
'''
insert_place_new = '''
INSERT INTO place (place_id)
VALUES (null)
'''
insert_place_name = '''
INSERT INTO place_name (place_names, place_id, main_place_name)
VALUES (?, ?, 1)
'''
insert_repository_new = '''
INSERT INTO repository (repositories)
VALUES (?)
'''
insert_role_type = '''
INSERT INTO role_type VALUES (null, ?, 0, 0)
'''
insert_source_new = '''
INSERT INTO source (sources) VALUES (?)
'''
insert_to_do = '''
INSERT INTO to_do (to_dos, priority) VALUES (?, ?)
'''
select_all_color_schemes = '''
SELECT color_scheme_id, bg, highlight_bg, head_bg, fg, built_in, hidden
FROM color_scheme
'''
select_all_color_schemes_hidden = '''
SELECT color_scheme_id, bg, highlight_bg, head_bg, fg, built_in, hidden
FROM color_scheme
WHERE hidden = 1
'''
select_all_color_schemes_unhidden = '''
SELECT color_scheme_id, bg, highlight_bg, head_bg, fg, built_in, hidden
FROM color_scheme
WHERE hidden = 0
'''
select_all_event_types = '''
SELECT event_types
FROM event_type
ORDER BY event_types
'''
select_all_event_types_couple = '''
SELECT event_types
FROM event_type
WHERE hidden != 1
AND couple == 1
'''
select_all_event_type_ids_marital = '''
SELECT event_type_id
FROM event_type
WHERE marital = 1
'''
select_all_findings_current_person = '''
SELECT finding_id
FROM finding
WHERE person_id = ?
'''
select_all_findings_roles_ids_distinct = '''
SELECT DISTINCT finding_id
FROM links_links
WHERE role_type_id IS NOT null
'''
select_all_findings_notes_ids = '''
SELECT finding_id
FROM links_links
WHERE note_id IS NOT null
'''
select_all_images = '''
SELECT images FROM image
'''
select_all_kin_type_ids_couple = '''
SELECT kin_type_id
FROM kin_type
WHERE kin_code = 'D'
AND hidden = 0
'''
select_all_kin_ids_types_couple = '''
SELECT kin_type_id, kin_types
FROM kin_type
WHERE kin_code = 'D'
AND hidden = 0
'''
select_all_name_types = '''
SELECT name_types FROM name_type ORDER BY name_types
'''
select_all_names = '''
SELECT names from name
'''
select_all_names_all_details = '''
SELECT person_id, names, name_types, name.name_id, sort_order, used_by
FROM name
JOIN name_type
ON name.name_type_id = name_type.name_type_id
ORDER BY hierarchy
'''
select_all_names_all_details_order_hierarchy = '''
SELECT person_id, names, name_types, name.name_id, sort_order, used_by
FROM name
JOIN name_type
ON name.name_type_id = name_type.name_type_id
ORDER BY person_id, hierarchy
'''
select_all_names_ids = '''
SELECT names, name.person_id
FROM name JOIN person
ON person.person_id = name.person_id
'''
select_all_nested_place_images = '''
SELECT DISTINCT images, caption, main_image, links_links.image_id
FROM links_links
JOIN nested_place
ON links_links.nested_place_id = nested_place.nested_place_id
JOIN image
ON image.image_id = links_links.image_id
WHERE links_links.nested_place_id = ?
'''
select_all_nested_place_strings = '''
SELECT a.place_names, b.place_names, c.place_names, d.place_names,
e.place_names, f.place_names, g.place_names, h.place_names, i.place_names,
nested_place_id
FROM nested_place
JOIN place_name a ON a.place_id = nest0
JOIN place_name b ON b.place_id = nest1
JOIN place_name c ON c.place_id = nest2
JOIN place_name d ON d.place_id = nest3
JOIN place_name e ON e.place_id = nest4
JOIN place_name f ON f.place_id = nest5
JOIN place_name g ON g.place_id = nest6
JOIN place_name h ON h.place_id = nest7
JOIN place_name i ON i.place_id = nest8
WHERE nest0 != 1 or nest1 != 1 or nest2 != 1 or nest3 != 1 or nest4 != 1 or nest5 != 1 or nest6 != 1 or nest7 != 1 or nest8 != 1
'''
select_all_person_ids = '''
SELECT person_id FROM person
'''
select_all_person_images = '''
SELECT DISTINCT images, caption, main_image, links_links.image_id
FROM links_links
JOIN person
ON links_links.person_id = person.person_id
JOIN image
ON image.image_id = links_links.image_id
WHERE links_links.person_id = ?
'''
select_all_place_ids = '''
SELECT place_id
FROM place
'''
select_all_place_names = '''
SELECT place_names
FROM place_name
'''
select_all_place_string_ids = '''
SELECT a.place_id, b.place_id, c.place_id, d.place_id,
e.place_id, f.place_id, g.place_id, h.place_id, i.place_id
FROM nested_place
JOIN place a ON a.place_id = nest0
JOIN place b ON b.place_id = nest1
JOIN place c ON c.place_id = nest2
JOIN place d ON d.place_id = nest3
JOIN place e ON e.place_id = nest4
JOIN place f ON f.place_id = nest5
JOIN place g ON g.place_id = nest6
JOIN place h ON h.place_id = nest7
JOIN place i ON i.place_id = nest8
WHERE nest0 != 1
'''
select_all_repository_strings = '''
SELECT repositories
FROM repository
'''
select_all_source_images = '''
SELECT images, caption, main_image, links_links.image_id
FROM links_links
JOIN source
ON links_links.source_id = source.source_id
JOIN image
ON image.image_id = links_links.image_id
WHERE links_links.source_id = ?
'''
select_all_sources = '''
SELECT sources FROM source
'''
select_app_setting_builtin_default_images = '''
SELECT default_image_male, default_image_female, default_image_unisex,
default_image_nested_place, default_image_source
FROM app_setting
WHERE app_setting_id = 1
'''
select_app_setting_default_images = '''
SELECT image_male, image_female, image_unisex, image_nested_place, image_source,
default_image_male, default_image_female, default_image_unisex,
default_image_nested_place, default_image_source
FROM app_setting
WHERE app_setting_id = 1
'''
select_app_setting_openpic_dir = '''
SELECT openpic_dir, default_openpic_dir
FROM app_setting
WHERE app_setting_id = 1
'''
select_app_setting_user_images = '''
SELECT image_male, image_female, image_unisex, image_nested_place, image_source
FROM app_setting
WHERE app_setting_id = 1
'''
select_assertion_count_finding = '''
SELECT COUNT(assertion_id)
FROM assertion
WHERE finding_id = ?
'''
select_assertion_description = '''
SELECT assertion_id, event_type_id, citation_id, surety
FROM assertion
WHERE assertion_id = ?
'''
select_assertion_ids_by_finding = '''
SELECT assertion_id, names, dates, places, particulars,
ages, roles
FROM assertion
WHERE finding_id = ?
'''
select_assertion_no_finding = '''
SELECT assertion_id, citation_id, event_type_id, dates, places,
particulars, ages, names, roles, surety
FROM assertion
WHERE finding_id is null
'''
select_birth_names_ids = '''
SELECT names, name.person_id, sort_order
FROM name JOIN person
ON person.person_id = name.person_id
WHERE name_type_id = 1
'''
select_citation_id = '''
SELECT citation_id FROM assertion WHERE assertion_id = ?
'''
select_citation_string_source = '''
SELECT citations, citation.source_id, sources
FROM citation
JOIN source ON source.source_id = citation.source_id
WHERE citation_id = ?
'''
select_citations_per_source = '''
SELECT citation_id, citations
FROM citation
JOIN source
ON citation.source_id = source.source_id
WHERE sources = ?
'''
select_closing_state_openpic = '''
SELECT openpic
FROM closing_state
WHERE closing_state_id = 1
'''
select_closing_state_recent_files = '''
SELECT recent_files
FROM closing_state
WHERE closing_state_id = 1
'''
select_closing_state_prior_tree = '''
SELECT prior_tree
FROM closing_state
WHERE closing_state_id = 1
'''
select_color_scheme_by_id = '''
SELECT bg, highlight_bg, head_bg, fg
FROM color_scheme
WHERE color_scheme_id = ?
'''
select_color_scheme_current_id = '''
SELECT color_scheme_id
FROM current
WHERE current_id = 1
'''
select_count_finding_id_sources = '''
SELECT COUNT(finding_id)
FROM assertion
WHERE finding_id = ?
'''
select_count_findings_roles = '''
SELECT COUNT (links_links_id)
FROM links_links
WHERE finding_id = ?
AND role_type_id IS NOT null
'''
select_count_place_id = '''
SELECT COUNT (place_id)
FROM place WHERE place_id = ?
'''
select_current_image_directory = '''
SELECT image_directory
FROM current
WHERE current_id = 1
'''
select_current_person = '''
SELECT current.person_id, names
FROM name
JOIN person
ON person.person_id = name.person_id
JOIN current
ON person.person_id = current.person_id
'''
select_current_person_id = '''
SELECT person_id
FROM current
WHERE current_id = 1
'''
select_current_person_image = '''
SELECT images
FROM image
JOIN links_links
ON image.image_id = links_links.image_id
WHERE main_image = 1
AND links_links.person_id = ?
'''
select_current_person_nested_place_source = '''
SELECT person_id, nested_place_id, source_id
FROM current
WHERE current_id = 1
'''
select_current_nested_place_id = '''
SELECT nested_place_id
FROM current
WHERE current_id = 1
'''
select_current_source_id = '''
SELECT source_id
FROM current
WHERE current_id = 1
'''
select_default_date_format = '''
SELECT default_date_formats, default_abt, default_est, default_cal,
default_bef_aft, default_bc_ad, default_os_ns, default_span,
default_range
FROM default_date_format
WHERE default_date_format_id = 1
'''
select_closing_state_tree_is_open = '''
SELECT tree_is_open
FROM closing_state
WHERE closing_state_id = 1
'''
select_date_format = '''
SELECT date_formats, abt, est, cal, bef_aft, bc_ad, os_ns, span, range
FROM date_format
WHERE date_format_id = 1
'''
select_date_finding = '''
SELECT date
FROM finding
WHERE finding_id = ?
'''
select_default_format_font_size = '''
SELECT default_font_size
FROM default_format
WHERE default_format_id = 1
'''
select_default_formats = '''
SELECT
default_bg,
default_highlight_bg,
default_head_bg,
default_fg,
default_output_font,
default_input_font,
default_font_size
FROM default_format
WHERE default_format_id = 1
'''
select_event_type_after_death = '''
SELECT event_types
FROM event_type
WHERE after_death = 1
'''
select_event_type_after_death_bool = '''
SELECT after_death
FROM event_type
WHERE event_types = ?
'''
select_event_type_couple_bool = '''
SELECT couple
FROM event_type
WHERE event_types = ?
'''
select_event_type_by_finding = '''
SELECT event_types
FROM event_type
JOIN finding
ON finding.event_type_id = event_type.event_type_id
WHERE finding_id = ?
'''
select_event_type_id = '''
SELECT event_type_id, couple
FROM event_type
WHERE event_types = ?
'''
select_event_type_id_by_string = '''
SELECT event_type_id
FROM event_type
WHERE event_types = ?
'''
select_event_type_string = '''
SELECT event_types
FROM event_type
WHERE event_type_id = ?
'''
select_finding_couple_details_by_finding = '''
SELECT person_id1, a.kin_types, person_id2, b.kin_types
FROM finding
JOIN kin_type as a
ON a.kin_type_id = finding.kin_type_id1
JOIN kin_type as b
ON b.kin_type_id = finding.kin_type_id2
WHERE finding_id = ?
'''
select_finding_couple_details_include_nulls = '''
SELECT r.person_id1, a.kin_types, q.person_id2, b.kin_types
FROM finding AS q
LEFT JOIN finding AS r
ON r.finding_id = q.finding_id
LEFT JOIN kin_type AS b
ON b.kin_type_id = q.kin_type_id1
LEFT JOIN kin_type AS a
ON a.kin_type_id = r.kin_type_id2
WHERE q.finding_id = ?
'''
select_finding_date = '''
SELECT date
FROM finding
WHERE finding_id = ?
'''
select_finding_date_and_sorter = '''
SELECT date, date_sorter
FROM finding
WHERE finding_id = ?
'''
select_finding_death_date = '''
SELECT date, finding_id
FROM finding
WHERE person_id = ?
AND event_type_id = 4
'''
select_finding_death_by_person = '''
SELECT date
FROM finding
WHERE person_id = ?
AND event_type_id = 4
'''
select_finding_details = '''
SELECT finding_id, date, event_types
FROM finding
JOIN event_type
ON finding.event_type_id = event_type.event_type_id
WHERE finding_id = ?
'''
select_finding_details_sorter = '''
SELECT finding_id, date_sorter, event_type_id
FROM finding
WHERE person_id = ?
AND event_type_id in (48, 83, 95)
'''
select_finding_event_type = '''
SELECT event_type_id
FROM finding
WHERE finding_id = ?
'''
select_finding_father = '''
SELECT person_id1
FROM finding
WHERE kin_type_id1 = 1
AND finding_id = ?
'''
select_finding_id_adoption = '''
SELECT finding_id
FROM finding
WHERE event_type_id = 83
AND person_id = ?
'''
select_finding_id_birth = '''
SELECT finding_id
FROM finding
WHERE event_type_id = 1
AND person_id = ?
'''
select_finding_id_by_person_and_event = '''
SELECT finding_id
FROM finding
WHERE person_id = (SELECT person_id FROM finding WHERE finding_id = ?)
AND event_type_id = 1
'''
select_finding_id_death = '''
SELECT finding_id
FROM finding
WHERE event_type_id = 4
AND person_id = ?
'''
select_finding_id_fosterage = '''
SELECT finding_id
FROM finding
WHERE event_type_id = 95
AND person_id = ?
'''
select_finding_id_guardianship = '''
SELECT finding_id
FROM finding
WHERE event_type_id = 48
AND person_id = ?
'''
select_finding_id_age1_alt_parents = '''
SELECT finding_id, age1
FROM finding
WHERE person_id1 = ?
AND kin_type_id1 in (1, 2, 110, 111, 112, 120, 121, 122, 130, 131)
'''
select_finding_id_age2_alt_parents = '''
SELECT finding_id, age2
FROM finding
WHERE person_id2 = ?
AND kin_type_id2 in (1, 2, 110, 111, 112, 120, 121, 122, 130, 131)
'''
select_finding_kin_types = '''
SELECT kin_type_id1, kin_type_id2
FROM finding
WHERE finding_id = ?
'''
select_finding_mother = '''
SELECT person_id2
FROM finding
WHERE kin_type_id2 = 2
AND finding_id = ?
'''
select_finding_person_date_alt_parent_event = '''
SELECT person_id, date
FROM finding
WHERE finding_id = ?
AND event_type_id in (48, 83, 95)
'''
select_finding_person_date_by_finding_and_type = '''
SELECT person_id, date
FROM finding
WHERE finding_id = ?
AND event_type_id = 1
'''
select_finding_persons = '''
SELECT person_id1, person_id2
FROM finding
WHERE finding_id = ?
'''
select_finding_nested_place = '''
SELECT a.place_names, b.place_names, c.place_names, d.place_names,
e.place_names, f.place_names, g.place_names, h.place_names, i.place_names
FROM finding
JOIN nested_place ON finding.nested_place_id = nested_place.nested_place_id
JOIN place_name a ON a.place_id = nest0
JOIN place_name b ON b.place_id = nest1
JOIN place_name c ON c.place_id = nest2
JOIN place_name d ON d.place_id = nest3
JOIN place_name e ON e.place_id = nest4
JOIN place_name f ON f.place_id = nest5
JOIN place_name g ON g.place_id = nest6
JOIN place_name h ON h.place_id = nest7
JOIN place_name i ON i.place_id = nest8
WHERE finding_id = ?
AND nest0 != 1
'''
select_finding_nested_place_id = '''
SELECT nested_place_id
FROM finding
WHERE finding_id = ?
'''
select_finding_sorter = '''
SELECT date_sorter
FROM finding
WHERE finding_id = ?
'''
select_findings_details_couple = '''
SELECT person_id1, age1, a.kin_types,
person_id2, age2, b.kin_types
FROM finding
JOIN kin_type as a
ON a.kin_type_id = kin_type_id1
JOIN kin_type as b
ON b.kin_type_id = kin_type_id2
WHERE finding_id = ?
'''
select_findings_details_couple_generic = '''
SELECT event_types, date, date_sorter, particulars
FROM finding
JOIN event_type
ON finding.event_type_id = event_type.event_type_id
WHERE finding_id = ?
'''
select_findings_details_generic = '''
SELECT event_types, particulars, age, date, date_sorter
FROM finding
JOIN event_type
ON finding.event_type_id = event_type.event_type_id
WHERE finding_id = ?
'''
select_finding_details_offspring_alt_parentage = '''
SELECT date, date_sorter, particulars
FROM finding
WHERE person_id = ?
AND event_type_id IN (1, 48, 83, 95)
AND finding_id = ?
'''
select_findings_for_person = '''
SELECT event_types
FROM finding
JOIN event_type
ON finding.event_type_id = event_type.event_type_id
WHERE person_id = ?
'''
select_findings_notes_order = '''
SELECT note_topic_order, links_links_id
FROM links_links
WHERE finding_id = ?
AND note_id IS NOT null
'''
select_finding_couple_person1_details = '''
SELECT finding_id, person_id1, kin_type_id1,
person_id2, kin_type_id2
FROM finding
WHERE person_id1 = ? AND kin_type_id1 = 1
'''
select_finding_couple_person2_details = '''
SELECT finding_id, person_id1, kin_type_id1,
person_id2, kin_type_id2
FROM finding
WHERE person_id2 = ? AND kin_type_id2 = 2
'''
select_finding_couple_details = '''
SELECT finding_id, person_id1, kin_type_id1,
person_id2, kin_type_id2
FROM finding
WHERE finding_id = ?
'''
select_finding_couple_details_alt_parent1 = '''
SELECT finding_id, person_id1, kin_type_id1,
person_id2, kin_type_id2
FROM finding
WHERE person_id1 = ? AND kin_type_id1 IN (
110, 111, 112, 120, 121, 122, 130, 131)
'''
select_finding_couple_details_alt_parent2 = '''
SELECT finding_id, person_id1, kin_type_id1,
person_id2, kin_type_id2
FROM finding
WHERE person_id2 = ? AND kin_type_id1 IN (
110, 111, 112, 120, 121, 122, 130, 131)
'''
select_format_font_size = '''
SELECT font_size, default_font_size
FROM format
WHERE format_id = 1
'''
select_finding_person = '''
SELECT finding_id
FROM finding
WHERE person_id = ?
'''
select_format_font_scheme = '''
SELECT output_font, font_size, default_output_font, default_font_size
FROM format
WHERE format_id = 1
'''
select_gender = '''
SELECT gender
FROM person
WHERE person_id = ?
'''
select_image_caption = '''
SELECT caption
FROM image
WHERE image_id = ?
'''
select_image_id = '''
SELECT image_id FROM image WHERE images = ?
'''
select_images_all = '''
SELECT images, image_id FROM image
'''
# why join to person here?
select_links_links_main_image_person = '''
SELECT images
FROM links_links
JOIN person
ON links_links.person_id = person.person_id
JOIN image
ON image.image_id = links_links.image_id
WHERE main_image = 1
AND links_links.person_id = ?
'''
# TRIED IT DIDN'T WORK
select_links_links_main_image_nested_place = '''
SELECT images
FROM links_links
JOIN nested_place
ON links_links.nested_place_id = nested_place.nested_place_id
JOIN image
ON image.image_id = links_links.image_id
WHERE main_image = 1
AND links_links.nested_place_id = ?
'''
# ORIGINAL
# select_links_links_main_image_place = '''
# SELECT images
# FROM links_links
# JOIN place
# ON links_links.place_id = place.place_id
# JOIN image
# ON image.image_id = links_links.image_id
# WHERE main_image = 1
# AND links_links.place_id = ?
# '''
select_links_links_main_image_source = '''
SELECT images
FROM links_links
JOIN source
ON links_links.source_id = source.source_id
JOIN image
ON image.image_id = links_links.image_id
WHERE main_image = 1
AND links_links.source_id = ?
'''
select_kin_type_alt_parent = '''
SELECT kin_types, kin_type_id
FROM kin_type
WHERE kin_code = 'B'
AND kin_type_id NOT IN (1, 2, 3, 26, 27, 28)
'''
select_kin_type_string = '''
SELECT kin_types FROM kin_type WHERE kin_type_id = ?
'''
select_kin_types = '''
SELECT kin_types
FROM kin_type
WHERE kin_type_id = ?
'''
select_kin_types_parental = '''
SELECT kin_type_id, kin_types
FROM kin_type
WHERE kin_code = 'B'
AND hidden = 0
'''
select_links_links_assertions_notes = '''
SELECT links_links.note_id, notes
FROM links_links
JOIN note ON note.note_id = links_links.note_id
WHERE assertion_id = ?
'''
select_links_links_count_image_person = '''
SELECT COUNT(image_id)
FROM links_links
WHERE person_id = ?
'''
select_links_links_count_image_nested_place = '''
SELECT COUNT(image_id)
FROM links_links
WHERE nested_place_id = ?
'''
select_links_links_count_image_source = '''
SELECT COUNT(image_id)
FROM links_links
WHERE source_id = ?
'''
select_links_links_person_main_image = '''
SELECT links_links_id, image_id, main_image
FROM links_links
WHERE image_id is not null
AND person_id = ?
ORDER BY main_image DESC
'''
select_links_links_nested_place_main_image = '''
SELECT links_links_id, image_id, main_image
FROM links_links
WHERE image_id is not null
AND nested_place_id = ?
ORDER BY main_image DESC
'''
select_links_links_source_main_image = '''
SELECT links_links_id, image_id, main_image
FROM links_links
WHERE image_id is not null
AND source_id = ?
ORDER BY main_image DESC
'''
select_links_links_notes_assertions = '''
SELECT links_links_id
FROM links_links
JOIN note
ON note.note_id = links_links.note_id
WHERE topic = ?
AND links_links.assertion_id = ?
'''
select_links_links_notes_findings = '''
SELECT links_links_id
FROM links_links
JOIN note
ON note.note_id = links_links.note_id
WHERE topic = ?
AND links_links.finding_id = ?
'''
select_locator_string_by_repo_and_citation = '''
SELECT repository_id, locator_id, locators
FROM locator
WHERE citation_id = ?
'''
select_locators_by_repo = '''
SELECT locators
FROM locator
WHERE (
SELECT COUNT(links_links_id)
FROM links_links
WHERE links_links.repository_id = ? AND source_id = ?) = 1 AND locator.repository_id = ?
'''
select_max_event_type_id = '''
SELECT MAX(event_type_id) FROM event_type
'''
select_max_name_type_id = '''
SELECT MAX(name_type_id) FROM name_type
'''
select_max_kin_type_id = '''
SELECT MAX(kin_type_id) FROM kin_type
'''
select_max_person_id = '''
SELECT MAX(person_id) FROM person
'''
select_max_place_id = ''' SELECT MAX(place_id) FROM place '''
select_name_all_current = '''
SELECT name_id, names, name_types
FROM name
JOIN name_type
ON name.name_type_id = name_type.name_type_id
WHERE person_id = ?
'''
select_name_details = '''
SELECT names, name_types, used_by
FROM name
LEFT JOIN name_type
ON name.name_type_id = name_type.name_type_id
WHERE person_id = ?
'''
select_name_id_by_person_id = '''
SELECT name_id
FROM name
WHERE person_id = ?
'''
select_name_sort_order = '''
SELECT sort_order
FROM name
JOIN person
ON person.person_id = name.person_id
WHERE name.person_id = ?
AND name_type_id = 1
'''
select_name_sorter = '''
SELECT names, sort_order
FROM name
JOIN person
ON person.person_id = name.person_id
WHERE name.person_id = ?
AND name_type_id = 1
'''
select_name_type_hierarchy = '''
SELECT name_types
FROM name_type
ORDER BY hierarchy
'''
select_name_type_hierarchy_by_id = '''
SELECT name_type_id
FROM name_type
ORDER BY hierarchy
'''
select_name_type_id = '''
SELECT name_type_id
FROM name_type
WHERE name_types = ?
'''
select_name_with_id = '''
SELECT names
FROM name JOIN person
ON name.person_id = person.person_id
WHERE name_type_id = 1
AND name.person_id = ?
'''
select_name_type_id_by_string = '''
SELECT name_type_id
FROM name_type
WHERE name_types = ?
'''
select_name_type_sorter_with_id = '''
SELECT names, name_types, sort_order
FROM name
JOIN person
ON name.person_id = person.person_id
JOIN name_type
ON name_type.name_type_id = name.name_type_id
WHERE name.person_id = ?
'''
select_name_with_id_any = '''
SELECT names, name_types
FROM name
JOIN person
ON name.person_id = person.person_id
JOIN name_type
ON name_type.name_type_id = name.name_type_id
WHERE name.person_id = ?
'''
select_nested_place_by_id = '''
SELECT place_names
FROM place_name
WHERE place_id = ?
AND main_place_name = 1
'''
select_nested_place_ids = '''
SELECT nest0, nest1, nest2, nest3, nest4, nest5, nest6, nest7, nest8
FROM nested_place
WHERE nested_place_id = ?
'''
select_nested_place_inclusion = '''
SELECT a.place_names, b.place_names, c.place_names, d.place_names,
e.place_names, f.place_names, g.place_names, h.place_names, i.place_names
FROM nested_place
JOIN place_name as a ON a.place_id = nest0
JOIN place_name as b ON b.place_id = nest1
JOIN place_name as c ON c.place_id = nest2
JOIN place_name as d ON d.place_id = nest3
JOIN place_name as e ON e.place_id = nest4
JOIN place_name as f ON f.place_id = nest5
JOIN place_name as g ON g.place_id = nest6
JOIN place_name as h ON h.place_id = nest7
JOIN place_name as i ON i.place_id = nest8
WHERE nest0 = ? or nest1 = ? or nest2 = ? or nest3 = ? or nest4 = ? or nest5 = ? or nest6 = ? or nest7 = ? or nest8 = ?
'''
select_notes_per_assertion = '''
SELECT topic, notes
FROM note
JOIN links_links
ON links_links.note_id = note.note_id
WHERE assertion_id = ?
ORDER BY note_topic_order
'''
select_notes_per_finding = '''
SELECT topic, notes
FROM note
JOIN links_links
ON links_links.note_id = note.note_id
WHERE finding_id = ?
ORDER BY note_topic_order
'''
select_note_id = '''
SELECT note_id
FROM note
WHERE topic = ?
'''
select_note_id_text = '''
SELECT note_id, notes
FROM note
WHERE topic = ?
'''
select_note_privacy = '''
SELECT private
FROM note
WHERE topic = ?
'''
select_opening_settings = '''
SELECT default_bg, default_highlight_bg, default_head_bg,
default_fg, default_output_font, default_input_font, default_font_size
FROM default_format
WHERE default_format_id = 1
'''
select_opening_settings_on_load = '''
SELECT
default_bg,
default_highlight_bg,
default_head_bg,
default_fg,
default_output_font,
default_input_font,
default_font_size
FROM default_format
WHERE default_format_id = 1
'''
select_person = '''
SELECT person_id
FROM finding
WHERE finding_id = ?
'''
select_person_birth_date = '''
SELECT
finding_id,
date
FROM person
JOIN finding
ON finding.person_id = person.person_id
JOIN event_type
ON finding.event_type_id = event_type.event_type_id
WHERE finding.person_id = ?
AND finding.event_type_id = 1
'''
select_person_death_date = '''
SELECT date
FROM person
JOIN finding
ON finding.person_id = person.person_id
JOIN event_type
ON finding.event_type_id = event_type.event_type_id
WHERE finding.person_id = ?
AND finding.event_type_id = 4
'''
select_person_distinct_like = '''
SELECT DISTINCT
person.person_id
FROM person
JOIN name
ON person.person_id = name.person_id
WHERE names LIKE ?
OR person.person_id LIKE ?
'''
select_person_gender = '''
SELECT gender
FROM person
JOIN name
ON person.person_id = name.person_id
WHERE names = ? AND name_type_id = 1
'''
select_person_gender_by_id = '''
SELECT gender
FROM person
WHERE person_id = ?
'''
select_person_id_birth = '''
SELECT person_id
FROM finding
WHERE finding_id = ?
AND event_type_id = 1
'''
select_person_id_alt_parentage = '''
SELECT person_id
FROM finding
WHERE finding_id = ?
AND event_type_id in (110, 111, 112, 120, 121, 122, 130, 131)
'''
select_person_id_finding = '''
SELECT person_id
FROM finding
WHERE finding_id = ?
'''
select_place_id_with_name = '''
SELECT place_id
FROM place_name
WHERE place_names = ?
'''
select_place_name_from_id = '''
SELECT place_names
FROM place_name
WHERE place_id = ?
'''
select_preferences = '''
SELECT use_default_images
FROM preferences
WHERE preferences_id = 1
'''
select_repo_id_by_name = '''
SELECT repository_id
FROM repository
WHERE repositories = ?
'''
select_repository_details = '''
SELECT repositories, repository_type
FROM repository
WHERE repository_id = ?
'''
select_roles = '''
SELECT
links_links_id,
role_types,
person_id,
links_links.role_type_id
FROM role_type
JOIN links_links
ON role_type.role_type_id = links_links.role_type_id
WHERE finding_id = ?
'''
select_role_type_by_id = '''
SELECT role_types
FROM role_type
WHERE role_type_id = ?
'''
select_role_types = '''
SELECT role_types
FROM role_type
'''
select_role_type_id = '''
SELECT role_type_id
FROM role_type
WHERE role_types = ?
'''
select_source_by_id = '''
SELECT sources FROM source WHERE source_id = ?
'''
select_source_id = '''
SELECT source_id FROM citation WHERE citation_id = ?
'''
select_source_id_by_string = '''
SELECT source_id
FROM source
WHERE sources = ?
'''
select_to_do = '''
SELECT to_do_id, to_dos
FROM to_do
ORDER BY priority
'''
update_app_setting_image_female = '''
UPDATE app_setting
SET image_female = ?
WHERE app_setting_id = 1
'''
update_app_setting_image_male = '''
UPDATE app_setting
SET image_male = ?
WHERE app_setting_id = 1
'''
update_app_setting_image_unisex = '''
UPDATE app_setting
SET image_unisex = ?
WHERE app_setting_id = 1
'''
update_app_setting_image_nested_place = '''
UPDATE app_setting
SET image_nested_place = ?
WHERE app_setting_id = 1
'''
update_app_setting_image_source = '''
UPDATE app_setting
SET image_source = ?
WHERE app_setting_id = 1
'''
update_app_setting_delete_user_images = '''
UPDATE app_setting
SET (image_male, image_female, image_unisex, image_nested_place,
image_source) = ("", "", "", "", "")
WHERE app_setting_id = 1
'''
update_assertion_age = '''
UPDATE assertion
SET ages = ?
WHERE assertion_id = ?
'''
update_assertion_citation = '''
UPDATE assertion
SET citation_id = ?
WHERE assertion_id = ?
'''
update_assertion_date = '''
UPDATE assertion
SET dates = ?
WHERE assertion_id = ?
'''
update_assertion_delete_finding = '''
UPDATE assertion
SET finding_id = null
WHERE finding_id = ?
'''
update_assertion_event_type = '''
UPDATE assertion
SET event_type_id = ?
WHERE assertion_id = ?
'''
update_assertion_name = '''
UPDATE assertion
SET names = ?
WHERE assertion_id = ?
'''
update_assertion_particulars = '''
UPDATE assertion
SET particulars = ?
WHERE assertion_id = ?
'''
update_assertion_place = '''
UPDATE assertion
SET places = ?
WHERE assertion_id = ?
'''
update_assertion_role = '''
UPDATE assertion
SET roles = ?
WHERE assertion_id = ?
'''
update_assertion_surety = '''
UPDATE assertion
SET surety = ?
WHERE assertion_id = ?
'''
update_assertion_link_finding = '''
UPDATE assertion
SET finding_id = ?
WHERE assertion_id = ?
'''
update_assertion_unlink_finding = '''
UPDATE assertion
SET finding_id = null
WHERE assertion_id = ?
'''
update_closing_state_openpic = '''
UPDATE closing_state
SET openpic = ?
WHERE closing_state_id = 1
'''
update_closing_state_recent_files = '''
UPDATE closing_state
SET recent_files = ?
WHERE closing_state_id = 1
'''
update_closing_state_tree = '''
UPDATE closing_state
SET prior_tree = ?
WHERE closing_state_id = 1
'''
update_closing_state_tree_is_closed = '''
UPDATE closing_state
SET tree_is_open = 0
WHERE closing_state_id = 1
'''
update_closing_state_tree_is_open = '''
UPDATE closing_state
SET tree_is_open = 1
WHERE closing_state_id = 1
'''
update_color_scheme_hide = '''
UPDATE color_scheme
SET hidden = 1
WHERE color_scheme_id = ?
'''
update_current_color_scheme = '''
UPDATE current
SET color_scheme_id = ?
WHERE current_id = 1
'''
update_current_color_scheme_default = '''
UPDATE current
SET color_scheme_id = 1
WHERE current_id = 1
'''
update_current_image_directory = '''
UPDATE current
SET image_directory = ?
WHERE current_id = 1
'''
update_current_person = '''
UPDATE current
SET person_id = ?
WHERE current_id = 1
'''
update_current_person_to_1 = '''
UPDATE current
SET person_id = 1
WHERE current_id = 1
'''
update_date_format_abt = '''
UPDATE date_format
SET abt = ?
WHERE date_format_id = 1
'''
update_date_format_befaft = '''
UPDATE date_format
SET bef_aft = ?
WHERE date_format_id = 1
'''
update_date_format_cal = '''
UPDATE date_format
SET cal = ?
WHERE date_format_id = 1
'''
update_date_format_date_formats = '''
UPDATE date_format
SET date_formats = ?
WHERE date_format_id = 1
'''
update_date_format_epoch = '''
UPDATE date_format
SET bc_ad = ?
WHERE date_format_id = 1
'''
update_date_format_est = '''
UPDATE date_format
SET est = ?
WHERE date_format_id = 1
'''
update_date_format_julegreg = '''
UPDATE date_format
SET os_ns = ?
WHERE date_format_id = 1
'''
update_date_format_range = '''
UPDATE date_format
SET range = ?
WHERE date_format_id = 1
'''
update_date_format_span = '''
UPDATE date_format
SET span = ?
WHERE date_format_id = 1
'''
update_event_types = '''
UPDATE finding
SET event_type_id = ?
WHERE finding_id = ?
'''
update_finding_age = '''
UPDATE finding
SET age = ?
WHERE finding_id = ?
'''
update_finding_age1 = '''
UPDATE finding
SET age1 = ?
WHERE finding_id = ?
'''
update_finding_age1_blank = '''
UPDATE finding
SET age1 = ""
WHERE finding_id = ?
'''
update_finding_age2 = '''
UPDATE finding
SET age2 = ?
WHERE finding_id = ?
'''
update_finding_age2_blank = '''
UPDATE finding
SET age2 = ""
WHERE finding_id = ?
'''
update_finding_ages_kintypes_null = '''
UPDATE finding
SET (age1, kin_type_id1, age2, kin_type_id2) = ('', null, '', null)
WHERE finding_id = ?
'''
update_finding_date = '''
UPDATE finding
SET (date, date_sorter) = (?, ?)
WHERE finding_id = ?
'''
update_finding_father = '''
UPDATE finding
SET (person_id1, kin_type_id1) = (?, 1)
WHERE finding_id = ?
'''
update_finding_kin_type_1 = '''
UPDATE finding
SET kin_type_id1 = ?
WHERE finding_id = ?
'''
update_finding_kin_type_2 = '''
UPDATE finding
SET kin_type_id2 = ?
WHERE finding_id = ?
'''
update_finding_mother = '''
UPDATE finding
SET (person_id2, kin_type_id2) = (?, 2)
WHERE finding_id = ?
'''
update_finding_nested_place = '''
UPDATE finding
SET nested_place_id = ?
WHERE finding_id = ?
'''
update_finding_parent1_null = '''
UPDATE finding
SET (age1, kin_type_id1, person_id1) = ('', null, null)
WHERE finding_id = ?
'''
update_finding_parent2_null = '''
UPDATE finding
SET (age2, kin_type_id2, person_id2) = ('', null, null)
WHERE finding_id = ?
'''
update_finding_parents= '''
UPDATE finding
SET (person_id1, person_id2, kin_type_id1, kin_type_id2) = (?, ?, 1, 2)
WHERE finding_id = ?
'''
update_finding_parents_new = '''
UPDATE finding
SET (age1, kin_type_id1, person_id1, age2, kin_type_id2, person_id2) =
('', 1, ?, '', 2, ?)
WHERE finding_id = ?
'''
update_finding_parents_null = '''
UPDATE finding
SET (age1, kin_type_id1, person_id1, age2, kin_type_id2, person_id2)
= ('', null, null, '', null, null)
WHERE finding_id = ?
'''
update_finding_particulars = '''
UPDATE finding
SET particulars = ?
WHERE finding_id = ?
'''
update_finding_partner1 = '''
UPDATE finding
SET (person_id1, kin_type_id1) = (?, 128)
WHERE finding_id = ?
'''
update_finding_partner2 = '''
UPDATE finding
SET (person_id2, kin_type_id2) = (?, 129)
WHERE finding_id = ?
'''
update_finding_person_1_null_by_id = '''
UPDATE finding
SET person_id2 = null
WHERE finding_id = ?
'''
update_finding_person_2_null_by_id = '''
UPDATE finding
SET person_id2 = null
WHERE finding_id = ?
'''
update_finding_person_1_null = '''
UPDATE finding
SET person_id1 = null
WHERE person_id1 = ?
'''
update_finding_person_2_null = '''
UPDATE finding
SET person_id2 = null
WHERE person_id2 = ?
'''
update_finding_person_1 = '''
UPDATE finding
SET (person_id1, kin_type_id1) = (?, ?)
WHERE finding_id = ?
'''
update_finding_person_2 = '''
UPDATE finding
SET (person_id2, kin_type_id2) = (?, ?)
WHERE finding_id = ?
'''
update_nested_place_finding = '''
UPDATE nested_place
SET (nest0, nest1, nest2, nest3, nest4, nest5, nest6, nest7, nest8)
= ({})
WHERE nested_place_id = (SELECT finding.nested_place_id FROM finding WHERE finding_id = ?)
'''.format(','.join(['?'] * 9))
update_finding_nested_place_unknown = '''
UPDATE finding
SET nested_place_id = 1
WHERE finding_id = ?
'''
update_findings_notes_order = '''
UPDATE links_links
SET note_topic_order = ?
WHERE links_links_id = ?
'''
update_findings_roles_person = '''
UPDATE links_links
SET person_id = ?
WHERE links_links_id = ?
'''
update_findings_roles_role_type = '''
UPDATE links_links
SET role_type_id = ?
WHERE links_links_id = ?
'''
update_format_font = '''
UPDATE format
SET (output_font, font_size) = (?, ?)
WHERE format_id = 1
'''
update_image_caption = '''
UPDATE image
SET caption = ?
WHERE image_id = ?
'''
update_kin_type_kin_code = '''
UPDATE kin_type
SET kin_code = ?
WHERE kin_type_id = ?
'''
update_links_links_main_image = '''
UPDATE links_links
SET main_image = 1
WHERE links_links_id = ?
'''
update_links_links_main_image_person = '''
UPDATE links_links
SET main_image = 1
WHERE image_id = (
SELECT image_id
FROM image WHERE images = ?)
AND person_id =
(SELECT current.person_id
FROM current WHERE current_id = 1)
'''
update_links_links_main_image_nested_place = '''
UPDATE links_links
SET main_image = 1
WHERE image_id = (
SELECT image_id
FROM image WHERE images = ?)
AND nested_place_id =
(SELECT current.nested_place_id
FROM current WHERE current_id = 1)
'''
# update_links_links_main_image_place = '''
# UPDATE links_links
# SET main_image = 1
# WHERE image_id = (
# SELECT image_id
# FROM image WHERE images = ?)
# AND place_id =
# (SELECT current.place_id
# FROM current WHERE current_id = 1)
# '''
update_links_links_main_image_source = '''
UPDATE links_links
SET main_image = 1
WHERE image_id = (
SELECT image_id
FROM image WHERE images = ?)
AND source_id =
(SELECT current.source_id
FROM current WHERE current_id = 1)
'''
# update_links_links_image_not_main = '''
# UPDATE links_links
# SET main_image = 0
# WHERE links_links_id = ?
# '''
update_links_links_note_order_assertion = '''
UPDATE links_links
SET note_topic_order = ?
WHERE assertion_id = ?
AND note_id = ?
'''
update_links_links_note_order_finding = '''
UPDATE links_links
SET note_topic_order = ?
WHERE finding_id = ?
AND note_id = ?
'''
update_links_links_unmain_image_person = '''
UPDATE links_links
SET main_image = 0
WHERE main_image = 1
AND links_links.person_id = ?
'''
update_links_links_unmain_image_nested_place = '''
UPDATE links_links
SET main_image = 0
WHERE main_image = 1
AND links_links.nested_place_id = ?
'''
# update_links_links_unmain_image_nested_place = '''
# UPDATE links_links
# SET main_image = 0
# WHERE main_image = 1
# AND links_links.place_id = ?
# '''
update_links_links_unmain_image_source = '''
UPDATE links_links
SET main_image = 0
WHERE main_image = 1
AND links_links.source_id = ?
'''
update_name_type_sorter = '''
UPDATE name
SET (names, name_type_id, sort_order) = (?, ?, ?)
WHERE name_id = ?
'''
update_nested_place = '''
UPDATE nested_place
SET (nest0, nest1, nest2, nest3, nest4, nest5, nest6, nest7, nest8) =
(?, ?, ?, ?, ?, ?, ?, ?, ?)
WHERE nested_place_id = ?
'''
update_note_edit = '''
UPDATE note
SET notes = ?
WHERE topic = ?
'''
update_note_privacy = '''
UPDATE note
SET private = ?
WHERE topic = ?
'''
update_note_topic = '''
UPDATE note
SET topic = ?
WHERE topic = ?
'''
update_person_gender = '''
UPDATE person
SET gender = ?
WHERE person_id = ?
'''
update_preferences_default_images = '''
UPDATE preferences
SET use_default_images = ?
WHERE preferences_id = 1
'''