appany / AppAny.Quartz.EntityFrameworkCore.Migrations

EntityFrameworkCore PostgreSQL migrations for Quartz.NET
MIT License
70 stars 18 forks source link

feat: add SQL server #49

Closed ZaoralJ closed 1 year ago

ZaoralJ commented 1 year ago

add support for SQL server it follows code style from quartz sql script, all names are capitalised

JasonLandbridge commented 1 year ago

I'm currently working on the Sqlite version and I also agree to use the capitalized names for table and columns names. Maybe an idea to place all these table names and column names into a Const file so it can be shared across database versions?

JasonLandbridge commented 1 year ago

"Finished" my PR: #50 , I have added a static table name to each entity but I'm not sure if that is the way if we also want to maybe capitalize all column names?

codecov-commenter commented 1 year ago

Codecov Report

Base: 91.27% // Head: 94.03% // Increases project coverage by +2.75% :tada:

Coverage data is based on head (87566c2) compared to base (a317229). Patch coverage: 100.00% of modified lines in pull request are covered.

Additional details and impacted files ```diff @@ Coverage Diff @@ ## main #49 +/- ## ========================================== + Coverage 91.27% 94.03% +2.75% ========================================== Files 40 52 +12 Lines 1066 1559 +493 Branches 2 2 ========================================== + Hits 973 1466 +493 Misses 92 92 Partials 1 1 ``` | [Impacted Files](https://codecov.io/gh/appany/AppAny.Quartz.EntityFrameworkCore.Migrations/pull/49?src=pr&el=tree&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=appany) | Coverage Δ | | |---|---|---| | [...ations/QuartzBlobTriggerEntityTypeConfiguration.cs](https://codecov.io/gh/appany/AppAny.Quartz.EntityFrameworkCore.Migrations/pull/49/diff?src=pr&el=tree&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=appany#diff-c3JjL0FwcEFueS5RdWFydHouRW50aXR5RnJhbWV3b3JrQ29yZS5NaWdyYXRpb25zLlNxbFNlcnZlci9FbnRpdHlUeXBlQ29uZmlndXJhdGlvbnMvUXVhcnR6QmxvYlRyaWdnZXJFbnRpdHlUeXBlQ29uZmlndXJhdGlvbi5jcw==) | `100.00% <100.00%> (ø)` | | | [...gurations/QuartzCalendarEntityTypeConfiguration.cs](https://codecov.io/gh/appany/AppAny.Quartz.EntityFrameworkCore.Migrations/pull/49/diff?src=pr&el=tree&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=appany#diff-c3JjL0FwcEFueS5RdWFydHouRW50aXR5RnJhbWV3b3JrQ29yZS5NaWdyYXRpb25zLlNxbFNlcnZlci9FbnRpdHlUeXBlQ29uZmlndXJhdGlvbnMvUXVhcnR6Q2FsZW5kYXJFbnRpdHlUeXBlQ29uZmlndXJhdGlvbi5jcw==) | `100.00% <100.00%> (ø)` | | | [...ations/QuartzCronTriggerEntityTypeConfiguration.cs](https://codecov.io/gh/appany/AppAny.Quartz.EntityFrameworkCore.Migrations/pull/49/diff?src=pr&el=tree&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=appany#diff-c3JjL0FwcEFueS5RdWFydHouRW50aXR5RnJhbWV3b3JrQ29yZS5NaWdyYXRpb25zLlNxbFNlcnZlci9FbnRpdHlUeXBlQ29uZmlndXJhdGlvbnMvUXVhcnR6Q3JvblRyaWdnZXJFbnRpdHlUeXBlQ29uZmlndXJhdGlvbi5jcw==) | `100.00% <100.00%> (ø)` | | | [...tions/QuartzFiredTriggerEntityTypeConfiguration.cs](https://codecov.io/gh/appany/AppAny.Quartz.EntityFrameworkCore.Migrations/pull/49/diff?src=pr&el=tree&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=appany#diff-c3JjL0FwcEFueS5RdWFydHouRW50aXR5RnJhbWV3b3JrQ29yZS5NaWdyYXRpb25zLlNxbFNlcnZlci9FbnRpdHlUeXBlQ29uZmlndXJhdGlvbnMvUXVhcnR6RmlyZWRUcmlnZ2VyRW50aXR5VHlwZUNvbmZpZ3VyYXRpb24uY3M=) | `100.00% <100.00%> (ø)` | | | [...urations/QuartzJobDetailEntityTypeConfiguration.cs](https://codecov.io/gh/appany/AppAny.Quartz.EntityFrameworkCore.Migrations/pull/49/diff?src=pr&el=tree&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=appany#diff-c3JjL0FwcEFueS5RdWFydHouRW50aXR5RnJhbWV3b3JrQ29yZS5NaWdyYXRpb25zLlNxbFNlcnZlci9FbnRpdHlUeXBlQ29uZmlndXJhdGlvbnMvUXVhcnR6Sm9iRGV0YWlsRW50aXR5VHlwZUNvbmZpZ3VyYXRpb24uY3M=) | `100.00% <100.00%> (ø)` | | | [...onfigurations/QuartzLockEntityTypeConfiguration.cs](https://codecov.io/gh/appany/AppAny.Quartz.EntityFrameworkCore.Migrations/pull/49/diff?src=pr&el=tree&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=appany#diff-c3JjL0FwcEFueS5RdWFydHouRW50aXR5RnJhbWV3b3JrQ29yZS5NaWdyYXRpb25zLlNxbFNlcnZlci9FbnRpdHlUeXBlQ29uZmlndXJhdGlvbnMvUXVhcnR6TG9ja0VudGl0eVR5cGVDb25maWd1cmF0aW9uLmNz) | `100.00% <100.00%> (ø)` | | | [...QuartzPausedTriggerGroupEntityTypeConfiguration.cs](https://codecov.io/gh/appany/AppAny.Quartz.EntityFrameworkCore.Migrations/pull/49/diff?src=pr&el=tree&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=appany#diff-c3JjL0FwcEFueS5RdWFydHouRW50aXR5RnJhbWV3b3JrQ29yZS5NaWdyYXRpb25zLlNxbFNlcnZlci9FbnRpdHlUeXBlQ29uZmlndXJhdGlvbnMvUXVhcnR6UGF1c2VkVHJpZ2dlckdyb3VwRW50aXR5VHlwZUNvbmZpZ3VyYXRpb24uY3M=) | `100.00% <100.00%> (ø)` | | | [...ons/QuartzSchedulerStateEntityTypeConfiguration.cs](https://codecov.io/gh/appany/AppAny.Quartz.EntityFrameworkCore.Migrations/pull/49/diff?src=pr&el=tree&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=appany#diff-c3JjL0FwcEFueS5RdWFydHouRW50aXR5RnJhbWV3b3JrQ29yZS5NaWdyYXRpb25zLlNxbFNlcnZlci9FbnRpdHlUeXBlQ29uZmlndXJhdGlvbnMvUXVhcnR6U2NoZWR1bGVyU3RhdGVFbnRpdHlUeXBlQ29uZmlndXJhdGlvbi5jcw==) | `100.00% <100.00%> (ø)` | | | [...rtzSimplePropertyTriggerEntityTypeConfiguration.cs](https://codecov.io/gh/appany/AppAny.Quartz.EntityFrameworkCore.Migrations/pull/49/diff?src=pr&el=tree&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=appany#diff-c3JjL0FwcEFueS5RdWFydHouRW50aXR5RnJhbWV3b3JrQ29yZS5NaWdyYXRpb25zLlNxbFNlcnZlci9FbnRpdHlUeXBlQ29uZmlndXJhdGlvbnMvUXVhcnR6U2ltcGxlUHJvcGVydHlUcmlnZ2VyRW50aXR5VHlwZUNvbmZpZ3VyYXRpb24uY3M=) | `100.00% <100.00%> (ø)` | | | [...ions/QuartzSimpleTriggerEntityTypeConfiguration.cs](https://codecov.io/gh/appany/AppAny.Quartz.EntityFrameworkCore.Migrations/pull/49/diff?src=pr&el=tree&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=appany#diff-c3JjL0FwcEFueS5RdWFydHouRW50aXR5RnJhbWV3b3JrQ29yZS5NaWdyYXRpb25zLlNxbFNlcnZlci9FbnRpdHlUeXBlQ29uZmlndXJhdGlvbnMvUXVhcnR6U2ltcGxlVHJpZ2dlckVudGl0eVR5cGVDb25maWd1cmF0aW9uLmNz) | `100.00% <100.00%> (ø)` | | | ... and [3 more](https://codecov.io/gh/appany/AppAny.Quartz.EntityFrameworkCore.Migrations/pull/49/diff?src=pr&el=tree-more&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=appany) | | Help us with your feedback. Take ten seconds to tell us [how you rate us](https://about.codecov.io/nps?utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=appany). Have a feature suggestion? [Share it here.](https://app.codecov.io/gh/feedback/?utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=appany)

:umbrella: View full report at Codecov.
:loudspeaker: Do you have feedback about the report comment? Let us know in this issue.