}
type SqlType = int | string
pub struct SqlValue {
	name  string
	value SqlType

}
type SqlType = int | string
pub struct SqlValue {
	name  string
	value SqlType

pub fn (mut self Db) insert(parts []SqlValue) {

pub fn (mut self Db) insert(table string, parts []SqlValue) {

	stmt := 'insert into irc_servers (${fields.join(',')}) values (${values.join(',')})'

	stmt := 'insert into $table (${fields.join(',')}) values (${values.join(',')})'

	rows, code := self.sqlite.exec('delete from $table where $field= "$value"')
	println('SQL del_irc_server $rows $code')

	self.action_by_field('delete', table, field, value)
}
pub fn (mut self Db) select_by_field(table string, field string, value string) [][]string {
	return self.action_by_field('select', table, field, value)
}
pub fn (mut self Db) action_by_field(action string, table string, field string, value string) [][]string {
	rows := self.exec('$action from $table where $field= "$value"')
	println('SQL del_irc_server $rows')
	return rows

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

			self.db.insert('irc_servers', irc.network_to_db(ircnet))

	sql_stmt := match system {

	existing := match system {

			"select * from irc_channels where name = '$room'"

			self.db.select_by_field('irc_channels', 'name', room)

			"select * from matrix_rooms where room_id = '$room'"

			self.db.select_by_field('matrix_rooms', 'room_id', room)

	println(sql_stmt)
	rows := self.db.exec(sql_stmt)
	if rows.len > 0 {

	if existing.len > 0 {

		stmt := match system {

		match system {

				"insert into irc_channels (server_id, name) values ('$network', '$room')"

				self.db.insert('irc_channels', [db.SqlValue{ name: 'server_id', value: network },
					db.SqlValue{
						name: 'name'
						value: room
					},
				])

				"insert into matrix_rooms (room_id) values ('$room')"

				self.db.insert('matrix_rooms', [db.SqlValue{ name: 'room_id', value: room},
					db.SqlValue{
						name: 'name'
						value: room
					},
				])

		self.db.exec(stmt)

				println("sync_rooms ircnet $ircnet.hostname joining $channel")

				println('sync_rooms ircnet $ircnet.hostname joining $channel')