• s

    shengyou

    1 year ago
    Hello, does anyone tried to connect to SQLite in-memory storage using Exposed? I tried this but doesn’t works.
    Database.connect(
        url = "jdbc:sqlite::memory:",
        driver = "org.sqlite.JDBC"
    )
    
    TransactionManager.manager.defaultIsolationLevel = Connection.TRANSACTION_SERIALIZABLE
    Follow the wiki and use
    Database.connect(“jdbc:sqlite:file:test?mode=memory&cache=shared”, “org.sqlite.JDBC”)
    and doesn’t work either. Not sure what I missing? Any suggestions are appreciated. Thanks!
    s
    tapac
    3 replies
    Copy to Clipboard
  • a

    Adam

    1 year ago
    I’m confused at how exposed handles
    LocalDate
    (via the
    JavaLocalDateColumnType
    class).
    LocalDate
    does not contain a timezone, but
    JavaLocalDateColumnType
    converts the
    LocalDate
    to a
    java.sql.Date
    object using the local timezone. This means that, if my timezone is UTC+n, saving a
    LocalDate
    of, for example
    1991-01-01
    will put
    1990-12-31
    in the DB. Have I misunderstood or overlooked something? This behaviour doesn’t seem to be correct. SQL DATEs are timezone free, so are
    LocalDate
    s so there shouldn’t be any timezone conversion happening.
    a
    s
    2 replies
    Copy to Clipboard
  • Daniel Skogquist Åborg

    Daniel Skogquist Åborg

    1 year ago
    Does anyone know how I specify a tinyint(1) column to come out as an integer value using MySQL? Casting to an IntegerColumnType generates a SQL error.
    Daniel Skogquist Åborg
    1 replies
    Copy to Clipboard
  • a

    Adam Crane

    1 year ago
    Hi all, does anyone know how I could use Exposed to model a routine/function in MS SQL that takes in a varchar and returns a table? Ideally, I'd love to use the routine in a join statement. Worst case I'll use custom SQL, but was hoping there was a better way.
    a
    Joel
    +1
    11 replies
    Copy to Clipboard
  • Luca Sas

    Luca Sas

    1 year ago
    hi, i was wondering if there is a way to automatically generate the entity classes. Seems a bit redundant to me to have to type the same copy-pasta twice even if its not a big deal.
    Luca Sas
    Joel
    +1
    6 replies
    Copy to Clipboard
  • pjagielski

    pjagielski

    1 year ago
    hi, I'm not following the channel, any plans for moving to maven central regarding bintray shutdown? there is an issue https://github.com/JetBrains/Exposed/issues/1160 but rather quiet there
    pjagielski
    1 replies
    Copy to Clipboard
  • e

    Endre Deak

    1 year ago
    Is there any way to get a list of the tables along with their aliases participating in a
    Join
    ? I saw
    Join.joinParts
    but that’s not accessible from outside - looks like it’s not 100% prepared for a use-case where the same table can be joined with a different alias.
    e
    2 replies
    Copy to Clipboard
  • r

    Robert

    1 year ago
    Hi. I understand it isn’t a very specific question, and maybe not the right place, but gonna try it anyway: should I prefer Jetbrains Exposed (https://github.com/JetBrains/Exposed) or SQL delight (https://github.com/cashapp/sqldelight)? And especially, why.
    r
    christophsturm
    +1
    5 replies
    Copy to Clipboard
  • solidogen

    solidogen

    1 year ago
    hi, can I store kotlinx.datetime Instant as a table?
    solidogen
    1 replies
    Copy to Clipboard
  • solidogen

    solidogen

    1 year ago
    So I need something like this to let exposed validate it's own scheme against itself spring.jpa.hibernate.ddl-auto=validate
    solidogen
    e
    5 replies
    Copy to Clipboard