20 lines
683 B
Nim
20 lines
683 B
Nim
|
import db_connector/db_sqlite
|
||
|
|
|
||
|
|
let db = open("data/db.sqlite3","","","")
|
||
|
|
|
||
|
|
db.exec(sql""" CREATE TABLE IF NOT EXISTS flats (
|
||
|
|
adId INTEGER,
|
||
|
|
title STRING,
|
||
|
|
price INTEGER,
|
||
|
|
propertyTypeText STRING,
|
||
|
|
essentialInformation STRING,
|
||
|
|
address STRING,
|
||
|
|
date STRING,
|
||
|
|
image STRING,
|
||
|
|
starred INTEGER,
|
||
|
|
lastChecked REAL)""")
|
||
|
|
|
||
|
|
db.exec(sql"INSERT INTO flats (adID,title,price,propertyTypeText,essentialInformation,address) VALUES(?,?,?,?,?,?)","0921583","SomeTitle",1003,"blablabla","sonstige infos","möchtegernstrasse 1")
|
||
|
|
|
||
|
|
proc [T]addEntry(var
|