orm | Doctrine Object Relational Mapper | Object-Relational Mapping library

Class static side 'typeof Animal' incorrectly extends base class static side 'typeof BaseModel'.
  Types of property 'database' are incompatible.
    Type '() => Promise' is not assignable to type 'void'.ts(2417)

  static get database() {
    throw new Error('DB not defined')
  }

  static get database() {
    return async () => SQLite.openDatabase('database.db')
  }

@pytest.mark.django_db(transaction=True, databases=['default', 'my_db2'])
class TestItems:
    def test_people(self):
      person1 = PeopleFactory()  # Adds 1 person to my_db2
      assert fetch_all_persons() == 1 # Fails Returns 0

class PeopleFactory(factory.django.DjangoModelFactory):
    id = factory.Sequence(lambda x: x + 1)
    name = factory.Faker('first_name')

    class Meta:
        model = People

from django.db import connections


def fetch_all_persons():
      with connections['my_db2'].cursor() as cursor:
        cursor.execute(f"SELECT * FROM Persons")
        return len(list(cursor.fetchall())):

[ERROR] Failed to execute goal org.sonatype.plugins:nexus-staging-maven-plugin:1.6.8:deploy (injected-nexus-deploy) on project persism: Execution injected-nexus-deploy of goal org.sonatype.plugins:nexus-staging-maven-plugin:1.6.8:de
ploy failed: An API incompatibility was encountered while executing org.sonatype.plugins:nexus-staging-maven-plugin:1.6.8:deploy: java.lang.ExceptionInInitializerError: null


[ERROR] import: Entry[import  from realm ClassRealm[maven.api, parent: null]]
[ERROR]
[ERROR] -----------------------------------------------------
[ERROR] : Unable to make field private final java.util.Comparator java.util.TreeMap.comparator accessible: module java.base does not "opens java.util" to unnamed module @149f5761
[ERROR] -> [Help 1]
org.apache.maven.lifecycle.LifecycleExecutionException: Failed to execute goal org.sonatype.plugins:nexus-staging-maven-plugin:1.6.8:deploy (injected-nexus-deploy) on project persism: Execution injected-nexus-deploy of goal org.sona
type.plugins:nexus-staging-maven-plugin:1.6.8:deploy failed: An API incompatibility was encountered while executing org.sonatype.plugins:nexus-staging-maven-plugin:1.6.8:deploy: java.lang.ExceptionInInitializerError: null

Caused by: org.apache.maven.plugin.PluginExecutionException: Execution injected-nexus-deploy of goal org.sonatype.plugins:nexus-staging-maven-plugin:1.6.8:deploy failed: An API incompatibility was encountered while executing org.son
atype.plugins:nexus-staging-maven-plugin:1.6.8:deploy: java.lang.ExceptionInInitializerError: null

    4.0.0

    io.github.sproket
    persism
    2.0.0
    jar


    
        ./src
        ./test
        
            
                ./test
                
                
                
            
        
        
            
                org.apache.maven.plugins
                maven-compiler-plugin
                3.8.1
                
                
                    17
                    17



                
            

            
                org.apache.maven.plugins
                maven-jar-plugin
                3.2.0
                
                    
                        
                            sproket.github.io.persism
                        
                    
                
            

            
                org.apache.maven.plugins
                maven-source-plugin
                3.2.1
                
                    
                        attach-sources
                        
                            jar-no-fork
                        
                    
                
            
            
                org.apache.maven.plugins
                maven-javadoc-plugin
                3.2.0
                
                    net.sf.persism.log*;net.sf.persism.logging.*
                    17
                
                
                    
                        attach-javadocs
                        
                            jar
                        
                    
                
            
            
                maven-surefire-plugin
                3.0.0-M5
                
                    net.sf.persism.categories.ExternalDB,net.sf.persism.categories.TestContainerDB
                    
                
            
            
                org.sonatype.plugins
                nexus-staging-maven-plugin
                1.6.8
                true
                
                    ossrh
                    https://s01.oss.sonatype.org/
                    true
                
            

        
    

    persism
    A zero ceremony ORM for Java
    https://github.com/sproket/Persism

    
        17
        17
        UTF-8
    

    
        
            BSD-3-Clause License
            https://github.com/sproket/Persism/blob/master/license.txt
        
    

    
        
            Dan Howard
            --------------------------
            io.github
            https://sproket.github.io/Persism/
        
    

    
        
            ossrh
            https://s01.oss.sonatype.org/content/repositories/snapshots
        
        
            ossrh
            https://s01.oss.sonatype.org/service/local/staging/deploy/maven2/
        
    

    
        scm:git:git://github.com/sproket/Persism.git
        scm:git:ssh://github.com/sproket/Persism.git
        https://github.com/sproket/Persism
    

    
        
            include-test-containers-db
            
                false
            
            
                
                    
                        maven-surefire-plugin
                        3.0.0-M5
                        
                            net.sf.persism.categories.ExternalDB
                        
                    
                
            
        

        
            exclude-test-containers-db
            
                false
            
            
                
                    
                        maven-surefire-plugin
                        3.0.0-M5
                        
                            net.sf.persism.categories.TestContainerDB
                        
                    
                
            
        

        
            release
            
                
                    
                        org.apache.maven.plugins
                        maven-jar-plugin
                        3.2.0
                        
                            
                                
                                    sproket.github.io.persism
                                
                            
                        
                    
                    
                        org.apache.maven.plugins
                        maven-source-plugin
                        3.2.1
                        
                            
                                attach-sources
                                
                                    jar-no-fork
                                
                            
                        
                    
                    
                        org.apache.maven.plugins
                        maven-javadoc-plugin
                        3.2.0
                        
                            
                                attach-javadocs
                                
                                    jar
                                
                                
                                    17
                                
                            
                        
                    
                    
                        org.apache.maven.plugins
                        maven-gpg-plugin
                        3.0.1
                        
                            
                                sign-artifacts
                                verify
                                
                                    sign
                                
                            
                        
                    
                
            
        
    


    
        
            junit
            junit
            4.13.2
            test
        
        
            com.carrotsearch
            junit-benchmarks
            0.7.2
            test
        
        
            org.testcontainers
            testcontainers
            1.15.2
            test
        
        
            ch.qos.logback
            logback-classic
            1.2.7
            provided
        

        
            log4j
            log4j
            1.2.17
            provided
        

        
            org.apache.logging.log4j
            log4j-api
            2.14.1
            provided
        
        
            org.apache.logging.log4j
            log4j-core
            2.14.1
            provided
        


        
            commons-dbcp
            commons-dbcp
            1.4
            test
        

        
            org.firebirdsql.jdbc
            jaybird
            4.0.2.java8
            test
        

        
            org.firebirdsql
            firebird-testcontainers-java
            1.1.0
            test
        

        
            com.h2database
            h2
            1.4.200
            test
        

        
            
            org.hsqldb
            hsqldb
            2.5.1
            test
            
        

        
            org.apache.derby
            derby
            10.8.2.2
            test
        

        
        
            com.microsoft.sqlserver
            mssql-jdbc
            8.4.1.jre8
            test
        

        
            org.testcontainers
            mssqlserver
            1.15.2
            test
        

        
            mysql
            mysql-connector-java
            8.0.23
            test
        

        
            org.testcontainers
            mysql
            1.15.2
            test
        

        
            net.sourceforge.jtds
            jtds
            1.3.1
            test
        

        
            com.oracle.database.jdbc
            ojdbc8
            21.3.0.0
            test
        

        
        
        
        
        
        

        
            org.postgresql
            postgresql
            9.2-1004-jdbc41
            test
        
        
            org.testcontainers
            postgresql
            1.15.2
            test
        

        
            org.xerial
            sqlite-jdbc
            3.34.0
            test
        

        
            net.sf.ucanaccess
            ucanaccess
            5.0.1
            test
        

        
            com.ibm.informix
            informix-jdbc-complete
            4.50.4.1
            test
        

        
            com.toddfast.typeconverter
            typeconverter
            1.0
            test
        

        
            org.reflections
            reflections
            0.9.11
            test
        

        
        
            javax.persistence
            javax.persistence-api
            2.2
            test
        


        
        
        
        
        
        
        
        
        
        
        
        
        
        


    

//omitted code that binds interfaces and classes - this code works and is fully tested. it is not related to problem at hand.
builder.Services.AddIdentity()
.AddDefaultTokenProviders();

builder.Services.AddAuthentication()
.AddCookie(options =>
{
    options.LoginPath = "/signin";
    options.LogoutPath = "/signout";
})
.AddDiscord(options =>
{
    options.ClientId = "some id";
    options.ClientSecret = "some secret";
    options.ClaimActions.MapCustomJson("urn:discord:avatar:url", user =>
        string.Format(
            CultureInfo.InvariantCulture,
            "https://cdn.discordapp.com/avatars/{0}/{1}.{2}",
            user.GetString("id"),
            user.GetString("avatar"),
            user.GetString("avatar")!.StartsWith("a_") ? "gif" : "png"));
});

builder.Services.AddRazorPages();

var app = builder.Build();
app.UseDeveloperExceptionPage();

app.UseHttpsRedirection();
app.UseStaticFiles();

app.UseRouting();
app.UseAuthentication();

app.MapControllerRoute("default", "{controller=Home}/{action=Index}/{id?}");

app.Run();

public class AccountController : Controller
{
    private readonly ISignInService _signInService;
    private readonly IUserService _userService;

    public AccountController(ISignInService signInService, IUserService userService)
    {
        _signInService = signInService;
        _userService = userService;
    }

    [HttpGet("~/signin")]
    public async Task SignIn() => View("SignIn", await HttpContext.GetExternalProvidersAsync());

    [HttpPost("~/signin")]
    public async Task SignIn([FromForm] string provider, string returnUrl)
    {
        if (string.IsNullOrWhiteSpace(provider))
        {
            return BadRequest();
        }

        if (!await HttpContext.IsProviderSupportedAsync(provider))
        {
            return BadRequest();
        }

        var redirectUrl = Url.Action(nameof(LoginCallback), "Account", new { returnUrl });
        var properties = _signInService.ConfigureExternalAuthenticationProperties(provider, redirectUrl, null);
        properties.Items.Add("XsrfKey", "Test");
        
        return Challenge(properties, provider);
    }

    [HttpGet("~/signout")]
    [HttpPost("~/signout")]
    public IActionResult SignOutCurrentUser()
    {
        return SignOut(new AuthenticationProperties {RedirectUri = "/"},
            CookieAuthenticationDefaults.AuthenticationScheme);
    }

    //[HttpGet("~/Account/LoginCallback")]
    [HttpGet]
    public async Task LoginCallback(string returnUrl = null, string remoteError = null)
    {
        if (remoteError != null)
        {
            return RedirectToAction("Index", "Home");
        }
        var info = await _signInService.GetExternalLoginInfoAsync("Test");
        if (info == null)
        {
            return RedirectToAction("Index", "Home");
        }

        var result = await _signInService.ExternalLoginSignInAsync(info.LoginProvider, info.ProviderKey, isPersistent: false, bypassTwoFactor: true);
        if (result.Succeeded)
        {
            return RedirectToLocal(returnUrl);
        }
        if (result.IsLockedOut)
        {
            return RedirectToAction("Index", "Home");
        }
        else
        {
            // If the user does not have an account, then ask the user to create an account.
            ViewData["ReturnUrl"] = returnUrl;
            ViewData["LoginProvider"] = info.LoginProvider;
            var email = info.Principal.FindFirstValue(ClaimTypes.Email);
            return RedirectToAction("Index", "Home");
        }
    }

    private IActionResult RedirectToLocal(string returnUrl)
    {
        if (Url.IsLocalUrl(returnUrl))
        {
            return Redirect(returnUrl);
        }
        else
        {
            return RedirectToAction(nameof(HomeController.Index), "Home");
        }
    }
}

use Doctrine\ORM\Mapping\Entity;
use Doctrine\ORM\Mapping\Column;
use Doctrine\ORM\Mapping\Id;
use Doctrine\ORM\Mapping\OneToMany;
use Doctrine\Common\Collections\ArrayCollection;
use Doctrine\Common\Collections\Collection;

#[Entity()]
class Tenant
{
    #[Id, Column(type: "integer")]
    #[GeneratedValue]
    private ?int $id = null;

    #[OneToMany(targetEntity: Asset::class, mappedBy: 'tenant')]
    private array|Collection|ArrayCollection $assets;

    // Other properties and typical getters and setters
}

use Doctrine\ORM\Mapping\ManyToOne;
use Doctrine\ORM\Mapping\JoinColumn;

abstract class AbstractTenantEntity implements TenantInterface
{
    /**
     * inversedBy performed in child where required
     */
    #[ManyToOne(targetEntity: Tenant::class)]
    #[JoinColumn(nullable: false)]
    protected ?Tenant $tenant = null;

    // Typical getters and setters
}

use Doctrine\ORM\Mapping as ORM;

/**
 * @ORM\Entity()
 * @ORM\AssociationOverrides({
 *     @ORM\AssociationOverride(name="tenant", inversedBy="assets")
 * })
 */
class Asset extends AbstractTenantEntity
{
    // Various properties and typical getters and setters
}

namespace App\Mapping;

use Attribute;
use Doctrine\Common\Annotations\Annotation\NamedArgumentConstructor;
use Doctrine\ORM\Mapping\Annotation;

/**
 * This annotation is used to override association mapping of property for an entity relationship.
 *
 * @Annotation
 * @NamedArgumentConstructor()
 * @Target("ANNOTATION")
 */
#[Attribute(Attribute::TARGET_CLASS | Attribute::IS_REPEATABLE)]
final class AssociationOverride implements Annotation
{
    /**
     * The name of the relationship property whose mapping is being overridden.
     *
     * @var string
     */
    public $name;

    /**
     * The join column that is being mapped to the persistent attribute.
     *
     * @var array<\Doctrine\ORM\Mapping\JoinColumn>
     */
    public $joinColumns;

    /**
     * The join table that maps the relationship.
     *
     * @var \Doctrine\ORM\Mapping\JoinTable
     */
    public $joinTable;

    /**
     * The name of the association-field on the inverse-side.
     *
     * @var string
     */
    public $inversedBy;

    /**
     * The fetching strategy to use for the association.
     *
     * @var string
     * @Enum({"LAZY", "EAGER", "EXTRA_LAZY"})
     */
    public $fetch;

    public function __construct(
        ?string $name = null,
        ?array  $joinColumns = null,
        ?string $joinTable = null,
        ?string $inversedBy = null,
        ?string $fetch = null
    ) {
        $this->name    = $name;
        $this->joinColumns = $joinColumns;
        $this->joinTable = $joinTable;
        $this->inversedBy = $inversedBy;
        $this->fetch = $fetch;
        //$this->debug('__construct',);
    }

    private function debug(string $message, string $file='test.json', ?int $options = null)
    {
        $content = file_exists($file)?json_decode(file_get_contents($file), true):[];
        $content[] = ['message'=>$message, 'object_vars'=>get_object_vars($this), 'debug_backtrace'=>debug_backtrace($options)];
        file_put_contents($file, json_encode($content, JSON_PRETTY_PRINT));
    }
}

import org.junit.jupiter.api.Test;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.autoconfigure.jdbc.AutoConfigureTestDatabase;
import org.springframework.boot.test.autoconfigure.orm.jpa.DataJpaTest;
import org.springframework.test.context.DynamicPropertyRegistry;
import org.springframework.test.context.DynamicPropertySource;
import org.testcontainers.containers.PostgreSQLContainer;
import org.testcontainers.junit.jupiter.Container;
import org.testcontainers.junit.jupiter.Testcontainers;

import static org.assertj.core.api.Assertions.assertThat;

@DataJpaTest
@AutoConfigureTestDatabase(replace = AutoConfigureTestDatabase.Replace.NONE)
@Testcontainers
public class AtleteRepositoryTest {
    @Container
    private static final PostgreSQLContainer CONTAINER = new PostgreSQLContainer<>("postgres:11");

    @DynamicPropertySource
    static void registerProperties(DynamicPropertyRegistry registry) {
        registry.add("spring.datasource.url", CONTAINER::getJdbcUrl);
        registry.add("spring.datasource.username", CONTAINER::getUsername);
        registry.add("spring.datasource.password", CONTAINER::getPassword);
    }

    @Autowired
    private AtleteRepository repository;

    @Test
    void testSave() {
        repository.save(new Atlete("Wout Van Aert", 0, 1, 0));

        assertThat(repository.count()).isEqualTo(1);
    }
}

import org.junit.jupiter.api.extension.AfterAllCallback;
import org.junit.jupiter.api.extension.BeforeAllCallback;
import org.junit.jupiter.api.extension.ExtensionContext;
import org.testcontainers.containers.PostgreSQLContainer;

public class PostgreSQLExtension implements BeforeAllCallback, AfterAllCallback {

    private PostgreSQLContainer postgres;

    @Override
    public void beforeAll(ExtensionContext context) {
        postgres = new PostgreSQLContainer<>("postgres:11");

        postgres.start();
        System.setProperty("spring.datasource.url", postgres.getJdbcUrl());
        System.setProperty("spring.datasource.username", postgres.getUsername());
        System.setProperty("spring.datasource.password", postgres.getPassword());
    }

    @Override
    public void afterAll(ExtensionContext context) {
        postgres.stop();
    }
}

import org.junit.jupiter.api.AfterAll;
import org.junit.jupiter.api.BeforeAll;
import org.springframework.test.context.DynamicPropertyRegistry;
import org.springframework.test.context.DynamicPropertySource;
import org.testcontainers.containers.PostgreSQLContainer;

public class DatabaseBaseTest {
    private static final PostgreSQLContainer CONTAINER = new PostgreSQLContainer<>("postgres:11");

    @BeforeAll
    static void start() {
        CONTAINER.start();
    }

    @AfterAll
    static void stop() {
        CONTAINER.stop();
    }

    @DynamicPropertySource
    static void registerProperties(DynamicPropertyRegistry registry) {
        registry.add("spring.datasource.url", () -> {
            String jdbcUrl = CONTAINER.getJdbcUrl();
            System.out.println("jdbcUrl = " + jdbcUrl);
            return jdbcUrl;
        });
        registry.add("spring.datasource.username", CONTAINER::getUsername);
        registry.add("spring.datasource.password", CONTAINER::getPassword);
    }
}

@DataJpaTest
@AutoConfigureTestDatabase(replace = AutoConfigureTestDatabase.Replace.NONE)
public class AtleteRepositoryTest extends DatabaseBaseTest {

    @DynamicPropertySource
    static void registerProperties(DynamicPropertyRegistry registry) {
        registry.add("spring.datasource.url", () -> {
            String jdbcUrl = CONTAINER.getJdbcUrl();
            System.out.println("jdbcUrl = " + jdbcUrl);
            return jdbcUrl;
        });
        registry.add("spring.datasource.username", CONTAINER::getUsername);
        registry.add("spring.datasource.password", CONTAINER::getPassword);
    }

    @Autowired
    private AtleteRepository repository;

    @Test
    void testSave() {
        repository.save(new Atlete("Wout Van Aert", 0, 1, 0));

        assertThat(repository.count()).isEqualTo(1);
    }
}

from django.db import transaction

entries = Entry.objects.select_for_update().filter(author=request.user)
with transaction.atomic():
    for entry in entries:
        ...

with transaction.atomic():
    Entry.objects.select_for_update().filter(author=request.user).update(foo="bar", wobble="wibble")

declare const user: User;
declare function get1(obj: O, path: AutoPath): void;
declare function get2(obj: O, path: AutoPath[]): void;

// works fine with single item
get1(user, "friend.books.title")
get1(user, "friend.books.ref1.age")
get1(user, "friend.friend.name")
// @ts-expect-error
get1(user, "friend.friend.www")
// @ts-expect-error
get1(user, "friend.books.www")
// @ts-expect-error
get1(user, "friend.books.ref1.www")

// works fine with array when there is just one item
get2(user, ["friend.name"])
get2(user, ["friend.books.ref1.age"])
// @ts-expect-error
get2(user, ["friend.books.ref1.www"])

// if there are more items it works only sometimes
// @ts-expect-error
get2(user, ["friend.name", "books.author.www"])

// if we add one more item that is valid and on the root level, it will make it pass
get2(user, ["friend.name", "books.author.www", "age"])

class Collection { items?: T[] }
class Reference { item?: T }

type Book = {
  id: string,
  title: string,
  author: User,
  ref1: Reference,
}

type User = {
  id: string,
  name: string,
  age: number,
  friend: User,
  friends: Collection,
  books: Collection,
}

type ExtractType = T extends Collection ? U : (T extends Reference ? U : T)
type StringKeys = T extends Collection 
  ? `${Exclude, symbol>}` 
  : T extends Reference
    ? `${Exclude, symbol>}` 
    : `${Exclude}`
type GetStringKey> = K extends keyof T ? ExtractType : never

type AutoPath =
  (P & `${string}.` extends never ? P : P & `${string}.`) extends infer Q
    ? Q extends `${infer A}.${infer B}`
      ? A extends StringKeys
        ? `${A}.${AutoPath, B>}`
        : never
      : Q extends StringKeys
        ? (GetStringKey extends unknown ? Exclude : never) | (StringKeys> extends never ? never : `${Q}.`)
        : StringKeys
    : never