Postgresql 13 random tckn generator

Öncelikle plpython3 ‘ü yüklüyoruz

sudo apt-get install postgresql-contrib postgresql-plpython3-13

CREATE OR REPLACE FUNCTION random_tckn ()
RETURNS TEXT
AS $$
    from random import randint
    tcno = str(randint(100000000, 1000000000))
    list_tc = list(map(int, tcno))
    tc10 = (sum(list_tc[::2]) * 7 - sum(list_tc[1::2])) % 10
    new_tc = tcno + str(tc10) + str((sum(list_tc[:9]) + tc10) % 10)
    return new_tc
$$ LANGUAGE 'plpython3u';

kullanım için

select  random_tckn()

yada

select  random_tckn() FROM generate_series(1,1000)

alıntı: python kod alıntısı: https://canerbasaran.github.io/yazilim/rastgele-tc-kimlik-no-uretici.html