import db

	hostnames []string

	hostname  string

	mut names := []string{}
	names.push(cols[1])

		hostnames: names

		hostname: cols[1]

pub fn network_to_db(ircnet Network) []string {
	mut ircrow := []string{}
	ircrow.push('') // id
	ircrow.push(ircnet.hostnames[0])
	ircrow.push(ircnet.name) // netname

pub fn network_to_db(ircnet Network) []db.SqlValue {
	mut ircrow := []db.SqlValue{}
	ircrow.push(db.SqlValue{name:"hostname", value:db.SqlType(ircnet.hostname)})
	ircrow.push(db.SqlValue{name:"netname", value:db.SqlType(ircnet.name)}) 

	addr := self.hostnames[0]

	addr := self.hostname

		if net.hostnames[0] == ircnet.hostnames[0] {

		if net.hostname == ircnet.hostname {

		if net.name == addr || net.hostnames[0] == addr {

		if net.name == addr || net.hostname == addr {

	host := ircnet.hostnames[0]

	host := ircnet.hostname

	sql_stmt := 'create table irc_servers (id integer primary key, hostname text, netname text)'
	db.exec_one(sql_stmt) or { println('db.sqlite fail $sql_stmt $err') }
	return Db{

	mut dbo := Db{

	dbo.exec('create table irc_servers (id integer primary key, hostname text, netname text)')
	dbo.exec('create table irc_channels (id integer primary key, server_id integer, name text)')
	return dbo
}
pub fn (mut self Db) exec(stmt string) {
	self.sqlite.exec_one(stmt) or { println('db.sqlite fail $stmt $err') }

type SqlType =  int |  string
  
pub struct SqlValue {
  name string
  value SqlType
}
  
pub fn (mut self Db) insert(parts []SqlValue) {
	mut fields := []string{}
	mut values := []string{}
	for part in parts {
	  fields.push(part.name)
	  values.push(part.value.str())
	}
	rows, code := self.sqlite.exec("insert into irc_servers ($fields) values ($values)")
	println('SQL insert $rows $code')
}
	

	println('SQL add_irc_server $rows $code')

	println('SQL del_irc_server $rows $code')

			self.db.add_irc_server(ircrow)

			self.db.insert(irc.network_to_db(ircnet))

				self.db.del_irc_server(ircnet.hostnames[0])

				self.db.del_irc_server(ircnet.hostname)