1 files changed, 75 insertions, 0 deletions
diff --git a/utils/constants.go b/utils/constants.go
new file mode 100644
index 0000000..6ec594c
--- /dev/null
+++ b/utils/constants.go
@@ -0,0 +1,75 @@
+package utils
+
+import "nectar/types"
+
+// Form field indices using iota for better readability
+const (
+	FieldConnectionType = iota
+	FieldHost
+	FieldPort
+	FieldSSL
+	FieldUser
+	FieldPassword
+	FieldConnectionName
+	FieldColor
+)
+
+// SQLite-specific field indices (redefine to match the layout)
+const (
+	SQLiteFieldConnectionType = iota // 0: Connection Type
+	SQLiteFieldDatabaseFile          // 1: Database File
+	SQLiteFieldConnectionName        // 2: Connection Name
+	SQLiteFieldColor                 // 3: Color
+)
+
+// Input field indices using iota
+const (
+	InputHost = iota
+	InputPort
+	InputUser
+	InputPassword
+	InputConnectionName
+)
+
+// Database connection defaults
+var (
+	DefaultPorts = map[types.ConnectionType]string{
+		types.PostgreSQL: "5432",
+		types.MySQL:      "3306",
+		types.SQLite:     "",
+	}
+
+	ConnectionTypes = []types.ConnectionType{
+		types.PostgreSQL,
+		types.MySQL,
+		types.SQLite,
+	}
+
+	// Total field counts for each database type
+	FieldCounts = map[types.ConnectionType]int{
+		types.SQLite:     4, // Connection Type, Database File, Connection Name, Color
+		types.PostgreSQL: 8, // Connection Type, Host, Port, SSL, User, Password, Connection Name, Color
+		types.MySQL:      8, // Same as PostgreSQL
+	}
+)
+
+// Field mapping for SQLite (simplified structure)
+var SQLiteFieldMapping = map[int]int{
+	SQLiteFieldConnectionName: InputConnectionName,
+}
+
+// Field mapping for PostgreSQL and MySQL (full structure)
+var NonSQLiteFieldMapping = map[int]int{
+	FieldHost:           InputHost,
+	FieldPort:           InputPort,
+	FieldUser:           InputUser,
+	FieldPassword:       InputPassword,
+	FieldConnectionName: InputConnectionName,
+}
+
+// Complete field mappings for all database types
+var FieldMappings = map[types.ConnectionType]map[int]int{
+	types.SQLite:     SQLiteFieldMapping,
+	types.PostgreSQL: NonSQLiteFieldMapping,
+	types.MySQL:      NonSQLiteFieldMapping,
+}