doc-user-database-connection

Registered by starbuck

1. Basic description
================
The goal of this feature is to:
     -create an sql database for the users
     -write qt code for the insertion/deletion/modification of users in the database (query the database from the program)

2. SQL database design
===================
Every machine with an running server has an sql database working in the background, which manages the registered users and the available channels.

See blueprint: 'ddl-script' for more details

3. Implementation
===============
The implementation will be done via qtmysql module.

4. How-to-use
===========
-Create QDatabase object
-Connect to database (call the connect method with the appropiate parameters)
-Use methods (manipulateQuery, selectQuery, queryModel) to access/modify database

5. Changelog
===========
15-03-2010: Switch from odbc to qtmysql module (Note on compiling via odbc for documentation purposes: Install unixodbc and compile: g++ OdbcImpl.cpp -o odbc -lodbc)

Blueprint information

Status:
Complete
Approver:
starbuck
Priority:
Not
Drafter:
starbuck
Direction:
Needs approval
Assignee:
starbuck
Definition:
Approved
Series goal:
None
Implementation:
Informational Informational
Milestone target:
None
Started by
starbuck
Completed by
starbuck

Related branches

Sprints

Whiteboard

01-03-2010:
----------------
*Basic design
*odbc tutorial @ http://www.dreamincode.net/forums/showtopic21309.htm

08-03-2010:
----------------
*odbc tutorial @ http://www.programmingforums.org/thread23855.html
*odbc tutorial @ http://www.unixodbc.org/doc/ProgrammerManual/Tutorial/
*odbc install (debian-based): sudo apt-get install unixodbc unixodbc-dev
*implementation of basic stuff: compile the following way: g++ OdbcImpl.cpp -o odbc -lodbc

12-03-2010:
----------------
*odbc implementation (part 1/x) - result sets, column description

15-03-2010:
----------------
*switch from odbc to QtSql Module (easier implementation)
*basic implementation of qtmysql module

22-03-2010:
----------------
*sqldatabase updates (querys, connect)

20-04-2010:
----------------
*finish up important methods
*debugging, compiling

(?)

Work Items

This blueprint contains Public information 
Everyone can see this information.

Subscribers

No subscribers.