<commit_before><?xml version="1.1" encoding="UTF-8" standalone="no"?>
<databaseChangeLog xmlns="http://www.liquibase.org/xml/ns/dbchangelog" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-2.0.xsd">
    <changeSet author="maxence" id="1559114784027-1">
        <createTable tableName="abstractstatemachinedescriptor">
            <column name="id" type="BIGINT">
                <constraints primaryKey="true" primaryKeyName="abstractstatemachinedescriptor_pkey"/>
            </column>
        </createTable>
    </changeSet>
    <changeSet author="maxence" id="1559114784027-2">
        <addForeignKeyConstraint baseColumnNames="id" baseTableName="abstractstatemachinedescriptor" baseTableSchemaName="public" 
                                 constraintName="fk_abstractstatemachinedescriptor_id" 
                                 deferrable="false" initiallyDeferred="false" 
                                 onDelete="NO ACTION" onUpdate="NO ACTION" 
                                 referencedColumnNames="id" referencedTableName="variabledescriptor" 
                                 referencedTableSchemaName="public" referencesUniqueColumn="false"/>
    </changeSet>
    <changeSet author="maxence" id="1559114784027-3">
        <sql>
            INSERT INTO abstractstatemachinedescriptor
            SELECT id FROM fsmdescriptor 
            UNION SELECT id FROM triggerdescriptor 
            UNION SELECT id FROM dialoguedescriptor;
        </sql>
    </changeSet>

    <changeSet author="maxence" id="1559114784027-4">
        <update tableName="variableinstance">
            <column name="dtype" value="StateMachineInstance"></column>
            <where>dtype = 'TriggerInstance'</where>
        </update>
    </changeSet>
</databaseChangeLog><commit_msg>Fix FSM Refactor<commit_after><?xml version="1.1" encoding="UTF-8" standalone="no"?>
<databaseChangeLog xmlns="http://www.liquibase.org/xml/ns/dbchangelog" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-2.0.xsd">
    <changeSet author="maxence" id="1559114784027-1">
        <createTable tableName="abstractstatemachinedescriptor">
            <column name="id" type="BIGINT">
                <constraints primaryKey="true" primaryKeyName="abstractstatemachinedescriptor_pkey"/>
            </column>
        </createTable>
    </changeSet>
    <changeSet author="maxence" id="1559114784027-2">
        <addForeignKeyConstraint baseColumnNames="id" baseTableName="abstractstatemachinedescriptor" baseTableSchemaName="public" 
                                 constraintName="fk_abstractstatemachinedescriptor_id" 
                                 deferrable="false" initiallyDeferred="false" 
                                 onDelete="NO ACTION" onUpdate="NO ACTION" 
                                 referencedColumnNames="id" referencedTableName="variabledescriptor" 
                                 referencedTableSchemaName="public" referencesUniqueColumn="false"/>
    </changeSet>
    <changeSet author="maxence" id="1559114784027-3">
        <sql>
            INSERT INTO abstractstatemachinedescriptor
            SELECT id FROM fsmdescriptor 
            UNION SELECT id FROM triggerdescriptor 
            UNION SELECT id FROM dialoguedescriptor;
        </sql>
    </changeSet>

    <changeSet author="maxence" id="1559114784027-4">
        <update tableName="variableinstance">
            <column name="dtype" value="StateMachineInstance"></column>
            <where>dtype = 'TriggerInstance'</where>
        </update>
    </changeSet>

    <changeSet author="maxence" id="1559114784027-5">
        <sql>
            DELETE FROM fsmdescriptor
            WHERE id IN (
            SELECT id FROM triggerdescriptor
            );
        </sql>
        <sql>
            DELETE FROM fsmdescriptor
            WHERE id IN (
            SELECT id FROM dialoguedescriptor
            );
        </sql>
    </changeSet>
</databaseChangeLog>
{'fraction_non_alphanumeric': 0.11116435074269286, 'fraction_numerical': 0.03497843794920939, 'mean_word_length': 2.538135593220339, 'pattern_counts': {'":': 0, '<': 59, '<?xml version=': 2, '>': 59, 'https://': 0, 'lorem ipsum': 0, 'www.': 8, 'xml': 12}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 10, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '528833', 'n_tokens_mistral': 1263, 'n_tokens_neox': 1134, 'n_words': 185}