public void insert_row(dbrow r)
{
table_entry t = table_mapping [r.table_id];
if (t.insert_statement == null)
{
StringBuilder sb = new StringBuilder("insert into " + t.t.name + "(");
for (int i = 0; i < t.t.fields.Length; i++)
{
if (i != 0)
{
sb.Append(',');
}
sb.Append(t.t.fields [i].name);
}
sb.Append(") values(");
for (int i = 0; i < t.t.fields.Length; i++)
{
if (i != 0)
{
sb.Append(",@param" + i.ToString());
}
else
{
sb.Append("@param" + i.ToString());
}
}
sb.Append(")");
t.insert_statement = sb.ToString();
}
System.Data.SqlClient.SqlCommand c = new System.Data.SqlClient.SqlCommand(t.insert_statement, con);
for (int i = 0; i < r.fields.Length; i++)
{
c.Parameters.Add(r.fields [i]);
}
c.Transaction = trans;
c.ExecuteNonQuery();
}
public static void process_row(dbrow r)
{
s.put_row (r);
}
/*public void write_header()
{
__writeint(version);
}
public void read_header()
{
cur_version=__readint ();
}
unsafe void __writestring (string st)
{
byte[] asdf = System.Text.Encoding.UTF8.GetBytes (st);
if (__tmp_int_buffer == null)
__tmp_int_buffer = new byte[4];
byte[] b = __tmp_int_buffer;
fixed(byte* p=b) {
int* i = (int*)p;
*i = System.Net.IPAddress.HostToNetworkOrder (asdf.Length);
}
s.Write (b, 0, 4);
s.Write (asdf, 0, asdf.Length);
}
unsafe string __readstring ()
{
if (__tmp_int_buffer == null)
__tmp_int_buffer = new byte[4];
byte[] b = __tmp_int_buffer;
s.Read (b, 0, 4);
int l;
fixed(byte* p=b) {
int* i = (int*)p;
l = System.Net.IPAddress.NetworkToHostOrder (*i);
}
byte[] asdf = new byte[l];
int o = 0;
while (o<l) {
int tmp = s.Read (asdf, o, l - o);
if (tmp <= 0)
throw new Exception ("eof encountered");
o += tmp;
}
return System.Text.Encoding.UTF8.GetString (asdf);
}
unsafe void __writeint (int i)
{
if (__tmp_int_buffer == null)
__tmp_int_buffer = new byte[4];
fixed(byte* b=__tmp_int_buffer) {
int* p = (int*)b;
*
p = System.Net.IPAddress.HostToNetworkOrder (i);
}
s.Write (__tmp_int_buffer, 0, 4);
}
int __readint ()
{
if (__tmp_int_buffer == null)
__tmp_int_buffer = new byte[4];
byte[] b = __tmp_int_buffer;
int o = 0;
while (o<b.Length) {
int tmp = s.Read (b, o, b.Length - o);
if (tmp <= 0)
throw new Exception ("eof encountered");
o += tmp;
}
return System.Net.IPAddress.NetworkToHostOrder (System.BitConverter.ToInt32 (b, 0));
}
public void put_table (dbtable t)
{
s.WriteByte ((byte)objtypes.table);
__writeint (t.id);
__writestring (t.name);
__writeint (t.fields.Length);
for (int i=0; i<t.fields.Length; i++) {
__writestring (t.fields [i].name);
__writeint (t.fields[i].len);
}
}
public void write_object(dbfield.types t, object o)
{
switch(t)
{
case dbfield.types.int8:
s.WriteByte ((byte)o);
break;
case dbfield.types.int16:
Int16 i=(Int16)o;
break;
}
}*/
/*public void put_row(dbrow r)
{
s.WriteByte ((byte)objtypes.row);
__writeint (r.table_id);
__writeint (r.fields.Length);
}*/
public void put_row (dbrow r)
{
formatter.Serialize (s, r);
}
public void insert_row (dbrow r)
{
table_entry t = table_mapping [r.table_id];
if (t.insert_statement == null) {
StringBuilder sb = new StringBuilder ("insert into " + t.t.name + "(");
for (int i=0; i<t.t.fields.Length; i++) {
if (i != 0)
sb.Append (',');
sb.Append (t.t.fields [i].name);
}
sb.Append (") values(");
for (int i=0; i<t.t.fields.Length; i++) {
if (i != 0)
sb.Append (",?");
else
sb.Append ('?');
}
sb.Append (")");
t.insert_statement = sb.ToString ();
}
Npgsql.NpgsqlCommand c = new Npgsql.NpgsqlCommand (t.insert_statement, con);
for (int i=0; i<r.fields.Length; i++) {
c.Parameters.Add (r.fields [i]);
}
c.ExecuteNonQuery ();
}
public static void process_row(dbrow r)
{
s.put_row(r);
}
/*public void write_header()
* {
* __writeint(version);
* }
* public void read_header()
* {
* cur_version=__readint ();
* }
* unsafe void __writestring (string st)
* {
* byte[] asdf = System.Text.Encoding.UTF8.GetBytes (st);
* if (__tmp_int_buffer == null)
* __tmp_int_buffer = new byte[4];
* byte[] b = __tmp_int_buffer;
* fixed(byte* p=b) {
* int* i = (int*)p;
* i = System.Net.IPAddress.HostToNetworkOrder (asdf.Length);
* }
* s.Write (b, 0, 4);
* s.Write (asdf, 0, asdf.Length);
* }
* unsafe string __readstring ()
* {
* if (__tmp_int_buffer == null)
* __tmp_int_buffer = new byte[4];
* byte[] b = __tmp_int_buffer;
* s.Read (b, 0, 4);
* int l;
* fixed(byte* p=b) {
* int* i = (int*)p;
* l = System.Net.IPAddress.NetworkToHostOrder (*i);
* }
* byte[] asdf = new byte[l];
* int o = 0;
* while (o<l) {
* int tmp = s.Read (asdf, o, l - o);
* if (tmp <= 0)
* throw new Exception ("eof encountered");
* o += tmp;
* }
* return System.Text.Encoding.UTF8.GetString (asdf);
* }
*
* unsafe void __writeint (int i)
* {
* if (__tmp_int_buffer == null)
* __tmp_int_buffer = new byte[4];
* fixed(byte* b=__tmp_int_buffer) {
* int* p = (int*)b;
*
* p = System.Net.IPAddress.HostToNetworkOrder (i);
* }
* s.Write (__tmp_int_buffer, 0, 4);
* }
*
* int __readint ()
* {
* if (__tmp_int_buffer == null)
* __tmp_int_buffer = new byte[4];
* byte[] b = __tmp_int_buffer;
* int o = 0;
* while (o<b.Length) {
* int tmp = s.Read (b, o, b.Length - o);
* if (tmp <= 0)
* throw new Exception ("eof encountered");
* o += tmp;
* }
* return System.Net.IPAddress.NetworkToHostOrder (System.BitConverter.ToInt32 (b, 0));
* }
*
* public void put_table (dbtable t)
* {
* s.WriteByte ((byte)objtypes.table);
* __writeint (t.id);
* __writestring (t.name);
* __writeint (t.fields.Length);
* for (int i=0; i<t.fields.Length; i++) {
* __writestring (t.fields [i].name);
* __writeint (t.fields[i].len);
* }
* }
* public void write_object(dbfield.types t, object o)
* {
* switch(t)
* {
* case dbfield.types.int8:
* s.WriteByte ((byte)o);
* break;
* case dbfield.types.int16:
* Int16 i=(Int16)o;
*
* break;
* }
* }*/
/*public void put_row(dbrow r)
* {
* s.WriteByte ((byte)objtypes.row);
* __writeint (r.table_id);
* __writeint (r.fields.Length);
* }*/
public void put_row(dbrow r)
{
formatter.Serialize(s, r);
}
