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);
