Where communities thrive


  • Join over 1.5M+ people
  • Join over 100K+ communities
  • Free without limits
  • Create your own community
People
Activity
  • Aug 04 13:12

    dependabot[bot] on nuget

    (compare)

  • Aug 04 13:12
    dependabot[bot] closed #1474
  • Aug 04 13:12
    dependabot[bot] commented #1474
  • Aug 04 13:12
    dependabot[bot] review_requested #1499
  • Aug 04 13:12

    dependabot[bot] on nuget

    Bump Oracle.ManagedDataAccess.C… (compare)

  • Aug 04 13:12
    dependabot[bot] labeled #1499
  • Aug 04 13:12
    dependabot[bot] opened #1499
  • Aug 03 20:16
    jzabroski commented #956
  • Aug 03 15:48
    jzabroski edited #1498
  • Aug 03 15:48
    jzabroski opened #1498
  • Jul 29 20:57
    CoskunSunali commented #978
  • Jul 29 20:56
    CoskunSunali commented #978
  • Jul 29 14:37
    jzabroski commented #978
  • Jul 20 20:20
    jzabroski edited #1438
  • Jul 20 20:17
    jzabroski closed #1427
  • Jul 20 20:17
    jzabroski commented #1427
  • Jul 20 13:38
    jzabroski commented #1348
  • Jul 20 13:09

    dependabot[bot] on nuget

    (compare)

  • Jul 20 13:09
    dependabot[bot] closed #1476
  • Jul 20 13:09
    dependabot[bot] commented #1476
Simon Novak
@snovak7
well what if I just try it
ah yes thank you for 3.2.7 release. dotnet fm tool works now on mac
John Zabroski
@jzabroski
great. it will get better. much more to come!
Simon Novak
@snovak7
yeah :) anyway, I thought you had in fm tool that it generates a migration class
Simon Novak
@snovak7
I see AsString() makes it text
which is what I need
Simon Novak
@snovak7
@jzabroski .Unique() doesn't have asc/desc options ?
Index that is
maybe it's a stupid question :D
alexanderbright
@alexanderbright
Hi guys,
could you tell me if it is possible to read a connection string from appsettings.json when I run migrations with the tool instead of reading the connection string from command line arguments?
dotnet fm migrate ...
John Zabroski
@jzabroski
@snovak7 There is a different API that supports sorting. A bit wonky but that is the nature of open source. Sometimes some use cases are there, just in whatever place the contributor needed it
@alexanderbright can you please post the question on GitHub discussions, thanks
alexanderbright
@alexanderbright

@alexanderbright can you please post the question on GitHub discussions, thanks

done
https://github.com/fluentmigrator/fluentmigrator/discussions/1303

alexanderbright
@alexanderbright
guys,
could you tell me if it is possible to log sql script for migration while using in-process migrations?
Or can I receive that script from FM services?
John Zabroski
@jzabroski
Hi @alexanderbright sorry for the delay replying. We're really trying to move to GitHub Discussions so we dont miss these questions.
It is definitely possible, as dotnet-fm allows it, so if you use In-Process Runner using the DotNet.Cli logic as a base, you should be able to just smoothly do what you describe.
alexanderbright
@alexanderbright
alexanderbright
@alexanderbright
Found RunnerOptions
So, issue resolved
Removed question
John Zabroski
@jzabroski
:thumbsup:
Simon Novak
@snovak7
@jzabroski ok, cool
Andrés Gómez
@agomezb
Hi, I have a project on .net framework 4, I would like to use fluentmigrator.
I understand I should use 2.0.7 version, where can i find samples or documentation to this version?
i.sinister
@i-sinister
Hi, I've tried using fluentmigrator with postgres and encountered a bug related to schema name handling. I've found 'related' issue and made added a comment but as bug is closed I'm not sure it was noticed. Can somebody check it, please? https://github.com/fluentmigrator/fluentmigrator/issues/771#issuecomment-673303328
John Zabroski
@jzabroski
Guys I had a crazy idea to quickly support smooth connectionless preview sql mode. Why not just create a mock IDbConnection and mock IDbTransaction? That completely removes the crazy NoOp logic that exists today. If someone tries calling ExecuteReader on a mock IDbReader we can throw an exception, too. Not perfect, but it would be a ton less work than what I had originally imagined.
allowing people to mock the conneciton might actually be a nice feature, too. Say you want to script a down migration that needs to query some system state. You could generate that through the mock by a robust interceptor like Moq. But for the core runner, we would just throw.
So, if you need to deploy something to a prod database you dont have ddl admin access to, you might be able to at least get a snapshot of some basic data and make some basic assertions.
I personally dont need anything that fancy, but one or two people have.
Simon Novak
@snovak7
@jzabroski if I use dotnet-fm, it says it doesn't support netstandard2.1 ? as it can't load library :)
reverting to netstandard2.0 looks like it works.
John Zabroski
@jzabroski
@snovak7 Hoping to fix that soon. Holiday break should give me a chance to clean some long standing stuff that is in half finished state in my jzabroski/FluentMigrator fork
You can always try to workaround library not load issues using a DirtyAssemblyResolveHelper trick, although its not really maintainable and whoever comes after you five years down the road will likely cuss you
John Zabroski
@jzabroski
Also, GitHub now seems to support copy-pasting html tables into markdown text. Sweeet
John Zabroski
@jzabroski
Also, this 2013 bug in IBM DB2 :psyduck: https://www.ibm.com/support/pages/apar/PM96007
John Zabroski
@jzabroski
Hmm... the fluentmigrator.github.io page doesnt seem to be correctly updating after AzureDevOps build success
I bet I need to click publish in the release pipeline, doh
Eivind Gussiås Løkseth
@eloekset
Fixed now, @jzabroski fluentmigrator/documentation#41
John Zabroski
@jzabroski
Great job
markjerz
@markjerz
Hi, just wondering if it's possible to have migrations auto-generated. For example, you could have two models that represented the state of your before and after databases and then get the tool to scaffold most of the fluent migrator expressions by examining the difference between the models?
Robert Williams
@RobertWilliams2000
Context: I am supporting postgres, sqlserver, & oracle.
Oracle behavior is quite a bit different with respect to DDL.
For instance if I create a stored procedure with a syntax error using Execute.Sql("Create Procedure ..."). The migration completes successfully. However the procedure is in invalid state.
Any chance someone in here has worked around issues like this in oracle and has some tips?
Robert Williams
@RobertWilliams2000
@markjerz in the past I had only used SQL Server and would utilize the visual studio data tools to generate a giant sql diff. Fluent migrator would run the script fine with a small amount of clean up and no transaction wrapping.
Rune Jacobsen
@havremunken

Hi all, I am pretty new to FluentMigrator, using it in my first project and I'm in love with the mental model etc. I have set up quite a few migrations and baked into my .Net 5 project nicely, running against a Postgres server on my local network for development.

However, time has come to deploy to production (at least test deployments), and for that, the Postgres server is on DigitalOcean's managed db thing. They require SSL and certificate usage, so I am required to do stuff to the connection establishing process to get up and running. I do the same in the EF DbContext setup, but of course FluentMigrator uses it's own stuff.

I found issue #968 which suggests to inherit from PostgresProcessor and do stuff in EnsureConnectionIsOpen() - however, I am completely blank as to what I need to do in there.

Is anyway aware of an example of how to provide a certificate for the postgres connection and handle the handshake bits?

Rune Jacobsen
@havremunken
That "anyway" in the last sentence was supposed to be an "anyone"..
Fausto Ruvalcaba
@seFausto
Hi everyone, I'm semi-new to using FluentMigrator. I do have a question that I haven't been able to find an answer or at least an opinion: Is there such thing as too many migrations? if so, should you clear your migrations and create them from scratch, with the first one being a schema build?
2 replies
Emmanuel Allende
@eallende3gis:matrix.org
[m]
hello! quick question. I need to extend PostgresGenerator. How can I achieve that? since PostgresGenerator has no parameterless constructor and I don't know what to pass to it.
Thanks!
YanerTavuz
@YanerTavuz
Hey everyone, I'm running FluentMigrator 3.2.1 and everytime I rebuild my solution when a migration has been run it seems to lock a .DLL named Microsoft.Data.SqlClient.SNI.dll.
I am using using (var scope = ServiceProvider.CreateScope()) to ensure that resources are released after running migration but to no success.
Edit: v3.2.16
YanerTavuz
@YanerTavuz
Solution that worked was to downgrade to v3.2.15
Andrew
@helmkamp
is the dotnet fm tooling compatible with .net 5?