using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using MySql.Data.MySqlClient;

namespace Kelsier {
    class Database {
        protected MySqlConnection _dbh = null;
        public MySqlConnection dbh { get { return _dbh; } }


        /// <summary>
        /// Construct a Database, using the MySQL connector string.
        /// </summary>
        /// <param name="dbinfo">Connector string</param>
        public Database(string dbinfo) {
            _dbh = new MySqlConnection(dbinfo);
        }

        public void Connect() {
            try {
                dbh.Open();
            } catch (MySqlException e) {
                Root.log.error("Error: {0}", e.ToString());
            }
        }

        public object queryScalar(string query) {
            MySqlCommand cmdo = new MySqlCommand(query, dbh);
            return cmdo.ExecuteScalar();
        }

        public MySqlDataReader queryReader(string query) {
            MySqlCommand cmdo = new MySqlCommand(query, dbh);
            return cmdo.ExecuteReader();
        }
    }
}