/// <summary>
/// Creates a table with a prefix and a name, deault columns name_id and name_name
/// </summary>
/// <param name="prefix">Prefix to prepend to the table name (not column names)</param>
/// <param name="name">Table name to create and fill</param>
/// <param name="add_default_columns">Option to add default _id and _name column</param>
/// <param name="auto_fill">Option to auto create/fill table with data</param>
public MySQLDataTable(DsnConnection dsn = null
, string prefix = null
, string name = null
, bool add_default_columns = false
, bool trim_info = false
, bool auto_fill = false
, bool live_update_dsn = false
, string fill_query = null
)
{
this.connection = dsn;
this.live = live_update_dsn;
this.TableName = (name == null)? "" :name;
this.Prefix = (prefix == null) ? "" : prefix;
Init();
if (add_default_columns && name != null)
{
AddDefaultColumns(trim_info);
}
if (auto_fill)
{
if (this.FullTableName != "")
{
DsnSQLUtil.CreateDataTable(connection, this);
}
if (fill_query != null)
{
Fill(fill_query, 0);
}
else
{
Fill();
}
}
}
public RatedGameConfigurator(ScheduleDataSet schedule)
{
this.schedule = schedule;
game_config = new GameConfiguration(schedule);
DsnSQLUtil.CreateDataTable(schedule.schedule_dsn, game_config);
InitializeComponent();
}
/// <summary>
/// Creates a table with the name, a auto increment column name_id, and a name column name_name
/// </summary>
/// <param name="name">Name of the table to create and fill</param>
public MySQLDataTable(string name)
{
this.TableName = name;
Init();
AddDefaultColumns(false);
DsnSQLUtil.CreateDataTable(connection, this);
Fill();
}
/// <summary>
/// Creates a table with a prefix and a name, deault columns name_id and name_name
/// </summary>
/// <param name="prefix">Prefix to prepend to the table name (not column names)</param>
/// <param name="name">Table name to create and fill</param>
public MySQLDataTable(string prefix, string name)
{
this.TableName = name;
this.Prefix = (prefix == null)?"":prefix;
Init();
AddDefaultColumns(false);
DsnSQLUtil.CreateDataTable(connection, this);
Fill();
}
/// <summary>
/// Replaces the current connection with the passed connection, and invokes Fill.
/// </summary>
/// <param name="new_connection"></param>
public void Reconnect(DsnConnection new_connection)
{
connection = new_connection;
this.BeginLoadData();
Clear();
DsnSQLUtil.CreateDataTable(connection, this);
Fill();
this.EndLoadData();
}
public MySQLNameTable(string prefix, string name, DsnConnection dsn)
: base(dsn, prefix, name)
{
DataColumn dc = this.Columns.Add(XDataTable.Name(this), typeof(string));
dc.Unique = true;
DsnSQLUtil.CreateDataTable(connection, this);
Fill();
}
public MySQLNameTable(string prefix, string name, bool trim_info)
: base(null, prefix, name, true, true)
{
DataColumn dc = this.Columns.Add(XDataTable.Name(this), typeof(string));
dc.Unique = true;
DsnSQLUtil.CreateDataTable(connection, this);
Fill();
}
private void button1_Click(object sender, EventArgs e)
{
DsnConnection source = new DsnConnection(textBox1.Text);
DsnConnection dest = new DsnConnection(textBox2.Text);
BingoTracking dataset = new BingoTracking();
DsnSQLUtil.CreateDataTable(dest, dataset);
DsnSQLUtil.FillDataSet(source, dataset);
DsnSQLUtil.AppendToDatabase(dest, dataset);
//DsnSQLUtil.
}
/// <summary>
/// Creates a table with a prefix and a name, deault columns name_id and name_name
/// </summary>
/// <param name="prefix">Prefix to prepend to the table name (not column names)</param>
/// <param name="name">Table name to create and fill</param>
/// <param name="strip_info_on_id">True to remove trailing _info from tablename for id column</param>
public MySQLDataTable(string name, bool auto_fill, bool strip_info_on_id)
{
this.TableName = name;
Init();
AddDefaultColumns(strip_info_on_id);
if (auto_fill)
{
DsnSQLUtil.CreateDataTable(connection, this);
Fill();
}
}
/// <summary>
/// Creates a table with a prefix and a name, deault columns name_id and name_name
/// </summary>
/// <param name="prefix">Prefix to prepend to the table name (not column names)</param>
/// <param name="name">Table name to create and fill</param>
/// <param name="add_default_columns">Option to add default _id and _name column</param>
/// <param name="auto_fill">Option to auto create/fill table with data</param>
public MySQLDataTable(string prefix, string name, bool trim_info, bool auto_fill)
{
this.TableName = name;
this.Prefix = (prefix == null) ? "" : prefix;
Init();
AddDefaultColumns(trim_info);
if (auto_fill)
{
DsnSQLUtil.CreateDataTable(connection, this);
Fill();
}
}
public MySQLNameTable(bool auto_fill, string prefix, string name)
: base(null, prefix, name, true, true)
{
DataColumn dc = this.Columns.Add(NameColumn, typeof(string));
dc.Unique = true;
if (auto_fill)
{
DsnSQLUtil.CreateDataTable(connection, this);
Fill();
}
}
public MySQLDataTable(DsnConnection dsn, DataTable table)
{
// copy table into myself...
connection = dsn;
TableName = table.TableName;
Prefix = table.Prefix;
foreach (DataColumn dc in table.Columns)
{
Columns.Add(dc);
}
DsnSQLUtil.CreateDataTable(connection, this);
}
public MySQLNameTable(DsnConnection dsn, string prefix, string name, bool trim_info, bool auto_fill, bool simple_name)
: base(dsn, prefix, name, true, trim_info, false)
{
// otherwise non-simple will be added by base initilalizer.
if (simple_name)
{
DataColumn dc = this.Columns.Add(simple_name ? "name" : XDataTable.Name(this), typeof(string));
dc.Unique = true;
}
if (auto_fill)
{
DsnSQLUtil.CreateDataTable(connection, this);
Fill();
}
}
/// <summary>
/// Replaces the current connection with the passed connection, and invokes Fill.
/// </summary>
/// <param name="new_connection"></param>
/// <param name="fill">if set, will invoke Fill()</param>
/// <param name="sync">if set, will sync to database (relation table, probably the current relations more accurate</param>
public void Reconnect(DsnConnection new_connection, bool fill, bool sync)
{
connection = new_connection;
DsnSQLUtil.CreateDataTable(connection, this);
if (fill)
{
this.BeginLoadData();
Clear();
Fill();
this.EndLoadData();
}
else if (sync)
{
SyncToDatabase(new_connection);
}
}
public void SetConnection(DsnConnection dsn, bool auto_create)
{
if (connection == null)
{
connection = dsn;
if (dsn != null)
{
if (auto_create)
{
DsnSQLUtil.CreateDataTable(connection, this);
}
}
}
else
{
connection = dsn;
if (auto_create)
{
DsnSQLUtil.CreateDataTable(connection, this);
}
}
}
/// <summary>
/// Just a wrapper for Create() and Fill().
/// </summary>
public void LoadMySQLDataTable()
{
DsnSQLUtil.CreateDataTable(connection, this);
Fill();
}
public static void Store(DsnConnection dsn)
{
DsnSQLUtil.CreateDataTable(dsn, storage);
DsnSQLUtil.CommitChanges(dsn, storage);
}