homemade very root database engine

1 files changed, 43 insertions, 10 deletions

diff --git a/w/class/modelart.php b/w/class/modelart.php
index ec68eb4..dfb6476 100644
--- a/w/class/modelart.php
+++ b/w/class/modelart.php
@@ -14,21 +14,52 @@ class Modelart extends Modeldb
 
 
 
-	public function exist($id)
+	public function exist(Art2 $art)
 	{
+		$artdata = $this->artstore->get($art->id());
+		if($artdata === false) {
+			return false;
+		} else {
+			return true;
+		}
+		
+	}
 
-		$req = $this->bdd->prepare(' SELECT COUNT(*) FROM ' . Config::arttable() . ' WHERE id = :id ');
-		$req->execute(array('id' => $id));
-		$donnees = $req->fetch(PDO::FETCH_ASSOC);
 
-		return (bool)$donnees['COUNT(*)'];
+	public function add(Art2 $art)
+	{
+			$this->artstore->insert($art);
+	}
+
+	public function get(Art2 $art)
+	{
+		$artdata = $this->artstore->get($art->id());
+		if($artdata !== false) {
+			$art = new Art2($artdata);
+			return $art;
+		} else {
+			return false;
+		}
 	}
 
+	public function update(Art2 $art)
+	{
+		$art->updateedited();
+		$this->artstore->update($art->id(), $art->dry());
+	}
 
 
+	public function exist3($id)
+	{
 
+		$req = $this->bdd->prepare(' SELECT COUNT(*) FROM ' . Config::arttable() . ' WHERE id = :id ');
+		$req->execute(array('id' => $id));
+		$donnees = $req->fetch(PDO::FETCH_ASSOC);
 
-	public function add(Art2 $art)
+		return (bool)$donnees['COUNT(*)'];
+	}
+
+	public function add3(Art2 $art)
 	{
 
 		if ($this->exist($art->id())) {
@@ -82,7 +113,7 @@ class Modelart extends Modeldb
 		$req->closeCursor();
 	}
 
-	public function get(Art2 $art)
+	public function get3(Art2 $art)
 	{
 
 		$req = $this->bdd->prepare('SELECT * FROM ' . Config::arttable() . ' WHERE id = :id ');
@@ -98,7 +129,7 @@ class Modelart extends Modeldb
 
 
 
-	public function update(Art2 $art)
+	public function update3(Art2 $art)
 	{
 		$now = new DateTimeImmutable(null, timezone_open("Europe/Paris"));
 
@@ -139,7 +170,9 @@ class Modelart extends Modeldb
 	}
 
 
-	public function getlister(array $selection = ['id'], array $opt = [])
+
+
+	public function getlister3(array $selection = ['id'], array $opt = [])
 	{
 		// give an array using SELECTION columns and sort and desc OPTIONS 
 
@@ -162,7 +195,7 @@ class Modelart extends Modeldb
 		}
 	}
 
-	public function getlisterwhere(array $select = ['id'], array $whereid = [], $by = 'id', $order = 'DESC')
+	public function getlisterwhere3(array $select = ['id'], array $whereid = [], $by = 'id', $order = 'DESC')
 	{
 		// give an array using SELECTION columns and sort and desc OPTIONS