<commit_before><?xml version="1.0" encoding="UTF-8"?>
<databaseChangeLog xmlns="http://www.liquibase.org/xml/ns/dbchangelog/1.9"
                   xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
                   xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog/1.9
                  http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-1.9.xsd">
</databaseChangeLog><commit_msg>Added script to create 'commons_ints' table that can be used to generate dates for use in reporting.<commit_after><?xml version="1.0" encoding="UTF-8"?>
<databaseChangeLog xmlns="http://www.liquibase.org/xml/ns/dbchangelog/1.9"
                   xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
                   xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog/1.9
                  http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-1.9.xsd">
	<changeSet id="openhmis-commons-2.0.0" author="ibewes">
		<preConditions onFail="MARK_RAN">
			<not>
				<tableExists tableName="commons_ints" />
			</not>
		</preConditions>

		<comment>
			The commons_ints table is used by reports/queries that need to generate all dates between two dates.
			Usage:
				-- Only works for 100 days, add more ints joins for more
				SELECT cal.date, tbl.data
				FROM (
					SELECT '2009-06-25' + INTERVAL a.i * 10 + b.i DAY as date
					FROM ints a JOIN ints b
					ORDER BY a.i * 10 + b.i
				) cal LEFT JOIN tbl ON cal.date = tbl.date
				WHERE cal.date BETWEEN '2009-06-25' AND '2009-07-01';

			See: http://stackoverflow.com/a/1080334/1314
		</comment>
		<createTable tableName="commons_ints">
			<column name="i" type="int"><constraints nullable="false" /></column>
		</createTable>

		<insert tableName="commons_ints">
			<column name="i">0</column>
			<column name="i">1</column>
			<column name="i">2</column>
			<column name="i">3</column>
			<column name="i">4</column>
			<column name="i">5</column>
			<column name="i">6</column>
			<column name="i">7</column>
			<column name="i">8</column>
			<column name="i">9</column>
		</insert>
	</changeSet>
</databaseChangeLog>
{'fraction_non_alphanumeric': 0.16332378223495703, 'fraction_numerical': 0.039637058261700095, 'mean_word_length': 3.1816367265469063, 'pattern_counts': {'":': 0, '<': 45, '<?xml version=': 2, '>': 45, 'https://': 0, 'lorem ipsum': 0, 'www.': 8, 'xml': 12}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '5206963', 'n_tokens_mistral': 873, 'n_tokens_neox': 726, 'n_words': 144}