ΘΕΜΑ: Project : Αποδείξεις - Βάση δεδομένων

CREATE TABLE [apodixis] (
    [arithmos_apod] VARCHAR NOT NULL, 
    [afm] VARCHAR NOT NULL REFERENCES [epixirisis](afm) ON DELETE CASCADE ON UPDATE CASCADE,
    [doy] VARCHAR NOT NULL,
    [typos_agoras] INTEGER NOT NULL,
    [ddate] DATE NOT NULL,
    [poso] REAL(8,2) NOT NULL,
    [aa] INTEGER NOT NULL UNIQUE ON CONFLICT FAIL,
    CONSTRAINT "protevon" PRIMARY KEY([afm], [ddate], [arithmos_apod]),
    FOREIGN KEY ([afm]) REFERENCES [epixirisis]([afm]) ON DELETE CASCADE ON UPDATE CASCADE
);

CONSTRAINT "protevon" PRIMARY KEY ([afm], [ddate], [arithmos_apod])

syndesi = sqlite3.connect(databaseonoma)
    curr = syndesi.cursor()
...
curr.execute("CREATE TABLE [apodixis] ([arithmos_apod] VARCHAR NOT NULL, [afm] VARCHAR NOT NULL\
    REFERENCES [epixirisis](afm) ON DELETE CASCADE ON UPDATE CASCADE, [doy] VARCHAR NOT NULL, \
    [typos_agoras] INTEGER NOT NULL, [ddate] DATE NOT NULL, [poso] REAL(8,2) NOT NULL, [aa] INTEGER NOT NULL UNIQUE ON CONFLICT FAIL, \
    CONSTRAINT \"protevon\" PRIMARY KEY ([afm], [ddate], [arithmos_apod]))")
....

.schema tablename

import sqlite3
db = sqlite3.Connection('/home/kostas/apodixis/src/data/apodixis2.db')
c = db.cursor()
p = c.execute("select sql from sqlite_master where name = ?",
('apodixis',))
for row in p:
    print(row)

CREATE TABLE "Epixeiriseis" (
	id INTEGER, 
	name VARCHAR, 
	owner VARCHAR, 
	afm INTEGER NOT NULL, 
	doy VARCHAR, 
	address VARCHAR, 
	phone INTEGER, 
	PRIMARY KEY (afm))
 
CREATE TABLE "Apodeixeis" (
	id INTEGER, 
	VALUE FLOAT, 
	ddate DATETIME NOT NULL, 
	receipt_id VARCHAR NOT NULL, 
	afm INTEGER NOT NULL, 
	PRIMARY KEY (ddate, receipt_id, afm), 
	FOREIGN KEY(afm) REFERENCES "Epixeiriseis" (afm) ON DELETE CASCADE ON UPDATE CASCADE)

afm = COLUMN(Unicode(9), primary_key=TRUE)