Clear all previous sql-code.

@return void
547200
protected function clear()
    {
        $this->sql      = null;
        $this->columns  = null;
        $this->from     = null;
        $this->join     = null;
        $this->where    = null;
        $this->groupby  = null;
        $this->orderby  = null;
        $this->limit    = null;
        $this->offset   = null;
    }
248319
public function clearCache()
    {
        $dbInstace = $this->getDbInstance();
        $sql = '
            DELETE FROM `cache`;
            VACUUM;
        ';
        $stmt = $dbInstace->prepare($sql);
        if ($stmt->execute()) {
            return;
        } else {
            $error = $stmt->errorInfo();
            $errorMsg = $error[2];
            throw new \RuntimeException('SQLite Exception: ' . $errorMsg . ' in SQL: <br /><pre>' . $sql . '</pre>');
        }
    }
1137981
public function clear()
    {
        $this->errors = [];
        $this->notices = [];
        $this->warnings = [];

        $this->warningsExist = false;
        $this->noticesExist = false;
        $this->errorsExist = false;

        $this->propertyResults = [];
    }
986590
public function removeAll()
    {
        /** @var Connection $connection */
        $connection = $this->entityManager->getConnection();

        $isMySQL = $connection->getDriver()->getName() === 'pdo_mysql';
        if ($isMySQL) {
            $connection->query('SET FOREIGN_KEY_CHECKS=0');
        }

        $connection->query("DELETE FROM neos_neos_eventlog_domain_model_event WHERE dtype = 'ttree_contentrepositoryimporter_event'");

        if ($isMySQL) {
            $connection->query('SET FOREIGN_KEY_CHECKS=1');
        }
    }
227161
public function clear()
    {
        for ($i = 0; $i < $this->length(); ++$i) {
            if ($this->offsetExists($i)) {
                $this->offsetUnset($i);
            }
        }
    }
804454
protected static function clear_old_records() {
        global $DB;

        $sql = "SELECT dpctx.*
                  FROM {tool_dataprivacy_ctxexpired} dpctx
             LEFT JOIN {context} ctx ON ctx.id = dpctx.contextid
                 WHERE ctx.id IS NULL";

        $orphaned = $DB->get_recordset_sql($sql);
        foreach ($orphaned as $orphan) {
            $expiredcontext = new expired_context(0, $orphan);
            $expiredcontext->delete();
        }

        // Delete any child of a user context.
        $parentpath = $DB->sql_concat('ctxuser.path', "'/%'");
        $params = [
            'contextuser' => CONTEXT_USER,
        ];

        $sql = "SELECT dpctx.*
                  FROM {tool_dataprivacy_ctxexpired} dpctx
                 WHERE dpctx.contextid IN (
                    SELECT ctx.id
                        FROM {context} ctxuser
                        JOIN {context} ctx ON ctx.path LIKE {$parentpath}
                       WHERE ctxuser.contextlevel = :contextuser
                    )";
        $userchildren = $DB->get_recordset_sql($sql, $params);
        foreach ($userchildren as $child) {
            $expiredcontext = new expired_context(0, $child);
            $expiredcontext->delete();
        }
    }
203162
public function clear()
    {
        try {
            $this->db->from($this->table)->delete();
        } catch (PDOException $e) {
            return false;
        }

        return true;
    }
1105157
public function clear()
    {
        $this->id = null;
        $this->dealer_id = null;
        $this->day = null;
        $this->begin = null;
        $this->end = null;
        $this->closed = null;
        $this->period_begin = null;
        $this->period_end = null;
        $this->created_at = null;
        $this->updated_at = null;
        $this->version = null;
        $this->version_created_at = null;
        $this->version_created_by = null;
        $this->dealer_id_version = null;
        $this->alreadyInSave = false;
        $this->clearAllReferences();
        $this->applyDefaultValues();
        $this->resetModified();
        $this->setNew(true);
        $this->setDeleted(false);
    }
180814
public function clean()
    {
        $this->assertReady();
        
        $sql = sprintf("DELETE FROM %s WHERE %s < NOW() - INTERVAL %d SECOND",
            $this->dbAdapter->platform->quoteIdentifier($this->table),
            $this->dbAdapter->platform->quoteIdentifier($this->timestampColumn),
            $this->getCleanInterval()->toSeconds());
        
        $this->dbAdapter->query($sql, DbAdapter::QUERY_MODE_EXECUTE);
    }
1224901
public function clear()
    {
        $this->id = null;
        $this->title = null;
        $this->slug = null;
        $this->athlete_label = null;
        $this->object_slug = null;
        $this->object_label = null;
        $this->object_plural_label = null;
        $this->skill_slug = null;
        $this->skill_label = null;
        $this->skill_plural_label = null;
        $this->skill_picture_url = null;
        $this->group_slug = null;
        $this->group_label = null;
        $this->group_plural_label = null;
        $this->transition_label = null;
        $this->transition_plural_label = null;
        $this->transitions_slug = null;
        $this->position_slug = null;
        $this->position_label = null;
        $this->feature_composition = null;
        $this->feature_tester = null;
        $this->is_default = null;
        $this->alreadyInSave = false;
        $this->clearAllReferences();
        $this->applyDefaultValues();
        $this->resetModified();
        $this->setNew(true);
        $this->setDeleted(false);
    }
349065
public function clearCaches()
    {
        foreach ($this->getClassFields() as $field => $options) {
            if (!empty($options['unique']) || !empty($options['primary'])) {
                $key = sprintf('%s/%s', static::$tableName, $field);
                DB::clearCachedRecord($key);
            }
        }
    }
23197
public function clear()
    {
        $this->scheme = null;
        $this->host = null;
        $this->user = null;
        $this->password = null;
        $this->path = null;
        $this->query = null;
        $this->fragment = null;
        $this->port = null;
    }
434769
public function clear(): void
    {
        $this->value = null;
        $this->defaultValue = null;
        $this->lenght = -1;
        $this->type = MDataType::UNKNOWN;
        $this->name = null;
    }
862249
public void clear() {
        mCardNumberEditText.setText("");
        mExpiryDateEditText.setText("");
        mCvcEditText.setText("");
        mPostalCodeEditText.setText("");
        mCardNumberEditText.setShouldShowError(false);
        mExpiryDateEditText.setShouldShowError(false);
        mCvcEditText.setShouldShowError(false);
        mPostalCodeEditText.setShouldShowError(false);
        updateBrand(Card.UNKNOWN);
    }
1357339
public function clear()
    {
        $this->id = null;
        $this->dealer_id = null;
        $this->product_id = null;
        $this->created_at = null;
        $this->updated_at = null;
        $this->version = null;
        $this->version_created_at = null;
        $this->version_created_by = null;
        $this->dealer_id_version = null;
        $this->product_id_version = null;
        $this->alreadyInSave = false;
        $this->clearAllReferences();
        $this->applyDefaultValues();
        $this->resetModified();
        $this->setNew(true);
        $this->setDeleted(false);
    }
1009934
public function clear()
    {
        $this->id = null;
        $this->visible = null;
        $this->code = null;
        $this->title = null;
        $this->type = null;
        $this->entity = null;
        $this->serialized_columns = null;
        $this->serialized_condition = null;
        $this->index_engine_driver_configuration_id = null;
        $this->created_at = null;
        $this->updated_at = null;
        $this->version = null;
        $this->version_created_at = null;
        $this->version_created_by = null;
        $this->alreadyInSave = false;
        $this->clearAllReferences();
        $this->applyDefaultValues();
        $this->resetModified();
        $this->setNew(true);
        $this->setDeleted(false);
    }
1028856
public function clear()
    {
        $this->map = [];
        $this->namedCriterions = [];
        $this->ignoreCase = false;
        $this->singleRecord = false;
        $this->selectModifiers = [];
        $this->selectColumns = [];
        $this->orderByColumns = [];
        $this->groupByColumns = [];
        $this->having = null;
        $this->asColumns = [];
        $this->joins = [];
        $this->selectQueries = [];
        $this->dbName = $this->originalDbName;
        $this->offset = 0;
        $this->limit = -1;
        $this->aliases = [];
        $this->useTransaction = false;
        $this->ifLvlCount = false;
        $this->wasTrue = false;
    }