--- /dev/null
+<?php
+
+class PdoApplianceVersionManager extends AbstractPdoManager {
+
+ public function edit(ApplianceVersion $applianceVersion){
+ if ($applianceVersion->id){
+ $this->update($applianceVersion);
+ return $applianceVersion->id;
+ } else {
+ return $this->create($applianceVersion);
+ }
+ }
+
+ public function update(ApplianceVersion $applianceVersion){
+ $sql = "UPDATE appliance_version SET " .
+ " appliance_id=?,version_id=?,creation_date=?,message=?,is_valider=?,is_valide=?,sugar_id=? " .
+ " WHERE id=? ";
+ $this->query(
+ $sql,
+ $applianceVersion->appliance_id,
+ $applianceVersion->version_id,
+ $applianceVersion->creation_date,
+ $applianceVersion->message,
+ $applianceVersion->is_valider,
+ $applianceVersion->is_valide,
+ $applianceVersion->sugar_id,
+ $applianceVersion->id
+ );
+ }
+
+ public function create(ApplianceVersion $applianceVersion){
+ $sql = "INSERT INTO appliance_version " .
+ " (appliance_id, version_id, creation_date, message, is_valider, is_valide,nature,sugar_id) VALUES ".
+ " (?,?,?,?,?,?,?,?)";
+ $this->query(
+ $sql,
+ $applianceVersion->appliance_id,
+ $applianceVersion->version_id,
+ $applianceVersion->creation_date,
+ $applianceVersion->message,
+ $applianceVersion->is_valider,
+ $applianceVersion->is_valide,
+ $applianceVersion->nature,
+ $applianceVersion->sugar_id
+ );
+ return $this->lastInsertId();
+ }
+
+ /**
+ * @param $appliance_id
+ * @return ApplianceVersion|null
+ */
+ public function getLast($appliance_id){
+ $sql = "SELECT * FROM appliance_version WHERE appliance_id=? ORDER BY creation_date DESC LIMIT 1";
+ $result = $this->queryOne($sql,$appliance_id);
+ return $this->createObjectModel($result);
+ }
+
+ public function getAll($appliance_id){
+ $sql = "SELECT * FROM appliance_version WHERE appliance_id=? ORDER BY creation_date DESC ";
+ $result = array();
+ foreach($this->query($sql,$appliance_id) as $line){
+ $result[] = $this->createObjectModel($line);
+ }
+ return $result;
+ }
+
+ /**
+ * @param $appliance_version_id
+ * @return ApplianceVersion|null
+ */
+ public function get($appliance_version_id){
+ $sql = "SELECT * FROM appliance_version WHERE id=?";
+ $result = $this->queryOne($sql,$appliance_version_id);
+ return $this->createObjectModel($result);
+ }
+
+}
\ No newline at end of file