private string DbAKsDefinition(TableDefInfo tableInfo) { if (tableInfo == null) { return(DBConstants.EMPTY_STRING); } string strFieldNames = CreateConstraintSQL(tableInfo.IndexAK(), true, true); return(strFieldNames); }
public override string CreateDbTriggerIns(TableDefInfo tableInfo) { StringBuilder strTriggerSql = new StringBuilder("CREATE TRIGGER "); strTriggerSql.AppendFormat("UI_{0} ON {0}", tableInfo.TableName()). Append(" AFTER INSERT AS\n"). Append("DECLARE inserted_cursor CURSOR FOR SELECT \n"). Append("firma_id,\n"). Append("davka_id\n"). Append("FROM inserted\n"). Append("DECLARE @xDavkaID int\n"). Append("DECLARE @iFirmaID int\n"). Append("DECLARE @iDavkaID int\n"). Append("DECLARE @iDavkaTX VARCHAR(50)\n"). Append("BEGIN\n"). Append("SET NOCOUNT ON\n"). Append("OPEN inserted_cursor\n"). Append("FETCH NEXT\n"). Append("FROM inserted_cursor INTO @iFirmaID,\n"). Append("@iDavkaID\n"). Append("WHILE @@fetch_status = 0\n"). Append("BEGIN\n"). Append("SET @iDavkaTX = ('Dávka č. ' + CONVERT(varchar(50),\n"). Append("@iDavkaID))\n"). Append("SET @xDavkaID = null\n"). Append("SELECT @xDavkaID = davka_id\n"). Append("FROM IMP_DAVKA\n"). Append("WHERE firma_id = @iFirmaID AND\n"). Append("davka_id = @iDavkaID\n"). Append("IF(@xDavkaID is null)\n"). Append("BEGIN\n"). Append("SET IDENTITY_INSERT IMP_DAVKA ON\n"). Append("INSERT INTO IMP_DAVKA(FIRMA_ID,\n"). Append("DAVKA_ID,\n"). Append("NAZEV,\n"). Append("ZPRACOVANO,\n"). Append("SAPHR)\n"). Append("VALUES(@iFirmaID,\n"). Append("@iDavkaID,\n"). Append("@iDavkaTX,\n"). Append("0,\n"). Append("0)\n"). Append("SET IDENTITY_INSERT IMP_DAVKA OFF\n"). Append("END\n"). Append("FETCH NEXT\n"). Append("FROM inserted_cursor INTO @iFirmaID,\n"). Append("@iDavkaID\n"). Append("END\n"). Append("CLOSE inserted_cursor\n"). Append("DEALLOCATE inserted_cursor\n"). Append("END\n"); return(strTriggerSql.ToString()); }
public override string CreateAlterTableRelationSQL(TableDefInfo tableInfo, RelationDefInfo relInfo) { string addBegin = DBConstants.EMPTY_STRING; string addClose = DBConstants.EMPTY_STRING; if (tableInfo.EnforceRelation(relInfo)) { return(CreateRelationSQL(relInfo, addBegin, addClose)); } return(DBConstants.EMPTY_STRING); }
private string DbRelsDefinition(TableDefInfo tableInfo) { if (tableInfo == null) { return(DBConstants.EMPTY_STRING); } string strFieldNames = DBConstants.EMPTY_STRING; foreach (var item in tableInfo.Relations()) { strFieldNames += CreateTableRelationSQL(item, true, true); } return(strFieldNames); }
private void CreateCodeClassConfigsOpens(IGeneratorWriter scriptWriter, TableDefInfo tableInfo, string blokIndent) { string tableName = tableInfo.TableName(); string className = ClassName(EntityName(tableInfo)); scriptWriter.WriteCodeLine(blokIndent + "// " + tableName + " : Declaration of the " + className); scriptWriter.WriteCodeLine(blokIndent + "public class " + className + "Configuration : EntityTypeConfiguration<" + className + ">"); scriptWriter.WriteCodeLine(blokIndent + "{"); blokIndent = IndentPlus(blokIndent, TAB_INDENT1); scriptWriter.WriteCodeLine(blokIndent + "public " + className + "Configuration()"); scriptWriter.WriteCodeLine(blokIndent + "{"); }
public string CreateTableSQL(TableDefInfo tableInfo, bool createRels, uint versCreate) { if (tableInfo == null) { return(DBConstants.EMPTY_STRING); } string strFieldNames = TableColsDefinition(tableInfo, createRels, versCreate); string strSQL = ("CREATE TABLE "); strSQL += tableInfo.TableName(); strSQL += " "; strSQL += strFieldNames; return(strSQL); }
public string CreateSequeSYN(TableDefInfo tableDef, IGeneratorWriter scriptWriter) { string countsSequeSYN = QuerySynonymCount(tableDef.TableSeqName()); long nSeqSynonymCount = scriptWriter.GetScriptCount(countsSequeSYN); bool bSeqSynonymFound = (nSeqSynonymCount == 1); if (bSeqSynonymFound) { return(DBConstants.EMPTY_STRING); } string createSequeSYN = CreateSequenceSynonym(tableDef); return(createSequeSYN); }
public void CreateTableCodeConfigs(TableDefInfo tableInfo, IGeneratorWriter scriptWriter) { string blokIndent = ""; blokIndent = IndentPlus(blokIndent, TAB_INDENT1); CreateCodeClassConfigsOpens(scriptWriter, tableInfo, blokIndent); blokIndent = IndentPlus(blokIndent, TAB_INDENT1); CreateCodeClassConfigsBody(scriptWriter, tableInfo, blokIndent); blokIndent = IndentBack(blokIndent, TAB_INDENT1); CreateCodeClassConfigsClose(scriptWriter, blokIndent); blokIndent = IndentBack(blokIndent, TAB_INDENT1); }
public string SelectRowCountTableData(TableDefInfo tableDef) { DbDataAdapter countDA = GetAdapter(tableDef.CreateSelectCountTableRow()); string TABLE_NAME = tableDef.TableName(); string commandResult = ""; DataSet tableDS = new DataSet(); countDA.Fill(tableDS, TABLE_NAME); foreach (DataRow rowCount in tableDS.Tables[TABLE_NAME].Rows) { commandResult = rowCount["POCET"].ToString(); } return(commandResult); }
public void CreateTableCodeClasses(TableDefInfo tableInfo, IGeneratorWriter scriptWriter) { string className = ClassName(EntityName(tableInfo)); string blokIndent = ""; blokIndent = IndentPlus(blokIndent, TAB_INDENT1); CreateCodeClassDefinitionOpens(scriptWriter, tableInfo, className, blokIndent); blokIndent = IndentPlus(blokIndent, TAB_INDENT1); CreateCodeClassDefinitionBody(scriptWriter, tableInfo, className, blokIndent); blokIndent = IndentBack(blokIndent, TAB_INDENT1); CreateCodeClassDefinitionClose(scriptWriter, blokIndent); blokIndent = IndentBack(blokIndent, TAB_INDENT1); }
private string TableColsDefinition(TableDefInfo tableInfo, bool createRels, uint versCreate) { if (tableInfo == null) { return(DBConstants.EMPTY_STRING); } string strFieldNames = "("; foreach (var field in tableInfo.TableColumnsForVersion(versCreate)) { string strFieldName = field.m_strName; strFieldName += " "; strFieldName += DbConvertDataType(field); strFieldName += " "; strFieldName += DbIdentity(field); strFieldName += DbNullAndDefault(field); strFieldNames += NEW_LINE_STR; strFieldNames += strFieldName.Trim(); strFieldNames += ","; } if (createRels && DbRelationInCreateTable()) { strFieldNames = StringUtils.JoinNonEmpty(NEW_LINE_STR, strFieldNames, DbRelsDefinition(tableInfo)); } if (DbXPIndexInCreateTable()) { strFieldNames = StringUtils.JoinNonEmpty(NEW_LINE_STR, strFieldNames, DbPKsDefinition(tableInfo)); } string retTableSql = strFieldNames.TrimEnd(DBConstants.TRIM_CHARS); retTableSql += ")"; retTableSql += NEW_LINE_STR; return(retTableSql); }
public override string CreateTableBND(TableDefInfo tableDef, uint versCreate) { string strSQL = ""; var tableFields = tableDef.TableColumnsForVersion(versCreate); foreach (var field in tableFields) { string strDefaultSQL; bool bRequiredDefault = DBPlatform.DefaultBindRequired(field.m_lAttributes); if (field.m_bRequired && bRequiredDefault) { if (DBPlatform.DefaultBindDataType(field.m_nType)) { strDefaultSQL = BindDefaultDataTypeSql(tableDef.TableName(), field.m_strName); strSQL += (strDefaultSQL); strSQL += DBConstants.NEW_LINE_STR; strSQL += DBConstants.NEW_LINE_STR; } } } return(strSQL); }
public abstract string CreateTableBND(TableDefInfo tableDef, uint versCreate);
public override string CreateSwitchIndentityInsertOff(TableDefInfo tableDef, bool bIdentityOn, IGeneratorWriter scriptWriter) { return(DBConstants.EMPTY_STRING); }
public override string CreateDbTriggerUpd(TableDefInfo tableInfo) { StringBuilder strTriggerSql = new StringBuilder("CREATE TRIGGER "); strTriggerSql.AppendFormat("UI_{0} ON {0}", tableInfo.TableName()). Append(" AFTER UPDATE AS\n"). Append("DELETE AS\n"). Append("DECLARE inserted_cursor CURSOR FOR SELECT firma_id,\n"). Append("davka_id,\n"). Append("zpracovano\n"). Append("FROM INSERTED\n"). Append("DECLARE deleted_cursor CURSOR FOR SELECT firma_id,\n"). Append("davka_id,\n"). Append("zpracovano\n"). Append("FROM DELETED\n"). Append("DECLARE @xZpracov tinyint\n"). Append("DECLARE @iFirmaID int\n"). Append("DECLARE @iDavkaID int\n"). Append("BEGIN\n"). Append("SET NOCOUNT ON\n"). Append("IF(COLUMNS_UPDATED() > 0)\n"). Append("BEGIN\n"). Append("OPEN inserted_cursor\n"). Append("FETCH NEXT\n"). Append("FROM inserted_cursor INTO @iFirmaID,\n"). Append("@iDavkaID,\n"). Append("@xZpracov\n"). Append("WHILE @@fetch_status = 0\n"). Append("BEGIN\n"). Append("IF(UPDATE(zpracovano) AND\n"). Append("@xZpracov is not null)\n"). Append("BEGIN\n"). Append("UPDATE imp_01_prac set zpracovano = @xZpracov where firma_id = @iFirmaID and davka_id = @iDavkaID\n"). Append("UPDATE imp_02_zp_vyplaty set zpracovano = @xZpracov where firma_id = @iFirmaID and davka_id = @iDavkaID\n"). Append("UPDATE imp_03_osdata set zpracovano = @xZpracov where firma_id = @iFirmaID and davka_id = @iDavkaID\n"). Append("UPDATE imp_31_pr_adresa set zpracovano = @xZpracov where firma_id = @iFirmaID and davka_id = @iDavkaID\n"). Append("UPDATE imp_05_zdr_poj set zpracovano = @xZpracov where firma_id = @iFirmaID and davka_id = @iDavkaID\n"). Append("UPDATE imp_06_soc_poj set zpracovano = @xZpracov where firma_id = @iFirmaID and davka_id = @iDavkaID\n"). Append("UPDATE imp_07_prijmy_prohl set zpracovano = @xZpracov where firma_id = @iFirmaID and davka_id = @iDavkaID\n"). Append("UPDATE imp_08_prohl_mes set zpracovano = @xZpracov where firma_id = @iFirmaID and davka_id = @iDavkaID\n"). Append("UPDATE imp_09_dite set zpracovano = @xZpracov where firma_id = @iFirmaID and davka_id = @iDavkaID\n"). Append("UPDATE imp_17_pomer set zpracovano = @xZpracov where firma_id = @iFirmaID and davka_id = @iDavkaID\n"). Append("UPDATE imp_18_uvazek set zpracovano = @xZpracov where firma_id = @iFirmaID and davka_id = @iDavkaID\n"). Append("UPDATE imp_19_mzda set zpracovano = @xZpracov where firma_id = @iFirmaID and davka_id = @iDavkaID\n"). Append("UPDATE imp_20_neprit set zpracovano = @xZpracov where firma_id = @iFirmaID and davka_id = @iDavkaID\n"). Append("UPDATE imp_21_srazka set zpracovano = @xZpracov where firma_id = @iFirmaID and davka_id = @iDavkaID\n"). Append("UPDATE imp_101_utvar set zpracovano = @xZpracov where firma_id = @iFirmaID and davka_id = @iDavkaID\n"). Append("UPDATE imp_102_strcz set zpracovano = @xZpracov where firma_id = @iFirmaID and davka_id = @iDavkaID\n"). Append("END\n"). Append("FETCH NEXT\n"). Append("FROM inserted_cursor INTO @iFirmaID,\n"). Append("@iDavkaID,\n"). Append("@xZpracov\n"). Append("END\n"). Append("CLOSE inserted_cursor\n"). Append("DEALLOCATE inserted_cursor\n"). Append("END\n"). Append("ELSE\n"). Append("BEGIN\n"). Append("OPEN deleted_cursor\n"). Append("FETCH NEXT\n"). Append("FROM deleted_cursor INTO @iFirmaID,\n"). Append("@iDavkaID,\n"). Append("@xZpracov\n"). Append("WHILE @@fetch_status = 0\n"). Append("BEGIN\n"). Append("delete from imp_01_prac where firma_id = @iFirmaID and davka_id = @iDavkaID\n"). Append("delete from imp_02_zp_vyplaty where firma_id = @iFirmaID and davka_id = @iDavkaID\n"). Append("delete from imp_03_osdata where firma_id = @iFirmaID and davka_id = @iDavkaID\n"). Append("delete from imp_31_pr_adresa where firma_id = @iFirmaID and davka_id = @iDavkaID\n"). Append("delete from imp_05_zdr_poj where firma_id = @iFirmaID and davka_id = @iDavkaID\n"). Append("delete from imp_06_soc_poj where firma_id = @iFirmaID and davka_id = @iDavkaID\n"). Append("delete from imp_07_prijmy_prohl where firma_id = @iFirmaID and davka_id = @iDavkaID\n"). Append("delete from imp_08_prohl_mes where firma_id = @iFirmaID and davka_id = @iDavkaID\n"). Append("delete from imp_09_dite where firma_id = @iFirmaID and davka_id = @iDavkaID\n"). Append("delete from imp_17_pomer where firma_id = @iFirmaID and davka_id = @iDavkaID\n"). Append("delete from imp_18_uvazek where firma_id = @iFirmaID and davka_id = @iDavkaID\n"). Append("delete from imp_19_mzda where firma_id = @iFirmaID and davka_id = @iDavkaID\n"). Append("delete from imp_20_neprit where firma_id = @iFirmaID and davka_id = @iDavkaID\n"). Append("delete from imp_21_srazka where firma_id = @iFirmaID and davka_id = @iDavkaID\n"). Append("delete from imp_101_utvar where firma_id = @iFirmaID and davka_id = @iDavkaID\n"). Append("delete from imp_102_strcz where firma_id = @iFirmaID and davka_id = @iDavkaID\n"). Append("FETCH NEXT\n"). Append("FROM deleted_cursor INTO @iFirmaID,\n"). Append("@iDavkaID,\n"). Append("@xZpracov\n"). Append("END\n"). Append("CLOSE deleted_cursor\n"). Append("DEALLOCATE deleted_cursor\n"). Append("END\n"). Append("END\n"); return(strTriggerSql.ToString()); }
public override string CreateSequeSEC(TableDefInfo tableDef) { return(DBConstants.EMPTY_STRING); }
public override string CreateTableSynonym(TableDefInfo tableDef) { return(DBConstants.EMPTY_STRING); }
public override string CreateDbTriggerIns(TableDefInfo tableInfo) { return(DBConstants.EMPTY_STRING); }
public override string CreateAlterTableRelationSQL(TableDefInfo tableInfo, RelationDefInfo relInfo) { return(DBConstants.EMPTY_STRING); }
public abstract string CreateSwitchIndentityInsertOff(TableDefInfo tableDef, bool bIdentityOn, IGeneratorWriter scriptWriter);
public string CreateTableSEQ(TableDefInfo tableDef) { return(DBConstants.EMPTY_STRING); }
public override string CreateTableBND(TableDefInfo tableDef, uint versCreate) { return(DBConstants.EMPTY_STRING); }
public abstract string CreateDbTriggerIns(TableDefInfo tableInfo);
public abstract string CreateTableSynonym(TableDefInfo tableDef);
public abstract string CreateSequenceSynonym(TableDefInfo tableDef);
public abstract string CreateAlterTableRelationSQL(TableDefInfo tableInfo, RelationDefInfo relInfo);
public string EntityName(TableDefInfo tableInfo) { return(tableInfo.TableName().ConvertNameToCamel()); }
public abstract string CreateSequeSEC(TableDefInfo tableDef);