OpenLLM-France/wikimedia huggingface dataset:
# SQLAlchemy

SQLAlchemy is an open-source Python library that provides an SQL toolkit (called "SQLAlchemy Core") and an Object Relational Mapper (ORM) for database interactions. It allows developers to work with databases using Python objects, enabling efficient and flexible database access.

## Description

SQLAlchemy offers tools for database schema generation, querying, and object-relational mapping. Key features include:
* A comprehensive embedded domain-specific language for SQL in Python called "SQLAlchemy Core" that provides means to construct and execute SQL queries.
* A powerful ORM that allows the mapping of Python classes to database tables.
* Support for database schema migrations.
* Compatibility with multiple database backends.
* Tools for database connection pooling and transaction management.

## History

SQLAlchemy was first released in February 2006. It has evolved to include a wide range of features for database interaction and has gained popularity among Python developers. Notable versions include:
* Version 0.1 (2006): Initial release.
* Version 1.0 (2015): Major enhancements in ORM and SQL expression language.
* Version 1.4 (2021): Introduction of a new ORM API.

## Example

The following example represents an n-to-1 relationship between movies and their directors. It is shown how user-defined Python classes create corresponding database tables, how instances with relationships are created from either side of the relationship, and finally how the data can be queried — illustrating automatically generated SQL queries for both lazy and eager loading.

### Schema definition

Creating two Python classes and corresponding database tables in the DBMS:

### Data insertion

One can insert a director-movie relationship via either entity:

### Querying

SQLAlchemy issues the following query to the DBMS (omitting aliases):
The output:
Setting lazy=True (default) instead, SQLAlchemy would first issue a query to get the list of movies and only when needed (lazy) for each director a query to get the name of the corresponding director:
# Tullichewan

Tullichewan is a former estate in the Vale of Leven, near Loch Lomond, Scotland. Tullichewan Castle was built in 1792 and demolished in 1954. It was located on the western edge of Alexandria, close to the present route of the A82.

## History

Originally called Tuloch Eoghain, "the hill of Eoghan." In the 17th century it was acquired by the Colquhoun family, and was known as Tully-Colquhoun or Tillyquhoun; and then Tullichewan. The Tullichewan estate was sold by the Colquhoun clan to James Buchanan in 1792.
Tullichewan Castle was designed in 1792 by architect Robert Lugar, who also designed Balloch Castle. It is the first example in Scotland of an asymmetrical Gothic house. The Horrocks family purchased the castle in 1817, living there until 1843. The estate was then sold to William Campbell of J & W Campbell, Glasgow merchants and remained in the Campbell family until the twentieth century.
The last owner was J Scott Anderson who acquired the house around 1930. At the outbreak of World War II, Tullichewan Castle Estate was requisitioned by the Royal Navy, who retained it for the rest of the war. Tullichewan Castle Camp was put to various uses. After the war, it was used as accommodation for workers at the Royal Naval Torpedo Factory in Alexandria. After the war, Mr J Scott Anderson returned to live in the castle, until its upkeep became too much. The castle then lay abandoned until it was finally demolished by explosives in 1954.
Although modern development has consumed most of the former estate, and little remains, a number of remnants are reported to have survived. The A82 dual carriageway and the A811 road were built through the grounds, with housing developments and the Vale of Leven Hospital covering the estate. The former stables and a fragment of the original tower can still be seen from the A82. The north lodge, or gatehouse, has been lost in the area of Tullichewan Caravan Park, where the estate also had a walled orchard. The south lodge can still be found on Main Street, Alexandria, north of the entrance to Christie Park. Of the Camp, no trace remains.
# Helistano Manga

Helistano Ciro Manga (born 20 May 1999) is a Bissau-Guinean footballer who also holds Portuguese citizenship. He currently plays for the Latvian club Grobiņas SC.

## Club honors

Noah
* Armenian Cup: 2019–20
* Armenian Supercup: 2020
# Bremer Ehrler

Bremer Ehrler (July 10, 1914 – February 9, 2013) was an American politician who served as Jefferson County Judge/ Executive and the 80th Secretary of State of Kentucky.

## Early life and education

Ehrler was born in Louisville, Kentucky. As a child, he worked on his family's dairy farm. He graduated from DuPont Manual High School in 1931.

## Career

Ehrler joined the United States Army in 1942 and served until 1968, retiring as a lieutenant colonel. Ehrler worked for the United States Postal Service for 37 years, and served as postmaster of Louisville, Kentucky during the 1960s.
Ehrler was appointed Jefferson County Judge/Executive by Governor Martha Layne Collins on December 21, 1984, to fill the vacancy left by Mitch McConnell after McConnell's election to the United States Senate. Ehrler served in that post until January 6, 1986. He did not seek election to a second term, opting instead to run for secretary of state in 1987, the year after he left office. He would serve as Kentucky Secretary of State from 1988 until the end of his term in 1992.
He later was appointed Jefferson County sheriff in 1993.
# Moody (James Moody album)

Moody (also released as Moody's Workshop) is an album by saxophonist James Moody composed of sessions from 1954 with a septet arranged by Quincy Jones. The LP was released on the Prestige label.

## Reception

Professional ratings :
| Review scores ||
| Source | Rating |
| AllMusic | |
Scott Yanow, writing for AllMusic, stated: "In the mid-'50s James Moody led a four-horn septet that played music falling somewhere between bop and rhythm & blues. The danceable rhythms and riffing made its recordings somewhat accessible but the solos of Moody (on tenor and alto) and trumpeter Dave Burns also held listener's interests".

## Track listing

    All compositions by Quincy Jones, except where indicated.
* "Keepin' Up with Jonesy" – 3:14
* "Workshop" (Gil Fuller) – 3:08
* "NJR (I'm Gone)" – 3:19
* "A Hundred Years from Today" (Ned Washington, Joe Young, Victor Young) – 2:45
* "Jack Raggs" (Jack Raggs) – 2:40
* "Mambo with Moody" (James Moody, Newbolt) – 4:07
* "Over the Rainbow" (Harold Arlen, Yip Harburg) – 3:03
* "Blues in the Closet" (Oscar Pettiford) – 3:53
* "Moody's Mood for Blues" – 5:35
* "Nobody Knows the Trouble I've Seen" (Traditional) – 2:51
* "It Might as Well Be Spring" - (tenor sax take) (Oscar Hammerstein II, Richard Rodgers) – 3:51
* Recorded at Van Gelder Studio in Hackensack, New Jersey on January 8, 1954 (tracks 1-4), April 12, 1954 (tracks 5-7), September 29, 1954 (tracks 8, 9 & 11) and January 28, 1955 (track 10)

## Personnel

* James Moody – tenor saxophone, alto saxophone
* Dave Burns – trumpet
* William Shepherd – trombone
* Pee Wee Moore – baritone saxophone
* Sadik Hakim (tracks 1-4), Jimmy Boyd (tracks 5-11) – piano
* John Latham – bass
* Joe Harris (tracks 1-7), Clarence Johnston (tracks 8-11) – drums
* Quincy Jones – arranger
* Eddie Jefferson – vocal (track 2)
* Rudy Van Gelder – engineer
# WZ Sagittae

WZ Sagittae (WZ Sge) is a cataclysmic dwarf nova star system in the constellation Sagitta. It consists of a white dwarf primary being orbited by a low mass companion. The white dwarf is about 0.85 solar masses while the companion is only 0.08 solar masses. This implies that the companion is a spectral class L2 star, although this has yet to be confirmed. The distance to this system has been determined by parallax, yielding a distance of 45.1 parsecs.
WZ Sagittae is an ultrashort period cataclysmic nova, with outbursts observed in 1913, 1946, 1978 and 2001. During the well-observed 2001 outburst, the nova reached a peak visual magnitude of 8.21. The 1913 event was the brightest of the observed outbursts, reaching a photographic magnitude of 7.0.
This nova is classified as a SU Ursae Majoris class star, which is a subclass of dwarf nova that produces what are termed superoutbursts spaced several months apart, interspaced with normal outbursts every few weeks. The normal outbursts typically last 2−3 days, while a superoutburst lasts a few weeks. However, WZ Sagittae is unusual in that it is only observed to emit superbursts.
The outbursts of a dwarf nova are caused when matter from a ring-like accretion disk becomes unstable. In this system, the companion star is sufficiently close to the white dwarf that the tidal bulge of the former overlaps the Roche limit, allowing matter to pass across and accumulate onto the disk. When the disk reaches a critical temperature, the gas collapses onto the white dwarf resulting in the release of gravitational potential energy.
A superoutburst may be caused by a tidal interaction of the accretion disk with the donor star, resulting in a greater deposition of matter on the white dwarf. In the case of WZ Sagittae, however, magnetic effects may act to enhance the deposition, resulting in the lack of normal outbursts. Because of the unique timing differences in the rate of superoutbursts of this nova, it been designated the prototype star for a WZ Sagittae subclass.
The orbital period of this system is 1.361 hours. Based upon observations of eclipses of the hot spot on the white dwarf (created by infalling material), the orbital plane of this system is inclined by 76° ± 6° to the line of sight from the Earth.
# Leylan (disambiguation)

Leylan is a city in East Azerbaijan Province, Iran.
Leylan (Persian: ليلان) may also refer to various places in Iran:
* Leylan, Hamadan
* Leylan, alternate name of Lilas, Hamadan Province
* Leylan, Markazi
* Leylan, Zanjan
* Leylan District, in East Azerbaijan Province
* Leylan-e Jonubi Rural District, in East Azerbaijan Province
* Leylan-e Shomali Rural District, in East Azerbaijan Province
Leylan can also refer to places outside of Iran:
# Viktor Berko

Viktor Berko (Ukrainian: Віктор Юрійович Берко; born 21 September 1992) is a Ukrainian football forward who last played for Livyi Bereh Kyiv.

## Career

Berko is a product of FC Zelenyi Hai Voznesensk playing at the Ukrainian Youth Football League.
Until 2012 he stayed with his home team playing in regional competitions. After that Berko moved to the main football club of the region playing at professional level.
He debuted at professional level on 3 April 2012 in the game against FC Odesa which was tied at 0. His first goal he scored on 3 May 2012 in 2–4 loss against FC Helios Kharkiv.
# Wroników

Wroników is a village in the administrative district of Gmina Rozprza, within Piotrków County, Łódź Voivodeship, in central Poland. It lies approximately 4 kilometres (2 mi) west of Rozprza, 14 km (9 mi) south-west of Piotrków Trybunalski, and 55 km (34 mi) south of the regional capital Łódź.
# Woodmere Art Museum

Woodmere Art Museum, located in the Chestnut Hill section of Philadelphia, Pennsylvania, has a collection of paintings, prints, sculpture and photographs focusing on artists from the Delaware Valley and includes works by Thomas Pollock Anshutz, Severo Antonelli, Jasper Francis Cropsey (The Spirit of Peace), Joan Wadleigh Curran, Daniel Garber, Edward Moran, Violet Oakley, Herbert Pullinger, Edward Willis Redfield, Nelson Shanks, Jessie Willcox Smith, Benjamin West (The Fatal Wounding of Sir Philip Sidney), Philip Jamison, Barbara Bullock and N. C. Wyeth (Anthony and Mr. Bonnyfeather).
The collection includes the Violet Oakley lunette paintings of The Child and Tradition, Youth and the Arts, and Man and Science.

## Classes

Woodmere provides art classes for adults and children and conducts a variety of special events and exhibitions including gallery talks, field trips, lectures, concerts and an annual juried exhibition.

## History

The museum was opened in 1940, founded by Charles Knox Smith (1845–1916), an oil and mining businessman, in his will. Smith was born in the Kensington neighborhood of Philadelphia and began his career as a grocer's boy and as an oil wagon driver. He rose to become a partner in that oil firm and subsequently invested in his own oil brokerage and a gold and silver mining company in Mexico.
Smith's collection of paintings, sculpture and antiques form the base of the permanent collection. It is housed in his Victorian mansion, Woodmere, to which Smith had added large exhibition spaces.

## Collection highlights

* Sailing before a Gale (undated), by Alfred Thompson Bricher
* The Pink Sash (1898), by Mary Cassatt
* Sunset in the Berkshire Hills (1857), by Frederic Edwin Church
* The Spirit of Peace (1851), by Jasper Francis Cropsey
* Fruit and Flowers (undated), by David de Noter [nl]
* Columbus and the Egg (1847), by Johann Geyer
* A Dream of Italy (undated), by William Louis Sonntag Sr.
* The Fatal Wounding of Sir Philip Sidney (1805), by Benjamin West
# The Gold Bug Variations

The Gold Bug Variations is a novel by American writer Richard Powers, first released in 1991.

## Plot introduction

The novel intertwines the discovery of the chemical structure of DNA with the musicality of Johann Sebastian Bach's harpsichord composition the Goldberg Variations. A similar theme is explored by Douglas Hofstadter in his 1979 book Gödel, Escher, Bach: an Eternal Golden Braid, and the title also alludes to Edgar Allan Poe's 1843 short story "The Gold-Bug", which is also incorporated in the plot of the novel.
The plot hinges on two love affairs: the first set in the 1950s, between two scientists intent on discovering the mysteries of DNA; the second in the 1980s, between two lovers who befriend the scientist featured in the novel's flashbacks.

## Awards

The Gold Bug Variations has received the following awards:
* Time Book of the Year, 1991
* Publishers Weekly Best Books of 1991
* Vrij Nederland Best Books of 1991
* The New York Times Notable Book, 1991
* De Morgen Best Book of 1991 (named in 1999, in a compilation of the best books each year over the last half century)
* Finalist, National Book Critics Circle Award for Fiction, 1991
# Masayuki Hisataka

Masayuki Kukan Hisataka (久高 正之, Hisataka Masayuki, born November 18, 1940) is head of Shorinjiryu Kenkokan Karate.
He is a descendant of Seiwa and son of the founder of Shorinjiryu Kenkokan Karate, Kōri Hisataka. He started his training in judo and karate at the age of three and obtained a shodan in both disciplines by the time he was 13.
He won the All-Japan Open Karatedo Championship in 1961 and 1962 and the Shorinjiryu Kenkokan Championship from 1958 to 1962. He graduated from Nihon University, holding a 4th dan in judo and a 5th dan in karate.
Hisataka represented Japan at the World's Fairs in New York City (1964) and Montreal (1967). He taught karate at Columbia University, State University of New York, McGill University, Loyola College, The National Theatre School of Canada, & CEGEP de Saint-Jérôme.
In the 1980s, Masayuki Hisataka created the World Koshiki Karatedo Federation (WKKF), which is an organization for 'safe contact' fighting competition with protective chest and headgear using Koshiki rules with the intention of Karate being accepted into the Olympics. Koshiki black belt certification and Koshiki referee certification is offered in the WKKF. Currently, Hisataka is ranked Hanshi 10th Dan, Shorinjiryu Kenkokan Karate-Do, and Koshiki Karate-Do.
He has also written two books about Shorinjiryu Karate: "Scientific Karatedo" (published in 1976) and "Essential Shorinjiryu Karatedo" (published in 1994). "Le Karate Koshiki", published only in French, focuses on training for Koshiki style competition fighting and other technical aspects.

## Shorinjiryu Kenkokan International Branches

Shorinjiryu Kenkokan Karate Do is represented around the world by its international branches directly affiliated to the Shorinjiryu Kenkokan Karate Hombu Dojo in Japan. Some of the major international Chief Instructors include:
* Japan: Masayuki Hisataka 10th Dan, Hiroshi Hisataka 7th Dan, Masamitsu Kudaka 7th Dan, Masaki Enomoto 6th Dan
* Australia: Scott Brown 6th Dan
* USA: Mega Martinez 6th Dan
* Canada: Philippe Nadeau 7th Dan
* Germany: Olaf Lotze 6th Dan
* New Zealand: Shaun O'Leary 5th Dan, Masaki Enomoto 6th Dan
* Switzerland: Mamadou Diallo 6th Dan
* Venezuela: Kunio Tanabe 6th Dan
* Spain: Luis Peres Santiago 5th Dan
Other branches include Hong Kong, India, Spain, United Kingdom, Netherlands, France & Russia. There are no descendant schools of the Shorinjiryu Kenkokan recorded at the Shorinjiryu Kenkokan Karatedo Headquarters in Japan, or the official website.
# Émery Fleury

Émery Fleury (February 10, 1901 – October 16, 1975) was a Canadian politician and a three-term member of the Legislative Assembly of Quebec.

## Background

He was born on February 10, 1901, in Saint-Léonard-d'Aston, Centre-du-Québec and became a dairy farmer.

## Political career

Fleury ran as a Conservative candidate in the district of Nicolet in the 1935 election and lost. He won a seat to the Legislative Assembly of Quebec as a Union Nationale candidate in the 1936 election against Liberal candidate Alexandre Gaudet. Fleury was defeated by Liberal candidate Henri-Napoléon Biron in the 1939 election, but won back his seat in the 1944 election and was re-elected in the 1948 election. He did not run for re-election in the 1952 election.

## Retirement

From 1963 to 1970, Fleury was a municipal public servant in Trois-Rivières. He died on October 16, 1975.
# Sandra Hazlehurst

Sandra Glenis Hazlehurst (née Brannigan; born 1959) is a New Zealand politician who has served as the mayor of Hastings since November 2017. She is the first woman to hold the position.

## Early life and family

Hazlehurst was born in Hastings in 1959, the daughter of Velma Ada Brannigan (née Warren) and John Brannigan, a carpenter and later baker. She was educated at Ebbett Park School, Heretaunga Intermediate, and Hastings Girls' High School. Growing up, she was actively involved in Girlguiding, and in 1977 she earned the Queen's Guide award.
After her overseas experience, Brannigan returned to New Zealand in 1983, and married Mark Hazlehurst the following year. The couple went on to have two daughters.
In 1986, Hazlehurst and her sister bought a fruit and vegetable shop in central Hastings. She later established Central Building Surveyors with her husband.

## Political career

Before being elected to the Hastings District Council in 2010, Hazlehurst served as the chair of the Hastings City Business Association for four years. She was elected mayor on 24 November 2017, following the 2017 by-election held after her predecessor, Lawrence Yule, resigned to contest the Tukituki electorate at the 2017 general election. She became the first female mayor of the district.
Hazlehurst served as the mayor of Hastings during the recovery period following Cyclone Gabrielle, where she played a role in overseeing infrastructure rebuilding efforts and addressing housing concerns, including buy-outs.
Under Hazlehurst's council, the Hastings District saw a 77% decline in the number of people in emergency housing between March 2022 and September 2023.
A public disagreement surfaced between Hazlehurst and senior councillor Damon Harvey in late 2023, after Harvey acknowledged the existence of a document related to the council's handling of consenting issues. As a result, Harvey was later removed from his committee chair position by Hazlehurst.
# Stinging Fork Falls State Natural Area

Stinging Fork Falls State Natural Area, a Tennessee Class II Natural-Scientific State Scenic Area, is located in Rhea County, Tennessee, near Spring City.
The Stinging Fork Falls trail terminates at the bottom of Stinging Fork Falls, a 30-foot (9.1 m) high waterfall, about 1 mile from the parking area. A future segment of the Cumberland Trail is planned to connect to the falls.
The 783-acre (3.17 km$^2$) area is owned by the State of Tennessee and managed by the Tennessee Department of Environment and Conservation. It was formerly owned and managed by Bowater Paper Company, which designated several areas in Tennessee as "Pocket Wildernesses" for public recreation.
# It's Getting Hot

"It's Getting Hot" is a single by American rapper NLE Choppa from the deluxe edition of Cottonwood 2. It was released on July 27, 2023 with an accompanying music video. Produced by Draco, Project X and Superstar O, it samples and interpolates the song "Hot in Herre" by Nelly.

## Background

NLE Choppa teased the song and its music video on July 25, 2023, which was set to be released on July 28 but wrote he would release it earlier if the post received 10,000 comments. The song was released the following day on July 27.

## Composition

The instrumental of the song is a modified version of that of "Hot in Herre", with deeper bass and sharper snares in the drums. The lyrics deal with similar topics to that of the original song, though NLE Choppa performs in a different flow; he also sings the chorus of "Hot in Herre", which are followed by vocally reimagined female background vocals.

## Reception

The song was met with mixed reception from fans. Nelly expressed approval of the homage, reposting the video with a comment "Go Up Nephew". In contrast, the song also received adverse criticism on social media. Millennial writers Alex Suskind and Hershal Pandya of Vulture debated the merit of NLE Choppa's remaking of "Hot in Herre". Choppa appeared to be unbothered about the negative reactions, even responding with laughing emojis and confident comments.

## Music video

The music video sees NLE Choppa dressing like Nelly in the "Hot in Herre" video, wearing a headband, A-shirt, baggy jeans, a Hardwood Classics Denver Nuggets throwback jersey, A Bathing Ape sneakers, and a band-aid under his eye. He is seen surrounded by bikini-clad women at a pool party, and rapping in the booth as he reads from a Danger Hiptop phone. It also features a woman swinging her hips, with "NLEVILLE" (a reference to Nelly's album Nellyville) printed on her buttocks.

## Charts

Chart performance for "It's Getting Hot" :
| Chart (2023) | Peak position |
| Canada (Canadian Hot 100) | 82 |
| New Zealand Hot Singles (RMNZ) | 9 |
| US Bubbling Under Hot 100 Singles (Billboard) | 8 |
| US Hot R&B/Hip-Hop Songs (Billboard) | 36 |
| US Rhythmic (Billboard) | 18 |

## Certifications

Certifications for "It's Getting Hot" :
| Region | Certification | Certified units/sales |
| United States (RIAA) | Gold | 500,000$^‡$ |
| $^‡$ Sales+streaming figures based on certification alone. |||