Example usage for com.liferay.portal.kernel.dao.db DB runSQL

Introduction

In this page you can find the example usage for com.liferay.portal.kernel.dao.db DB runSQL.

Prototype

public void runSQL(String[] sqls) throws IOException, SQLException;

Source Link

Usage

From source file:com.liferay.dynamic.data.mapping.upgrade.v1_0_0.test.UpgradeDynamicDataMappingTest.java

License:Open Source License

protected void deleteContent(long contentId) throws Exception {
    DB db = DBManagerUtil.getDB();

    db.runSQL("delete from DDMContent where contentId = " + contentId);
}

---

From source file:com.liferay.dynamic.data.mapping.upgrade.v1_0_0.test.UpgradeDynamicDataMappingTest.java

License:Open Source License

protected void deleteRecord(long recordId) throws Exception {
    DB db = DBManagerUtil.getDB();

    db.runSQL("delete from DDLRecordVersion where recordId = " + recordId);
    db.runSQL("delete from DDLRecord where recordId = " + recordId);
}

---

From source file:com.liferay.dynamic.data.mapping.upgrade.v1_0_0.test.UpgradeDynamicDataMappingTest.java

License:Open Source License

protected void deleteRecordSet(long recordSetId) throws Exception {
    DB db = DBManagerUtil.getDB();

    db.runSQL("delete from DDLRecordSet where recordSetId = " + recordSetId);
}

---

From source file:com.liferay.dynamic.data.mapping.upgrade.v1_0_0.test.UpgradeDynamicDataMappingTest.java

License:Open Source License

protected void deleteStorageLink(long storageLinkId) throws Exception {
    DB db = DBManagerUtil.getDB();

    db.runSQL("delete from DDMStorageLink where storageLinkId = " + storageLinkId);
}

---

From source file:com.liferay.dynamic.data.mapping.upgrade.v1_0_0.test.UpgradeDynamicDataMappingTest.java

License:Open Source License

protected void deleteStructure(long structureId) throws Exception {
    DB db = DBManagerUtil.getDB();

    db.runSQL("delete from DDMStructure where structureId = " + structureId);
}

---

From source file:com.liferay.dynamic.data.mapping.upgrade.v1_0_0.test.UpgradeDynamicDataMappingTest.java

License:Open Source License

protected void deleteTemplate(long templateId) throws Exception {
    DB db = DBManagerUtil.getDB();

    db.runSQL("delete from DDMTemplate where templateId = " + templateId);
}

---

From source file:com.liferay.journal.upgrade.JournalServiceUpgrade.java

License:Open Source License

protected void deleteTempImages() throws Exception {
    if (_log.isDebugEnabled()) {
        _log.debug("Delete temporary images");
    }/*from  w  w  w .ja va2  s.  co  m*/

    DB db = DBManagerUtil.getDB();

    db.runSQL("delete from Image where imageId IN (SELECT articleImageId FROM "
            + "JournalArticleImage where tempImage = TRUE)");

    db.runSQL("delete from JournalArticleImage where tempImage = TRUE");
}

---

From source file:com.liferay.localization.servlet.LocalizationServletContextListener.java

License:Open Source License

protected void runSQL(String[] sqls) throws Exception {
    DB db = DBFactoryUtil.getDB();

    db.runSQL(sqls);
}

---