congrats Icon
New! Announcing Tabnine Chat Beta
Learn More
Tabnine Logo
SqlExecutor.tableExists
Code IndexAdd Tabnine to your IDE (free)

How to use
tableExists
method
in
org.hswebframework.ezorm.rdb.executor.SqlExecutor

Best Java code snippets using org.hswebframework.ezorm.rdb.executor.SqlExecutor.tableExists (Showing top 5 results out of 315)

origin: hs-web/hsweb-framework

  @Override
  public void run(String... args) throws Exception {
    if (sqlExecutor.tableExists("QRTZ_LOCKS")) {
      return;
    }
    DatabaseType databaseType = DataSourceHolder.currentDatabaseType();
    String databaseTypeName = databaseType.name();
    if (databaseType == DatabaseType.jtds_sqlserver) {
      databaseTypeName = DatabaseType.sqlserver.name();
    }
    String file = "classpath*:/quartz/sql/quartz-" + databaseTypeName + "-create.sql";
    Resource[] resources = new PathMatchingResourcePatternResolver().getResources(file);

    for (Resource resource : resources) {
      try (Reader reader = new InputStreamReader(resource.getInputStream())) {
        String str = FileUtils.reader2String(reader);
        List<String> sqlList = Sqls.parse(str);
        for (String sql : sqlList) {
          if (StringUtils.isEmpty(sql)) return;
          sqlExecutor.exec(sql);
        }
      }
    }
  }
}
origin: hs-web/hsweb-framework

protected void initInstallInfo() throws SQLException {
  boolean tableInstall = sqlExecutor.tableExists("s_system");
  database.createOrAlter("s_system")
      .addColumn().name("name").varchar(128).comment("系统名称").commit()
      .addColumn().name("major_version").alias(majorVersion).number(32).javaType(Integer.class).comment("主版本号").commit()
      .addColumn().name("minor_version").alias(minorVersion).number(32).javaType(Integer.class).comment("次版本号").commit()
      .addColumn().name("revision_version").alias(revisionVersion).number(32).javaType(Integer.class).comment("修订版").commit()
      .addColumn().name("snapshot").number(1).javaType(Boolean.class)
      .custom(column -> column.setValueConverter(new NumberValueConverter(Boolean.class)))
      .comment("是否快照版").commit()
      .addColumn().name("comment").varchar(2000).comment("系统说明").commit()
      .addColumn().name("website").varchar(2000).comment("系统网址").commit()
      .addColumn().name("framework_version").notNull().alias(frameworkVersion).clob()
      .custom(column -> column.setValueConverter(new JSONValueConverter(SystemVersion.FrameworkVersion.class, new ClobValueConverter()))).notNull().comment("框架版本").commit()
      .addColumn().name("dependencies").notNull().alias(dependencies).clob()
      .custom(column -> column.setValueConverter(new JSONValueConverter(SystemVersion.Dependency.class, new ClobValueConverter()))).notNull().comment("依赖详情").commit()
      .comment("系统信息")
      .custom(table -> table.setObjectWrapper(new BeanWrapper<SystemVersion>(SystemVersion::new, table)))
      .commit();
  if (!tableInstall) {
    installed = null;
    return;
  }
  RDBTable<SystemVersion> rdbTable = database.getTable("s_system");
  installed = rdbTable.createQuery().where("name", targetVersion.getName()).single();
}
origin: hs-web/hsweb-easy-orm

@Override
public TableBuilder createOrAlter(String name) {
  RDBTableMetaData tableMetaData = new RDBTableMetaData();
  tableMetaData.setName(name);
  tableMetaData.setDatabaseMetaData(metaData);
  try {
    boolean tableExists;
    if (metaData.getParser() != null) {
      tableExists = metaData.getParser().tableExists(name);
    } else {
      tableExists = sqlExecutor.tableExists(name);
    }
    if (tableExists) {
      if (metaData.getParser() != null) {
        RDBTableMetaData tmp = metaData.getParser().parse(name);
        tmp.getColumns().forEach(tableMetaData::addColumn);
      } else {
        logger.warn("table {} exists,but tableMetaParser is null", name);
      }
    }
  } catch (Exception e) {
  }
  return new SimpleTableBuilder(tableMetaData, this, sqlExecutor);
}
origin: org.hswebframework/hsweb-easy-orm-rdb

@Override
public TableBuilder createOrAlter(String name) {
  RDBTableMetaData tableMetaData = new RDBTableMetaData();
  tableMetaData.setName(name);
  tableMetaData.setDatabaseMetaData(metaData);
  try {
    boolean tableExists;
    if (metaData.getParser() != null) {
      tableExists = metaData.getParser().tableExists(name);
    } else {
      tableExists = sqlExecutor.tableExists(name);
    }
    if (tableExists) {
      if (metaData.getParser() != null) {
        RDBTableMetaData tmp = metaData.getParser().parse(name);
        tmp.getColumns().forEach(tableMetaData::addColumn);
      } else {
        logger.warn("table {} exists,but tableMetaParser is null", name);
      }
    }
  } catch (Exception e) {
  }
  return new SimpleTableBuilder(tableMetaData, this, sqlExecutor);
}
origin: org.hswebframework.web/hsweb-spring-boot-starter

protected void initInstallInfo() throws SQLException {
  boolean tableInstall = sqlExecutor.tableExists("s_system");
  database.createOrAlter("s_system")
      .addColumn().name("name").varchar(128).comment("系统名称").commit()
      .addColumn().name("major_version").alias(majorVersion).number(32).javaType(Integer.class).comment("主版本号").commit()
      .addColumn().name("minor_version").alias(minorVersion).number(32).javaType(Integer.class).comment("次版本号").commit()
      .addColumn().name("revision_version").alias(revisionVersion).number(32).javaType(Integer.class).comment("修订版").commit()
      .addColumn().name("snapshot").number(1).javaType(Boolean.class)
      .custom(column -> column.setValueConverter(new NumberValueConverter(Boolean.class)))
      .comment("是否快照版").commit()
      .addColumn().name("comment").varchar(2000).comment("系统说明").commit()
      .addColumn().name("website").varchar(2000).comment("系统网址").commit()
      .addColumn().name("framework_version").notNull().alias(frameworkVersion).clob()
      .custom(column -> column.setValueConverter(new JSONValueConverter(SystemVersion.FrameworkVersion.class, new ClobValueConverter()))).notNull().comment("框架版本").commit()
      .addColumn().name("dependencies").notNull().alias(dependencies).clob()
      .custom(column -> column.setValueConverter(new JSONValueConverter(SystemVersion.Dependency.class, new ClobValueConverter()))).notNull().comment("依赖详情").commit()
      .comment("系统信息")
      .custom(table -> table.setObjectWrapper(new BeanWrapper<SystemVersion>(SystemVersion::new, table)))
      .commit();
  if (!tableInstall) {
    installed = null;
    return;
  }
  RDBTable<SystemVersion> rdbTable = database.getTable("s_system");
  installed = rdbTable.createQuery().where("name", targetVersion.getName()).single();
}
org.hswebframework.ezorm.rdb.executorSqlExecutortableExists

Popular methods of SqlExecutor

  • list
  • delete
  • exec
  • single
  • update
  • insert

Popular in Java

  • Parsing JSON documents to java classes using gson
  • setContentView (Activity)
  • getExternalFilesDir (Context)
  • getContentResolver (Context)
  • VirtualMachine (com.sun.tools.attach)
    A Java virtual machine. A VirtualMachine represents a Java virtual machine to which this Java vir
  • URLEncoder (java.net)
    This class is used to encode a string using the format required by application/x-www-form-urlencoded
  • Timer (java.util)
    Timers schedule one-shot or recurring TimerTask for execution. Prefer java.util.concurrent.Scheduled
  • HttpServlet (javax.servlet.http)
    Provides an abstract class to be subclassed to create an HTTP servlet suitable for a Web site. A sub
  • DateTimeFormat (org.joda.time.format)
    Factory that creates instances of DateTimeFormatter from patterns and styles. Datetime formatting i
  • LoggerFactory (org.slf4j)
    The LoggerFactory is a utility class producing Loggers for various logging APIs, most notably for lo
  • Github Copilot alternatives
Tabnine Logo
  • Products

    Search for Java codeSearch for JavaScript code
  • IDE Plugins

    IntelliJ IDEAWebStormVisual StudioAndroid StudioEclipseVisual Studio CodePyCharmSublime TextPhpStormVimGoLandRubyMineEmacsJupyter NotebookJupyter LabRiderDataGripAppCode
  • Company

    About UsContact UsCareers
  • Resources

    FAQBlogTabnine AcademyTerms of usePrivacy policyJava Code IndexJavascript Code Index
Get Tabnine for your IDE now