<commit_before>package ca.crystalshard.adapter.persistance.repositories;

import ca.crystalshard.adapter.persistance.SqlTableNames;
import ca.crystalshard.adapter.persistance.Storage;
import com.google.inject.Inject;


public class MySqlJobRepository extends JobRepositoryBase {

    @Inject
    public MySqlJobRepository(Storage storage) {
        super(storage);

        this.saveQuery = String.format("" +
                        " INSERT INTO %s " +
                        " (name, createdDateUtc, updatedDateUtc) " +
                        " VALUES (:name, UTC_TIMESTAMP(), UTC_TIMESTAMP()) ",
                SqlTableNames.JOB
        );
        this.updateQuery = String.format("" +
                        " UPDATE %s " +
                        " SET name = :name, updatedDateUtc = UTC_TIMESTAMP() " +
                        " WHERE id = :id ",
                SqlTableNames.JOB
        );
        this.retrieveQuery = String.format("" +
                        " SELECT id, name, createdDateUtc, updatedDateUtc, deletedDateUtc " +
                        " FROM %s j " +
                        " WHERE j.deletedDateUtc IS NULL " +
                        " AND ",
                SqlTableNames.JOB
        );
        this.deleteQuery = String.format("" +
                        " UPDATE %s " +
                        " SET deletedDateUtc = UTC_TIMESTAMP() " +
                        " WHERE id = :id ",
                SqlTableNames.JOB
        );
    }<commit_msg>Fixed broken tests<commit_after>package ca.crystalshard.adapter.persistance.repositories;

import ca.crystalshard.adapter.persistance.SqlTableNames;
import ca.crystalshard.adapter.persistance.Storage;
import com.google.inject.Inject;


public class MySqlJobRepository extends JobRepositoryBase {

    @Inject
    public MySqlJobRepository(Storage storage) {
        super(storage);

        this.saveQuery = String.format("" +
                        " INSERT INTO %s " +
                        " (name, createdDateUtc, updatedDateUtc) " +
                        " VALUES (:name, UTC_TIMESTAMP(), UTC_TIMESTAMP()) ",
                SqlTableNames.JOB
        );
        this.updateQuery = String.format("" +
                        " UPDATE %s " +
                        " SET name = :name, updatedDateUtc = UTC_TIMESTAMP() " +
                        " WHERE id = :id ",
                SqlTableNames.JOB
        );
        this.retrieveQuery = String.format("" +
                        " SELECT id, name, createdDateUtc, updatedDateUtc, deletedDateUtc " +
                        " FROM %s j " +
                        " WHERE j.deletedDateUtc IS NULL ",
                SqlTableNames.JOB
        );
        this.deleteQuery = String.format("" +
                        " UPDATE %s " +
                        " SET deletedDateUtc = UTC_TIMESTAMP() " +
                        " WHERE id = :id ",
                SqlTableNames.JOB
        );
    }
{'fraction_non_alphanumeric': 0.09771876064010895, 'fraction_numerical': 0.0, 'mean_word_length': 1.4220939818631493, 'pattern_counts': {'":': 0, '<': 3, '<?xml version=': 0, '>': 3, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, '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': '4559614', 'n_tokens_mistral': 816, 'n_tokens_neox': 747, 'n_words': 145}