#!/bin/sh
sed -i -e "/<Import Condition/ s/'\$(SQLDBExtensionsRefPath)'/'\$(NetCoreBuild)' != 'true' AND '\$(SQLDBExtensionsRefPath)'/" \
    -e "\|^</Project>|i \
    <Import Condition=\"'\$(NetCoreBuild)' == 'true'\" Project=\"\$(NETCoreTargetsPath)\\\\Microsoft.Data.Tools.Schema.SqlTasks.targets\"\/>\n \
    <ItemGroup>\n \
      <PackageReference Condition=\"'\$(NetCoreBuild)' == 'true'\" Include=\"Microsoft.NETFramework.ReferenceAssemblies\" Version=\"1.0.0\" PrivateAssets=\"All\"/>\n \
    </ItemGroup>\n \
    <Target Name=\"BeforeBuild\">\n \
      <Delete Files=\"\$(BaseIntermediateOutputPath)\\\\project.assets.json\"/>\n \
    </Target>" \
    -e "/BNK_Banking_GetAccountDetails.sql/d" \
    -e "/BNK_Banking_Modulr_GetInstitutionKeyAndSecret.sql/d" \
    -e "/GetModulrAccountId.sql/d" \
    -e "s/\"Banking.sql/\"banking.sql/" \
    -e "s/DestroyCardsUnder/DESTROYCARDSUNDER/" \
    -e "s/DpsOnlineFees/Dpsonlinefees/" \
    -e "s/Export_to_CSV_Audit/Export_to_CSV_audit/" \
    -e "s/XML_Reported_Presentments.sql/XML_reported_presentments.sql/" \
    -e "s/UpdateEhiCutOffurls_Pm.sql/UPDATEEHICUTOFFURLS_PM.sql/" \
    -e '/<ArtifactReference.*master.dacpac.*/, /<\/ArtifactReference/ d' \
    -e 's/Sql130DatabaseSchemaProvider/Sql150DatabaseSchemaProvider/' \
*.sqlproj

if [ -f Scripts/Post-Deployment/Script.PostDeployment.sql ]; then
  sed -i -e 's/:r .\\/:r /' Scripts/Post-Deployment/Script.PostDeployment.sql
fi